MediaMonkey Wiki - User contributions [en]

ISDBSongData::IsntInDB

2009-09-30T17:39:31Z

Botijo: /* Property description */ Reworked the description so that it makes a little bit more sense.

{{MethodDeclaration|SDBSongData|ISDBSongData|Property Get/Let IsntInDB As Boolean}}

===Property description===

Returns True if the track is not stored in the Library. Defaults to False.
Returns False when
# Track is in the Library (SongID > 0)
# When MM does not know anything yet (SongID = -1)

In order for this property to be updated, MM needs to query the database. If the user sets this property to False, MM will not do a query to the database. This is done by device plug-ins extensively in order to avoid expensive database queries.

Info taken from [[http://www.mediamonkey.com/forum/viewtopic.php?p=39581#39581 this post by Jiri]].

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBSongData|{{PAGENAME}}]]
[[Category:Interface ISDBSongData|{{PAGENAME}}]]

SDBSongData

2009-09-29T20:55:47Z

Botijo: /* ISDBSongData members */ Added three or four new properties I have found in the latest beta.

{{AutomationObjectsList}}
== CoClass SDBSongData ==

Object with all properties of a track. Corresponding Songs Table columns.

To apply changes made to a SongData object, be sure to call one or more of the methods [[ISDBSongData::UpdateAlbum|UpdateAlbum]], [[ISDBSongData::UpdateArtist|UpdateArtist]], [[ISDBSongData::UpdateDB|UpdateDB]] and/or [[ISDBSongData::WriteTags|WriteTags]]. In some cases, you can call the [[ISDBSongList::UpdateAll|UpdateAll]] method of the SongList object containing the SongData object.

=== ISDBSongData members ===

