$ticid = $_REQUEST['tic_id']; $thread_type = "R"; $poster = $current_user->user_login; $source = "Web"; $admin_response = @Format::stripslashes($_REQUEST['message']); ///from post to thread-table to variable to email $ipaddress = $_SERVER['REMOTE_ADDR']; $date = date("Y-m-d g:i:s"); ///EST (todo's - add option to WP osT-Settings) $ost_wpdb->insert($thread_table, array('pid' => $pid, 'ticket_id' => $ticid, 'staff_id' => $staffid, 'thread_type' => $thread_type, 'poster' => $poster, 'source' => $source, 'title' => "", 'body' => key4ce_wpetss_forum_text($admin_response), 'ip_address' => $ipaddress, 'created' => $date), array('%d', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s')); $thread_id = $ost_wpdb->insert_id; // File Table Entry Code Start Here By Pratik Maniar on 02/08/2014 if (!empty($_FILES['file']['name'][0])) { $fileids = array(); for ($i = 0; $i < count($_FILES['file']['name']); $i++) { $fullfinalpath = key4ce_getKeyValue('uploadpath'); $key4ce_generateHashKey = key4ce_generateHashKey(33); $key4ce_generateHashSignature = key4ce_generateHashSignature(33); $dir_name = substr($key4ce_generateHashKey, 0, 1); $structure = $fullfinalpath . "/" . $dir_name; if (!is_dir($structure)) { mkdir($structure, 0355); } $alowaray = explode(".", str_replace(' ', '', $fileextesnions)); $strplc = str_replace(".", "", str_replace(' ', '', $fileextesnions)); $allowedExts = explode(",", $strplc); $allowextscnt = count($allowedExts); $temp = explode(".", $_FILES['file']['name'][$i]); $extension = end($temp); //return uploaded file extension $newfilename = $key4ce_generateHashKey;
?> "/> <input type="hidden" name="type" value="<?php echo $filedetails->type; ?> "/> <input type="hidden" name="name" value="<?php echo $filedetails->name; ?> "/> <input type="hidden" name="h" value="<?php echo session_id(); ?> "/> <input type="hidden" name="filepath" value="<?php echo key4ce_getKeyValue('uploadpath'); ?> "/> <span class="key4ce_Icon key4ce_attachment"></span><input type="submit" name="download" value="<?php echo $filedetails->name; ?> "> </form> <?php } } ?> </td> </tr> </tbody> </table>
<?php /* Template Name: new_ticket.php */ if ($keyost_version == 193) { $attachement_status = key4ce_getKeyValue('allow_attachments'); $max_user_file_uploads = key4ce_getKeyValue('max_user_file_uploads'); $max_file_size = key4ce_getKeyValue('max_file_size'); $fileextesnions = key4ce_getKeyValue('allowed_filetypes'); } else { $fileconfig = key4ce_FileConfigValue(); $filedata = json_decode($fileconfig); $attachement_status = $filedata->attachments; $max_user_file_uploads = $filedata->max; $max_file_size = $filedata->size; $fileextesnions = $filedata->extensions; } $alowaray = explode(".", str_replace(' ', '', $fileextesnions)); $strplc = str_replace(".", "", str_replace(' ', '', $fileextesnions)); $allowedExts = explode(",", $strplc); function add_quotes($str) { return sprintf("'%s'", $str); } $extimp = implode(',', array_map('add_quotes', $allowedExts)); $finalary = "'" . $extimp . "'"; ?> <script language="javascript" src="<?php echo plugin_dir_url(__FILE__) . '../js/jquery_1_7_2.js'; ?> "></script> <script type="text/javascript">
<?php if ($keyost_usercloseticket == 0) { ?> <style> #key4ce_ticket_menu1{width: 8.5% !important;}#key4ce_ticket_list1{width: 8.5% !important;}#key4ce_ticket_menu2{width: 47% !important;}#key4ce_ticket_list2{width: 47% !important;}#key4ce_ticket_menu4{width:11% !important;} #key4ce_ticket_list4{width:11% !important;} #key4ce_ticket_menu5{width:11% !important;} #key4ce_ticket_list5{width:11% !important;} #key4ce_ticket_menu6{width:250px !important;} #key4ce_ticket_list6{width:250px !important;} </style> <?php } $time_format = key4ce_getKeyValue('time_format'); $date_format = key4ce_getKeyValue('date_format'); $datetime_format = key4ce_getKeyValue('datetime_format'); if (isset($_POST['close'])) { $close_ticket_list = $_POST['tickets']; $i = 0; foreach ($close_ticket_list as $close_ticket) { if ($keyost_version == 194 || $keyost_version == 195 || $keyost_version == 1951) { $ost_wpdb->update($ticket_table, array('status_id' => '3'), array('ticket_id' => $close_ticket), array('%s')); } else { $ost_wpdb->update($ticket_table, array('status' => 'closed'), array('ticket_id' => $close_ticket), array('%s')); } $i++; } echo "<div style=' color: red;font-size: 15px;font-weight: bold;margin-top: 20px;text-align: center;'>" . _e("{$i} record(s) has been closed successfully", 'key4ce-osticket-bridge') . "</div>"; echo "<script>window.location.href=location.href;</script>"; } if (@$list_opt) {
$adminmessage .= "Subject: " . $sub . "<br />"; $adminmessage .= "<br />----------------------<br />"; $adminmessage .= "Message: " . $user_message . ""; $adminmessage .= "<br />----------------------<br /><br />"; $adminmessage .= "To respond to the ticket, please login to the support ticket system."; $adminmessage .= "<br /><br />"; $adminmessage .= "" . site_url() . ""; $adminmessage .= "<br />"; $adminmessage .= "Your friendly Customer Support System "; $headers = 'From: ' . $title . ' <' . $adem . ">\r\n"; add_filter('wp_mail_content_type', create_function('', 'return "text/html"; ')); wp_mail($os_admin_email_admin, $subject, key4ce_wpetss_forum_text('<div style="display: none;">-- do not reply below this line -- <br/><br/></div>' . $adminmessage), $headers); } //Email Notification to Department Of Staff Added by Pratik Maniar on 28-04-2014 Start Here ///Email osticket Department - a new ticket has been created if (key4ce_getKeyValue('ticket_alert_dept_members') == 1 && key4ce_getKeyValue('ticket_alert_active') == 1) { $staff_details = $ost_wpdb->get_results("SELECT email,firstname,lastname FROM {$ost_staff} WHERE `dept_id` ={$dep_id}"); $department_staff = count($staff_details); if ($department_staff > 0) { foreach ($staff_details as $staff) { $staff_firstname = $staff->firstname; $staff_lastname = $staff->lastname; $staff_email = $staff->email; $subject = $sub; $deptmessage = "Hello {$staff_firstname} {$staff_lastname},<br />A new ticket has been created.<br /><br />"; $deptmessage .= "Ticket ID #" . $ticketid . ""; $deptmessage .= "<br />----------------------<br />"; $deptmessage .= "Name: " . $username . "<br />"; $deptmessage .= "Email: " . $usermail . "<br />"; $deptmessage .= "Priority: " . $priordesc . "<br />"; $deptmessage .= "Department: " . $dept_name . "<br />";
require_once WP_PLUGIN_DIR . '/key4ce-osticket-bridge/admin/db-settings.php'; require_once WP_PLUGIN_DIR . '/key4ce-osticket-bridge/includes/functions.php'; $dept_opt = $ost_wpdb->get_results("SELECT dept_name,dept_id FROM {$dept_table} where ispublic=1"); wp_enqueue_script('ost-bridge-validate', plugins_url('../js/validate.js', __FILE__)); // Start File system changes $fileconfig = key4ce_FileConfigValue(); $filedata = json_decode($fileconfig); if ($keyost_version == 193) { $attachement_status = key4ce_getKeyValue('allow_attachments'); $max_user_file_uploads = key4ce_getKeyValue('max_user_file_uploads'); $agent_max_file_size = key4ce_getKeyValue('max_staff_file_uploads'); $fileextesnions = key4ce_getKeyValue('allowed_filetypes'); } else { $attachement_status = $filedata->attachments; $max_user_file_uploads = $filedata->max; $agent_max_file_size = key4ce_getKeyValue('max_file_size'); $fileextesnions = $filedata->extensions; } // End file system changes $alowaray = explode(".", str_replace(' ', '', $fileextesnions)); $strplc = str_replace(".", "", str_replace(' ', '', $fileextesnions)); $allowedExts = explode(",", $strplc); function add_quotes($str) { return sprintf("'%s'", $str); } $extimp = implode(',', array_map('add_quotes', $allowedExts)); $finalary = "'" . $extimp . "'"; $args = array('blog_id' => $GLOBALS['blog_id'], 'role' => '', 'meta_key' => '', 'meta_value' => '', 'meta_compare' => '', 'meta_query' => array(), 'include' => array(), 'exclude' => array(), 'orderby' => 'login', 'order' => 'ASC', 'offset' => '', 'search' => '', 'number' => '', 'count_total' => false, 'fields' => 'all', 'who' => ''); global $wpdb; $WPusersData = $wpdb->get_results("SELECT user_nicename,user_email FROM " . $wpdb->prefix . "users", ARRAY_A);
<?php if ($attachement_status == 1 || $attachement_status == true) { if (key4ce_getPluginValue('Attachments on the filesystem') == 1) { ?> <tr><td> <div id="addinput"> <p> <span style="color:#000;"><?php echo __("Attachment 1:", 'key4ce-osticket-bridge'); ?> </span> <input type="file" id="p_new" name="file[]" onchange="return checkFile(this);"/> <a href="#" id="addNew"><?php echo __("Add", 'key4ce-osticket-bridge'); ?> </a> <span style="color: red;font-size: 11px;"><?php echo __("Max file upload size :", 'key4ce-osticket-bridge'); echo key4ce_getKeyValue('max_file_size') * 0.0009765625 * 0.0009765625; ?> MB</span> </p> </div> </td></tr> <?php } else { ?> <tr><td><?php echo __("Attachments on the Filesystem plugin can be downloaded here:", 'key4ce-osticket-bridge'); ?> <a href="http://osticket.com/download/go?dl=plugin%2Fstorage-fs.phar" title="Attachement Filesystem Plugin" target="_blank"><?php echo __("Attachement Filesystem Plugin", 'key4ce-osticket-bridge'); ?> </a></td></tr>