Toplist

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:

• Add Image Storage Setting (hot linking or upload)
• Add Stats Page [ Will be released later ]
• Add API to get site info onto non-vB pages and other vB pages.
• Add Site Comment System
• Fix bug with & not being allowed in URLs [ Done ]
• Add Setting to choose where to put Toplist Sites Marquee
• Whatever else is suggested

Change Log
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!

[divided_by_fear]

kk one sec ill try

[derekivey]

You might get an error in that one, if so please redownload and import the new .xml file. I was missing a " in the install code.

[divided_by_fear]

nope did the same thing... i did overwrite and all...

[derekivey]

Try the file I just uploaded please.

[divided_by_fear]

nah its still giving the same error

[derekivey]

Hmm I'll take a look and get back to you in a few mins.

[divided_by_fear]

ok np this is the error it gives

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='2' && username='MindWalker';

MySQL Error : Table '*******_**********.toplist_ratings' doesn't exist

[derekivey]

Ok, try again please.

If it doesn't work, just execute this query in the AdminCP:
[sql]
CREATE TABLE `".TABLE_PREFIX."toplist_ratings` (
`id` int(10) NOT NULL auto_increment,
`site_id` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`rating` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
[/sql]

[divided_by_fear]

it wont even let me do it through php admin

#1103 - Incorrect table name '".TABLE_PREFIX."toplist_ratings'

[divided_by_fear]

is there a way i can do it with out the table prefix