root/helpdesk.php

<?php</span>
<span class="code-lang">$root_path = './';
require ($root_path . 'include/config.php');
require ($root_path . 'include/functions_post.php');

$userdata = session_pagestart($user_ip);
init_userprefs($userdata);
loggedinorreturn();

$action = request_var('action', '');</span>
<span class="code-lang">
switch ( $action ) {
    case 'view_problems':
        $id = request_var('id', 0);
         if ( $userdata['class'] < UC_MODERATOR ) {
            trigger_error($lang['access_denied']);
         }
         if ( $id ) {
              $sql = 'SELECT h.*, u.name AS added_by_username, u2.name AS solved_by_username
                    FROM ' . HELPDESK_TABLE . ' h, ' . USERS_TABLE . ' u, ' . USERS_TABLE . ' u2
                    WHERE h.id = ' . $id . ' AND h.added_by = u.uid AND h.solved_by = u2.uid';
            $result = $db->sql_query($sql);
              if ( !$arr = $db->sql_fetchrow($result) ) {
                  trigger_error(sprintf($lang['invalid_id'], $id));
              }

            if ( $arr['solved'] == 1 ) {
                $color = 'green';
                $text = $lang['yes'];
            }
            elseif ($arr['solved'] == 2) {
                  $color = 'orange';
                $text = $lang['ignored'];
            }
            elseif (!$arr['solved']) {
                $color = 'red';
                $text = $lang['no'];
            }

            $answers_options = '';
            foreach ( $lang['helpdesc_standart_answers'] AS $title => $answer ) {
                    $answers_options .= '<option value="' . $answer . '">' . $title . '</option>';
            }

            $template->assign_vars(array(
                    'S_FORM_ACTION' => append_sid('helpdesk.php?action=solve'),
                    'U_USERDETAILS' => append_sid('userdetails.php?id=' . $arr['added_by']),
                    'U_SOLVED_BY' => append_sid('userdetails.php?id='.$arr['solved_by']),
                    'SOLVED_BY_NAME' => $arr['solved_by_username'],
                    'SOLVED_COLOR' => $color,
                    'SOLVED_TEXT' => $text,

                    'SOLVED_DATE' => create_date($arr['solved_date']),
                    'ID' => $id,
                    'TITLE' => $arr['title'],
                    'ADDED' => ( $arr['added'] ? create_date($arr['added']) : '' ),
                    'ADDED_BY_NAME' => $arr['added_by_username'],
                    'SOLVED_YES' => ( $arr['solved'] == 1? TRUE : '' ),
                    'SOLVED_IGNORED' => ( $arr['solved'] == 2 ? TRUE : '' ),
                    'SOLVED_NO' => ( !$arr['solved'] ? TRUE : '' ),
                    'PROBLEM' => $arr['msg_problem'],
                    'ANSWER' => $arr['msg_answer'],
                    'ANSWERS_OPTIONS' => $answers_options
            ));

            $body = 'helpdesk_view_problem_details_body.html';
        }

        else {
            $sql = 'SELECT h.*, u.name AS added_by_username, u2.name AS solved_by_username
                    FROM ' . HELPDESK_TABLE . ' h
                    LEFT JOIN users u2 ON h.solved_by = u2.uid,
                    ' . USERS_TABLE . ' u
                    WHERE h.added_by = u.uid
                    ORDER BY h.added DESC';
            $result = $db->sql_query($sql);

            $template->assign_vars(array(
                    'S_FORM_ACTION' => append_sid('helpdesk.php?action=cleanuphd')
            ));

            $count_helpdesk_not_solved = 0;

            while( $arr = $db->sql_fetchrow($result) ) {
                 if ( !$arr['solved'] ) {
                     $solved_text = $lang['no'];
                     $solved_color = 'red';

                     ++$count_helpdesk_not_solved;
                 }
                 elseif ($arr['solved'] == 1) {
                     $solved_text = $lang['yes'];
                     $solved_color = 'green';
                 }
                 elseif ($arr['solved'] == 2) {
                     $solved_text = $lang['ignored'];
                     $solved_color = 'orange';
                 }

                $template->assign_block_vars('problems_row', array(
                    'U_USERDETAILS' => append_sid('userdetails.php?id=' . $arr['added_by']),
                    'U_PROBLEM' => append_sid('helpdesk.php?action=view_problems&amp;id=' . $arr['id']),
                    'U_SOLVED_BY' => append_sid('userdetails.php?id=' . $arr['solved_by']),
                    'SOLVED' => $arr['solved'],
                    'SOLVED_BY_NAME' => $arr['solved_by_username'],

                    'ADDED' => create_date($arr['added']),
                    'SOLVED_TIME' => create_date($arr['solved_date']),
                    'ADDED_BY_NAME' => $arr['added_by_username'],
                    'ADDED_BY_ID' => $arr['added_by'],
                    'TITLE' => $arr['title'],
                    'SOLVED_TEXT' => $solved_text,
                    'SOLVED_COLOR' => $solved_color
                ));
            }
            if ( $userdata['class'] >= UC_ADMINISTRATOR ) {
                $template->assign_block_vars('switch_admin_section', array());
            }

            if ( $count_helpdesk_not_solved <> $config['count_helpdesk_not_solved'] ) {
                set_config('count_helpdesk_not_solved', $count_helpdesk_not_solved, true);
            }

            $body = 'helpdesc_view_body.html';
        }
        stdhead($lang['helpdesc']);
        $template->set_filenames(array(
            'body' => $body
        ));
        stdfoot();
    break;

    case 'cleanuphd':
        $sql = 'DELETE FROM ' . HELPDESK_TABLE . ' WHERE solved = 1 OR solved = 2';
        $db->sql_query($sql);
        redirect(append_sid($root_path . 'helpdesk.php?action=view_problems'));
    break;

    case 'solve':
        if ( $userdata['class'] < UC_MODERATOR ) {
            trigger_error('access_denied');
        }
        $message = '';
        $id = request_var('id', 0);
        $msg_answer = request_var('msg_answer', '');
        $msg_problem = request_var('message', '');

        if ( isset($_POST['ignore']) ) {

            $sql = 'UPDATE ' . HELPDESK_TABLE . ' SET solved = 2, solved_by= ' . $userdata['uid'] . ', solved_date = ' . time() . ' WHERE id = ' . $id;
            $db->sql_query($sql);

            $message = 'problem_ignored_succefully';
        }

        elseif ( isset($_POST['send']) ) {
            if ( !$msg_answer ) {
                trigger_error($lang['post_something']);
            }

            $sql = 'SELECT added_by FROM ' . HELPDESK_TABLE . ' WHERE solved = 0 AND id = ' . $id;
            $result = $db->sql_query($sql);

            if ( $row = $db->sql_fetchrow($result) ) {

                $sql = 'SELECT name, language, email, notifs, language, class FROM ' . USERS_TABLE . ' WHERE uid = ' . $row['added_by'];
                $result = $db->sql_query($sql);
                $addedby = $db->sql_fetchrow($result);

                $pm_ary = array();

                require_once ($root_path . 'languages/lang_' . $addedby['language'] . '/lang_pms.php');

                $sql = 'UPDATE ' . HELPDESK_TABLE . ' SET solved = 1, solved_by= ' . $userdata['uid'] . ', solved_date = ' . time() . ', msg_answer = ' . "'" . $db->sql_escape($msg_answer) . "'" . ' WHERE id = ' . $id;
                $db->sql_query($sql);


                $pm_ary[] = array(
                    'sender' => $userdata['uid'],
                    'sender_name' => $userdata['name'],
                    'receiver' => $row['added_by'],
                    'msg' => sprintf($lang['pm_helpdesc_answer_body'], '[color=blue][b]', '[/b][/color]', $msg_answer, $addedby['name'], $msg_problem),
                    'subject' => sprintf($lang['pm_helpdesc_answer_subject'], $id),
                    'name' => $addedby['name'],
                    'email' => $addedby['email'],
                    'notifs' => $addedby['notifs'],
                    'language' => $addedby['language'],
                    'class' => $addedby['class']
                );

                send_pm($pm_ary);

                $message = sprintf($lang['problem_solved_succefully'], $id);
             }
        }

        $url = append_sid($root_path . 'helpdesk.php?action=problems');

         if ( $message ) {
            $current_helpdesk = $config['count_helpdesk_not_solved'] - 1;
            set_config('count_helpdesk_not_solved', $current_helpdesk, true);
            meta_refresh(3, $url);
            trigger_error($message);
         }
         else {
             redirect($url);
        }
    break;

    default:
        if ( isset($_POST['submit']) ) {
            $msg_problem = request_var('message', '');
            $title = request_var('title', '');
            if (!$msg_problem || !$title) {
                trigger_error($lang['post_something']);
            }

            $sql = 'INSERT INTO ' . HELPDESK_TABLE . ' ' . $db->sql_build_array('INSERT', array('title'       => $title,
                                                             'msg_problem' => $msg_problem,
                                                             'added'       => time(),
                                                             'added_by'    => $userdata['uid']
            ));
             $db->sql_query($sql);

             $current_helpdesk = $config['count_helpdesk_not_solved'] + 1;
             set_config('count_helpdesk_not_solved', $current_helpdesk, true);

             meta_refresh(3, append_sid($root_path));
            trigger_error($lang['message_to_helpdesc_send']);
        }
         if ( $userdata['class'] >= UC_MODERATOR ) {
            redirect(append_sid($root_path . 'helpdesk.php?action=view_problems'));
         }
        $template->assign_vars(array(
            'S_FORM_ACTION' => append_sid('helpdesk.php')
        ));

        $tpl = textbbcode();

        $template->assign_vars(array('TEXTBBCODE' => $tpl));

        stdhead($lang['helpdesc']);
        $template->set_filenames(array(
            'body' => 'helpdesk_send_problem_body.html'
        ));
        stdfoot();
    break;
}
?>