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!

[derekivey]

Ok, No problem, glad you got it working. Also do you remember what kind of errors it gave you when you tried uploading the images?

[puertoblack2003]

Originally Posted by derekivey

Ok, No problem, glad you got it working. Also do you remember what kind of errors it gave you when you tried uploading the images?

sorry D, i think i spoke to soon..but was to tired last night and had to give this a break...as far as the error message can't find my text files because i normally save the error .some how i didn't save it ,it was just when u upload a pic file from home pc file to server it was then giving me the error message that i was unable to upload....now back to the error for the rating..on page 16 verse 234 i followed the instruction to run queries..i ran the queries but when i want to rated a site i get that same error ..i'm stuck what else do you want me to look at.

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='1' && username='puertoblack2003';

MySQL Error  : Table 'puertotech.toplist_ratings' doesn't exist
Error Number : 1146
Date         : Sunday, February 5th 2006 @ 08:56:52 AM
Script       : http://www.loveforlife.com/toplist.php?do=rate&id=1
Referrer     : 
IP Address   : xxxxx.xxxx.xxx
Username     : xxxxxxxxxxxxx
Classname    : vb_database

believe me i was read through the hole thread here.. :ermm:

comment: also i ran the queries and seem to be in there i double checked everything just waiting for you i'm stuck :ermm:

[derekivey]

For some reason it looks like the SQL table for the ratings didn't get created. Try executing this code in PHPMyAdmin, or vB's query page in the AdminCP.

[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;
[/sql]

Also if you have a table prefix, be sure to add that to the table name also.

Derek

[forumsoup.com]

Just wondering, because I really don't know. Why would a site have a toplist?

[puertoblack2003]

Originally Posted by derekivey

For some reason it looks like the SQL table for the ratings didn't get created. Try executing this code in PHPMyAdmin, or vB's query page in the AdminCP.

[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;
[/sql]

Also if you have a table prefix, be sure to add that to the table name also.

Derek

got to love u man...lol... it worked know i have to figure out how to resolve the new version....error message will keep you informed

[derekivey]

Originally Posted by forumsoup.com

Just wondering, because I really don't know. Why would a site have a toplist?

They are mainly used to let users post their site and help get traffic to the different sites. Also at the same time they put a link on their site to your and it counts the hits in.

Originally Posted by nievesidenshop

got to love u man...lol... it worked know i have to figure out how to resolve the new version....error message will keep you informed

Ok, please let me know if you see the error again.

Thanks,
Derek

[tasarimdunyasi]

hi,

first:

when i delete a site using admin panel, i see that message:

Warning: unlink(/**************public_html/images/toplist/buttons/sites/forumbit_14): No such file or directory in /*****cp/toplist_admin.php on line 646
deleting succesfull..


second:

when I'm adding a new site, toplist looks like that althoug i don't use a picture. why it try to screen image although i use blank: http://img291.imageshack.us/img291/7020/example7px.jpg

sorry for my english.

thanks

Installed and working almost perfectly. Couple of questions:

- Where do I edit/add the missing image in the attached pic?

- How do I set the allowed image types? I made the edits to the files in post 463, but it still wants "JPEG" instead of "JPG".

Thanks!

[derekivey]

Originally Posted by tasarimdunyasi

hi,

first:

when i delete a site using admin panel, i see that message:

Warning: unlink(/**************public_html/images/toplist/buttons/sites/forumbit_14): No such file or directory in /*****cp/toplist_admin.php on line 646
deleting succesfull..


second:

when I'm adding a new site, toplist looks like that althoug i don't use a picture. why it try to screen image although i use blank: http://img291.imageshack.us/img291/7020/example7px.jpg

sorry for my english.

thanks

Just ignore the error, that just means the file isn't there. I will make it not show the error in the next release.

Also can you PM me the url to your forum and a test account so that I can try the 2nd thing? It shouldn't be showing anything if you leave the image field blank.

Originally Posted by Chris-777

Installed and working almost perfectly. Couple of questions:

- Where do I edit/add the missing image in the attached pic?

- How do I set the allowed image types? I made the edits to the files in post 463, but it still wants "JPEG" instead of "JPG".

Thanks!

For the image to show, you need to edit the images/toplist/buttons/dynamic/image.png file in a text editor such as notepad. You need to change the path from what I have to your path. See this post for more info.

For your second question, did you add $image_type == "image/jpg" to the if statement?

Derek

Thanks for the quick reply Derek. Got the broken image sorted out, thanks very much.

For the JPEG problem, I don't want ".jpeg" at all, so I changed all the instances listed from ' OR $image_type == "image/jpeg"' to OR $image_type == "image/jpg". I assume that should have worked as well, no?