Changeset 1236

Timestamp:

09/18/2008 01:01:22 AM (2 years ago)

Author:

DotMG

Message:

refs #811

Applied code in #811#comment:6

Files:

• branches/1.1.6.6/libs/Wakka.class.php (modified) (1 diff)

branches/1.1.6.6/libs/Wakka.class.php

@@ -1670 +1670 @@
         }
         function SaveACL($tag, $privilege, $list) {
+                // the $default will be put in the SET statement of the INSERT SQL for default values. It isn't used in UPDATE.
+                $default = "read_acl = '', write_acl = '', comment_acl = '', ";
+                // we strip the privilege_acl from default, to avoid redundancy
+                $default = str_replace($privilege."_acl = '',", '', $default);
                 if ($this->LoadACL($tag, $privilege, 0)) $this->Query("UPDATE ".$this->config["table_prefix"]."acls SET ".mysql_real_escape_string($privilege)."_acl = '".mysql_real_escape_string(trim(str_replace("\r", "", $list)))."' WHERE page_tag = '".mysql_real_escape_string($tag)."' LIMIT 1");
-                else $this->Query("INSERT INTO ".$this->config["table_prefix"]."acls SET page_tag = '".mysql_real_escape_string($tag)."', ".mysql_real_escape_string($privilege)."_acl = '".mysql_real_escape_string(trim(str_replace("\r", "", $list)))."'");
+                else $this->Query("INSERT INTO ".$this->config["table_prefix"]."acls SET $default page_tag = '".mysql_real_escape_string($tag)."', ".mysql_real_escape_string($privilege)."_acl = '".mysql_real_escape_string(trim(str_replace("\r", "", $list)))."'");
         }
         function TrimACLs($list) {