Changeset 42 for trunk/lib/RecordVersion.inc.php

Timestamp:

Dec 18, 2005 12:16:03 AM (18 years ago)

Author:

scdev

Message:

detabbed all files ;P

File:

• trunk/lib/RecordVersion.inc.php (modified) (20 diffs)

trunk/lib/RecordVersion.inc.php

@@ -1 +1 @@
 <?php
 /**
- * The RecordVersion:: class provides a system for saving, reviewing, and 
+ * The RecordVersion:: class provides a system for saving, reviewing, and
  * restoring versions of a record of any DB table. All the data in the record is
  * serialized, compressed, and saved in a blob in the version_tbl. Restoring a
  * version simply does a REPLACE INTO of the data. It is very simple, and works
  * with multiple database tables, but the drawback is that relationships for
- * a record cannot be retained. For example, an article from an article_tbl can 
+ * a record cannot be retained. For example, an article from an article_tbl can
  * be saved, but not categories associated to the record in a category_article_tbl.
  * The restored article will simple retain the relationships that the previous
@@ -40 +40 @@
     {
         static $instances = array();
-                
+
         if (!isset($instances[$auth_object->getVal('auth_name')])) {
             $instances[$auth_object->getVal('auth_name')] = new RecordVersion($auth_object);
@@ -58 +58 @@
             trigger_error('Constructor not provided a valid Auth_SQL object.', E_USER_ERROR);
         }
-        
+
         $this->_auth = $auth_object;
-        
+
         // Get create tables config from global context.
         if (!is_null(App::getParam('db_create_tables'))) {
@@ -66 +66 @@
         }
     }
-    
+
     /**
      * Setup the database table for this class.
@@ -77 +77 @@
     {
         static $_db_tested = false;
-    
+
         if ($recreate_db || !$_db_tested && $this->getParam('create_table')) {
             if ($recreate_db) {
@@ -98 +98 @@
                 KEY record_val (record_val)
             )");
-            
+
             if (!DB::columnExists($this->getParam('db_table'), array(
                 'version_id',
@@ -113 +113 @@
                 trigger_error(sprintf('Database table %s has invalid columns. Please update this table manually.', $this->getParam('db_table')), E_USER_ERROR);
             }
-        }    
+        }
         $_db_tested = true;
     }
@@ -160 +160 @@
     {
         $this->initDB();
-    
+
         // Get current record.
         if (!$record = $this->getCurrent($record_table, $record_key, $record_val)) {
@@ -166 +166 @@
             return false;
         }
-                
+
         // Clean-up old versions.
         $this->deleteOld($record_table, $record_key, $record_val);
-        
+
         // Save as new version.
         DB::query("
@@ -206 +206 @@
     {
         $this->initDB();
-    
+
         // Get version data.
         $qid = DB::query("
-            SELECT * FROM " . $this->getParam('db_table') . " 
+            SELECT * FROM " . $this->getParam('db_table') . "
             WHERE version_id = '" . addslashes($version_id) . "'
         ");
@@ -228 +228 @@
         // SQLize the keys of the specified versioned record.
         $replace_keys = join(",\n", array_map('addslashes', array_keys($data)));
-        
+
         // SQLize the keys of the values of the specified versioned record. (These are more complex because we need to account for SQL null values.)
         $replace_values = '';
@@ -236 +236 @@
             $comma = ',';
         }
-        
+
         // Replace current record with specified versioned record.
         DB::query("
@@ -245 +245 @@
             )
         ");
-        
+
         return $record;
     }
@@ -252 +252 @@
      * Version garbage collection. Deletes versions older than min_days
      * when quantity of versions exceeds min_qty. If quantity
-     * exceeds 100 within min_days, the oldest are deleted to bring the 
+     * exceeds 100 within min_days, the oldest are deleted to bring the
      * quantity back down to min_qty.
      *
@@ -264 +264 @@
     {
         $this->initDB();
-    
+
         // Get total number of versions for this record.
         $qid = DB::query("
@@ -273 +273 @@
         ");
         list($v_count) = mysql_fetch_row($qid);
-        
+
         if ($v_count > $this->getParam('min_qty')) {
             if ($v_count > $this->getParam('max_qty')) {
@@ -329 +329 @@
     {
         $this->initDB();
-    
+
         // Get versions of this record.
         $qid = DB::query("
@@ -358 +358 @@
     {
         $this->initDB();
-    
+
         // Get version data.
         $qid = DB::query("
-            SELECT * FROM " . $this->getParam('db_table') . " 
+            SELECT * FROM " . $this->getParam('db_table') . "
             WHERE version_id = '" . addslashes($version_id) . "'
         ");
@@ -377 +377 @@
     {
         $this->initDB();
-    
+
         // Get version data.
         $qid = DB::query("
-            SELECT * FROM " . $this->getParam('db_table') . " 
+            SELECT * FROM " . $this->getParam('db_table') . "
             WHERE version_id = '" . addslashes($version_id) . "'
         ");
@@ -401 +401 @@
     {
         $this->initDB();
-    
+
         $qid = DB::query("
             SELECT * FROM " . addslashes($record_table) . "