Posted by: Martyn Feb 25 2007, 10:06 AM
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);