# HG changeset patch
# User teknolog
# Date 1267484276 0
# Node ID 7bca37ba5fa940e2b1a4c7160905681cfb1fc556
# Parent  08733234ccb199b0644b844ceb12f96696a4bc65
Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo

diff -r 08733234ccb1 -r 7bca37ba5fa9 application/sis/podcatcher_udeb.sis
Binary file application/sis/podcatcher_udeb.sis has changed
diff -r 08733234ccb1 -r 7bca37ba5fa9 application/sis/podcatcher_udeb_signed.sis
Binary file application/sis/podcatcher_udeb_signed.sis has changed
diff -r 08733234ccb1 -r 7bca37ba5fa9 application/sis/podcatcher_urel.sis
Binary file application/sis/podcatcher_urel.sis has changed
diff -r 08733234ccb1 -r 7bca37ba5fa9 application/sis/podcatcher_urel_signed.sis
Binary file application/sis/podcatcher_urel_signed.sis has changed
diff -r 08733234ccb1 -r 7bca37ba5fa9 engine/src/ShowEngine.cpp
--- a/engine/src/ShowEngine.cpp	Sun Feb 28 23:25:24 2010 +0000
+++ b/engine/src/ShowEngine.cpp	Mon Mar 01 22:57:56 2010 +0000
@@ -808,15 +808,28 @@
 	{
 	DP1("CShowEngine::DBUpdateShow, title='%S'", &aItem.Title());
 
+	HBufC* titleBuf = HBufC::NewLC(KMaxLineLength);
+	TPtr titlePtr(titleBuf->Des());
+	titlePtr.Copy(aItem.Title());
+	PodcastUtils::SQLEncode(titlePtr);
+
+	HBufC* descBuf = HBufC::NewLC(KMaxLineLength);
+	TPtr descPtr(descBuf->Des());
+	descPtr.Copy(aItem.Description());
+	PodcastUtils::SQLEncode(descPtr);
+
 	_LIT(KSqlStatement, "update shows set url=\"%S\", title=\"%S\", description=\"%S\", filename=\"%S\", position=\"%Lu\","
 			"playtime=\"%u\", playstate=\"%u\", downloadstate=\"%u\", feeduid=\"%u\", showsize=\"%u\", trackno=\"%u\","
 			"pubdate=\"%Lu\", showtype=\"%d\", lasterror=\"%d\" where uid=\"%u\"");
-	iSqlBuffer.Format(KSqlStatement, &aItem.Url(), &aItem.Title(), &aItem.Description(),
+	iSqlBuffer.Format(KSqlStatement, &aItem.Url(), &titlePtr, &descPtr,
 			&aItem.FileName(), aItem.Position().Int64(), aItem.PlayTime(),
 			aItem.PlayState(), aItem.DownloadState(), aItem.FeedUid(),
 			aItem.ShowSize(), aItem.TrackNo(), aItem.PubDate().Int64(),
 			aItem.ShowType(), aItem.LastError(), aItem.Uid());
 
+	CleanupStack::PopAndDestroy(descBuf);
+	CleanupStack::PopAndDestroy(titleBuf);
+
 	sqlite3_stmt *st;
 
 	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
diff -r 08733234ccb1 -r 7bca37ba5fa9 group/ABLD.BAT
--- a/group/ABLD.BAT	Sun Feb 28 23:25:24 2010 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,15 +0,0 @@
-@ECHO OFF
-
-REM Bldmake-generated batch file - ABLD.BAT
-REM ** DO NOT EDIT **
-
-perl -S ABLD.PL "\workspace\podcatcher\group\\" %1 %2 %3 %4 %5 %6 %7 %8 %9
-if errorlevel==1 goto CheckPerl
-goto End
-
-:CheckPerl
-perl -v >NUL
-if errorlevel==1 echo Is Perl, version 5.003_07 or later, installed?
-goto End
-
-:End