Display forum stats in a dynamic image

[Mr Chad]

any help?

[Chris M]

Well all I can say in my defence is that it worked for me when I tested it

I don't know why you are getting these errors...

Chris

[Mr Chad]

Originally Posted by Chris M

Well all I can say in my defence is that it worked for me when I tested it

I don't know why you are getting these errors...

Chris

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.

[Dark Riku]

You must edit this code so it has your directory

/home/username/public_html/directory

It must be like that i beleive. Did you edit the code at all?

[Mr Chad]

yes its right...
/kunden/homepages/18/d117741316/htdocs/forums

[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

[Mr Chad]

ohh man i learned something too!

cant thank you enough

This is how i fixed it:
I followed what you said but that worked halfway

I added a line under the email var

$TABLE_PREFIX= "table prefix";

and replaced all the "TABLE_PREFIX" with $TABLE_PREFIX

[Chris M]

It's probably all the bad mysql_query's in there using double quotes and stuff - Not the greatest of code but functional

Chris