PHP-Quelltext

<?php include "umfrage.php";?>

Quellcode

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\2\umfrage.php on line 12

PHP-Quelltext

         $data = mysql_fetch_array($sql, MYSQL_ASSOC);

PHP-Quelltext

<?php
define('GET_CACHES', 1);
define('ROOT_PATH', './');
$user_access = get_permission();
require(ROOT_PATH.'admin/plugins/umfrage/configs.php');

function ip_exists($table,$id) {
         include "admin/plugins/umfrage/configs.php";
         $sql_conf = mysql_query("SELECT * from $configs LIMIT 1");
         $sql_conf = mysql_fetch_array($sql_conf, MYSQL_ASSOC);
         $einheit = $sql_conf['sperreinheit'];
         $sperrzeit = $sql_conf['sperrdauer'];
         $sekundenanzahl = $sperrzeit*$zeiteinheit[$einheit];
         $sql = mysql_query("SELECT * from $table WHERE id = '$id' LIMIT 1");
         $data = mysql_fetch_array($sql, MYSQL_ASSOC);
         if(ereg($_SERVER['REMOTE_ADDR'], $data['ip']) > 0) {
                  $doit = explode("#", $data['ip']);
                  for($x=0;$x<count($doit);$x++) {
                       $findit = explode("%", $doit[$x]);
                       if($findit[0]==$_SERVER['REMOTE_ADDR']) {
                          $zeitabstand = time()-$findit[1];
                          if($zeitabstand > $sekundenanzahl) { return false; break; }
                          else { return true; break; }

                       }
                  }

         }
         else {
            return false;
            }
}
$ant = $_POST['ant'];

if(isset($_POST['vote']) && isset($ant) && !ip_exists($umfragen,$_POST['id'])) {
   $id = $_POST['id'];
   $sql = mysql_query("SELECT * from $umfragen WHERE id = '$id' LIMIT 1");
   $data = mysql_fetch_array($sql, MYSQL_ASSOC);
   $votes = explode(",", $data['votes']);
   $votes[$ant]++;
   $votes = implode(",", $votes);
   if(!empty($data['ip'])) {
      $ip = explode("#", $data['ip']);
      if(ereg($_SERVER['REMOTE_ADDR'], $data['ip']) > 0) {
         for($x=0;$x<count($ip);$x++) {
              $sameip = explode("%", $ip[$x]);
              if($sameip[0]==$_SERVER['REMOTE_ADDR']) {
                  $sameip[1]=time();
                  $ip[$x]=implode("%", $sameip);
                  break;
              }
         }
         $ip = implode("#", $ip);
      }
      else {
         $result = array_push($ip, $_SERVER['REMOTE_ADDR']."%".time());
         $ip = implode("#", $ip);
      }
   }
   else {
         $ip = $_SERVER['REMOTE_ADDR']."%".time();
   }
   $sql = mysql_query("UPDATE $umfragen SET votes = '$votes', ip = '$ip' WHERE id = '$id' LIMIT 1");

   /* LOGS ANFERTIGEN START */

   $vote = $_POST['ant'];
   $timestamp = time();
   $date = date("d.m.Y, H:i:s",$timestamp);
   $ip = $_SERVER['REMOTE_ADDR'];
   $dns = $_SERVER['REMOTE_HOST'];
   $uri = $_SERVER['REQUEST_URI'];
   $referrer = $_SERVER['HTTP_REFERER'];
   $agent = $_SERVER['HTTP_USER_AGENT'];


   /* LOGS ANFERTIGEN END */

   if(!sql) {
      echo "Fehler beim Aktualisieren...";
      mysql_error();
   }


}

         /* Umfragen-Tabelle auslesem*/
         $sql = mysql_query("SELECT * FROM $umfragen");
         $counter = 0;
         $umfragen = mysql_num_rows($sql);
