Top xx Posters List

This modification is no longer available or supported.

The 3.5 version of my Top (10) Posters hack.

This has now been re-vamped for the release of version 3.xx - the hack no longer uses a seperate topposters.php file.

This hack displays a page with the Top Forum Posters for a given set of periods. Two periods are fixed ('This Month' & 'Overall') but can be turned off in the options. The other three periods are user definable (in days) - the default values are 1 day (24 hours), 7 days & 28 days. These three columns cannot be turned off.

The number of posters to be shown can also be set, the default is the top 10 posters. You can also select which usergroups are included in the count, so members in banned groups etc are not shown.

To upgrade (if you want to) uninstall version 2.xx and re-install this version. Note the url to display the page has changed.


History:

v3.01 - First public version 3
v3.02 - Fixed display error reported in post 59
v3.03 - Fixed display error reported in post 84
v3.11 - Series of additions, upgrades and settings added.
v3.12 - Updated install code to check for existing index.
v3.13 - Fixed uncached templates added in v3.11
v3.14 : Changes to display layout.
v3.15 : Minor changes, no update necessary.
v3.16 : Fixed bug in monthly totals caculation.

[lazytown]

This is a great mod! Why are you complaining?

-vissa

[lazytown]

I was thinking I would write a little cronjob that would run this every hour and save it as html. That way it won't hammer the server every time a user requests it. Do you think that would be a good way to reduce the load this puts on a server?

-vissa

[lazytown]

One thing that would be cool is if it had another table that showed top reputations per period of time (is that even possible?)... For example, top user reputation overall, top reputation points earned in last 30 days, etc... Perhaps even a ratio between posts and reputation earned over that period of time. Is that a wacko idea? I think that would make this the ultimate top user mod.

-vissa

[lazytown]

Last question from me (promise). How would I remove certain forums from the postcount? I'm assuming I could change the SQL querry - but I might need a little help.

Thanks
-vissa

[mojahudba]

i instal but dunno where its gone ? ? anyway love all your hacks

[Paul M]

Originally Posted by Aftermath

Gah that's sad...

That's life I'm afraid. vB is a hobby, not a career.

I just about have time to do, and support, the stuff I do for free, and a few small paid jobs every now and then.

[Paul M]

Originally Posted by vissa

This is a great mod! Why are you complaining?

Thank you.

Originally Posted by vissa

I was thinking I would write a little cronjob that would run this every hour and save it as html. That way it won't hammer the server every time a user requests it. Do you think that would be a good way to reduce the load this puts on a server?

I think that sounds like overkill. Unless you have a huge forum (> 1000 posts a day) and people are viewing this all the time, then the load is not going to worry you.

Originally Posted by vissa

One thing that would be cool is if it had another table that showed top reputations per period of time (is that even possible?)... For example, top user reputation overall, top reputation points earned in last 30 days, etc... Perhaps even a ratio between posts and reputation earned over that period of time. Is that a wacko idea? I think that would make this the ultimate top user mod.

That would be a whole different hack.

Originally Posted by vissa

Last question from me (promise). How would I remove certain forums from the postcount? I'm assuming I could change the SQL querry - but I might need a little help.

Yes, you would need to add some code to the SQL WHERE lines.

[Paul M]

Originally Posted by mojahudba

i instal but dunno where its gone ? ? anyway love all your hacks

Erm, where has what gone ?

[lazytown]

Originally Posted by Paul M

I think that sounds like overkill. Unless you have a huge forum (> 1000 posts a day) and people are viewing this all the time, then the load is not going to worry you.

Well I guess we have a huge forum since we get over 1500 posts per day (sometimes 2000 or more). I guess it does depend how often it is clicked though. Mine takes about 2.5 secs when I run the top 10 posters, according to ministats.

Originally Posted by Paul M

Yes, you would need to add some code to the SQL WHERE lines.

Any specifics?

Thanks
-vissa

[Paul M]

Originally Posted by vissa

Well I guess we have a huge forum since we get over 1500 posts per day (sometimes 2000 or more). I guess it does depend how often it is clicked though. Mine takes about 2.5 secs when I run the top 10 posters, according to ministats.

Yeah, that's quite slow, but my guess it that's only a small number os times pre hour, it's not a page people keep viewing minute after minute.

Originally Posted by vissa

Any specifics?

No at the moment, but thinking about it, it will add extra joins to the queries, as well as the extra 'where' logic. Not recommended - esp on a forum your size - it would drive that 2.5 seconds up significantly.