aboutsummaryrefslogtreecommitdiff
path: root/quote.php
diff options
context:
space:
mode:
Diffstat (limited to 'quote.php')
-rw-r--r--quote.php79
1 files changed, 0 insertions, 79 deletions
diff --git a/quote.php b/quote.php
deleted file mode 100644
index 8e08a3d..0000000
--- a/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/jg.db");
-$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>";
-
-?>