Diarmuid Wrote: > However I have no clue where to start on the sql syntax. Any hints or > links I should check out? There are a lot of different tutorials on the net, > just search on google and choose one that feels like the right level to start at. http://www.google.se/search?q=sql+tutorial
The key is really to understand the slimserver data model, that is the tables and the relation between the tables. A short introduction of the most important ones for creating playlists with the SQLPlayList plugin follows below. There are some sample playlists available in the included README.txt file, you can also use the web interface and look at the generated SQL queries to get ideas. More playlists templates are available in the web interface if you are running slimserver with the MySQL database or you are running the TrackStat plugin. tracks: Contains all tracks, the column audio = 1 will give you all songs. The table also contain rows for albums and these have audio=0. genres: Contains all genres. Often used in combination with tracks and genre_track table. contributors: Contains all artists and other contributors. Often used in combination with tracks and contributor_track table. albums: Contains all albums. genre_track: Contains the relation between a track and genres. A single track can have several rows in this table if it have more than one genre. contributor_track: Contains the relation between a track and artist/contributor. A single track can have serveral rows in this table if it have more than one artist/contributor. track_statistics: Table available only if you run the TrackStat plugin, contains information about rating, play counts and last played date set by the TrackStat plugin. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