{| border="1"
|-
! Name
! Type
! Description
!
! Name
! Value Type
! Possible Values
! Description
|-
|[[ISDBSongData::Album|Album]]
|Property Get
|
|
|
|
|
|
|-
|[[ISDBSongData::AlbumArt|AlbumArt]]
|Property Get
|
|
|
|
|
|
|-
|[[ISDBSongData::AlbumArtistName|AlbumArtistName]]
|Property Get/Let
|
|
|AlbumArtist
|TEXT
|
|
|-
|[[ISDBSongData::AlbumName|AlbumName]]
|Property Get/Let
|
|
|Album
|TEXT
|
|
|-
|[[ISDBSongData::Artist|Artist]]
|Property Get
|
|
|
|
|
|
|-
|[[ISDBSongData::ArtistName|ArtistName]]
|Property Get/Let
|
|
|Artist
|TEXT
|
|
|-
|[[ISDBSongData::Author|Author]]
|Property Get/Let
|
|
|Author
|TEXT
|
|The Composer of the Song
|-
|[[ISDBSongData::Band|Band]]
|Property Get/Let
|
|
|Band
|TEXT
|
|
|-
|[[ISDBSongData::Bitrate|Bitrate]]
|Property Get/Let
|
|
|Bitrate
|INTEGER
|
|
|-
|[[ISDBSongData::Bookmark|Bookmark]]
|Property Get/Let
|
|
|PlaybackPos
|INTEGER
|
|To be confirmed
|-
|[[ISDBSongData::BPM|BPM]]
|Property Get/Let
|
|
|BPM
|INTEGER
|
|Beats Per Minute
|-
|[[ISDBSongData::Cached|Cached]]
|Property Get/Let
|
|
|CacheStatus
|INTEGER
|
|
|-
|[[ISDBSongData::CachedPath|CachedPath]]
|Property Get
|
|
|CacheName
|TEXT
|
|
|-
|[[ISDBSongData::CalculateGapData|CalculateGapData]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::canCrossfade|canCrossfade]]
|Property Get/Set
|
|
|
|
|
|
|-
|[[ISDBSongData::Channels|Channels]]
|Property Get/Let
|
|
|Stereo
|INTEGER
|
|
|-
|[[ISDBSongData::Comment|Comment]]
|Property Get/Let
|
|
|Comment
|TEXT
|
|
|-
|[[ISDBSongData::Conductor|Conductor]]
|Property Get/Let
|
|
|Conductor
|TEXT
|
|
|-
|[[ISDBSongData::Copyright|Copyright]]
|Property Get/Let
|
|
|Copyright
|TEXT
|
|
|-
|[[ISDBSongData::Custom1|Custom1]]
|Property Get/Let
|
|
|Custom1
|TEXT
|
|
|-
|[[ISDBSongData::Custom2|Custom2]]
|Property Get/Let
|
|
|Custom2
|TEXT
|
|
|-
|[[ISDBSongData::Custom3|Custom3]]
|Property Get/Let
|
|
|Custom3
|TEXT
|
|
|-
|[[ISDBSongData::Custom4|Custom4]]
|Property Get/Let
|
|
|Custom4
|TEXT
|
|
|-
|[[ISDBSongData::Custom5|Custom5]]
|Property Get/Let
|
|
|Custom5
|TEXT
|
|
|-
|[[ISDBSongData::Date|Date]]
|Property Get/Let
|
|
|
|
|
|
|-
|[[ISDBSongData::DateAdded|DateAdded]]
|Property Get/Let
|
|
|DateAdded
|REAL
|
|
|-
|[[ISDBSongData::DateDBModified|DateDBModified]]
|Property Get
|
|
|
|
|
|
|-
|[[ISDBSongData::Day|Day]]
|Property Get/Let
|
|
|Year[7,2]
|INTEGER
|
|
|-
|[[ISDBSongData::DiscNumber|DiscNumber]]
|Property Get/Let
|
|
|
|
|
|MM2
|-
|[[ISDBSongData::DiscNumberStr|DiscNumberStr]]
|Property Get/Let
|
|
|DiscNumber
|TEXT
|
|
|-
|[[ISDBSongData::Encoder|Encoder]]
|Property Get/Let
|
|
|Encoder
|TEXT
|
|
|-
|[[ISDBSongData::FileLength|FileLength]]
|Property Get/Let
|
|
|FileLength
|INTEGER
|
|
|-
|[[ISDBSongData::FileModified|FileModified]]
|Property Get/Let
|
|
|FileModified
|REAL
|
|
|-
|[[ISDBSongData::GaplessBytes|GaplessBytes]]
|Property Get/Let
|
|
|GaplessBytes
|INTEGER
|
|
|-
|[[ISDBSongData::Genre|Genre]]
|Property Get/Let
|
|
|Genre
|TEXT
|
|
|-
|[[ISDBSongData::GetCopy|GetCopy]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::Grouping|Grouping]]
|Property Get/Let
|
|
|GroupDesc
|TEXT
|
|
|-
|[[ISDBSongData::ID|ID]]
|Property Get/Let
|
|
|ID
|INTEGER
|AUTOINCREMENT (1 to inf.)
|
|-
|[[ISDBSongData::InvolvedPeople|InvolvedPeople]]
|Property Get/Let
|
|
|InvolvedPeople
|TEXT
|
|
|-
|[[ISDBSongData::isBookmarkable|isBookmarkable]]
|Property Get/Let
|
|
|Seekable
|INTEGER
|
|To be confirmed
|-
|[[ISDBSongData::IsntInDB|IsntInDB]]
|Property Get/Let
|
|
|
|
|
|Dynamic Check
|-
|[[ISDBSongData::ISRC|ISRC]]
|Property Get/Let
|
|
|ISRC
|TEXT
|
|
|-
|[[ISDBSongData::isShuffleIgnored|isShuffleIgnored]]
|Property Get/Let
|
|
|
|
|
|
|-
|[[ISDBSongData::LastPlayed|LastPlayed]]
|Property Get/Let
|
|
|LastTimePlayed
|REAL
|
|
|-
|[[ISDBSongData::Leveling|Leveling]]
|Property Get/Let
|
|
|NormalizeTrack
|REAL
|
|
|-
|[[ISDBSongData::LevelingAlbum|LevelingAlbum]]
|Property Get/Let
|
|
|NormalizeAlbum
|REAL
|
|
|-
|[[ISDBSongData::Lyricist|Lyricist]]
|Property Get/Let
|
|
|Lyricist
|TEXT
|
|
|-
|[[ISDBSongData::Lyrics|Lyrics]]
|Property Get/Let
|
|
|Lyrics
|TEXT
|
|
|-
|[[ISDBSongData::Media|Media]]
|Property Get
|
|
|IDMedia
|INTEGER
|
|
|-
|[[ISDBSongData::MediaLabel|MediaLabel]]
|Property Get
|
|
|
|
|
|
|-
|[[ISDBSongData::MetadataFromFilename|MetadataFromFilename]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::Month|Month]]
|Property Get/Let
|
|
|Year[5,2]
|INTEGER
|
|
|-
|[[ISDBSongData::Mood|Mood]]
|Property Get/Let
|
|
|Mood
|TEXT
|
|
|-
|[[ISDBSongData::MusicComposer|MusicComposer]]
|Property Get/Let
|
|
|
|
|
|Use Author
|-
|[[ISDBSongData::Occasion|Occasion]]
|Property Get/Let
|
|
|Occasion
|TEXT
|
|
|-
|[[ISDBSongData::OriginalArtist|OriginalArtist]]
|Property Get/Let
|
|
|OrigArtist
|TEXT
|
|
|-
|[[ISDBSongData::OriginalLyricist|OriginalLyricist]]
|Property Get/Let
|
|
|OrigLyricist
|TEXT
|
|
|-
|[[ISDBSongData::OriginalTitle|OriginalTitle]]
|Property Get/Let
|
|
|OrigTitle
|TEXT
|
|
|-
|[[ISDBSongData::OriginalYear|OriginalYear]]
|Property Get/Let
|
|
|OrigYear[1,4]
|INTEGER
|
|
|-
|[[ISDBSongData::OriginalMonth|OriginalMonth]]
|Property Get/Let
|
|
|OrigYear[5,2]
|INTEGER
|
|
|-
|[[ISDBSongData::OriginalDay|OriginalDay]]
|Property Get/Let
|
|
|OrigYear[7,2]
|INTEGER
|
|
|-
|[[ISDBSongData::ParseText|ParseText]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::Path|Path]]
|Property Get/Let
|
|
|SongPath
|TEXT
|
|
|-
|[[ISDBSongData::PeakValue|PeakValue]]
|Property Get/Let
|
|
|
|
|
|
|-
|[[ISDBSongData::PlayCounter|PlayCounter]]
|Property Get/Let
|
|
|PlayCounter
|INTEGER
|
|
|-
|[[ISDBSongData::PlaylistOrder|PlaylistOrder]]
|Property Get/Let
|
|
|
|
|
|Dynamic Check
|-
|[[ISDBSongData::PostGap|PostGap]]
|Property Get/Let
|
|
|PostGap
|INTEGER
|
|
|-
|[[ISDBSongData::PreGap|PreGap]]
|Property Get/Let
|
|
|PreGap
|INTEGER
|
|
|-
|[[ISDBSongData::Preview|Preview]]
|Property Get
|
|
|
|
|
|
|-
|[[ISDBSongData::PreviewPath|PreviewPath]]
|Property Get
|
|
|PreviewName
|TEXT
|
|
|-
|[[ISDBSongData::Publisher|Publisher]]
|Property Get/Let
|
|
|Publisher
|TEXT
|
|
|-
|[[ISDBSongData::Quality|Quality]]
|Property Get/Let
|
|
|Quality
|TEXT
|
|
|-
|[[ISDBSongData::Rating|Rating]]
|Property Get/Let
|
|
|Rating
|INTEGER
|
|
|-
|[[ISDBSongData::RatingString|RatingString]]
|Property Get/Let
|
|
|
|
|
|Rating (Not Used?)
|-
|[[ISDBSongData::ReadTags|ReadTags]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::ReadTagsAsExt|ReadTagsAsExt]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::RenameByMask|RenameByMask]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::SampleRate|SampleRate]]
|Property Get/Let
|
|
|SamplingFrequency
|INTEGER
|
|
|-
|[[ISDBSongData::SongID|SongID]]
|Property Get
|
|
|
|
|
|Internal Use Only
|-
|[[ISDBSongData::SongLength|SongLength]]
|Property Get/Let
|
|
|SongLength
|INTEGER
|
|
|-
|[[ISDBSongData::SongLengthString|SongLengthString]]
|Property Get
|
|
|
|
|
|SongLength Formatted
|-
|[[ISDBSongData::Tempo|Tempo]]
|Property Get/Let
|
|
|Tempo
|TEXT
|
|
|-
|[[ISDBSongData::Title|Title]]
|Property Get/Let
|
|
|SongTitle
|TEXT
|
|
|-
|[[ISDBSongData::TotalSamples|TotalSamples]]
|Property Get/Let
|
|
|TotalSamples
|INTEGER
|
|
|-
|[[ISDBSongData::TrackOrder|TrackOrder]]
|Property Get/Let
|
|
|
|
|
|MM2
|-
|[[ISDBSongData::TrackOrderStr|TrackOrderStr]]
|Property Get/Let
|
|
|TrackNumber
|TEXT
|
|
|-
|[[ISDBSongData::UpdateAlbum|UpdateAlbum]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::UpdateArtist|UpdateArtist]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::UpdateDB|UpdateDB]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::VBR|VBR]]
|Property Get/Let
|
|
|VBR
|INTEGER
|
|
|-
|[[ISDBSongData::WriteTags|WriteTags]]
|Method
|
|
|
|
|
|
|-
|[[ISDBSongData::Year|Year]]
|Property Get/Let
|
|
|Year[1,4]
|INTEGER
|
|
|-}

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBSongData|{{PAGENAME}}]]

