PDA

View Full Version : poster of the year :D

dutchbb
02-24-2007, 03:15 PM
Does anyone know how to run a query to find out who has made the most posts in last year (2006). I would like to announce the winners on our board :D
anywares
02-26-2007, 03:40 PM
Install that hack erm.........that shows the top results under the navbar/shoutbox?
dutchbb
03-15-2007, 01:28 PM
Not sure what you mean

If someone could providde me with a query to calculate this in mysql that would be enough for me :)
WhaLberg
03-15-2007, 02:28 PM
I think this can be done by importing the dateline to normal date* and selecting posts added by user. And mysql_num_rows will help you to calculate how much post s/he sent in that year.

* I don't know whether changing the date is possible.
dutchbb
03-15-2007, 04:12 PM
Now to translate this in easy steps for me :D
WhaLberg
03-15-2007, 07:35 PM
Now to translate this in easy steps for me :D

Let me know if you do that. ;)
dutchbb
03-16-2007, 03:53 PM
LOL I eman someone else, i can't :(