You are here

function poll_votes in Drupal 6

Same name and namespace in other branches
  1. 5 modules/poll/poll.module \poll_votes()
  2. 7 modules/poll/poll.pages.inc \poll_votes()

Callback for the 'votes' tab for polls you can see other votes on

2 string references to 'poll_votes'
poll_menu in modules/poll/poll.module
Implementation of hook_menu().
system_update_6043 in modules/system/system.install
Update table indices to make them more rational and useful.

File

modules/poll/poll.pages.inc, line 29
User page callbacks for the poll module.

Code

function poll_votes($node) {
  drupal_set_title(check_plain($node->title));
  $output = t('This table lists all the recorded votes for this poll. If anonymous users are allowed to vote, they will be identified by the IP address of the computer they used when they voted.');
  $header[] = array(
    'data' => t('Visitor'),
    'field' => 'u.name',
  );
  $header[] = array(
    'data' => t('Vote'),
    'field' => 'pv.chorder',
  );
  $result = pager_query("SELECT pv.chorder, pv.uid, pv.hostname, u.name FROM {poll_votes} pv LEFT JOIN {users} u ON pv.uid = u.uid WHERE pv.nid = %d" . tablesort_sql($header), 20, 0, NULL, $node->nid);
  $rows = array();
  while ($vote = db_fetch_object($result)) {
    $rows[] = array(
      $vote->name ? theme('username', $vote) : check_plain($vote->hostname),
      check_plain($node->choice[$vote->chorder]['chtext']),
    );
  }
  $output .= theme('table', $header, $rows);
  $output .= theme('pager', NULL, 20, 0);
  return $output;
}