You could manipulate the DB directly if you wanted but be careful how you formulate the MySQL.
From what I can see there are two tables: PANEL_NAMES which has a PANEL_NO indicating the order and a NAME. There is also a TYPE which always seems to be 1 (might differ if you use host verses user panels) and an OWNER which is the rd user name that uses the panel (might be the host name if you use host verses user panels). The second table is PANELS which contains the entries for all the buttons and what panel it belongs to. So assuming you have three panels: A, B, C and you renamed B to D so want to move it to the end: update PANELS set PANEL_NO = 9999 where PANEL_NO = 1; update PANEL_NAMES set PANEL_NO = 9999 where PANEL_NO = 1; This changes the buttons that were in the B panel (number order goes from 0, 1, 2 etc) to temporarily be 9999 and then goes on to change the panel itself to 9999. Then you need to move C down the list: update PANELS set PANEL_NO = 1 where PANEL_NO = 2; update PANEL_NAMES set PANEL_NO = 1 where PANEL_NO = 2; Then you need to move D (formerly B) back to the end of the list: update PANELS set PANEL_NO = 2 where PANEL_NO = 9999; update PANEL_NAMES set PANEL_NO = 2 where PANEL_NO = 9999; Wayne Merricks The Voice Asia On 30/08/12 04:47, Geoff Barkman wrote: > Hi There > I'm running Rivendell 1.72 on Ubuntu > The Rdairplay in my station has about 50 different banks of hotkeys. > From time to time sound panels get renamed and the desire to swap the > order of panels comes up. > > I could copy the buttons to rdairplay and then copy to the new > panel... but then if some the buttons are colored for various reasons > I have to remember one of them was green and another blue etc... it > gets quite tedious. > > Is there an easier was perhaps by renumbering them directly in the > data base.... any thoughts? > > Many thanks > Geoff Barkman > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ####################### Scanned by MailMarshal ####################### ############ Attention: The information contained in this message is confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. Christian Vision or any of its subsidiaries will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on. Please note that we reserve the right to monitor and read any e-mails sent or received by the company under the Telecommunications (Lawful Business Practice) (Interception of Communications) Regulation 2000. Christian Vision is registered in England as a limited company 2842414 and as a charity 1031031 ############ _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
