Printable Version of Topic

Click here to view this topic in its original format

Ventrino Forum for Walker Scripts _ Ventrino FAQ _ How To Switch Groups Of Menus Items On And Off

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);

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)