MediaMonkey Wiki - User contributions [en]

Last.FM Scrobbler Plugin Info

2010-01-16T10:41:29Z

Bex:

= About Last.FM Scrobbler Support =

Mediamonkey supports the Last.FM 'scrobbler' plugins to submit played tracks within MediaMonkey itself (portable player sync'd played tracks are not supported).

Currently there are 3 main plugins available, only ONE of which should reside in the "<MediaMonkey program folder>\Plugins" folder.

'''NOTE''': '''Option 3''' Is recommended for use

== Option 1: gen_audioscrobbler.dll (v 1.1.10) ==

This is the last 'old style' plugin for winamp 2 compatible clients. This plugin uses a config panel normally accessed via Tool > Options > Player > General Plugins > Plugin Config.

You can download this from the links @ http://www.last.fm/forum/34905/_/135053

Occasionally the config panel will get hidden behind the MM app window, if the MM window is made smaller you can usually then click on the config panel to bring it to the front where you can change and save your settings. Alternative way is to use ALT+TAB to bring back focus to config panel.

This plugin does not support last.fm profile "Now Playing" updates, and some unicode characters can cause a track to not be submitted.

'''INSTALLATION:'''
* Download this: http://static.last.fm/plugins/audioscrobbler.wa.1.1.10.exe
* Install to \Program Files\Mediamonkey\Plugins\
* Choose 'General' option rather than 'Media library' option when installing.
* Restart MM or start it, and go into Tools -> Options -> General Plug-ins to enter your login information
* Scrobble!

== Option 2: gen_wa2_scrobbler.dll (v 2.x.x) ==

This is the offical current style of last.fm plugins. This plugin utilizes a 'tray application' which gives some additional metadata info and includes the last.fm radio player for streaming radio.

The last compatible version for v2 plugins is [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45], newer plugins are currently incompatible with MediaMonkey.

To configure the version 2 style, you must open the tray application and configure through it's options. The plugin does not have any self configure, nor will it function without the tray application installed and running (normally the plugin will start the tray app automatically).

The latest official plugins are always available at Last.FM http://www.last.fm/download/ keeping in mind that while the latest tray app should work, plugins newer than [http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe 2.0.45] will not.

'''INSTALLATION:'''
* Download this: http://static.last.fm/plugins/ass/WinampPluginSetup_2.0.45.0.exe
* Install to \Program Files\Mediamonkey\Plugins
* When last.fm tells you to update your plugin, don't do it, the newest plugin doesn't work.
* Scrobble!

== Option 3: gen_LastFMScrobbler.dll [http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34632&sd=d Native Last.FM Scrobbler Plugin] (beta) ==

Native MM last.fm plugin - Requires at least [http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34522&sd=d MediaMonkey version 3.1] Only one that Scrobbles Unicode Tracks Correctly; Does NOT need Last.fm Util/player to be installed (And if it is installed suggested action is to disable Scrobbling of tracks played in last.fm player).

See complete [http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34632&start=0 forum thread] for more details

'''INSTALLATION:'''
* Download at: http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34632&sd=d
* Double-click the downloaded file, and agree to install
* Go to Tools > Options > Last.fm Service to configure your username and password
* Scrobble!

Database Structure

2009-11-18T07:04:24Z

Bex:

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Database Structure

2009-11-18T06:45:59Z

Bex:

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings.
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Database Structure

2009-11-18T06:45:44Z

Bex:

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
UserLocale
* USERLOCALE - Sorts according to users locale in regional settings.
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

ISDBUIForm::ActiveControl

2009-11-10T19:55:36Z

Bex:

{{MethodDeclaration|SDBUIForm|ISDBUIForm|Property Get/Let ActiveControl As String}}

===Property description===

Sets focus to a control of the parent form.
The control is represented by its ControlName.

Gets ControlName of focused control.

Examples:

MyForm.ActiveControl = "MyEditBoxControlName"

MyForm.ActiveControl = MyEditBox.Common.ControlName

Introduced in MediaMonkey 3.1.2.1289

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUIForm|{{PAGENAME}}]]
[[Category:Interface ISDBUIForm|{{PAGENAME}}]]

