Automated Awards System

[Dean C]

This system exists - its called the stars hack

[sabret00the]

isn't the stars hack based on post count?

[Dean C]

And so is yours - hence when you get to x posts you get a new (set of) image(s). Its the same theory...

[sabret00the]

only one of my images is based on post count tho

Originally Posted by sabret00the

sylus yours sounds interesting but with mine i have only one real award based on post count, the rest are event attendees, photos (photopost), contest winners (hmmm contest hack, that's an idea lol), recruiters, quiz masters, community contributors (seems as though that would have to be manual after all), etc but as you can none of these is based on user post count. you have to much faith in my php skills faranth

[sabret00the]

would it be possible to do the queries on all users over lets say 2 days (userid1-200) every 2 hours doing 2 hundred more and have that data cached on a per week basis? or would it kill the database with the queries?

[sabret00the]

ok i've figured out how to do this, on a very large board it might be a bit harder though.

anyway you query everything
if user have a possitive amount of posts over his or her days on the board along with whether they've been on in the last month and you'll have your regular poster award

you can query the database to see if userid XX has submitted a quiz or not for the Quiz Master award

the same as above for the Photo award (integrated to Photopost)

if userid XX has referals over X then you can give em the Referrer award

Staff member would be more of a conditional if userid XX = usergroupid XX OR XX then give them this award

and stuff like Event Attendee, Contributor, Contest Winner would be manual via the ACP



anyway with all that you set it to run a cron job to update the relevant database settingsand then cache them all for 24 hours or XX hours and you've got your automated awards system.

now i've not had time to bone up on my php but it would be a great hack, if anyone wants to make it feel free, i'll probably make it an official request when my brain switches on and i can figure out if i'm missing anything.