Changeset 169 for trunk/lib/Version.inc.php
- Timestamp:
- Jun 14, 2006 1:10:07 AM (18 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/lib/Version.inc.php
r161 r169 93 93 } 94 94 $db->query("CREATE TABLE IF NOT EXISTS " . $db->escapeString($this->getParam('db_table')) . " ( 95 version_id int NOT NULL auto_increment, 96 record_table varchar(255) NOT NULL default '', 97 record_key varchar(255) NOT NULL default '', 98 record_val varchar(255) NOT NULL default '', 99 version_data mediumblob NOT NULL, 100 version_title varchar(255) NOT NULL default '', 101 version_notes varchar(255) NOT NULL default '', 102 saved_by_user_id smallint(11) NOT NULL default '0', 103 version_datetime datetime NOT NULL default '0000-00-00 00:00:00', 95 version_id INT NOT NULL AUTO_INCREMENT, 96 record_table VARCHAR(255) NOT NULL DEFAULT '', 97 record_key VARCHAR(255) NOT NULL DEFAULT '', 98 record_val VARCHAR(255) NOT NULL DEFAULT '', 99 version_data MEDIUMBLOB NOT NULL, 100 version_title VARCHAR(255) NOT NULL DEFAULT '', 101 version_number SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', 102 version_notes VARCHAR(255) NOT NULL DEFAULT '', 103 saved_by_user_id SMALLINT(11) NOT NULL DEFAULT '0', 104 version_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', 104 105 PRIMARY KEY (version_id), 105 106 KEY record_table (record_table), … … 115 116 'version_data', 116 117 'version_title', 118 'version_number', 117 119 'version_notes', 118 120 'saved_by_user_id', … … 180 182 return false; 181 183 } 184 185 // Get previous version_number. 186 $qid = $db->query(" 187 SELECT MAX(version_number) FROM " . $db->escapeString($this->getParam('db_table')) . " 188 WHERE record_table = '" . $db->escapeString($record_table) . "' 189 AND record_key = '" . $db->escapeString($record_key) . "' 190 AND record_val = '" . $db->escapeString($record_val) . "' 191 "); 192 list($last_version_number) = mysql_fetch_row($qid); 182 193 183 194 // Clean-up old versions. … … 193 204 version_data, 194 205 version_title, 206 version_number, 195 207 version_notes, 196 208 saved_by_user_id, … … 202 214 '" . $db->escapeString(gzcompress(serialize($record), 9)) . "', 203 215 '" . $db->escapeString($title) . "', 216 '" . $db->escapeString($last_version_number + 1) . "', 204 217 '" . $db->escapeString($notes) . "', 205 218 '" . $db->escapeString($this->_auth->get('user_id')) . "', … … 354 367 // Get versions of this record. 355 368 $qid = $db->query(" 356 SELECT version_id, saved_by_user_id, version_datetime, version_title, version_notes 369 SELECT 370 version_id, 371 saved_by_user_id, 372 version_datetime, 373 version_title, 374 version_number, 375 version_notes 357 376 FROM " . $db->escapeString($this->getParam('db_table')) . " 358 377 WHERE record_table = '" . $db->escapeString($record_table) . "'
Note: See TracChangeset
for help on using the changeset viewer.