12-04-2018, 01:02 PM
awesome idea. i think you should implement it separately.
scoring can be done by first sorting for active users with more than 14 posts [if post benefit becomes part of the award] or 19. Next you find most viewed and most replied on those selected. but here is the issue. you can not calculate using total views and replies. Im sure you can count monthly replies from reply dates.
But how are you going to get monthly views ? dont think that is kept in db for each thread.
i hope you understand why you should not calculate on total but monthly stats .. so that every user, irrespective of old or new, gets equal shot at winning each month.
scoring can be done by first sorting for active users with more than 14 posts [if post benefit becomes part of the award] or 19. Next you find most viewed and most replied on those selected. but here is the issue. you can not calculate using total views and replies. Im sure you can count monthly replies from reply dates.
But how are you going to get monthly views ? dont think that is kept in db for each thread.
i hope you understand why you should not calculate on total but monthly stats .. so that every user, irrespective of old or new, gets equal shot at winning each month.
Sincere Thanks to VirMach for my VPS9. Also many thanks to Shadow Hosting and cubedata for the experiences I had with their VPSs.