$message .= "Message:\n"; $message .= stripslashes($_POST['message']) . "\n"; $message .= "----------------------------------------------------------------------\n"; ?> <table width="<?php echo $maintablewidth; ?> " cellspacing="1" cellpadding="1" class="boxborder" align="<?php echo $maintablealign; ?> "> <tr> <td class="text"><?php echo supportSendMail($_POST['email'], $_POST['name'], 'Support Ticket Written By - ' . $_POST['account'], $message); if ($emailuser == 'TRUE') { echo supportSendMail($_POST['email'], $_POST['name'], 'Support Ticket Written By - ' . $_POST['account'], $message, '1'); } ?> </td> </tr> </table> <?php $refresh = 'TRUE'; } } } // SELECT THE DIFFERENT FROM LOCATIONS ON WHETHER THE ACCOUNT IS CHOSEN if (!isset($_POST['account'])) { ?> <form action="<?php echo $_SERVER['PHP_SELF'];
$message .= $socketfromname; ?> <table width="<?php echo $maintablewidth; ?> " cellspacing="1" cellpadding="1" class="boxborder" align="<?php echo $maintablealign; ?> "> <tr> <td class="text"> <?php if (0) { echo supportSendMail($_POST['email'], $_POST['name'], 'Response To Ticket ' . $_GET['ticketid'] . ' Written By - ' . $_SESSION['stu_username'], $message); if ($emailuser == 'TRUE') { echo supportSendMail($_POST['email'], $_POST['name'], 'Response To Ticket ' . $_GET['ticketid'] . ' Written By - ' . $_SESSION['stu_username'], $message, '1'); } } ?> </td> </tr> </table> <?php $refresh = 'TRUE'; } } } // QUERY TO GET THE TICKET IN QUESTION AND ANY REPLIES TO THAT TICKET $query = "\tSELECT td_transactionId,tickets_id, tickets_subject, tickets_timestamp, tickets_status, tickets_name, tickets_email, tickets_admin, tickets_child, tickets_question, tickets_status_id, tickets_status_name, tickets_status_color, c.*\n\t\t\t\t\tFROM tickets_tickets a, tickets_status b, tickets_categories c\n\t\t\t\t\tWHERE (a.tickets_id = '" . intval($_GET['ticketid']) . "'\n\t\t\t\t\tOR tickets_child = '" . intval($_GET['ticketid']) . "')\n\t\t\t\t\tAND a.tickets_urgency = b.tickets_status_id\n\t\t\t\t\tAND a.tickets_category = c.tickets_categories_id\n\t\t\t\t\tAND (tickets_username = '******'stu_username'] . "'\n\t\t\t\t\tOR tickets_admin = 'Admin')\n\t\t\t\t\tORDER BY tickets_id ASC"; $result = mysql_query($query); $totaltickets = mysql_num_rows($result);