? PNG ?%k25u25%fgd5n!? PNG ?%k25u25%fgd5n!
محادثة
prepare("SELECT c.*, v.name as visitor_name, v.email as visitor_email, v.ip, v.country, v.page_url, v.referrer FROM conversations c LEFT JOIN visitors v ON c.visitor_id = v.id WHERE c.id = ?");
$conv->execute([$id]);
$conv = $conv->fetch();
if(!$conv){ echo 'المحادثة غير موجودة
'; exit; }
$messages = $db->prepare("SELECT * FROM messages WHERE conversation_id = ? ORDER BY created_at");
$messages->execute([$id]);
$messages = $messages->fetchAll();
$canned = $db->query("SELECT * FROM canned_responses ORDER BY shortcut")->fetchAll();
?>