2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
25 DELETE FROM history WHERE field IN ('lastposttime', 'lastpostby', 'hiddenlastposttime', 'hiddenlastpostby')
32 * This class is used to record changes in a bug's fields, comments, and
35 * @author Iris Studios, Inc.
36 * @copyright Copyright ©2002 - [#]year[#], Iris Studios, Inc.
55 var $attachmentid = 0;
65 * The original data to compare against
69 var $original = array();
76 var $modified = array();
79 * Compared/diff'd data
83 var $compared = array();
85 // ###################################################################
87 * Sets the bug ID for the current logging instance
91 * @param integer New bug ID
93 function set_bugid($newbugid)
95 $this->bugid
= $newbugid;
98 // ###################################################################
100 * Sets the attachment ID for the current logging instance
104 * @param integer New attachment ID
106 function set_attachmentid($id)
108 $this->attachmentid
= $id;
111 // ###################################################################
113 * Sets the current comment ID to be logged
117 * @param integer New comment ID
119 function set_commentid($id)
121 $this->commentid
= $id;
124 // ###################################################################
126 * Assigns data into the $this->original or $this->modified array based
127 * on the passed arrays of information and the fields to add (and what
128 * name to add them under), and any prefix
132 * @param bool TRUE for original, FALSE for modified
133 * @param array Data array
134 * @param array List of fields in the data array to add; in format of array('field name' => 'display name', 'display name 2', 'display name 3')
135 * @param bool If TRUE, then the list of fields is used to exclude, not include
136 * @param string Field prefix
138 function add_data($orig, $data, $fields, $exclude = false
, $prefix = '')
140 $array = ($orig ?
'original' : 'modified');
143 if ($exclude == false
)
145 foreach ($fields AS $fname => $fdisplay)
147 if (is_numeric($fname))
152 $this->{$array}["$prefix$fdisplay"] = array('name' => $fname, 'value' => $data["$fname"]);
157 foreach ($data AS $fname => $value)
159 if (!in_array($fname, $fields))
161 $this->{$array}["$prefix$fname"] = array('name' => $fname, 'value' => $value);
167 // ###################################################################
169 * Populates the $this->compared array as a diff between the original
170 * and modified data. This is then used to create the databse queries.
174 function compare_arrays()
176 $newfields = array_diff_assoc($this->modified
, $this->original
);
177 $removedfields = array_diff_assoc($this->original
, $this->modified
);
179 foreach ($this->modified
AS $key => $value)
181 if ($this->original
["$key"] != $value)
183 $this->compared
["$key"] = array('old' => $this->original
["$key"]['value'], 'new' => $this->modified
["$key"]['value']);
187 foreach ($newfields AS $field)
189 $this->compared
["$field"] = array('old' => null
, 'new' => $this->modified
["$field"]['value']);
192 foreach ($removedfields AS $field)
194 $this->compared
["$field"] = array('old' => $this->original
["$field"]['value'], 'new' => null
);
198 // ###################################################################
200 * Runs $this->compare_arrays() and then takes the result and prepares
201 * it for insertion into the history database.
205 function update_history()
209 $this->compare_arrays();
211 foreach ($this->compared
AS $field => $values)
214 INSERT INTO " . TABLE_PREFIX
. "history
215 (bugid, attachmentid, commentid, dateline, userid, field, original, changed)
217 (" . $bugsys->clean($this->bugid
, TYPE_UINT
) . ", " . $bugsys->clean($this->attachmentid
, TYPE_UINT
) . ",
218 " . $bugsys->clean($this->commentid
, TYPE_UINT
) . ", " . TIMENOW
. ", " . $bugsys->userinfo
['userid'] . ",
219 '" . $bugsys->db
->escape_string($field) . "', '" . $bugsys->db
->escape_string($values['old']) . "',
220 '" . $bugsys->db
->escape_string($values['new']) . "'
227 /*=====================================================================*\
228 || ###################################################################
231 || ###################################################################
232 \*=====================================================================*/