From e7edb55d63f78559972646af07107193c8c26a52 Mon Sep 17 00:00:00 2001 From: Steven Wittens Date: Mon, 17 Jan 2005 19:00:03 +0000 Subject: - The real code fixes ;) --- modules/queue.module | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'modules/queue.module') diff --git a/modules/queue.module b/modules/queue.module index e49d1319b..df36698fb 100644 --- a/modules/queue.module +++ b/modules/queue.module @@ -126,9 +126,9 @@ function queue_overview() { $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'); - $sresult = pager_query($sql, 10, 0,$sql_count , $user->uid); + $result = pager_query($sql, 10, 0, $sql_count, $user->uid); - while ($node = db_fetch_object($sresult)) { + while ($node = db_fetch_object($result)) { if ($user->uid == $node->uid || $node->voted) { $rows[] = array(array('data' => l($node->title, 'queue/'. $node->nid), 'class' => 'title'), array('data' => format_name($node), 'class' => 'name'), array('data' => module_invoke($node->type, 'node_name', $node), 'class' => 'type'), array('data' => $node->score, 'class' => 'score')); } @@ -138,7 +138,7 @@ function queue_overview() { } if ($pager = theme('pager', NULL, 10, 0, tablesort_pager())) { - $rows[] = array(array('data' => $pager, 'colspan' => '4')); + $rows[] = array(array('data' => $pager, 'colspan' => '4')); } if (!$rows) { -- cgit v1.2.3