SQL-Viewer 2.4 [Script] 2009-10-25
Thanks!
Glad you found it useful.
Glad you found it useful.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
-
- Posts: 5559
- Joined: Wed Feb 07, 2007 11:07 pm
- Location: New Jersey, USA
- Contact:
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
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
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins
Join Dropbox, the online site to share your files
Link to Favorite Scripts/Skins
Join Dropbox, the online site to share your files
I'm a bit busy now and I don't know when I'll get the time...
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
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!
I want to clear only the DB covers and have MM re-detect embedded/external art.
edit
well it seemed pretty simple actually...
Code: Select all
DELETE from Covers
New script: Last.FM Node Now with DJ Mode!
Last.fm + MediaMonkey = Scrobbler DJ!
Tag with MusicBrainz ~ Get Album Art!
Tweak the Monkey! ~ My Scripts Page
Last.fm + MediaMonkey = Scrobbler DJ!
Tag with MusicBrainz ~ Get Album Art!
Tweak the Monkey! ~ My Scripts Page
Yeah, it's almost to simple to delete data from a table..
Good idea. I think I'll do exactly that myself.
Good idea. I think I'll do exactly that myself.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Thanks for the script. Very useful.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
Thanks Owyn!
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
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
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
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
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.
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.
Thanks!
That doesn't happen for me. Does it happen with the latest version as well?
What version of MM do you use?
That doesn't happen for me. Does it happen with the latest version as well?
What version of MM do you use?
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
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?
New script: Last.FM Node Now with DJ Mode!
Last.fm + MediaMonkey = Scrobbler DJ!
Tag with MusicBrainz ~ Get Album Art!
Tweak the Monkey! ~ My Scripts Page
Last.fm + MediaMonkey = Scrobbler DJ!
Tag with MusicBrainz ~ Get Album Art!
Tweak the Monkey! ~ My Scripts Page
@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.
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.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
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
Ver 2.1.1 (2008-05-01) [MM3 only]
What's new?
- Fixed some layout issues (thanks to tekno)
- Improved RemVBS function
Enjoy!
/Bex
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
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
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
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts