added getContent to StorageEngine

1 files changed, 33 insertions, 3 deletions

diff --git a/paste/include/storage/MysqlStorage.php b/paste/include/storage/MysqlStorage.php
index f33db64..fa8a9de 100644
--- a/paste/include/storage/MysqlStorage.php
+++ b/paste/include/storage/MysqlStorage.php
@@ -79,9 +79,11 @@ INDEX (nick)
 	{
 		$name = sha1(date('r') . rand(1000, getrandmax()));
 		if ($stmt = $this->mysql->prepare(
-			    'INSERT INTO ' . $this->table . '  (pid, nick, language, content, description, remote) VALUES (?, ?, ?, ?, ?, ?)')) {
-
-			/* bind parameters for markers */
+			    'INSERT INTO ' . $this->table . '
+                             (pid, nick, language, content,
+                             description, remote) VALUES
+                             (?, ?, ?, ?, ?, ?)'))
+		{
 			$stmt->bind_param('ssssss', $name, $nick, $language, $content, $description, $_SERVER["REMOTE_ADDR"]);
 
 			/* execute query */
@@ -94,6 +96,34 @@ INDEX (nick)
 			$stmt->close();
 		}
 	}
+
+	public function getContent($pid)
+	{
+		if ($stmt = $this->mysql->prepare(
+			    'SELECT nick, language, content, description, time FROM ' . $this->table . '
+                             WHERE pid = ? LIMIT 1'))
+		{
+			$stmt->bind_param('s', $pid);
+
+			/* execute query */
+			if (!$stmt->execute()) {
+				header('HTTP/1.0 503 Service Unavailable');
+				die('MySQL Error (' . $this->mysql->errno . ') ' .
+				    $this->mysql->error);
+			}
+
+			$stmt->bind_result($nick, $lang, $content, $description, $time);
+
+			if (!$stmt->fetch()) {
+				header('HTTP/1.0 404 Not Found');
+				die('No such paste');
+			}
+
+			echo PastifyText($content, $lang, $description);
+
+			$shmt->close();
+		}
+	}
 }
 
 ?>