Dez 06

The Killers Zitat Quiz

Jörn @ 19:02

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

if ($_SESSION['quiz_restart'] == “yes”) {
unset($_SESSION['last_id']);
unset($_SESSION['songs']);
unset($_SESSION['answered_songs']);
unset($_SESSION['hsname']);
unset($_SESSION['hsemail']);
unset($_SESSION['points']);
unset($_SESSION['time']);
unset($_SESSION['vorname']);
unset($_SESSION['nachname']);
unset($_SESSION['strasse']);
unset($_SESSION['plz']);
unset($_SESSION['ort']);
unset($_SESSION['land']);

$_SESSION[quiz_restart] = “no”;
}

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

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

if (!isset($_SESSION['songs'])) {
if ($_POST['songs'] == 10 OR $_POST['songs'] == 20 OR $_POST['songs'] == 30) {
$_SESSION['songs'] = $_POST['songs'];
//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['songs']);
}
}

if ($_SESSION['quiz_start'] == “true” AND (!isset($_SESSION['hsname']) OR !isset($_SESSION['songs']))) {
unset($_SESSION['quiz_start']);
unset($_SESSION['last_id']);
unset($_SESSION['hsname']);
unset($_SESSION['songs']);
unset($_SESSION['answered_songs']);
unset($_SESSION['hsemail']);
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']);
}

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

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

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

//If user answered all songs, end the quiz!
if (isset($_SESSION['answered_songs']) AND isset($_SESSION['songs'])) {
if ($_SESSION['answered_songs'] >= $_SESSION['songs']) {
$_SESSION['quiz_start'] = “end”;
}
}

//Add points if song is right
if ($_POST['answer_song'] != “”) {
if ($_SESSION['last_id'] == $_POST['answer_song']) {
$_SESSION['points']++;
}
}

//Hall of Fame
$query_week = “SELECT week
FROM 83_thekillersquiz_weekly
ORDER BY week DESC
LIMIT 1″;
$result_week = mysql_query($query_week);
$number_week = mysql_numrows($result_week);
$row_week = mysql_fetch_array($result_week);
$week = $row_week['week'];
$week_now = time();
//Is it time to write new stats for the week?
if ($week_now > ($week + 604800)) {
//Get current #1 Player
$query_number1 = “SELECT id
FROM 83_thekillersquiz
WHERE timestamp > ‘”. $week .”‘
ORDER BY points DESC,
time ASC
LIMIT 1″;
$result_number1 = mysql_query($query_number1);
$number_number1 = mysql_numrows($result_number1);
$row_number1 = mysql_fetch_array($result_number1);

$winner = $row_number1['id'];

$current_week = $week + 604800;
if ($number_number1 == 1) {
//Insert Player into Hall of Fame
$query_insert_number1 = “INSERT
INTO 83_thekillersquiz_weekly SET
player_id = ‘”. $winner .”‘,
week = ‘”. $current_week .”‘”;
$result_insert_number1 = mysql_query($query_insert_number1) OR DIE(“Fehler – Fehlermeldung: ” . mysql_error());
}
}

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

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

Spielregeln

Beim The Killers Quiz bekommst du beliebige Zeilen aus vielen verschiedenen The Killers Songs angezeigt und du musst dich entscheiden, zu welchem Song der Ausschnitt gehört. Um die Auswahl etwas einzugrenzen bekommst du drei Möglichkeiten angezeigt, wobei nur eine davon die Richtige sein kann.
Für jeden richtigen Song bekommst du einen Punkt! Am Ende des Spiels werden diese zusammen addiert. Mit dieser Gesamtpunktzahl wirst du in die Highscoreliste eingetragen!
Aber Vorsicht! Es zählt nicht nur, ob der Song richtig gewählt wurde, sondern auch wie schnell du für deine Antwort benötigst! Haben zwei oder mehr Teilnehmer die gleiche Punktzahl erreicht, entscheidet über die Platzierung, wer der schnellere war!

