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

[onenonymous]

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]

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

Nyn

[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]

Download link fixed!

[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

[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=?

[nynaevelan]

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.

Nyn

[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



Nyn

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

[nynaevelan]

Thanks I will give that a try.

[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