Bruji

Conor wrote:If all the links share something in common that you can identify them by you would be able to remove them all with the SQL. As usual create a backup of your Database.dvdpd file, as you can render the database unreadable with an SQL command. The file is located by default in your home folder at ~/Library/ Application Support/DVDpedia/Database.dvdpd.

Then with Terminal you can run the following commands (removes all the links that have any folder "Images" as part of the path):

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
DELETE from zlink where zurl like "%/Images/%";
.exit 

I would recommend caution with the above command as it can remove all your links, should there be a mistake in the "where" part. I personally would do delete items and links by hand to be sure what I am removing. However, if you have thousands of links the above would be quite useful.

Updates you can run as usual from within the program under the get more info in the advance menu or with the gear button on the lower right of the edit window.