[Mp-plugins-svn] SF.net SVN: mp-plugins: [530] trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt /FileItems/FilelinkList.cs

[<nor...@us...>]

Revision: 530
          http://mp-plugins.svn.sourceforge.net/mp-plugins/?rev=530&view=rev
Author:   northern_sky
Date:     2007-06-12 16:09:40 -0700 (Tue, 12 Jun 2007)

Log Message:
-----------
fixed genrebug

Modified Paths:
--------------
    trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/FileItems/FilelinkList.cs

Modified: trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/FileItems/FilelinkList.cs
===================================================================
--- trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/FileItems/FilelinkList.cs	2007-06-12 23:06:25 UTC (rev 529)
+++ trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/FileItems/FilelinkList.cs	2007-06-12 23:09:40 UTC (rev 530)
@@ -87,8 +87,8 @@
         // applicationItem.
         // SPECIAL: the current application IS NOT the application with the launchinfo!
         strSQL = String.Format(
-          "SELECT fi.appid AS targetappid, fi.grouperappid AS grouperappid, f.fileid AS fileid, title, uppertitle, f.filename as filename, filepath, imagefile, genre, genre2, genre3, genre4, genre5, country, manufacturer, YEAR, rating, overview, SYSTEM, import_flag, manualfilename, lasttimelaunched, launchcount, isfolder, external_id FROM tblFileItem f, tblFilterItem fi WHERE f.fileid = fi.fileid AND grouperappid = {0} ORDER BY filepath, uppertitle", nAppID);
-        results = sqlDB.Execute(strSQL);
+           "SELECT fi.appid AS targetappid, fi.grouperappid AS grouperappid, f.fileid AS fileid, title, uppertitle, f.filename as filename, filepath, imagefile, mainGenre, subGenre, country, manufacturer, YEAR, rating, overview, SYSTEM, import_flag, manualfilename, lasttimelaunched, launchcount, isfolder, external_id FROM tblFileItem f, tblFilterItem fi WHERE f.fileid = fi.fileid AND grouperappid = {0} ORDER BY filepath, uppertitle", nAppID);
+          results = sqlDB.Execute(strSQL);
         if (results.Rows.Count == 0)
           return;
         for (int iRow = 0; iRow < results.Rows.Count; iRow++)


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.