/** RackGhost - Blog Detail */
$slug = $param ?? $segments[1] ?? '';
$tf='title_'.$lang; $cf='content_'.$lang; $ef='excerpt_'.$lang; $mf='meta_title_'.$lang; $md='meta_description_'.$lang;
$post = $db->fetch("SELECT bp.*, bc.name_tr as cat_tr, bc.name_en as cat_en, bc.slug as cat_slug, sc.slug as svc_slug, sc.name_tr as svc_tr, sc.name_en as svc_en FROM blog_posts bp LEFT JOIN blog_categories bc ON bp.category_id=bc.id LEFT JOIN service_categories sc ON bp.service_category_id=sc.id WHERE bp.slug=? AND bp.status='published'", [$slug]);
if(!$post){ header('Location: '.SITE_URL.'/blog'); exit; }
$db->query("UPDATE blog_posts SET views=views+1 WHERE id=?", [$post['id']]);
$related = $db->fetchAll("SELECT * FROM blog_posts WHERE id!=? AND status='published' ORDER BY published_at DESC LIMIT 3", [$post['id']]);
$cn='cat_'.$lang; $sn='svc_'.$lang;
?>
