The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Toplist Details »» | |||||||||||||||||||||||||
Toplist
Developer: derekivey Version: 2.0.0 vBulletin Version: 3.5.5 (Seems to work fine on 3.6.0) File Edits: 0 Template Edits: 2 (Optional) New Phrases: 294 Uses Plugins: Yes! Difficulty: Easy Description: This hack adds a Toplist to your forums. You can choose in the AdminCP whether to rank the sites by their In hits or their Out hits. It is fully phrased to make it easy to translate to another language if you need to. The users are able to add a site, edit, or delete their site if they added it. The Administrators can Edit the users' sites or Delete them. This hack is for vBulletin 3.5.5. *** I Strongly Recommend That You Backup Your Database Before Installing/Upgrading This Hack! *** Planned features for a later release:
The change log is now available here. Screen Shots I have added screen shots of this hack in action below. More screenshots are located here. Demo You can find demo information here. Translations You can find a French translation of this hack here. For a How To on Editing the Dynamic Image, See this Post. Please click Install you installed this hack. Thanks! Supporters / CoAuthors Show Your Support
|
Comments |
#962
|
|||
|
|||
If you just transfered everything, you shouldn't have to reinstall the Toplist itself. If you want to do a fresh install, just delete the product, and delete any Toplist_ tables that vB's product manager left, and import the XML file again to install.
Derek |
#963
|
|||
|
|||
The hack was actually uninstalled during the move, it's just those tables stuck around...
How do I remove the tables? |
#964
|
|||
|
|||
After installing the toplist hack. I am unable to set permissions . I get a database error.
Having looked in the database I have no toplist permissions column. I have set the toplist up on our test site which works flawlessy . Any ideas whats going wrong? the database error I get is Database error in vBulletin 3.5.4: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Administrators', `description` = '', `usertitle` = 'Administrator', `opentag` = '<span style=\"color: red;\">', `closetag` = '</span>', `passwordexpires` = '0', `passwordhistory` = '0', `forumpermissions` = '1048575', `attachlimit` = '5000000', `pmquota` = '500', `pmpermissions` = '3', `pmsendmax` = '5', `calendarpermissions` = '63', `wolpermissions` = '31', `adminpermissions` = '3', `genericpermissions` = '205520831', `genericoptions` = '31', `profilepicmaxwidth` = '120', `profilepicmaxheight` = '150', `profilepicmaxsize` = '200000', `avatarmaxwidth` = '120', `avatarmaxheight` = '150', `avatarmaxsize` = '200000', `toplistpermissions` = '1' WHERE usergroupid=6; MySQL Error : Unknown column 'toplistpermissions' in 'field list' Error Number : 1054 Date : Sunday, July 23rd 2006 @ 08:48:09 PM Script : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php Referrer : http://www.iz-grafix.co.uk/forums/ad...&usergroupid=6 IP Address : ******** Username : ******** Classname : vb_database |
#965
|
|||
|
|||
Quote:
[sql]DELETE TABLE IF EXISTS toplist_categories; DELETE TABLE IF EXISTS toplist_clicks; DELETE TABLE IF EXISTS toplist_ratings; DELETE TABLE IF EXISTS toplist_reports; DELETE TABLE IF EXISTS toplist_sites;[/sql] If you have a table prefix, don't forget to add that to each of the lines above. After that has been done, reinstall the Toplist hack and let me know if you have anymore problems. Quote:
Execute the following SQL in PHPMyAdmin. [sql]ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;[/sql] Be sure to add your table prefix to that if you have one. Derek |
#966
|
|||
|
|||
Thanks for the quick reply though it didn't fix my problem.
After running the query I got this error Error SQL query: ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ; MySQL said: #1060 - Duplicate column name 'arcadepermissions' |
#967
|
|||
|
|||
Hmm, thats weird. Can you open PHPMyAdmin, and see if there are two columns called arcadepermissions, and see if the toplistpermissions column is there at all?
Thanks, Derek |
#968
|
|||
|
|||
I don't have more than one arcadepermissions table and still don't have a toplistpermissions table either.
What I did see was this below, should I have multiple index files?, the error at the bottom makes me think not. |
#969
|
|||
|
|||
Hello Derek - today I noticed we are having another problem - few days ago I have installed the newest version of mod - our toplist is using ranking method by views - today I saw that one user was raising the counter views continously within 5 min - of course his site was raising up in the toplist also I looked closely to other sites and noticed that there is second site with very strange views record
we are having counts form guests disabled, there is a Limit The Number Of Clicks Out For Each User and it is set to 1, we also turn on Limit The Number Of Clicks In For Each IP Address - so why this not situation is going on - maybe this option are only for In Hits and Out Hits ?? |
#970
|
|||
|
|||
Quote:
Quote:
Derek |
#971
|
|||
|
|||
Quote:
I would like to ask how is views ranking method counted - is it summary of in out and views ?? thanks again for such fantastic support |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|