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