hi nice hack it works fine except for the member of the day i get this error.

Invalid SQL: SELECT userid,username FROM user WHERE userid<>$daybits[1] AND (usergroupid=5 OR usergroupid=6 OR usergroupid=7 OR usergroupid=2) ORDER BY RAND() LIMIT 1
mysql error: You have an error in your SQL syntax near 'RAND() LIMIT 1' at line 1

any ideas anyone?

you need to have this installed ;)

it is installed turned out to be a different version of mysql didnt like the rand() see member of the day thread for fix.

but the problem i have now is that the userid numbers dont match the username.

http://www.golden-springs.com/forums/index.php

you will see the top poster and top thread starter show userid 1 and userid 2 from the database but the names arent userid 1 and userid 2

can this be fixed?

sweet. found the fix there. thanks :)

np ;)

Wouldn't this tax the server because every hit on the forumhome would generate 5 additional SQL select statements? Why not put this as a link on another page for those who want statistics?

love the hack, you said new vs coming out with referrer, due soon? wow it's hacks like this as to why i left dcforum after years of having to hack it myself, what a community

gonna install this one now m8.

Thx

hmm doesn't seem to work on the 2.2.6 version cause some lines are unable to be found.

Is there gonna be an update...or does somebody know what to edit?

I was able to install this hack on our 2.2.6 vB forum no problem. It's been a while but I don't remember having any problems. Have you installed other hacks that could have changed the code?

-Steve St.Laurent
Webmaster of http://www.turbodieselregister.com

Could well be yes.

but found the bugger.

Thx anywayz for the help