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!

[DementedMindz]

if you had to use a backup from before you used then the it wouldnt show in sql since you didnt have it installed then. but if you have no important info for topsites erase the topsites tables.

[DementedMindz]

lmfao you beat me to it i was typing it the same time.

[Chicago_VLNU_4s]

where do i delete the topsite tables from?? **Still new to this by two months**

[derekivey]

Does your host give you some sort of control panel to use? If so, there should be a link to PHPMyAdmin in there, if not you will have to edit your vBulletin config to allow your userid to execute queries, then go to AdminCP -> Maintenance -> Execute Query, and enter these queries. Please note that doing this will delete all Toplist data from the tables, so if you have sites in the Toplist, they will be gone after doing this!

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

Derek

[Chicago_VLNU_4s]

^^

I do have CPanel, but i did the second way, through Admin CP and here's the error I got

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
DROP TABLE IF EXISTS toplist_clicks;
DROP TABLE IF EXISTS toplist_ratings;
' at line 1

[derekivey]

hmm does this work?

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

[Chicago_VLNU_4s]

nope..

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
DROP TABLE IF EXISTS `toplist_clicks`;
DROP TABLE IF EXISTS `toplist_ratings' at line 1

[derekivey]

Not sure then, your going to have to try that in PHPMyAdmin, I'm not sure why it's giving you errors in vB's system.

Derek

[DementedMindz]

I was just thinking of a feature. ok you know how you have a random site at the top maybe you can change it to a featured site. This is what I was thinking... Say you have a cron reset the stats at the begining of each month. Then the month starts and you get each sites votes at the end of the month who ever has the highest vote stays on the featured site for the month until the stats are reset then its on to the following month where the stats are checked again for a new featured site. I think it may bring more hits in and be a nicer feature then the random site. Let me know what you think???

[derekivey]

I'll see about adding it. Shouldn't be that hard to add, but the new stats feature isn't done yet, so I'll have to wait till then and add it then.

Derek