So i am currently in the process of creating a forum and blog posting service, and wanted to add this feature. First, I wanted to implement this 'formula', for lack of a better word. What I want to do is pay my poster the following way: *The poster who posts the most gets paid $.10 per post *The poster who posts the second most posts gets paid $.09 per post *The poster who posts the third most posts gets paid $.08 per post and so on.. Is there a way where I can get the system to recognize who posted the most, and then pay them their respective amounts based on what 'position' they come in, or do I have to do that manually?
I bet you have a (MySQL) database for the system... SELECT `user` FROM `users` ORDER BY `users`.`posts` DESC LIMIT 0, 3
I don't understand why people try and do something if they don't understan the fundamentals of what is required. That above query is also just a pointer in the correct location, its naturally narrow in its catchment.. since it will always favour the people who have been using your forum the longest... I'll let you figure out why to try and help you flex your brainmuscles.
@Kalyse True! You cant let everybody else do the hard work for you and enjoy the revenue yourself. You could exclude the admin for example, WHERE `ID` > 1
I'm not letting anyone do all the hard work. I am making he site, not them. I just wanted to make the payment process a little easier than what it would have to be without that script.