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

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: DebugHelper 1.8 (2012-08-07) [MM4]

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

by Bex » Tue Aug 07, 2012 9:29 am

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

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

by nynaevelan » Thu Dec 03, 2009 5:41 pm

Thanks I will give that a try. :D

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

by Bex » Thu Dec 03, 2009 3:49 pm

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.

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

by nynaevelan » Wed Dec 02, 2009 5:42 pm

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

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

by nynaevelan » Sat Mar 07, 2009 12:07 pm

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

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

by Bex » Sat Mar 07, 2009 12:01 pm

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

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

by nynaevelan » Sat Mar 07, 2009 10:28 am

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

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

by Bex » Fri Dec 12, 2008 11:34 pm

Download link fixed! :D

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

by MoDementia » Sat Sep 27, 2008 6:02 pm

Code: Select all

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

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

by nynaevelan » Sat Sep 27, 2008 5:14 pm

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

Nyn

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

by onenonymous » Sat Sep 27, 2008 5:00 pm

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

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

by nynaevelan » Sat Sep 27, 2008 4:49 pm

Hi Bex:

It's me again. 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 or a button directly in the DH script? I am using this one so much, a button would be really useful.

Nyn

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

by nynaevelan » Sun Sep 21, 2008 6:05 am

Bex wrote:Oops... :oops:

Replace the previous code with this one:

Code: Select all

info = info & "TrackModified: "    & FormatDateTime(DB.OpenSql("SELECT DATETIME(TrackModified+2415018.5) FROM Songs WHERE ID="&list.item(0).ID).StringByIndex(0)) & VbNewline
Even if the first one returns a date, it always returns the date from the track with the lowest id in your library.
The second one actually returns the date from the selected track.
Well I guess you can tell I only tried it on 1 track.... :oops:

Nyn

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

by Bex » Sun Sep 21, 2008 4:53 am

Oops... :oops:

Replace the previous code with this one:

Code: Select all

info = info & "TrackModified: "    & FormatDateTime(DB.OpenSql("SELECT DATETIME(TrackModified+2415018.5) FROM Songs WHERE ID="&list.item(0).ID).StringByIndex(0)) & VbNewline
Even if the first one returns a date, it always returns the date from the track with the lowest id in your library.
The second one actually returns the date from the selected track.

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

by nynaevelan » Sat Sep 20, 2008 7:24 pm

Bex wrote:Thank you! :D
Good ideas! I'll try to implement them in the next version of the script.

@Nyn,
In the meantime you can add this line (after e.g. FileModified) to get TrackModified:

Code: Select all

info = info & "TrackModified: "    & FormatDateTime(DB.OpenSql("SELECT DATETIME(TrackModified+2415018.5) FROM Songs").StringByIndex(0)) & VbNewline
Worked perfectly, thank you. :) :)

Nyn

Top