diff options
Diffstat (limited to 'www/quote.php')
| -rw-r--r-- | www/quote.php | 83 |
1 files changed, 0 insertions, 83 deletions
diff --git a/www/quote.php b/www/quote.php deleted file mode 100644 index 70b1b84..0000000 --- a/www/quote.php +++ /dev/null @@ -1,83 +0,0 @@ -<?php - -/* Copyright Maximilian Möhring, 2013 -Licensed under the GPL. Read LICENSE for more Information.*/ - -function print_quote($db){ - include("static/header.php"); - - if(!empty($_GET["id"])){ - $zufall = $_GET["id"]; - } else { - $zufall = ""; - } - - /*__Datenbank___*/ - $rows = $db->query("SELECT count(*) as count FROM sprueche;"); - $row = $rows->fetchArray(); - $numRows = $row["count"]; - - if ($zufall == ""){ - $zufall = mt_rand(1,$numRows); - } - - - $safe_zufall = SQLite3::escapeString("$zufall"); - $ergebnis = $db->query("SELECT * FROM sprueche where id=$safe_zufall;"); - - echo" - -<div id='content_container' align='center'> - <br> - <div class='kleineschrift'> - <div class='ueberschrift'><p>JUNGE GEMEINDE ADLERSHOF</p></div> - </div> - <div id='container' align='center'> - -<br><br><br> - -<b>Zitat Nummer #$zufall</b><br><br><div id='bgcolor'> - "; - - - if (preg_match('/[0-9]/',$zufall)){ // I really need this hack to get the 404 when /[0-9][a-zA-Z]/ is happening. Bad PHP! - if (preg_match('/[^0-9]/',$zufall)){ - $zufall = 0; - } - } - - - - if ($zufall > 0 && $zufall <= ($numRows)){ - while($row=$ergebnis->fetchArray()){ - echo $row["spruch"]; - } - } else { - echo "\"Sorry, can't find the quote, but a cat is fine too, right?\"<br><br> -<pre> - ,/| _.--''^``-...___.._.,; - /, \'. _-' ,--,,,--''' - { \ `_-'' ' /} - `;;' ; ; ; - ._.--'' ._,,, _..' .;.' - (,_....----''' (,..--'' -</pre><br><br> -<i>404 - Eintrag nicht vorhanden.</i> - "; - } - - echo "</div> - -<br><br><br> - ----------------------------------------------------------------- -<div class='kleineschrift'><p>Es sind momentan <b><i>$numRows</i></b> Zitate in der Datenbank enthalten.</p> -Du suchst ein bestimmtes Zitat? Gib hier dessen Nummer ein: <form method='get' action='/quote' > - <input name='id' type='text' size='2' maxlength='30'> - <input type='submit' style='display:none'/> - - </form> -</div> - -</div></div></div> -"; -} |
