This is a great mod! Why are you complaining?

-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?

-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.

-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.

Thanks
-vissa

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

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.

Thank you.


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.

That would be a whole different hack.

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

Erm, where has what gone ?

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.

Any specifics?

Thanks
-vissa

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.

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.