Changeset 1030 for trunk/common

Timestamp:

03/03/09 19:23:59 (3 years ago)

Author:

savin.tiberiu@…

Message:

 

Location:

trunk/common

Files:

• db/textblock.php (modified) (1 diff)
• security.php (modified) (1 diff)

trunk/common/db/textblock.php

@@ -72 +72 @@
 }
 
+// Delete $revision from database
+// The revision is identified by name and timestamp
+// $curr is true if $revision is the current revision and false otherwise
+function textblock_delete_revision($revision, $curr)
+{
+    if ($curr == false) {
+        $name = $revision['name'];
+        $timestamp = $revision['timestamp'];
+        $query = "DELETE FROM `ia_textblock_revision`
+            WHERE `name` = ".db_quote($name)." &&
+                `timestamp` = ".db_quote($timestamp);
+        db_query($query);
+    } else {
+        $name = $revision['name'];
+        $query = "REPLACE INTO `ia_textblock`
+                    (SELECT * FROM `ia_textblock_revision`
+                    WHERE `name` = ".db_quote($name)."
+                    ORDER BY `timestamp` DESC LIMIT 1)";
+        db_query($query);
+
+        //delete last_rev from ia_textblock_revision
+        $query = "DELETE FROM `ia_textblock_revision`
+                WHERE `name` = ".db_quote($name)."
+                ORDER BY `timestamp` DESC LIMIT 1";
+        db_query($query);
+    }
+}
+
 // This is the function called by most query functions.
 function textblock_complex_query($options)

trunk/common/security.php

@@ -131 +131 @@
         case 'round-delete':
         case 'textblock-delete':
+        case 'textblock-delete-revision':
         case 'grader-overwrite':
         case 'grader-delete':