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]

I have no chance
I deleted everything in my sql base
but when I upload the product

Database error in vBulletin 3.5.3:

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'
),
(
'toplist_ranking_method',
'toplist_options',
'0',
'0',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0,\'selected=\"selected\"\') . \">In Hits</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1,\'selected=\"selected\"\') . \">Out Hits</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2,\'selected=\"selected\"\') . \">Rating</option>\r\n<option value=\\\"3\\\" \" . iif($setting[\'value\']==3,\'selected=\"selected\"\') . \">Views</option>\r\n</select>',
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_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
90,
0,
1,
'toplist'
),
(
'toplist_disable_html',
'toplist_options',
'1',
'1',
'free',
'yesno',
100,
0,
1,
'toplist'
),
(
'toplist_moderate_sites',
'toplist_options',
'0',
'0',
'free',
'yesno',
110,
0,
1,
'toplist'
),
(
'',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_email_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_email_users',
'toplist_options',
'1',
'1',
'free',
'',
130,
0,
1,
'toplist'
),
(
'toplist_pm_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
140,
0,
1,
'toplist'
),
(
'toplist_pm_from_user',
'toplist_options',
'1',
'1',
'free',
'',
150,
0,
1,
'toplist'
),
(
'toplist_pm_users',
'toplist_options',
'1',
'1',
'free',
'',
160,
0,
1,
'toplist'
),
(
'sites_per_page',
'toplist_options',
'15',
'15',
'free',
'',
170,
0,
1,
'toplist'
),
(
'toplist_in_redirect_url',
'toplist_options',
'',
'',
'free',
'',
180,
0,
1,
'toplist'
),
(
'toplist_number_of_sites',
'toplist_options',
'1',
'1',
'free',
'',
190,
0,
1,
'toplist'
),
(
'toplist_max_height',
'toplist_options',
'31',
'31',
'free',
'',
200,
0,
1,
'toplist'
),
(
'toplist_max_width',
'toplist_options',
'88',
'88',
'free',
'',
210,
0,
1,
'toplist'
),
(
'toplist_popup_height',
'toplist_options',
'220',
'220',
'free',
'',
220,
0,
1,
'toplist'
),
(
'toplist_popup_width',
'toplist_options',
'250',
'250',
'free',
'',
230,
0,
1,
'toplist'
),
(
'toplist_show_forumhome_images',
'toplist_options',
'0',
'0',
'free',
'yesno',
240,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_direction',
'toplist_options',
'left',
'left',
'free',
'',
250,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_scrollamount',
'toplist_options',
'5',
'5',
'free',
'',
260,
0,
1,
'toplist'
),
(
'toplist_forumhome_number_of_images',
'toplist_options',
'0',
'0',
'free',
'',
270,
0,
1,
'toplist'
),
(
'toplist_max_image_size',
'toplist_options',
'5000',
'5000',
'free',
'',
280,
0,
1,
'toplist'
),
(
'toplist_number_of_in_hits_until_banner_shows',
'toplist_options',
'0',
'0',
'free',
'',
290,
0,
1,
'toplist'
),
(
'toplist_show_user_banners',
'toplist_options',
'1',
'1',
'free',
'yesno',
300,
0,
1,
'toplist'
),
(
'toplist_check_if_code_exists',
'toplist_options',
'0',
'0',
'free',
'yesno',
310,
0,
1,
'toplist'
),
(
'toplist_use_custom_in_rank_image',
'toplist_options',
'0',
'0',
'free',
'yesno',
320,
0,
1,
'toplist'
),
(
'toplist_custom_in_rank_image_extension',
'toplist_options',
'gif',
'gif',
'free',
'',
330,
0,
1,
'toplist'
),
(
'toplist_count_site_page_views',
'toplist_options',
'0',
'0',
'free',
'yesno',
340,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Thursday, June 8th 2006 @ 10:59:38 PM
Script : http://www.xxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://www.xxxxxxxxxxxxxx.com/forums...?do=productadd
IP Address : 8xxxxxxxxxxxxx2
Username : xxxxxxxxxxxxxx
Classname : vb_database

[Equinox6]

Hi realy quick question, is there enyway i can change the name so it shows on the navbar as something else apart from 'toplist' i want to use this as more of a affiliates thing?

Is it possable?

Regards,

-Equinox

[derekivey]

Sorry, looks like vBulletin messed up my XML file. Please try the attached one, and let me know if it works. Zip file has been updated too.

Thanks,
Derek

[derekivey]

Originally Posted by Equinox6

Hi realy quick question, is there enyway i can change the name so it shows on the navbar as something else apart from 'toplist' i want to use this as more of a affiliates thing?

Is it possable?

Regards,

-Equinox

Sure is, just edit the text in the phrase called 'toplist' (w/o the quotes), don't change the var name, but for the English Translation just type Affiliates or what ever you want.

Let me know if you have any problems.

Thanks,
Derek

[Mr.D]

Originally Posted by derekivey

Hmm, I thought I added that phrase. I might have accidentally selected a different product for it, I'll take a look. For your 2nd problem, make sure when you hover over the link it says something like &id=somenumber

Derek

yes it hase id something like this and i think the id is wrong

?do=viewvotes&id%20=%201

and the banner doesent show on admincp on all pages. And when will you add that phrase in there

Could not find phrase 'error_toplist_site_pending_moderation'.

[derekivey]

Can you PM me admin details so I can check this out please?

Thanks,
Derek

[derekivey]

Sorry, I have added the missing phrase. Please reimport the attached xml file and select yes to overwrite. Zip file has been updated as well.

Derek

[michaelsilvia]

I am getting this error when uploading a .jpg file.

Sorry, your image could not be uploaded because the format of it is not allowed. Allowed formats are GIF, JPEG, and PNG

The format of the file you uploaded is .

Please go back and select a new image or leave the image field blank.

How can I change the type of images that can be uploaded?

[derekivey]

Hi, can you please send me the image so I can try and fix the bug? This has never happened to me so I need to take a look at it and see whats wrong.

Thanks,
Derek

[derfelix]

Hi Derek
Big thumbs up.. havent updated yet cause im just upgrading vbulletin..
but looks great with all the new features!!!

may i add a couple of wishes for next release???
(i'm comparing the features to my existing external toplist)

functionality:
- add a cron to reset the counts..
why? because if any new sites are added.. they will never be able to move up if some sites have been there for years with thousands of ins and outs. (usually i have a cron on a weekly base ... but a reset once a month would be fine also)

- add a cache to the generated banners
if the site that uses the stats banner has 1.000.000 hits a day.. it will be generated 1.000.000 times ON YOUR SERVER. (cache update once an hour or day.. or only if things change)

- change the layout to standard banners 468x60
When using the standard banners.. the layout gets to wide specially if you are using a left navigation block.. it would be, for those banners much nicer if the banner was between site title and description, not needing an extra column.

- only show banners for the first 10 or 20 or 30 sites
the banners for the others should not appear. (sort of reward for good sites)

Last .. but this is just the frosting on the pie

- have a plus [+] minus [-] or equal [=] sign near the ranking
so users would know if this site is coming up or loosing rank.. example i a site is ranked 4 it would have a symbol besides the rank (or somewhere else) if the former rank was 3 it would be a [-] .. if the former rank was 10 it would be a [+].. and if nothing has changed.. ie. the former rank was 4 in the last 24 hours so.. it would be [=]... hmm i'll check with my toplist pro what criteria they use for [=]

sorry if one of these features is allready implemented.. as i said i will only be upgrading during the week. (I only looked at the changelog)
But I think its great and looks very professional now!!!!!

And last... just had an idea.. and i dunno if its easy to implement..
- if a user has a homepage in his profile, add a little checkbox in his settings so he can have it added automatically to the toplist (it should tell him to add a banner as soon as possible)

thats all for now.. no more ideas

Felix