Umfragemodul von darth-vader, etwas vertauscht?

bloody_marie · Beitrag von **bloody_marie** » Di 3. Aug 2004, 12:26

Hallo ich benutze das Umfragemodul von darth-vader.
Installation hat alles geklappt.
Jedoch ist bei mir irgendwas vertauscht. Im frontend sieht man nach Einbinden des Moduls die Ergebnisse anstatt der Voting-Maske. Hier mal meine URL:http://www.hoerth-schneider.de/cms
Ich poste jetzt mal meinen Code, vielleicht stehe ich auch total auf dem Schlauch. Bin auch kein php-Profi

Hier der Input-code:

/********************************************************
* CONTENIDO MODUL - INPUT
*
* Modulname : Umfrage
* Author : Alexander Höhn
* Copyright : art & weise medienproduktion
info@auw-media.de
* Created : 16-09-2002
* Modified : 04-07-2003
* Modified again & again until: May. 18th 2004 by Lars D. Forseth <lars@forseth.de>
*********************************************************/

/* debugging? */
$debugging = "no";
/* end "debugging?" */

/* debugging stuff */
if ($debugging == "yes") {
echo "
- poll_action: $poll_action<br>
- poll_id_active: $poll_id_active<br>
- poll_subaction: $poll_subaction<br>
- poll_reset: $poll_reset<br>
";
}
/* end "debugging stuff" */

$db0 = new DB_Contenido;
$db0->query("LOCK TABLES poll WRITE,poll_log WRITE;"); // lock tables

switch($poll_action){

//-------------------------- Speichern der Daten in die Tabelle ------------------------------
case "save_poll" : {

if("CMS_VALUE[96]" == "") {$poll_answer3 = " ";}
else {
$poll_answer3 = "CMS_VALUE[96]";
$poll_answer3 = str_replace (";","",$poll_answer3);
$poll_answer3 = str_replace ("--","",$poll_answer3);
$poll_answer3 = str_replace ("'","",$poll_answer3);
$poll_answer3 = htmlentities($poll_answer3);
}
if("CMS_VALUE[95]" == "") {$poll_answer4 = " ";}
else {
$poll_answer4 = "CMS_VALUE[95]";
$poll_answer4 = str_replace (";","",$poll_answer4);
$poll_answer4 = str_replace ("--","",$poll_answer4);
$poll_answer4 = str_replace ("'","",$poll_answer4);
$poll_answer4 = htmlentities($poll_answer4);
}
if($CMS_VAR[94] == "") {$poll_answer5 = " ";}
else {
$poll_answer5 = $CMS_VAR[94];
$poll_answer5 = str_replace (";","",$poll_answer5);
$poll_answer5 = str_replace ("--","",$poll_answer5);
$poll_answer5 = str_replace ("'","",$poll_answer5);
$poll_answer5 = htmlentities($poll_answer5);
}
if($CMS_VAR[93] == "") {$poll_answer6 = " ";}
else {
$poll_answer6 = $CMS_VAR[93];
$poll_answer6 = str_replace (";","",$poll_answer6);
$poll_answer6 = str_replace ("--","",$poll_answer6);
$poll_answer6 = str_replace ("'","",$poll_answer6);
$poll_answer6 = htmlentities($poll_answer6);
}

/* filter given data */
$poll_question = str_replace (";","","CMS_VALUE[99]");
$poll_question = str_replace ("--","",$poll_question);
$poll_question = str_replace ("'","",$poll_question);
$poll_question = htmlentities($poll_question);

$poll_answer1 = "CMS_VALUE[98]";
$poll_answer1 = str_replace (";","",$poll_answer1);
$poll_answer1 = str_replace ("--","",$poll_answer1);
$poll_answer1 = str_replace ("'","",$poll_answer1);
$poll_answer1 = htmlentities($poll_answer1);

$poll_answer2 = "CMS_VALUE[97]";
$poll_answer2 = str_replace (";","",$poll_answer2);
$poll_answer2 = str_replace ("--","",$poll_answer2);
$poll_answer2 = str_replace ("'","",$poll_answer2);
$poll_answer2 = htmlentities($poll_answer2);

$db1 = new DB_Contenido;

/* if one tries to edit a non-existing poll, let him create it as a new poll */
if (($poll_id_active <= 0) and ($poll_subaction == "edit_poll")) {
$poll_subaction = "new_poll";
}
if ($debugging == "yes") echo "- poll_subaction: $poll_subaction<br>";
/* end "if one tries to edit a non-existing poll, let him create it as a new poll" */

/* create new poll */
if ($poll_subaction == "new_poll") {
$sql1 = "INSERT INTO poll VALUES (\"\", \"".$poll_question."\", ".
"\"".$poll_answer1."\", \"".$poll_answer2."\", \"".$poll_answer3.
"\", \"".$poll_answer4."\", \"".$poll_answer5."\", \"".$poll_answer6.
"\", \"0\");";
$db1->query($sql1);
}
/* end "create new poll" */

/* edit existing poll */
if ($poll_subaction == "edit_poll") {
$sql1 = "UPDATE poll SET poll_question=\"".$poll_question."\", ".
"poll_answer1=\"".$poll_answer1."\", poll_answer2=\"".$poll_answer2."\", ".
"poll_answer3=\"".$poll_answer3."\", poll_answer4=\"".$poll_answer4."\", ".
"poll_answer5=\"".$poll_answer5."\", poll_answer6=\"".$poll_answer6."\", ".
"poll_active=1 WHERE poll_id=".$poll_id_active.";";
$db1->query($sql1);
}
/* end "edit existing poll" */

/* reset vote counter */
if($poll_reset == "yes") {
$sql1_2 = "DELETE FROM poll_log WHERE poll_id=".$poll_id_active.";";
$db1->query($sql1_2);
}
/* end "reset vote counter" */

} // end " case "save_poll" "

case "activate_poll" : {

//--------------------------- Aktivieren der gewünschten Frage --------------------------------
$poll_question = str_replace (";","","CMS_VALUE[92]");
$poll_question = str_replace ("--","",$poll_question);
$poll_question = str_replace ("'","",$poll_question);
$poll_question = htmlentities($poll_question);

$db3 = new DB_Contenido;
$db3->query("UPDATE poll SET poll_active=0;");
$db3->query("UPDATE poll SET poll_active=1 WHERE poll_question=\"".$poll_question."\";");

break;
} // end " case "activate_poll" "
} // end switch

