if (isset($_POST['send']) && $_POST['send'] == 'send') { $priority = array(); $categories = array(); $subject = validate($_POST['subject'], 'subject'); $priority[0] = isset($_POST['priority1']) ? $_POST['priority1'] : ''; $priority[1] = isset($_POST['priority2']) ? $_POST['priority2'] : ''; $priority[2] = isset($_POST['priority3']) ? $_POST['priority3'] : ''; $fromdate = validate($_POST['fromdate'], 'fromdate'); $todate = validate($_POST['todate'], 'todate'); $message = validate($_POST['message'], 'message'); $customer = validate($_POST['customer'], 'customer'); $cat = $db->query_first('SELECT COUNT(`id`) as `ccount` FROM `' . TABLE_PANEL_TICKET_CATS . '`'); for ($x = 0; $x < $cat['ccount']; $x++) { $categories[$x] = isset($_POST['category' . $x]) ? $_POST['category' . $x] : ''; } $query = ticket::getArchiveSearchStatement($db, $subject, $priority, $fromdate, $todate, $message, $customer, $userinfo['adminid'], $categories); $fields = array('lastchange' => $lng['ticket']['lastchange'], 'ticket_answers' => $lng['ticket']['ticket_answers'], 'subject' => $lng['ticket']['subject'], 'lastreplier' => $lng['ticket']['lastreplier'], 'priority' => $lng['ticket']['priority']); $paging = new paging($userinfo, $db, TABLE_PANEL_TICKETS, $fields, $settings['panel']['paging'], $settings['panel']['natsorting']); $result = $db->query($query . $paging->getSqlWhere(true) . " " . $paging->getSqlOrderBy() . " " . $paging->getSqlLimit()); $sortcode = $paging->getHtmlSortCode($lng); $arrowcode = $paging->getHtmlArrowCode($filename . '?page=' . $page . '&s=' . $s); $searchcode = $paging->getHtmlSearchCode($lng); $pagingcode = $paging->getHtmlPagingCode($filename . '?page=' . $page . '&s=' . $s); $ctickets = array(); while ($row = $db->fetch_array($result)) { if (!isset($ctickets[$row['customerid']]) || !is_array($ctickets[$row['customerid']])) { $ctickets[$row['customerid']] = array(); } $ctickets[$row['customerid']][$row['id']] = $row; } if ($paging->sortfield == 'customerid' && $paging->sortorder == 'desc') {