[pLog-svn] r1795 - plog/branches/plog-1.0.1/class/gallery/dao

[oscar at devel.plogworld.net]

Author: oscar
Date: 2005-04-10 10:33:32 +0000 (Sun, 10 Apr 2005)
New Revision: 1795

Modified:
   plog/branches/plog-1.0.1/class/gallery/dao/galleryalbums.class.php
   plog/branches/plog-1.0.1/class/gallery/dao/galleryresources.class.php
Log:
fixed issue 417 even more...

Modified: plog/branches/plog-1.0.1/class/gallery/dao/galleryalbums.class.php
===================================================================
--- plog/branches/plog-1.0.1/class/gallery/dao/galleryalbums.class.php	2005-04-10 10:16:15 UTC (rev 1794)
+++ plog/branches/plog-1.0.1/class/gallery/dao/galleryalbums.class.php	2005-04-10 10:33:32 UTC (rev 1795)
@@ -266,8 +266,8 @@
                       parent_id = ".$album->getParentId().",
                       properties = '".serialize($album->getProperties())."',
                       show_album = ".$album->getShowAlbum().",
-                      normalized_name = '".$tf->normalizeText($album->getName())."',
-                      normalized_description = '".$tf->normalizeText($album->getDescription())."',
+                      normalized_name = '".Db::qstr($tf->normalizeText($album->getName()))."',
+                      normalized_description = '".Db::qstr($tf->normalizeText($album->getDescription()))."',
 					  mangled_name = '".$tf->urlize($album->getName())."'
                       WHERE id = ".$album->getId().";";
 

Modified: plog/branches/plog-1.0.1/class/gallery/dao/galleryresources.class.php
===================================================================
--- plog/branches/plog-1.0.1/class/gallery/dao/galleryresources.class.php	2005-04-10 10:16:15 UTC (rev 1794)
+++ plog/branches/plog-1.0.1/class/gallery/dao/galleryresources.class.php	2005-04-10 10:33:32 UTC (rev 1795)
@@ -324,7 +324,7 @@
 						  file_path, file_name, metadata, thumbnail_format, normalized_description) VALUES (
 						  $ownerId, $albumId, '".Db::qstr($description)."', $flags, $resourceType,
 						  '$filePath', '$fileName', '$serMetadata', '$thumbnailFormat',
-				  '$normalizedDescription');";	
+				  '".Db::qstr($normalizedDescription)."');";	
 						  
 			$result = $this->Execute( $query );
 
@@ -628,7 +628,7 @@
                       metadata = '".Db::qstr(serialize($resource->getMetadata()))."',
 					  thumbnail_format ='".$resource->getThumbnailFormat()."',
                       date = '".$resource->getDate()."',
-                      normalized_description = '".$tf->normalizeText( $resource->getDescription())."'
+                      normalized_description = '".Db::qstr($tf->normalizeText( $resource->getDescription()))."'
                       WHERE id = ".$resource->getId();
 
             $result = $this->Execute( $query );