vBulletin CMS Widgets - [WIDGET] Forum Stats

This is a simple widget to display some forum stats.

It would really like to see this combined with the Currently Online and Site Visitor's Widgets...

But until then, I am using this PHP Widget...

Feel free to use/hack/slash the code for your own needs...

Navigate to AdminCP -> CMS -> Widgets.
Create a PHP Type Widget and paste the below code.

PHP Code:

ob_start();
global $vbulletin, $db, $vbphrase;
//Begin Forum Stats
// forum stats start
$numbersmembers = $db->query_first("SELECT COUNT(*) AS users,MAX(userid) AS max FROM " . TABLE_PREFIX . "user");
$numbermembers = number_format($numbersmembers['users']);
$counter = $db->query_first("SELECT COUNT(postid) AS posts, COUNT(threadid) AS threads FROM " . TABLE_PREFIX . "post");
$totalposts=number_format($counter['posts']);
$countthreads = $db->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread");
$totalthreads=number_format($countthreads['threads']);
// forum stats end

// total online start
$datecut = TIMENOW - $vbulletin->options['cookietimeout'];
$headerguests=$db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "session WHERE userid=0 AND lastactivity>$datecut");
$headerusers=$db->query_first("SELECT COUNT(DISTINCT(userid)) AS count FROM " . TABLE_PREFIX . "session WHERE " . TABLE_PREFIX . "session.userid>0 AND " . TABLE_PREFIX . "session.lastactivity>$datecut");
$headerguests=$headerguests[count];
$headerusers=$headerusers[count];
$totalonline=$headerguests+$headerusers;
// total online end

// get newest member name and userid start
$getnewestmember=$db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid=$numbersmembers[max]");
$newusername = $getnewestmember['username'];
$newuserid = $getnewestmember['userid'];
// get newest member name and userid end

 //End Forum Status
//SideBar - Begin forum Stats
$sb_stats='
<table width="100%" align="center"> <tr> <td class="" align="left"> <div class="smallfont"> <strong>Number of Members: </strong> '.$numbermembers.'<br /> <strong>Total Threads: </strong>'. $totalthreads.'<br /> <strong>Total Posts: </strong>'. $totalposts.'<br /> <strong>Currently Online: </strong>'. $totalonline.'<br /> <br /> <strong>Newest Member:</strong> <a href="'.$vboptions[bburl].'/member.php?u='.$newuserid.'"><b>'.$newusername.'</b></a> </td> </tr> </table>';
//SideBar = End forum Status
echo $sb_stats;
$output=ob_get_contents();
ob_end_clean(); 


[COL NIL SATIS]

Originally Posted by zulfiqar.halari

This widget is not working in my Forum as i am not using CMS, rather i want to use it in side bar of my vBulletin forum but its not working and showing as blank.

Let me know whats the correct code to display it in our forum widget side bar.

Regards

any ideas guys ...will this work in the side blocks???

[goshalim]

Originally Posted by axix20xx

Same Here for this and Recent Thread az so ...



So how can we fix It ?

Ok Guys i found it how it works !!!!

Go to tha admin panel and open the widgets section
Then find the widget which you creat and then press configure.

Then delete what is in the box and copy again the PHP code.

press Ok and thats it !!!!

[goshalim]

Originally Posted by Brew

All I get is today's date

Ok Guys i found it how it works !!!!

Go to tha admin panel and open the widgets section
Then find the widget which you creat and then press configure.

Then delete what is in the box and copy again the PHP code.

press Ok and thats it !!!!

[soul86]

So nice man . Thank you

[RedHacker]

I have 4.1.0 Version and when login show all number of members. When refresh the page at the members stats missing three members. Why....?

[chriske]

They are probaply in the usergroup: users awaiting email confirmation.

[LuucEarth]

Thank you very much.

Ive used this with some slight modifications to add the ability to track Active(posted in forums in the last 2 weeks) members of the armies in our tournaments.

[ehsanix]

If I want
The destination would be on our website indexes on a blank page php
What do I do?

[traen]

Thanks worked like a charm on 4.1.1.

[fidelTFG]

How do I get rid of the php logo on the template?