Compatible Devices

2008-11-10T19:59:12Z

Botijo: Added links for known Iriver devices.

This is a list of devices with known compatibility (i.e. these devices have been tested by users) with the current version of MediaMonkey. If you know of additional devices with MediaMonkey compatibility, please add them to this list. Devices are listed by their manufacturer. Click on any device to find any specific settings that are necessary to sync with the device.

==Apple==
:[[iPod]] (including 5th Generation)
:[[iPod Classic]]
:[[iPod Mini|iPod Mini]] (1st and 2nd Generation)
:[[iPod Nano]] (1st, 2nd, 3rd, and 4th Generation)
:[[iPod Photo]]
:[[iPod Shuffle]] (1st and 2nd Generation)
:[[iPod Touch]]
:[[iPhone|iPhone]]

==Archos==
:[[GenericMTP|Archos 605 Wifi]]
:[[GenericMTP|Archos Gmini (all versions)]]
:[[GenericMTP|Archos Gemini 200]]

==Audiovox==
:[[GenericMTP|Audiovox SMP3-xxx]]

==Cowon==
:[[USBmass|iAudio X5]]

==Creative==
:[[MTPZen|Zen]]
:[[MTPZen|Zen Micro (2.20.05 firmware)]]
:[[MTPZen|Zen Nano]]
:[[MTPZen|Zen Neeon]]
:[[MTPZen|Zen Sleek]]
:[[MTPZen|Zen Stone]]
:[[MTPZen|Zen Touch (with 'Plays for Sure' MTP firmware update)]]
:[[MTPZen|Zen Vision]]
:[[MTPZen|Zen Vision:M]]
:[[MTPZen|Zen xtra ('Plays for Sure' firmware update)]]

