WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė Child· 2008 Lie. 28 11:07:18
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());



?>