echo "



<table>
";
echo " <tr bgcolor=\"#FFFFE0\">
<td colspan='2'>
<font size='2' face='Verdana'>
<b>HINWEISE:</b><br><br>
<font color=\"darkblue\"><p style=\"padding-left: 10px;\">
Durch "Speichern" wird die aktuelle Umfrage nicht aktiviert,<br>
sondern nur in der Datenbank gespeichert.<br>
Eine Umfrage bearbeiten oder neu anlegen, geht natürlich nur,<br>
wenn die entsprechende Option ausgewählt und dann auf <br>
"Speichern" geklickt wurde!<br>
Eine Umfrage aktivieren kann man, in dem man sie <br>
in dem Drop-Down-Menü auswählt und dann auf "Aktivieren" klickt.<br>
</p></font>
</font>
</td>
</tr>";
echo "<tr>
<td> </td>
<td> </td>
</tr>";

$db2 = new DB_Contenido;
$sql2 = "SELECT * FROM poll WHERE poll_active=1;";
$db2->query($sql2);
$db2->next_record();
$poll_question_active = $db2->f("poll_question");
$poll_answer1_active = $db2->f("poll_answer1");
$poll_answer2_active = $db2->f("poll_answer2");
$poll_answer3_active = $db2->f("poll_answer3");
$poll_answer4_active = $db2->f("poll_answer4");
$poll_answer5_active = $db2->f("poll_answer5");
$poll_answer6_active = $db2->f("poll_answer6");
$poll_id_active = $db2->f("poll_id");

echo " <tr bgcolor=\"#FFFFE0\">
<td colspan='2'>
<font size='2' face='Verdana'><b>
Momentan ist folgende Umfrage aktiv:<br>
<i style=\"padding-left: 10px;\">\"$poll_question_active\"</i>
</b></font>
</td>
</tr>
";

echo "
<tr>
<td> </td>
<td> </td>
</tr>";
echo "
<tr>
<td colspan=\"2\">
<u>Aktion:</u><br><br>
<input type=\"radio\" name=\"poll_action\" value=\"save_poll\">
  Umfrage mit eine der beiden folgenden Funktionen abspeichern:
