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!

[chriszep]

hello when I upload product-toplist.xml

i have this

atabase error in vBulletin 3.5.3:

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

MySQL Error : Duplicate column name 'status'
Error Number : 1060
Date : Tuesday, April 25th 2006 @ 11:36:24 AM
Script : http://www.xxxxxxxxxxxxxx.com/forums/admincp/plugin.php
Referrer : http://www.xxxxxxxxxxxxxx.com/forums...?do=productadd
IP Address : xxxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxxxxxxxxxxxx
Classname : vb_database

Thanks

[derekivey]

Try removing that query from the install code in the XML file and try reimporting it again, or if there are no sites on your toplist yet, you can drop all of the toplist_* tables and reimport.

Derek

[Ramsesx]

Originally Posted by derekivey

Are you running the latest version (1.0.7) of my hack? It looks like you are missing the views field. If you are not upgraded yet, please upgrade, but if you did, just execute this query in vB's admincp or PHPMyAdmin.
[sql]ALTER TABLE `vb3_toplist_sites` ADD `views` INT( 25 ) UNSIGNED NOT NULL;[/sql]

Derek

Sorry, you're right I don't have the latest version.
One wish for a next version, could you make an option for disabling the rating system because I have some user rating the concurrent sites bad.
Thank you

[derekivey]

Sure, I will add that option. I might also add a banning option.

Derek

[cat4m]

I keep getting this error when I try to add an image to the site :
Warning: getimagesize(/home/lovespir/public_html/loveforum/images/toplist/buttons/sites/trcv75d4FUtp179je4ne): failed to open stream: No such file or directory in /admincp/toplist_admin.php on line 393
Can anyone help at all. I have been looking through the thread but cant find anything that works. Thanks in advance.

[derekivey]

Make sure the /images/toplist/buttons/sites folder exists and is writable (chmod 777).

[chriszep]

Originally Posted by derekivey

Try removing that query from the install code in the XML file and try reimporting it again, or if there are no sites on your toplist yet, you can drop all of the toplist_* tables and reimport.

Derek

ok I made it but another error with duplicate

Database error in vBulletin 3.5.3:

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

MySQL Error : Duplicate column name 'status'
Error Number : 1060
Date : Thursday, April 27th 2006 @ 12:07:11 PM
Script : http://xxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://xxxxxxxxxxxxxxxxxxxx/forums/a...?do=productadd
IP Address : xxxxx
Username : Cxxxx
Classname : vb_database

how to uninstall everything in the data base ?

[derekivey]

You have to use PHPMyAdmin to remove all the toplist_* tables, and there is a field in the usergrouppermissions table.

Derek

[cat4m]

Originally Posted by derekivey

Make sure the /images/toplist/buttons/sites folder exists and is writable (chmod 777).

How do I make it writable ? And what is chmod 777 ? Sorry I dont know much about this. Everything else is working but the image picture.

[derekivey]

There should be a feature in your FTP program to let you give it write permissions. If you can't find it talk to your webhosting provider. They should be able to help you out.

Derek