From a9833a395ff129a5fc4978b7ea08f0d2a84f9be6 Mon Sep 17 00:00:00 2001 From: Michael Date: Fri, 13 Jan 2017 10:37:39 +0000 Subject: [PATCH] The relay query now uses a better index --- include/diaspora.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/include/diaspora.php b/include/diaspora.php index fc88c79bf2..fdbc0479f9 100644 --- a/include/diaspora.php +++ b/include/diaspora.php @@ -45,13 +45,13 @@ class Diaspora { foreach($servers AS $server) { $server = trim($server); + $addr = "relay@".str_replace("http://", "", normalise_link($server)); $batch = $server."/receive/public"; - $relais = q("SELECT `batch`, `id`, `name`,`network` FROM `contact` WHERE `uid` = 0 AND `batch` = '%s' LIMIT 1", dbesc($batch)); + $relais = q("SELECT `batch`, `id`, `name`,`network` FROM `contact` WHERE `uid` = 0 AND `batch` = '%s' AND `addr` = '%s' AND `nurl` = '%s' LIMIT 1", + dbesc($batch), dbesc($addr), dbesc(normalise_link($server))); if (!$relais) { - $addr = "relay@".str_replace("http://", "", normalise_link($server)); - $r = q("INSERT INTO `contact` (`uid`, `created`, `name`, `nick`, `addr`, `url`, `nurl`, `batch`, `network`, `rel`, `blocked`, `pending`, `writable`, `name-date`, `uri-date`, `avatar-date`) VALUES (0, '%s', '%s', 'relay', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, '%s', '%s', '%s')", datetime_convert(), -- 2.39.5