Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Toplist Details »»
Toplist
Version: 2.0.0, by derekivey derekivey is offline
Developer Last Online: Jan 2010 Show Printable Version Email this Page

Version: 3.5.8 Rating:
Released: 10-17-2005 Last Update: 01-04-2007 Installs: 412
DB Changes Uses Plugins Template Edits Auto-Templates
Additional Files Translations  
No support by the author.

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!

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #412  
Old 01-08-2006, 12:24 PM
loonytune15's Avatar
loonytune15 loonytune15 is offline
 
Join Date: Mar 2003
Location: Loony Bin
Posts: 357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks for the maquee fix. Drop into my website, one of my designers may be able to help you out with that image.
Reply With Quote
  #413  
Old 01-08-2006, 06:17 PM
foreverdarkness's Avatar
foreverdarkness foreverdarkness is offline
 
Join Date: Dec 2004
Location: Pittsburgh
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Every time i try to do the update and import the new product, i check the allow overwrite but it keeps saying the different sql databases already exist...I have even deleted every part of the toplist from my database and I still get the same errors. Please help!!!
Reply With Quote
  #414  
Old 01-08-2006, 06:55 PM
derekivey derekivey is offline
 
Join Date: Apr 2005
Location: Pennsylvania, USA
Posts: 1,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you paste the error for me please?

Thanks.
Reply With Quote
  #415  
Old 01-08-2006, 07:00 PM
foreverdarkness's Avatar
foreverdarkness foreverdarkness is offline
 
Join Date: Dec 2004
Location: Pittsburgh
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO vb3_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</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_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'
),
(
'toplist_popup_height',
'toplist_options',
'220',
'220',
'free',
'',
250,
0,
1,
'toplist'
),
(
'toplist_popup_width',
'toplist_options',
'250',
'250',
'free',
'',
260,
0,
1,
'toplist'
),
(
'toplist_show_forumhome_images',
'toplist_options',
'0',
'0',
'free',
'yesno',
270,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_direction',
'toplist_options',
'left',
'left',
'free',
'',
280,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_scrollamount',
'toplist_options',
'5',
'5',
'free',
'',
290,
0,
1,
'toplist'
),
(
'toplist_forumhome_number_of_images',
'toplist_options',
'0',
'0',
'free',
'',
300,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Sunday, January 8th 2006 @ 03:45:03 PM

This is the error I get when importing the product and selecting to overwrite the existing one.

In my admin panel everything is there except toplist options...and on the toplist.php there is no place to add a site to it.
Reply With Quote
  #416  
Old 01-08-2006, 11:14 PM
derekivey derekivey is offline
 
Join Date: Apr 2005
Location: Pennsylvania, USA
Posts: 1,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,

Can you PM me admin access details, and PHPMyAdmin info please so I can take a look?

Thanks,
Derek
Reply With Quote
  #417  
Old 01-08-2006, 11:57 PM
foreverdarkness's Avatar
foreverdarkness foreverdarkness is offline
 
Join Date: Dec 2004
Location: Pittsburgh
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I got that error fixed that i post i now have a different error. It is when i try to go to the toplist.php page. It works fine when its disabled but when enabled i get this error.


At the top of the page it says
Warning: Division by zero in /toplist.php on line 146

Warning: Division by zero in /includes/functions.php on line 1809

then

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM vb3_toplist_sites WHERE status='active' ORDER BY `in` DESC LIMIT 0,;

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 '' at line 1
Error Number : 1064
Date : Sunday, January 8th 2006 @ 08:39:35 PM
Script : http://www.foreverdarkness.com/forum/toplist.php
Reply With Quote
  #418  
Old 01-09-2006, 09:36 AM
derekivey derekivey is offline
 
Join Date: Apr 2005
Location: Pennsylvania, USA
Posts: 1,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Check to make sure sites per page in the Toplist options isn't set to 0.
Reply With Quote
  #419  
Old 01-09-2006, 01:02 PM
foreverdarkness's Avatar
foreverdarkness foreverdarkness is offline
 
Join Date: Dec 2004
Location: Pittsburgh
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by derekivey
Check to make sure sites per page in the Toplist options isn't set to 0.
I dont see where that is located...it is not in my toplist options and I also searched it in my database and could not find it. Please help.
Reply With Quote
  #420  
Old 01-09-2006, 06:59 PM
derekivey derekivey is offline
 
Join Date: Apr 2005
Location: Pennsylvania, USA
Posts: 1,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Should be at http://www.yourdomain.com/forums/adm...oplist_options

Try finding Sites Per Page on that page. If it's not there, you need to reimport the xml file because your settings must be missing then.
Reply With Quote
  #421  
Old 01-09-2006, 11:03 PM
foreverdarkness's Avatar
foreverdarkness foreverdarkness is offline
 
Join Date: Dec 2004
Location: Pittsburgh
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually there was an error in the xlp product file...duplicate part at the end.

<setting varname="" displayorder="120">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="toplist_open_in_new_window" displayorder="120">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>

cause the error i originally had up top.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:16 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.14704 seconds
  • Memory Usage 2,329KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete