Hmm thats weird, it looks fine to me, I'll have to take a look more closely and I'll let you know if I find anything out.

Derek

EDIT: What MySQL version do you have?

Hi... i love this mod... really coool... anyways i suppose you know of the 'cannot edit categories' bug from ACP... :) (too many spaces_ "id = 2") :D maybe...

-b6

Please try this file, it should fix it. I attached it to a post and forgot to update the zip file in the first post.

Link: https://vborg.vbsupport.ru/attachmen...5&d=1150214870

Derek

thank`s
iam install it :banana:

georg

Hi Georg,

Are you still getting that MySQL error?

Thanks,
Derek

One last thing... a friend uploaded a banner which was outside my dims limits... added the site but showed no banner... sho he thought he'd try it again... and again...and again...not knowing he was uploading a banner that was too big... so a little notice would be great :D...as i say...top mod... great stuff!

-b6

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?

yes,
this file was already instal.
the same error ist still getting.
what now ??
greatings
georg

Ok, what version of MySQL do you have?

Server OS/PHP WINNT
Datenbankverbrauch 81,10 MB
Webserver Apache v2.2.0
Index belegt 2,57 MB
PHP 5.1.1
PHPs max. Post-Gr??e 16,00 MB
PHPs maximale Uploadgr??e 16,00 MB
PHPs Speicherlimit Nein
MySQL-Version 5.0.18-nt-max
MySQL Paketgr??e 1.023,0 KB

here my dates
georg

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

Georg,

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

Thanks,
Derek

I'll test it out for you...

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

thanks .. :banana:
georg

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

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

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

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

What MySQL version are you running?

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

Thanks! Glad you like it :D.

Derek

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)

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

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

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

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

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:
Derek

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

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

PM sent - thanks for support

I'm currently running MySQL 5.0.18.

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

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

There was another bug found with this hack, if you edit a site in the AdminCP, it resets the category back to no category, so its just shown when you first go to the Toplist. If you would like to fix this, please upload the attached file to the AdminCP and overwrite the old one. I am also updating the zip file to include this change.

Thanks,
Derek

Another bug, when you give a usergroup permission to edit they can bypass the validation. Instead of clicking the validate link to check if the backlink exist they can simply click edit and save and the link is posted in the toplist. Can this be fixed?

Also when I turn on site moderation and then validate the user, the user still gets the message (when clicking validate) that the moderator needs to validate the link first. So the site is validated by me but the user still gets this message and can't validate his site (backlink).

I'll take a look at these and get back to you. I'll see if I can reproduce them.

Derek

Thank for so fast answer and using Your precious time
unfortunately I found next error - when I am trying to edit category in Admin CP i get message "Sorry, you cannot edit a category without first selecting one. Please try again, and make sure a id is included in the url."

I also had this error but with the latest update it is gone. You can go around this bug by opening the edit category in a new window. Then in the url you can see what is wrong. You must get rid of the two spaces at the end.

Remove %20 twice at the end and enter. No it works. :)

Ok another one, when users forget to copy the site code they can't get it again when hey edit their site. They have to delete the entry and start all over again. Can't you display the site code on the user edit page ?

Request: how can I remove the rating column? I want to disable the rating part from the toplist.

Thank you for the update. The hack seems to work fine now. I just have one question. How would I go about moving the toplist box that scrolls the listed sides, to the bottom of my forums? Right now I have an affiliate box there, and would like to replace that with the Toplist box. I'm not very experienced when it comes to coding so if you could help me, that'd be great. Thanks.

Make sure you uploaded the attached file above. I logged into your admincp and it doesn't look like you did because that bug still exists, and so does the broken images bug when you click on Toplist Sites.

It shows up when they edit their site and click submit. I think I will add a page in the next version where they can see it without having to edit their site.

Right now you manually have to remove the rating column, but in the next version I will have an option that when disabled it will not show it, requiring no file edits. For now, if you want to remove it now, you have to edit the Toplist, Toplist_1, and Toplist_2 templates to remove it.

You will have to mess with the plugin called Toplist Forum Home Addon, which is on the hook forumhome_complete. You will have to edit the line called:
and replace it with a line of code that is currently above where you want to put it.

Derek

Thanks for your answer! :)

Ok some users think they are clever and put the site html on a page outside of their site. Can you make the url where they put the site html code visible on the admin page when I edit a site please?

done that but still getting the following when trying to upload a JPG banner, JPEG files work but no1 really uses them anymore