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.

[Neal-UK]

Originally Posted by nealparry

blank for me to and the error also

sorry, install it under products....mind you, i then got a db error and couldn't viw the forum and had to remove it.

My forum has db prefix FORUM so will that be a problem?

[Zorck]

Hello, I get this error :

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DESC LIMIT 0, 5;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost
Error Number : 1064
Date : Thursday, July 28th 2005 @ 09:26:18 PM
Script : http://www.pixsell.com.ar/forums/index.php
Referrer : http://www.pixsell.com.ar/forums/pri...=showpm&pmid=1
IP Address : 201.255.27.156
Username : admin
Classname : vb_database



any idea?

[Neal-UK]

I get that too:

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM FORUMthread AS thread
LEFT JOIN FORUMuser AS user ON (user.username = thread.lastposter)
LEFT JOIN FORUMdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DESC LIMIT 0, 5;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DE
Error Number : 1064
Date : Friday, July 29th 2005 @ 12:31:36 AM
Script : http://www.burnleyweb.com/community/index.php
Referrer : http://www.burnleyweb.com/community/online.php
IP Address : 212.***.***.***
Username : *******
Classname : vb_database

[InfiniteWebby]

Ok the database errors are because you left the excluded forums setting blank, put a zero in there for now and it should be okay. I'll put in a check statement that will make sure this doesn't happen in the future.

To everyone else having troubles uploading the plugin. I should have stated this before. IT IS A PRODUCT to import it you must go into your admincp click the Manage Products link in the nav bar. Click [Add/Import Product] then import it. If you have already tried to import it then it is best if you select 'yes' for Allow Overwrite. If you are still having troubles then pm me with the exact problem and I will look into it.

[Neal-UK]

im struggling to find where you mean, i though i did the above but it still gives me the error

[InfiniteWebby]

Ok, sorry the settings didn't export. It *should* be fixed now, just download the new zip and follow the instructions.

Again if there are any problems pm me, it is much easier that way =)

[Neal-UK]

Originally Posted by AnimeWebby

Ok, sorry the settings didn't export. It *should* be fixed now, just download the new zip and follow the instructions.

Again if there are any problems pm me, it is much easier that way =)

lol, no worries, will try now thanks very much for your help

[Neal-UK]

Originally Posted by nealparry

lol, no worries, will try now thanks very much for your help

No, still getting an error on forumhome:

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM FORUMthread AS thread
LEFT JOIN FORUMuser AS user ON (user.username = thread.lastposter)
LEFT JOIN FORUMdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DESC LIMIT 0, 5;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DE
Error Number : 1064
Date : Friday, July 29th 2005 @ 01:42:01 AM
Script : http://www.burnleyweb.com/community/index.php
Referrer : http://www.burnleyweb.com/community/usercp.php
IP Address : 212.***.****.*****
Username : ******
Classname : vb_database

[Neal-UK]

my forum prefix is FORUM, that causing a problem?

[InfiniteWebby]

Are the settings in the vB options this time?