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]

Current translation ......

[TheProphet]

Great thanks m8, thumbs up, this is just what i needed...

[trackpads]

I am getting this error when I import the product and cannot figure out why:

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'toplist_enabled',
'toplist_options',
'1',
'1',
'free',
'yesno',
10,
0,
1,
'toplist'
),
(
'disabled_message',
'toplist_options',
'The Toplist is Currently Disabled. Please Come Back Later.',
'The Toplist is Currently Disabled. Please Come Back Later.',
'free',
'textarea',
20,
0,
1,
'toplist'
),
(
'rank_by_in',
'toplist_options',
'1',
'1',
'free',
'yesno',
30,
0,
1,
'toplist'
),
(
'toplist_count_out_from_guests',
'toplist_options',
'0',
'0',
'free',
'yesno',
40,
0,
1,
'toplist'
),
(
'toplist_limit_out_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
50,
0,
1,
'toplist'
),
(
'toplist_out_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
60,
0,
1,
'toplist'
),
(
'toplist_limit_in_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
70,
0,
1,
'toplist'
),
(
'toplist_in_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
80,
0,
1,
'toplist'
),
(
'toplist_allowed_user_groups',
'toplist_options',
'2,5,6,7',
'2,5,6,7',
'free',
'',
90,
0,
1,
'toplist'
),
(
'toplist_allow_member_edit',
'toplist_options',
'1',
'1',
'free',
'yesno',
100,
0,
1,
'toplist'
),
(
'toplist_allowed_to_moderate',
'toplist_options',
'5,6,7',
'5,6,7',
'free',
'',
110,
0,
1,
'toplist'
),
(
'',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_disable_html',
'toplist_options',
'1',
'1',
'free',
'yesno',
130,
0,
1,
'toplist'
),
(
'toplist_moderate_sites',
'toplist_options',
'0',
'0',
'free',
'yesno',
140,
0,
1,
'toplist'
),
(
'toplist_email_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
150,
0,
1,
'toplist'
),
(
'toplist_email_users',
'toplist_options',
'1',
'1',
'free',
'',
160,
0,
1,
'toplist'
),
(
'toplist_pm_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
170,
0,
1,
'toplist'
),
(
'toplist_pm_from_user',
'toplist_options',
'1',
'1',
'free',
'',
180,
0,
1,
'toplist'
),
(
'toplist_pm_users',
'toplist_options',
'1',
'1',
'free',
'',
190,
0,
1,
'toplist'
),
(
'sites_per_page',
'toplist_options',
'15',
'15',
'free',
'',
200,
0,
1,
'toplist'
),
(
'toplist_in_redirect_url',
'toplist_options',
'',
'',
'free',
'',
210,
0,
1,
'toplist'
),
(
'toplist_number_of_sites',
'toplist_options',
'1',
'1',
'free',
'',
220,
0,
1,
'toplist'
),
(
'toplist_max_height',
'toplist_options',
'31',
'31',
'free',
'',
230,
0,
1,
'toplist'
),
(
'toplist_max_width',
'toplist_options',
'88',
'88',
'free',
'',
240,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Thursday, November 24th 2005 @ 10:07:17 AM
Script : http://www.trackpads.com/forum/.../plugin.php
Referrer : http://www.trackpads.com/forum/.../p...?do=productadd
IP Address : 68.47.97.220
Username : Hannibal
Classname : vb_database

thanks!

[derekivey]

Do you already have this hack installed? That error means those settings exist already.

[trackpads]

Originally Posted by derekivey

Do you already have this hack installed? That error means those settings exist already.

I thought the same thing even though I didnt. I had the affiliate hack installed but removed it aswell as installed this one and then removed it too just to see if I could clear it.

I looked in phpmyadmin for any of those variables in the settings table but found nothing. Any idea what else I should check?

Thanks again for the help,

-Jason

[trackpads]

Just checked the table and this is the first one that didnt get put in and there is no duplicate:

(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),

Any ideas?

[trackpads]

Originally Posted by trackpads

Just checked the table and this is the first one that didnt get put in and there is no duplicate:

(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),

Any ideas?

Found it!

Wierd though, one of the varnames in my settings table was blank? That was what was breaking the import of this product.

All works now.

thanks!!

[derekivey]

Try executing this query in phpmyadmin or the query page in the vB AdminCP, and see if it returns anything.

[sql]SELECT * FROM setting WHERE varname='toplist_enabled'[/sql]

Derek

EDIT: Ok lol, glad you got it to work

[trackpads]

Originally Posted by derekivey

Try executing this query in phpmyadmin or the query page in the vB AdminCP, and see if it returns anything.

[sql]SELECT * FROM setting WHERE varname='toplist_enabled'[/sql]

Derek

EDIT: Ok lol, glad you got it to work

Thank you for the help, this is a really, really nice hack. Kudos!!!

[derekivey]

Thanks Glad you like it!

Derek