Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: biski neveikia

Parašė Child· 2008 Lie. 28 11:07:18
#1
http://viva-l2.xz.lt/l2jstatus.php
cia uzejus meta errora

Stai kodas,padekit kas nors

?>php

#Login Server
$serverLip="84.32.157.47";
$serverLport="2106";

#GameServer
$serverGip="84.32.157.47";
$serverGPort="7777";

#Database Host
$databaseHost="xxxxxxxx";
$databaseLogin="xxxx";
$databasePassword="xxxx";
$databaseName="xxxx";


?>

<?php

#Login
$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin )
    $lstat = "<font color=#00FF00>ONLINE</font>";
else
    $lstat = "<font color=#FF0000>OFFLINE</font>";
 

#Sieghardt
$fgame2 = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame2 )
    $gstat2 = "<font color=#00FF00>ONLINE</font>";
else
    $gstat2 = "<font color=#FF0000>OFFLINE</font>";


mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());

mysql_select_db($databaseName) or die(mysql_error()); 

//online kari
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel=0");

$result = mysql_query($query) or die(mysql_error());

$num2=mysql_numrows($result);
$sum=$sum+$num2;

//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");

$result = mysql_query($query) or die(mysql_error());

$alliance2=mysql_numrows($result);

//all characters

$query = ("SELECT * FROM characters WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$char2=mysql_numrows($result);

//all GM characters

$query = ("SELECT * FROM characters Where accesslevel > 99");

$result = mysql_query($query) or die(mysql_error());

$gmchar2=mysql_numrows($result);

//all accounts

$query = ("SELECT * FROM accounts WHERE access_level>=0");

$result = mysql_query($query) or die(mysql_error());

$accounts2=mysql_numrows($result);

//Clan

   
$get_config_data="SELECT clan_id FROM clan_data";

$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");

$result = mysql_query($query) or die(mysql_error());

$clan2=mysql_numrows($result);

//GM
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel>100 AND online=1");
while ($gmtitle2 = mysql_fetch_array ($quary)) {
    $gmname2 = $gmtitle2["char_name"];
}



//Titan
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel=75 AND online=1");
while ($titantitle2 = mysql_fetch_array ($quary)) {
    $titanname2 = $titantitle2["char_name"];
}


mysql_close();
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die(mysql_error());

mysql_select_db($databaseName) or die(mysql_error());

?>



Parašė MAnjack· 2008 Lie. 28 11:07:03
#2
?>php

Keisk į:

<?php

Parašė Child· 2008 Lie. 28 11:07:44
#3
visus?

Parašė mXt· 2008 Lie. 28 11:07:10
#4
As tai tik viena matau :D Sakyk tiesiai, ka rukei?

Parašė Child· 2008 Lie. 28 11:07:01
#5
pigius vitaminus ;)

Parašė RuP3r· 2008 Lie. 28 11:07:03
#6
<?php

#Login Server
$serverLip="84.32.157.47";
$serverLport="2106";

#GameServer
$serverGip="84.32.157.47";
$serverGPort="7777";

#Database Host
$databaseHost="xxxxxxxx";
$databaseLogin="xxxx";
$databasePassword="xxxx";
$databaseName="xxxx";


?>

<?php

#Login
$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin )
    $lstat = "<font color=#00FF00>ONLINE</font>";
else
    $lstat = "<font color=#FF0000>OFFLINE</font>";
 

#Sieghardt
$fgame2 = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame2 )
    $gstat2 = "<font color=#00FF00>ONLINE</font>";
else
    $gstat2 = "<font color=#FF0000>OFFLINE</font>";


mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());

mysql_select_db($databaseName) or die(mysql_error()); 

//online kari
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel=0");

$result = mysql_query($query) or die(mysql_error());

$num2=mysql_numrows($result);
$sum=$sum+$num2;

//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");

$result = mysql_query($query) or die(mysql_error());

$alliance2=mysql_numrows($result);

//all characters

