Miscellaneous Hacks - Top Posters List

This modification is no longer available or supported.

This 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, 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 (or excluded) in the count, so members in banned groups etc are not shown.

If enabled, this will also attempt to add a link to your Quick Links or Navbar. There is also an option to prefix the link path if you use something like CMPS.

To install just unzip the xml file and import it using the Product Manager


History:

v3.7.001 - First 3.7 release.
v3.7.002 - Fix counting of guest posts in certain circumstances.

[Paul M]

The template is found in the style manager, same as all other templates. The one you want is "Top_Posters_bit".

To do last month would require code changes, and possible a change to the sql.

[Promoking]

Thanks Paul - I really appreciate it.

Originally Posted by Paul M

To do last month would require code changes, and possible a change to the sql.

So... um... I guess doing that kinda coding is way beyond my skillz. Any hope you can add it?

Cheers

-Brian

PS. Idea for another mod = a page where you can run a search query specified by a date range that returns individual users/posters and the number of posts each user made within the specified date range. What do you think? Useful? Doable?

Thanks

[Paul M]

Originally Posted by Promoking

So... um... I guess doing that kinda coding is way beyond my skillz. Any hope you can add it?

PS. Idea for another mod = a page where you can run a search query specified by a date range that returns individual users/posters and the number of posts each user made within the specified date range. What do you think? Useful? Doable?

Sorry, no changes are planned to this mod.

[MorrisMcD]

Just times out for me when installing the product... I dont even see the product listed under products installed..

Any clue? Worked great on 3.6 for me.. No database crashing here though...

[Paul M]

Sorry, there is no reason for this to time out other than some odd issue with your board. Have you tried again ?

[MorrisMcD]

Originally Posted by Paul M

Sorry, there is no reason for this to time out other than some odd issue with your board. Have you tried again ?

Yes I tried it three times.. Without overwrite on.. Each time, it did the same thing. In fact, just tried it again...

Importing Product, Please Wait...

[:]
Checking for Index
Adding Index

Never goes back to the products page.. Just sits there like so for about a min to two min and then the bottom of the page reads as done

[Paul M]

Your server is obviously taking a long time to add the index, or failing to add it for some reason. Maybe you will have to do that manually.

[MorrisMcD]

Originally Posted by Paul M

Your server is obviously taking a long time to add the index, or failing to add it for some reason. Maybe you will have to do that manually.

How do I go about doing so? Can I try changing timeout values somewhere possibly?

[Paul M]

Originally Posted by MorrisMcD

How do I go about doing so?

Just run the sql manually ;

[sql]ALTER TABLE post ADD INDEX (dateline)[/sql]

[MorrisMcD]

Originally Posted by Paul M

Just run the sql manually ;

[sql]ALTER TABLE post ADD INDEX (dateline)[/sql]

Your SQL-query has been executed successfully (Query took 62.6895 sec)
SQL-query:
ALTER TABLE post ADD INDEX ( dateline )

Did it manually.. Imported the product... same thing

I verified the dateline exists in the post table. So when installing, when it checks for the index, why does it still attempt to add it?