Server status (accounts,items,guilds,players)

[DexterSK]

PHP Code:

<?PHP
$result=mysql_query("SELECT count(*) as accounts from account.account");
$data=mysql_fetch_assoc($result);

$result1=mysql_query("SELECT count(*) as players from player.player");
$data1=mysql_fetch_assoc($result1);

$result2=mysql_query("SELECT count(*) as guilds from player.guild");
$data2=mysql_fetch_assoc($result2);

$result3=mysql_query("SELECT count(*) as items from player.item");
$data3=mysql_fetch_assoc($result3);

echo'Accounts: '.$data['accounts'].'<br>';
echo'Players: '.$data1['players'].'<br>';
echo'Guilds: '.$data2['guilds'].'<br>';
echo'Items: '.$data3['items'].'<br>';

?>

[.Shōgun]

Are you serious?

[oOPhillOo]

Are you serious?

behindert? Virus und so? XDD
Naja das PHPScript ist eigtl "ein bissel" unnötig, da es schon so viele von denen gibt

[DexterSK]

Originally Posted by Uncorrupted

Are you serious?

:-D

[IgorGlock]

-.-' Kleine Release...
Hättest ja sagen können das der nur Anzahl der Einträge ausgibt.

[TraxWall]

<?PHP
$result=mysql_query("SELECT count(id) as accounts from account.account");
$data=mysql_fetch_assoc($result);

$result1=mysql_query("SELECT count(id) as players from player.player");
$data1=mysql_fetch_assoc($result1);

$result2=mysql_query("SELECT count(id) as guilds from player.guild");
$data2=mysql_fetch_assoc($result2);

$result3=mysql_query("SELECT count(id) as items from player.item");
$data3=mysql_fetch_assoc($result3);

echo'Accounts: '.$data['accounts'].'<br>';
echo'Players: '.$data1['players'].'<br>';
echo'Guilds: '.$data2['guilds'].'<br>';
echo'Items: '.$data3['items'].'<br>';

?>
Thus, less strain on the database.
and fewer things can be queried to

[IgorGlock]

-.-' Datenbank Killer ist das aber schon. Würde nicht empfehlen auf die Startseite zu stellen.
Für Admins vll. nur :P

[DexterSK]

I have pvp system release ?

// S F M B E