summaryrefslogtreecommitdiff
path: root/includes/pages/user_questions.php
blob: d23b4e96db83d7908f5c831816e8e39ee079b80f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<?php
function user_questions() {
  global $user;

  if (!isset ($_REQUEST['action'])) {
    $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>' . str_replace("\n", '<br />', $question['Question']) . '</td><td><a href="' . page_link_to("user_questions") . '&action=delete&id=' . $question['QID'] . '">Löschen</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'] . '">Löschen</a></td><tr>';
    }

    return template_render('../templates/user_questions.html', array (
      'link' => page_link_to("user_questions"),
      'open_questions' => $open_questions,
      'answered_questions' => $answered_questions
    ));
  } else {
    switch ($_REQUEST['action']) {
      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) . "'");
          header("Location: " . page_link_to("user_questions"));
        } else
          return error("Gib eine Frage ein!", true);
        break;
      case 'delete' :
        if (isset ($_REQUEST['id']) && preg_match("/^[0-9]{1,11}$/", $_REQUEST['id']))
          $id = $_REQUEST['id'];
        else
          return error("Incomplete call, missing Question ID.", true);

        $question = sql_select("SELECT * FROM `Questions` WHERE `QID`=" . sql_escape($id) . " LIMIT 1");
        if (count($question) > 0 && $question[0]['UID'] == $user['UID']) {
          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.", true);
        break;
    }
  }
}
?>