Mensie prenastavenie koli register global

<tr>
 <td width="248" class="page">
<?
 include "poll/settings.inc";
 $poll = mysql_connect("$db_host", "$db_username", "$db_password")
       or die ("Could not connect");
 mysql_select_db ("kmsa")
        or die ("Could not select database");
       
     $checkforcurrent = mysql_query("select id,dateactive from polls where active='yes' order by question limit 1");
     $current_poll = mysql_fetch_row($checkforcurrent);
     $curpollid = $current_poll[0];
     $dateactive = $current_poll[1];
     $today=date("Y-m-d 00:00");
     $date1=strtotime( "$dateactive 00:00" );
     $date2=strtotime("$today");
     $datediffer = (($date2-$date1)/86400);
     
 if ($datediffer>=$interval){
     $lookfornext = mysql_query("select id from polls where active='no' order by id limit 1");
     $getnextid = mysql_fetch_row($lookfornext);
     $nextpollid = $getnextid[0];
     if ($nextpollid){
          $date = date("Y-m-d");
          mysql_query("update polls set active='end' where id=$curpollid");
          mysql_query("update polls set active='yes', dateactive='$date' where id=$nextpollid");
          mysql_query("delete from poll_ip");
     }
 }

 function writeresults (){
     $getquestion = mysql_query("select id,question,votes from polls where active='yes' order by question limit 1");
     $question = mysql_fetch_row($getquestion);
     echo "<font class=\"nleft2\"><b>".$question[1]."</b></font><br><font class=\"left\">";
     $totalvotes = $question[2];
     $getresults = mysql_query("select votes, alternative from poll_alternatives where poll_id='$question[0]'");
     $imageid=1;
     while ($result = mysql_fetch_array($getresults)){
        if ($totalvotes!=0){
        $percentage = (round(($result["votes"]/$totalvotes)*10000))/100;
    }
        $imagewidth = round($percentage*2);
        echo "<b>".$result["alternative"]."</b> - $percentage% (".$result["votes"]." hlasov)<br>";
        echo "<img src=\"poll/$imageid.gif\" width=\"$imagewidth\" height=\"10\" style=\"border:1px solid black\"><br>";
        $imageid++;
     }
     echo "<br>Spolu hlasov: $totalvotes</font>";
}


 if (!$submit && !$results) {
     ?>
     <form method="post" action="<?=$PHP_SELF ?>" target="_top">
     <?

     $getquestion = mysql_query("select id,question from polls where active='yes' order by question limit 1");
     $question = mysql_fetch_row($getquestion);
     $pollid = $question[0];
     $dateactive = $question[2];
     $question = $question[1];
     echo "<font class=\"nleft2\"><b>$question</b></font><br><font class=\"left\">";
     $getalternatives = mysql_query("select id, alternative from poll_alternatives where poll_id='$pollid'");
     while ($writeit = mysql_fetch_array($getalternatives)){
           echo "<input type=\"radio\" name=polloption value=\"".$writeit["id"]."\"";
           if (!$checkedvar){ echo "checked"; $checkedvar=1; }
           echo ">";
           echo " ".$writeit["alternative"]."<br>";
     }
     echo "<input type=\"hidden\" name=\"pollid\" value=\"$pollid\"></font>";
     echo "<br><center><input type=\"Submit\" value=\"Hlasovať\" name=\"submit\">";
     echo "</center></font>";
 }
 
 
 elseif ($submit){
     $checkforip = mysql_query("select ip from poll_ip where ip='$REMOTE_ADDR'");
     if (mysql_num_rows($checkforip)==0){
     mysql_query ("update poll_alternatives set votes=votes+1 where id='$polloption'");
     mysql_query ("update polls set votes=votes+1 where id='$pollid'");
     mysql_query ("insert into poll_ip (ip) values ('$REMOTE_ADDR')");
     echo "<font class=\"left\">Tvoj hlas bol prijatý<br><p></font>";
     }
     else { echo "<font class=\"left\">Jeden hlas na jednu IP adresu<br><p></font>";}
     // skriva ut resultat
     writeresults();
  }

  elseif($results){
      writeresults();
  }
       
 mysql_close($poll);
?>
 </td>
</tr>