From 6eb4254d06a1c261b0a46283b1952a6e6182537b Mon Sep 17 00:00:00 2001 From: Michael Vogel Date: Sat, 31 Jan 2015 23:13:21 +0100 Subject: [PATCH] The query after an API post was improved to make it faster. --- include/api.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/include/api.php b/include/api.php index 2d3c31af0c..c8a313ce19 100644 --- a/include/api.php +++ b/include/api.php @@ -848,7 +848,7 @@ // get last public wall message $lastwall = q("SELECT `item`.*, `i`.`contact-id` as `reply_uid`, `i`.`author-link` AS `item-author` FROM `item`, `item` as `i` - WHERE `item`.`contact-id` = %d + WHERE `item`.`contact-id` = %d AND `item`.`uid` = %d AND ((`item`.`author-link` IN ('%s', '%s')) OR (`item`.`owner-link` IN ('%s', '%s'))) AND `i`.`id` = `item`.`parent` AND `item`.`type`!='activity' @@ -856,6 +856,7 @@ ORDER BY `item`.`created` DESC LIMIT 1", intval($user_info['cid']), + intval(api_user()), dbesc($user_info['url']), dbesc(normalise_link($user_info['url'])), dbesc($user_info['url']), -- 2.39.5