ShiftState

2009-10-31T07:53:08Z

Bex:

Shift state is an integer value specifying set of keys currently pressed. It can be a combination (i.e. binary OR) of any of the following values:

:0 ... <Nothing>
:1 ... WinKey
:2 ... Shift
:4 ... Alt
:8 ... Ctrl
:16 ... Left mouse
:32 ... Right mouse
:64 ... Middle mouse

ISDBApplicationEvents::OnTrackEnd

2009-01-22T23:05:26Z

Bex:

{{MethodDeclaration|SDBApplication|ISDBApplicationEvents|Sub OnTrackEnd}}

===Event description===

This event is called when track playback is finished because the end of track is reached.

Introduced in MediaMonkey 3.1.0.1218.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBApplication|{{PAGENAME}}]]
[[Category:Interface ISDBApplicationEvents|{{PAGENAME}}]]

Database Structure

2009-01-21T23:06:22Z

Bex:

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statemant, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

ISDBApplicationEvents::OnShuffleClicked

2009-01-21T18:14:26Z

Bex:

{{MethodDeclaration|SDBApplication|ISDBApplicationEvents|Sub OnShuffleClicked}}

===Event description===

This event is called when state of Shuffle is changed.

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBApplication|{{PAGENAME}}]]
[[Category:Interface ISDBApplicationEvents|{{PAGENAME}}]]

ISDBApplicationEvents::OnRepeatClicked

2009-01-21T18:14:11Z

Bex:

{{MethodDeclaration|SDBApplication|ISDBApplicationEvents|Sub OnRepeatClicked}}

===Event description===

This event is called when state of Repeat is changed.

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBApplication|{{PAGENAME}}]]
[[Category:Interface ISDBApplicationEvents|{{PAGENAME}}]]

ISDBApplicationEvents::OnNowPlayingModified

2009-01-21T18:13:56Z

Bex:

{{MethodDeclaration|SDBApplication|ISDBApplicationEvents|Sub OnNowPlayingModified}}

===Event description===

This event is called when the content of Now Playing is modified in any way (tracks added, moved, deleted, ...).

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBApplication|{{PAGENAME}}]]
[[Category:Interface ISDBApplicationEvents|{{PAGENAME}}]]

ISDBApplicationEvents::OnNowPlayingSelectionChanged

2009-01-21T18:13:35Z

Bex:

{{MethodDeclaration|SDBApplication|ISDBApplicationEvents|Sub OnNowPlayingSelectionChanged}}

===Event description===

This event is called when there's any change in Now Playing selection (some tracks are selected or unselected).

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBApplication|{{PAGENAME}}]]
[[Category:Interface ISDBApplicationEvents|{{PAGENAME}}]]

ISDBApplicationEvents::OnIdle

2009-01-21T18:13:12Z

Bex:

{{MethodDeclaration|SDBApplication|ISDBApplicationEvents|Sub OnIdle}}

===Event description===

This event is called when MediaMonkey doesn't do anything and scripts can do something on background.

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBApplication|{{PAGENAME}}]]
[[Category:Interface ISDBApplicationEvents|{{PAGENAME}}]]

ISDBApplicationEvents::OnTrackListSelectionChanged

2009-01-21T16:58:20Z

Bex:

{{MethodDeclaration|SDBApplication|ISDBApplicationEvents|Sub OnTrackListSelectionChanged}}

===Event description===

This event is called when there's any change in the main tracklist selection (some tracks are selected or unselected).

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBApplication|{{PAGENAME}}]]
[[Category:Interface ISDBApplicationEvents|{{PAGENAME}}]]

ISDBUICommonEvents::OnExit

2009-01-21T16:57:41Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommonEvents|Sub OnExit(Control As Object)}}

===Parameters===

{{MethodParameters
|Control |Object |}}

===Event description===

This event is called when the associated control loses focus.

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommonEvents|{{PAGENAME}}]]

ISDBUICommonEvents::OnEnter

2009-01-21T16:48:34Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommonEvents|Sub OnEnter(Control As Object)}}

===Parameters===

{{MethodParameters
|Control |Object |}}

===Event description===

This event is called when the associated control gets focus.

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommonEvents|{{PAGENAME}}]]

ISDBUICommonEvents::OnDblClick

2009-01-21T16:48:16Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommonEvents|Sub OnDblClick(Control As Object)}}

===Parameters===

{{MethodParameters
|Control |Object |}}

===Event description===

This event is called when the associated control is double-clicked.

Introduced in MediaMonkey 3.1.0.1217.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommonEvents|{{PAGENAME}}]]

ISDBFileSystem::CopyFile

2009-01-21T00:44:58Z

Bex:

{{MethodDeclaration|SDBFileSystem|ISDBFileSystem|Function CopyFile(Source As String, Destination As String) As Boolean}}

===Parameters===

{{MethodParameters
|Source |String |Source filename.
|Destination |String |Destination filename.}}

===Method description===

Copies source file to the target file.

Introduced in MediaMonkey 3.1.0.1212.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBFileSystem|{{PAGENAME}}]]
[[Category:Interface ISDBFileSystem|{{PAGENAME}}]]

ISDBFileSystem::MoveFile

2009-01-21T00:44:38Z

Bex:

{{MethodDeclaration|SDBFileSystem|ISDBFileSystem|Function MoveFile(Source As String, Destination As String) As Boolean}}

===Parameters===

{{MethodParameters
|Source |String |Source filename.
|Destination |String |Destination filename.}}

===Method description===

Moves source file to the target file.

Introduced in MediaMonkey 3.1.0.1212.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBFileSystem|{{PAGENAME}}]]
[[Category:Interface ISDBFileSystem|{{PAGENAME}}]]

ISDBPlayer::PlaylistFocused

2009-01-21T00:42:14Z

Bex:

{{MethodDeclaration|SDBPlayer|ISDBPlayer|Property Get/Let PlaylistFocused (Index As Long) As Bool}}

===Property description===

Retuns or sets which track in Now Playing list is focused.

Introduced in MediaMonkey 3.1.0.1214.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBPlayer|{{PAGENAME}}]]
[[Category:Interface ISDBPlayer|{{PAGENAME}}]]

ISDBPlayer::PlaylistSelected

2009-01-21T00:41:46Z

Bex:

{{MethodDeclaration|SDBPlayer|ISDBPlayer|Property Get/Let PlaylistSelected (Index As Long) As Bool}}

===Property description===

Retuns or sets whether given track in Now Playing list is selected.

Introduced in MediaMonkey 3.1.0.1214.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBPlayer|{{PAGENAME}}]]
[[Category:Interface ISDBPlayer|{{PAGENAME}}]]

ISDBIniFile::Flush

2009-01-21T00:36:39Z

Bex:

{{MethodDeclaration|SDBIniFile|ISDBIniFile|Sub Flush}}

===Method description===

Saves all changes made to the ini file to disk. This is automatically done by MediaMonkey when all instances of the ini file (i.e. in all scripts!) are destroyed. You can call this for additional safety, when needed.

Introduced in MediaMonkey 3.1.0.1214.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBIniFile|{{PAGENAME}}]]
[[Category:Interface ISDBIniFile|{{PAGENAME}}]]

ISDBTracksWindow::Selected

2009-01-21T00:34:24Z

Bex:

{{MethodDeclaration|SDBTracksWindow|ISDBTracksWindow|Property Get/Let Selected( Index As Long) As Bool}}

===Property description===

Returns or sets whether given track in the main tracklist is selected or is not.

Introduced in MediaMonkey 3.1.0.1214.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBTracksWindow|{{PAGENAME}}]]
[[Category:Interface ISDBTracksWindow|{{PAGENAME}}]]

ISDBTracksWindow::Focused

2009-01-21T00:34:00Z

Bex:

{{MethodDeclaration|SDBTracksWindow|ISDBTracksWindow|Property Get/Let Focused As Long}}

===Property description===

Returns or sets focused track in the main track list.

Introduced in MediaMonkey 3.1.0.1214.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBTracksWindow|{{PAGENAME}}]]
[[Category:Interface ISDBTracksWindow|{{PAGENAME}}]]

ISDBScriptControl::Reload

2009-01-21T00:32:49Z

Bex:

{{MethodDeclaration|SDBScriptControl|ISDBScriptControl|Sub Reload(ScriptPath As String)}}

===Parameters===

{{MethodParameters
|ScriptPath |String |Script file to be reloaded.}}

===Method description===

This method is for script development only. When called with a full script path, the script will be reloaded from disk before the its next event is called and so updated source from disk is used instead of the already loaded code from memory.

In case the ScriptPath parameter is an empty string, all strings in memory will be reloaded.

Note that by calling this method you lose all global variables of the reloaded script, their content can't be preserved. On the other hand, all registered events are preserved.

Introduced in MediaMonkey 3.1.0.1212.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBScriptControl|{{PAGENAME}}]]
[[Category:Interface ISDBScriptControl|{{PAGENAME}}]]

ISDBUI::MainWindowFocus

2009-01-21T00:32:12Z

Bex:

{{MethodDeclaration|SDBUI|ISDBUI|Property Get/Let MainWindowFocus As Int}}

===Property description===

Returns or set the currently focused control of the main window. Possible values are:

:0 ... Undefined
:1 ... Tree
:2 ... Tracklist
:3 ... Search
:4 ... Now Playing

Introduced in MediaMonkey 3.1.0.1210.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUI|{{PAGENAME}}]]
[[Category:Interface ISDBUI|{{PAGENAME}}]]

ISDBUITreeListItem::TreeList

2009-01-21T00:31:37Z

Bex:

{{MethodDeclaration|SDBUITreeListItem|ISDBUITreeListItem|Property Get TreeList As [[SDBUITreeList]]}}

===Property description===

Returns treelist control this node belongs to.

Introduced in MediaMonkey 3.1.0.1208.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUITreeListItem|{{PAGENAME}}]]
[[Category:Interface ISDBUITreeListItem|{{PAGENAME}}]]

SDBUIListBox

2009-01-21T00:30:47Z

Bex:

{{AutomationObjectsList}}
== CoClass SDBUIListBox ==

Listbox (UI element).

Introduced in MediaMonkey 3.1.0.1208.

=== ISDBUIListBox members ===

{{MethodsList
|[[ISDBUIListBox::Common|Common]] |Property Get |
|[[ISDBUIListBox::ItemIndex|ItemIndex]] |Property Get/Let |
|[[ISDBUIListBox::Items|Items]] |Property Get/Let |
}}

=== ISDBUIListBoxEvents members ===

{{MethodsList
|[[ISDBUIListBoxEvents::OnChange|OnChange]] |Event |
}}

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

ISDBUIEdit::SelText

2009-01-21T00:28:23Z

Bex:

{{MethodDeclaration|SDBUIEdit|ISDBUIEdit|Property Get/Let SelText As String}}

===Property description===

Selected text (can't be edited using this property).

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUIEdit|{{PAGENAME}}]]
[[Category:Interface ISDBUIEdit|{{PAGENAME}}]]

ISDBUIEdit::SelStart

2009-01-21T00:28:07Z

Bex:

{{MethodDeclaration|SDBUIEdit|ISDBUIEdit|Property Get/Let SelStart As Integer}}

===Property description===

Start of selected text.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUIEdit|{{PAGENAME}}]]
[[Category:Interface ISDBUIEdit|{{PAGENAME}}]]

ISDBUIEdit::SelLength

2009-01-21T00:27:38Z

Bex:

{{MethodDeclaration|SDBUIEdit|ISDBUIEdit|Property Get/Let SelLength As Integer}}

===Property description===

Length of selected text.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUIEdit|{{PAGENAME}}]]
[[Category:Interface ISDBUIEdit|{{PAGENAME}}]]

ISDBUICommon::FontUnderline

2009-01-21T00:25:51Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommon|Property Get/Let FontUnderline As Bool}}

===Property description===

