</div>
            
            <div class="sidebar">
            
            <div class="top">Habboregio Groep</div>
            <div class="mid"><div style="border: 1px solid #B9B9B9;"><a


href="http://www.habbo.nl/groups/79721/id"> <img src="images/groep.png" alt="Wordt lid!"


/></a></div></div>
            
    <div class="top">Poll</div>
            <div class="mid"><strong>Poll week 1</strong><br /><br />
<?php
    $poll_sql = mysql_query("SELECT * FROM poll ORDER BY id DESC LIMIT 1") or trigger_error(mysql_error());
    if(mysql_num_rows($poll_sql))
    {
        $poll = mysql_fetch_assoc($poll_sql);
        $voted_sql = mysql_query("SELECT `voted_at_answer` FROM `poll_votes` WHERE `poll_id` = '" . mysql_real_escape_string($poll['id']) . "' AND `userid_of_voter` = '" . mysql_real_escape_string($_SESSION['uId']) . "'") or trigger_error(mysql_error());
        if(isset($_POST['submit']) && $_POST['submit'])
        {
            if(isset($_SESSION['uId']))
            {
                if((isset($_POST['answer'])) && (ctype_digit($_POST['answer'])))
                {
                    if(!empty($poll['answer' . htmlentities($_POST['answer'])]))
                    {
                        if(!mysql_num_rows($voted_sql))
                        {
                            mysql_query("INSERT INTO `poll_votes` VALUES ('" . mysql_real_escape_string($poll['id']) . "','" . mysql_real_escape_string($_SESSION['uId']) . "','" . mysql_real_escape_string($_POST['answer']) . "')") or trigger_error(mysql_error());
                            $voted_sql = mysql_query("SELECT `voted_at_answer` FROM `poll_votes` WHERE `poll_id` = '" . mysql_real_escape_string($poll['id']) . "' AND `userid_of_voter` = '" . mysql_real_escape_string($_SESSION['uId']) . "'") or trigger_error(mysql_error());
                        }
                    }
                }
            }
        }
        echo '<strong>' . htmlentities($poll['question'], ENT_QUOTES) . '</strong><br />';
        $votes_sql = mysql_query("SELECT COUNT(1) AS `total_votes` FROM `poll_votes` WHERE `poll_id` = '" . mysql_real_escape_string($poll['id']) . "'") or trigger_error(mysql_error());
        $votes = mysql_fetch_assoc($votes_sql);
        if(mysql_num_rows($voted_sql))
        {
            $voted = mysql_fetch_assoc($voted_sql);
        }
        if((!isset($voted)) && (isset($_SESSION['uId'])))
        {
            echo '<form action="#" method="post">';
        }
        echo '<table>';
        for($i = 1; $i <= 10; $i++)
        {
            if (!empty($poll['answer' . $i]))
            {
                $answer_votes_sql = mysql_query("SELECT COUNT(1) AS `answer_votes` FROM `poll_votes` WHERE `poll_id` = '" . mysql_real_escape_string($poll['id']) . "' AND `voted_at_answer` = '" . mysql_real_escape_string($i) . "'") or trigger_error(mysql_error());
                $answer_votes = mysql_fetch_assoc($answer_votes_sql);
                if($votes['total_votes'] != 0)
                {
                    $percentage = ((round(($answer_votes['answer_votes'] / $votes['total_votes']), 4)) * 100);
                }
                else
                {
                    $percentage = 0;
                }
                echo '<tr>';
                if((!isset($voted)) && (isset($_SESSION['uId'])))
                {
                    echo '<td><input type="radio" name="answer" value="' . htmlentities($i) . '"></td>';
                }
                echo '<td>';
                if($voted['voted_at_answer'] == $i)
                {
                    echo '<i>' . htmlentities($poll['answer' . $i]) . '</i>';
                }
                else
                {
                    echo htmlentities($poll['answer' . $i]);
                }
                echo '</td><td><div style="background: url(http://www.one2xs.com/img/warn_bar_bg.gif) no-repeat bottom left; width: 135px; height: 10px; padding: 1px 0 0 1px; font-size: 9px;"><div style="background: url(http://www.one2xs.com/img/warn_bar_orange.gif) no-repeat bottom left; width: ' . ($percentage * 1.33) . 'px; height: 8px; float: left; margin: 1px 0 0 0;"></div></div></td><td><i>' . $percentage . '%</i></td></tr>';
            }
        }
        echo '</table>';
        if((!isset($voted)) && (isset($_SESSION['uId'])))
        {
            echo '<input type="submit" value="STEM!" name="submit"></form>';
        }
        echo 'Totaal aantal stemmen: ' . htmlentities($votes['total_votes']);
    }            
?>
</div>
            
            </div>
            


                    <div style="clear: both;"></div>
                    <div id="footer">Habboregio is geen onderdeel van Habbo of Sulake


Coperation Oy. Alle rechten voorbehouden | Habboregio 2009-2010    <a href="#top">Naar


boven</a> | <a href="contact">Contact</a></div>
        
            </div>
    </div>


</body>
</html>