function get_stats()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
//////////////// posts \\\\\\\\\\\\\\\\\\\\
function currentposts()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$postcount = "SELECT * FROM posts";
$postcount1 = $db->query($postcount);
$posts = $db->numRows($postcount1);
if (!isset($posts)) {
$posts = '0';
}
echo 'Posts: <B>';
echo $posts;
echo '</B>';
}
//////////////// Last post \\\\\\\\\\\\\\\\\\\\
function latestpost()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$latestpost = "SELECT * FROM posts ORDER BY postid DESC LIMIT 1";
$latest = $db->query($latestpost);
$postinfo = $db->fetchArray($latest);
if ($postinfo[parentpost] < 1) {
echo 'Latest Post: <a href=';
echo $stcfg[RootDir];
echo '/?action=message&forum=';
echo $postinfo[forumname];
echo '&postid=';
echo $postinfo[postid];
echo '>';
echo $postinfo[title];
echo '</a>';
}
if ($postinfo[parentpost] > 0) {
echo 'Latest Post: <a href=';
echo $stcfg[RootDir];
echo '/?action=message&forum=';
echo $postinfo[forumname];
echo '&postid=';
echo $postinfo[parentpost];
echo '>';
echo $postinfo[title];
echo '</a>';
}
}
//////////////// count members \\\\\\\\\\\\\\\\\\\\
function currentmembers()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$membercount = "SELECT * FROM memberships";
$membercount1 = $db->query($membercount);
$members = $db->numRows($membercount1);
if (!isset($members)) {
$members = '0';
}
echo 'Members: <B>';
echo $members;
echo '</B>';
}
//////////////// count members \\\\\\\\\\\\\\\\\\\\
function currentproducts()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$membercount = "SELECT * FROM products";
$membercount1 = $db->query($membercount);
$members = $db->numRows($membercount1);
if (!isset($members)) {
$members = '0';
}
echo 'Products: <B>';
echo $members;
echo '</B>';
}
//////////////// Last member \\\\\\\\\\\\\\\\\\\\
function latestproduct()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$latestmember = "SELECT * FROM products ORDER BY id DESC LIMIT 1";
$latest = $db->query($latestmember);
$memberinfo = $db->fetchArray($result);
echo 'Latest Product: ';
echo ' <a href=./?action=products&cat=' . $memberinfo['category'] . '&product=' . $memberinfo['id'] . '>';
echo $memberinfo[product_name];
echo '</a>';
}
//////////////// count members \\\\\\\\\\\\\\\\\\\\
function currentcharacters()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$charactercount = "SELECT * FROM Bios";
$charactercount1 = $db->query($charactercount);
$characters = $db->numRows($charactercount1);
if (!isset($characters)) {
$characters = '0';
}
echo 'Total Characters: <B>';
echo $characters;
echo '</B>';
}
//////////////// Last member \\\\\\\\\\\\\\\\\\\\
function latestmember()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$latestmember = "SELECT * FROM memberships ORDER BY userid DESC LIMIT 1";
$latest = $db->query($latestmember);
$memberinfo = $db->fetchArray($result);
echo 'Latest Member: ';
echo ' <a href=' . $stcfg[RootDir] . '/?action=userprofile&userid=' . $memberinfo['username'] . '>';
echo $memberinfo[username];
echo '</a>';
}
//////////////// Members online \\\\\\\\\\\\\\\\\\\\
function getusernames()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$query = "SELECT * FROM activeusers WHERE name != 'GUEST' ORDER BY lastaction";
$result = $db->query($query);
$num_results = $db->numRows($result);
for ($i = 0; $i < $num_results; $i++) {
$row = $db->fetchArray($result);
echo '<a href=' . $stcfg[RootDir] . '/?action=userprofile&userid=' . $row['name'] . '>';
echo $row[name];
echo '</a> ';
}
}
//////////////// guests online \\\\\\\\\\\\\\\\\\\\
function guestcount()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$guestcount = "SELECT * FROM activeusers WHERE name = 'GUEST' ORDER BY lastaction";
$guestcount1 = $db->query($guestcount);
$guests = $db->numRows($guestcount1);
if (!isset($guests)) {
$guests = '0';
}
echo 'Guests Online: <B>';
echo $guests;
echo '</B>';
}
function roomcount()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$roomcount = "SELECT * FROM roomcfg";
$roomcount1 = $db->query($roomcount);
$rooms = $db->numRows($roomcount1);
if (!isset($rooms)) {
$rooms = '0';
}
echo 'Chat Rooms:<B>';
echo $rooms;
echo '</B>';
}
function total_count()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$query = "SELECT * FROM room_online";
$result = $db->query($query);
$num_results = $db->numRows($result);
if ($num_results == '0') {
$users = '0';
} else {
$users = $num_results;
}
echo 'Users Chatting: <B>';
echo $users;
echo '</B>';
}
function lscount()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$lscount = "SELECT * FROM login_accounts";
$lscount1 = $db->query($lscount);
$ls = $db->numRows($lscount1);
if (!isset($ls)) {
$ls = '0';
}
echo 'LS Accounts:<B>';
echo $ls;
echo '</B>';
}
function tooncount()
{
include_once "db.inc.php";
$db = new DB();
$db->open();
$tooncount = "SELECT * FROM character_";
$tooncount1 = $db->query($tooncount);
$toons = $db->numRows($tooncountt1);
if (!isset($toons)) {
$toons = '0';
}
echo 'Eqemu Characters:<B>';
echo $toons;
echo '</B>';
}
//////////////// output \\\\\\\\\\\\\\\\\\\\
// echo '<b>Member Stats:</b><br>';
// currentmembers();
// echo '<BR>';
// latestmember();
echo '<b>Products:</b><br>';
currentproducts();
echo '<BR>';
latestproduct();
echo '<hr>';
echo '<b>Forum Stats:</b><br>';
currentposts();
echo '<BR>';
latestpost();
// echo '<hr><b>Chat Stats:</b><br>';
// total_count();
// echo '<BR>';
// roomcount();
// echo '<br>';
// currentcharacters();
// if($sitetype = 'EQEMU'){
// echo '<hr>';
// echo 'EQEmu Server Stats';
// echo '<BR>';
// lscount();
// echo '<br>';
// tooncount();
//}
// echo '<hr><b>Users Online:</b><br>';
// guestcount();
// echo '<BR> Members online:';
// getusernames();
// echo '<table width=100%><tr>';
// echo '<td valign=top align=center>';
// echo '<b>Member Stats:</b><br>';
// currentmembers();
// echo '<Br>';
// latestmember();
// echo '</td>';
// echo '<td valign=top align=center>';
// echo '<b>Forum Stats:</b><br>';
// currentposts();
// echo '<BR>';
// latestpost();
// echo '</td>';
// echo '<td valign=top align=center>';
// echo '<b>Chat Stats:</b><br>';
// total_count();
// // echo '<BR>';
// // roomcount();
// echo '<BR>';
// currentcharacters();
// echo '</td>';
// echo '</tr>';
// echo '</table>';
}
google_ad_client = "pub-7526690253327491"; /* 200x200, created 11/26/08 */ google_ad_slot = "0501741132"; google_ad_width = 200; google_ad_height = 200; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <h5>Latest Posts</h5> <div class="box"> <div class="content"> <ul> <?php latestpost(); ?> </ul> </div> </div> <h5>Latest Members</h5> <div class="box"> <div class="content"> <ul> <?php latestuser(); ?> </ul> </div> </div> <h5>Useful Links</h5>
