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.

[xhybrid]

hi,

your Extensions works fine @ www.r32-club.de

thank you :up:

[Crow]

I know this is a long shot but anyway to get this to show the newest photos from photopost (text Link)??? :nervous:

[InfiniteWebby]

Originally Posted by blue6995

Is there anyway of preventing the Top Posters Block from being displayed?

Thanks

There is no easy way at the moment. I just got a new PC so am in the middle of sorting some stuff out, I might be back later with a solution.

Originally Posted by Crow

I know this is a long shot but anyway to get this to show the newest photos from photopost (text Link)??? :nervous:

I am not familiar with photopost so wouldn't even know where to start.

[GuaRRand]

works great!!

Maybe an idea for next version (if its not mentioned before)
Show the avatar of the #1 poster on the list?

[redlabour]

Hi,

how can i use TopXStats in iFrames in a xternal Portal PHP or HTML Block for vBa, vBP or MKPortal ?

[plateau]

stillllllllllllllll waiting for more columns coming out..................

come on mate. ... ... ^_^

[divided_by_fear]

is there any way you could get this working for vBadvanced CMPS v2.0.0 and if so thank you very much...

[caliman]

It would be nice if this did not show redirects if you move a thread.

Also if I remove top posters, what code do I have to remove so that it runs faster (doesn't query the db about top posters).

thanks! cool mod.

[outlaw621]

Originally Posted by 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?

Did you try changing userid to usergroupid? I have not tested this yet. It is just a thought.

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 usergroupid NOT IN (8) ORDER BY posts DESC LIMIT 0, $displayrecords"); 


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 usergroupid NOT IN (8) ORDER BY posts DESC LIMIT 0, $displayrecords"); 


The above code MAY let you exclude by group instead of user. In the above examples, it should exclude group 8 which is the default banned users group.

[caliman]

Thank you outlaw I will try that.
Do you know anything about the 'moved thread' bug? It shows the redirect and the thread.