Mai 09

The Killers Foto Quiz

Jörn @ 10:49

$upas = Array("ä" => “ae”, “ü” => “ue”, “ö” => “oe”, “Ä” => “Ae”, “Ü” => “Ue”, “Ö” => “Oe”, “ß” => “ss”);

if (!isset($_SESSION['fqname'])) {
$name = trim($_POST['fqname']);
$name = htmlentities(strtr($name, $upas));
$name = addslashes($name);
if ($name != “”) {
$_SESSION['fqname'] = $name;
} else {
unset($_SESSION['fqname']);
}
}

if (!isset($_SESSION['fqemail'])) {
$email = trim($_POST['fqemail']);
$email = htmlentities($email);
$email = addslashes($email);
if ($email != “”) {
$_SESSION['fqemail'] = $email;
} else {
unset($_SESSION['fqemail']);
}
}

if (!isset($_SESSION['pics'])) {
if ($_POST['pics'] == 3 OR $_POST['pics'] == 4 OR $_POST['pics'] == 5) {
$_SESSION['pics'] = $_POST['pics'];
//Set persons data
$_SESSION['vorname'] = htmlentities(strtr($_POST['vorname'], $upas));
$_SESSION['nachname'] = htmlentities(strtr($_POST['nachname'], $upas));
$_SESSION['strasse'] = htmlentities(strtr($_POST['strasse'], $upas));
$_SESSION['plz'] = htmlentities(strtr($_POST['plz'], $upas));
$_SESSION['ort'] = htmlentities(strtr($_POST['ort'], $upas));
$_SESSION['land'] = htmlentities(strtr($_POST['land'], $upas));
if ($_POST['lang'] == “de” OR $_POST['lang'] == “en”) {
$_SESSION['lang'] = htmlentities(strtr($_POST['lang'], $upas));
} else {
$_SESSION['lang'] = “de”;
}
} else {
unset($_SESSION['pics']);
}
}

// $_SESSION['vorname'] = htmlentities(strtr($_POST['vorname'], $upas));
/*
if (count($_SESSION['pic_id_all']) != ($_SESSION['answered_pics']) {
unset($_SESSION['fotoquiz_start']);
}
*/
if (!isset($_SESSION['pics']) OR !isset($_SESSION['fqname']) OR !isset($_SESSION['fotoquiz_start'])) {
unset($_SESSION['fotoquiz_start']);
unset($_SESSION['last_pic_id']);
unset($_SESSION['pic_id_all']);
unset($_SESSION['fqname']);
unset($_SESSION['pics']);
unset($_SESSION['answered_pics']);
unset($_SESSION['fqemail']);
unset($_SESSION['points']);
unset($_SESSION['time']);
session_destroy;
}

if (!isset($_SESSION['last_pic_id'])) {
$_SESSION['last_pic_id'] = 0;
}

if (!isset($_SESSION['answered_pics'])) {
$_SESSION['answered_pics'] = 0;
}

if (!isset($_SESSION['points'])) {
$_SESSION['points'] = 0;
}

//Did the user find all the mistakes?
if ($_POST['mistakes'] != “”) {
$mistakes = trim($_POST['mistakes']);
$mistakes = htmlentities(strtr($mistakes, $upas));
$mistakes = addslashes($mistakes);

if ($mistakes == $_SESSION['pic_mistakes']) {
$_SESSION['points']++;
}
}

//Is the game over?
if (isset($_SESSION['answered_pics']) AND isset($_SESSION['pics'])) {
if ($_SESSION['answered_pics'] >= $_SESSION['pics']) {
$_SESSION['fotoquiz_start'] = “end”;
}
}

