The Arcive of Official vBulletin Modifications Site.

Toplist · **Released**: 10-17-2005

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!

derekivey · #**962** 07-23-2006, 02:21 PM

If you just transfered everything, you shouldn't have to reinstall the Toplist itself. If you want to do a fresh install, just delete the product, and delete any Toplist_ tables that vB's product manager left, and import the XML file again to install.

Derek

Lena Starling · #**963** 07-23-2006, 03:19 PM

The hack was actually uninstalled during the move, it's just those tables stuck around...

How do I remove the tables?

Izza · #**964** 07-23-2006, 06:52 PM

After installing the toplist hack. I am unable to set permissions . I get a database error.
Having looked in the database I have no toplist permissions column.

I have set the toplist up on our test site which works flawlessy .

Any ideas whats going wrong?

the database error I get is

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '5000000',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '120',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '150',
`avatarmaxsize` = '200000',
`toplistpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'toplistpermissions' in 'field list'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 08:48:09 PM
Script : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php
Referrer : http://www.iz-grafix.co.uk/forums/ad...&usergroupid=6
IP Address : ********
Username : ********
Classname : vb_database

derekivey · #**965** 07-24-2006, 01:26 AM

Quote:

Originally Posted by Lena Starling

The hack was actually uninstalled during the move, it's just those tables stuck around...

How do I remove the tables?

Execute the following code in PHPMyAdmin...

[sql]DELETE TABLE IF EXISTS toplist_categories;
DELETE TABLE IF EXISTS toplist_clicks;
DELETE TABLE IF EXISTS toplist_ratings;
DELETE TABLE IF EXISTS toplist_reports;
DELETE TABLE IF EXISTS toplist_sites;[/sql]

If you have a table prefix, don't forget to add that to each of the lines above.

After that has been done, reinstall the Toplist hack and let me know if you have anymore problems.

Quote:

Originally Posted by Izza

After installing the toplist hack. I am unable to set permissions . I get a database error.
Having looked in the database I have no toplist permissions column.

I have set the toplist up on our test site which works flawlessy .

Any ideas whats going wrong?

the database error I get is

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '5000000',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '120',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '150',
`avatarmaxsize` = '200000',
`toplistpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'toplistpermissions' in 'field list'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 08:48:09 PM
Script : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php
Referrer : http://www.iz-grafix.co.uk/forums/ad...&usergroupid=6
IP Address : ********
Username : ********
Classname : vb_database

Looks like the product installer didn't add the column to the usergroup table.

Execute the following SQL in PHPMyAdmin.

[sql]ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;[/sql]

Be sure to add your table prefix to that if you have one.

Derek

Izza · #**966** 07-24-2006, 07:56 AM

Thanks for the quick reply though it didn't fix my problem.

After running the query I got this error

Error
SQL query:

ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ;

MySQL said:

#1060 - Duplicate column name 'arcadepermissions'

derekivey · #**967** 07-24-2006, 03:20 PM

Hmm, thats weird. Can you open PHPMyAdmin, and see if there are two columns called arcadepermissions, and see if the toplistpermissions column is there at all?

Thanks,
Derek

Izza · #**968** 07-24-2006, 06:40 PM

I don't have more than one arcadepermissions table and still don't have a toplistpermissions table either.

What I did see was this below, should I have multiple index files?, the error at the bottom makes me think not.

Dj. Gargamel · #**969** 07-25-2006, 06:26 AM

Hello Derek - today I noticed we are having another problem - few days ago I have installed the newest version of mod - our toplist is using ranking method by views - today I saw that one user was raising the counter views continously within 5 min - of course his site was raising up in the toplist also I looked closely to other sites and noticed that there is second site with very strange views record

we are having counts form guests disabled, there is a Limit The Number Of Clicks Out For Each User and it is set to 1, we also turn on Limit The Number Of Clicks In For Each IP Address - so why this not situation is going on - maybe this option are only for In Hits and Out Hits ??

derekivey · #**970** 07-25-2006, 01:09 PM

Quote:

Originally Posted by Izza

I don't have more than one arcadepermissions table and still don't have a toplistpermissions table either.

What I did see was this below, should I have multiple index files?, the error at the bottom makes me think not.

Don't worry about indexes... Click structure at the top to see if they are there.

Quote:

Originally Posted by Dj. Gargamel

Hello Derek - today I noticed we are having another problem - few days ago I have installed the newest version of mod - our toplist is using ranking method by views - today I saw that one user was raising the counter views continously within 5 min - of course his site was raising up in the toplist also I looked closely to other sites and noticed that there is second site with very strange views record

we are having counts form guests disabled, there is a Limit The Number Of Clicks Out For Each User and it is set to 1, we also turn on Limit The Number Of Clicks In For Each IP Address - so why this not situation is going on - maybe this option are only for In Hits and Out Hits ??

Yeah those options are only for clicks in and out. Maybe I should add a setting to either count uniques or count all page views. I can probably make it so when it's set to uniques, have it only count them once in a certain time period (say 1 day or what ever). What do you think?

Derek

Dj. Gargamel · #**971** 07-25-2006, 03:23 PM

Quote:

Originally Posted by derekivey

Yeah those options are only for clicks in and out. Maybe I should add a setting to either count uniques or count all page views. I can probably make it so when it's set to uniques, have it only count them once in a certain time period (say 1 day or what ever). What do you think?

Derek

It would be perfect -
I would like to ask how is views ranking method counted - is it summary of in out and views ??

thanks again for such fantastic support

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08615 seconds Memory Usage 2,323KB 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 (5)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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!