From 8e657f64efb3c3e12365d1c33e6ab89e40d9bfd5 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 9 Sep 2003 18:18:43 +0000 Subject: - Gerhard's uid 0 patches. These patches bring various performance improvements. Requires a database update. --- modules/watchdog.module | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'modules/watchdog.module') diff --git a/modules/watchdog.module b/modules/watchdog.module index 0d3165351..1a3c83bda 100644 --- a/modules/watchdog.module +++ b/modules/watchdog.module @@ -77,7 +77,7 @@ function watchdog_overview($type) { array("data" => t("user"), "field" => "u.name"), array("data" => t("operations"), "colspan" => "2") ); - $sql = "SELECT w.*, u.name, u.uid FROM {watchdog} w LEFT JOIN {users} u ON w.uid = u.uid ". ($type ? $query[$type] : ""); + $sql = "SELECT w.*, u.name, u.uid FROM {watchdog} w INNER JOIN {users} u ON w.uid = u.uid ". ($type ? $query[$type] : ""); $sql .= tablesort_sql($header); $result = pager_query($sql, 50); @@ -105,7 +105,7 @@ function watchdog_overview($type) { function watchdog_view($id) { - $result = db_query("SELECT w.*, u.name, u.uid FROM {watchdog} w LEFT JOIN {users} u ON w.uid = u.uid WHERE w.wid = %d", $id); + $result = db_query("SELECT w.*, u.name, u.uid FROM {watchdog} w INNER JOIN {users} u ON w.uid = u.uid WHERE w.wid = %d", $id); if ($watchdog = db_fetch_object($result)) { $output .= ""; -- cgit v1.2.3