From: <che...@us...> - 2007-06-20 18:43:34
|
Revision: 578 http://mp-plugins.svn.sourceforge.net/mp-plugins/?rev=578&view=rev Author: chef_koch Date: 2007-06-20 11:43:30 -0700 (Wed, 20 Jun 2007) Log Message: ----------- just a visual change how the sql in Update() is build if there are any negative consequences with this change or you don't like it, i would revert it. ;) just drop me a note Modified Paths: -------------- trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/ApplicationItems/ApplicationItem.cs Modified: trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/ApplicationItems/ApplicationItem.cs =================================================================== --- trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/ApplicationItems/ApplicationItem.cs 2007-06-20 18:27:55 UTC (rev 577) +++ trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/ApplicationItems/ApplicationItem.cs 2007-06-20 18:43:30 UTC (rev 578) @@ -905,14 +905,35 @@ } try { - sql = String.Format("update tblApplicationItem set title = '{0}', shorttitle = '{1}', filename = '{2}', arguments = '{3}', windowstyle = '{4}', startupdir = '{5}', useshellexecute = '{6}', usequotes = '{7}', source_type = '{8}', source = '{9}', imagefile = '{10}',filedirectory = '{11}',imagedirectory = '{12}',validextensions = '{13}',importvalidimagesonly = '{14}',iposition = {15}, enabled = '{16}', fatherID = '{17}', enableGUIRefresh = '{18}', GUIRefreshPossible = '{19}', pincode = '{20}', contentID = '{21}', systemDefault = '{22}', WaitForExit = '{23}', preLaunch = '{24}', postLaunch = '{25}' where appID = {26}", - ProgramUtils.Encode(Title), ProgramUtils.Encode(ShortTitle), ProgramUtils.Encode(Filename), ProgramUtils.Encode(Arguments), - ProgramUtils.WindowStyleToStr(WindowStyle), ProgramUtils.Encode(StartupDir), ProgramUtils.BooleanToStr(UseShellExecute), - ProgramUtils.BooleanToStr(UseQuotes), ProgramUtils.ApplicationTypeToString(SourceType), ProgramUtils.Encode(Source), ProgramUtils.Encode(Imagefile), - ProgramUtils.Encode(FileDirectory), ProgramUtils.Encode(ImageDirectory), ProgramUtils.Encode(ValidExtensions), ProgramUtils.BooleanToStr(importValidImagesOnly), Position, - ProgramUtils.BooleanToStr(Enabled), FatherID, ProgramUtils.BooleanToStr(EnableGUIRefresh), ProgramUtils.BooleanToStr(GUIRefreshPossible), - Pincode, ContentID, ProgramUtils.Encode(SystemDefault), ProgramUtils.BooleanToStr(WaitForExit), ProgramUtils.Encode(PreLaunch), ProgramUtils.Encode(PostLaunch), - AppID); + sql = String.Format( + "update tblApplicationItem set" + + "title = '" + ProgramUtils.Encode(Title) + + "', shorttitle = '" + ProgramUtils.Encode(ShortTitle) + + "', filename = '" + ProgramUtils.Encode(Filename) + + "', arguments = '" + ProgramUtils.Encode(Arguments) + + "', windowstyle = '" + ProgramUtils.WindowStyleToStr(WindowStyle) + + "', startupdir = '" + ProgramUtils.Encode(StartupDir) + + "', useshellexecute = '" + ProgramUtils.BooleanToStr(UseShellExecute) + + "', usequotes = '" + ProgramUtils.BooleanToStr(UseQuotes) + + "', source_type = '" + ProgramUtils.ApplicationTypeToString(SourceType) + + "', source = '" + ProgramUtils.Encode(Source) + + "', imagefile = '" + ProgramUtils.Encode(Imagefile) + + "', filedirectory = '" + ProgramUtils.Encode(FileDirectory) + + "', imagedirectory = '" + ProgramUtils.Encode(ImageDirectory) + + "', validextensions = '" + ProgramUtils.Encode(ValidExtensions) + + "', importvalidimagesonly = '" + ProgramUtils.BooleanToStr(importValidImagesOnly) + + "', iposition = " + Position + + ", enabled = '" + ProgramUtils.BooleanToStr(Enabled) + + "', fatherID = '" + FatherID + + "', enableGUIRefresh = '" + ProgramUtils.BooleanToStr(EnableGUIRefresh) + + "', GUIRefreshPossible = '" + ProgramUtils.BooleanToStr(GUIRefreshPossible) + + "', pincode = '" + Pincode + + "', contentID = '" + ContentID + + "', systemDefault = '" + ProgramUtils.Encode(SystemDefault) + + "', WaitForExit = '" + ProgramUtils.BooleanToStr(WaitForExit) + + "', preLaunch = '" + ProgramUtils.Encode(PreLaunch) + + "', postLaunch = '" + ProgramUtils.Encode(PostLaunch) + + "' where appID = " + AppID); sqlDB.Execute(sql); } catch (SQLiteException ex) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |