PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC] ); } catch (Throwable $e) { $conn = null; } } // ═══════════════════════════════════════════════════════════════ // AUTO-BOOTSTRAP SCHEMA + SEED // ═══════════════════════════════════════════════════════════════ $bootstrap_msg = ''; if ($conn instanceof PDO) { try { $conn->exec("CREATE TABLE IF NOT EXISTS cbd_creators ( id INT AUTO_INCREMENT PRIMARY KEY, slug VARCHAR(80) UNIQUE NOT NULL, stage_name VARCHAR(120) NOT NULL, real_name VARCHAR(120), label VARCHAR(120), vertical VARCHAR(80), base_location VARCHAR(120), languages VARCHAR(200), tagline VARCHAR(255), lede TEXT, pull_quote VARCHAR(500), cover_label VARCHAR(60) DEFAULT 'COVER FEATURE', issue_no VARCHAR(10) DEFAULT '001', issue_date VARCHAR(40), verified TINYINT(1) DEFAULT 0, featured TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $conn->exec("CREATE TABLE IF NOT EXISTS cbd_platforms ( id INT AUTO_INCREMENT PRIMARY KEY, creator_id INT NOT NULL, platform VARCHAR(40) NOT NULL, handle VARCHAR(120), metric VARCHAR(20), unit VARCHAR(40), last_sync DATE, INDEX (creator_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $conn->exec("CREATE TABLE IF NOT EXISTS cbd_audience ( id INT AUTO_INCREMENT PRIMARY KEY, creator_id INT NOT NULL, bucket ENUM('geo','age') NOT NULL, label VARCHAR(80) NOT NULL, pct INT NOT NULL, INDEX (creator_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $conn->exec("CREATE TABLE IF NOT EXISTS cbd_reel ( id INT AUTO_INCREMENT PRIMARY KEY, creator_id INT NOT NULL, track_no VARCHAR(8), title VARCHAR(200), season VARCHAR(20), role VARCHAR(120), length VARCHAR(20), sort_order INT DEFAULT 0, INDEX (creator_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $conn->exec("CREATE TABLE IF NOT EXISTS cbd_past_work ( id INT AUTO_INCREMENT PRIMARY KEY, creator_id INT NOT NULL, brand VARCHAR(120), kind VARCHAR(120), year VARCHAR(8), INDEX (creator_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $conn->exec("CREATE TABLE IF NOT EXISTS cbd_rates ( id INT AUTO_INCREMENT PRIMARY KEY, creator_id INT NOT NULL, line_item VARCHAR(200), zar VARCHAR(40), sort_order INT DEFAULT 0, INDEX (creator_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $conn->exec("CREATE TABLE IF NOT EXISTS cbd_brands ( id INT AUTO_INCREMENT PRIMARY KEY, company VARCHAR(160) NOT NULL, contact_name VARCHAR(120), email VARCHAR(160) UNIQUE NOT NULL, phone VARCHAR(40), pw_hash VARCHAR(255), verified TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $conn->exec("CREATE TABLE IF NOT EXISTS cbd_briefs ( id INT AUTO_INCREMENT PRIMARY KEY, creator_slug VARCHAR(80), brand_id INT NULL, brand_name VARCHAR(160), brand_email VARCHAR(160), budget_zar VARCHAR(60), deliverable VARCHAR(120), brief_body TEXT, status ENUM('new','quoted','accepted','rejected','closed') DEFAULT 'new', store_buddy_notes TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, INDEX (creator_slug), INDEX (status) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $conn->exec("CREATE TABLE IF NOT EXISTS cbd_deals ( id INT AUTO_INCREMENT PRIMARY KEY, brief_id INT, creator_id INT, brand_id INT, gross_zar DECIMAL(12,2), commission_pct DECIMAL(5,2) DEFAULT 15.00, creator_payout DECIMAL(12,2), status ENUM('quoted','deposit_pending','deposit_received','delivered','paid','cancelled') DEFAULT 'quoted', created_at DATETIME DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Banking settings (key/value) — single row for KS bank details shown to brands $conn->exec("CREATE TABLE IF NOT EXISTS cbd_settings ( k VARCHAR(60) PRIMARY KEY, v TEXT ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); // Idempotent column adds for deposit tracking on briefs (silent if exists) foreach ([ "ALTER TABLE cbd_briefs ADD COLUMN quote_zar VARCHAR(40) NULL", "ALTER TABLE cbd_briefs ADD COLUMN deposit_received TINYINT(1) DEFAULT 0", "ALTER TABLE cbd_briefs ADD COLUMN deposit_date DATE NULL", "ALTER TABLE cbd_briefs ADD COLUMN deposit_ref VARCHAR(80) NULL", ] as $sql) { try { $conn->exec($sql); } catch (Throwable $e) {} } // Seed default banking details if empty $bcount = (int)$conn->query("SELECT COUNT(*) FROM cbd_settings WHERE k LIKE 'bank_%'")->fetchColumn(); if ($bcount === 0) { $bdefaults = [ 'bank_account_name' => 'Kronos Sqwasha (Pty) Ltd', 'bank_name' => 'FNB', 'bank_account_no' => '— set in Buddy Desk —', 'bank_branch_code' => '250655', 'bank_account_type' => 'Business Cheque', 'bank_ref_format' => 'CBD-{BRIEF_ID}', 'bank_swift' => 'FIRNZAJJ', ]; $bs = $conn->prepare("INSERT INTO cbd_settings (k,v) VALUES (?,?)"); foreach ($bdefaults as $k => $v) $bs->execute([$k,$v]); } $count = (int)$conn->query("SELECT COUNT(*) FROM cbd_creators")->fetchColumn(); if ($count === 0) { $stmt = $conn->prepare("INSERT INTO cbd_creators (slug,stage_name,real_name,label,vertical,base_location,languages, tagline,lede,pull_quote,cover_label,issue_no,issue_date,verified,featured) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,1,1)"); $stmt->execute([ 'father-tp','Father TP','TP','Kronos Sqwasha', 'Music · Afro / Venda Fusion','Kempton Park · Louis Trichardt', 'Tshivenda, English, isiZulu, Sepedi', 'A label, an artist, a movement north from Limpopo to Cairo and back.', 'Father TP isn\'t chasing a sound. He\'s tracing one — a family ledger of language, river-crossings and Bantu memory pressed into eighteen songs. Kronos Sqwasha is the imprint. Venda Namusi is the canvas. The continent is the studio.', 'We are not worshipping downstream. We are walking back to the source.', 'COVER FEATURE','001','MAY · MMXXVI' ]); $cid = (int)$conn->lastInsertId(); $ps = $conn->prepare("INSERT INTO cbd_platforms (creator_id,platform,handle,metric,unit,last_sync) VALUES (?,?,?,?,?,CURDATE())"); foreach ([ ['YOUTUBE','@fathertp','48.2K','subscribers'], ['SPOTIFY','@kronossqwasha','12.7K','monthly listeners'], ['TIKTOK','@fathertp_za','94.5K','followers'], ['INSTAGRAM','@kronos.sqwasha','21.8K','followers'], ] as $p) $ps->execute(array_merge([$cid], $p)); $as = $conn->prepare("INSERT INTO cbd_audience (creator_id,bucket,label,pct) VALUES (?,?,?,?)"); foreach ([ ['geo','SOUTH AFRICA',71],['geo','ZIMBABWE',9],['geo','BOTSWANA',6],['geo','NAMIBIA',4],['geo','UK & DIASPORA',10], ['age','13–17',8],['age','18–24',31],['age','25–34',38],['age','35–44',17],['age','45+',6], ] as $a) $as->execute(array_merge([$cid], $a)); $rs = $conn->prepare("INSERT INTO cbd_reel (creator_id,track_no,title,season,role,length,sort_order) VALUES (?,?,?,?,?,?,?)"); foreach ([ ['01','Gogo\'s Gate','S1','Vocals · Writer · Producer','3:42',1], ['02','Pamberi (Beitbridge)','S2','Vocals · Writer','4:11',2], ['03','Zikomo, Lusaka','S3','Vocals · Writer','3:28',3], ['04','Aubrey at the Lake','S4','Vocals · Co-prod','4:55',4], ['05','Two Rivers, Khartoum','S8','Vocals · Writer','5:20',5], ] as $r) $rs->execute(array_merge([$cid], $r)); $ws = $conn->prepare("INSERT INTO cbd_past_work (creator_id,brand,kind,year) VALUES (?,?,?,?)"); foreach ([ ['MTN South Africa','Brand Track','2025'], ['Castle Lite','Event Feature','2025'], ['SAA Voyager','TikTok Campaign','2024'], ['Pick n Pay','IG Reel Series','2024'], ] as $w) $ws->execute(array_merge([$cid], $w)); $rts = $conn->prepare("INSERT INTO cbd_rates (creator_id,line_item,zar,sort_order) VALUES (?,?,?,?)"); foreach ([ ['Branded Track (3:00–3:30)','R 85 000',1], ['Feature Verse (16 bars)','R 28 000',2], ['TikTok Original Post','R 12 500',3], ['Instagram Reel + Story Set','R 14 000',4], ['Live Event Booking (≤45 min)','R 65 000',5], ['Quarterly Ambassadorship','POA',6], ] as $rt) $rts->execute(array_merge([$cid], $rt)); $es = $conn->prepare("INSERT INTO cbd_creators (slug,stage_name,real_name,label,vertical,base_location,languages,tagline,lede,pull_quote,cover_label,issue_no,issue_date,verified,featured) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); foreach ([ ['naledi-m','Naledi M.','Naledi Mokoena','Independent','Fashion · Streetwear','Johannesburg','English, Sesotho','Streetwear stylist with a soft spot for Sotho geometry.','','','COVER 002','002','MAY · MMXXVI',1,0], ['the-grootman','The Grootman','Sipho N.','Grootman Media','Comedy · Sketch','Cape Town','English, isiXhosa','Township observational comedy, two-million-strong on TikTok.','','','ROSTER','003','MAY · MMXXVI',1,0], ] as $ex) $es->execute($ex); $bootstrap_msg = 'Database bootstrapped · Father TP + 2 placeholder creators seeded.'; } } catch (Throwable $e) { $bootstrap_msg = 'Bootstrap error: ' . $e->getMessage(); } } // ═══════════════════════════════════════════════════════════════ // ROUTER // ═══════════════════════════════════════════════════════════════ $page = $_GET['p'] ?? 'roster'; $slug = $_GET['slug'] ?? 'father-tp'; $admin_authed = isset($_GET['key']) && $_GET['key'] === 'reelrosters2024'; // ═══════════════════════════════════════════════════════════════ // POST HANDLERS // ═══════════════════════════════════════════════════════════════ $flash = null; if ($_SERVER['REQUEST_METHOD']==='POST' && isset($_POST['brand_register'])) { $company = trim($_POST['company'] ?? ''); $name = trim($_POST['contact_name'] ?? ''); $email = filter_var($_POST['email'] ?? '', FILTER_VALIDATE_EMAIL); $pw = $_POST['password'] ?? ''; if ($conn && $company && $email && strlen($pw) >= 6) { try { $stmt = $conn->prepare("INSERT INTO cbd_brands (company,contact_name,email,pw_hash) VALUES (?,?,?,?)"); $stmt->execute([$company,$name,$email,password_hash($pw,PASSWORD_DEFAULT)]); $_SESSION['brand_id'] = (int)$conn->lastInsertId(); $_SESSION['brand_company'] = $company; $flash = ['ok','Brand account created. Rate cards unlocked.']; $page = 'roster'; } catch (Throwable $e) { $flash = ['err','Email already registered or DB error.']; } } else $flash = ['err','Complete all fields, password min 6 chars.']; } if ($_SERVER['REQUEST_METHOD']==='POST' && isset($_POST['brand_login'])) { $email = filter_var($_POST['email'] ?? '', FILTER_VALIDATE_EMAIL); $pw = $_POST['password'] ?? ''; if ($conn && $email) { $stmt = $conn->prepare("SELECT * FROM cbd_brands WHERE email=? LIMIT 1"); $stmt->execute([$email]); $b = $stmt->fetch(); if ($b && password_verify($pw, $b['pw_hash'])) { $_SESSION['brand_id'] = (int)$b['id']; $_SESSION['brand_company'] = $b['company']; $flash = ['ok','Welcome back, '.$b['company'].'.']; $page = 'roster'; } else $flash = ['err','Invalid credentials.']; } } if (isset($_GET['logout'])) { session_destroy(); session_start(); $flash = ['ok','Logged out.']; } if ($_SERVER['REQUEST_METHOD']==='POST' && isset($_POST['drop_brief'])) { $cslug = trim($_POST['creator_slug'] ?? 'father-tp'); $brand = trim($_POST['brand_name'] ?? ($_SESSION['brand_company'] ?? '')); $email = filter_var($_POST['brand_email'] ?? '', FILTER_VALIDATE_EMAIL); $budget = trim($_POST['budget'] ?? ''); $deliver = trim($_POST['deliverable'] ?? ''); $brief = trim($_POST['brief'] ?? ''); if ($brand && $email && $brief && $conn) { try { $stmt = $conn->prepare("INSERT INTO cbd_briefs (creator_slug,brand_id,brand_name,brand_email,budget_zar,deliverable,brief_body) VALUES (?,?,?,?,?,?,?)"); $stmt->execute([$cslug, $_SESSION['brand_id'] ?? null, $brand, $email, $budget, $deliver, $brief]); $new_brief_id = (int)$conn->lastInsertId(); $_SESSION['last_brief_ref'] = 'CBD-' . str_pad($new_brief_id, 5, '0', STR_PAD_LEFT); $flash = ['ok','Brief #'.$_SESSION['last_brief_ref'].' received. Your Store Buddy will email a quote within 24h. Once you accept, EFT details follow.']; } catch (Throwable $e) { $flash = ['err','Could not save brief: '.$e->getMessage()]; } } else $flash = ['err','Please complete brand, email and brief.']; } if ($admin_authed && $_SERVER['REQUEST_METHOD']==='POST' && isset($_POST['update_brief'])) { $bid = (int)$_POST['brief_id']; $status = $_POST['status'] ?? 'new'; $notes = trim($_POST['notes'] ?? ''); $quote = trim($_POST['quote_zar'] ?? ''); $dep = !empty($_POST['deposit_received']) ? 1 : 0; $dep_ref = trim($_POST['deposit_ref'] ?? ''); $dep_date = $dep ? date('Y-m-d') : null; $conn->prepare("UPDATE cbd_briefs SET status=?, store_buddy_notes=?, quote_zar=?, deposit_received=?, deposit_ref=?, deposit_date=? WHERE id=?") ->execute([$status,$notes,$quote,$dep,$dep_ref,$dep_date,$bid]); $flash = ['ok','Brief #'.$bid.' updated.']; } if ($admin_authed && $_SERVER['REQUEST_METHOD']==='POST' && isset($_POST['update_banking'])) { $fields = ['bank_account_name','bank_name','bank_account_no','bank_branch_code','bank_account_type','bank_ref_format','bank_swift']; $up = $conn->prepare("INSERT INTO cbd_settings (k,v) VALUES (?,?) ON DUPLICATE KEY UPDATE v=VALUES(v)"); foreach ($fields as $f) $up->execute([$f, trim($_POST[$f] ?? '')]); $flash = ['ok','Banking details saved.']; } // Load banking settings $bank = []; if ($conn) { foreach ($conn->query("SELECT k,v FROM cbd_settings WHERE k LIKE 'bank_%'") as $row) { $bank[$row['k']] = $row['v']; } } // ═══════════════════════════════════════════════════════════════ // DATA FETCH // ═══════════════════════════════════════════════════════════════ function fetch_creator($conn, $slug) { if (!$conn) return null; $stmt = $conn->prepare("SELECT * FROM cbd_creators WHERE slug=? LIMIT 1"); $stmt->execute([$slug]); $c = $stmt->fetch(); if (!$c) return null; $cid = $c['id']; $c['platforms'] = $conn->query("SELECT * FROM cbd_platforms WHERE creator_id=$cid")->fetchAll(); $c['geo'] = $conn->query("SELECT * FROM cbd_audience WHERE creator_id=$cid AND bucket='geo'")->fetchAll(); $c['age'] = $conn->query("SELECT * FROM cbd_audience WHERE creator_id=$cid AND bucket='age'")->fetchAll(); $c['reel'] = $conn->query("SELECT * FROM cbd_reel WHERE creator_id=$cid ORDER BY sort_order")->fetchAll(); $c['past'] = $conn->query("SELECT * FROM cbd_past_work WHERE creator_id=$cid")->fetchAll(); $c['rates'] = $conn->query("SELECT * FROM cbd_rates WHERE creator_id=$cid ORDER BY sort_order")->fetchAll(); return $c; } $all_creators = $conn ? $conn->query("SELECT * FROM cbd_creators ORDER BY featured DESC, id ASC")->fetchAll() : []; $creator = ($page==='creator') ? fetch_creator($conn, $slug) : null; $brand_authed = !empty($_SESSION['brand_id']); $brand_company = $_SESSION['brand_company'] ?? null; function e($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } ?> ReelRosters · CBD · Roster Magazine<?= $creator ? ' · '.e($creator['stage_name']) : '' ?>

