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.

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

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

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

^^

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

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]

nope..

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

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???

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