Forum Display Enhancements - SM Forum Statistics

Hello everybody,

After I saw a thread months ago, I told the thread author that I will do it and I made my promise, well, a little bit late.

What is this statistics product?
This is NOT a board statistics mod. This is a forum statistics mod that displays the top posters, top replied threads (within two months) and top viewed threads (within two months).

INSTALLATION:

• Import the product.
• Open the FORUMDISPLAY template.
• Add after $navbar:

  $forumtops

• Save.

That's all.

Congratulations!

Any idea to improve this mod is welcome.

NOTE: Works on 3.6.x.

Update notes:
v1.1 - Top poster query edited.
v1.2 - Thread queries edited.

[Varsh]

Hmm for some reason it won't display anything even after the template change.

[sdavis2702]

Awesome thanks!

[ElForro]

I've downloaded the updated product but I think the table prefix is missing or something like that...

Database error in vBulletin 3.6.9:

Invalid SQL:

               SELECT threadid, title, replycount FROM thread
			   WHERE forumid = 3 AND dateline > 1204340400
			   ORDER BY replycount DESC
			   LIMIT 5;

MySQL Error  : Table 'millionredire.thread' doesn't exist

I mean, the table "thread" doesn't exist... It should be something like vb_thread

[WhaLberg]

I have edited the top thread queries again, if its working for you (which means you don't have a table prefix) you don't need to re-import the product but if you have problems with the product, please re-download and re-import with overwriting option.

By the way, any ideas to implement this mod?

[J105C]

WOW, this is an awesome mod!

[Super Jinni]

what if the top poster hasn't been active for more than two months?

is he going to be replaced?

another thing:

after installing this, I couldn't find any options in for this product in ACP

Originally Posted by WhaLberg

any ideas to implement this mod?

Some Suggestions:

1- Make product options in ACP for:
-enable/disable product.
- include/exclude usergroup(s) to forum statistics.
- include/exclude usergroup(s) to be counted.
- include/exclude user(s) to be counted.
- include/exclude forums to make this product work in.

2- Include top thread starters.

thanks

[madscientist06]

Sounds great, but I'm a little slow and please excuse my newbieness!

A couple questions:

# Import the product.
Where? How? Could you list the steps?

# Open the FORUMDISPLAY template.
What is the full file name of the template and where can I find it (e.g. folder)?
Am I editing this from my PC or from VB?

Thanks much!

[zigojacko]

Worked great, excellent mod. Thanks

[Super Jinni]

Originally Posted by madscientist06

Sounds great, but I'm a little slow and please excuse my newbieness!

A couple questions:

# Import the product.
Where? How? Could you list the steps?

# Open the FORUMDISPLAY template.
What is the full file name of the template and where can I find it (e.g. folder)?
Am I editing this from my PC or from VB?

Thanks much!

to import the product:

1- download the product

2- in the Admin CP scroll down to the page

On the left choose : Plugins & Products > Manage Products
then scroll down again and to the bottom till you find [Add/Import Product] then press on it

3- then under Import Product press Browse and then choose the product form were you save it in

4- press Import

and you're done

to edit the template:

1- in the admin CP on the left choose: Styles & Templates> Search in Templates

2- type in empty box: FORUMDISPLAY and then press Find

2- in the results look for the style that you're currently using or which you want to use this product with if you have more than one style and from the list of the style you should see the template FORUMDISPLAY under the Forum Display Templates

3- press on the Template named FORUMDISPLAY twice then you can edit it as mentioned

and you're done..

[EuroBeat2]

I have tried this mode. While the idea is excellent there is a problem how TOP REPLIED THREADS and TOP VIEWED THREADS are rendered. It looks like the mode takes TOP REPLIED THREADS and simply use the data from that column to generate TOP VIEWED THREADS (you might notice that even order is the same and has nothing to do with listing from highest to lowest viewed threads). I have situation where there are messages that are not qualified as TOP REPLIED THREADS, but they had the highest rank as top viewed and yet not appearing in TOP VIEWED THREADS. Therefore makes this mode of limited value.

I would also suggest to make it flexible so another than TOP 5 are displayed (like maybe 3 or 10 etc, whatever Administrator would choose to have). That goes as addendum to Super Jinni list.

Thank you for your work.

EB