| Server IP : 51.89.169.208 / Your IP : 216.73.216.57 Web Server : Apache System : Linux ns3209505.ip-198-244-202.eu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Tue Nov 5 04:50:16 EST 2024 x86_64 User : yellowleaf ( 1019) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/yellowleaf/public_html/support/ |
Upload File : |
<?php
session_start();
$path = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';
$styleSupport = 'class="navBoxSel"';
$t_email = $_GET['email'];
/// closing ticket message
if(isset($_POST['close_ticket'])){
$r3 = $connect->query("DELETE FROM tickets WHERE email='{$t_email}'") or die($connect->error);
$ticket_closed=TRUE;
}
/// posting new ticket message
if(isset($_POST['submit'])){
$name=ucwords($_POST['name']);
$email=$_POST['email'];
$message=$_POST['message'];
$subject=$_POST['subject'];
$date=time();
$browser=$_SERVER['HTTP_USER_AGENT'];
// creating ticket convo
$r1 = $connect->query("INSERT INTO tickets SET email = '{$email}', name = '{$name}', subject = '{$subject}', message = '{$message}', staff = '0', date = '{$date}',browser='{$browser}', status='1'") or die($connect->error);
$success=TRUE;
}
/// posting ticket message - END
// tickets
$convo_sql = $connect->query("SELECT * FROM tickets WHERE email='{$t_email}' ORDER BY id ASC");
$ticket_exist = $convo_sql->num_rows;
if($ticket_exist==0){
header('Location: /support/');
}else{
while($trow = $convo_sql->fetch_assoc()){
$ticket_id[]=$trow['id'];
$ticket_subj[]=$trow['subject'];
if($trow['staff']=="0"||$trow['staff']==""){
$customer_email[]=$trow['email'];
$customer_name[]=ucwords($trow['name']);
$nameDisplay=ucwords($trow['name']);$css='topBarCust';$tickType="tickTypeCust";$typeName="Customer";
}else{
$nameDisplay=ucwords($trow['staff']);$css='topBarStaff';$tickType="tickTypeStaff";$typeName="Staff";
}
$content.='<div class="tickCn">';
$content.='<div class="topBarCurv '.$css.'">';
$content.='<span class="'.$tickType.'">'.$typeName.'</span>';
$content.='<span class="tickName">'.$nameDisplay.'</span> | <span class="tickDate">'.date("l jS F Y, g:ia", $trow['date']).'</span>';
$content.='</div>';
$content.='<div class="botBarCurv botbar">'.nl2br(htmlentities($trow['message'])).'</div>';
$content.='</div>';
}
$status_html='<span class="tickStatus">Open</span> <img style="margin-3px;" src="/img/dot_green.png">';
$content_top.='<table width="100%" style="margin-bottom:40px;"><tr>';
$content_top.='<td><div class="tickId">Ticket ID: #<span>'.$ticket_id[0].'</span></div></td>';
$content_top.='<td style="min-width:250px"><div class="tickStatCn">Ticket Status: <span>'.$status_html.'</span></div></td></tr>';
$content_top.='<tr><td><div class="tickSubj">Subject:<br><span>'.$ticket_subj[0].'</span></div></td>';
$content_top.='<td valign="top"></td>';
$content_top.='</tr></table>';
}
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Support - YellowLeaf UK</title>
<script src="/js/js.js"></script>
<link href="/style.css" rel="stylesheet" type="text/css">
<style>
.topBarCurv{border:1px solid #dedede;-webkit-border-top-left-radius: 10px;-webkit-border-top-right-radius: 10px;-moz-border-radius-topleft: 10px;-moz-border-radius-topright: 10px;border-top-left-radius: 10px;border-top-right-radius: 10px;}
.botBarCurv{border:1px solid #dedede;border-top:0px;-webkit-border-bottom-right-radius: 10px;-webkit-border-bottom-left-radius: 10px;-moz-border-radius-bottomright: 10px;-moz-border-radius-bottomleft: 10px;border-bottom-right-radius: 10px;border-bottom-left-radius: 10px;}
.tickTypeCust,.tickTypeStaff{float:right;font-weight:bold;font-size:10pt;}
.topBarCust{padding:10px 20px;background:url('/img/blue_grad.png') repeat-x bottom;}
.topBarStaff{padding:10px 20px;background:url('/img/green_grad.png') repeat-x bottom;}
.botbar{padding:20px}
.tickName{font-weight:bold;}
.tickDate{font-size:10pt;font-weight:bold;}
.tickCn{margin-top:20px;}
.tickId{font-size:20pt;}
.tickId span{color:#dd4b39}
.tickStatCn{float:right;font-size:14pt;}
.tickStatCn span{color:#888}
.tickStatus{}
.tickSubj{font-size:16pt;margin-top:20px}
.tickSubj span{color:#888;font-size:12pt;}
.tickUserName{font-size:12pt;color:#888;margin-top:40px;font-weight:bold;}
.tickUserName span{font-size:16pt;color:#444;font-weight:normal;}
.tickReply{color:#197AC4;margin-top:15px;font-weight:bold;}
</style>
<script>
function showTicketForm(){
el('replyForm').style.display='';
el('convo-op').style.display='none';
}
</script>
</head>
<body>
<? include '../header.php'; ?>
<table class="tbwdth">
<tr>
<td valign="top" width="225">
<? include '../info_menu.php'; ?>
</td>
<td valign="top" style="padding-left:30px;">
<div style="font-size:23pt;font-weight:bold;color: #444;padding-bottom:10px;color:#197AC4">Contact Us</div>
<?
if($ticket_closed==TRUE){?>
<div class="successDvBx">
You're ticket has been closed. <a href="/">Click here to return to YellowLeaf homepage ></a>
</div>
<?}elseif($error==TRUE){?>
<div style="color:#555;line-height:21px;margin-top: 20px;">
Sorry, this ticket does not exist!
</div>
<?}else{ ?>
<form action="view_ticket.html?email=<?=$customer_email[0]?>" method="POST">
<div style="color:#555;line-height:21px;margin-top: 20px;">
<?=$content_top?><?=$content?>
</div>
<div id="convo-op" style="margin-top:30px;">
<div style="margin-bottom:10px;font-size:12pt;font-weight:bold;">Has your query been answered?</div>
<div>
<button style="margin-right:8px" class="button red" onclick="return confirm('Are you sure that you want to close this ticket?');" type="submit" name="close_ticket">Yes - Close this ticket now ></button>
<b>OR</b>
<button type="button" style="margin-left:8px" class="button blue" onclick="showTicketForm();return false;">No - Reply Now ></button>
</div>
</div>
<div id="replyForm" style="display:none;color:#555;line-height:21px;margin-top: 20px;">
<input type="hidden" value="<?=$customer_name[0]?>" name="name" size="34">
<input type="hidden" value="<?=$customer_email[0]?>" name="email" size="34">
<input type="hidden" value="<?=$ticket_id[0]?>" name="id" size="34">
<div class="tickUserName">Name: <span><?=$customer_name[0]?><span></div>
<div class="tickReply">Your Reply:</div>
<textarea name="message" style="width:97%;font-size:11pt;padding:10px;font-family:verdana;" rows="15"></textarea>
<input class="fancyBtn blueBtn" style="border:0px;margin-top:20px;float:right;" type="submit" value="Send Message >" name="submit">
</div>
</form>
<?}?>
</td>
</tr>
</table>
<? include '../footer.php'; ?>
</body>
</html>