diff options
Diffstat (limited to 'includes/pages/user_questions.php')
| -rw-r--r-- | includes/pages/user_questions.php | 17 |
1 files changed, 12 insertions, 5 deletions
diff --git a/includes/pages/user_questions.php b/includes/pages/user_questions.php index 0ed1339c..be7f9930 100644 --- a/includes/pages/user_questions.php +++ b/includes/pages/user_questions.php @@ -7,9 +7,9 @@ function user_questions() { global $user; if (! isset($_REQUEST['action'])) { - $open_questions = sql_select("SELECT * FROM `Questions` WHERE `AID`=0 AND `UID`=" . sql_escape($user['UID'])); + $open_questions = sql_select("SELECT * FROM `Questions` WHERE `AID` IS NULL AND `UID`=" . sql_escape($user['UID'])); - $answered_questions = sql_select("SELECT * FROM `Questions` WHERE `AID`>0 AND `UID`=" . sql_escape($user['UID'])); + $answered_questions = sql_select("SELECT * FROM `Questions` WHERE NOT `AID` IS NULL AND `UID`=" . sql_escape($user['UID'])); foreach ($answered_questions as &$question) { $answer_user_source = User($question['AID']); if ($answer_user_source === false) @@ -23,10 +23,15 @@ function user_questions() { case 'ask': $question = strip_request_item_nl('question'); if ($question != "") { - sql_query("INSERT INTO `Questions` SET `UID`=" . sql_escape($user['UID']) . ", `Question`='" . sql_escape($question) . "'"); + $result = sql_query("INSERT INTO `Questions` SET `UID`=" . sql_escape($user['UID']) . ", `Question`='" . sql_escape($question) . "'"); + if ($result === false) + engelsystem_error(_("Unable to save question.")); + success(_("You question was saved.")); redirect(page_link_to("user_questions")); } else - return error(_("Please enter a question!"), true); + return page_with_title(questions_title(), array( + error(_("Please enter a question!"), true) + )); break; case 'delete': if (isset($_REQUEST['id']) && preg_match("/^[0-9]{1,11}$/", $_REQUEST['id'])) @@ -39,7 +44,9 @@ function user_questions() { sql_query("DELETE FROM `Questions` WHERE `QID`=" . sql_escape($id) . " LIMIT 1"); redirect(page_link_to("user_questions")); } else - return error(_("No question found."), true); + return page_with_title(questions_title(), array( + error(_("No question found."), true) + )); break; } } |