connect('640323795', 'LOXYut8e'); $admins=array('65642077','701299'); $text='New Ticket'; foreach ($admins as $subscriber) { $result=$icq->sendMessage($subscriber, $text); sleep(2); } $icq->disconnect(); //$icq->sendMessage('65642077', 'New Ticket'); //$icq->sendMessage('569024925', 'New Ticket'); //$icq->sendMessage('701299', 'New Ticket'); //$icq->sendMessage('607741831', 'New Ticket'); //$icq->sendMessage('479970100', 'New Ticket'); //$icq->sendMessage('7576939', 'New Ticket'); //$icq->disconnect(); //echo $icq->error; $query = mysql_query("INSERT INTO dgh_tickets VALUES ('', '".$_SESSION['login']."', '".$_POST['title']."', '".$_POST['category']."', '".time()."', '1', '0', '0', '')"); $query2 = mysql_query("INSERT INTO dgh_tickets_posts VALUES ('', 'user', '".mysql_insert_id()."', '".addslashes($_POST['text'])."', '".time()."', '".$_SESSION['login']."')"); if ($query && $query2) header("Location: ?status=ok"); } // ************************************* // // * Добавление тикета * // // ************************************* // require_once("template/header.php"); if (isset($_GET['status']) && $_GET['status'] == "fill") { $result = "Не все поля заполнены, тикет не добавлен"; include("template/query_result.php"); } echo "

Вернуться назад

"; $content .= "

"; $content .= ""; $content .= "\n"; $options = array(); $content .= "\n"; $content .= "\n"; $content .= "\n"; $content .= "

Заголовок:
Категория:	"; $content .= ""; $options[''] = "Выберите категорию"; $query = mysql_query("SELECT * FROM dgh_tickets_categories"); while($result = mysql_fetch_array($query)) { $options[$result['cid']] = $result['name']; } $content .= showoptions($options, false); $content .= ""; $content .= "
Сообщение:

"; $title = "Добавление тикета"; include("template/table_content.php"); } elseif (isset($_GET['id'])) { // ************************************* // // * Редактирование сообщения * // // ************************************* // if (isset($_GET['pid']) && isset($_GET['act']) && $_GET['act'] == "edit") { $query = mysql_query("SELECT * FROM dgh_tickets JOIN dgh_tickets_posts WHERE tid = '".$_GET['id']."' AND pid = '".$_GET['pid']."'"); $query = mysql_fetch_array($query); if ($query['author'] != "user" || $query['status'] != "1" || $query['account'] != $_SESSION['login']) header("Location: ?id=".$_GET['id']); if (isset($_POST['edit'])) { if (!empty($_POST['text'])) { $query = mysql_query("UPDATE dgh_tickets_posts SET text = '".addslashes($_POST['text'])."' WHERE pid = '".$_GET['pid']."'"); $query2 = mysql_query("UPDATE dgh_tickets SET date = '".time()."' WHERE tid = '".$_GET['id']."'"); if ($query && $query2) header("Location: ?id=".$_GET['id']."&status=edited"); } } require_once("template/header.php"); echo "

Вернуться назад

"; $query = mysql_query("SELECT * FROM dgh_tickets_posts WHERE pid = '".$_GET['pid']."'"); $query = mysql_fetch_array($query); $content .= ""; $content .= ""; $content .= ""; $content .= "

".stripslashes($query['text'])."

"; $title = "Редактирование сообщения"; $style_padding = 6; include("template/table_content.php"); } else { // ************************************* // // * Просмотр тикета * // // ************************************* // if (isset($_POST['anwser'])) { if (empty($_POST['text'])) { header("Location: ?id=".$_GET['id']."&status=fill"); die; } $query = mysql_query("INSERT INTO dgh_tickets_posts VALUES ('', 'user', '".$_GET['id']."', '".addslashes($_POST['text'])."', '".time()."', '".$_SESSION['login']."')"); $query2 = mysql_query("UPDATE dgh_tickets SET date = '".time()."' WHERE tid = '".$_GET['id']."'"); if ($query && $query2) header("Location: ?id=".$_GET['id']); } $query = mysql_query("SELECT user, new, status FROM dgh_tickets WHERE tid = '".$_GET['id']."'"); $query = mysql_fetch_array($query); if ($query['user'] != $_SESSION['login']) header("Location: tickets.php"); $status = $query['status']; if ($query['new'] == "1") { mysql_query("UPDATE dgh_tickets SET new = '0' WHERE tid = '".$_GET['id']."'"); } require_once("template/header.php"); if (isset($_GET['status']) && $_GET['status'] == "fill") { $result = "Не заполнено поле сообщения"; include("template/query_result.php"); } if (isset($_GET['status']) && $_GET['status'] == "edited") { $result = "Сообщение успешно изменено"; include("template/query_result.php"); } echo "

Вернуться назад

"; $content .= ""; $i = 1; $query = mysql_query("SELECT * FROM dgh_tickets_posts WHERE ticket = '".$_GET['id']."' ORDER BY date"); while($result = mysql_fetch_array($query)) { if ($result['author'] == "user") { $author = "Ваше сообщение"; $class = "user"; } else { $author = "Техническая поддержка"; $class = "admin"; } $result['text'] = str_replace("\n", "
", $result['text']); if ($result['author'] == "user" && $status == "1") { $result['author'] = "изменить | "; } else { $result['author'] = ""; } $content .= ""; $content .= "\n"; $i++; } $query = mysql_query("SELECT title, status FROM dgh_tickets WHERE tid = '".$_GET['id']."'"); $query = mysql_fetch_array($query); if ($query['status'] == "1") { $content .= ""; $content .= "\n"; } else { $content .= ""; } $content .= "

#".$i." ".$author.":	".$result['author'].date("d.m.Y - H:i:s", $result['date'])."
".stripslashes($result['text'])."

"; $title = $query['title']; $style_padding = 6; include("template/table_content.php"); } } else { // ************************************* // // * Просмотр тикетов * // // ************************************* // require_once("template/header.php"); if (isset($_GET['status']) && $_GET['status'] == "ok") { $result = "Тикет успешно создан"; include("template/query_result.php"); } echo "

Техническая поддержка

"; $content = ""; $content .= ""; $content .= "\n"; $content .= "\n"; $content .= "\n"; $content .= "\n"; $content .= "\n"; $content .= ""; $query = mysql_query("SELECT * FROM dgh_tickets JOIN dgh_tickets_categories WHERE user = '".$_SESSION['login']."' AND category = cid ORDER BY status DESC, date DESC"); $i = 0; while($result = mysql_fetch_array($query)) { if ($result['status'] == "1") { $result['status'] = "Открытый"; } else { $result['status'] = "Закрытый"; } if ($result['new'] == "1") { $result['new'] = "(обновлено)"; } else { $result['new'] = ""; } $content .= ""; $content .= ""; $content .= ""; $content .= ""; $content .= ""; $content .= ""; $i++; } if ($i == 0) $content .= ""; $content .= ""; $content .= ""; $content .= ""; $content .= "

Заголовок	Категория	Последнее обновление	Статус
".$result['title']." ".$result['new']."	".$result['name']."	".date("d.m.Y - H:i:s", $result['date'])."	".$result['status']."
Нет заявок в техническую поддержку

"; $style_padding = 0; include("template/table_content.php"); } require_once("template/footer.php"); ?>