prepare("SELECT * FROM sites WHERE id = ? LIMIT 1"); $st->execute([$id]); $site = $st->fetch(); if (!$site) { flash('err', 'Site not found.'); redirect('sites.php'); } } if ($_SERVER['REQUEST_METHOD'] === 'POST') { csrf_check(); $domain = strtolower(trim(e_post('domain'))); $domain = preg_replace('#^https?://#i', '', $domain); $domain = preg_replace('#^www\.#', '', $domain); $domain = preg_replace('#[/:].*$#', '', $domain); $company = e_post('company_name'); if ($domain === '' || $company === '') { flash('err', 'Domain and company name are required.'); } else { $dup = db()->prepare("SELECT id FROM sites WHERE domain = ?" . ($id ? " AND id <> ?" : "") . " LIMIT 1"); $dup->execute($id ? [$domain, $id] : [$domain]); if ($dup->fetch()) { flash('err', 'Domain "' . $domain . '" is already used by another site.'); } else { $fields = [ 'domain' => $domain, 'company_name' => $company, 'company_short_name' => e_post('company_short_name'), 'company_number' => e_post('company_number'), 'year_founded' => e_post('year_founded') !== '' ? (int)e_post('year_founded') : null, 'theme_color' => preg_match('/^#[0-9a-fA-F]{6}$/', e_post('theme_color')) ? e_post('theme_color') : '#0d6efd', 'contact_email' => e_post('contact_email'), 'contact_phone' => e_post('contact_phone'), 'address_line1' => e_post('address_line1'), 'address_line2' => e_post('address_line2'), 'city' => e_post('city'), 'postcode' => e_post('postcode'), 'country' => e_post('country') !== '' ? e_post('country') : 'United Kingdom', 'is_active' => isset($_POST['is_active']) ? 1 : 0, ]; $logo = upload_image('logo', __DIR__ . '/../uploads/logos', 'logo'); if ($logo) { if ($site && !empty($site['logo_path'])) { $old = __DIR__ . '/../uploads/logos/' . basename($site['logo_path']); if (is_file($old)) @unlink($old); } $fields['logo_path'] = $logo; } if ($id) { $set = implode(', ', array_map(fn($k) => "$k = ?", array_keys($fields))); db()->prepare("UPDATE sites SET $set WHERE id = ?")->execute([...array_values($fields), $id]); flash('ok', 'Site updated.'); } else { $cols = implode(', ', array_keys($fields)); $ph = implode(', ', array_fill(0, count($fields), '?')); db()->prepare("INSERT INTO sites ($cols) VALUES ($ph)")->execute(array_values($fields)); $id = (int)db()->lastInsertId(); flash('ok', 'Site created. Download its satellite file from the list and upload it to that domain\'s hosting.'); } redirect('sites.php'); } } } $val = function ($k, $d = '') use ($site) { return $site[$k] ?? $d; }; admin_head($id ? 'Edit site' : 'New site'); admin_topbar($id ? 'Edit site' : 'New site', '← Back to sites'); ?>

Identity

Contact and address