Whether font of the control is underlined.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommon|{{PAGENAME}}]]

ISDBUICommon::FontStrikeOut

2009-01-21T00:25:34Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommon|Property Get/Let FontStrikeOut As Bool}}

===Property description===

Whether font of the control is striked out.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommon|{{PAGENAME}}]]

ISDBUICommon::FontSize

2009-01-21T00:25:08Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommon|Property Get/Let FontSize As Int}}

===Property description===

Specifies size of font used for the control.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommon|{{PAGENAME}}]]

ISDBUICommon::FontName

2009-01-21T00:24:48Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommon|Property Get/Let FontName As String}}

===Property description===

Specifies name of font used for the control.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommon|{{PAGENAME}}]]

ISDBUICommon::FontItalic

2009-01-21T00:23:58Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommon|Property Get/Let FontItalic As Bool}}

===Property description===

Whether font of the control is Italic.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommon|{{PAGENAME}}]]

ISDBUICommon::FontColor

2009-01-21T00:23:41Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommon|Property Get/Let FontColor As Int}}

===Property description===

Specifies color of font used for the control.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommon|{{PAGENAME}}]]

ISDBUICommon::FontBold

2009-01-21T00:23:21Z

Bex:

{{MethodDeclaration|SDBUICommon|ISDBUICommon|Property Get/Let FontBold As Bool}}

===Property description===

Whether font of the control is Bold.

Introduced in MediaMonkey 3.1.0.1207.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBUICommon|{{PAGENAME}}]]
[[Category:Interface ISDBUICommon|{{PAGENAME}}]]

Database Structure

2009-01-21T00:21:27Z

Bex:

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, indicating how the word is pronounced in English (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statemant, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

ISDBApplicationEvents::OnTrackDeleting

2009-01-21T00:15:11Z

Bex:

{{MethodDeclaration|SDBApplication|ISDBApplicationEvents|Function OnTrackDeleting(Track As SDBSongData, FromDisk As Bool) As Bool}}

===Parameters===

{{MethodParameters
|Track |[[SDBSongData]] |Track to be deleted
|FromDisk |Bool |Will be deleted from disk, or just from Library?}}

===Event description===

This event is called when a track is about to be deleted. In case the event returns True, the track deletion doesn't proceed.

Introduced in MediaMonkey 3.1.0.1206.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBApplication|{{PAGENAME}}]]
[[Category:Interface ISDBApplicationEvents|{{PAGENAME}}]]

ISDBTree::Refresh

2009-01-21T00:09:42Z

Bex:

{{MethodDeclaration|SDBTree|ISDBTree|Sub Refresh}}

===Method description===

Causes the tree to be repainted. It's useful after some actions, e.g. changing tree node Caption doesn't repaint the node automatically and so this method might be needed.

Introduced in MediaMonkey 3.1.0.1216.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBTree|{{PAGENAME}}]]
[[Category:Interface ISDBTree|{{PAGENAME}}]]

Database Structure

2009-01-20T23:53:13Z

Bex:

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statemant, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Database Structure

2009-01-20T23:41:45Z

