<?php
##################################################################
# Karnaf HelpDesk System - Copyright (C) 2001-2015 Kobi Shmueli. #
# See the LICENSE file for more information. #
##################################################################
require_once "karnaf_header.php";
CheckOperSession();
$id = $_GET['id'];
if (empty($id) || !is_numeric($id)) {
safe_die("Invalid Ticket ID!");
}
show_title("Ticket #" . $id);
make_menus("Karnaf (HelpDesk)");
$query = squery("SELECT t.id,t.randcode,t.status,t.description,t.unick,t.ufullname,t.uemail,t.uphone,t.uip,t.rep_u,\nt.rep_g,t.open_time,t.opened_by,t.is_real,t.is_private,t.email_upd,t.memo_upd,c1.name AS cat1_name,c2.name AS cat2_name,c3.name AS\ncat3_name,s.status_name,up.priority_name AS upriority,sp.priority_name AS priority,g.private_actions,t.merged_to,t.cc,up.priority_id \nAS upriority_id, sp.priority_id,t.ext1,t.ext2,t.ext3,t.title \nFROM (karnaf_tickets AS t INNER JOIN karnaf_cat3 AS c3 ON c3.id=t.cat3_id INNER JOIN karnaf_cat2 AS c2 ON c2.id=c3.parent\nINNER JOIN karnaf_cat1 AS c1 ON c1.id=c2.parent INNER JOIN karnaf_statuses AS s ON s.status_id=t.status INNER JOIN karnaf_priorities AS up ON\nup.priority_id=t.upriority INNER JOIN karnaf_priorities AS sp ON sp.priority_id=t.priority LEFT JOIN groups AS g ON g.name=t.rep_g) WHERE t.id=%d", $id);
if (!($result = sql_fetch_array($query))) {
safe_die("Invalid Ticket ID!");
}
if (!IsGroupMember($result['rep_g']) && !IsKarnafAdminSession()) {
AccessDenied("Ticket is assigned to another team.");
}
$autoload = 1;
if (isset($_GET['reassign'])) {
$autoload = 5;
}
$autostatus = "";
if (isset($_POST['is_private']) && $_POST['is_private'] == "on") {
$is_private = 1;
} else {
$is_private = 0;
}
}
if (isset($_SESSION['userID'])) {
$extra = ", userhits= userhits+1";
}
if ($eingetragen) {
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_browser SET hits=hits+1 WHERE (type = \'browser\' AND variable = \'' . $browser . '\') OR (type = \'os\' AND variable = \'' . $os . '\');');
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_jahr SET hits=hits+1' . @$extra . ' WHERE jahr=' . $nowYear . '');
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_monat SET hits=hits+1' . @$extra . ' WHERE (jahr=' . $nowYear . ') and (monat=' . $nowMonth . ')');
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_tag SET hits=hits+1' . @$extra . ' WHERE (jahr=' . $nowYear . ') and (monat=' . $nowMonth . ') and (tag=' . $nowDate . ')');
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_stunde SET hits=hits+1' . @$extra . ' WHERE (jahr=' . $nowYear . ') and (monat=' . $nowMonth . ') and (tag=' . $nowDate . ') and (stunde=' . $nowHour . ')');
} else {
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_browser SET hits=hits+1, visits=visits+1 WHERE (type = \'browser\' AND variable = \'' . $browser . '\') OR (type = \'os\' AND variable = \'' . $os . '\');');
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_jahr SET hits=hits+1, visits=visits+1' . @$extra . ' WHERE jahr=' . $nowYear . '');
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_monat SET hits=hits+1, visits=visits+1' . @$extra . ' WHERE (jahr=' . $nowYear . ') and (monat=' . $nowMonth . ')');
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_tag SET hits=hits+1, visits=visits+1' . @$extra . ' WHERE (jahr=' . $nowYear . ') and (monat=' . $nowMonth . ') and (tag=' . $nowDate . ')');
$db->query('UPDATE ' . DB_PRE . 'ecp_stats_stunde SET hits=hits+1, visits=visits+1' . @$extra . ' WHERE (jahr=' . $nowYear . ') and (monat=' . $nowMonth . ') and (tag=' . $nowDate . ') and (stunde=' . $nowHour . ')');
}
//------------------------------ Webstats updaten ENDE -------------------------------------------------//
$result = $db->query('SELECT serverID, response FROM ' . DB_PRE . 'ecp_server WHERE aktiv = 1 AND stat = 1 AND ((SELECT datum FROM ' . DB_PRE . 'ecp_server_stats WHERE ' . DB_PRE . 'ecp_server_stats.sID = serverID ORDER BY datum DESC LIMIT 1) < ' . (time() - SERVER_LOG_INTERVALL * 60) . ' OR (SELECT datum FROM ' . DB_PRE . 'ecp_server_stats WHERE ' . DB_PRE . 'ecp_server_stats.sID = serverID ORDER BY datum DESC LIMIT 1) is null)');
if ($db->num_rows()) {
update_server_cache(true);
while ($row = mysql_fetch_assoc($result)) {
$row['response'] = unserialize($row['response']);
if ($db->result(DB_PRE . 'ecp_server_stats', 'COUNT(sID)', 'sID = ' . $row['serverID'] . ' AND datum > ' . (time() - SERVER_LOG_INTERVALL * 60)) == 0) {
$db->query('INSERT INTO ' . DB_PRE . 'ecp_server_stats (`sID`, `datum`, `players`) VALUES (' . $row['serverID'] . ', ' . time() . ', ' . (int) @$row['response']['s']['players'] . ');');
}
}
}
if (!@$ajax and defined('VERSION')) {
make_menus();
}
