DebugHelper 1.8 (2012-08-07) [MM4]

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

onenonymous
Posts: 374
Joined: Sat Feb 02, 2008 1:09 pm
Location: Texas
Contact:

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by onenonymous »

nynaevelan wrote: Is there a quick code you can give me in order to add either info to the scripts.ini file so I can create a button with Onenonymous' Right Click for Scripts script

Code: Select all

[DebugHelper-Song]
Filename=Auto\DebugHelper.vbs
Procname=DisplaySongInfo
Order=99
DisplayName=Debug Helper Song
Description=Debug Helper Song
Language=VBScript
ScriptType=99
Icon=27

[DebugHelper-Node]
Filename=Auto\DebugHelper.vbs
Procname=DisplayNodeInfo
Order=99
DisplayName=Debug Helper Node
Description=Debug Helper Node
Language=VBScript
ScriptType=99
Icon=27
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by nynaevelan »

Thank you for the quick response, now I have one more button!!!! :D

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
MoDementia
Posts: 1321
Joined: Thu Jun 15, 2006 3:26 pm
Location: Geelong, Victoria, Australia
Contact:

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by MoDementia »

Code: Select all

[DebugHelper]
Filename=Auto\DebugHelper.vbs
Procname=DisplaySongInfo
Order=100
DisplayName=Debug Helper
Description=Debug Helper
Language=VBScript
Icon=27
ScriptType=99
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden
Contact:

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by Bex »

Download link fixed! :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
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by nynaevelan »

Bex:

Would it be too difficult to add the bookmark length (Songs.PlaybackPos) to DH?? Not the number as it is in the db but as the length that it is at in the track? Or better yet, if you have a SQL statement that could be used in SV that will work. The way it shows in MM, example 0.3, is not very helpful without actually selecting the track to play, which of course messes up the current now playing list. Thanks.

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

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by Bex »

Here's the SQL: :)

Code: Select all

SELECT ID, Artist, SongTitle,
CASE WHEN PlaybackPos <600000 THEN SUBSTR(STRFTIME('%M:%S',0.5+CAST(PlaybackPos AS REAL)/86400000),2)
WHEN PlaybackPos <3600000 THEN STRFTIME('%M:%S',0.5+CAST(PlaybackPos AS REAL)/86400000)
ELSE SUBSTR(STRFTIME('%H:%M:%S',0.5+CAST(PlaybackPos AS REAL)/86400000),2) END PlaybackPosition
FROM Songs
WHERE Songs.ID=?
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
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by nynaevelan »

Bex wrote:Here's the SQL: :)

Code: Select all

SELECT ID, Artist, SongTitle,
CASE WHEN PlaybackPos <600000 THEN SUBSTR(STRFTIME('%M:%S',0.5+CAST(PlaybackPos AS REAL)/86400000),2)
WHEN PlaybackPos <3600000 THEN STRFTIME('%M:%S',0.5+CAST(PlaybackPos AS REAL)/86400000)
ELSE SUBSTR(STRFTIME('%H:%M:%S',0.5+CAST(PlaybackPos AS REAL)/86400000),2) END PlaybackPosition
FROM Songs
WHERE Songs.ID=?
Thank you, once again you have made my life a little bit easier. :D :D

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

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by nynaevelan »

Bex:

A question for you, here is one of many tracks which appear to have album art discrepancies. I would like to fix them but I forget where DV is pulling the data from. I assume the first is the Covers table of the db, where is the other info coming from? And secondly, cause you know I will ask, is there a SQL statement to help me fix them? If it is not fixable, I can use Trixmoto's Album Art Tagger script to remove all but the first cover but I would like to avoid that if at all possible. TIA

Image

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

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by Bex »

The first one is SQL, i.e. how the database is thinking the Album Art is stored. The other one is from MM's API which usually reads directly from the tag of the files but with Album Art is actually is a combination of data in the db and the data in the tag. That is at least how I interpret it.

One way to fix strange things like this could be to delete the data in the database and then rescan the affected tracks/folders again. That should correct most things. You could also try to rescan without deleting data.
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
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: DebugHelper 1.7 [Script] 2008-06-06 [MM3]

Post by nynaevelan »

Thanks I will give that a try. :D
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
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden
Contact:

Re: DebugHelper 1.8 [Script] 2012-08-07 [MM4]

Post by Bex »

Script is updated!
Ver 1.8 (2012-08-07)
- Changed Information box to a version which let you copy the information
- Added new fields
- - MediaMonkey version
- - ApplicationPath
- - Database location
- - ScriptsIni location
- - Script location
- - AddonInstallRoot
- - Current Collection
- - Collection SQL
- - RelatedObjectID (New useful Node property)


This version only works with MM4!

Download here or from the first post:
DebugHelper 1.8
If you're a new user, please read the first post, including the installation instructions.


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
Post Reply