Bex:

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(SqlString,"@","@@")
Str = Replace(SqlString,"_","@_")
Str = Replace(SqlString,"%","@%")
Str = Replace(SqlString,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statemant, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
 '''Windows Vista:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

== Default Mediamonkey 2 Database location ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]

== Database structure ==
''(only most important tables)''

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

ISDBSongData::Year

2008-06-05T17:08:16Z

Bex: /* Property description */

{{MethodDeclaration|SDBSongData|ISDBSongData|Property Get/Let Year As Long}}

===Property description===

Year part of the full date. Note that if you set this value, you automatically erase Month and Day to 0. So, if you want to set the full date this way, you have to set Year first and only then Month and Day. Also, do not set Month and Day if Year is not set since it yields strange result.

{{Property Summary|SongData|Year|Value|Songs|Year|Integer|Date|19740000|}}

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

ISDBSongData::OriginalYear

2008-06-05T17:07:48Z

Bex: /* Property description */

{{MethodDeclaration|SDBSongData|ISDBSongData|Property Get/Let OriginalYear As Long}}

===Property description===

Year part of the full original date. Note that if you set this value, you automatically erase OriginalMonth and OriginalDay to 0. So, if you want to set the full date this way, you have to set Year first and only then Month and Day. Also, do not set OriginalMonth and OriginalDay if OriginalYear is not set since it yields strange result.

{{Property Summary|SongData|OriginalYear|Value|Songs|OrigYear|Integer|Original Date|19740000|}}

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

ISDBSongData::OriginalMonth

2008-06-05T17:02:09Z

Bex:

===Property description===

Month part of the full original date. It can be 1-12 or 0 in case it is unknown.

{{Property Summary|SongData|OriginalMonth|Value|Songs|Year|Integer|Date|19741023|}}

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

ISDBSongData::OriginalDay

2008-06-05T17:00:30Z

Bex:

===Property description===

Day part of the full original release date. It can be 1-31 or 0 in case it is unknown.

{{Property Summary|SongData|OriginalDay|Value|Songs|Year|Integer|Date|19741023|}}

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

SDBSongData

2008-06-05T16:55:53Z

Bex: /* ISDBSongData members */

{{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::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::DateAdded|DateAdded]]
|Property Get/Let
|
|
|DateAdded
|REAL
|
|
|-
|[[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::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}}]]

Moving MM to a new computer

2008-05-18T14:40:34Z

Bex: /* Introduction */

==Introduction==
If you want to move MM to a new computer but retain your database, follow these steps. If these steps are followed correctly, all information that is maintained by your database will be retained, including PlayHistory, PlayCounts, Dates Added, PlayLists and all other fields within MM.

==Copying your database==
Your database is located at:

'''Windows XP''': C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey

or

'''Windows Vista''': C:\Users\<USERNAME>\AppData\Local\Mediamonkey

and is called MM.DB (note that you will have to enable viewing of hidden Files and Folders to find this file).

After installing MM on the new computer, put your database in the correct location (as noted above) on the new computer.

==Moving your music to the new PC==
Next, you'll have to move all the music from the old PC onto the new one, making sure that the file directory for each track stays the same as on the old PC (with the exception of drive letter, though that can remain the same.)

==Installing the update drive-ID script==
After you do all of that, install [http://www.mediamonkey.com/forum/viewtopic.php?t=8975 this script] to your new PC. To install this script, first shut down MM. Next, copy the contents in the 'Code:' box at the link provided into notepad. Save the file as 'MM_HDDSerial.vbs' (without the quotes) in your C:\Program Files\MediaMonkey\Scripts folder. Next, within that same folder, find 'Scripts.ini'. Open this file with notepad and copy the following lines and paste them onto the end of the file, then save.

Copy these lines into Scripts.ini:

[HDDSerial]
 FileName=MM_HDDSerial.vbs
 ProcName=Change_HDD_Serial
 Order=99
 DisplayName=Move Device Content
 Description=Corrects broken links after exchanged harddrive
 Language=VBScript
 ScriptType=0

==Running the script==
Now you're ready to run the script. Open MM and run the script at Tools -> Scripts -> Move Device Content. If you receive any errors or the script doesn't appear under Tools -> Scripts, check that you have installed the script correctly, and/or try restarting MM.

Running the script will change the drive-ID within the MediaMonkey database to recognize your new drive, and all your database information will be retained. If you can play your music from MM, and tracks do not 'grey out', then you have successfully moved your MM installation to a new computer.

ISDBDatabase::GetFilterQuery

2008-03-08T11:27:05Z

Bex:

{{MethodDeclaration|SDBDatabase|ISDBDatabase|Function GetFilterQuery(ID As Integer) As String}}

===Parameters===

{{MethodParameters
|ID |Integer |ID of specified filter.}}

===Method description===

Returns the WHERE part of the SQL query used by specified filter.

Introduced in MediaMonkey 3.0.2.1135.

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBDatabase|{{PAGENAME}}]]
[[Category:Interface ISDBDatabase|{{PAGENAME}}]]