From 938d26ba3e9c6566d00f7393daa3e1b36f2e5479 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Wed, 11 Mar 2020 15:18:33 -0700 Subject: fix app links in DB when doing a site rename --- boot.php | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'boot.php') diff --git a/boot.php b/boot.php index 2e6d3c63c..db01a42a7 100755 --- a/boot.php +++ b/boot.php @@ -1593,6 +1593,22 @@ function fix_system_urls($oldurl, $newurl) { } } + // fix links in apps + + $a = q("select id, app_url, app_photo from app where app_url like '%s' OR app_photo like '%s'", + dbesc('%' . $oldurl . '%'), + dbesc('%' . $oldurl . '%') + ); + if($a) { + foreach($a as $aa) { + q("update app set app_url = '%s', app_photo = '%s' where id = %d", + dbesc(str_replace($oldurl,$newurl,$aa['app_url'])), + dbesc(str_replace($oldurl,$newurl,$aa['app_photo'])), + intval($aa['id']) + ); + } + } + // now replace any remote xchans whose photos are stored locally (which will be most if not all remote xchans) $r = q("select * from xchan where xchan_photo_l like '%s'", -- cgit v1.2.3