<p style=\"padding-left: 30px;\">
<input type=\"radio\" name=\"poll_subaction\" value=\"edit_poll\">
  momentan aktive Umfrage bearbeiten
<br>
<input type=\"radio\" name=\"poll_subaction\" value=\"new_poll\">
  neue Umfrage anlegen
</p>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Frage :</td>
<td><input type=\"text\" name=\"CMS_VAR[99]\" value=\"$poll_question_active\"></td>
</tr>
<tr>
<td>Antwort 1 :</td>
<td><input type=\"text\" name=\"CMS_VAR[98]\" value=\"$poll_answer1_active\"></td>
</tr>
<tr>
<td>Antwort 2 :</td>
<td><input type=\"text\" name=\"CMS_VAR[97]\" value=\"$poll_answer2_active\"></td>
</tr>
<tr>
<td>Antwort 3:</td>
<td><input type=\"text\" name=\"CMS_VAR[96]\" value=\"$poll_answer3_active\"></td>
</tr>
<tr>
<td>Antwort 4 :</td>
<td><input type=\"text\" name=\"CMS_VAR[95]\" value=\"$poll_answer4_active\"></td>
</tr>
<tr>
<td>Antwort 5 :</td>
<td><input type=\"text\" name=\"CMS_VAR[94]\" value=\"$poll_answer5_active\"></td>
</tr>
<tr>
<td>Antwort 6 :</td>
<td><input type=\"text\" name=\"CMS_VAR[93]\" value=\"$poll_answer6_active\"></td>
</tr>
<tr>
<td> Alle Zähler auf 0 setzen:</td>
<td><input type=\"checkbox\" name=\"poll_reset\" value=\"yes\"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>

<tr>
<td> </td>
<td>
<input type=\"hidden\" name=\"poll_id_active\" value=\"$poll_id_active\">
</td>
</tr>
<tr>
<td colspan=\"2\"><center>";

//---------------------- Darstellung aller Umfragen in einer drop-down Liste --------------------------------

$db4 = new DB_Contenido;
$db4->query("SELECT * FROM poll;");
$db4->next_record();
$test = $db4->f("poll_id");

if (!$test) {
$sql4 = "CREATE TABLE poll (poll_id int(11) NOT NULL auto_increment, poll_question text NOT NULL, ".
"poll_answer1 text NOT NULL, poll_answer2 text NOT NULL, poll_answer3 text NOT NULL, ".
"poll_answer4 text NOT NULL, poll_answer5 text NOT NULL, poll_answer6 text NOT NULL, ".
"poll_active int(1) default NULL, PRIMARY KEY (poll_id) ) TYPE=MyISAM;";
$db4->query("SELECT * FROM poll;");
$db4->next_record();
} // if DB doesn't exist yet, create it

echo "
<input type=\"radio\" name=\"poll_action\" value=\"activate_poll\">
  Umfrage aus der Liste auswählen und aktivieren:
<br>
<select name=\"CMS_VAR[92]\" size=\"1\">";

for($i=0; $i<$db4->num_rows(); $i++){
if(($db4->f("poll_id")) == $poll_id_active) {$a = " selected";}
else {$a = "";}
echo "
<option value=\"".$db4->f("poll_question")."\"$a>".$db4->f("poll_question")."</option>";
$db4->next_record();
} // end for

echo "
</select>" ;

echo "
</td>
</tr>
<tr>
<td colspan=\"2\">
<center>
";

/* print statistic of current poll */