==Dell==
:[[USBmass|Dell DJ (mostly works--need logs to debug playlist problem)]]

==Eiger labs==
:[[USBmass|MPMan MP-F57]]

==Finis==
:[[USBmass|Finis SwiMP3]]

==iRiver==
:[[GenericMTP|iRiver Clix 2nd Gen (MTP mode)]]
:iRiver H10
:iRiver H120/H320/H340
:iRiver ifp-8xx
:[[USBmass|iRiver iFP-9xx]]
:iRiver N-xx
:iRiver PMP-1xx
:iRiver PMC-120

==Motorola==
:[[Motorola RIZR Z3]]

==Nokia==
:[[GenericMTP|Nokia 5310]]

==Phillips==
:[[GenericMTP|Philips HDD6320]] (partial support--need logs to debug)

==RCA==
:[[USBmass|Lyra 2780]]

==Samsung==
:[[GenericMTP|Samsung YP-XX]]
:[[GenericMTP|Samsung YP-XXX]]

==SanDisk==
:[[MTPSansa|Sansa eXXX]]
:[[MTPSansa|Sansa Fuze]]
:[[MTPSansa|Sansa M250]]
:[[MTPSansa|Sandisk Sansa]]

==Toshiba==
:[[GenericMTP|Toshiba Gigabeat (works but firmware bug limits synch speed)]]

