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!

[Dj. Gargamel]

hello - I just installed this great mod but I am having a problem - everything is working correctly till the moment I am choosing a category of sites to view - sites are displayed only when View All Sites option is turned on - when we are trying to sort sites by category none of pages is being shown (one random site is displaying always at top)

[puregraf]

hi im getting this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE status = 'inactive';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Monday, June 19th 2006 @ 01:30:55 PM
Script : http://www.puregraffiti.com/graffiti...list_admin.php
Referrer :
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database


and when i access: http://www.puregraffiti.com/graffiti-space/toplist.php

i get:

puregraffiti, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


also,

i have no topsites category under my admincp for vbulletin like how it shows on your screenshots that im supposed to have... ??

someone please help

[Noxious]

i just installed this mod, i was wondering if anyone know how i change the banner allowed file extensions as the default mod only allows jpeg, gif and png image banner files and i prefere to use jpg, and when i try to upload a jpg banner i get an error message

Thanks for any help

[derekivey]

Originally Posted by Dj. Gargamel

hello - I just installed this great mod but I am having a problem - everything is working correctly till the moment I am choosing a category of sites to view - sites are displayed only when View All Sites option is turned on - when we are trying to sort sites by category none of pages is being shown (one random site is displaying always at top)

Can you PM me a link to your site so I can take a look?

Originally Posted by puregraf

hi im getting this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE status = 'inactive';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Monday, June 19th 2006 @ 01:30:55 PM
Script : http://www.puregraffiti.com/graffiti...list_admin.php
Referrer :
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database


and when i access: http://www.puregraffiti.com/graffiti-space/toplist.php

i get:

puregraffiti, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


also,

i have no topsites category under my admincp for vbulletin like how it shows on your screenshots that im supposed to have... ??

someone please help

Make sure you imported the product XML file under vB's product manager, then set the usergroup permissions and everything should be working.

Originally Posted by Noxious

i just installed this mod, i was wondering if anyone know how i change the banner allowed file extensions as the default mod only allows jpeg, gif and png image banner files and i prefere to use jpg, and when i try to upload a jpg banner i get an error message

Thanks for any help

Currently you have to edit the add_site.php, edit_site.php, and /admincp/toplist_admin.php files to add image types. You will need to know the mime type for each file type you want to add (e.g. image/jpeg).

The line should look like this:

PHP Code:

if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png") 


Derek

[puregraf]

Make sure you imported the product XML file under vB's product manager, then set the usergroup permissions and everything should be working.

hi, i went to redo that, and i went to import and got this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE image LIKE 'http://%';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Monday, June 19th 2006 @ 06:35:04 PM
Script : http://www.puregraffiti.com/graffiti...ncp/plugin.php
Referrer : http://www.puregraffiti.com/graffiti...?do=productadd
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database

then i went to do it again cause it didnt add it, and i got this:



Database error in vBulletin 3.5.4:

Invalid SQL:
CREATE TABLE `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;;



MySQL Error : Table 'toplist_ratings' already exists
Error Number : 1050
Date : Monday, June 19th 2006 @ 06:37:29 PM
Script : http://www.puregraffiti.com/graffiti...ncp/plugin.php
Referrer : http://www.puregraffiti.com/graffiti...?do=productadd
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database

[derekivey]

Please login to PHPMyAdmin, and delete all of the toplist_ tables, as well as the toplistpermissions column in the usergroup table (Do not delete the table itself!), and try the import again.

Derek

[Dj. Gargamel]

Originally Posted by derekivey

Can you PM me a link to your site so I can take a look?

Derek

PM sent - thanks for support

[Vitz]

Originally Posted by derekivey

What MySQL version are you running?

I'm currently running MySQL 5.0.18.

[derekivey]

Ok, I'll release an update shortly to fix these db errors. It seems that MySQL has added some more keywords so I will need to add ` around everything.

Derek

[derekivey]

Ok I have released the update. Those of you having SQL errors should redownload the zip file and reupload the files only. You don't have to reimport the xml file.

Please let me know if you continue to have problems.

Thanks,
Derek