Yes, how do you run a query? :?:

Double bump this. :)

Firefly, any way to put a little graphic or something on the MOTD user's post for the day? Something like the birthday hack.

ps...my users really like this. thanks.

Chris

When I do this, ?resetmember=1 does not work anymore, which makes me wonder what it will do at midnight

I installed this but it shows the same member everyday unless I do the reset thing myself. In other words it's not selecting a new member on it's own each day. Any ideas why?

Nevermind, I fixed my problem.

****bump****

Waaaaaay cool.

I just applied 'Who was online today' hack and merged that with the WOL box, I had one blank line left, and this just fit in perfectly! Fnx ;)

I've ran this for about a week now and it's never changed the member of the day. Any reason why it isn't automatically changing daily?

What version of MySQL are you using?

I get this:

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT userid,username
FROM user
WHERE userid<>
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 'AND (usergroupid=5
OR usergroupid=6
' at line 4

mysql error number: 1064

Date: Sunday 24th of February 2002 03:53:22 PM
Script: http://www.gb-mod.net/forums/forums/index.php?
Referer: http://www.gb-mod.net/forums/admin/i...hp?action=head


And how Do I query that first line?