Register DiskLister Admin now using
Register DiskLister Server now using
Sometimes you may need more than search and erasing single records. "Database Functions" window (apple+F for macintosh or ctrl+F for windows) gives you power to write SQL commands that will be applied to all databases you select.
How to use it? First we try to apply function "Delete Invisible items", which is included by default:
If you're familiar with SQL, you can create your own commands. DiskLister is reading functions from "dbfuncs.xml" file. It's an XML file encoded in UTF-8, with this format for functions:
<function name="Name of the function" code="SQL command"/>
eg.
<function name="Delete Invisible items" code="DELETE FROM paths WHERE vis='0'"/>
NOTE: in SQL command, use only the apostrophe character. Don't use quotation mark in SQL command, it will conflict with quotation used in XML element and your SQL command will not be proceeded.