It really depends on how good you are with sql, and computer stuff, how comfortable you will be with really heavy tricks.

You can dump tables in admin->database->export area. If you do that, you can export your Links database to a file with all the insert commands, download the file, cut off the top of it (old links) and then quickly delete lines from the list, and then do a delete from prefix_Links where ID => first_link_delete and ID <= last link deleted, then reimport the "good" links using a a cut/past to the SQL monitor box. If there are only a few links you want to keep, after looking at the list, you could do something like:

update Links set isValidated = "Yes" where ID IN ( ) ; I'm not sure the _exact_ command, then you could just

delete from Links where isValidated = 'No'

I'm being a bit sketchy, since all these are pretty dangerous, as they require direct database manipulation.

You can also issue your own SQL commnad to export only the links where isValidated = No, which will cut down the size of your export file drasticly, and let you pick up unvalidate files you might have missed.

The *best* way to fix things, would be to use th IN() list method, once you get the "good" ID's. The reason is that it uses the data already in the database, with an update and a delete. Once you set all the good links to isValidated you can get rid of all the bad links that have isValidated="No". It also does not required deleting good data from the database then reimporting it, which has some risk to it.

If you are going to use the IN method, you can go to the sql monitor in links, and simply ask:

select * from prefix_Links where isValidated="No"

and then do a cut/paste from the results screen into an editor, and take down a list of the "good" ID's that you probably want to keep.

If you can tell the good/bad from just the title and URL, just ask for:

select ID,Title,URL from prefix_Links where isValidated="No"

It would be a really quick 2-finger type delete pattern from there on <G>. Use a block-select/delete to remove the Title, URL data from the editor, change \n to \n, via a regex search/replace, and insert that into the IN (...) portion of the update.

I do something very similar when trying to add new links in bulk, and assign them categories.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.