while ($data = mysql_fetch_array($sql, MYSQL_ASSOC)) {
 if($data[status] == 1) {
               if($counter>0) echo $abstand;
               /* Frage */
               echo "<form style=\"padding:0px;margin:0px;\" action=\"".$_SERVER['REQUEST_URI'];
               echo "#ergebnisse\" method=\"POST\">\n";
               echo "<div class=\"umfragentext\">";
               echo $data['question'];
               echo "</div>\n";

               /* Antwortmoeglichkeiten */
               $options = explode("%%", $data['options']);

         if(!ip_exists($umfragen,$data[id])) {
               echo "<div style=\"padding-left:15px;text-align:left\">";
               for($x=0;$x<count($options);$x++) {
                          echo "<span class=\"umfrageoption\"><input name=\"ant\" value=\"".$x."\" type=\"radio\"> ";
                          echo $options[$x]."</span><br>\n";
               }
               echo "</div>";
               echo "<br><input type=\"hidden\" name=\"id\" value=\"".$data['id']."\">\n";
               echo "<input type=\"submit\" name=\"vote\" value=\"abstimmen\" class=\"vote\"><br>\n";
         }

               if((isset($_POST['results']) && $_POST['id'] == $data['id']) || ip_exists($umfragen,$data[id])) {
                      /* Ergebnisse anzeigen */
                      $voters = 0;
                      $max_vote = 0;
                      $max_vote_pos = 0;
                      $votes = explode(",", $data['votes']);
                      for($x=0;$x<count($options);$x++) {
                           $voters=$voters+$votes[$x];
                           if($votes[$x] > $max_vote) {
                               $max_vote = $votes[$x];
                               $max_vote_pos = $x;
                           }
                      }
                      $percentage = array();
                      $hund = 0;
                      $pc = 0;
                      $end = false;
                      while(!$end) {
                            $hund = 0;
                            for($x=0;$x<count($options);$x++) {
                                   if($voters==0) {
                                       $percentage[$x] = 0;
                                   }
                                   else {
                                       $percentage[$x]=($votes[$x]*100)/$voters;
                                       $percentage[$x]=round($percentage[$x],$pc);
                                   }
                                       $hund = $hund + $percentage[$x];
                            }
                            /* Nachkommastellenbestimmung */
                            $pc++;
                            if($hund == 100 || $pc == 2) {
                                   $end = true;
                            }
                      }
                      echo "<a id=\"ergebnisse\"></a><div style=\"text-align:left;padding-left:15px;padding-right:11px;padding-top:5px;font-size:11px; font-family:tahoma; color:#222221\">";
                      for($x=0;$x<count($percentage);$x++) {
                           if($max_vote == 0) {
                               $blau = 0;
                               $grau = $maxlaenge;
                               }
                           else {
                               $blau = ceil(($maxlaenge/$max_vote)*$votes[$x]);
                               $grau = $maxlaenge - $blau;
                               }
                           /*
                           if($blau>$maxlaenge) $blau=$maxlaenge;
                           echo $options[$x]."<br>\n";
                           echo "<img src=\"".$pfad."/balken/balken_";
                           if($blau==$maxlaenge) echo "orange";
                           else echo $farbe;
                           */
                           echo $options[$x]."<br>\n";
                           echo "<img src=\"".$pfad."balken/balken_";
                           echo $farbe;
                           echo ".gif\" height=\"12\" width=\"$blau\" border=\"0\" title=\"$votes[$x] Stimmen\" alt=\"$votes[$x] Stimmen\">";
                           echo "<img src=\"".$pfad."balken/balken_grau.gif\" height=\"12\" width=\"$grau\" border=\"0\" title=\"$votes[$x] Stimmen\" alt=\"$votes[$x] Stimmen\">\n";
                           echo $percentage[$x]."%<br>\n";

                      }
                      echo "</div>";
                      echo "<div class=\"umfragentext\">insgesamt $voters Stimmen</div>\n";
               }
               else {
                     echo "<input type=\"submit\" name=\"results\" value=\"Ergebnisse\" class=\"vote\">\n";
               }

               echo "</form>\n";
               $counter++;
 }
}
if($counter == 0) echo "z.Zt. keine Umfrage aktiv";
?>