REELROSTERS CBD · Roster Magazine

Vol. I·MAY · MMXXVI

Logout Brand Login →

DB unavailable — running in display-only mode. Check includes/db.php

Vol. I · Iss. 001 · MAY MMXXVI

The Roster.

A working magazine of South Africa's most bookable creators. Read the pages, drop a brief — your Store Buddy handles the rest.

$cr): ?>

N°

Verified Featured

Read →

Roster initialising…

Refresh once to seed creators.

For Brands

Pick a tier.

All deals brokered by your dedicated Store Buddy. Direct EFT into the Kronos Sqwasha holding account. 15% brokerage on every closed deal.

'Browse','zar'=>'Free','sub'=>'For first-time brands','features'=>['Read all profiles','See public stats','1 brief / month','Buddy reply 48h']], ['name'=>'Pro','zar'=>'R 1 850 /mo','sub'=>'Most popular','features'=>['Unlock all rate cards','Unlimited briefs','Buddy reply 24h','Campaign dashboard','Direct EFT escrow']], ['name'=>'Agency','zar'=>'R 4 500 /mo','sub'=>'5 brand seats','features'=>['Everything in Pro','5 seats','Multi-creator campaigns','Quarterly market report','Dedicated Buddy']], ]; foreach ($tiers as $i => $t): ?>

