Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory : /home/u107206879/domains/escort46.de/public_html/en/ |
<?php
require "db_connection.php";
include "sessioncheck.php";
function friendly_seo_string($vp_string){
$vp_string = trim($vp_string);
$vp_string = html_entity_decode($vp_string);
$vp_string = strip_tags($vp_string);
$vp_string = strtolower($vp_string);
$vp_string = preg_replace('~[^ a-z0-9_.]~', ' ', $vp_string);
$vp_string = preg_replace('~ ~', '-', $vp_string);
$vp_string = preg_replace('~-+~', '-', $vp_string);
return $vp_string;
} # friendly_seo_string()
if(isset($_POST["sendid"]) && !empty($_POST["sendid"]) && isset($_POST["textmsg"]) && !empty($_POST["textmsg"]) ) {
$mainadqry=mysqli_query($connection,"SELECT id,profile_tile FROM advertise WHERE em_id=".$_SESSION['id']." AND main_profile=1");
$mainad=mysqli_fetch_array($mainadqry);
$sendid=$mainad['id'];
$title=$mainad['profile_tile'];
$recvid = $_POST["sendid"];
//$sendid = $_SESSION["id"];
$textmsg = $_POST["textmsg"];
$sql = "INSERT INTO off_messages (sender_id,receiver_id,message,is_read) VALUES (".$sendid.", '" . $recvid . "', '" . $textmsg . "', 1)";
$sqlres = mysqli_query($connection,$sql);
if($sqlres){
$to=$recvid;
$subject="Reply from user (".MAIN_EMAIL_NAME.")";
$headers='From:'.MAIN_EMAIL_NAME.' <'.MAIN_EMAIL.'>';
$msg= "You got a new message from a user ";
$msg.="\nBelow is the link of profile who replied to you. Follow the link to reply to this message.
\n".SUB_URL."/user_detail/".$sendid."/".friendly_seo_string($title);
$msg.="\n\nMessage: \n".$textmsg;
mail($to,$subject,$msg,$headers);
}
}
$recvid = $_POST["sendid"];
?>
<ul class="list-unstyled" >
<?php
$chattbl="SELECT b.*, IF(b.receiver_id = ".$sendid.", 'received', 'sent') as sendstatus FROM off_messages as b WHERE '".$sendid."' IN (b.receiver_id, b.sender_id) AND '".$recvid."' IN (b.receiver_id, b.sender_id) ORDER BY b.date_time ASC";
$chatres = mysqli_query($connection,$chattbl);
while($chatmsgs = mysqli_fetch_array($chatres)){
$proqry="SELECT * FROM images WHERE em_id=".$_SESSION['id']." AND is_profile=1";
$prores=mysqli_query($connection,$proqry);
$propic = mysqli_fetch_array($prores);
if($chatmsgs['sendstatus']=="received"){
$liclass="";
$spanclass="pull-left";
$divclass="pull-right";
}elseif($chatmsgs['sendstatus']=="sent"){
if($propic['photo']==""){
$imagesrc=MAIN_URL."/images/default-person.png";
}else{
$imagesrc=MAIN_URL."/user_images/".$propic['photo'];
}
$liclass="admin_chat";
$spanclass="pull-right";
$divclass="pull-left";
}
?>
<li class="left clearfix <?php echo $liclass; ?>">
<span class="chat-img1 <?php echo $spanclass; ?>">
<img src="<?php echo MAIN_URL; ?>/images/default-person.png" alt="User" class="img-circle">
</span>
<div class="chat-body1 clearfix">
<p><?php echo $chatmsgs['message']; ?></p>
<div class="chat_time <?php echo $divclass; ?>"><?php echo date("H:i",strtotime($chatmsgs['date_time'])); ?></div>
</div>
</li>
<?php
}
?>
</ul>