query($q); if($reslt->getNumRows() > 0) $reslt->next(); $poll = $reslt->getString('id_poll'); } $query = "select * from user_poll where user_id='$user_id' and poll_id='$poll'"; $result = $kyberia->query($query); if($result->getNumRows()==0) define ('VOTE', true); else define ('VOTE', false); if(IsSet($option)) { $sqlcmd="select * from user_poll where user_id='$user_id' and poll_id='$poll'"; $result=$kyberia->query($sqlcmd); if ($result->getNumRows()==0) { $sqlcmd="update polls set responses=responses+1 where id_poll=$poll"; $result=$kyberia->query($sqlcmd); $sqlcmd="update poll_options set number=number+1 where id_option=$option"; $result=$kyberia->query($sqlcmd); $kyberia->query("insert into user_poll set user_id='$user_id',poll_id='$poll'"); } else echo "
brawco,v ankete uz si hlasoval!"; } $sqlcmd="select * from polls where forum_id='$node_id' order by id_poll desc limit 1"; $result=$kyberia->query($sqlcmd); if ($result->getNumRows()>0) { $result->next(); echo ""; $sqlcmd="select * from poll_options where id_poll='".$result->getString('id_poll')."'"; $result2=$kyberia->query($sqlcmd); while ($result2->next()) { (int) $count = (int) ($result2->getString('number')/$percent); $count2 =$count/2; if(VOTE && !IsSet($option)) echo ""; else echo ""; } echo ""; echo "

"; echo $result->getString('question'); $percent=$result->getString('responses')/100; if (!$percent) $percent=1; echo "
getString('id_poll'),"&option=",$result2->getString('id_option'),">",$result2->getString('text'),"		".$count."%
".$result2->getString('text')."		".$count."%
Spolu hlasovalo ".$result->getString('responses')." ludi

"; } ?>