summaryrefslogtreecommitdiff
path: root/includes/pages/user_questions.php
blob: 04ae891415b7f8d82890511522f16b086452651a (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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php

use Engelsystem\Database\DB;

/**
 * @return string
 */
function questions_title()
{
    return _('Ask the Heaven');
}

/**
 * @return string
 */
function user_questions()
{
    global $user;

    if (!isset($_REQUEST['action'])) {
        $open_questions = DB::select(
            'SELECT * FROM `Questions` WHERE `AID` IS NULL AND `UID`=?',
            [$user['UID']]
        );

        $answered_questions = DB::select(
            'SELECT * FROM `Questions` WHERE NOT `AID` IS NULL AND `UID`=?',
            [$user['UID']]
        );
        foreach ($answered_questions as &$question) {
            $answer_user_source = User($question['AID']);
            $question['answer_user'] = User_Nick_render($answer_user_source);
        }

        return Questions_view($open_questions, $answered_questions, page_link_to('user_questions') . '&action=ask');
    } else {
        switch ($_REQUEST['action']) {
            case 'ask':
                $question = strip_request_item_nl('question');
                if ($question != '') {
                    $result = DB::insert('
                        INSERT INTO `Questions` (`UID`, `Question`)
                        VALUES (?, ?)
                        ',
                        [$user['UID'], $question]
                    );
                    if (!$result) {
                        engelsystem_error(_('Unable to save question.'));
                    }
                    success(_('You question was saved.'));
                    redirect(page_link_to('user_questions'));
                } else {
                    return page_with_title(questions_title(), [
                        error(_('Please enter a question!'), true)
                    ]);
                }
                break;
            case 'delete':
                if (isset($_REQUEST['id']) && preg_match('/^[0-9]{1,11}$/', $_REQUEST['id'])) {
                    $question_id = $_REQUEST['id'];
                } else {
                    return error(_('Incomplete call, missing Question ID.'), true);
                }

                $question = DB::select(
                    'SELECT `UID` FROM `Questions` WHERE `QID`=? LIMIT 1',
                    [$question_id]
                );
                if (count($question) > 0 && $question[0]['UID'] == $user['UID']) {
                    DB::delete(
                        'DELETE FROM `Questions` WHERE `QID`=? LIMIT 1',
                        [$question_id]
                    );
                    redirect(page_link_to('user_questions'));
                } else {
                    return page_with_title(questions_title(), [
                        error(_('No question found.'), true)
                    ]);
                }
                break;
        }
    }

    return '';
}