openrat-cms

commit 50f9238b6b0a3df980f07227d4bb32b856d95a9f
parent f92ed507f2ae294c6b6d01ed1218472b4b53939e
Author: dankert <devnull@localhost>
Date:   Thu,  8 Oct 2009 23:00:23 +0200

Korrektur: SQL-Objekt nicht wiederverwenden.

Diffstat:
M
objectClasses/Object.class.php
 | 
20
++++++++++++++------

1 file changed, 14 insertions(+), 6 deletions(-)
diff --git a/objectClasses/Object.class.php b/objectClasses/Object.class.php
@@ -840,18 +840,26 @@ SQL
 		global $SESS;
 		$db = db_connection();
 
-		$sql = new Sql('SELECT COUNT(*) FROM {t_name} '.' WHERE objectid  ={objectid}'.'   AND languageid={languageid}');
+		$sql = new Sql(<<<SQL
+SELECT COUNT(*) FROM {t_name}  WHERE objectid  ={objectid} AND languageid={languageid}
+SQL
+);
 		$sql->setInt( 'objectid'  , $this->objectid   );
 		$sql->setInt( 'languageid', $this->languageid );
 		$count = $db->getOne($sql);
 
 		if ($count > 0)
 		{
-			$sql->setQuery('UPDATE {t_name} SET '.
-			               '  name  = {name},'.
-			               '  descr = {desc} '.
-			               ' WHERE objectid  ={objectid}'.
-			               '   AND languageid={languageid}');
+			$sql = new Sql( <<<SQL
+			UPDATE {t_name} SET 
+			                 name  = {name},
+			                 descr = {desc}
+			                WHERE objectid  ={objectid}
+			                  AND languageid={languageid}
+SQL
+);
+			$sql->setInt( 'objectid'  , $this->objectid   );
+			$sql->setInt( 'languageid', $this->languageid );
 			$sql->setString('name', $this->name);
 			$sql->setString('desc', $this->desc);
 			$db->query($sql);