if (!isset($_SESSION['fotoquiz_start'])) {

//Startseite
$_SESSION['fotoquiz_start'] = “true”; ?>

Spielregeln

Beim The Killers Foto Quiz bekommst du jeweils zwei Fotos gezeigt. Eines der Bilder wurde jedoch verändert und du musst herausfinden, wie viele Fehler in das zweite Bild eingebaut wurden. Trage die Anzahl der gefundenen Fehler in das dafür vorgesehene Feld ein.
Viel Spaß beim Rätseln und Fehler finden!
Die Angabe der mit einem * gekennzeichneten Felder ist freiwillig!

ACHTUNG: Solltest du an einem Gewinnspiel teilnehmen wollen, so musst du alle Felder des Formulares ausfüllen, damit wir den Gewinn ggf. direkt an dich senden können!

Rules

In The Killers Foto Quiz you will be shown two different photographs, one of which has been modified. Your mission is to find how many mistakes the second picture has. Fill in the amount of mistakes you found in the textbox below the picture.
It is not required to enter the field marked with an * !

WARNING: If you’d like to participate in a current sweepstakes for the opportunity to receive a prize for your efforts you have to fill out the whole form below so we can send you your prize right away – in the case that you have won.

The Killers Foto Quiz

Name in Highscore:

Fotos:

Sprache / Language

E-Mail:*

Vorname / First name:*

Nachname / Last name:*

Strasse / Street:*

Postleitzahl / Zipcode:*

Wohnort / City:*

Land / Country:*

Letzten 10 Spieler

Most Recent 10 Players

//Letzen 10 Spieler

$i = 1;

$query_top10 = "SELECT name, points, timestamp
FROM 83_thekillersfotoquiz
ORDER BY timestamp DESC
LIMIT 10";
$result_top10 = mysql_query($query_top10);
$number_top10 = mysql_numrows($result_top10);
while ($row_top10 = mysql_fetch_array($result_top10)) {

if ($row_top10['points'] == 1) {
$points_de = "Foto";
$points_en = "Picture";
} else {
$points_de = "Fotos";
$points_en = "Pictures";
}

?>

“.$row_top10['name'] .” – “. $row_top10['points'] .” “. $points_de .”

“;
?>

“.$row_top10['name'] .” – “. $row_top10['points'] .” “. $points_en .”

“;
?>

$i++;
}

} elseif ($_SESSION['fotoquiz_start'] == "true") {
//Quiz
if (!isset($_SESSION['time'])) {
$_SESSION['time'] = time();
}

$_SESSION['answered_pics']++;

if($_SESSION['last_pic_id'] == 0) {
$query_quiz = "SELECT *
FROM 83_thekillersfotoquiz_data
ORDER BY RAND()
LIMIT 1";
} else {
//Tell script which picture (ids) where already used - so we do not get doubles!
$arr_id_all = array();
$arr_id_all = explode(";", $_SESSION['pic_id_all']);

echo $arr_id_all;

//Create WHERE string for MySQL query
$start = 1;
if (count($arr_id_all) > 1) {
foreach ($arr_id_all as $pic_id) {
if($start == 1) {
$start = 0;
$where_query = “id != “. $pic_id;
} else {
$where_query .= ” AND id != “. $pic_id;
}
}
} else {
$where_query = “id != “. $_SESSION['last_pic_id'];
}

//echo $where_query;
$query_quiz = “SELECT *
FROM 83_thekillersfotoquiz_data
WHERE “. $where_query .”
ORDER BY RAND()
LIMIT 1″;
}

$result_quiz = mysql_query($query_quiz);
$number_quiz = mysql_numrows($result_quiz);
$row_quiz = mysql_fetch_array($result_quiz);

//Initialise variables
$_SESSION['last_pic_id'] = $row_quiz['id'];

//Add the current song id to array
$arr_id_all[] = $row_quiz['id'];
//Create string from array
$_SESSION['pic_id_all'] = implode(“;”, $arr_id_all);

//How many mistakes ARE in the pictures?
$_SESSION['pic_mistakes'] = $row_quiz['anz_fehler'];

?>

Wie viele Fehler findest du?
How many mistakes do you count?

.jpg”>

_mod.jpg”>

Fehler / Mistakes:

} elseif ($_SESSION['fotoquiz_start'] == "end") {
if ($_SESSION['points'] > $_SESSION['pics']) {
echo “ERROR :: POINTS ::Please contact the administrator”;
session_destroy;
die();
}

$time_now = time();

if ($_SESSION['time'] >= $time_now) {
echo “ERROR :: TIME :: Please contact the administrator”;
session_destroy;
die();
} else {
$time_finish = $time_now – $_SESSION['time'];
}

//echo $_SESSION['hsname'] .” mail: “. $_SESSION['hsemail'] .” anz. songs: “. $_SESSION['songs'] .” answ. songs: “. $_SESSION['answered_songs'] .” points: “. $_SESSION['points'] .” time: “. $_SESSION['time'] .” time2: “. $time_now .” time_diff: “. $time_finish;

$query_insert = “INSERT
INTO 83_thekillersfotoquiz SET
name = ‘”. $_SESSION['fqname'] .”‘,
points = ‘”. $_SESSION['points'] .”‘,
time = ‘”. $time_finish .”‘,
timestamp = ‘”. $_SESSION['time'] .”‘,
email = ‘”. $_SESSION['fqemail'] .”‘,
vorname = ‘”.$_SESSION['vorname'].”‘,
nachname = ‘”.$_SESSION['nachname'].”‘,
strasse = ‘”.$_SESSION['strasse'].”‘,
plz = ‘”.$_SESSION['plz'].”‘,
ort = ‘”.$_SESSION['ort'].”‘,
land = ‘”.$_SESSION['land'].”‘,
lang = ‘”.$_SESSION['lang'].”‘”;

$result_insert = mysql_query($query_insert) OR DIE(“Fehler – Fehlermeldung: ” . mysql_error());
?>

Herzlichen Glückwunsch

Du hast auf von möglichen Bildern alle Fehler erkannt.
Insgesamt hast du Sekunden benötigt, um auf Fotos Fehler zu finden.

Versuche es noch einmal!

Hast du schon das The Killers Zitat Quiz ausprobiert?

Zeige jedem, dass du ein The Killers Fan bist, mit den Zitaten in deiner Forensignatur – passe das Design deinen Vorlieben an!

Congratulations

You were successful in finding all mistakes for out of pictures!
You needed seconds to find mistakes on pictures.

Try again!

Did you try out The Killers Quotes Quiz yet?

Show everyone that you are a The Killers Fan with the quotes in your signature – customize it with your favourite colors!!

Letzten 10 Spieler

Most Recent 10 Players

//Letzen 10 Spieler

$i = 1;

$query_top10 = "SELECT name, points, timestamp
FROM 83_thekillersfotoquiz
ORDER BY timestamp DESC
LIMIT 10";
$result_top10 = mysql_query($query_top10);
$number_top10 = mysql_numrows($result_top10);
while ($row_top10 = mysql_fetch_array($result_top10)) {

if ($row_top10['points'] == 1) {
$points_de = "Foto";
$points_en = "Picture";
} else {
$points_de = "Fotos";
$points_en = "Pictures";
}

?>

“.$row_top10['name'] .” – “. $row_top10['points'] .” “. $points_de .”

“;
?>

“.$row_top10['name'] .” – “. $row_top10['points'] .” “. $points_en .”

“;
?>

$i++;
}

//Destroy used Sessionvariables
unset($_SESSION['fotoquiz_start']);
unset($_SESSION['last_pic_id']);
unset($_SESSION['fqname']);
unset($_SESSION['pics']);
unset($_SESSION['pic_id_all']);
unset($_SESSION['answered_pics']);
unset($_SESSION['pic_mistakes']);
unset($_SESSION['fqemail']);
unset($_SESSION['points']);
unset($_SESSION['time']);
unset($_SESSION['lang']);
unset($_SESSION['vorname']);
unset($_SESSION['nachname']);
unset($_SESSION['strasse']);
unset($_SESSION['plz']);
unset($_SESSION['ort']);
unset($_SESSION['land']);
session_destroy;

}

//TEST 3
//echo "
TEST 3 name: “. $_SESSION['fqname'] .” last_pic_id”. $_SESSION['last_pic_id'] .” fotoquiz:”. $_SESSION['fotoquiz_start'] .” pic:”. $row_quiz['pic'] .” mail: “. $_SESSION['fqemail'] .” anz. pics: “. $_SESSION['pics'] .” answ. pics: “. $_SESSION['answered_pics'] .” points: “. $_SESSION['points'] .” time: “. $_SESSION['time'];

?>