]> src.bluestatic.org Git - bugdar.git/blob - docs/update_history.php
r1406: Moving the rest of the email body texts (from class_notification.php) to templates
[bugdar.git] / docs / update_history.php
1 <?php
2
3 // $Id$
4
5 die('Remove die notice!');
6
7 chdir('./../');
8 require_once('./global.php');
9
10 $total = $nodo = 0;
11
12 $history = $db->query("SELECT * FROM " . TABLE_PREFIX . "history");
13 while ($log = $db->fetch_array($history))
14 {
15 $matches = array();
16 if (preg_match('#custom_field([0-9]+?)#i', $log['field'], $matches))
17 {
18 $db->query("UPDATE " . TABLE_PREFIX . "history SET field = 'custom.field{$matches[1]}' WHERE historyid = $log[historyid]");
19 }
20 else if (preg_match('#comment ([0-9]+?) (hidden|text)#i', $log['field'], $matches))
21 {
22 $db->query("UPDATE " . TABLE_PREFIX . "history SET field = 'comment.{$matches[2]}', commentid = {$matches[1]} WHERE historyid = $log[historyid]");
23 }
24 else if ($log['attachmentid'] != 0)
25 {
26 $db->query("UPDATE " . TABLE_PREFIX . "history SET field = 'attachment.{$log['field']}' WHERE historyid = $log[historyid]");
27 }
28 else if (!preg_match('#^(comment|attachment)?\.#', $log['field']))
29 {
30 foreach (array('original', 'changed') AS $array)
31 {
32 if (preg_match('# \(id: ([0-9]+?)\)$#i', $log["$array"], $matches))
33 {
34 $db->query("UPDATE " . TABLE_PREFIX . "history SET $array = {$matches[1]} WHERE historyid = $log[historyid]");
35 }
36 else if (preg_match('#user ?id:? ([0-9]+?)#i', $log["$array"], $matches))
37 {
38 $db->query("UPDATE " . TABLE_PREFIX . "history SET $array = {$matches[1]} WHERE historyid = $log[historyid]");
39 }
40 $db->query("UPDATE " . TABLE_PREFIX . "history SET field = '.{$log['field']}' WHERE historyid = $log[historyid]");
41 }
42 }
43 }
44
45 ?>