Bitte gebe im unteren Formular deinen Namen an, so wie er am Ende vom The Killers Quiz im Highscore stehen soll!
Wähle dann aus, wie viele Songs du zuordnen möchtest. Bedenke: Je mehr Songs du zuordnen möchtest, desto mehr Punkte kannst du erreichen – allerdings dauert das Quiz dann natürlich auch etwas länger…
Die Angabe deiner E-Mail Adresse ist freiwillig! Solltest du sie angeben, wirst du darüber benachrichtigt, wenn jemand mehr Punkte erreicht hat als du oder schneller war.

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

The Killers Quiz is a game where you have to identify which The Killers song the listed quotes are from. For each quote, you will be given a choice of three different The Killers songs – but only one answer is right!
For each song you answer correctly you’ll get one point! At the end of the game they’ll be added up and your name will appear in the highscore list next to your total points.
But time is also a factor! It’s not only important to answer each question correctly but also to be fast! For example, if there is a tie between two players who matched the same number of quotes correctly to their songs, then the winner will be decided by who was the fastest!

Please enter your name in the form below in order for it to appear in the highscore list after you finish The Killers Quiz!

After adding your name you need to choose how many songs you’d like to match. Remember: The more songs you want to match, the more points you can achieve – but the quiz will take longer then…
Your email address is not required but if you do include it you will receive an information email updating you on any players who surpass your current performance.

WARNING: If you’d like to participate in a current sweepstakes for the opportunity to receive a prize for your efforts, it is necessary to complete the form below in all of its entirety so we may send your prize right away!

The Killers Zitat Quiz

Name in Highscore:

Songs:

Sprache / Language

E-Mail:*

Vorname / First name

Nachname / Last name

Strasse / Street

Postleitzahl / Zipcode

Wohnort / City

Land / Country

Wöchentliche Top 10 Platzierung

echo date("d.m.Y H:i", ($week + 1)) ." - ". date("d.m.Y H:i", ($week + 604800)) ." (Zeitzone: Berlin)

“;

?>

Weekly Top 10 Highscore

echo date("m.d.Y H:i", ($week + 1)) ." - ". date("m.d.Y H:i", ($week + 604800)) ." (Timezone: Berlin)

“;

?>

//Top 10 Highscore

$i = 1;

$query_top10 = "SELECT name, points, time
FROM 83_thekillersquiz
WHERE timestamp > ‘”. $week .”‘
ORDER BY points DESC,
time ASC
LIMIT 10″;
$result_top10 = mysql_query($query_top10);
$number_top10 = mysql_numrows($result_top10);
while ($row_top10 = mysql_fetch_array($result_top10)) {
?>

“.$row_top10['name'] .” erreichte “. $row_top10['points'] .” Punkte
in “. $row_top10['time'] .” (Sekunden)

“;
?>

“.$row_top10['name'] .” got “. $row_top10['points'] .” points
in “. $row_top10['time'] .” (seconds)

“;
?>

$i++;
}

//HALL OF FAME

?>

Hall of Fame

$query_hof = "SELECT a.name, a.points, a.time, b.week
FROM 83_thekillersquiz AS a JOIN 83_thekillersquiz_weekly AS b
WHERE a.id = b.player_id
ORDER BY b.week DESC
LIMIT 10";
$result_hof = mysql_query($query_hof);
$number_hof = mysql_numrows($result_hof);
while ($row_hof = mysql_fetch_array($result_hof)) {
?>

“.$row_hof['name'] .” erreichte “. $row_hof['points'] .” Punkte
in “. $row_hof['time'] .” (Sekunden)

“;
?>

“.$row_hof['name'] .” got “. $row_hof['points'] .” points
in “. $row_hof['time'] .” (seconds)

“;
?>

}

?>

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

$_SESSION['answered_songs']++;
$arr_answers = array();

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

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

//echo $where_query;
$query_quiz = “SELECT *
FROM 83_thekillersquotes
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_id'] = $row_quiz['id'];

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

