<!-- Debugging PHP values: START -->
<!-- Script executed: 2025-07-18 10:49:31 -->
<!-- session_status(): 2 -->
<!-- isset($_SESSION['user']->id): false -->
<!-- User ID: null -->
<!-- $_SESSION content (first 500 chars): Array
(
)
... -->
<!-- Debugging PHP values: END -->
require_once($_SERVER['DOCUMENT_ROOT'].'/db.php'); 
require_once($_SERVER['DOCUMENT_ROOT'].'/globals.php'); 
require_once($_SERVER['DOCUMENT_ROOT'].'/includes_shared.php');
require_once($_SERVER['DOCUMENT_ROOT'].'/header.php'); // Assuming header.php builds navigation etc.

// Determine login status based solely on $_SESSION['user']->id
$user_is_logged_in = isset($_SESSION['user']->id);


// Define domain for URLs
$domain = 'https://casino.watch';

$slug = isset($_GET['slug']) ? $_GET['slug'] : 'hala-chimanimani-resort-casino';
$langauge = isset($_GET['lang']) ? $_GET['language'] : $base_language;
$casino = null;
$stmt = mysqli_prepare($con, "SELECT * FROM casinos WHERE casino_slug = ?  LIMIT 1");
if (!$stmt) {
    die("DB_ERROR: Failed to prepare casino statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__); // Added file/line for better debugging
}
mysqli_stmt_bind_param($stmt, "s", $slug);
if (!mysqli_stmt_execute($stmt)) {
    die("DB_ERROR: Failed to execute casino statement: " . mysqli_stmt_error($stmt) . " in " . __FILE__ . " on line " . __LINE__); // Added file/line
}
$result = mysqli_stmt_get_result($stmt);
if (!$result) {
    die("DB_ERROR: Failed to get result for casino statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__); // Added file/line
}
if (mysqli_num_rows($result) > 0) {
    $casino = mysqli_fetch_object($result);
}
mysqli_stmt_close($stmt);

if (!$casino) {
    http_response_code(404);
    die("Casino not found.");
}
$master_casino_id = !empty($casino->parent_id) ? $casino->parent_id : $casino->casino_id;
$json = json_decode($casino->api_json1);
// Check for JSON decode errors (non-fatal, but good to log)
if (json_last_error() !== JSON_ERROR_NONE) {
    error_log("JSON Decode Error for casino ID {$master_casino_id}: " . json_last_error_msg() . " in " . __FILE__ . " on line " . __LINE__);
    // Optionally: die("CRITICAL_ERROR: Invalid JSON data for casino.");
}

function get_json_property($obj, $path, $default = null) {
    if (!is_object($obj)) return $default;
    $keys = explode('->', $path);
    $current = $obj;
    foreach ($keys as $key) {
        if (!isset($current->$key)) return $default;
        $current = $current->$key;
    }
    return $current;
}


function get_youtube_id($url) {
    parse_str(parse_url($url, PHP_URL_QUERY), $vars);
    return $vars['v'] ?? null;
}

// --- DYNAMIC DATA FETCHING FOR ALL SECTIONS ---
$db_reviews = [];
$stmt_reviews = mysqli_prepare($con, "SELECT * FROM casinos_reviews WHERE casino_id = ? ORDER BY id DESC LIMIT 10");
if(!$stmt_reviews) {
    die("DB_ERROR: Failed to prepare reviews statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
mysqli_stmt_bind_param($stmt_reviews, "i", $master_casino_id);
if (!mysqli_stmt_execute($stmt_reviews)) {
    die("DB_ERROR: Failed to execute reviews statement: " . mysqli_stmt_error($stmt_reviews) . " in " . __FILE__ . " on line " . __LINE__);
}
$result_reviews = mysqli_stmt_get_result($stmt_reviews);
if (!$result_reviews) {
    die("DB_ERROR: Failed to get result for reviews statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
while ($row = mysqli_fetch_object($result_reviews)) { $db_reviews[] = $row; }
mysqli_stmt_close($stmt_reviews);

$up_votes = 0; $down_votes = 0; 

$live_events = [];
$stmt_events = mysqli_prepare($con, "SELECT * FROM events WHERE casino_id = ? ORDER BY id DESC LIMIT 3");
if (!$stmt_events) {
    die("DB_ERROR: Failed to prepare events statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
mysqli_stmt_bind_param($stmt_events, "i", $master_casino_id);
if (!mysqli_stmt_execute($stmt_events)) {
    die("DB_ERROR: Failed to execute events statement: " . mysqli_stmt_error($stmt_events) . " in " . __FILE__ . " on line " . __LINE__);
}
$result_events = mysqli_stmt_get_result($stmt_events);
if (!$result_events) {
    die("DB_ERROR: Failed to get result for events statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
while ($row = mysqli_fetch_object($result_events)) { $live_events[] = $row; }
mysqli_stmt_close($stmt_events);

$live_jobs = [];
$stmt_jobs = mysqli_prepare($con, "SELECT * FROM jobs WHERE casino_id = ? ORDER BY id DESC LIMIT 3");
if (!$stmt_jobs) {
    die("DB_ERROR: Failed to prepare jobs statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
mysqli_stmt_bind_param($stmt_jobs, "i", $master_casino_id);
if (!mysqli_stmt_execute($stmt_jobs)) {
    die("DB_ERROR: Failed to execute jobs statement: " . mysqli_stmt_error($stmt_jobs) . " in " . __FILE__ . " on line " . __LINE__);
}
$result_jobs = mysqli_stmt_get_result($stmt_jobs);
if (!$result_jobs) {
    die("DB_ERROR: Failed to get result for jobs statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
while ($row = mysqli_fetch_object($result_jobs)) { $live_jobs[] = $row; }
mysqli_stmt_close($stmt_jobs);

$promo_banner = null;
$banner_result = mysqli_query($con, "SELECT id, headline, description, cta, image_name, link FROM banners WHERE status = 'Active' AND moderated = 'Yes' ORDER BY RAND() LIMIT 1");
if (!$banner_result) {
    die("DB_ERROR: Failed to query banners: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
if (mysqli_num_rows($banner_result) > 0) {
    $promo_banner = mysqli_fetch_object($banner_result);
    // Impression logging, if it has a database interaction, should also be handled carefully.
    // Example: $impression_sql = "INSERT INTO analytics_impressions (...) VALUES (...)";
    // $stmt_imp = mysqli_prepare($con, $impression_sql); if (!$stmt_imp) { error_log(...); }
    // ... then execute and close. No die() for non-critical logging.
    $impression_sql = "INSERT INTO analytics_impressions (item_id, variation_id, user_id, page_url, ip_address, type, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?)";
    $stmt_imp = mysqli_prepare($con, $impression_sql);
    if($stmt_imp) {
        $user_id_for_analytics = $_SESSION['user']->id ?? null;
        $visitor_type = get_impression_type($con, $_SERVER['REMOTE_ADDR'], $_SERVER['HTTP_USER_AGENT']);
        mysqli_stmt_bind_param($stmt_imp, 'iiissss', $promo_banner->id, $promo_banner->id, $user_id_for_analytics, $_SERVER['REQUEST_URI'], $_SERVER['REMOTE_ADDR'], $visitor_type, $_SERVER['HTTP_USER_AGENT']);
        mysqli_stmt_execute($stmt_imp); // No die() here, logging is not critical for page load
        mysqli_stmt_close($stmt_imp);
    } else {
        error_log("DB_ERROR: Failed to prepare analytics impression statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
    }
}


$images = [];
$stmt_img = mysqli_prepare($con, "SELECT * FROM casino_latest_images WHERE casino_id = ?");
if(!$stmt_img) {
    die("DB_ERROR: Failed to prepare images statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
mysqli_stmt_bind_param($stmt_img, "i", $casino->parent_id);
if (!mysqli_stmt_execute($stmt_img)) {
    die("DB_ERROR: Failed to execute images statement: " . mysqli_stmt_error($stmt_img) . " in " . __FILE__ . " on line " . __LINE__);
}
$result_img = mysqli_stmt_get_result($stmt_img);
if (!$result_img) {
    die("DB_ERROR: Failed to get result for images statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
while ($row = mysqli_fetch_object($result_img)) { $images[] = $row; }
mysqli_stmt_close($stmt_img);

$profile_image_url = !empty($images) ? rtrim($domain, '/') . '/assets/casino/' . htmlspecialchars($images[0]->casino_id) . '/' . htmlspecialchars($images[0]->filename) : 'https://placehold.co/208x208';
$gallery_images_for_alpine = [];
if (!empty($images)) { foreach ($images as $img) { $gallery_images_for_alpine[] = ['src' => rtrim($domain, '/') . '/assets/casino/' . htmlspecialchars($img->casino_id) . '/' . htmlspecialchars($img->filename), 'alt' => htmlspecialchars($img->description)]; } }

$latitude = get_json_property($json, 'casino->location->coordinates->latitude');
$longitude = get_json_property($json, 'casino->location->coordinates->longitude');
$address = get_json_property($json, 'casino->location->address');

$highlights = [];
if (($val = get_json_property($json, 'casino->features->gaming->slots->totalMachines')) > 0) { $highlights[] = ['icon' => '<svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 6V4m0 2a2 2 0 100 4m0-4a2 2 0 110 4m-6 8a2 2 0 100-4m0 4a2 2 0 110-4m0 4v2m0-6V4m6 6v10m6-2a2 2 0 100-4m0 4a2 2 0 110-4m0 4v2m0-6V4" /></svg>', 'value' => number_format($val).'+', 'label' => 'Slot Machines']; }
if (($val = get_json_property($json, 'casino->features->gaming->tableGames->list')) && !empty($val)) { $highlights[] = ['icon' => '<svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M3 10h18M7 15h1m4 0h1m-7 4h12a3 3 0 003-3V8a3 3 0 00-3-3H6a3 3 0 00-3 3v8a3 3 0 003 3z" /></svg>', 'value' => count($val).'+ Types', 'label' => 'Table Games']; }
if (($val = get_json_property($json, 'casino->dining->restaurants')) && !empty($val)) { $highlights[] = ['icon' => '<svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" viewBox="0 0 20 20" fill="currentColor"><path d="M6.5 10.5a1.5 1.5 0 11-3 0 1.5 1.5 0 013 0z" /><path d="M11.5 10.5a1.5 1.5 0 11-3 0 1.5 1.5 0 013 0z" /><path d="M16.5 10.5a1.5 1.5 0 11-3 0 1.5 1.5 0 013 0z" /><path fill-rule="evenodd" d="M4 2a2 2 0 00-2 2v11a2 2 0 002 2h12a2 2 0 002-2V4a2 2 0 00-2-2H4zm0 2h12v11H4V4z" clip-rule="evenodd" /></svg>', 'value' => count($val), 'label' => 'Restaurants']; }
if ($casino->casino_always_open == '1') { $highlights[] = ['icon' => '<svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 8v4l3 3m6-3a9 9 0 11-18 0 9 9 0 0118 0z" /></svg>', 'value' => 'Open 24/7', 'label' => 'Hours']; }

$social_profiles = [];
$stmt_profiles = mysqli_prepare($con, "SELECT * FROM casinos_profiles WHERE casino_id = ? ORDER BY name ASC");
if(!$stmt_profiles) {
    die("DB_ERROR: Failed to prepare profiles statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
mysqli_stmt_bind_param($stmt_profiles, "i", $master_casino_id);
if (!mysqli_stmt_execute($stmt_profiles)) {
    die("DB_ERROR: Failed to execute profiles statement: " . mysqli_stmt_error($stmt_profiles) . " in " . __FILE__ . " on line " . __LINE__);
}
$result_profiles = mysqli_stmt_get_result($stmt_profiles);
if (!$result_profiles) {
    die("DB_ERROR: Failed to get result for profiles statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
while ($row = mysqli_fetch_object($result_profiles)) { $social_profiles[] = $row; }
mysqli_stmt_close($stmt_profiles);

// ** NEW: Fetch ratings, followers, and offers **
$ratings_sql = "SELECT 
                    (SELECT COUNT(id) FROM casinos_ratings WHERE casino_id = ? AND vote_direction = 'up') as up_votes,
                    (SELECT COUNT(id) FROM casinos_ratings WHERE casino_id = ? AND vote_direction = 'down') as down_votes";
$stmt_ratings = mysqli_prepare($con, $ratings_sql);
if(!$stmt_ratings) {
    die("DB_ERROR: Failed to prepare ratings count statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
mysqli_stmt_bind_param($stmt_ratings, "ii", $master_casino_id, $master_casino_id);
if (!mysqli_stmt_execute($stmt_ratings)) {
    die("DB_ERROR: Failed to execute ratings count statement: " . mysqli_stmt_error($stmt_ratings) . " in " . __FILE__ . " on line " . __LINE__);
}
$ratings = mysqli_fetch_assoc(mysqli_stmt_get_result($stmt_ratings));
mysqli_stmt_close($stmt_ratings); // Close statement for counts

$up_votes = $ratings['up_votes'] ?? 0;
$down_votes = $ratings['down_votes'] ?? 0;

$user_vote = null;
$user_id = $_SESSION['user']->id ?? null; // Use current user_id from session
if($user_id) {
    $vote_sql = "SELECT vote_direction FROM casinos_ratings WHERE casino_id = ? AND user_id = ?";
    $stmt_uv = mysqli_prepare($con, $vote_sql);
    if(!$stmt_uv) {
        die("DB_ERROR: Failed to prepare user vote statement (user): " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
    }
    mysqli_stmt_bind_param($stmt_uv, "ii", $master_casino_id, $user_id);
} else {
    $session_id = session_id(); // Ensure session_id is defined
    $vote_sql = "SELECT vote_direction FROM casinos_ratings WHERE casino_id = ? AND session_id = ?";
    $stmt_uv = mysqli_prepare($con, $vote_sql);
    if(!$stmt_uv) {
        die("DB_ERROR: Failed to prepare user vote statement (session): " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
    }
    mysqli_stmt_bind_param($stmt_uv, "is", $master_casino_id, $session_id);
}
if (!mysqli_stmt_execute($stmt_uv)) {
    die("DB_ERROR: Failed to execute user vote statement: " . mysqli_stmt_error($stmt_uv) . " in " . __FILE__ . " on line " . __LINE__);
}
$user_vote = mysqli_fetch_assoc(mysqli_stmt_get_result($stmt_uv))['vote_direction'] ?? null;
mysqli_stmt_close($stmt_uv);

$is_following = false;
if($user_id) {
    $follow_sql = "SELECT id FROM casinos_followers WHERE casino_id = ? AND user_id = ?";
    $stmt_f = mysqli_prepare($con, $follow_sql);
    if(!$stmt_f) {
        die("DB_ERROR: Failed to prepare follow statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
    }
    mysqli_stmt_bind_param($stmt_f, "ii", $master_casino_id, $user_id);
    if (!mysqli_stmt_execute($stmt_f)) {
        die("DB_ERROR: Failed to execute follow statement: " . mysqli_stmt_error($stmt_f) . " in " . __FILE__ . " on line " . __LINE__);
    }
    if(mysqli_stmt_get_result($stmt_f)->num_rows > 0) { $is_following = true; }
    mysqli_stmt_close($stmt_f);
}

// ** NEW: Fetch Videos **
$live_videos = []; // Initialize array
$stmt_videos = mysqli_prepare($con, "SELECT * FROM videos WHERE casino_id = ? ORDER BY rand() DESC LIMIT 10");
if(!$stmt_videos) {
    die("DB_ERROR: Failed to prepare videos statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
mysqli_stmt_bind_param($stmt_videos, "i", $master_casino_id);
if (!mysqli_stmt_execute($stmt_videos)) {
    die("DB_ERROR: Failed to execute videos statement: " . mysqli_stmt_error($stmt_videos) . " in " . __FILE__ . " on line " . __LINE__);
}
$result_videos = mysqli_stmt_get_result($stmt_videos);
if (!$result_videos) {
    die("DB_ERROR: Failed to get result for videos statement: " . mysqli_error($con) . " in " . __FILE__ . " on line " . __LINE__);
}
while ($row = mysqli_fetch_object($result_videos)) { $live_videos[] = $row; }
mysqli_stmt_close($stmt_videos);

// --- 2. SET HEADER VARIABLES ---
$page_title = "Casino Profile - " . htmlspecialchars($casino->casino_name);
$meta_description = htmlspecialchars(get_json_property($json, 'casino->seo->metaDescription', ''));

// --- 3. INCLUDE HEADER ---
// This was moved up already.

?>

<!-- 4. MAIN PAGE CONTENT -->
<main class="px-4 sm:px-6 md:px-10 lg:px-20 xl:px-32 flex flex-1 justify-center py-8">
    <div class="layout-content-container flex flex-col w-full max-w-7xl mx-auto" 
         x-data="casinoProfile({
            casinoId: <br />
<b>Warning</b>:  Undefined variable $master_casino_id in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>301</b><br />
,
            initialVote: '<br />
<b>Warning</b>:  Undefined variable $user_vote in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>302</b><br />
',
            isFollowing: <br />
<b>Warning</b>:  Undefined variable $is_following in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>303</b><br />
false,
            upVotes: <br />
<b>Warning</b>:  Undefined variable $up_votes in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>304</b><br />
,
            downVotes: <br />
<b>Warning</b>:  Undefined variable $down_votes in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>305</b><br />
         })">
        
        <section class="flex flex-col md:flex-row items-center gap-6 md:gap-8 p-6 md:p-8 bg-white rounded-xl shadow-lg mb-8 border">
            <div class="bg-center bg-no-repeat aspect-square bg-cover rounded-lg w-32 h-32 md:w-48 md:h-48 flex-shrink-0 border-4 border-orange-500 shadow-md" style='background-image: url("<br />
<b>Warning</b>:  Undefined variable $profile_image_url in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>309</b><br />
");'></div>
            <div class="flex flex-col items-center md:items-start text-center md:text-left w-full">
                <h2 class="text-3xl md:text-4xl font-bold"><br />
<b>Warning</b>:  Undefined variable $casino in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>311</b><br />
<br />
<b>Warning</b>:  Attempt to read property "casino_name" on null in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>311</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>311</b><br />
</h2>
                <p class="text-lg md:text-xl text-gray-600 mt-1"><br />
<b>Warning</b>:  Undefined variable $casino in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>312</b><br />
<br />
<b>Warning</b>:  Attempt to read property "casino_location_country_city" on null in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>312</b><br />
<br />
<b>Warning</b>:  Undefined variable $casino in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>312</b><br />
<br />
<b>Warning</b>:  Attempt to read property "casino_location_country_state" on null in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>312</b><br />
, </p>
                <div class="flex items-center mt-3 text-gray-500 text-base flex-wrap justify-center gap-x-4 gap-y-2">
                    <div class="flex items-center gap-2">
                        <button @click="rate('up')" :class="{ 'bg-green-100 text-green-700 ring-2 ring-green-500': userVote === 'up' }" class="flex items-center gap-1.5 rounded-full px-3 py-1.5 text-sm font-semibold transition-colors duration-150 hover:bg-gray-200"><svg class="w-5 h-5" viewBox="0 0 20 20" fill="currentColor"><path d="M2 10.5a1.5 1.5 0 113 0v6a1.5 1.5 0 01-3 0v-6zM6 10.333v5.43a2 2 0 001.106 1.79l.05.025A4 4 0 008.943 18h5.416a2 2 0 001.962-1.608l1.2-6A2 2 0 0015.562 8H12V4a2 2 0 00-2-2 1 1 0 00-1 1v.667a4 4 0 01-.8 2.4L6.8 7.933a2 2 0 00-1.8 2.4z"/></svg><span x-text="upVotes"></span></button>
                        <button @click="rate('down')" :class="{ 'bg-red-100 text-red-700 ring-2 ring-red-500': userVote === 'down' }" class="flex items-center gap-1.5 rounded-full px-3 py-1.5 text-sm font-semibold transition-colors duration-150 hover:bg-gray-200"><svg class="w-5 h-5" viewBox="0 0 20 20" fill="currentColor"><path d="M18 9.5a1.5 1.5 0 11-3 0v-6a1.5 1.5 0 013 0v6zM14 9.667v-5.43a2 2 0 00-1.106-1.79l-.05-.025A4 4 0 0011.057 2H5.642a2 2 0 00-1.962 1.608l-1.2 6A2 2 0 004.438 12H8v4a2 2 0 002 2 1 1 0 001-1v-.667a4 4 0 01.8-2.4l2.2-2.867a2 2 0 001.8-2.4z" /></svg><span x-text="downVotes"></span></button>
                    </div>
                    <a class="hover:text-orange-500 text-sm" href="#reviews"><br />
<b>Warning</b>:  Undefined variable $db_reviews in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>318</b><br />
<br />
<b>Fatal error</b>:  Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null given in /var/www/casino.watch/casino-profile.php:318
Stack trace:
#0 /var/www/casino.watch/router.php(50): require_once()
#1 {main}
  thrown in <b>/var/www/casino.watch/casino-profile.php</b> on line <b>318</b><br />