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]

No idea. If it sees the index it wont try and add it.

[MorrisMcD]

Originally Posted by Paul M

No idea. If it sees the index it wont try and add it.

Welp.. If you give up, so do I... Nice feature.. Not worth the headache

And it doesn't seem I am the only one with a similar problem. Nor do I have a problem with any other products

[Paul M]

Originally Posted by MorrisMcD

Welp.. If you give up, so do I... Nice feature.. Not worth the headache

Since I have neither access to your server or forum, there is nothing I can do. I cant just produce magic answers out of thin air.

Originally Posted by MorrisMcD

And it doesn't seem I am the only one with a similar problem. Nor do I have a problem with any other products

I dont see anyone else having an issue creating the index.

How many of those "other products" create an index on (or alter) the post table, Im guessing none, since they obviously would have the same problem (the issue is mysql creating the index, not the product).

[MorrisMcD]

Originally Posted by Paul M

Since I have neither access to your server or forum, there is nothing I can do. I cant just produce magic answers out of thin air.

I understand that.. And I will continue to enjoy the majority of your addons and appreciate your effort in making them.. Unfortunately this one just isn't working out.

Originally Posted by Paul M

I dont see anyone else having an issue creating the index.

How many of those "other products" create an index on (or alter) the post table, Im guessing none, since they obviously would have the same problem (the issue is mysql creating the index, not the product).

I noticed you said something about the problem of the index being created slow and timing out in post # 28... Which is similar to my issue I guess (or at least I thought).. Weird thing is, that the index is created.. I verified it's there. Perhaps it is something on mysql, but I can't imagine what since I am having no other issues with anything whatsoever. Not really meaning to point fingers as you may have taken it that way. Just lost for a solution as I have no other symptoms to go off of

[Paul M]

If you are absolutely sure the index has been created, you can simply comment out the line in the product xml that tries to create it, it will then install (line 76 I believe). Be aware that if the index isnt created ok, you may find the top posters page slow to generate and load.

[MorrisMcD]

Originally Posted by Paul M

If you are absolutely sure the index has been created, you can simply comment out the line in the product xml that tries to create it, it will then install (line 76 I believe). Be aware that if the index isnt created ok, you may find the top posters page slow to generate and load.

I appreciate the fact you still do want to help Paul.. I really do.. I more wanted to give up because I don't want to burden you. But since you posted again..

As far as I can tell, it is created. But my knowledge in this stuff is quite limited. I actually started combing over the product to find where it instructs to create the index. I wasn't sure so I decided to lay off. In any case, before I try the commenting out.. Take a looksy at these screen shots and tell me if it appears that it is created and created successfully. Thanks again for taking the time to respond. I really don't want to be a pain.. Just check these out and tell me if you see any issue with the index... I think its ok.. But I would feel comfortable knowing someone who knows a lot more thinks its ok before I take a suggestion that starts with 'If you are absolutely sure the index has been created'.. lol Sorry that this is going out of the scope of what you would normally support. I understand if you decline to continue

[Paul M]

Neither of those screenshots shows the indexes, they are listed in phpmyadmin under the structure listing (see screenshot). You can also run the following command to list them ;

SHOW INDEX FROM post

[MorrisMcD]

Originally Posted by Paul M

Neither of those screenshots shows the indexes, they are listed in phpmyadmin under the structure listing (see screenshot). You can also run the following command to list them ;

SHOW INDEX FROM post

Eeek... Problem found

My guess would be to start by deleting all the dateline indexes and then the dateline field? Then attempt reimporting again? Might end up with the same results

Hope I said that right...

I also noticed some tables named postindex_temp*****-*** that may or may not have been there before and may or may not have anything to do with this. I get by with people's help on here or other forums.. Sorry for my noobishness

[Paul M]

Originally Posted by MorrisMcD

My guess would be to start by deleting all the dateline indexes and then the dateline field? Then attempt reimporting again? Might end up with the same results

You can delete all the indexes listed except these four : PRIMARY, userid, threadid, dateline.


Do not delete the dateline field in your database, you will break your forum, bigtime.

This kills my DB as well, btw. Just tried installing it on a fresh DB, it creates the index then corrupts my post table.

The hack should have some kind of note/warning for users with big forums, as it creates an index on one of the biggest tables in the DB (post).

Edited for clarity: Folks may need to set their mysql timeouts higher for this to run on big tables.