Page 5 of 17
Posted: Tue Feb 05, 2008 5:51 pm
by Bex
Thanks!
Glad you found it useful.
Posted: Tue Feb 19, 2008 9:41 pm
by nynaevelan
Hi Bex:
When you get a chance, can you look at
this script? There seems to be some conflict occurring with it and the SQL Viewer, maybe you have an idea or two how to resolve it.
Nyn
Posted: Wed Feb 20, 2008 11:43 am
by Bex
I'm a bit busy now and I don't know when I'll get the time...
Posted: Mon Apr 14, 2008 4:17 pm
by Teknojnky
Is there a safe way to clear the 'covers' table?
I want to clear only the DB covers and have MM re-detect embedded/external art.
edit
well it seemed pretty simple actually...
Make sure you backup your database before doing that, and re-scan after to re-import existing art!
Posted: Mon Apr 14, 2008 5:01 pm
by Bex
Yeah, it's almost to simple to delete data from a table..
Good idea. I think I'll do exactly that myself.
Posted: Fri Apr 18, 2008 8:16 pm
by Owyn
Thanks for the script. Very useful.
Posted: Fri Apr 18, 2008 8:22 pm
by Bex
Thanks Owyn!
Posted: Wed Apr 30, 2008 8:04 pm
by Bex
Script is updated
Ver 2.1 (2008-04-30) [MM3 only]
What's new?
- Change the window to a floating window
- Enlarged the <History> and <Saves> dropdowns dramatically (They were annoyingly short.)
- Changed numbers of saved history queries to 200
- Fixed so "history saves" older than last 200 are automatically deleted
- Added more buttons, [*], [COUNT(*)], [ORDER BY]
Enjoy!
/Bex
Posted: Wed Apr 30, 2008 8:39 pm
by MDominik13
Thanks for the great script. It has been a huge help to me in writing my own scripts and doing basic DB maintenance.
I do have one problem though. When my query results in an error, the error message gets stuck behind the query window. I worked around the problem by disabling the StayOnTop option for the form. Not sure if this is the right thing to do or if I'm doing something wrong.
Posted: Thu May 01, 2008 4:23 am
by Bex
Thanks!
That doesn't happen for me. Does it happen with the latest version as well?
What version of MM do you use?
Posted: Thu May 01, 2008 9:42 am
by MDominik13
I just installed your latest script and I'm using MM 3.0.3.1164.
I wish I could figure out how to reproduce it. I just set StayOnTop back to true and now it's not happening (it happened like 90% of the time before). Anyhow, I'll let you know if I can reproduce it and, if so, how.
Posted: Thu May 01, 2008 10:03 am
by Teknojnky
perhaps move the save/delete buttons under the indent control, and lock the lists to the right side of the form so the drop down's expand/contract with the form?
Posted: Thu May 01, 2008 11:46 am
by Bex
@MDominik13,
Yeah, I think I had that problem too but I changed something so it vanished, I forgot to update the script here though.
@Tekno,
Good idea, it'll be fixed soon.
Posted: Thu May 01, 2008 12:16 pm
by Bex
Script is updated
Ver 2.1.1 (2008-05-01) [MM3 only]
What's new?
- Fixed some layout issues (thanks to tekno)
- Improved RemVBS function
Enjoy!
/Bex
Posted: Thu May 08, 2008 8:09 am
by Bex
Script is updated
Ver 2.2 (2008-05-08 ) [MM3 only]
What's new?
- Added DropDown which adds data to the SQL-Window from the selected song in MM
Enjoy!
/Bex