' . h($h1) . '

' . $rightHtml . '

'; if ($m = flash('ok')) echo '

' . h($m) . '

'; if ($m = flash('err')) echo '

' . h($m) . '

'; } function admin_foot() { ?>

query("SELECT id, domain, company_name, is_active FROM sites ORDER BY company_name")->fetchAll(); return $s; } /** The sites a vehicle is published on. */ function vehicle_site_ids($vehicleId) { $st = db()->prepare("SELECT site_id FROM vehicle_sites WHERE vehicle_id = ?"); $st->execute([$vehicleId]); return array_map('intval', $st->fetchAll(PDO::FETCH_COLUMN)); } /** Replace a vehicle's site links with the ticked boxes. */ function set_vehicle_sites($vehicleId, array $siteIds) { $valid = array_column(all_sites(), 'id'); $siteIds = array_values(array_unique(array_intersect(array_map('intval', $siteIds), array_map('intval', $valid)))); db()->prepare("DELETE FROM vehicle_sites WHERE vehicle_id = ?")->execute([$vehicleId]); if (!$siteIds) return; $ins = db()->prepare("INSERT INTO vehicle_sites (vehicle_id, site_id) VALUES (?, ?)"); foreach ($siteIds as $sid) $ins->execute([$vehicleId, $sid]); } /** The sites a review is published on. */ function review_site_ids($reviewId) { $st = db()->prepare("SELECT site_id FROM review_sites WHERE review_id = ?"); $st->execute([$reviewId]); return array_map('intval', $st->fetchAll(PDO::FETCH_COLUMN)); } /** Replace a review's site links with the ticked boxes. */ function set_review_sites($reviewId, array $siteIds) { $valid = array_map('intval', array_column(all_sites(), 'id')); $siteIds = array_values(array_unique(array_intersect(array_map('intval', $siteIds), $valid))); db()->prepare("DELETE FROM review_sites WHERE review_id = ?")->execute([$reviewId]); if (!$siteIds) return; $ins = db()->prepare("INSERT INTO review_sites (review_id, site_id) VALUES (?, ?)"); foreach ($siteIds as $sid) $ins->execute([$reviewId, $sid]); } /** Renders the "which sites" checkbox grid. $checked is an array of site ids. */ function site_checkboxes(array $checked, $name = 'sites') { if (!all_sites()) { echo '

There are no sites yet. Add the first site.

'; return; } ?>

?" : "") . " LIMIT 1"; $st = db()->prepare($sql); $st->execute($ignoreId ? [$slug, $ignoreId] : [$slug]); if (!$st->fetch()) return $slug; $slug = $base . '-' . $i; } return $base . '-' . uniqid(); }