Member of the Day!

The idea is from SitePoint Forums.

I think a lot of people really want this hack, and I've even seen a released version of it here, but it used cronjobs and stuff like that I'm sure not all of use want to mess with.

So, here's my version of the hack, completely crobjob-less and 100% working.
The hack also includes an easy way for the admins to change the member of the day at any given time. (see note below)
You can see it in action in this board, on the main page in the stats box.

To install this hack download the attached file (memberofday.hack.php), upload to your /admin folder and use vbHacker.

A couple of notes:

• The member of the day will reset every day at 12:00am server time.
• It is possible for the admins to re-choose the member of the day at any given time, by adding "?resetmember=1" when visiting index.php. (only logged in admins can use this; for regular users it won't do anything)
• The only check in the code is to prevent the same member of the day two days in a row. It is possible, however, that the same member will be chosen two days after he was already a member of the month.
• I don't recommend using this hack on a small forum (with not-so-many members) because of the above.

That's it, have fun.

[Boofo]

Good job! Looks great!

BTW, what is the "boardstat.php hack"? I must have missed that one.

[suzannev]

Here is the link:

Boardstat link

Your signature sounds like me at the mall with my kids, I tell my 2 sons (13 and 10) not to walk with me, I don't want anyone to think I am that old.

[Boofo]

Thank you for the link.

Congratulations on surviving teenagers. I have a 5 year old and 3 months old twins (all boys) and 2 grown boys (21 and 22) and I'm not sure I'll survive it all. I think that's why I adopted the signature. (But I wouldn't trade any of them for the world).

[mheinemann]

Originally posted by Boofo


Just changing RAND() to RAND(NOW()) will do the same thing with less code and you don't have to do the $seed= part of it. That's what NOW does automatically.

Thanks for the tip.

[Mike Gaidin]

Originally posted by mheinemann
Let me know if it works for you.

Looks like it works fine. Thanks for the help.

[Boofo]

Originally posted by mheinemann


Thanks for the tip.

You're very welcome. I found this tip at the mysql site and it seems to make a difference.

[Rose]

Thanks Firefly for the hack. And many thanks to Boofo whose previous posts (see page nine) have helped get it working for me.

[high]* Rose pounces on install[/high]

[Rose]

Outta curiosity - If I wanted to limit the usergroups that are eligible for the Member of the Day, I'd simply plug in the appropriate numbers as shown below, right? I mean, the below will pull members from usergroups 5,6,7, & 2, right?

PHP Code:

    $newmember=$DB_site->query_first("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"); 


[Boofo]

Yes.

[Rose]

I knew you'd be to my rescue. Thanks, Boofo!