[release] java stat

[Arabs Emperor]

this is java stat it's good and take from all forums stat

also you should put this

topposter code in phpinclude

if (strpos($_SERVER['PHP_SELF'], 'index.php') != false)
{
$topposters=$DB_site->query_first("SELECT username,posts,userid FROM user ORDER BY posts desc LIMIT 1");
$toptstarter=$DB_site->query_first("SELECT COUNT(*) AS count,postuserid,postusername FROM thread GROUP BY postuserid ORDER BY count DESC LIMIT 1");
}
if (strpos($_SERVER['PHP_SELF'], "index.php") != false)
{
$result = $DB_site->query("SELECT SUM(views) AS totalviews FROM thread");
$totalviews = $DB_site->fetch_array($result);
$totalviews = number_format($totalviews['totalviews']);
}

//
Converted to work with phpinclude by Anime-loo, hack by Lesane
//
Total Thread Views
by filburt1
---------------------------------------
demo :- http://www.freewebz.com/arabse/demo_vbt.htm
backgroun:- images/back1.jpg
you can used this http://www.freewebz.com/arabse/back1.jpg
---------------------------------------
i put the code in Attach
just put it any where in forumhome

my regards

sory for my bad english *_*

[filburt1]

You basically combined the two mods? There's some optimization that can be done (the two FROM thread queries can be combined). Also the second strpos... doesn't need to be there :)

[filburt1]

Almost forgot: please post that PHP code in its own text file to avoid breaking the page layout here :)

[Brad]

Also the second strpos... doesn't need to be there

If anyone dosent know what hes talking about, use this.

if (strpos($_SERVER['PHP_SELF'], 'index.php') != false)
{
$topposters=$DB_site->query_first("SELECT username,posts,userid FROM user ORDER BY posts desc LIMIT 1");
$toptstarter=$DB_site->query_first("SELECT COUNT(*) AS count,postuserid,postusername FROM thread GROUP BY postuserid ORDER BY count DESC LIMIT 1");
//start second mod
$result = $DB_site->query("SELECT SUM(views) AS totalviews FROM thread");
$totalviews = $DB_site->fetch_array($result);
$totalviews = number_format($totalviews['totalviews']);
}

[Brad]

Also, people that wish to release my mods as part of there please pm me about it frist, i really dont mind but i like to know. 99.9% of the time ill always say yes, but check with me frist.

[Arabs Emperor]

oh .................................................. ..!!

[imported_khaledtrm]

very nice

[Arabs Emperor]

thanks khaledtrm *_*

[imported_msu]

great work Arabs Emperor

thanx :)

[Arabs Emperor]

thanks msu

[x-wave]

working. nice job :)