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!

[loonytune15]

Originally Posted by derekivey

Category system is on my list of things to add. I also plan to add an option that allows you to add a random site to the forum home, note this will be optional and can be turned off in the AdminCP.

Sounds good, both be very good additions. Will serve well as an affiliate hack.

[loonytune15]

ok I have had to run the last 2 queries above and with the last one I got this error.
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';

ALTER TABLE `toplist_sites` ADD `votes` INT( 10 ) DEFAULT

It still wont show any ratings.
in the admin cp under toplist sites, it dont show the ratings either, but when you click to view the individual site, it shows in there.

[derekivey]

Hmm looks like your missing part of the query.

Try this:

[sql]
ALTER TABLE `toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;
[/sql]

[loonytune15]

nope that didn't work either..
An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'rating_total' in 'toplist_sites'
I got that error running that on its own.

I changed the other query and got the first error again.

[derekivey]

Hmm, looks like your missing that field also, run these queries:
[sql]
ALTER TABLE `toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;
ALTER TABLE `toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;
ALTER TABLE `toplist_sites` ADD `rating_average` INT( 10 ) DEFAULT '0' NOT NULL AFTER `votes`;
[/sql]

Sorry for the trouble, not sure why the plugin system didn't execute those queries. Once you run those it should work.

[loonytune15]

I am idiot, I didn't realize that these needed to be run seperately.

All seems to work now except it wont accpt the earlier attempts at voting.

[derekivey]

If you know who voted, and for what site, you can easily add their votes by editing the database..

[Allan]

error:

Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE `toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;;

MySQL Error  : Duplicate column name 'rating_total'
Error Number : 1060
Date         : Tuesday, December 6th 2005 @ 11:17:47 AM
Script       : http://www.xxxxxxx.com/xxxxxx/admincp/plugin.php
Referrer     : http://www.xxxxxxx.com/xxxxxx/admincp/plugin.php?do=productadd
IP Address   : 82.xxxxx.0.xxxx
Username     : xxxxxxxx
Classname    : vb_database

[derekivey]

That means you already have that one in the database, just edit the .xml file and remove that query from the install code, and try it again, it should work after you do that.

[Allan]

Invalid SQL:
ALTER TABLE `toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;