Adding Banned Members to Forum Statistics

[Savage Circuits]

I've been pouring through the forums and even used Google bu can't seem to find details of what I want to do. On my website the only banned members are spammers. I wanted to add to the Forum Statistics the number of Spammers Banned by displaying the number of banned members, however there doesn't seem to be a variable for that available. Could anyone point me in the direction of resources showing how I can get that value?

[Savage Circuits]

Does anyone know how this might be accomplished?

[kh99]

You could create a plugin using hook forumhome_complete and this code:

$res = $vbulletin->db->query_first("SELECT COUNT(*) AS numberbanned FROM user WHERE usergroupid = 8");

$numberbanned = vb_number_format($res['numberbanned']);
vB_Template::preRegister('FORUMHOME', array('numberbanned' => $numberbanned));

and then in the FORUMHOME template use {vb:raw numberbanned}.

This does add one query to that page. You could eliminate that by calculating it once every so often and putting it in the datastore, but I think that would require editing forum.php to add it to the $specialtemplates array (unless someone else knows a way around that).

[Savage Circuits]

Kevin, I appreciate your reply...could you please point me to a resource that describes adding a hook to the forumhome_complete?

I have made many modifications to my website templates, usually by seeing how othershad done it. I have created custom user fields and included those into custom pages, such as an achievement system on my site, however some things in this PHP code still remain a mystery to me.

I appreciate your help!

[kh99]

Originally Posted by Savage Circuits

Kevin, I appreciate your reply...could you please point me to a resource that describes adding a hook to the forumhome_complete?

Here's a link to the manual that describes the product/plugin system: https://www.vbulletin.com/docs/html/plugin_system . If you're not interested in reading it all then click on "Plugin Manager" then "Add a new plugin".

forumhome_complete is what you want to select from the hook location dropdown menu, and you can paste the code from above in the large text area. Enter a title so that later you'll remember what this does, then click the "Yes" radio button at the bottom to activate the plugin. Now you can click the save button and the plugin will be active.

[Savage Circuits]

Kevin, thanks again for your help. I am looking at implementing this once the patches slow down a bit. Each patch it seems I have to redo all my mods.