summaryrefslogtreecommitdiff
path: root/muggle-plugin/gd_content_interface.c
diff options
context:
space:
mode:
authorRaK <RaK@e10066b5-e1e2-0310-b819-94efdf66514b>2004-02-10 01:23:06 +0000
committerRaK <RaK@e10066b5-e1e2-0310-b819-94efdf66514b>2004-02-10 01:23:06 +0000
commit17e61a9aec7d55086e00dab2ac3ad2dda3683eec (patch)
tree709e52707df7c1c20cd08ad35c9ee0e5324ae0d6 /muggle-plugin/gd_content_interface.c
parentaff976904d87f660b52f34d26ec9efa3c68128c1 (diff)
downloadvdr-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.c18
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
*