I know that I should modify some stuff but I did not understand what how I should modify it???
<?php
poll_id=1; // **** change this *****
// the rest shouldn't be altered..
$show_poll=$_REQUEST['show'];
$query_content = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_polls WHERE poll_id = '$poll_id'");
$poll_data = $query_content->fetchRow();
$txt_vote = $poll_data['txt_vote'];
$txt_voted = $poll_data['txt_voted'];
$txt_picture = WB_URL."/modules/polls/".$poll_data['txt_picture'];
$txt_nopolls = $poll_data['txt_nopolls'];
$txt_results = $poll_data['txt_results'];
$poll_id = $poll_data['poll_id'];
if($query_content->numRows() > 0) { # If there is a poll
$fetch_content = $query_content->fetchRow();
$ip = $_SERVER['REMOTE_ADDR']; # Check for voted allready
$data = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_polls_votes WHERE `vote_ip` = '" . $ip . "' AND `poll_id` = '" . $poll_id . "' AND `vote_datum` > '" . time() . "'" );
$datapoll = $data->fetchRow();
if ((!$_POST['vote']) && (!$datapoll) && (!$show_poll)) { # Check if form submitted and not voted yet and no request to show results!
$options = explode(",", $poll_data['poll_keuzes']); # Split options and count them in loop
$aant = count($options)-1;
$poll .= "<center>".$poll_data['poll_stelling']."</center><br />" ;
$poll .= "<form method=\"POST\" action=\"" . $_SERVER['PHP_SELF'] . "\">";
for($i = 0; $i <= $aant; $i++) { # Loop and make input radios
$j = $i+1;
$poll .= "<input type=\"radio\" value=\"" . $j . "\" name=\"poll\" />" . $options[$i] . "<br />";
}
$poll .= "<br /><center><input type=\"submit\" class=\"button\" name=\"vote\" value=\"$txt_vote\" /></center></form>";
$poll .= "<center><a href=\"".$_SERVER[PHP_SELF]."?show=1\">".$txt_results."</a></center>";
echo $poll;
} else { # Add data to database and check for a value
if($_POST['poll']) { # Option selected - Update votes
$vote=$_POST['poll'];
$stemmen = explode(",", $poll_data['poll_scores']);# Split the vote scores
$vote--;
(int) $stemmen[$vote]++; # add one to the selected option
$stem = implode(",", $stemmen); # Remake the data and add to database
$poll_data['poll_scores']=$stem;
$database->query("UPDATE ".TABLE_PREFIX."mod_polls SET `poll_scores` = '" . $stem . "' WHERE `poll_id` = '" . $poll_data['poll_id'] . "'");
$date_time = time()+($poll_data['poll_ttl']*60*60);
$database->query("INSERT INTO ".TABLE_PREFIX."mod_polls_votes SET `vote_ip` = '" . $ip . "',`poll_id` = '" . $poll_data['poll_id'] . "', `vote_datum` = '" . $date_time . "'");
# Make sure to show poll
$datapoll="1" ;
}
}
if(($datapoll) || ($show_poll)) { # If allready voted or requested show results
$options = explode(",", $poll_data['poll_keuzes']); # Split options and scores
$scores = explode(",", $poll_data['poll_scores']);
$option = count($options)-1;
$votes = array_sum($scores); # Count the votes and show them
$results .= "<center>".$poll_data['poll_stelling']."</center><br />";
$results .= "<p>";
for($i = 0;$i <= $option; $i++) { # Loop through results
$results .= $options[$i] . "<br />";
if ($votes>0) {
$num = (int) ($scores[$i] / ($votes/100)) ;
} else {
$num=0;
}
$results .= "<img src=\"".$txt_picture."\" width=\"" . $num/2 . "\" height=\"10\" /> " . $num . "%";
$results .= "<br />";
}
$results .= "</p>";
$results .= $txt_voted . $votes . "<br />";
echo $results;
}
} else { # No polls!
echo $txt_nopolls;
}
?>
</div>
WebsiteBaker Community Forum
