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!

[Ramsesx]

Hi derek, I changed my site to a new server and new domain now I get this error:

PHP Code:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_toplist_sites SET out=out+1 WHERE id='27';

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 'out=out+1 WHERE id='27'' at line 1
Error Number : 1064
Date         : Friday, May 5th 2006 @ 03:37:23 AM
Script       : http://www.mydomain.de/forum/out.php?id=27
Referrer     : http://www.mydomain.de/index.php
IP Address   : 87.123.18.57
Username     : MC
Classname    : vb_database 


Please can you give me a hint where i need to look? Thank you.

[derekivey]

I'm not too sure. I would have to take a look at it. Can you please PM me the URL to your site so I can take a look?

Thanks,
Derek

[ubblite]

derekivey,

Any luck with a solution to my above posted problem?

Thanks

[derekivey]

Can you PM me a link to your site as well so I can look at it?

Thanks,
Derek

[chriszep]

Originally Posted by derekivey

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

Derek

ok I have done it , remove everything with "toplist" (made a search in PHPMyAdmin ) and remove field in the usergrouppermissions table.
now when I ulpload the product , i have this :

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 : Monday, May 8th 2006 @ 01:18:09 PM
Script : http://xxxxxxxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://xxxxxxxxxxxxxxxx/forums/admin...?do=productadd
IP Address : xxxxxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxx
Classname : vb_database

thanks

[derekivey]

Remove that code from the install code and try again.

ALTER TABLE `" . TABLE_PREFIX . "toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;

[lasor]

Excellent Job Thanks....

One question on frontpage is the anyway to open links in new window. I have selected this option in the acp options and it works fine on my toplist page but the links on the frontpage do not open in new window?

Thanks

[derekivey]

The CMPS module might not have that yet, I'm not sure if I added it or not. You can easilly add it by editing the module's template though.

Derek

[lasor]

Thanks for that...But can give me a little more of a clue..Sorry Im not an 100% upto date with vBulletin and coding...

Thanks again

[lasor]

Another really cool option would be the ability to disable indevidual banners from being displaid on the front page. I am pretty sure there must be a pretty simple way of doing this...