diff options
| author | woro <woro@e10066b5-e1e2-0310-b819-94efdf66514b> | 2008-12-19 17:40:49 +0000 |
|---|---|---|
| committer | woro <woro@e10066b5-e1e2-0310-b819-94efdf66514b> | 2008-12-19 17:40:49 +0000 |
| commit | 431465e37e10795845745a04b789d26c2b438f7d (patch) | |
| tree | 047a1a2a40c51a0913d6476dd0db518bbb82d167 | |
| parent | d4f378664b1a82adf85bf0750e5521dcb8874c81 (diff) | |
| download | vdr-plugin-muggle-431465e37e10795845745a04b789d26c2b438f7d.tar.gz vdr-plugin-muggle-431465e37e10795845745a04b789d26c2b438f7d.tar.bz2 | |
mysql only: Fix order of insertion into playlistitem when the playlist
was
empty
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@1220 e10066b5-e1e2-0310-b819-94efdf66514b
| -rw-r--r-- | mg_db_gd_mysql.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mg_db_gd_mysql.c b/mg_db_gd_mysql.c index b93a449..c067a81 100644 --- a/mg_db_gd_mysql.c +++ b/mg_db_gd_mysql.c @@ -548,7 +548,7 @@ mgDbGd::AddToCollection( const string Name,const vector<mgItem*>&items, mgParts* // insert a unique trackid: string trackid = ltos(thread_id()+1000000); Execute("INSERT INTO playlistitem SELECT "+listid+"," - "MAX(tracknumber)+"+ltos(tracksize)+","+trackid+ + "CASE WHEN MAX(tracknumber) IS NULL THEN 0 ELSE MAX(tracknumber) END +"+ltos(tracksize)+","+trackid+ " FROM playlistitem WHERE playlist="+listid); // find tracknumber of the trackid we just inserted: |