if ($poll_id_active > 0) {

$db = new DB_Contenido;

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active;");
$db->next_record();
$test = $db->f("COUNT(*)");

if ($test > 0) {

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=1;");
$db->next_record();
$result1 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=2;");
$db->next_record();
$result2 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=3;");
$db->next_record();
$result3 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=4;");
$db->next_record();
$result4 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=5;");
$db->next_record();
$result5 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=6;");
$db->next_record();
$result6 = $db->f("COUNT(*)");

$total = $result1+$result2+$result3+$result4+$result5+$result6;

echo "
<br><br>
<p style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><b>Statistik der momentan aktiven Umfrage:</b></p>
<br><br>
<table width=\"165\" cellspacing=\"0\" cellpadding=\"2\" style=\"BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid;
MARGIN-BOTTOM: 3pt; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid;
BACKGROUND-COLOR: #efefef;\">";

echo "
<tr style=\"padding-left: 8px; padding-right: 8x; padding-top: 5px; padding-bottom: 3px;
font-family: Verdana; font-size: 10pt; color: darkblue; BACKGROUND-COLOR: #efefef;\"><td>".$poll_question_active."</td></tr><tr><td> </td></tr>";

echo "
<tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td><i><u>Gesamt:</u> ".$total." Stimmen</i></td></tr><tr><td> </td></tr>";

if (($result1 > 0) and ($total > 0)) $percent = round(((100*$result1)/$total), 2);
if($result1!="0") $color1= "cornflowerblue";
if ($percent < 5.00) $color1 = "";
echo "
<tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td>\"<b>".$poll_answer1_active."</b>\" (".$result1.") :</td></tr>";
echo "
<tr><td>
<table><tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td bgcolor=\"".$color1."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";

if (($result2 > 0) and ($total > 0)) $percent = round(((100*$result2)/$total), 2);
if($result2!="0") $color2= "skyblue";
if ($percent < 5.00) $color2 = "";
echo "
<tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td>\"<b>".$poll_answer2_active."</b>\" (".$result2.") :</td></tr>";
echo "
<tr><td>
<table><tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td bgcolor=\"".$color2."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";

if(strlen($poll_answer3_active) > 1){
if (($result3 > 0) and ($total > 0)) $percent = round(((100*$result3)/$total), 2);
if($result3!="0") $color3= "lightskyblue";
if ($percent < 5.00) $color3 = "";
echo "
<tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td>\"<b>".$poll_answer3_active."</b>\" (".$result3.") :</td></tr>";
echo "
<tr><td>
<table><tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td bgcolor=\"".$color3."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";
}

if(strlen($poll_answer4_active) > 1){
if (($result4 > 0) and ($total > 0)) $percent = round(((100*$result4)/$total), 2);
if($result4!="0") $color4= "lightblue";
if ($percent < 5.00) $color4 = "";
echo "
<tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td>\"<b>".$poll_answer4_active."</b>\" (".$result4.") :</td></tr>";
echo "
<tr><td>
<table><tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td bgcolor=\"".$color4."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";
}

if(strlen($poll_answer5_active) > 1){
if (($result5 > 0) and ($total > 0)) $percent = round(((100*$result5)/$total), 2);
if($result5!="0") $color5= "lightsteelblue";
if ($percent < 5.00) $color5 = "";
echo "
<tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td>\"<b>".$poll_answer5_active."</b>\" (".$result5.") :</td></tr>";
echo "
<tr><td>
<table><tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td bgcolor=\"".$color5."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";
}

if(strlen($poll_answer6_active) > 1){
if (($result6 > 0) and ($total > 0)) $percent = round(((100*$result6)/$total), 2);
if($result6!="0") $color6= "darkgray";
if ($percent < 5.00) $color6 = "";
echo "
<tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td>\"<b>".$poll_answer6_active."</b>\" (".$result6.") :</td></tr>";
echo "
<tr><td>
<table><tr style=\"FONT-SIZE: 12px; COLOR: #000000;FONT-FAMILY: helvetica, arial, geneva, sans-serif;\"><td bgcolor=\"".$color6."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";
}

echo "
</table>

";

} // end "if (isset($test))"
} // end "if (isset($poll_id_active))"

/* end of modul*/
echo "
</center>
</td>
</tr>
</table>



";

$db0->query("UNLOCK TABLES;"); // unlock tables

Und hier der Output-Code:

<?php

/********************************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname : Umfrage
* Author : Alexander Höhn
* Copyright : art & weise medienproduktion
info@auw-media.de
* Created : 16-09-2002
* Modified : 04-07-2003
* Modified again & again until: May. 12th 2004 by Lars D. Forseth <lars@forseth.de>
*********************************************************/

/* set this to "yes" if you want to run script in debugging mode */
$debugging = "no";
/* end "set this to "yes" if you want to run script in debugging mode" */

