Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- </head>
- <body>
- <?
- /***************************************
- **************Funktionen****************
- ***************************************/
- /**********kandidaten-Auflistung********/
- function showKandi($stat) {
- $sql = mysql_query("SELECT * ,REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(Name, 'Ä', 'A'), 'Ö','O'), 'Ü', 'U'),'ä', 'a'), 'ö', 'o'), 'ü','u'), 'ß', 's') AS sortiert FROM kandidaten ORDER BY sortiert");
- while ($kandidaten = mysql_fetch_object($sql)) {
- $kaName = $kandidaten -> NAME;
- $kaGruppe = $kandidaten -> GRUPPE;
- if ($kaGruppe == 1) {
- $kaGruppe1[] = $kaName;
- }
- else {
- $kaGruppe2[] = $kaName;
- }
- }
- $echo = "<table>
- <tr>
- <td class=\"hl\" align=\"center\" colspan=\"2\">Altersgruppe 14-17 Jahre</td>
- <td id=\"abstandGruppen\"> </td>
- <td class=\"hl\" align=\"center\" colspan=\"2\">Altersgruppe 18-21 Jahre</td>
- </tr>
- <tr><td colspan=\"5\"> </td></tr>";
- foreach ($kaGruppe1 as $value) {
- $maxGruppe1++;
- }
- foreach ($kaGruppe2 as $value) {
- $maxGruppe2++;
- }
- $x = 0;
- if ($stat == "show") {
- if ($maxGruppe1 >= $maxGruppe2) {
- foreach ($kaGruppe1 as $value) {
- $echo .= "<tr><td>".$value."</td><td> </td><td> </td><td>".$kaGruppe2[$x]."</td></tr>";
- $x++;
- }
- }
- else {
- foreach ($kaGruppe2 as $value) {
- $echo .= "<tr><td>".$kaGruppe1[$x]."</td><td> </td><td> </td><td>".$value."</td></tr>";
- $x++;
- }
- }
- }
- elseif ($stat == "vote") {
- if ($maxGruppe1 >= $maxGruppe2) {
- foreach ($kaGruppe1 as $value) {
- $echo .= "
- <tr><td><input type=\"checkbox\" name=\"gruppe1[]\" value=\"".$value."\" /></td>
- <td>".$value."</td>
- <td> </td>";
- if (empty($kaGruppe2[$x])) {
- $echo .= "<td> </td><td> </td>";
- }
- else {
- $echo .= "
- <td><input type=\"checkbox\" name=\"gruppe2[]\" value=\"".$kaGruppe2[$x]."\" /></td>
- <td>".$kaGruppe2[$x]."</td></tr>";
- }
- $x++;
- }
- }
- else {
- foreach ($kaGruppe2 as $value) {
- if (empty($kaGruppe1[$x])) {
- $echo .= "<td> </td><td> </td>";
- }
- else {
- $echo .= "
- <tr><td><input type=\"checkbox\" name=\"gruppe1[]\" value=\"".$kaGruppe1[$x]."\" /></td>
- <td>".$kaGruppe1[$x]."</td>";
- }
- $echo .= "
- <td> </td>
- <td><input type=\"checkbox\" name=\"gruppe2[]\" value=\"".$value."\" />
- </td><td>".$value."</td></tr>";
- $x++;
- }
- }
- }
- $echo .= "<tr><td align=\"center\" colspan=\"5\"><input type=\"submit\" value=\"Wählen\" /></td></tr></table>";
- return $echo;
- }
- /**********Wähler-Auflistung***********/
- function showVoters () {
- $echo = "<ul>";
- $sql = mysql_query("SELECT * FROM user WHERE VOTED = 1");
- while($user = mysql_fetch_object($sql)) {
- $username = $user -> ID;
- $echo .= "<li class=\"ausgabe\">".$username."</li>";
- }
- $echo .= "</ul>";
- return $echo;
- }
- /**********IP-Auth-Prüfung*************/
- function checkLogin () {
- $login = FALSE;
- $sql = mysql_query("SELECT * FROM ip_auth");
- $client_ip = $_SERVER['REMOTE_ADDR'];
- while($ip_auth = mysql_fetch_object($sql)) {
- $check_ip = $ip_auth -> IP;
- $check_id = $ip_auth -> ID;
- if($check_ip == $client_ip)
- {
- $login = TRUE;
- }
- }
- return $login;
- }
- /**********User-ID Abfragen************/
- function getUserid() {
- $sql = mysql_query("SELECT * FROM ip_auth");
- $client_ip = $_SERVER['REMOTE_ADDR'];
- while($ip_auth = mysql_fetch_object($sql)) {
- $check_ip = $ip_auth -> IP;
- $check_id = $ip_auth -> ID;
- $check_userid = $ip_auth -> USERID;
- if($check_ip == $client_ip)
- {
- $userid = $check_userid;
- }
- }
- return $userid;
- }
- /**********Zufälliges Passwort*********/
- function getRandpw($length) {
- $newpass = "";
- $string="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
- mt_srand((double)microtime()*1000000);
- for ($i=1; $i <= $length; $i++)
- {
- $newpass .= substr($string, mt_rand(0,strlen($string)-1), 1);
- }
- return $newpass;
- }
- /**********User-Anlegen****************/
- function createUser($anzahl) {
- $dummy = mysql_query("TRUNCATE TABLE user");
- $echo ="<span class=\"headline\">Einzige Ausgabe der Passwörter.</span><br/>Die Passwörter werden jetzt verschlüsselt und können nicht noch einmal ausgegeben werden. Kopieren Sie sie in ein Textdokument oder eine Tabelle.<br />Wenn Sie die Passwörter nicht speichern, müssen Sie neue Zugänge einrichten.</p>
- <ul>
- <li class=\"hl\">Userid : Passwort</p>";
- for ($x = 1; $x <= $anzahl; $x++)
- {
- $pass_clear = getRandpw(8);
- $pass = md5($pass_clear);
- mysql_query("INSERT INTO user ( PASSWORD, VOTED, FEEDBACK) VALUES ( '$pass','0','0')") or die(mysql_error());
- $echo .= "<li class=\"ausgabe\">".$x." : ".$pass_clear."</li>";
- }
- $echo .= "</ul>
- <a href=\"adminlogin.php\">[Zurück]</a>";
- return $echo;
- }
- /**********Wahlstatus Abrufen**********/
- function getVotestat() {
- $sql = mysql_query("SELECT * FROM status WHERE ID=1");
- $t_status = mysql_fetch_object($sql);
- $stat = $t_status -> VALUE;
- return $stat;
- }
- /**********Ergebnis anzeigen***********/
- function showResult($who) {
- $totalVotes1 = 0;
- $totalVotes2 = 0;
- $collength = 600;
- $sql = mysql_query("SELECT * FROM kandidaten ORDER BY NAME");
- while ($t_kandidaten = mysql_fetch_object($sql)) {
- $kaName = $t_kandidaten -> NAME;
- $kaGruppe = $t_kandidaten -> GRUPPE;
- $kaVotes = $t_kandidaten -> STIMMEN;
- if ($kaGruppe == 1) {
- $kaGruppe1[] = $kaName;
- $kaVotes1[] = $kaVotes;
- $totalVotes1 += $kaVotes;
- }
- else {
- $kaGruppe2[] = $kaName;
- $kaVotes2[] = $kaVotes;
- $totalVotes2 += $kaVotes;
- }
- }
- $echo = "";
- if ($who == "user") {
- $echo = "<p class=\"headline\">Das Wahlergebnis:</p>";
- }
- $echo .= "<table align=\"center\">
- <tr>
- <td class=\"hl\" align=\"center\">Altersgruppe 14-17 Jahre</td>
- </tr><tr><td> </td></tr>";
- $x = 0;
- $echo .= "<tr><td><table border=\"2\" rules=\"rows\" frame=\"void\">";
- foreach ($kaGruppe1 as $value) {
- $pro = round(100 / ($totalVotes1/2) * ($kaVotes1[$x]/2), 0);
- $colpro = round ($collength / 100 * $pro, 0);
- $y = $x%2;
- $echo .= "<tr><td>".$value."</td>
- <td><img src=\"inc/".$y.".jpg\" height=\"20\" width=\"".$colpro."px\" /> ".$pro."% (".($kaVotes1[$x]/2).")</td></tr>";
- $x++;
- }
- if ($who == "admin") {
- $echo .= "
- <tr>
- <td colspan=\"2\"><b>Gesamtstimmen in dieser Altersklasse: ".($totalVotes1/2)."</b></td>
- </tr>";
- }
- $echo .= "</table></td></tr><tr><td> </td></tr><tr><td> </td></tr><tr><td> </td></tr>";
- $echo .=
- "<tr>
- <td class=\"hl\" align=\"center\" colspan=\"2\">Altersgruppe 18-21 Jahre</td>
- </tr><tr><td> </td></tr>";
- $x = 0;
- $echo .= "<tr><td><table border=\"2\" rules=\"rows\" frame=\"void\">";
- foreach ($kaGruppe2 as $value) {
- $pro = round(100 / ($totalVotes2/2) * ($kaVotes2[$x]/2), 0);
- $colpro = round ($collength / 100 * $pro, 0);
- $y = $x%2;
- $echo .= "<tr>
- <td>".$value."</td>
- <td><img src=\"inc/".$y.".jpg\" height=\"20\" width=\"".$colpro."px\" /> ".$pro."% (".($kaVotes2[$x]/2).")</td>
- </tr>";
- $x++;
- }
- if ($who == "admin") {
- $echo .= "
- <tr>
- <td colspan=\"2\"><b>Gesamtstimmen in dieser Altersklasse: ".($totalVotes2/2)."</b></td>
- </tr>";
- }
- $echo .= "</table></td></tr>";
- $echo .= "</table>";
- return $echo;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement