From 6854cb3f4d8219cf1829e32122eb2502a916eae9 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <mail@andreasbaumann.cc>
Date: Sat, 1 Feb 2020 09:05:48 +0100
Subject: initial checkin

---
 setup/upgrade/0.9.9/convert_private.php | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 setup/upgrade/0.9.9/convert_private.php

(limited to 'setup/upgrade/0.9.9/convert_private.php')

diff --git a/setup/upgrade/0.9.9/convert_private.php b/setup/upgrade/0.9.9/convert_private.php
new file mode 100644
index 0000000..b871d39
--- /dev/null
+++ b/setup/upgrade/0.9.9/convert_private.php
@@ -0,0 +1,26 @@
+<?php
+   /**********************************************************\
+   | This script converts the private/public history entries   |
+   \***********************************************************/
+   
+
+$check_sql = $db->query('SELECT * FROM {history} WHERE event_type = 26 OR event_type = 27');
+
+while ($row = $db->fetchRow($check_sql))
+{
+    $db->query('DELETE FROM {history} WHERE history_id = ?', array($row['history_id']));
+    if ($row['event_type'] == 26) {
+        $row['old_value'] = 0;
+        $row['new_value'] = 1;
+    }
+    if ($row['event_type'] == 27) {
+        $row['old_value'] = 1;
+        $row['new_value'] = 0;
+    }
+    $db->query("INSERT INTO {history} (task_id, user_id, event_date, event_type, field_changed, old_value, new_value)
+                                      VALUES(?, ?, ?, 0, 'mark_private', ?, ?)",
+                                      array($row['task_id'], $row['user_id'], $row['event_date'], $row['old_value'], $row['new_value']));
+}
+
+
+?>
-- 
cgit v1.2.3-70-g09d2