From 32b3ce5f900cf0d378f77a6675b989ee0e641f13 Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Fri, 3 Jun 2011 00:22:11 +0200
Subject: admin questions

---
 includes/pages/user_questions.php | 17 +++++++++++++----
 1 file changed, 13 insertions(+), 4 deletions(-)

(limited to 'includes/pages/user_questions.php')

diff --git a/includes/pages/user_questions.php b/includes/pages/user_questions.php
index 8201c6d6..4e9daa5a 100644
--- a/includes/pages/user_questions.php
+++ b/includes/pages/user_questions.php
@@ -6,11 +6,20 @@ function user_questions() {
 		$open_questions = "";
 		$questions = sql_select("SELECT * FROM `Questions` WHERE `AID`=0 AND `UID`=" . sql_escape($user['UID']));
 		foreach ($questions as $question)
-			$open_questions .= '<tr><td>' . $question['Question'] . '</td><td><a href="' . page_link_to("user_questions") . '&action=delete&id=' . $question['QID'] . '">Delete</a></td><tr>';
+			$open_questions .= '<tr><td>' . str_replace("\n", '<br />', $question['Question']) . '</td><td><a href="' . page_link_to("user_questions") . '&action=delete&id=' . $question['QID'] . '">Delete</a></td><tr>';
+
+		$answered_questions = "";
+		$questions = sql_select("SELECT * FROM `Questions` WHERE `AID`>0 AND `UID`=" . sql_escape($user['UID']));
+		foreach ($questions as $question) {
+			$answered_questions .= '<tr><td>' . str_replace("\n", '<br />', $question['Question']) . '</td>';
+			$answered_questions .= '<td>' . UID2Nick($question['AID']) . '</td><td>' . str_replace("\n", '<br />', $question['Answer']) . '</td>';
+			$answered_questions .= '<td><a href="' . page_link_to("user_questions") . '&action=delete&id=' . $question['QID'] . '">Delete</a></td><tr>';
+		}
 
 		return template_render('../templates/user_questions.html', array (
 			'link' => page_link_to("user_questions"),
-			'open_questions' => $open_questions
+			'open_questions' => $open_questions,
+			'answered_questions' => $answered_questions
 		));
 	} else {
 		switch ($_REQUEST['action']) {
@@ -20,7 +29,7 @@ function user_questions() {
 					sql_query("INSERT INTO `Questions` SET `UID`=" . sql_escape($user['UID']) . ", `Question`='" . sql_escape($question) . "'");
 					header("Location: " . page_link_to("user_questions"));
 				} else
-					return error("Please enter a Question!");
+					return error("Please enter a question!");
 				break;
 			case 'delete' :
 				if (isset ($_REQUEST['id']) && preg_match("/^[0-9]{1,11}$/", $_REQUEST['id']))
@@ -33,7 +42,7 @@ function user_questions() {
 					sql_query("DELETE FROM `Questions` WHERE `QID`=" . sql_escape($id) . " LIMIT 1");
 					header("Location: " . page_link_to("user_questions"));
 				} else
-					return error("No Question found.");
+					return error("No question found.");
 				break;
 		}
 	}
-- 
cgit v1.2.3-70-g09d2