$query = ("SELECT * FROM characters WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$char2=mysql_numrows($result);

//all GM characters

$query = ("SELECT * FROM characters Where accesslevel > 99");

$result = mysql_query($query) or die(mysql_error());

$gmchar2=mysql_numrows($result);

//all accounts

$query = ("SELECT * FROM accounts WHERE access_level>=0");

$result = mysql_query($query) or die(mysql_error());

$accounts2=mysql_numrows($result);

//Clan

   
$get_config_data="SELECT clan_id FROM clan_data";

$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");

$result = mysql_query($query) or die(mysql_error());

$clan2=mysql_numrows($result);

//GM
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel>100 AND online=1");
while ($gmtitle2 = mysql_fetch_array ($quary)) {
    $gmname2 = $gmtitle2["char_name"];
}



//Titan
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel=75 AND online=1");
while ($titantitle2 = mysql_fetch_array ($quary)) {
    $titanname2 = $titantitle2["char_name"];
}


mysql_close();
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die(mysql_error());

mysql_select_db($databaseName) or die(mysql_error());

?>



Parašė Fanio· 2008 Lie. 28 11:07:47
#7
Vaje vaje, nejaugi tiek nesimato..

<?php

#Login Server
$serverLip="84.32.157.47";
$serverLport="2106";

#GameServer
$serverGip="84.32.157.47";
$serverGPort="7777";

#Database Host
$databaseHost="xxxxxxxx";
$databaseLogin="xxxx";
$databasePassword="xxxx";
$databaseName="xxxx";


?>

<?php

#Login
$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin )
    $lstat = "<font color=#00FF00>ONLINE</font>";
else
    $lstat = "<font color=#FF0000>OFFLINE</font>";
 

#Sieghardt
$fgame2 = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame2 )
    $gstat2 = "<font color=#00FF00>ONLINE</font>";
else
    $gstat2 = "<font color=#FF0000>OFFLINE</font>";


mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());

mysql_select_db($databaseName) or die(mysql_error());

//online kari
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel=0");

$result = mysql_query($query) or die(mysql_error());

$num2=mysql_numrows($result);
$sum=$sum+$num2;

//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");

$result = mysql_query($query) or die(mysql_error());

$alliance2=mysql_numrows($result);

//all characters

