diff options
Diffstat (limited to 'oldwww/quote.php')
| -rw-r--r-- | oldwww/quote.php | 79 |
1 files changed, 0 insertions, 79 deletions
diff --git a/oldwww/quote.php b/oldwww/quote.php deleted file mode 100644 index b0bc136..0000000 --- a/oldwww/quote.php +++ /dev/null @@ -1,79 +0,0 @@ -<?php - -/* Copyright Maximilian Möhring, 2013 -Licensed under the GPL. Read LICENSE for more Information.*/ - -include('auth.php'); -include("header.php"); - -$zufall = $_GET["id"]; - -/*__Datenbank___*/ -$db = new SQLite3("../database/database.sqlite"); -$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.php' > - <input name='id' type='text' size='2' maxlength='30'> - <input type='submit' style='display:none'/> - - </form> -</div> - -</div></div></div> -</body></html>"; - -?> |
