From 993ea0c6c5a07cf9c2edadf2c0f6a378cde56acb Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 29 Jan 2005 22:02:37 +0000 Subject: - Patch #16111 by chx: generalized node_rewrite_query to db_rewrite_query. --- modules/queue.module | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'modules/queue.module') diff --git a/modules/queue.module b/modules/queue.module index df36698fb..831e92154 100644 --- a/modules/queue.module +++ b/modules/queue.module @@ -124,8 +124,8 @@ function queue_overview() { $header = array(array('data' => t('Subject')), array('data' => t('Author')), array('data' => t('Type')), array('data' => t('Score'))); $sql = 'SELECT n.nid, n.title, n.type, u.name, u.uid, SUM(IF(q.uid = %d, 1, 0)) AS voted, SUM(q.vote) AS score FROM {node} n INNER JOIN {users} u ON n.uid = u.uid INNER JOIN {queue} q ON n.nid = q.nid WHERE n.moderate = 1 GROUP BY n.nid, n.title, n.type, u.name, u.uid, q.uid, q.vote'; - $sql = node_rewrite_sql($sql); - $sql_count = node_rewrite_sql('SELECT COUNT(n.nid) FROM {node} n INNER JOIN {queue} q ON n.nid = q.nid WHERE n.moderate = 1'); + $sql = db_rewrite_sql($sql); + $sql_count = db_rewrite_sql('SELECT COUNT(n.nid) FROM {node} n INNER JOIN {queue} q ON n.nid = q.nid WHERE n.moderate = 1'); $result = pager_query($sql, 10, 0, $sql_count, $user->uid); while ($node = db_fetch_object($result)) { -- cgit v1.2.3