Hi Wayne Thats the kind of thing I was expecting to do. My wife is an expert on mysql... so I'll get her assistance me thinks. I figured there would be a bit of a shuffle to do. All my panels are user panels ....because that the best way, that I've discovered to have the same panels across my network of 4 rivendell computers. I even made a refresh buttons macro to show any changed buttons across my network on all the machines. Cheers Geoff
On Thu, Aug 30, 2012 at 11:28 PM, Wayne Merricks <[email protected]> wrote: > 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 _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
