session_start();
include("../config.php");
include("../show_tip.php");
if(!$_GET['old']){
$vote_db = mysql_query("SELECT * FROM vote order by -ID");
$vote = mysql_fetch_array($vote_db);
}else{
$vote_db = mysql_query("SELECT * FROM vote WHERE ID = '$_GET[old]'");
$vote = mysql_fetch_array($vote_db);
}
$votes_db = mysql_query("SELECT * FROM votes WHERE vote = '$vote[ID]' && nickname = '$_SESSION[nickname]'");
$votes = mysql_fetch_array($votes_db);
$status_db = mysql_query("SELECT * FROM status WHERE nickname = '$_SESSION[nickname]'");
$status = mysql_fetch_array($status_db);
if($_SESSION['nickname']==""){ echo "Du bist nicht eingeloggt"; }else{
?>
include_once("../_menu.php");
$links = array('
alte Umfragen einsehen '.show_tip(102,$_SESSION['nickname'],0));
echo createMenu($links,275)."
";
if($_GET['show']){
$saw_dbs=mysql_query("SELECT * FROM vote ORDER BY -ID");
while($saw=mysql_fetch_array($saw_dbs)){
$ve_db = mysql_query("SELECT * FROM votes WHERE vote = '$saw[ID]'");
$ve = mysql_num_rows($ve_db);
echo "
".$saw['frage']." Mit ".$ve." Stimmen";
}
exit();
}
if($vote['ID'] == ""){
echo "Derzeit keine Umfrage aktiv";
}else{
if($_GET['seite'] == "ergebniss" or $votes['nickname'] == $_SESSION['nickname'] or $_GET['old']){ echo $vote['frage']."
";
if($votes['nickname'] == $_SESSION['nickname']){
echo "
Du hast bereits abgestimmt"; } ?>
$gesamt = $vote['erg1'] + $vote['erg2'] + $vote['erg3'] + $vote['erg4'] + $vote['erg5'] + $vote['erg6'];
if($vote['ant1'] != ""){ ?>
echo $vote['ant1']; ?> |
echo $vote['erg1']." ("; $a1=round($vote['erg1']/$gesamt*100,1); echo $a1."%)"; ?> |
|
} if($vote['ant2'] != ""){ ?>
echo $vote['ant2']; ?> |
echo $vote['erg2']." ("; $a2=round($vote['erg2']/$gesamt*100,1); echo $a2."%)"; ?> |
|
} if($vote['ant3'] != ""){ ?>
echo $vote['ant3']; ?> |
echo $vote['erg3']." ("; $a3=round($vote['erg3']/$gesamt*100,1); echo $a3."%)"; ?> |
|
} if($vote['ant4'] != ""){ ?>
echo $vote['ant4']; ?> |
echo $vote['erg4']." ("; $a4=round($vote['erg4']/$gesamt*100,1); echo $a4."%)"; ?> |
|
} if($vote['ant5'] != ""){ ?>
echo $vote['ant5']; ?> |
echo $vote['erg5']." ("; $a5=round($vote['erg5']/$gesamt*100,1); echo $a5."%)"; ?> |
|
} if($vote['ant6'] != ""){ ?>
echo $vote['ant6']; ?> |
echo $vote['erg6']." ("; $a6=round($vote['erg6']/$gesamt*100,1); echo $a6."%)"; ?> |
|
} ?>
Stimmen |
echo $vote['erg1'] + $vote['erg2'] + $vote['erg3'] + $vote['erg4'] + $vote['erg5'] + $vote['erg6']; ?> |
|
}
if($_POST['abstimmen']){
if($votes['nickname'] == $_SESSION['nickname']){
echo "Du hast bereits abgestimmt";
}else{
$ppk = $status['ppkt'] + 5;
mysql_query("UPDATE status Set ppkt = '$ppk' WHERE nickname = '$status[nickname]'");
echo $_SESSION['nickname']." du hast erfolgreich ".$_POST['antwort']." gestimmt.";
if($vote['ant1'] == $_POST['antwort']){
mysql_query("INSERT INTO votes (vote, nickname, ant) VALUES ('$vote[ID]', '$_SESSION[nickname]', '$_POST[antwort]')");
$erg = $vote['erg1'] + 1;
mysql_query("UPDATE vote Set erg1 = '$erg' WHERE ID = '$vote[ID]'");
}
if($vote['ant2'] == $_POST['antwort']){
mysql_query("INSERT INTO votes (vote, nickname, ant) VALUES ('$vote[ID]', '$_SESSION[nickname]', '$_POST[antwort]')");
$erg = $vote['erg2'] + 1;
mysql_query("UPDATE vote Set erg2 = '$erg' WHERE ID = '$vote[ID]'");
}
if($vote['ant3'] == $_POST['antwort']){
mysql_query("INSERT INTO votes (vote, nickname, ant) VALUES ('$vote[ID]', '$_SESSION[nickname]', '$_POST[antwort]')");
$erg = $vote['erg3'] + 1;
mysql_query("UPDATE vote Set erg3 = '$erg' WHERE ID = '$vote[ID]'");
}
if($vote['ant4'] == $_POST['antwort']){
mysql_query("INSERT INTO votes (vote, nickname, ant) VALUES ('$vote[ID]', '$_SESSION[nickname]', '$_POST[antwort]')");
$erg = $vote['erg4'] + 1;
mysql_query("UPDATE vote Set erg4 = '$erg' WHERE ID = '$vote[ID]'");
}
if($vote['ant5'] == $_POST['antwort']){
mysql_query("INSERT INTO votes (vote, nickname, ant) VALUES ('$vote[ID]', '$_SESSION[nickname]', '$_POST[antwort]')");
$erg = $vote['erg5'] + 1;
mysql_query("UPDATE vote Set erg5 = '$erg' WHERE ID = '$vote[ID]'");
}
if($vote['ant6'] == $_POST['antwort']){
mysql_query("INSERT INTO votes (vote, nickname, ant) VALUES ('$vote[ID]', '$_SESSION[nickname]', '$_POST[antwort]')");
$erg = $vote['erg6'] + 1;
mysql_query("UPDATE vote Set erg6 = '$erg' WHERE ID = '$vote[ID]'");
}
?>
Ergebnis ansehen
}}
if(!$_POST['abstimmen'] && !$_GET['seite'] && $votes['nickname'] != $_SESSION['nickname'] && !$_GET['old']){
echo "Aktuelle Mitglieder Umfrage von U-Race.de
"; ?>
}}}
$status1_db = mysql_query("SELECT * FROM premium WHERE nickname = '$_SESSION[nickname]'");
$status1 = mysql_fetch_array($status1_db);
if($status1['p1_ende'] <= time()){
?>
} ?>