==Sony==
:[[USBmass|Sony Ericsson W600]]
:[[USBmass|Sony Ericsson W800i]]
:[[GenericMTP|Sony Walkman NWZ-A829]]

ISDBTools::OutputDebugStringMM

2008-07-21T22:30:44Z

Botijo: Added link to DebugView download

{{MethodDeclaration|SDBTools|ISDBTools|Sub OutputDebugStringMM(Value As String)}}

===Parameters===

{{MethodParameters
|Value |String |A string to be added to debug log.}}

===Method description===

This method outputs a debug string using Windows OutputDebugString method, but only in case the Debug version of MediaMonkey is running. It can be useful for debuging your scripts, you can the view the debug logs using [http://technet.microsoft.com/en-us/sysinternals/bb896647.aspx DebugView tool]. Using this method instead of [[ISDBTools::OutputDebugString]] can be useful when you want to keep the debug messages in your released scripts and then get debug logs from users in case of troubles.

===Related items===

* [[ISDBTools::OutputDebugString]]

{{Introduced|3.0}}

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBTools|{{PAGENAME}}]]
[[Category:Interface ISDBTools|{{PAGENAME}}]]

Scripting Tips & Tricks (MM4)

2008-07-21T22:29:44Z

Botijo: /* (MediaMonkey) Scripting in general */ Added DebugView

==(MediaMonkey) Scripting in general==

=== 'Correctly' update song properties ===
Using the SongData object, you can either update the database/library (UpdateDB) and/or update the file's tags (WriteTags). So there's no way to let the song changes be saved like the user selected in the Options panel (menu Tools > Options > Library > Tags & Playlists > "Update tags when editing properties").
However, the UpdateAll method for the SongList object ''does'' take into account this user-specified option. So you can create a new SongList object using SDB.NewSongList and add your SDBSongData object(s) to it. Then call the UpdateAll method on the songlist, and your song(s) will be saved in user-specified way.

