diff options
author | RaK <RaK@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-02-10 01:23:06 +0000 |
---|---|---|
committer | RaK <RaK@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-02-10 01:23:06 +0000 |
commit | 17e61a9aec7d55086e00dab2ac3ad2dda3683eec (patch) | |
tree | 709e52707df7c1c20cd08ad35c9ee0e5324ae0d6 /muggle-plugin/gd_content_interface.c | |
parent | aff976904d87f660b52f34d26ec9efa3c68128c1 (diff) | |
download | vdr-plugin-muggle-17e61a9aec7d55086e00dab2ac3ad2dda3683eec.tar.gz vdr-plugin-muggle-17e61a9aec7d55086e00dab2ac3ad2dda3683eec.tar.bz2 |
Ein fehler beim Tracksearch behoben. geht jetzt, aber nur einmal?!?!
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk@34 e10066b5-e1e2-0310-b819-94efdf66514b
Diffstat (limited to 'muggle-plugin/gd_content_interface.c')
-rw-r--r-- | muggle-plugin/gd_content_interface.c | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/muggle-plugin/gd_content_interface.c b/muggle-plugin/gd_content_interface.c index e3c43f4..03b3929 100644 --- a/muggle-plugin/gd_content_interface.c +++ b/muggle-plugin/gd_content_interface.c @@ -3,10 +3,10 @@ * \brief Data Objects for content (e.g. mp3 files, movies) * for the vdr muggle plugindatabase ******************************************************************** - * \version $Revision: 1.10 $ - * \date $Date: 2004/02/09 23:21:33 $ + * \version $Revision: 1.11 $ + * \date $Date: 2004/02/10 01:23:06 $ * \author Ralf Klueber, Lars von Wedel, Andreas Kellner - * \author file owner: $Author: MountainMan $ + * \author file owner: $Author: RaK $ * * DUMMY * Implements main classes of for content items and interfaces to SQL databases @@ -40,7 +40,7 @@ int GdInitDatabase(MYSQL *db) } if(mysql_real_connect(db,"localhost","root","", - "GiantDisc2",0,NULL,0) == NULL) + "GiantDisc",0,NULL,0) == NULL) { return -2; } @@ -1142,10 +1142,9 @@ bool GdTreeNode::expand() if (m_level == 1) { sprintf(sqlbuff, "SELECT CONCAT(tracks.artist,' - ',tracks.title),tracks.id" - " FROM tracks,genre as genre1,genre as genre2,album" - " WHERE (genre1.id=tracks.genre1 OR" + " FROM tracks,genre as genre1,genre as genre2" + " WHERE (genre1.id=tracks.genre1 AND" " genre2.id=tracks.genre2) AND" - " (album.cddbid=tracks.sourceid) AND" " %s" " ORDER BY CONCAT(tracks.artist,' - ',tracks.title)" , m_restriction.c_str()); @@ -1159,7 +1158,7 @@ bool GdTreeNode::expand() " CONCAT(album.artist,' - ',album.title) as title," " album.cddbid" " FROM tracks,album,genre as genre1, genre as genre2" - " WHERE (genre1.id=tracks.genre1 OR" + " WHERE (genre1.id=tracks.genre1 AND" " genre2.id=tracks.genre2) AND" " %s" " ORDER BY CONCAT(album.artist,' - ',album.title)" @@ -1333,6 +1332,9 @@ mgContentItem* GdTreeNode::getSingleTrack() /* -------------------- begin CVS log --------------------------------- * $Log: gd_content_interface.c,v $ + * Revision 1.11 2004/02/10 01:23:06 RaK + * Ein fehler beim Tracksearch behoben. geht jetzt, aber nur einmal?!?! + * * Revision 1.10 2004/02/09 23:21:33 MountainMan * partial bug fixes * |