<?php# Helpdesk software Hesk# Version: 0.93b from July 5, 2005# File name: submit_ticket.php# File last modified: July 5, 2005# Written 23rd April 2005 by Klemen Stirn (info@phpjunkyard.com)# http://www.PHPJunkYard.com############################################################################### COPYRIGHT NOTICE ## Copyright 2005 PHPJunkYard All Rights Reserved. ## ## The Hesk may be used and modified free of charge by anyone AS LONG AS ## THIS COPYRIGHT NOTICE AND ALL THE COMMENTS REMAIN INTACT. By using this ## code you agree to indemnify Klemen Stirn from any liability that might ## arise from it's use. ## ## Selling the code for this program or any portion of it without prior ## written consent is expressly forbidden. ## ## Obtain permission before redistributing this software over the Internet or ## in any other medium. In all cases copyright and header must remain intact. ## This Copyright is in full effect in any country that has International ## Trade Agreements with the United States of America or with ## the European Union. ############################################################################################################# DO NOT EDIT BELOW ##############################define('IN_SCRIPT',1);/* Get all the required files and functions */require_once('hesk_settings.inc.php');require_once('language/'.$hesk_settings['language'].'.inc.php');require_once('inc/common.inc.php');/* Print header */require_once('inc/header.inc.php');$name=hesk_input($_POST['name'],$hesklang['enter_your_name']);$email=hesk_validateEmail($_POST['email'],$hesklang['enter_valid_email']);$category=hesk_input($_POST['category'],$hesklang['sel_app_cat']);$priority=hesk_input($_POST['priority'],$hesklang['sel_app_priority']);$subject=hesk_input($_POST['subject'],$hesklang['enter_ticket_subject']);$message=hesk_input($_POST['message'],$hesklang['enter_message']);$message=hesk_makeURL($message);$message=nl2br($message);/* Generate tracking ID */$trackingID='';for ($i=1;$i<=10;$i++) {$tmp = substr('AEUYBDGHJLMNPQRSTVWXZ12345678', rand(1,29), 1);$trackingID .= $tmp;}$trackingURL=$hesk_settings['hesk_url'].'/ticket.php?track='.$trackingID;/* Add to database */require_once('inc/database.inc.php');hesk_dbConnect() or hesk_error("$hesklang[cant_connect_db] $hesklang[contact_webmsater] $hesk_settings[webmaster_mail]!");$sql = "INSERT INTO `hesk_tickets` (`id`,`trackid`,`name`,`email`,`category`,`priority`,`subject`,`message`,`dt`,`ip`,`status`)VALUES ('','$trackingID','$name','$email','$category','$priority','$subject','$message',NOW(),'$_SERVER[REMOTE_ADDR]','1')";$result = hesk_dbQuery($sql) or hesk_error("$hesklang[cant_sql]: $sql</p><p>$hesklang[mysql_said]:<br>".mysql_error()."</p><p>$hesklang[contact_webmsater] $hesk_settings[webmaster_mail]");/* Get e-mail message for customer */$fp=fopen('emails/new_ticket.txt','r');$message=fread($fp,filesize('emails/new_ticket.txt'));fclose($fp);$message=str_replace('%%NAME%%',$name,$message);$message=str_replace('%%SUBJECT%%',$subject,$message);$message=str_replace('%%TRACK_ID%%',$trackingID,$message);$message=str_replace('%%TRACK_URL%%',$trackingURL,$message);$message=str_replace('%%SITE_TITLE%%',$hesk_settings['site_title'] ,$message);$message=str_replace('%%SITE_URL%%',$hesk_settings['site_url'] ,$message);/* Send e-mail */$headers="From: $hesk_settings[noreply_mail]\n";$headers.="Reply-to: $hesk_settings[noreply_mail]\n";@mail($email,$hesklang['ticket_received'],$message,$headers);/* Need to notify any admins? */$admins=array();$sql = "SELECT `email`,`isadmin`,`categories` FROM `hesk_users` WHERE `notify`='1'";$result = hesk_dbQuery($sql) or hesk_error("$hesklang[cant_sql]: $sql</p><p>$hesklang[mysql_said]:<br>".mysql_error()."</p><p>$hesklang[contact_webmsater] $hesk_settings[webmaster_mail]");while ($myuser=hesk_dbFetchAssoc($result)){ /* Is this an administrator? */ if ($myuser['isadmin']) {$admins[]=$myuser['email']; continue;} /* Not admin, is he allowed this category? */ $cat=substr($myuser['categories'], 0, -1); $myuser['categories']=explode(",",$cat); if (in_array($category,$myuser['categories'])) { $admins[]=$myuser['email']; continue; }}if (count($admins)>0){$trackingURL_admin=$hesk_settings['hesk_url'].'/admin_ticket.php?track='.$trackingID;/* Get e-mail message for customer */$fp=fopen('emails/new_ticket_staff.txt','r');$message=fread($fp,filesize('emails/new_ticket_staff.txt'));fclose($fp);$message=str_replace('%%NAME%%',$name,$message);$message=str_replace('%%SUBJECT%%',$subject,$message);$message=str_replace('%%TRACK_ID%%',$trackingID,$message);$message=str_replace('%%TRACK_URL%%',$trackingURL_admin,$message);$message=str_replace('%%SITE_TITLE%%',$hesk_settings['site_title'] ,$message);$message=str_replace('%%SITE_URL%%',$hesk_settings['site_url'] ,$message);/* Send e-mail to staff */$email=implode(',',$admins);$headers="From: $hesk_settings[noreply_mail]\n";$headers.="Reply-to: $hesk_settings[noreply_mail]\n";@mail($email,$hesklang['new_ticket_submitted'],$message,$headers);} // End if?><p class="smaller"><a href="<?php echo $hesk_settings['site_url']; ?>"class="smaller"><?php echo $hesk_settings['site_title']; ?></a> ><a href="index.php?a=start" class="smaller"><?php echo $hesk_settings['hesk_title']; ?></a>> <?php echo $hesklang['ticket_submitted']; ?><br> </p></td></tr><tr><td><p> </p><h3 align="center"><?php echo $hesklang['ticket_submitted']; ?></h3><p> </p><p align="center"><?php echo $hesklang['ticket_submitted_success'].': <b>'.$trackingID;?></b></p><p align="center"><a href="<?php echo $trackingURL; ?>"><?php echo $hesklang['view_your_ticket']; ?></a></p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><?phprequire_once('inc/footer.inc.php');?>