=== See MM debug log via DebugView ===
You can download [http://technet.microsoft.com/en-us/sysinternals/bb896647.aspx DebugView] directly from Microsoft. If used with the debug version of MM, lots of useful messages will be displayed in DebugView. Also, any message set via [[ISDBTools::OutputDebugStringMM]] will also be added to that debug log.

=== See MM Scripting interface using OLEView ===
MS Visual Studio contains a tool called [http://www.microsoft.com/downloads/details.aspx?familyid=5233B70D-D9B2-4CB5-AEB6-45664BE858B6&displaylang=en OLEView] ("OLE Viewer" or "OLE/COM Object Viewer") ([http://download.microsoft.com/download/win2000platform/oleview/1.00.0.1/nt5/en-us/oleview_setup.exe direct link]), which can show the type library of the SongsDB object "MediaMonkey Library". It requires the Iviewers.dll, which is not included, but can be downloaded from [http://www.dlldll.com/downdll/2757.html here] or other 3rd-party locations. There, you can see all supported properties and methods of the MediaMonkey scripting interface. This can be handy to find out new scripting methods in case that the scripting reference isn't up-to-date yet.
 The way to get there: ''OleView'' > Type Libraries > MediaMonkey Library > (double click)
 and then in the ''ITypeLib Viewer'' > SongsDB (MediaMonkey Library) > Interfaces.

=== Detecting docking of a panel ===
When you un(dock) a dockable panel, the OnResize event is triggered twice:
*Once while the panel is being (un)docked with DockedTo = 0
*Once after the panel has been (undocked): with DockedTo = -1 (panel undocked) or DockedTo = X (panel docked, X is the number that represents the docking position)

=== Keep reference to Form/Panel ===
When you create a form or panel, always add a reference to the SDB.Objects dictionary. If you don't add it, the form/panel will be gone immediately after you created it, with or without error message. Instead of using the SDB.Objects dictionary you can also store a reference as a global script variable, in most cases.

=== Event mechanisms ===
There are still 2 event mechanisms available:
*Using the (mostly deprecated) ''old event mechanism'' (using ''Control''.OnClickFunc and ''Control''.UseScript), your global variables aren't remembered in the event handlers (e.g. kind of like the script is reopened). For those scripts, you had to use ''ParentControl''.ChildControl("control name") or save object references to SDB's ''Objects'' dictionary.
*Using the ''new event mechanism'', your global variables ''are'' remembered so you can use their values in the event handlers. The Objects dictionary is now only necessary to communicate/store object references between different scripts.
So always use the new event mechanism where you can. Only for option panels (sheets) this is not yet possible. There you'll need to store values between the main program and the event handlers in SDB.Objects, in the INI or in the Registry.

=== Changing the current tree node ===
Changing the selected node from a script (using SDB.MainTree.CurrentNode = ...........) takes some time to happen, and it happens asynchronicly (the code execution doesn't wait until the node is really selected). For that reason, you can't use (get value of) SDB.MainTree.CurrentNode directly after you have assigned a new node to it (set value to), because changes won't have happened yet.

=== Interaction with MediaMonkey from outside ===
There are at least three ways to interact with MediaMonkey from an external program:
*Open the MediaMonkey.exe program with command line options (arguments).
*Using the same Windows Messages (SendMessage/PostMessage) as in Winamp (WM_USER and WM_COMMAND). MM partially emulates how WinAmp works (not 100%, but very close) and so it can use WinAmp plug-ins. The class name to communicate with is "Winamp v1.x".
*Using OLE Automation, which can be very easily used e.g. from VB Script.
*:<source lang="vb">Dim SDB : Set SDB = CreateObject("SongsDB.SDBApplication")</source>
*:<source lang="csharp">SongsDB.SDBApplicationClass SDB = new SongsDB.SDBApplicationClass();</source>
*:Be sure to set ''SDB.ShutdownAfterDisconnect'' to ''False'' if you opened the MediaMonkey program by calling the SDB object, and you don't want it to be closed when your external program exits (or if you disconnect the SDB object = COM link).

==Visual Basic Script==

=== Index in VBScript ===

Usually indexes start from '''0''' (e.g. for normal arrays). However, sometimes (e.g. for string positions or for [[ISDBCommonDialog::FilterIndex]]) they start from '''1'''.

=== Code readability ===

To maintain good readability of your scripting code, make sure to add comments where necessary, split large methods in smaller ones, use appropriate indentation (tabs or 2/3/4 spaces), and if necessary split long lines of code over several lines. To split a line of VBScript code (not text or numbers), add a ''space'' and an ''underscore'', and continue on the next line. Don't forget the space before the underscore or it won't work.
<source lang="vb">
MsgBox "This is quite a long text to display on one single line and for readability we better split it on multiple lines"

MsgBox "This is quite a long text to display on one single line" & " and for readability we better split it on multiple lines"

MsgBox "This is quite a long text to display on one single line" _
& " and for readability we better split it on multiple lines"
</source>
In the third example the code is more readable, but the result is still the same: a message box with one long line of text. To split this over multiple lines, we preferably use the constant vbNewLine. If necessary, you can also use ''vbCr'' (Unix-style) or ''vbCrLf''(Windows-style). Using these constants is more clear than using respectively ''Chr(13)'' (Unix-style) or ''Chr(13) & Chr(10)'' (Windows-style).
<source lang="vb">
MsgBox "This is quite a long text to display on one single line" & vbNewLine _
& " and for readability we better split it on multiple lines"
</source>

=== Using Flags in VBScript ===

The concept of [[Flags]] can be a difficult for novice programmers. Click the link for an explanation of how to use them in VBScript (or Visual Basic).

=== Links ===

'''Helpful sites:'''
* [http://msdn2.microsoft.com/en-us/library/ms950396.aspx Reference for scripting resources]
* [http://www.microsoft.com/technet/scriptcenter/default.mspx Microsoft Script Center]
* [http://msdn2.microsoft.com/en-us/library/t0aew7h6.aspx VBScript User's Guide and Language Reference]
* [http://www.microsoft.com/technet/scriptcenter/scripts/default.mspx?mfr=true VBScript Script Repository]
* [http://www.w3schools.com/vbscript/default.asp W3Schools VBScript learning]

'''VBScript editors:'''
* [http://www.vbsedit.com/ VBSEdit] (debugging, object and COM lookup, integrated help)
* [http://notepad-plus.sourceforge.net/ NotePad++]
* [http://www.pspad.com/ PSPad]
* [http://www.sapien.com/ PrimalScript]
* [http://www.microsoft.com/downloads/details.aspx?familyid=2f465be0-94fd-4569-b3c4-dffdf19ccd99&displaylang=en Microsoft VBScript 5.6 Debugger for Win 2000/XP] (debugging)
* [http://www.editpadpro.com/ EditPad (Pro)]

== Database & SQL ==

=== Database transactions ===

Starting from MM 3.0 transactions are often used when working with database. It can cause some problems to script authors in case they don't know some details. One example where you can face a problem is when you use [[ISDBSongData::UpdateDB]] method while you have some SQL query open. What happens in this case is, that MM wants to start a transaction, but there's still an SQL query open. This results either in an error message (in debug build) or possibly an apparent freeze of MM in the release build.

In order to prevent this problem, you can either:
* Put all these DB operations in an transaction, i.e. use [[ISDBDatabase::BeginTransaction]] and [[ISDBDatabase::Commit]].
* Close already running SQL queries before you call things like [[ISDBSongData::UpdateDB]].

=== Creating complex SQL queries ===
To easily create complex SQL queries, you can use the Query graphical user interface in Access interface, and show the SQL code when you are done. In any case, make sure that your SQL code is organized is such a way that it can be understood easily, e.g. by putting SELECT, INSERT, FROM, ORDER BY, ... on separate lines with appropriate indentation.

=== Avoid SQL date problems ===
One of the problems with SQL is that dates are often confused, which sometimes give programming bugs. The best way to circumvent this problem is by using the format #yyyy-mm-dd# for all dates in SQL (e.g. #2006-10-31# for 31th October 2006).

=== Links ===
'''Helpful sites:'''
*[http://www.w3schools.com/sql/default.asp W3Schools SQL learning]

Linux Plugin Status

2008-06-08T11:22:02Z

Botijo: /* Failure Reason Codes */

WORK IN PROGRESS
Plugins that run in [[Linux%2C_Wine_%26_MediaMonkey | MediaMonkey under wine]]

==Default Installed Plug-ins==
{| border="1"
|-
! Plugin
! Status
! Provides
! Requires
|-
| '''DSP(Digital Signal Processing)'''
|-
| dsp_DeFX.dll
|
|
|
|-
| '''Device Synchronization'''
|-
| d_iPhone.dll
| Fails(1)
|
|
|-
| d_iPod.dll
| Fails(1)
|
|
|-
| d_iRiverH.dll
| Fails(1)
|
|
|-
| d_USBMass1.dll
| Fails(1)
|
|
|-
| d_WMDM.dll
| Fails(2)
|
|
|-
| '''Input Format'''
|-
| f_aac.dll
|
|
|
|-
| f_ape.dll
|
|
|
|-
| f_flac.dll
|
|
|
|-
| f_flac_codec.dll
|
|
|
|-
| f_mpc.dll
|
|
|
|-
| f_ogg.dll
|
|
|
|-
| f_wave.dll
|
|
|
|-
| '''Input'''
|-
| in_ape.dll
|
|
|
|-
| in_mpc.dll
|
|
|
|-
| in_vorbis.dll
| OK
| Vorbis (OGG)
|
|-
| in_wav.dll
|
|
|
|-
| in_wma.dll
|
|
|
|-
| in_wmp3.dll
| Fails(3)
|
|
|-
| '''Output'''
|-
| out_MMDS.dll
|
|
|
|-
| out_wave.dll
| OK
|
|
|-
| '''Visualization'''
|-
| vis_geis.dll
| Fails(4)
|
|
|-
| vis_milk.dll
| OK
|
|
|-
| vms_desktop.dll
|
|
|
|}

==Other Plugins==
{| border="1"
|-
! Plugin
! Status
! Provides
! Requires
|-
| gen_wa2_scrobbler.dll
|
| Last.fm
|
|-
| in_mad.dll
| OK
| MP3
|
|-
| [[http://www.hydrogenaudio.org/forums/index.php?s=c3af297449c1a7b8ab5adb628cb6cff8&showtopic=60454 in_mad.dll]] (Newer)
| OK (5)
| MP3
|
|-
| in_mp3PRO.dll
|
|
|
|-
| in_mp3.dll
| OK
| MP3
| Comes from winamp2 install
|}

==Failure Reason Codes==
# Calls to a non implemented function in cfgmgr32.dll - it might require native file, not tested. iRiverH and iPod related plugins fail on init.
# Requires an OLE object that should be provided by Windows Media Player. UID: {25baad81-3560-11d3-8471-00c04f79dbc0}. Not tested.
# Requires Windows Media Player and also codecs for Windows Media Player. Not tested.
# Changes screen resolution and does not render at all. Can be safely exited by pressing escape.
# Extra long buffers while using newer MAD plugin. Expect 10 seconds between player action and sound response.

2008-05-06T19:07:34Z

Botijo: /* Failure Reason Codes */

WORK IN PROGRESS

==Default Installed Plug-ins==
{| border="1"
|-
! Plugin
! Status
! Provides
! Requires
|-
| '''DSP(Digital Signal Processing)'''
|-
| dsp_DeFX.dll
|
|
|
|-
| '''Device Synchronization'''
|-
| d_iPhone.dll
| Fails(1)
|
|
|-
| d_iPod.dll
| Fails(1)
|
|
|-
| d_iRiverH.dll
| Fails(1)
|
|
|-
| d_USBMass1.dll
| Fails(1)
|
|
|-
| d_WMDM.dll
| Fails(1)
|
|
|-
| Input Format
|-
| f_aac.dll
|
|
|
|-
| f_ape.dll
|
|
|
|-
| f_flac.dll
|
|
|
|-
| f_flac_codec.dll
|
|
|
|-
| f_mpc.dll
|
|
|
|-
| f_ogg.dll
|
|
|
|-
| f_wave.dll
|
|
|
|-
| '''Input'''
|-
| in_ape.dll
|
|
|
|-
| in_mpc.dll
|
|
|
|-
| in_vorbis.dll
|
|
|
|-
| in_wav.dll
|
|
|
|-
| in_wma.dll
|
|
|
|-
| in_wmp3.dll
| Fails(2)
|
|
|-
| '''Output'''
|-
| out_MMDS.dll
|
|
|
|-
| out_wave.dll
|
|
|
|-
| '''Visualization'''
|-
| vis_geis.dll
|
|
|
|-
| vis_milk.dll
| OK
|
|
|-
| vms_desktop.dll
|
|
|
|}

==Other Plugins==
{| border="1"
|-
! Plugin
! Status
! Provides
! Requires
|-
| gen_wa2_scrobbler.dll
|
|
|
|-
| in_mad.dll
| OK
|
|
|-
| in_mp3PRO.dll
|
|
|
|}

==Failure Reason Codes==
# All device synchronization plug-ins require OLE which as yet is not working.
# Requires Windows Media Player and also codecs for Windows Media Player.

Linux, Wine & MediaMonkey

MM on Wine: Milkdrop working

File:Wine07.png

2008-04-30T21:04:53Z

Botijo: MM on Wine: CD Burner screen (useless at the moment)

MM on Wine: CD Burner screen (useless at the moment)

File:Wine06.png

2008-04-30T21:04:12Z

Botijo: MM on Wine: Script that adds a Node to the tree. Album Art in the middle of screen.

MM on Wine: Script that adds a Node to the tree. Album Art in the middle of screen.

File:Wine05b.png

2008-04-30T21:01:19Z

Botijo: MM on Wine: After skin change

MM on Wine: After skin change

File:Wine05a.png

2008-04-30T21:00:48Z

Botijo: MM on Wine: Before changing Skin

MM on Wine: Before changing Skin

File:Wine04.png

2008-04-30T20:59:30Z

Botijo: MM on Wine: Extension management

MM on Wine: Extension management