'; echo '

Status page temporarily unavailable

'; echo '

We could not reach the status database. Try again in a minute.

'; exit; } /** * Every DATETIME in the status_* tables is UTC (DB server tz). This page's * PHP tz is Pacific/Auckland, so a bare strtotime() misreads DB values by * the NZ offset — always render through nzTime(). */ function nzTime(?string $utc, string $fmt = 'M j, g:ia'): string { if (!$utc) return ''; try { return (new DateTime($utc, new DateTimeZone('UTC'))) ->setTimezone(new DateTimeZone('Pacific/Auckland'))->format($fmt); } catch (Throwable $e) { return (string)$utc; } } /** Epoch seconds for a UTC DB datetime (safe cousin of strtotime for these tables). */ function utcTs(?string $utc): int { if (!$utc) return 0; try { return (new DateTime($utc, new DateTimeZone('UTC')))->getTimestamp(); } catch (Throwable $e) { return 0; } } /** "in 2 days" / "in 3 hours" for a future UTC datetime. */ function nzRel(?string $utc): string { $d = utcTs($utc) - time(); if ($d <= 0) return 'now'; if ($d < 3600) { $m = max(1, (int)floor($d / 60)); return "in $m minute" . ($m === 1 ? '' : 's'); } if ($d < 86400) { $h = (int)floor($d / 3600); return "in $h hour" . ($h === 1 ? '' : 's'); } $days = (int)floor($d / 86400); return "in $days day" . ($days === 1 ? '' : 's'); } function statusDecodeAffected(?string $json): array { if ($json === null || $json === '') return []; $arr = json_decode($json, true); return is_array($arr) ? array_values(array_filter(array_map('strval', $arr))) : []; } /** * Operator-typed body text → tidy HTML. Trims stray indentation, collapses * runs of blank lines to a single paragraph gap, then converts newlines to *
. Pair with normal white-space (NOT pre-wrap — combining pre-wrap with * nl2br doubles every line break, which is how the page ended up with huge * gaps between sentences). */ function bodyHtml(?string $text): string { $text = trim((string)$text); $text = preg_replace('/[^\S\r\n]*\R[^\S\r\n]*/', "\n", $text); // strip per-line indent $text = preg_replace('/\n{3,}/', "\n\n", $text); // max one blank line return nl2br(htmlspecialchars($text)); } $nowUtc = gmdate('Y-m-d H:i:s'); $services = $db->query( "SELECT * FROM status_services ORDER BY sort_order, name" )->fetchAll(PDO::FETCH_ASSOC); // Page-level global banner, managed from CC → Status. Tolerates the // status_page_settings migration not having landed yet. $pageBanner = ['enabled' => false, 'style' => 'maintenance', 'title' => '', 'message' => '']; try { $kv = []; foreach ($db->query("SELECT name, value FROM status_page_settings") as $r) { $kv[$r['name']] = (string)($r['value'] ?? ''); } $pageBanner['style'] = in_array(($kv['banner_style'] ?? ''), ['info', 'maintenance', 'warning', 'critical'], true) ? $kv['banner_style'] : 'maintenance'; $pageBanner['title'] = trim($kv['banner_title'] ?? ''); $pageBanner['message'] = trim($kv['banner_message'] ?? ''); $pageBanner['enabled'] = ($kv['banner_enabled'] ?? '0') === '1' && ($pageBanner['title'] !== '' || $pageBanner['message'] !== ''); } catch (Throwable $e) { // Pre-migration DB — no banner. } // Scheduled maintenance windows whose start hasn't arrived render under // "Upcoming maintenance"; everything else unresolved is an active incident. // Falls back to the legacy query while the scheduled_for migration is pending. $hasSchedule = true; $upcoming = []; try { $stmt = $db->prepare( "SELECT * FROM status_incidents WHERE published = 1 AND resolved_at IS NULL AND state = 'scheduled' AND scheduled_for IS NOT NULL AND scheduled_for > :now ORDER BY scheduled_for ASC" ); $stmt->execute([':now' => $nowUtc]); $upcoming = $stmt->fetchAll(PDO::FETCH_ASSOC); $stmt = $db->prepare( "SELECT * FROM status_incidents WHERE published = 1 AND resolved_at IS NULL AND NOT (state = 'scheduled' AND scheduled_for IS NOT NULL AND scheduled_for > :now) ORDER BY started_at DESC" ); $stmt->execute([':now' => $nowUtc]); $openIncidents = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (Throwable $e) { $hasSchedule = false; $openIncidents = $db->query( "SELECT * FROM status_incidents WHERE published = 1 AND resolved_at IS NULL ORDER BY started_at DESC" )->fetchAll(PDO::FETCH_ASSOC); } $pastIncidents = $db->query( "SELECT * FROM status_incidents WHERE published = 1 AND resolved_at IS NOT NULL ORDER BY resolved_at DESC LIMIT 20" )->fetchAll(PDO::FETCH_ASSOC); $updatesByIncident = []; $allIds = array_map(fn($r) => (int)$r['id'], array_merge($openIncidents, $pastIncidents)); if ($allIds) { $place = implode(',', array_fill(0, count($allIds), '?')); $stmt = $db->prepare( "SELECT * FROM status_incident_updates WHERE incident_id IN ($place) ORDER BY created_at DESC" ); $stmt->execute($allIds); foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $u) { $updatesByIncident[(int)$u['incident_id']][] = $u; } } // Service state → public-facing label + colour bucket. $stateMap = [ 'operational' => ['label' => 'Operational', 'class' => 'op', 'dot' => 'op'], 'degraded' => ['label' => 'Degraded performance','class' => 'wn', 'dot' => 'wn'], 'partial_outage' => ['label' => 'Partial outage', 'class' => 'er', 'dot' => 'er'], 'major_outage' => ['label' => 'Major outage', 'class' => 'er', 'dot' => 'er'], 'maintenance' => ['label' => 'Maintenance', 'class' => 'mt', 'dot' => 'mt'], ]; $severityRank = [ 'operational' => 0, 'maintenance' => 1, 'degraded' => 2, 'partial_outage' => 3, 'major_outage' => 4, ]; // Mirror the CC's lazy schedule transitions display-side, so this page is // truthful even when the CC hasn't been opened to persist them: // * window started but row still 'scheduled' → show as in progress // * window ended but row not yet 'completed' → show under history // While a window is active, its affected services render as Maintenance // below (unless their stored status is already worse) — and revert on // their own the moment the window closes. No cron, no stuck colours. $maintNowKeys = []; if ($hasSchedule) { $stillOpen = []; foreach ($openIncidents as $inc) { $for = $inc['scheduled_for'] ?? null; $until = $inc['scheduled_until'] ?? null; if ($for !== null && $until !== null && $until <= $nowUtc && in_array($inc['state'], ['scheduled', 'in_progress'], true)) { $inc['state'] = 'completed'; $inc['started_at'] = $for; // not creation time — real window start $inc['resolved_at'] = $until; array_unshift($pastIncidents, $inc); continue; } if ($for !== null && $for <= $nowUtc && $inc['state'] === 'scheduled') { $inc['state'] = 'in_progress'; $inc['started_at'] = $for; } if ($for !== null && $for <= $nowUtc && ($until === null || $until > $nowUtc) && $inc['state'] === 'in_progress') { foreach (statusDecodeAffected($inc['affected_services'] ?? null) as $k) { $maintNowKeys[$k] = true; } } $stillOpen[] = $inc; } $openIncidents = $stillOpen; foreach ($services as &$svc) { if (isset($maintNowKeys[$svc['key_name']]) && ($severityRank[$svc['status']] ?? 0) < $severityRank['maintenance']) { $svc['status'] = 'maintenance'; } } unset($svc); } // Friendly names for affected-service chips on upcoming windows. $svcNameByKey = []; foreach ($services as $svc) { $svcNameByKey[$svc['key_name']] = $svc['name']; } /** * Build a 30-element map (oldest → today) of the worst state each service * was in on each of the last 30 days. Algorithm: * * * Find the state immediately before the window started (so day 1 has * a meaningful baseline even if no changes happened recently). * * Walk every change in the window in order, advancing a "current" state * pointer. For each day, the worst state seen during that day wins. * * Days with no row for the service in history still inherit the current * state — which is normally 'operational'. * * Days where the service didn't yet exist (created_at after that day) are * marked 'unknown' so the strip renders a muted segment rather than a * misleading green bar. */ function statusBuildHistoryStrip(PDO $db, int $serviceId, string $serviceCreatedAt, array $rank, int $days = 30): array { $tz = new DateTimeZone('UTC'); $today = (new DateTime('today', $tz)); $windowAt = (clone $today)->modify('-' . ($days - 1) . ' days')->setTime(0, 0); // Most recent change strictly before the window — establishes the // baseline state walking into day 1 of the strip. $prior = $db->prepare( "SELECT status FROM status_service_history WHERE service_id = :id AND changed_at < :cut ORDER BY changed_at DESC LIMIT 1" ); $prior->execute([':id' => $serviceId, ':cut' => $windowAt->format('Y-m-d H:i:s')]); $current = (string)($prior->fetchColumn() ?: 'operational'); // All changes during the window. $during = $db->prepare( "SELECT status, changed_at FROM status_service_history WHERE service_id = :id AND changed_at >= :cut ORDER BY changed_at" ); $during->execute([':id' => $serviceId, ':cut' => $windowAt->format('Y-m-d H:i:s')]); $changes = $during->fetchAll(PDO::FETCH_ASSOC); $createdAt = $serviceCreatedAt ? new DateTime($serviceCreatedAt, $tz) : null; $strip = []; $i = 0; for ($d = 0; $d < $days; $d++) { $dayStart = (clone $windowAt)->modify("+$d days"); $dayEnd = (clone $dayStart)->modify('+1 day'); // If the service didn't exist yet for the whole of this day, // render a muted segment rather than falsely green. if ($createdAt && $createdAt >= $dayEnd) { $strip[] = ['date' => $dayStart->format('Y-m-d'), 'state' => 'unknown']; continue; } $worst = $current; while ($i < count($changes)) { $rowAt = new DateTime($changes[$i]['changed_at'], $tz); if ($rowAt < $dayEnd) { if (($rank[$changes[$i]['status']] ?? 0) > ($rank[$worst] ?? 0)) { $worst = $changes[$i]['status']; } $current = $changes[$i]['status']; $i++; } else { break; } } $strip[] = ['date' => $dayStart->format('Y-m-d'), 'state' => $worst]; } return $strip; } // Build the per-service strips in a single pass. $historyByService = []; foreach ($services as $svc) { $historyByService[(int)$svc['id']] = statusBuildHistoryStrip( $db, (int)$svc['id'], (string)($svc['created_at'] ?? ''), $severityRank ); } // An active maintenance window only exists in status_incidents — the strip is // built from status_service_history, which never hears about it. Paint today's // segment blue for affected services so the badge and the strip agree (and the // uptime %, which excludes maintenance days, stays honest). if ($maintNowKeys) { foreach ($services as $svc) { if (!isset($maintNowKeys[$svc['key_name']])) continue; $sid = (int)$svc['id']; if (empty($historyByService[$sid])) continue; $lastIdx = count($historyByService[$sid]) - 1; $seg = $historyByService[$sid][$lastIdx]; if (($severityRank[$seg['state']] ?? 0) < $severityRank['maintenance']) { $historyByService[$sid][$lastIdx]['state'] = 'maintenance'; } } } $overall = 'operational'; foreach ($services as $s) { if (($severityRank[$s['status']] ?? 0) > ($severityRank[$overall] ?? 0)) { $overall = $s['status']; } } // Header banner copy + colour $bannerCopy = [ 'operational' => ['title' => 'All systems operational', 'sub' => 'Everything is running normally.'], 'maintenance' => ['title' => 'Scheduled maintenance', 'sub' => 'A planned maintenance window is in effect.'], 'degraded' => ['title' => 'Some services degraded', 'sub' => 'We\'ve seen reduced performance on one or more services.'], 'partial_outage' => ['title' => 'Partial outage in progress', 'sub' => 'A subset of services is currently unavailable.'], 'major_outage' => ['title' => 'Major outage in progress', 'sub' => 'We\'re working on a critical incident right now.'], ]; $banner = $bannerCopy[$overall]; // Service icon → boxicons class $iconMap = [ 'globe' => 'bx-globe', 'layout' => 'bx-layout', 'database' => 'bx-data', 'shopping-bag' => 'bxs-shopping-bag', 'mail' => 'bx-envelope', 'image' => 'bx-image-alt', 'sparkles' => 'bx-bot', 'shield' => 'bx-shield-quarter', 'server' => 'bx-server', ]; header('Cache-Control: no-cache, no-store, must-revalidate, max-age=0'); $_host = $_SERVER['HTTP_HOST'] ?? 'onplattr.com'; $_base = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? 'https' : 'http') . '://' . $_host; ?> Plattr — Status
'bx-info-circle', 'maintenance' => 'bx-wrench', 'warning' => 'bx-error', 'critical' => 'bx-error-circle', ][$pageBanner['style']]; ?>

Service status

Updated
Auto-refresh every 60 seconds

Active incidents

open
Started NZT $nowUtc): ?> Expected until NZT

Upcoming maintenance

scheduled
Maintenance → NZT Starts · about

Services

All times NZT (Pacific/Auckland)
0 ? round(100 * $okDays / $ratedDays, $okDays === $ratedDays ? 0 : 2) : null; ?>
“”
30 days ago % uptime Today

Incident history

Last
No incidents to report Smooth sailing on every service. We'll post here the moment something needs attention.
No past incidents in the recent window Resolved incidents appear here for transparency.
· resolved in