/* get only vars accepted by POST or GET */
$poll_action = $_POST['poll_action'];
$given_answer = $_POST['given_answer'];
$poll_stats = $_GET['poll_stats'];
if ($debugging == "yes") echo "- poll_action: $poll_action<br>";
if ($debugging == "yes") echo "- given_answer: $given_answer<br>";
if ($debugging == "yes") echo "- poll_stats: $poll_stats<br>";
if ($debugging == "yes") echo "- cookie: ".($_COOKIE['poll'])."<br>";
/* end "get only vars accepted by POST or GET" */

$db1 = new DB_Contenido;

/* lock tables */
$db1->query("LOCK TABLES poll WRITE,poll_log WRITE;");
/* end "lock tables" */

/* get * from active poll */
$db1->query("SELECT * FROM poll WHERE poll_active=1 LIMIT 1;");
$db1->next_record();
$poll_id_active = $db1->f("poll_id");

/* no active poll in DB */
if (!isset($poll_id_active)) {echo "Keine aktive Umfrage in der DB vorhanden!";}
/* end "no active poll in DB" */

/* there is an active poll in DB */
else {

$poll_question_active = $db1->f("poll_question");
$poll_answer1_active = $db1->f("poll_answer1");
$poll_answer2_active = $db1->f("poll_answer2");
$poll_answer3_active = $db1->f("poll_answer3");
$poll_answer4_active = $db1->f("poll_answer4");
$poll_answer5_active = $db1->f("poll_answer5");
$poll_answer6_active = $db1->f("poll_answer6");
if ($debugging == "yes") echo "- poll_id_active: $poll_id_active<br>";
/* end "get od from active poll" */

/* get user's ip and proxy ip */
$user_ip = $_SERVER['REMOTE_ADDR'];
$user_proxy = $_SERVER['HTTP_X_FORWARDED_FOR'];
/* end "get user's ip and proxy ip" */

/* user is only allowed to vote if cookies are enabled and his IP isn't blocked (anymore) */

if ($poll_stats == "yes") {$poll_action = "vote"; $given_answer = 666;}

if ($poll_action == "vote") {

$db0 = new DB_Contenido;
$sql = "SELECT poll_log_id,user_time FROM poll_log WHERE poll_id=$poll_id_active ".
"and user_ip='$user_ip' ORDER BY user_time DESC LIMIT 1;";
$db0->query($sql);
$db0->next_record();
$poll_log_id = $db0->f("poll_log_id");
$user_time = $db0->f("user_time");

if ($debugging == "yes") {
echo "- poll_action: $poll_action<br>";
echo "- poll_id_active: $poll_id_active<br>";
echo "- user_time: $user_time<br>- poll_log_id: $poll_log_id<br>";
} // end if ($debugging == "yes")

if ((isset($user_time)) and (isset($poll_log_id))) {
if ($debugging == "yes") echo "- user_time: $user_time<br>- poll_log_id: $poll_log_id<br>";
$block_seconds = 0;
$block_minutes = 15;
$block_hours = 0;
$block_days = 0;
$block_months = 0;
$block_total = ($block_seconds + ($block_minutes * 60) + ($block_hours * 60 * 60)
+ ($block_days * 60 * 60 * 24) + ($block_months * 60 * 60 * 24 * 30));
// IP is still blocked
if ((time()) < ($user_time + $block_total)) {
$poll_stats = "yes";
$given_answer = 666;
if ($debugging == "yes") echo "- poll_stats: $poll_stats<br>- given_answer: $given_answer<br>";
$db0->query("UPDATE poll_log SET user_time=UNIX_TIMESTAMP() WHERE poll_log_id=$poll_log_id;");
} // end if
} // end if

} // end if

/* end "user is only allowed to vote if cookies are enabled" and his IP isn't blocked (anymore) */

echo "


";

/* allowed to vote and no form data given -> show poll form */
if((($_COOKIE['poll']) == "poll_allowed")
and ($poll_action != "vote") and ($poll_stats != "yes")){

$links = explode('?',$auth->url());
$links2 = explode('&',$links[1]);
$link = $links[0].'?'.$links2[0];
if ($debugging == "yes") echo "- link: $link<br>";

echo "
<form action=\"$link\" method=\"post\" name=\"poll_form\">";

echo "

<table width=\"165\" cellspacing=\"0\" cellpadding=\"2\" class=\"poll\">
<tr>
<td colspan=\"2\" align=\"left\" class=\"poll_question\">$poll_question_active<br></td>
</tr>
<tr><td colspan=\"2\"> </td></tr>
<tr class=\"text\">
<td width=\"25\"></td><td><input value=\"1\" type=\"radio\" name=\"given_answer\">  $poll_answer1_active</td>
</tr>
<tr class=\"text\">
<td width=\"25\" ></td><td><input value=\"2\" type=\"radio\" name=\"given_answer\">  $poll_answer2_active</td>
</tr>";

// poll_answer3 to poll_answer6 are optional...
if(strlen($poll_answer3_active) > 1)
echo "
<tr class=\"text\">
<td width=\"25\" ></td><td><input value=\"3\" type=\"radio\" name=\"given_answer\">  $poll_answer3_active</td>
</tr>";
if(strlen($poll_answer4_active) > 1)
echo "
<tr class=\"text\">
<td width=\"25\" ></td><td><input value=\"4\" type=\"radio\" name=\"given_answer\">  $poll_answer4_active</td>
</tr>";
if(strlen($poll_answer5_active) > 1)
echo "
<tr class=\"text\">
<td width=\"25\" ></td><td><input value=\"5\" type=\"radio\" name=\"given_answer\">  $poll_answer5_active</td>
</tr>";
if(strlen($poll_answer6_active) > 1)
echo "
<tr class=\"text\">
<td width=\"25\" ></td><td><input value=\"6\" type=\"radio\" name=\"given_answer\">  $poll_answer6_active</td>
</tr>";
echo "<tr>
<td> </td><td> </td>
</tr class=\"text\">
<tr>
<td colspan =\"2\">
<input type=\"hidden\" name=\"poll_id\" value=\"".$poll_id_active."\">
<input type=\"hidden\" name=\"poll_action\" value=\"vote\">
<center><input type=\"submit\" class=\"poll_button\" value=\"Abstimmen\"><br>


</form>

</tr>";

} /* end "allowed to vote and no form data given -> show poll form" */

/* show poll stats and store vote if there was one given */
else {

$db = new DB_Contenido;

// if given_answer is valid, store it in poll_log
if ((ereg("^[1-6]{1}$",$given_answer)) and ($poll_stats != "yes")) {
if ($debugging == "yes") echo "- given_answer: $given_answer<br>- poll_stats: $poll_stats<br>";
$sql = "INSERT INTO poll_log VALUES (\"\",$poll_id_active,".
"$given_answer,\"$user_ip\",\"$user_proxy\",UNIX_TIMESTAMP());";
$db->query($sql);
} // end if

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=1;");
$db->next_record();
$result1 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=2;");
$db->next_record();
$result2 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=3;");
$db->next_record();
$result3 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=4;");
$db->next_record();
$result4 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=5;");
$db->next_record();
$result5 = $db->f("COUNT(*)");

$db->query("SELECT COUNT(*) FROM poll_log WHERE poll_id=$poll_id_active and user_vote=6;");
$db->next_record();
$result6 = $db->f("COUNT(*)");

$total = $result1+$result2+$result3+$result4+$result5+$result6;

echo "
<table width=\"165\" cellspacing=\"0\" cellpadding=\"2\" class=\"poll\">";

echo "
<tr class=\"poll_question\"><td>".$poll_question_active."</td></tr><tr><td> </td></tr>";

echo "
<tr class=\"text\"><td><i><u>Gesamt:</u> ".$total." Stimmen</i></td></tr><tr><td> </td></tr>";

if (($result1 > 0) and ($total > 0)) $percent = round(((100*$result1)/$total), 2);
if($result1!="0") $class1= "bar1";
if ($percent < 5.00) $class1 = "";
echo "
<tr class=\"text\"><td>\"<b>".$poll_answer1_active."</b>\" (".$result1.") :</td></tr>";
echo "
<tr><td>
<table><tr class=\"text\"><td class=\"".$class1."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";

if (($result2 > 0) and ($total > 0)) $percent = round(((100*$result2)/$total), 2);
if($result2!="0") $class2= "bar2";
if ($percent < 5.00) $class2 = "";
echo "
<tr class=\"text\"><td>\"<b>".$poll_answer2_active."</b>\" (".$result2.") :</td></tr>";
echo "
<tr><td>
<table><tr class=\"text\"><td class=\"".$class2."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";

if(strlen($poll_answer3_active) > 1){
if (($result3 > 0) and ($total > 0)) $percent = round(((100*$result3)/$total), 2);
if($result3!="0") $class3= "bar3";
if ($percent < 5.00) $class3 = "";
echo "
<tr class=\"text\"><td>\"<b>".$poll_answer3_active."</b>\" (".$result3.") :</td></tr>";
echo "
<tr><td>
<table><tr class=\"text\"><td class=\"".$class3."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";
}

if(strlen($poll_answer4_active) > 1){
if (($result4 > 0) and ($total > 0)) $percent = round(((100*$result4)/$total), 2);
if($result4!="0") $class4= "bar4";
if ($percent < 5.00) $class4 = "";
echo "
<tr class=\"text\"><td>\"<b>".$poll_answer4_active."</b>\" (".$result4.") :</td></tr>";
echo "
<tr><td>
<table><tr class=\"text\"><td class=\"".$class4."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";
}

if(strlen($poll_answer5_active) > 1){
if (($result5 > 0) and ($total > 0)) $percent = round(((100*$result5)/$total), 2);
if($result5!="0") $class5= "bar5";
if ($percent < 5.00) $class5 = "";
echo "
<tr class=\"text\"><td>\"<b>".$poll_answer5_active."</b>\" (".$result5.") :</td></tr>";
echo "
<tr><td>
<table><tr class=\"text\"><td class=\"".$class5."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";
}

if(strlen($poll_answer6_active) > 1){
if (($result6 > 0) and ($total > 0)) $percent = round(((100*$result6)/$total), 2);
if($result6!="0") $class6= "bar6";
if ($percent < 5.00) $class6 = "";
echo "
<tr class=\"text\"><td>\"<b>".$poll_answer6_active."</b>\" (".$result6.") :</td></tr>";
echo "
<tr><td>
<table><tr class=\"text\"><td class=\"".$class6."\" width=\"".$percent."\"> </td></tr></table>";
echo "
</td></tr>
";
}

} // end else

/* print stats link only if stats aren't displayed already */
if ((($_COOKIE['poll']) == "poll_allowed") and ($poll_action != "vote") and ($poll_stats != "yes")) {
echo "

<tr>
<td colspan=\"2\" align=\"center\">
<div align=\"center\"><a href=\"$PHP_SELF?idcat=$idcat&poll_stats=yes\">Statistik »</a></div>
</td>
</tr>
";
}
/* end "print stats link only if stats aren't displayed already" */

echo "

</table>
";

}
/* end "there is an active poll in DB" */

