SM Forum Statistics

[WhaLberg]

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.

[Hornstar]

So is this an updated Top X Stats or from another mod? I have been waiting for Top X Stats to be updated for a while myself.

[ElForro]

Thanks! I was the one who asked for it... I will try it...

I'm getting this error:

Invalid SQL:

SELECT COUNT(*) AS count, post.userid, post.username FROM foro_post
LEFT JOIN foro_thread AS t ON(post.threadid = t.threadid)
LEFT JOIN foro_forum AS f ON(f.forumid = t.forumid)
WHERE f.forumid = 3
GROUP BY username
ORDER BY count DESC
LIMIT 5;

MySQL Error : Unknown column 'post.userid' in 'field list'
Error Number : 1054
Date : Saturday, May 10th 2008 @ 02:55:01 AM
Script : http://www.xxxx.com/forumdisplay.php?f=3
Referrer : http://www.xxxx.com/
IP Address : XXX.XX.XX.XX
Username : XXXX
Classname : vB_Database

[indie2industry]

First install. Lets see how this works

:-)

[indie2industry]

and working perfectly

[ElForro]

Now I tried to install in my test forum wich is a VB 3.7 (before i tried with 3.6.9) and I'm getting this error

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT COUNT(*) AS count, post.userid, post.username FROM vbpost
LEFT JOIN vbthread AS t ON(post.threadid = t.threadid)
LEFT JOIN vbforum AS f ON(f.forumid = t.forumid)
WHERE f.forumid = 2
GROUP BY username
ORDER BY count DESC
LIMIT 5;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109

[WhaLberg]

I have updated the product. Please re-import and tell me the result.

[asj]

Now I tried to install in my test forum wich is a VB 3.7 (before i tried with 3.6.9) and I'm getting this error

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT COUNT(*) AS count, post.userid, post.username FROM vbpost
LEFT JOIN vbthread AS t ON(post.threadid = t.threadid)
LEFT JOIN vbforum AS f ON(f.forumid = t.forumid)
WHERE f.forumid = 2
GROUP BY username
ORDER BY count DESC
LIMIT 5;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109
the same problem :(

[WhaLberg]

Please download the attachment and if you had installed the previous version, overwrite it when importing.

[Defkalion]

Nice work. :)

[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


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]

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

[Super Jinni]

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

yeah

I agree with you...

I've installed this product but I disabled it till the next release and update

I only hope that the author still cares about this product.

:)

[SSJB_7]

very nice thx

[ERAFOX]

great in 3.6.x

install

[Uberguilds]

This plugin is amazing thanks for making it

3.8