From a9377d6a3f8156ed686f122f791a813caef2e93f Mon Sep 17 00:00:00 2001
From: Max Kostikov <max@kostikov.co>
Date: Thu, 17 Sep 2020 23:25:55 +0200
Subject: Boost DB conversion speed to Z6

---
 Zotlabs/Module/Z6trans.php | 24 +++++++++++++++++++++---
 1 file changed, 21 insertions(+), 3 deletions(-)

diff --git a/Zotlabs/Module/Z6trans.php b/Zotlabs/Module/Z6trans.php
index 0caf096c9..31132bbe3 100644
--- a/Zotlabs/Module/Z6trans.php
+++ b/Zotlabs/Module/Z6trans.php
@@ -71,7 +71,25 @@ class Z6trans extends Controller {
 				}
 
 			}
+			
+			$zot = dbesc($zot_xchan);
+			$zot6 = dbesc($zot6_xchan);
+
+			// Item table
+			foreach(['owner_xchan', 'author_xchan'] as $x) {
+				$q .= sprintf("UPDATE item SET $x = '%s' WHERE $x = '%s';\r\n",
+					$zot6,
+					$zot
+				);
+			}
+			$q .= "UPDATE item SET source_xchan = replace(source_xchan, '$zot', '$zot6'), route = replace(route, '$zot', '$zot6'), allow_cid = replace(allow_cid, '$zot', '$zot6'), deny_cid = replace(deny_cid, '$zot', '$zot6');\r\n";
+
+			// photo table
+			$q .= "UPDATE photo SET xchan = replace(xchan, '$zot', '$zot6'), allow_cid = replace(allow_cid, '$zot', '$zot6'), deny_cid = replace(deny_cid, '$zot', '$zot6');\r\n";
 
+			// dreport table
+			$q .= "UPDATE dreport SET dreport_recip = '$zot6' WHERE dreport_recip = '$zot';\r\n";
+			$q .= "UPDATE dreport SET dreport_xchan = '$zot6' WHERE dreport_xchan = '$zot';\r\n";
 		}
 
 		if($q)
@@ -103,16 +121,16 @@ class Z6trans extends Controller {
 			'chatpresence' => ['cp_xchan'],
 			'chatroom' => ['allow_cid', 'deny_cid'],
 			'config' => ['v'],
-			'dreport' => ['dreport_recip', 'dreport_xchan'],
+//			'dreport' => ['dreport_recip', 'dreport_xchan'],
 			'event' => ['event_xchan', 'allow_cid', 'deny_cid'],
 			'iconfig' => ['v'],
-			'item' => ['owner_xchan', 'author_xchan', 'source_xchan', 'route', 'allow_cid', 'deny_cid'],
+//			'item' => ['owner_xchan', 'author_xchan', 'source_xchan', 'route', 'allow_cid', 'deny_cid'],
 			'mail' => ['from_xchan', 'to_xchan'],
 			'menu_item' => ['allow_cid', 'deny_cid'],
 			'obj' => ['allow_cid', 'deny_cid'],
 			'pconfig' => ['v'],
 			'pgrp_member' => ['xchan'],
-			'photo' => ['xchan', 'allow_cid', 'deny_cid'],
+//			'photo' => ['xchan', 'allow_cid', 'deny_cid'],
 			'source' => ['src_channel_xchan', 'src_xchan'],
 			'updates' => ['ud_hash'],
 			'xchat' => ['xchat_xchan'],
-- 
cgit v1.2.3