In Reply To:
A) For one-time solution you need to do an SQL query:
1) list all records into a temp table in a category from lsql_catlinks
2) update IsValidated field to No for all records IDs listed in the temp table
B) you need a plugin for this (may be also solved using an unusual global, on a non-public page).
Hello there,
Thanks for the quick reply... and your idea does makes sense.. except the fact that I do not know what sql query I need to use to unvalidate the listings once I get the ID numbers of all the listings within certain category?
B) I can do a test install, import entire DB, change the settings to it should display 10,000 link on one page, and then change the link.html page so it will only display the ID number of the listing, I think doing so should give me the ID number of all the listings within any given category within seconds... thanks for the wonderful trick. :)
Now still I am hoping if I can get some help with the sql query to unvalidate all the listings.
Vishal
Vishal
-------------------------------------------------------