//Get wrong answers
$query_wrong_answers = “SELECT id, song
FROM 83_thekillersquotes
WHERE id != “. $_SESSION['last_id'] .”
AND song != ‘”. addslashes($row_quiz['song']) .”‘
ORDER BY RAND()
LIMIT 1″;
$result_wrong_answers = mysql_query($query_wrong_answers);
$number_wrong_answers = mysql_numrows($result_wrong_answers);
$row_wrong_answers = mysql_fetch_array($result_wrong_answers);
$wrong_song_1 = addslashes($row_wrong_answers['song']);

//Get wrong answers
$query_wrong_answers_2 = “SELECT id, song
FROM 83_thekillersquotes
WHERE id != “. $_SESSION['last_id'] .”
AND song != ‘”. addslashes($row_quiz['song']) .”‘
AND song != ‘”. $wrong_song_1 .”‘
ORDER BY RAND()
LIMIT 1″;
$result_wrong_answers_2 = mysql_query($query_wrong_answers_2);
$number_wrong_answers_2 = mysql_numrows($result_wrong_answers_2);
$row_wrong_answers_2 = mysql_fetch_array($result_wrong_answers_2);
$wrong_song_2 = addslashes($row_wrong_answers_2['song']);

?>

Zu welchem The Killers Song gehört folgende Zeile?
Which The Killers song is the following line taken from?

$rndm = rand(0,5);

if ($rndm == 0) {
?>

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

$time_now = time();

if ($_SESSION['time'] >= $time_now) {
echo “ERROR :: TIME :: Please contact the administrator”;
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_thekillersquiz SET
name = ‘”. $_SESSION['hsname'] .”‘,
points = ‘”. $_SESSION['points'] .”‘,
time = ‘”. $time_finish .”‘,
timestamp = ‘”. $_SESSION['time'] .”‘,
email = ‘”. $_SESSION['hsemail'] .”‘,
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 von möglichen Punkten erreicht.
Insgesamt hast du Sekunden benötigt, um Zitate zuzuordnen.

Versuche es erneut und verbessere deinen Highscore!

Hast du schon das The Killers Foto Quiz ausprobiert?

Bitte sende uns weitere Zitate ein, so dass wir das Quiz weiter ausbauen können. Schreibe deine Lieblingszeilen im Forum in diesem Topic!

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

Congratulations

You have out of possible points!
You needed seconds to match The Killers quotes.

Try it again and beat your highscore!

Did you try out The Killers Foto Quiz yet?

Please send us more quotes so we can expand the quiz! Simply write on the official The Killers board in this topic what your favorite lines are!

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

Wöchentliche Top 10 Platzierung

echo date("d.m.Y H:i", ($week + 1)) ." - ". date("d.m.Y H:i", ($week + 604800)) ." (Zeitzone: Berlin)

“;

?>

Weekly Top 10 Highscore

echo date("m.d.Y H:i", ($week + 1)) ." - ". date("m.d.Y H:i", ($week + 604800)) ." (Timezone: Berlin)

“;

?>

//Top 10 Highscore

$i = 1;

$query_top10 = "SELECT name, points, time
FROM 83_thekillersquiz
WHERE timestamp > ‘”. $week .”‘
ORDER BY points DESC,
time ASC
LIMIT 10″;
$result_top10 = mysql_query($query_top10);
$number_top10 = mysql_numrows($result_top10);
while ($row_top10 = mysql_fetch_array($result_top10)) {
?>

“.$row_top10['name'] .” erreichte “. $row_top10['points'] .” Punkte
in “. $row_top10['time'] .” (Sekunden)

“;
?>

“.$row_top10['name'] .” got “. $row_top10['points'] .” points
in “. $row_top10['time'] .” (seconds)

“;
?>

$i++;
}

//Destroy used Sessionvariables
unset($_SESSION['quiz_start']);
unset($_SESSION['last_id']);
unset($_SESSION['hsname']);
unset($_SESSION['songs']);
unset($_SESSION['answered_songs']);
unset($_SESSION['hsemail']);
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']);

}
//TEST 3
//echo "
TEST 3 : “. $_SESSION['hsname'] .” “. $_SESSION['last_id'] .” “. $_SESSION['quiz_start'] .” “. $row_quiz['song'] .” “. $wrong_song_1 .” “. $wrong_song_2 .” “. $row_quiz['song'];

?>