this might have been suggested but how about instead of just showing html code for linking to the toplist (vb) site you show other code as well for images that the vb site admin has uploaded. so for example the admin can upload 6 or 7 promotional images. then when a user has finished adding there site they have the option to copy a simply text link as well as in link with the admins promotional images


hope u understand me


cheers :D

That can easily be added by tweaking the Toplist_HTML_Code template and changing it to be like you want. I think I am just going to keep it the same for now. But if you want to change it on yours feel free to.

Derek

Is there a way to have a box on the forumhome thats shows random toplists sites?

Yeah, I'll try and make an addon tonight. Where would you like to see it at on the forum home?

bottom in a hor. scrolling bar.

Like under the Whats Going on? Box?

yea like under the birthdays ect.

It would scroll the images (linked) across the page in a box. I think that would be a nice addon.

Wait, so you just want a part that scrolls the images in the Toplist?

yea and maybe if no image, the name of the site and its linked to that site thru the out.php thing.

Ok, I'll try and make that.

Ok great!

Also Bump this amazing hack to the first page :D

I'll try and get to it tomorrow, I have been really busy with school this week :(.

I have installed this.

If I may make a suggestion....

Could you have another update for game servers, to check the status, and possibly only show online servers?

Thanks for the mod!

Hi,

I'm not sure how to do this, sorry :(

Version 1.0.4 is now out.

Please see the first post for what's new.

Follow the readme file closely to avoid losing the sites in your Toplist...

Derek

the rating system dont see to work for me gives me a error...

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='2' && username='MindWalker';

MySQL Error : Table '*************.toplist_ratings' doesn't exist
Error Number : 1146
Date : Sunday, December 4th 2005 @ 09:40:03 PM
Script : /toplist.php?do=rate&id=2
Referrer :
IP Address :
Username :
Classname : vb_database

its the way you have the sql set up with table_prefix it dont work on my sql i suppose cause it didnt alter the tables

Hold on, I think I forgot to add the SQL code for that database to the install code, I'll update the zip file in a second.

ok np thank you very much

Ok, redownload the zip file and try importing it again, don't forget to hit yes for overwrite.

kk one sec ill try

You might get an error in that one, if so please redownload and import the new .xml file. I was missing a " in the install code.

nope did the same thing... i did overwrite and all...

Try the file I just uploaded please.

nah its still giving the same error

Hmm I'll take a look and get back to you in a few mins.

ok np this is the error it gives

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='2' && username='MindWalker';

MySQL Error : Table '*******_**********.toplist_ratings' doesn't exist

Ok, try again please.

If it doesn't work, just execute this query in the AdminCP:
[sql]
CREATE TABLE `".TABLE_PREFIX."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]

it wont even let me do it through php admin

#1103 - Incorrect table name '".TABLE_PREFIX."toplist_ratings'

is there a way i can do it with out the table prefix

Yeah remove ".TABLE_PREFIX." it wont work in phpmyadmin b/c TABLE_PREFIX is part of vB.

ok one sec let me try

ok it opens up the ratings box but once i subit it gives another error let me try to do the tables manually or if you code post the tables that would be great

[sql]
ALTER TABLE `toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;

ALTER TABLE `toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;

ALTER TABLE `toplist_sites` ADD `rating_average` INT( 10 ) DEFAULT '0' NOT NULL AFTER `votes`;
[/sql]

There you go :)

working great thank you one thing i went to rate my site before this fix but its not showing now can i make that show?

nm lol i got it thank you so much... now how could i add the rating to the random site module lol...sorry for asking so much

I'll update that module tomorrow, I have to go now. It's late here.

Derek

Was the add-on for the forum home added into this release?

no it wasnt...

I have updated and cant see any probs so far, though i am hoping the add-on for the forum home will be added in soon.

I'd like it to include an option on how many will scroll and so forth.