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!

[Allan]

So i work now, i'm changed manual in database the query

Good, i'm a error, the link which the hack gives us does not work home and to the others also, the page di link is white and reloads ceaselessly

[derekivey]

Huh? What link?

Also,
[sql]
ALTER TABLE `toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;
[/sql]

There are 2 ;'s in that, that is why it didn't work.

[Allan]

this link for example:

<a href="http://www.yoursite.com/forum/in.php?id=1" target="_BLANK">yoursite</a>

don't work, reload, and reload, and reload etc ....

[derekivey]

Did you set your IN Click URL in the AdminCP on the settings page? You need to set it to like your forums url or your main site's url.

[puertoblack2003]

i have one problem i followed instruction in the other post but did not work maybe you can look at this when trying the rating system.

database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='1' && username='xxxxxx;

MySQL Error : Table 'puertotech.toplist_ratings' doesn't exist
Error Number : 1146
Date : Tuesday, December 6th 2005 @ 02:30:00 PM
Script : http://www.xxxxxxxxx/toplist.php?do=rate&id=1
Referrer : http://xxxxxxxx/toplist.php
IP Address : xxx.xxxx.xxxx
Username : love
Classname : vb_database

[Allan]

Originally Posted by derekivey

Did you set your IN Click URL in the AdminCP on the settings page? You need to set it to like your forums url or your main site's url.

So Derekivey, i'm stupid , i work !

File Attach: French Language for Version 1.0.4

[derekivey]

Thanks for Translating it Allan .

@nievesidenshop:

Manually execute these queries in the AdminCP or PHPMyAdmin, sorry for the inconvenience, for some reason the product system isn't executing them.

[sql]
CREATE TABLE `YOUR_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;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;

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

Please replace YOUR_TABLE_PREFIX_ with the prefix you use for your tables (if you use one, if not just delete YOUR_TABLE_PREFIX_).

[puertoblack2003]

ok having problems now..trying to uninstalled and reinstalled producted?

uninstalled ok, when trying to reinstall got this error:

Database error in vBulletin 3.5.1:

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, December 6th 2005 @ 03:01:35 PM
Script : http://www.xxx.com/admincp/plugin.php
Referrer : http://www.xxx.com/admincp/plugin.php?do=productadd
IP Address : 1xx.xxx.xxxx.
Username : LOVE
Classname : vb_database

[puertoblack2003]

Originally Posted by derekivey

Thanks for Translating it Allan .

@nievesidenshop:

Manually execute these queries in the AdminCP or PHPMyAdmin, sorry for the inconvenience, for some reason the product system isn't executing them.

[sql]
CREATE TABLE `YOUR_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;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;

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

Please replace YOUR_TABLE_PREFIX_ with the prefix you use for your tables (if you use one, if not just delete YOUR_TABLE_PREFIX_).

yea didn't see this message...ok i did run that but it was still giving me an error so i uninstalled it and try to installed it again and the error below ...soory didn't see that..

[derekivey]

Ok, for those of you who had problems with the database, I have uploaded a new zip file. Please try importing the .xml file in it. I had the install code set for version 1.0.3, when it should have been 1.0.4. It should now execute the queries. If anyone still has problems, please let me know.

Thanks,
Derek