Display forum stats in a dynamic image

[Mr Chad]

Display forum stats in a dynamic image, this was done in all the other versions but in 3.5 things changed and i cant find a working method of doing this.

Come on guys...

[kafi]

Display forum stats in a dynamic image, this was done in all the other versions but in 3.5 things changed and i cant find a working method of doing this.

Come on guys...

would love it

[Mr Chad]

would love it

yep... I requested this months ago but no one seems to want to make it, it is a well needed mod.

[Chris M]

As I told you previously I got it to work with little effort...

If I get time I will post the updated file here, but I'm sure you can figure out what to change yourself...

Upon looking at the code I cannot see any reason why it will not work if you fill in the database information correctly :)

And in case you are wondering what hack I am referring to, it is: https://vborg.vbsupport.ru/showthread.php?t=50848&highlight=signature.php

Chris

[Mr Chad]

As I told you previously I got it to work with little effort...

If I get time I will post the updated file here, but I'm sure you can figure out what to change yourself...

Upon looking at the code I cannot see any reason why it will not work if you fill in the database information correctly :)

And in case you are wondering what hack I am referring to, it is: https://vborg.vbsupport.ru/showthread.php?t=50848&highlight=signature.php

Chris

I would greatly appriciate it if you post the updated file here.

[Mr Chad]

I would greatly appriciate it if you post the updated file here.

please!

[Mr Chad]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in signature.php on line 54

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in signature.php on line 56

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in signature.php on line 61

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in signature.php on line 63

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in signature.php on line 68

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in signature.php on line 70

Warning: Cannot modify header information - headers already sent by (output started at signature.php:54) in signature.php on line 102

lil help

[Mr Chad]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in signature.php on line 54

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in signature.php on line 56

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in signature.php on line 61

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in signature.php on line 63

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in signature.php on line 68

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in signature.php on line 70

Warning: Cannot modify header information - headers already sent by (output started at signature.php:54) in signature.php on line 102

lil help

soo no help?

[Marco van Herwaarden]

And what code is generating these errors? you can not expect that someone can give you an answer without seeing what you're doing.

[Mr Chad]

the code that chris gave me

https://vborg.vbsupport.ru/showthread.php?t=50848&highlight=signature.php

[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]

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]

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 :p

Here's what you change in signature.php:
$querya="SELECT COUNT(*) AS users, MAX(userid) AS max FROM user WHERE usergroupid!=4";
to
$querya="SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . TABLE_PREFIX . "user WHERE usergroupid!=4";
then
$queryb="SELECT COUNT(*) AS posts FROM post";
to
$queryb="SELECT COUNT(*) AS posts FROM " . TABLE_PREFIX . "post";
then
$queryc="SELECT COUNT(*) AS threads FROM thread";
to
$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