Choose

· ISS. ·

Verified Roster

A imprint ·

/ FRAME 01

Portrait · Studio Kronos

§ I — The Lede

“”

—

Stage Name

Label

Based

Languages

§ II — The Numbers

Reach, verified.

Audited monthly · Last sync

$p): $acc = ['num-accent','num-accent3','num-accent2',''][$i % 4]; ?>

§ III — The Roster

Who's
listening.

Geo and age fingerprint pulled from owned channels.

By Geography

By Age Cohort

§ IV — The Reel

Selected
discography.

§ V — Receipts

Brands
in the rolodex.

§ VI — Rate Card

The numbers
at the door.

Indicative ZAR · Excl. VAT · Brokered by Store Buddy

Rates available to verified brands.

Create a brand account to unlock the full rate card.

Create Brand Account

§ — The Flow

How a deal closes.

Manual EFT escrow · No payment gateway · Funds held by Kronos Sqwasha until delivery

$s): ?>

§ VII — Store Buddy

Drop the
brief.

Skip the DM hunt. Your Store Buddy receives, qualifies and routes the deal — quote inside 24 hours. Once you accept, EFT the agreed amount into the Kronos Sqwasha holding account. Funds are released to the creator only on delivery and your sign-off.

Quote SLA

15%

Brokerage

