The op link is borked so I dunno what all the stats were that seem important to most of you. To me, I built a small php page that queries some data from the database to display on a webpage.
http://www.jocoberry.com/eq/
As you can see, it's not a popular
server. The problem with this method is you can only get info from what is in the database.
Here is the source php I use on that page:
To tell if the
server is up or down:
PHP Code:
<?
if (exec("ps -A | grep world") == "")
echo "<img src="./down.jpg"</img>";
else
echo "<img src="./up.jpg"</img>";
fi
?>
Who is
online:
PHP Code:
<?php
echo exec("mysql -H -u **USER** --password=**PASS** -D eqemu -e "select distinct character_.name as Name, long_name as Zone from zone, character_, character_backup where zone.zoneidnumber = character_.zoneid and character_.name = character_backup.name AND ts > current_timestamp() - interval 1 hour ORDER BY ts;"");
?>
Number of accounts (most of these are the folks using that quick connect
button):
PHP Code:
<?php
echo exec("mysql -H -u **USER** --password=**PASS** -D eqemu -e "select count(id) as Accounts from account;"");
?>
Trophy room by resale value:
PHP Code:
<?php
echo exec("mysql -H -u **USER** --password=**PASS** -D eqemu -e "SELECT character_.name AS Name, items.name AS Item FROM character_, inventory, items WHERE account_id != 6 AND itemid = items.id AND charid = character_.id ORDER BY price DESC LIMIT 5;"");
?>
Hope this helps.
Server Status XML
Linear Mode
