query("SHOW COLUMNS FROM briefs")->fetchAll(PDO::FETCH_ASSOC);
foreach ($crows as $c) $briefCols[(string)$c['Field']] = true;
} catch (Throwable $e) {
// ignore
}
}
// ---------------------------
// Unread replies badge (brand/admin) ✅ UPDATED
// ---------------------------
$unreadBrandReplies = 0;
if ($logged && $uid > 0 && ($isBrand || $isAdmin) && ($pdo instanceof PDO)) {
try {
if (!empty($briefCols['brand_user_id']) && !empty($briefCols['reply_message']) && !empty($briefCols['brand_read_at'])) {
$st = $pdo->prepare("
SELECT COUNT(*) AS c
FROM briefs
WHERE brand_user_id = ?
AND reply_message IS NOT NULL
AND reply_message <> ''
AND brand_read_at IS NULL
");
$st->execute([$uid]);
$unreadBrandReplies = (int)($st->fetch()['c'] ?? 0);
}
} catch (Throwable $e) {
error_log('LAYOUT_UNREAD_BRAND_BADGE_ERROR: ' . $e->getMessage());
}
}
// ---------------------------
// Unread briefs badge (creator/admin) ✅ UPDATED
// ---------------------------
$unreadCreatorBriefs = 0;
$creatorIdForNav = 0;
if ($logged && $uid > 0 && ($isCreator || $isAdmin) && ($pdo instanceof PDO)) {
try {
// find creator.id for this user
$st = $pdo->prepare("SELECT id FROM creators WHERE user_id=? LIMIT 1");
$st->execute([$uid]);
$row = $st->fetch();
if ($row) $creatorIdForNav = (int)$row['id'];
if ($creatorIdForNav > 0) {
if (!empty($briefCols['creator_id']) && !empty($briefCols['creator_read_at'])) {
$st = $pdo->prepare("
SELECT COUNT(*) AS c
FROM briefs
WHERE creator_id = ?
AND creator_read_at IS NULL
");
$st->execute([$creatorIdForNav]);
$unreadCreatorBriefs = (int)($st->fetch()['c'] ?? 0);
} elseif (!empty($briefCols['creator_id']) && !empty($briefCols['status'])) {
// fallback if creator_read_at not present
$st = $pdo->prepare("
SELECT COUNT(*) AS c
FROM briefs
WHERE creator_id = ?
AND (status IS NULL OR status NOT IN ('read','replied'))
");
$st->execute([$creatorIdForNav]);
$unreadCreatorBriefs = (int)($st->fetch()['c'] ?? 0);
}
}
} catch (Throwable $e) {
error_log('LAYOUT_UNREAD_CREATOR_BADGE_ERROR: ' . $e->getMessage());
}
}
// ---------------------------
// Creator Featured status (for navbar highlight) ✅ NEW
// ---------------------------
$creatorFeaturedActive = false;
$creatorFeaturedUntil = '';
if ($logged && $creatorIdForNav > 0 && ($isCreator || $isAdmin) && ($pdo instanceof PDO)) {
try {
// Check featured_until column exists (safe)
$st = $pdo->query("
SELECT COUNT(*)
FROM information_schema.columns
WHERE table_schema = DATABASE()
AND table_name = 'creators'
AND column_name = 'featured_until'
");
$hasFeatCol = ((int)$st->fetchColumn() > 0);
if ($hasFeatCol) {
$st = $pdo->prepare("SELECT featured_until FROM creators WHERE id=? LIMIT 1");
$st->execute([$creatorIdForNav]);
$creatorFeaturedUntil = (string)($st->fetchColumn() ?: '');
if ($creatorFeaturedUntil !== '') {
$ts = strtotime($creatorFeaturedUntil);
$creatorFeaturedActive = ($ts !== false && $ts > time());
}
}
} catch (Throwable $e) {
// ignore; keep inactive
}
}
// ---------------------------
// Browse link: MUST be unfiltered
// ---------------------------
$browseHref = '/browse';
// ---------------------------
// Layout mode: make listing/browse full-width (functional-first)
// ---------------------------
$FULL_VIEWS = ['browse', 'listing']; // keep others boxed for now
$isFullWidth = in_array((string)$view, $FULL_VIEWS, true);
$navInnerStyle = $isFullWidth
? "width:100%;margin:0;padding:10px 16px;display:flex;align-items:center;gap:10px;flex-wrap:wrap;"
: "max-width:1100px;margin:0 auto;padding:10px 16px;display:flex;align-items:center;gap:10px;flex-wrap:wrap;";
$mainStyle = $isFullWidth
? "width:100%;max-width:none;margin:24px 0;padding:0 16px;"
: "max-width:1100px;margin:24px auto;padding:0 16px;";
?>
<?= $h($title) ?>