openrat-cms

commit 76a6dea4c89dfb36eb246f3f8f29e45189773208
parent 95d0af6e834c6e3346e81d2d9dcc1b2b7e48e230
Author: dankert <devnull@localhost>
Date:   Thu, 15 Oct 2009 00:18:26 +0200

Korrektur der Datenbank-SQL-Parameter.

Diffstat:
objectClasses/Acl.class.php
 | 
36
++++++++++++++++++++----------------

1 file changed, 20 insertions(+), 16 deletions(-)
diff --git a/objectClasses/Acl.class.php b/objectClasses/Acl.class.php
@@ -402,39 +402,43 @@ class Acl
 		$sql = new Sql('SELECT MAX(id) FROM {t_acl}');
 		$this->aclid = intval($db->getOne($sql))+1;
 		
-		$sql = new Sql( 'INSERT INTO {t_acl} '.
-		                ' (id,userid,groupid,objectid,is_write,is_prop,is_create_folder,is_create_file,is_create_link,is_create_page,is_delete,is_release,is_publish,is_grant,is_transmit,languageid)'.
-		                ' VALUES( {aclid},{userid},{groupid},{objectid},{write},{prop},{create_folder},{create_file},{create_link},{create_page},{delete},{release},{publish},{grant},{transmit},{languageid} )' );
+		$sql = new Sql( <<<SQL
+		INSERT INTO {t_acl} 
+		                 (id,userid,groupid,objectid,is_write,is_prop,is_create_folder,is_create_file,is_create_link,is_create_page,is_delete,is_release,is_publish,is_grant,is_transmit,languageid)
+		                 VALUES( {aclid},{userid},{groupid},{objectid},{write},{prop},{create_folder},{create_file},{create_link},{create_page},{delete},{release},{publish},{grant},{transmit},{languageid} )
+SQL
+);
 
 		$sql->setInt('aclid'   ,$this->aclid   );
-		$sql->setInt('objectid',$this->objectid);
-		
-		if	( intval($this->groupid) == 0 )
-			$sql->setNull('groupid');
-		else
-			$sql->setInt ('groupid',$this->groupid);
 		
 		if	( intval($this->userid) == 0 )
 			$sql->setNull('userid');
 		else
 			$sql->setInt ('userid',$this->userid);
+		
+		if	( intval($this->groupid) == 0 )
+			$sql->setNull('groupid');
+		else
+			$sql->setInt ('groupid',$this->groupid);
 
-		$sql->setBoolean('is_default'   ,$this->isDefault     );
-		$sql->setBoolean('prop'         ,$this->prop          );
+		$sql->setInt('objectid',$this->objectid);
+		//$sql->setBoolean('is_default'   ,$this->isDefault     );
 		$sql->setBoolean('write'        ,$this->write         );
+		$sql->setBoolean('prop'         ,$this->prop          );
+		$sql->setBoolean('create_folder',$this->create_folder );
+		$sql->setBoolean('create_file'  ,$this->create_file   );
+		$sql->setBoolean('create_link'  ,$this->create_link   );
+		$sql->setBoolean('create_page'  ,$this->create_page   );
 		$sql->setBoolean('delete'       ,$this->delete        );
 		$sql->setBoolean('release'      ,$this->release       );
 		$sql->setBoolean('publish'      ,$this->publish       );
 		$sql->setBoolean('grant'        ,$this->grant         );
 		$sql->setBoolean('transmit'     ,$this->transmit      );
-		$sql->setBoolean('create_folder',$this->create_folder );
-		$sql->setBoolean('create_file'  ,$this->create_file   );
-		$sql->setBoolean('create_link'  ,$this->create_link   );
-		$sql->setBoolean('create_page'  ,$this->create_page   );
 
 		if	( intval($this->languageid) == 0 )
 			$sql->setNull('languageid');
-		else	$sql->setInt ('languageid',$this->languageid);
+		else
+			$sql->setInt ('languageid',$this->languageid);
 
 		$db->query( $sql );
 	}