From d64bc008fdff5cad8634395c375a744b8fe960d4 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Fri, 17 Oct 2003 16:10:48 +0000 Subject: Patch by Moshe: - comment.module: fixed an ambigous 'timestamp' query - forum.module: prev/next links no longer excerpt from the title+body in their title attribute. they now excerpt from only their title. this is more consistent with rest of drupal, and GROUP BY on node.body which isn't appreciated by MSSQL. also replaced some '' with NULL which caused errors in MSSQL - statistics.module: replaced a USING join with a standard ON join. USING is not as widely supported, and functionally equivalent. --- modules/statistics/statistics.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/statistics/statistics.module') diff --git a/modules/statistics/statistics.module b/modules/statistics/statistics.module index 0cd4df2a7..06cb508ae 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/statistics.module @@ -326,7 +326,7 @@ function statistics_admin_topnodes_table() { array("data" => t("last hit"), "field" => "s.timestamp"), array("data" => t("operations")) ); - $sql = "SELECT s.nid, s.daycount, s.totalcount, s.timestamp, n.title FROM {statistics} s INNER JOIN {node} n USING (nid)"; + $sql = "SELECT s.nid, s.daycount, s.totalcount, s.timestamp, n.title FROM {statistics} s INNER JOIN {node} n ON s.nid = n.nid"; $sql .= tablesort_sql($header); $result = pager_query($sql, 20); // WHERE s.%s <> '0' -- cgit v1.2.3