1 files changed, 74 insertions, 0 deletions
diff --git a/quote.php b/quote.php
new file mode 100644
index 0000000..022d2ff
--- /dev/null
+++ b/quote.php
@@ -0,0 +1,74 @@
+<?php include('auth.php');
+include("header.php");
+
+$zufall = $_GET["id"];
+
+/*__Datenbank___*/
+$db = new SQLite3("/var/www/jungegemeinde/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>";
+
+?>