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.

Just what I was waiting for, thanks!!! :D

Permissions are pretty easy and I must say vital to the functionality of this hack :)

It's nice - Similar to my Latest threads hack but obviously with a few more sets of stats :)

I'm interested to know how many extra queries this adds, and whether any cached data could be used to prevent queries being used etc...

Satan

its gives Invalid Argument suplied for foreach() in n function.php at line 771 while trying to upload the plugin file ???

Sweeet.../me clicks install

The XML file when uploaded doesn't have any code or a title name, there for it doesn't show up, just a blank plugin.

hi mate, u r great, it is what i was just waiting for!

Same for me.

its true but before that it gives u an error which is invalid .......... online line 771

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?

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?

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

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.

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

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

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

my forum prefix is FORUM, that causing a problem?

Are the settings in the vB options this time?

no, just the default

did you select yes when it asked you to allow overwrite?

Well Done but I think more Columns could be added such as: Top Viewed Threads, Top Replied Threads, like these.

Cheers.

You mean it works for you?

And I will be working on extra columns once I get permissions and username formatting done.

no as i unistalled it then reinstalled it. Am i best selecting overwrite and try again?

Probably and if you are still having troubles then contact me via pm. They are in my profile.

it works finaly thanks a loooooooooooooooooooooooooooooooot for that hack

whoo oooo, it's working thanks. If only I could move the shoutbox to the bottom now....... Thanks AnimeWebby

EVERYTHING WORKS FINE, BUT THERE IS A SMALL PROBLEM. THE TITLE "Top Poster" doesnt show, Other than that, its fine.

eh? that was working earlier. Help??

is this a phrase issue? which phrase will it be?

To fix the top poster not showing just add a new phrase.

Phrase Type: GLOBAL
Product: Top 'X' Stats by InfiniteWebby
Varname: top_posters
Text: Top Posters

weird, still not showing. It was earlier, i'm sure of it.

Sorry made a mistake again. It is meant to have a varname of top_posters!

I updated the zip to fix the missing phrase so if you'd prefer to reinstall the product then feel free to do so.

yup, working now many thanks again ;-)

Ooooo, I have gotta have one of these. :)

very well, thx man !

yes it is.

thanks mate, and i m waiting for ur further works done!

I love this hack, thanks AnimeWebby. :)

One thing though...

On the FORUMHOME, this works well with usergroup permissions, i.e. I can only see the threads that I am allowed to view under my usergroup. BUT... when I click on the link to see all 30 top entries (http://www......../forum/topXstats.php ), then ALL posts show... and unfortunately even guests will see the threads of the staff forum, for example... :(

Any fix for this?