EFT

Direct Escrow

Brand / Agency

Work Email

Indicative Budget (ZAR)

Deliverable

The Brief

By submitting, you agree to ReelRosters CBD Store Buddy terms. Your Buddy is bound by NDA.

Creator not found.

Back to Roster

For Brands & Agencies

Unlock the roster.

One account. Every rate card. A Store Buddy on the other end of every brief.

Unlock full rate cards on every creator
Unlimited briefs · 24h quote SLA
Direct EFT escrow · KS holds funds until delivery
Campaign dashboard

Create Account

Buddy Desk · Auth Required

Locked.

query("SELECT * FROM cbd_briefs ORDER BY created_at DESC LIMIT 100")->fetchAll() : []; $brands = $conn ? $conn->query("SELECT * FROM cbd_brands ORDER BY created_at DESC LIMIT 50")->fetchAll() : []; $stats = [ 'creators' => count($all_creators), 'briefs_total' => $conn ? (int)$conn->query("SELECT COUNT(*) FROM cbd_briefs")->fetchColumn() : 0, 'briefs_new' => $conn ? (int)$conn->query("SELECT COUNT(*) FROM cbd_briefs WHERE status='new'")->fetchColumn() : 0, 'brands' => count($brands), ]; ?>

Store Buddy Desk

Operations.

Authed ·

$s): ?>

Brief Queue

No briefs yet.

For:

Budget:

Deliv:

Deposit Received

Banking Details · KS Holding

These are the EFT details emailed to brands once they accept a quote. Update once, used everywhere.

Brand Accounts

No brands registered.