From 4f7a46e075efe552dcd462ea25ca972708b00cc4 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sun, 28 May 2006 19:06:03 +0000 Subject: [PATCH] r857: Finished implementing fetch_user_cache() --- includes/class_notification.php | 17 ++++++++++++++++- 1 file changed, 16 insertions(+), 1 deletion(-) diff --git a/includes/class_notification.php b/includes/class_notification.php index 57d70aa..44fe869 100644 --- a/includes/class_notification.php +++ b/includes/class_notification.php @@ -119,7 +119,22 @@ class NotificationCenter $masterids = array_merge($this->roles['-notapplicable-'], $this->roles['reporter'], $this->roles['assignee'], $this->roles['favourite'], $this->roles['voter'], $this->roles['commenter']); $masterids = array_unique($masterids); - print_r($masterids); + $userinfo = $this->registry->db->query(" + SELECT user.*, useremail.* + FROM " . TABLE_PREFIX . "useremail AS useremail + LEFT JOIN " . TABLE_PREFIX . "user AS user + ON (user.userid = useremail.userid) + WHERE useremail.userid IN (" . implode(',', $masterids) . ") + "); + while ($user = $this->registry->db->fetch_array($userinfo)) + { + if (!is_array($this->users["$user[userid]"])) + { + $this->users["$user[userid]"] = $user; + unset($this->users["$user[userid]"]['mask'], $this->users["$user[userid]"]['relation']); + } + $this->users["$user[userid]"]['options']["$user[relation]"] = $user['mask']; + } } // ################################################################### -- 2.22.5