Top 'X' Stats

[high]Security Fix: The uploaded version fixes all issues concerned with the recent security vulnerabilities. Sorry I haven't been around I don't really do anything plugin wise anymore.[/high]

Oh this version also works with all current version of vB 3.6. So feel free to use it on that version.

- InfiniteWebby

The low down

Well this is the vB 3.5.0 version of my hack. It is much the same as the original except that for some added stuff that I never released

Basically what it does is show the Top 'X' (edited via the vBulletin options in the admincp) newest members, top posters and newest replies on the Forumhome.

So what's new in this version?

Well for one all settings, which include amount of stats to show on forumhome and the extended page, thread title and username truncation, excluded forums and 'new' and 'old' thread prefixes.

Secondly there is now an extra page where you are able to choose exactly how many stats to show.

And lastly and most importantly it only takes 3 simple steps to install =)

What's on the horizon?

- More "stat blocks" including top reputation and top thread based on views or replies. If you have a suggestion please let me know, prefferably via pm.
- Proper can view other users threads permissions. At the moment I cannot think of how to block other people threads while still showing your own without totally re-writing the hack =(.

Version 1.2.1 is a re-release with who's online additions as well as some template changes. So you are best to reinstall the whole thing all over again.

So anyway enjoy and click install.

[NotaBene]

Originally Posted by jluerken

Check your usergroup settings. This has nothing to do with the hack.
I think you set the option to moderate this usergroup.

Yes, I checked it - I wanted to check it as I want posts from this usergroup to be moderated.
My problem: Although the new threads aren't displayed in forumdisplay and the posts / threads aren't readable by entering the Post-/Thread-ID (which is like it should be) the TopXStat displays them as new posts / threads.

greetz,
NotaBene

[jluerken]

Originally Posted by InfiniteWebby

@q8-star: I'm not sure what's going wrong with it.

@jluerken: Search this thread, I'm pretty sure someone else asked the same question.

I did so but I could not find the answer.

I want to exclude special userids or groups from showing up.

Example:
USERID. 1234 from an RSS Feed Bot
USERGROUP 8: Banned users should not be listed there.

[jluerken]

I found out how I can exclude users from the TOP Poster list.

In topXstats.php find:

PHP Code:

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords"); 


and change to

PHP Code:

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE userid NOT IN (1282,1) ORDER BY posts DESC LIMIT 0, $displayrecords"); 


I added a WHERE userid NOT IN (1282,1) which is an array of userid's.

In this example I excluded userid 1282 which is my RSS Bot and userid 1 which is the main Admin account.

In product-topXstats.xml find:

PHP Code:

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords"); 


and change to:

PHP Code:

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE userid NOT IN (1282,1) ORDER BY posts DESC LIMIT 0, $displayrecords"); 


Reupload the topXstats.php and
then go to your ADMINCP - PLUGIN SYSTEM - MANAGE PRODUCTS - ADD/IMPORT PRODUCT and upload the change .xml file.
Make sure that "Allow Overwrite" is set to YES

Thats it!

I did not find out how to exclude a whole group like the banned group.

@InfiniteWebby:
Could you please release a version 1.3 where we can also exclude single userids and whole groups?

[jluerken]

I found a small cosmetic bug in version 1.2.1

I am displaying the top 5 posters on forumhome.
STATISTICS - TOP 5 is a link to the topXstats.php file displaying the whole toplist.

This is fine but when you click on this link its saying
STATISTICS - TOP 30 for example but redirecting to the topXstats.php file also.

On the Top30 list the link should redirect back to forumhome again I think.

Maybe something for 1.2.2 or 1.3?

[InfiniteWebby]

Ok, I start working on all of your requests soon, but I am having a little trouble with my hosting so I need to get that fixed first.

[vietkool]

is there any setting after import the XML files ? I've donw exactly what say in install.txt file but I can not get it to show the Stats at all

[InfiniteWebby]

Settings are in the vbulletin settings under top 'x' stats. If the stats aren't showing then it is likely the templates haven't been uploaded properly or you have plugins and products disabled.

[lairnoc]

he infinitewebby

How can i make an extra top latest threads and highest reputation ? Or will you do something like that in the future.. now people reply so fast that new threads survive lik e5 minutes on my forum...

[rb290]

thank you!
i wish all the other hacks were this easy to install

[rb290]

but one thing, is their a way i can put this at the top of the forum ?
cause its all the way at the bottom and it makes more sense to have it at the top