How To Switch Groups Of Menus Items On And Off, Shortcuts to menu management Options

[Martyn]

The following SQL statements can make dramatic changes to the appearance and functionality of your tools page. Please use with caution (it's always a good idea to take a backup of your data before making any changes. Run these statements in the SQL Viewer.

Switch all non text or banner options OFF

SQL

UPDATE vtp_menus SET menu_active=0 WHERE id IN(6,32,50,51,52,59,63,71,72,76,77);

Turn ON the Text Exchange menus

SQL

UPDATE vtp_menus SET menu_active=1 WHERE id IN(65,66,67);

Turn OFF the Text Exchange menus

SQL

UPDATE vtp_menus SET menu_active=0 WHERE id IN(65,66,67);

Turn ON the Banner Exchange

SQL

UPDATE vtp_menus SET menu_active=1 WHERE id IN(42,58,64);

Turn OFF the Banner Exchange

SQL

UPDATE vtp_menus SET menu_active=0 WHERE id IN(42,58,64);

Switch Professional Menus to Standard Menus

SQL

UPDATE vtp_menus SET menu_active=0 WHERE id IN(50,65,66,67,69,72,76);
UPDATE vtp_menus SET menu_nr='Yes' WHERE id IN(41);
UPDATE vtp_menus SET menu_nr='No' WHERE id IN(47);