SQL-Viewer 2.4 [Script] 2009-10-25

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Postby Bex » Tue Feb 05, 2008 5:51 pm

Thanks! :D
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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Postby nynaevelan » Tue Feb 19, 2008 9:41 pm

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
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
nynaevelan
 
Posts: 5558
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA

Postby Bex » Wed Feb 20, 2008 11:43 am

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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Postby Teknojnky » Mon Apr 14, 2008 4:17 pm

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...

Code: Select all
DELETE from Covers


Make sure you backup your database before doing that, and re-scan after to re-import existing art! :o
Teknojnky
 
Posts: 5509
Joined: Tue Sep 06, 2005 11:01 pm

Postby Bex » Mon Apr 14, 2008 5:01 pm

Yeah, it's almost to simple to delete data from a table..

Good idea. I think I'll do exactly that myself. :D
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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Postby Owyn » Fri Apr 18, 2008 8:16 pm

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
Owyn
 
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Postby Bex » Fri Apr 18, 2008 8:22 pm

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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Postby Bex » Wed Apr 30, 2008 8:04 pm

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
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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Postby MDominik13 » Wed Apr 30, 2008 8:39 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.
MDominik13
 
Posts: 102
Joined: Mon Jun 27, 2005 2:47 pm

Postby Bex » Thu May 01, 2008 4:23 am

Thanks!

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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Postby MDominik13 » Thu May 01, 2008 9:42 am

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.
MDominik13
 
Posts: 102
Joined: Mon Jun 27, 2005 2:47 pm

Postby Teknojnky » Thu May 01, 2008 10:03 am

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?
Teknojnky
 
Posts: 5509
Joined: Tue Sep 06, 2005 11:01 pm

Postby Bex » Thu May 01, 2008 11:46 am

@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.
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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Postby Bex » Thu May 01, 2008 12:16 pm

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
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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Postby Bex » Thu May 08, 2008 8:09 am

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
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
Bex
 
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

PreviousNext

Return to Need Help with Addons?

Who is online

Users browsing this forum: Exabot [Bot] and 6 guests