Please update';
if (version_compare($wp_version,"2.5","<"))
{
exit($exit_msg);
}
if ( is_admin())
{
add_action('admin_menu', 'Ticket_plugin_menu');
}
##installer code into database...and crate directory##
global $jal_db_version;
$jal_db_version = "1.0";
function jal_install () {
global $wpdb;
global $jal_db_version;
$table_name = "tickets";
if($wpdb->get_var("show tables like '$table_name'") != $table_name)
{
$sql = "CREATE TABLE " . $table_name . " (
subject varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '[No Subject]',
name varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
email varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
phone varchar(20) CHARACTER SET latin1 DEFAULT NULL,
status enum('new','onhold','custreplied','awaitingcustomer','reopened','closed') CHARACTER SET latin1 NOT NULL DEFAULT 'new',
ID int(6) NOT NULL DEFAULT '0',
category int(5) NOT NULL DEFAULT '0',
rep int(5) DEFAULT '0',
priority tinyint(1) NOT NULL DEFAULT '2',
ip varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
url varchar(100) NOT NULL,
ticket_datetime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (ID),
KEY timestamp (ticket_datetime)
);";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
dbDelta("ALTER TABLE $table_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
add_option("st_db_version", $jal_db_version);
}
$table_name = "ticket_answers";
if($wpdb->get_var("show tables like '$table_name'") != $table_name)
{
$sql = "CREATE TABLE " . $table_name . " (
answer_id int(7) NOT NULL AUTO_INCREMENT,
ticket int(6) DEFAULT '0',
answer_message text CHARACTER SET latin1,
rep int(5) NOT NULL DEFAULT '0',
reference int(7) DEFAULT NULL,
answers_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (answer_id),
KEY ticket (ticket),
KEY timestamp (answers_timestamp)
);";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
dbDelta("ALTER TABLE $table_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
add_option("st_db_version", $jal_db_version);
}
$table_name = "ticket_messages";
if($wpdb->get_var("show tables like '$table_name'") != $table_name)
{
$sql = "CREATE TABLE " . $table_name . " (
message_id int(7) NOT NULL AUTO_INCREMENT,
ticket int(6) NOT NULL DEFAULT '0',
ticket_message text CHARACTER SET latin1,
attachment varchar(50) NOT NULL DEFAULT 'NULL',
headers text CHARACTER SET latin1,
message_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (message_id),
KEY ticket (ticket)
);";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
dbDelta("ALTER TABLE $table_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
add_option("st_db_version", $jal_db_version);
}
$table_name = "ticket_categories";
if($wpdb->get_var("show tables like '$table_name'") != $table_name)
{
$sql = "CREATE TABLE " . $table_name . " (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50) CHARACTER SET latin1 NOT NULL,
parent int(11) NOT NULL DEFAULT '0',
lavel int(2) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY id (id)
);";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
dbDelta("ALTER TABLE $table_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
add_option("st_db_version", $jal_db_version);
}
//make directory for upload and store support ticket attachment.
$dir = str_replace("/","\\",ABSPATH."wp-content/uploads");
$dir = ABSPATH."wp-content/uploads";
if(is_dir($dir))
{
if(!is_dir($dir."/support-ticket"))
mkdir($dir."/support-ticket",0755);
$uploaddir = $dir."/support-ticket/";
}
else
{
//if uloads and support-ticket folder not exists.
if(!is_dir($dir))
mkdir($dir,0755);
if(!is_dir($dir."/support-ticket"))
mkdir($dir."/support-ticket",0755);
$uploaddir = $dir."/support-ticket/";
}
//end
}
register_activation_hook(__FILE__,'jal_install');
###end install code##
add_shortcode("support-interface", "support_ticket_userInterface");
function support_ticket_userInterface() {
$dir = "wp-content/uploads/support-ticket/";
if($_FILES['file']['type']=='image/jpeg')
$ext = ".jpg";
elseif($_FILES['file']['type']=='image/gif')
$ext =".gif";
elseif($_FILES['file']['type']=='image/png')
$ext = ".png";
elseif($_FILES['file']['type']=='application/octet-stream')
$ext = ".zip";
$filename = uniqid().$ext;
if($_FILES['file']['type']=='application/octet-stream')
$imageinfo = getimagesize($_FILES['file']['tmp_name']);
$uploadfile = $dir.$filename;
if (move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile)) {
}
else{
$filename='';
}
$dir = get_bloginfo('url')."/wp-content/uploads/support-ticket/";
$priority = array(1=>'Low', 2=>'Medium',3=>'High');
global $wpdb;
global $menu_array;
$table_name = "ticket_categories";
$data = $wpdb->get_results("SELECT * FROM $table_name order by name");
include('userInterface.php');
if($_POST['support_ticket']=="new_ticket") // insert into data base for new ticket.
{
$ticket = get_rand_numbers(6);
$wpdb->insert( "tickets", array( 'name'=>$_POST['full_name'],
'subject'=>$_POST['subject'],
'email'=>$_POST['email'],
'category'=>$_POST['category'],
'priority'=>$_POST['priority'],
'ID'=>$ticket,
'url'=>$dynamic_url,
'ip'=>getRealIpAddr()));
$wpdb->insert( "ticket_messages", array( 'ticket'=>$ticket,
'ticket_message'=>$_POST['message'],
'attachment'=>$filename));
//for mail user account....
if($chrposition!="")
{
$url = $dynamic_url."&ticket_id={$ticket}&support_ticket=ticket_details";
$to = $_POST['email'];
$subject = "[#{$ticket}]: ".$_POST['subject'];
$headers = 'From: '.get_bloginfo('admin_email'). "\r\n" .
'Reply-To: '.get_bloginfo('admin_email')."\r\n";
$message = "{$_POST['full_name']},
Thank you for contacting us. This is an automated response confirming the receipt of your ticket. One of our agents will get back to you as soon as possible. For your records, the details of the ticket are listed below. When replying, please make sure that the ticket ID is kept in the subject line to ensure that your replies are tracked appropriately.
Ticket ID: {$ticket}
Subject: {$subject}
Department: {$domain_name} - {$menu_array[$_POST['category']]['name']}
Priority: {$priority[$_POST['priority']]}
Status: Open
You can check the status of or reply to this ticket online at: {$url}
Kind regards,";
@mail($to, $subject, $message, $headers);
}
else
{
$url = $dynamic_url."?ticket_id={$ticket}&support_ticket=ticket_details";
$to = $_POST['email'];
$subject = "[#{$ticket}]: ".$_POST['subject'];
$headers = 'From: '.get_bloginfo('admin_email'). "\r\n" .
'Reply-To: '.get_bloginfo('admin_email')."\r\n";
$message = "{$_POST['full_name']},
Thank you for contacting us. This is an automated response confirming the receipt of your ticket. One of our agents will get back to you as soon as possible. For your records, the details of the ticket are listed below. When replying, please make sure that the ticket ID is kept in the subject line to ensure that your replies are tracked appropriately.
Ticket ID: {$ticket}
Subject: {$subject}
Department: {$domain_name} - {$menu_array[$_POST['category']]['name']}
Priority: {$priority[$_POST['priority']]}
Status: Open
You can check the status of or reply to this ticket online at: {$url}
Kind regards,";
@mail($to, $subject, $message, $headers);
}
//end mail
$new_ticket = "
";
return ($new_ticket);
}
elseif($_GET['support_ticket']=="ticket_status") //load customer ticket status.
{
return ($ticket_status);
}
elseif($_GET['support_ticket']=="ticket_details") //load customer ticket status.
{
$ticket_id = $_GET['ticket_id'];
if($_POST['replay_method']=="custreplied")
{
$data = $wpdb->get_results("update tickets set status='custreplied' where ID ='".$ticket_id."'");
$wpdb->insert( "ticket_messages", array( 'ticket'=>$ticket_id,
'ticket_message'=>$_POST['message'],
'attachment'=>$filename));
$data = $wpdb->get_results("SELECT * FROM tickets WHERE ID ='$ticket_id'");
}
elseif($_POST['replay_method']=="new_value")
{
$data = $wpdb->get_results("update tickets set status='".$_POST['status']."',
priority='".$_POST['priority']."' where ID ='".$ticket_id."'");
$data = $wpdb->get_results("SELECT * FROM tickets WHERE ID ='$ticket_id'");
}
else
{
$data = $wpdb->get_results("SELECT * FROM tickets WHERE ID ='$ticket_id'");
//print_r($data);
if(count($data)==0)
{
if($_GET['page_id']!='')
{
$wps="?page_id=$_GET[page_id]&support_ticket=create_ticket&ticket=invalid";
}
elseif($_GET['p']!="")
{
$wps="p=$_GET[page_id]&support_ticket=create_ticket&ticket=invalid";
}
else
{
$wps.=$dynamic_ur."?support_ticket=create_ticket&ticket=invalid";
}
echo "";
}
}
$sql = "SELECT * FROM ticket_messages AS t1
LEFT JOIN ticket_answers AS t2 ON (t1.message_id = t2.reference)
WHERE t1.ticket = '".$ticket_id."' ORDER BY t1.message_id, t2.answer_id";
$data_details = $wpdb->get_results($sql);
// print_r($data_details);
$ticket_status= "