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.
Threaded Mode
