IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
How To Switch Groups Of Menus Items On And Off, Shortcuts to menu management
Martyn
post Feb 25 2007, 10:06 AM
Post #1


WSF Commander
*******

Group: Admin
Posts: 4,662
Joined: 26-August 05
Member No.: 10



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);
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 17th July 2019 - 08:27 AM