Digital Dave came up with an issue that I had never given much thought to, he wanted to update the icons used by www.police-traffic.com in the tools page. He had uploaded the icons and then began changing the paths manually in the manager. Anyone who has done this before will probably know what a pain it can be. So Dave asked if there’s an easier way, and there is, and here it is; run the following SQL in your SQL Viewer changing the path to your new templates and voila, job done!
UPDATE vtp_menus SET menu_icon = REPLACE( menu_icon, '/templates/standard/images/', '/templates/your-template-folder/images/' )
Tags: SQL
