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

Post a reply

Visual Confirmation

To prevent automated access and spam, you are required to confirm that you are human. Please place a check mark next to all images of monkeys or apes. If you cannot see any images, please contact the Board Administrator.

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[flash] is OFF
[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]

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

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

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

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

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

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

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

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

Download link fixed! :D

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

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

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

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

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

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

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

Post 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