Cool SQL to update traffic exchange icons

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/'
)

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">