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);
UPDATE vtp_menus SET menu_nr='Yes' WHERE id IN(41);
UPDATE vtp_menus SET menu_nr='No' WHERE id IN(47);