Top 10 Posters Display

This modification is no longer available or supported.

This simple hack displays a page with the Top 10 Forum Posters for the last day, 7 days, 28 days and overall.

No vB files need to be edited. The instructions (txt file), the php file, and a screenshot are attached.

A vB Advanced module is also now available for this (thanks to dsboyce8624) - just d/l the zip file.

[SlipNslide281]

Maybe in your instructions tell people to run this query:ALTER TABLE post ADD INDEX (dateline)

enstead of saying "If you don't already have an index on the dateline field in the user table then you should add one"

some people are new to this and don't understand what to do. Its kinda like saying if you don't already have this hack installed, install it. Thats what makes me so frustrated on these hacks is the coders automaticly thinks you know what your doing and get about 80% done and bam!!! instructions are not clearn. If we knew we would be making our own hacks. All we users ask is just put exactly what we should do in the instructions.

[selwonk]

Originally Posted by SlipNslide281

Maybe in your instructions tell people to run this query:ALTER TABLE post ADD INDEX (dateline)

enstead of saying "If you don't already have an index on the dateline field in the user table then you should add one"

some people are new to this and don't understand what to do. Its kinda like saying if you don't already have this hack installed, install it. Thats what makes me so frustrated on these hacks is the coders automaticly thinks you know what your doing and get about 80% done and bam!!! instructions are not clearn. If we knew we would be making our own hacks. All we users ask is just put exactly what we should do in the instructions.

The instructions read:

Step 5.

If you don't already have an index on the dateline field in the user table then you should add one ;

ALTER TABLE post ADD INDEX (dateline)

I'm probably opening myself up for a flame here, but hey...

I don't think it's too much to ask that if you feel confident enough to start hacking vBulletin, you should really be able to check if a field is indexed. It's just my humble opinion of course! :classic:

At the end of the day, this will not stop this particular hack working. If your site is so large that failing to index this field causes a huge delay in displaying the results, but you don't understand why the indexing change might be required (or how to deal with it), isn't time you learned a bit more about MySQL! :nervous:

Cheers!

[SlipNslide281]

I did my own site not even knowing how to register my domain. I started out as a complete noob and still am. Yes the confidence isn't there. But I have learned so much from detailed instructions. Here is my site, and its my first site. So detailed instructions can help people learn.

www.sonaf.com

[Gutspiller]

How do we know if we need to run Step 5?

If you don't already have an index on the dateline field in the user table then you should add one ;

ALTER TABLE post ADD INDEX (dateline)

If the topposters.php works, does that mean we don't need to do this?

[Sleepyk]

Originally Posted by Sleepyk

how i get on my forum home template under last 10 threads?

help?

[faast]

Does this work with vB 3.0.7?

[Paul M]

Originally Posted by selwonk

Hi Paul

Great hack - thanks very much! Any objections to me removing the link to your profile at the bottom:

Version 1.55 : ? Paul Marsden 2005

I have no objections to it staying, but unless my users are registered on cable forum they can't see your profile anyway! :ermm:

Cheers!

You may remove the actual link to my CF profile - as long as the copyright message (text) remains.

[MillerLight]

Installed on VB Ver 3.0.8.

Left out Step 5 and works fine. Straight forward install, works great!

[michaelbenson]

Excellent idea and hack .. keep up the good work
Installed

[tuanluu]

How can I show top 10 poster on index page, and right below the navar board