echo "



";

/* unlock tables */
$db1->query("UNLOCK TABLES;");
/* end "unlock tables" */

?>

Grüßle
bloody_marie

Darth-Vader · Beitrag von **Darth-Vader** » Di 3. Aug 2004, 13:13

und was ist mit dem cookie-code der vor das <html> beim layout kommt? haste denn mal ne umfrage in der Db angelegt (macht man in der konfiguration des template)

hast du die install und das changelog mal gelesen?

bloody_marie · Beitrag von **bloody_marie** » Di 3. Aug 2004, 13:22

Cookiecode ist vor dem html-Tag, Habe auch zwei Umfragen angelegt, die Resultate werden ja angezeigt. Tabellen sind auch angelegt.

Habe alles genauso gemacht wie du es beschrieben hast.

Ich habe die neueste version vom 21.05. genommen.

bloody_marie · Beitrag von **bloody_marie** » Di 3. Aug 2004, 13:54

Also, habe das Doctype weggenommen und siehe da, es klappt

bloody_marie · Beitrag von **bloody_marie** » Di 3. Aug 2004, 14:08

Nachdem ich nun einmal abgestimmt habe um zu testen, wird das Voting wieder nicht angezeigt sondern die Ergebnisse, ich verzweifle noch.

bloody_marie · Beitrag von **bloody_marie** » Di 3. Aug 2004, 14:56

O.K, habe $expires_months = 0; gesetzt und jetzt geht es wieder.