vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=93065

Top 'X' Stats
by InfiniteWebby
28 Jul 2005 13:25

3 Attachment(s)
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.

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.

Azhrialilu 28 Jul 2005 13:32

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

Chris M 28 Jul 2005 14:44

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

Barakat 28 Jul 2005 15:09

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

Anfiniti.net 28 Jul 2005 16:43

Sweeet.../me clicks install

mrgizmo 28 Jul 2005 17:04

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.

plateau 28 Jul 2005 17:42

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

prawn 28 Jul 2005 18:24

Quote:

Originally Posted by mrgizmo
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.

Same for me.

Barakat 29 Jul 2005 00:13

Quote:

Originally Posted by mrgizmo
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.

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

Neal-UK 29 Jul 2005 00:52

Quote:

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

blank for me to and the error also

Neal-UK 29 Jul 2005 00:54

Quote:

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 29 Jul 2005 01:27

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 29 Jul 2005 01:32

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 29 Jul 2005 01:51

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 29 Jul 2005 02:12

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


All times are GMT. The time now is 18:56.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.