Display forum stats in a dynamic image

[Chris M]

Originally Posted by chatbum

well im guessing its because there is nowhere for you to put your TABLE PREFIX.

your forums must not have one or use the standard one.

Ah yes of course - It's a vB2 hack, no table prefixes

Here's what you change in signature.php:

PHP Code:

$querya="SELECT COUNT(*) AS users, MAX(userid) AS max FROM user WHERE usergroupid!=4"; 


to

PHP Code:

$querya="SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . TABLE_PREFIX . "user WHERE usergroupid!=4"; 


then

PHP Code:

$queryb="SELECT COUNT(*) AS posts FROM post"; 


to

PHP Code:

$queryb="SELECT COUNT(*) AS posts FROM " . TABLE_PREFIX . "post"; 


then

PHP Code:

$queryc="SELECT COUNT(*) AS threads FROM thread"; 


to

PHP Code:

$queryc="SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread"; 


That should be all

Chris