diff options
| author | RaK <RaK@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-02-12 07:56:46 +0000 |
|---|---|---|
| committer | RaK <RaK@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-02-12 07:56:46 +0000 |
| commit | 382da39b01bbde1c0f2fe06a92d2a4a0281644b9 (patch) | |
| tree | 9193ce1b33b048b3e0ad2a1f5095d04ad01e54df /muggle-plugin/gd_content_interface.c | |
| parent | 68673c2c01a04118570d363c4f3c2bac4e60d9c3 (diff) | |
| download | vdr-plugin-muggle-382da39b01bbde1c0f2fe06a92d2a4a0281644b9.tar.gz vdr-plugin-muggle-382da39b01bbde1c0f2fe06a92d2a4a0281644b9.tar.bz2 | |
- SQL Fehler bei der Playlist Search korrigiert
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk@37 e10066b5-e1e2-0310-b819-94efdf66514b
Diffstat (limited to 'muggle-plugin/gd_content_interface.c')
| -rw-r--r-- | muggle-plugin/gd_content_interface.c | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/muggle-plugin/gd_content_interface.c b/muggle-plugin/gd_content_interface.c index 0a71e23..c916e6a 100644 --- a/muggle-plugin/gd_content_interface.c +++ b/muggle-plugin/gd_content_interface.c @@ -3,8 +3,8 @@ * \brief Data Objects for content (e.g. mp3 files, movies) * for the vdr muggle plugindatabase ******************************************************************** - * \version $Revision: 1.13 $ - * \date $Date: 2004/02/11 21:55:16 $ + * \version $Revision: 1.14 $ + * \date $Date: 2004/02/12 07:56:46 $ * \author Ralf Klueber, Lars von Wedel, Andreas Kellner * \author file owner: $Author: RaK $ * @@ -1252,7 +1252,7 @@ bool GdTreeNode::expand() case 102: if (m_level == 1) { sprintf(sqlbuff, - "SELECT CONCAT(playlist.title,' (',playlist.author,')')," + "SELECT DISTINCT playlist.title," " playlist.id" " FROM playlist,playlistitem,tracks,genre as genre1,genre as genre2" " WHERE playlist.id=playlistitem.playlist AND" @@ -1260,18 +1260,18 @@ bool GdTreeNode::expand() " genre1.id=tracks.genre1 AND" " genre2.id=tracks.genre2 AND" " %s" - " ORDER CONCAT(playlist.title,' (',playlist.author,')')," + " ORDER BY playlist.title," , m_restriction.c_str()); idfield = "playlist.id"; } else if (m_level == 2) { sprintf(sqlbuff, - "SELECT DISTINCT CONCAT(tracks.artist,' - ',tracks.title)," + "SELECT CONCAT(tracks.artist,' - ',tracks.title)," " tracks.id" " FROM playlist,playlistitem,tracks" " WHERE playlist.id=playlistitem.playlist AND" " playlistitem.trackid=tracks.id AND" " %s" - " ORDER playlistitem.tracknumber" + " ORDER BY playlistitem.tracknumber" , m_restriction.c_str()); idfield = "tracks.id"; } else { @@ -1438,6 +1438,9 @@ mgContentItem* GdTreeNode::getSingleTrack() /* -------------------- begin CVS log --------------------------------- * $Log: gd_content_interface.c,v $ + * Revision 1.14 2004/02/12 07:56:46 RaK + * - SQL Fehler bei der Playlist Search korrigiert + * * Revision 1.13 2004/02/11 21:55:16 RaK * - playlistsearch eingebaut * - filter search liefert nun in der zweiten |