viewpoll.php

   1 <?php
   2 $page_name = 'Current Poll';
   3 require ('config.php');
   4 if (!empty ($_POST['submit']))
   5 {
   6         $require_login = true;
   7         $level_restriction = NEW_USER;
   8 }
   9 require ('top.inc.php');
  10
  11 $current_poll = mysql_result (mysql_query ('SELECT `pollid` FROM `poll` ORDER BY `pollid` DESC LIMIT 1'), 0);
  12 $polls = isset ($_GET['pollid']) ?
  13 mysql_query ('SELECT * FROM `poll` WHERE `pollname` != \'\' AND `pollid` <= '.intval ($_GET['pollid']).' ORDER BY `pollid` DESC'):
  14 mysql_query ('SELECT * FROM `poll` WHERE `pollname` != \'\' ORDER BY `pollid` DESC');
  15 $pollinfo = mysql_fetch_row ($polls);
  16 if (!$pollinfo)
  17         stop ('Invalid poll ID.');
  18 $prev_poll = mysql_query ('SELECT `pollid` FROM `poll` WHERE `pollname` != \'\' AND `pollid` < '.$pollinfo[0].' ORDER BY `pollid` DESC LIMIT 1');
  19 $next_poll = mysql_query ('SELECT `pollid` FROM `poll` WHERE `pollname` != \'\' AND `pollid` > '.$pollinfo[0].' ORDER BY `pollid` ASC LIMIT 1');
  20
  21
  22 if (isset ($_POST['submit']))
  23 {
  24         if ($userinfo['lastpoll'] == $pollinfo[0])
  25                 echo '<div class="alert">You have already voted in the current poll.</div>
  26 ';
  27         elseif (!isset ($userinfo['username']))
  28                 echo '<div class="alert">You must be logged in to vote.</div>
  29 ';
  30         elseif (!$pollinfo[$_POST['voteid'] + 1])
  31                 echo '<div class="alert">Invalid poll option.</div>
  32 ';
  33         else
  34         {
  35                 $voteid = intval ($_POST['voteid']);
  36                 mysql_query ('UPDATE `poll` SET `votes'.$voteid.'` = (`votes'.$voteid.'` + 1) WHERE `pollid` = '.$pollinfo[0]);
  37                 mysql_query ('UPDATE `users` SET `lastpoll` = '.$pollinfo[0].', `lastvote` = '.$voteid.' WHERE `lastacip` = \''.$_SERVER['REMOTE_ADDR'].'\'');
  38                 echo '<div class="alert">Vote submitted.</div>
  39 ';
  40                 $pollinfo = mysql_fetch_row (mysql_query ('SELECT * FROM `poll` ORDER BY `pollid` DESC'));
  41         }
  42 }
  43
  44 $sum = array_sum (array_slice ($pollinfo, 10, 8));
  45 echo '<div class="c3">'.$pollinfo[1].': '.$sum.' votes, started '.date2 ($pollinfo[18]).'</div>
  46 <table>
  47 <tr><th style="width:20%">Option</th><th colspan="2">Votes</th></tr>
  48 ';
  49 for ($optnum = 2; $optnum < 10; $optnum++)
  50 {
  51         $widthpc = $sum ? round ($pollinfo[($optnum + 8)] / $sum * 90, 1) : 0;
  52         if ($pollinfo[$optnum] != '')
  53         {
  54                 echo '<tr class='.colour().'><td title="'.($optnum-1).'">'.$pollinfo[$optnum].'</td><td style="width:2em">'.$pollinfo[($optnum + 8)].'</td>
  55 <td><div class="alert" style="width:',$widthpc,'%;white-space:normal;overflow:visible">';
  56                 if ($userinfo['level'] >= MOD && $current_poll == $pollinfo[0])
  57                 {
  58                         $voteusers = mysql_query ('SELECT `userid` FROM `users` WHERE `lastpoll` = '.$pollinfo[0].' AND `lastvote` = '.($optnum - 1));
  59                         for ($un = 0; $usr = mysql_fetch_row ($voteusers); ++$un)
  60                                 echo ($un ? ', ' : 'Users: ').userlink($usr[0]);
  61                 }
  62                 else
  63                         echo '&nbsp;';
  64                 echo '</div></td></tr>
  65 ';
  66         }
  67 }
  68 echo '</table>
  69 <div class="c3">';
  70 if (mysql_num_rows ($prev_poll))
  71         echo '<a href="?pollid='.mysql_result ($prev_poll, 0).'" rel="previous">&larr; Previous</a>';
  72 if (mysql_num_rows ($next_poll))
  73         echo ' | <a href="?pollid='.mysql_result ($next_poll, 0).'" rel="next">Next &rarr;</a> | <a href="poll.php">Current Poll</a>';
  74
  75 echo '</div>';
  76
  77 echo '<h2>Full List</h2>
  78 <ol class="plain-list">';
  79 $polls = mysql_query ('SELECT * FROM `poll` WHERE `pollname` != \'\' ORDER BY `pollid` DESC');
  80         while ($pollinfo = mysql_fetch_row ($polls))
  81                 echo '<li class='.colour().'><a href="?pollid='.$pollinfo[0].'">'.date2 ($pollinfo[18]).': '.$pollinfo[1].'</a></li>'."\n";
  82 echo '</ol>';
  83
  84 require ('foot.php');
  85 ?>