summaryrefslogtreecommitdiff
path: root/modules/poll
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2005-01-29 22:02:37 +0000
committerDries Buytaert <dries@buytaert.net>2005-01-29 22:02:37 +0000
commit993ea0c6c5a07cf9c2edadf2c0f6a378cde56acb (patch)
tree3a0999b14fee17844a3318ee2f564191a83e31f3 /modules/poll
parente6d36892abca87d1c668d6294106a154c219cee4 (diff)
downloadbrdo-993ea0c6c5a07cf9c2edadf2c0f6a378cde56acb.tar.gz
brdo-993ea0c6c5a07cf9c2edadf2c0f6a378cde56acb.tar.bz2
- Patch #16111 by chx: generalized node_rewrite_query to db_rewrite_query.
Diffstat (limited to 'modules/poll')
-rw-r--r--modules/poll/poll.module4
1 files changed, 2 insertions, 2 deletions
diff --git a/modules/poll/poll.module b/modules/poll/poll.module
index 84463bfb2..21eede302 100644
--- a/modules/poll/poll.module
+++ b/modules/poll/poll.module
@@ -51,7 +51,7 @@ function poll_block($op = 'list', $delta = 0) {
}
else if ($op == 'view') {
// Retrieve the latest poll.
- $sql = node_rewrite_sql("SELECT MAX(n.created) FROM {node} n WHERE n.type = 'poll' AND n.status = 1 AND n.moderate = 0");
+ $sql = db_rewrite_sql("SELECT MAX(n.created) FROM {node} n WHERE n.type = 'poll' AND n.status = 1 AND n.moderate = 0");
$timestamp = db_result(db_query($sql));
if ($timestamp) {
$poll = node_load(array('type' => 'poll', 'created' => $timestamp, 'moderate' => 0, 'status' => 1));
@@ -266,7 +266,7 @@ function poll_node_name($node) {
function poll_page() {
// List all polls
$sql = "SELECT n.nid, n.title, p.active, n.created, SUM(c.chvotes) AS votes FROM {node} n INNER JOIN {poll} p ON n.nid = p.nid INNER JOIN {poll_choices} c ON n.nid = c.nid WHERE type = 'poll' AND status = 1 AND moderate = 0 GROUP BY n.nid, n.title, p.active, n.created ORDER BY n.created DESC";
- $sql = node_rewrite_sql($sql);
+ $sql = db_rewrite_sql($sql);
$result = pager_query($sql, 15);
$output = '<ul>';
while ($node = db_fetch_object($result)) {