$query = ("SELECT * FROM characters WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$char2=mysql_numrows($result);

//all GM characters

$query = ("SELECT * FROM characters Where accesslevel > 99");

$result = mysql_query($query) or die(mysql_error());

$gmchar2=mysql_numrows($result);

//all accounts

$query = ("SELECT * FROM accounts WHERE access_level>=0");

$result = mysql_query($query) or die(mysql_error());

$accounts2=mysql_numrows($result);

//Clan

   
$get_config_data="SELECT clan_id FROM clan_data";

$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");

$result = mysql_query($query) or die(mysql_error());

$clan2=mysql_numrows($result);

//GM
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel>100 AND online=1");
while ($gmtitle2 = mysql_fetch_array ($quary)) {
    $gmname2 = $gmtitle2["char_name"];
}



//Titan
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel=75 AND online=1");
while ($titantitle2 = mysql_fetch_array ($quary)) {
    $titanname2 = $titantitle2["char_name"];
}


mysql_close();
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die(mysql_error());

mysql_select_db($databaseName) or die(mysql_error());
?>


Redagavo Fanio· 2008 Lie. 28 11:07:34

Parašė mXt· 2008 Lie. 28 11:07:18
#8
ir abu smailus palikot :D

Parašė Child· 2008 Lie. 28 11:07:19
#9
na dabar dar kitoki errora meta

Parašė mXt· 2008 Lie. 28 11:07:27
#10
<?php

#Login Server
$serverLip="84.32.157.47";
$serverLport="2106";

#GameServer
$serverGip="84.32.157.47";
$serverGPort="7777";

#Database Host
$databaseHost="xxxxxxxx";
$databaseLogin="xxxx";
$databasePassword="xxxx";
$databaseName="xxxx";


?>

<?php

#Login
$flogin = @fsockopen ($serverLip,$serverLport, $errno, $errstr, 1);
if ( $flogin )
    $lstat = "<font color=#00FF00>ONLINE</font>";
else
    $lstat = "<font color=#FF0000>OFFLINE</font>";
 

#Sieghardt
$fgame2 = @fsockopen ($serverGip,$serverGPort, $errno, $errstr, 1);
if ( $fgame2 )
    $gstat2 = "<font color=#00FF00>ONLINE</font>";
else
    $gstat2 = "<font color=#FF0000>OFFLINE</font>";


mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die (mysql_error());

mysql_select_db($databaseName) or die(mysql_error());

//online kari
$query = ("SELECT * FROM characters WHERE online=1 and accesslevel=0");

$result = mysql_query($query) or die(mysql_error());

$num2=mysql_numrows($result);
$sum=$sum+$num2;

//Alliance
$query = ("SELECT * FROM clan_data WHERE ally_name!=\"\"");

$result = mysql_query($query) or die(mysql_error());

$alliance2=mysql_numrows($result);

//all characters

$query = ("SELECT * FROM characters WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$char2=mysql_numrows($result);

//all GM characters

$query = ("SELECT * FROM characters Where accesslevel > 99");

$result = mysql_query($query) or die(mysql_error());

$gmchar2=mysql_numrows($result);

//all accounts

$query = ("SELECT * FROM accounts WHERE access_level>=0");

$result = mysql_query($query) or die(mysql_error());

$accounts2=mysql_numrows($result);

//Clan

   
$get_config_data="SELECT clan_id FROM clan_data";

$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");

$result = mysql_query($query) or die(mysql_error());

$clan2=mysql_numrows($result);

//GM
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel>100 AND online=1");
while ($gmtitle2 = mysql_fetch_array ($quary)) {
    $gmname2 = $gmtitle2["char_name"];
}



//Titan
$quary = mysql_query ("SELECT char_name FROM characters WHERE accesslevel=75 AND online=1");
while ($titantitle2 = mysql_fetch_array ($quary)) {
    $titanname2 = $titantitle2["char_name"];
}


mysql_close();
mysql_connect($databaseHost,$databaseLogin,$databasePassword) or die(mysql_error());

mysql_select_db($databaseName) or die(mysql_error());
?>



Parašė Fanio· 2008 Lie. 28 11:07:07
#11
lovefiefka parašė:
na dabar dar kitoki errora meta


Naudok kur pataisiau dabar ir nemes :D

Parašė Child· 2008 Lie. 28 11:07:13
#12
zmones vistiek neveikia http://viva-l2.xz.lt/l2jstatus.php

Parašė MAnjack· 2008 Lie. 28 11:07:39
#13
Taigi sql lentelė nesukurta, o čia jau mes niekuo nepadėsim, nes nežinom struktūros.

Parašė Child· 2008 Lie. 28 11:07:17
#14
kokios strukturos reikia sakyk gal pasakysiu padesit tada
as noriu kad rodytu kiek zaideju siuo metu losia ,kiek serve prisijungusiu ir pns
Redagavo Child· 2008 Lie. 28 11:07:04

Parašė Žmogus· 2008 Lie. 28 11:07:53
#15
Iš kur tu šita gavai?

Parašė Poker· 2008 Lie. 28 11:07:24
#16
Visu pirma tu turi imti viska ne ish kokio savo db,o ish serverio db...ten yra lentele characters .

Parašė Child· 2008 Lie. 28 12:07:02
#17
paziurekit db ka ten meta:[

Parašė Poker· 2008 Lie. 28 12:07:23
#18
Ir nesupranti kodel? :s

Parašė Child· 2008 Lie. 28 12:07:49
#19
nea
:[:(

Parašė MAnjack· 2008 Lie. 28 12:07:57
#20
Prisijungimas blogas. Mokinkis saito kūrimo poagrindų.

Parašė Child· 2008 Lie. 28 12:07:43
#21
man cia reikia ne saio o servo

Warkion jei zinai kas yra tai pasakyk
Redagavo Child· 2008 Lie. 28 12:07:04

Parašė Child· 2008 Lie. 28 12:07:10
#22
padesi?