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!

[Ramsesx]

Seems not to work with msql 5, maybe you remember my help request before 2 month derek.

[derekivey]

Georg,

Please try the attached file and let me know if it works.

Thanks,
Derek

[Snake]

I'll test it out for you...

[nets]

i`ll have overide it.
and it runs perfektly .. no errors !!
the sql database run?s.

thanks .. :banana:
georg

Originally Posted by derekivey

Georg,

Please try the attached file and let me know if it works.

Thanks,
Derek

[derekivey]

Thanks for getting back to me. I will update the zip file soon with the fix so that no one else has any problems with it.

Thanks,
Derek

[b6gm6n]

Originally Posted by derekivey

There should be a notice. That's weird it wasn't showing up though. What happened when he tried adding it? What did the Toplist script do?

it's ok... all working, my bad...

[Vitz]

I'm getting an odd Database error when trying to add a site through the Admin CP. Any idea how to fix this?

Originally Posted by Error

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO toplist_sites SET
username = 'Vitz',
name = 'Name',
url = 'http://www.name.com',
description = 'Name',
`in` = '0',
out = '0',
views = '0',
status = 'active',
cid = '',
imagetype = 'image/jpeg',
imagesize = '4326',
imagecode = 'yIu026PzjHz7HrXTnGd6',
added_code = '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 'out = '0',
views = '0',
status = 'active',
cid = '',
' at line 7
Error Number : 1064
Date : Monday, June 19th 2006 @ 08:12:40 AM
Script : http://www.elusive-works.co.uk/forum...list_admin.php
Referrer : http://www.elusive-works.co.uk/forum...min.php?do=add
IP Address : 82.169.28.64
Username : Vitz
Classname : vB_Database

Other than that, great hack. It'll definitely help me out.

[derekivey]

What MySQL version are you running?

[PitPunks]

Nominated for m.o.t.m and clicked install, ++++ing amazing dude, thanks!

[derekivey]

Thanks! Glad you like it .

Derek