Stats In Header

[Marco van Herwaarden]

Was this a reply to someones question? This is a very old thread, and the changes you suggest add more queries then needed to the page.

Originally Posted by Almotmaiz.Net

heloo FREIND ,

Step 1 : open : global.php
Step 2 : Find line 491)

eval('$header = "' . fetch_template('header') . '";');

Step 3 :Repalce with :

$mem=$DB_site->query_first("SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user");
 
$thr=$DB_site->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread");
 
$post=$DB_site->query_first("SELECT COUNT(*) AS posts FROM " . TABLE_PREFIX . "post");
 
$line=$DB_site->query_first("SELECT COUNT(*) AS ond FROM " . TABLE_PREFIX . "session");
 
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM " . TABLE_PREFIX . "user order by userid DESC limit 1");
 
$newusername=$getnewestusers['username'];
 
$newuserid=$getnewestusers['userid'];
 
eval('$header = "' . fetch_template('header') . '";');

Step 4:
threads : $thr[threads]
Posts : $post[posts]
members : $mem[users]
new member : $newusername
finish