// Irvine California · Command Center // One Cloudflare Worker: hosts the panel, keeps your ER:LC server key secret, // handles staff accounts (sign up → approval → role) and checks every action against the user's role. // // NEEDS (set in the Cloudflare dashboard, see setup steps in chat): // D1 database binding named DB // Secret ERLC_KEY = your ER:LC server key // Secret SETUP_CODE = any password you choose; needed once to create the Owner account const UPSTREAM = "https://api.policeroleplay.community/v1"; /* ---------------- permissions & default roles ---------------- */ const PERMS = [ { id: "view.dashboard", group: "View", label: "Overview, players, staff, vehicles & queue" }, { id: "view.modcalls", group: "View", label: "Mod calls" }, { id: "view.logs", group: "View", label: "Join, kill & command logs" }, { id: "view.bans", group: "View", label: "Ban list" }, { id: "cmd.message", group: "Commands", label: "Hints, messages & PMs (:h :m :pm)" }, { id: "cmd.moderate", group: "Commands", label: "Kill, refresh, jail, TP, heal, wanted" }, { id: "cmd.kick", group: "Commands", label: "Kick players" }, { id: "cmd.ban", group: "Commands", label: "Ban & unban players" }, { id: "cmd.server", group: "Commands", label: "Weather, time, peace timer, priority" }, { id: "cmd.staff", group: "Commands", label: "Give or remove in-game mod/admin" }, { id: "cmd.console", group: "Commands", label: "Any other command (free console)" }, { id: "users.manage", group: "Management", label: "Approve accounts & assign lower roles" }, { id: "roles.manage", group: "Management", label: "Create & edit roles" }, { id: "audit.view", group: "Management", label: "See the panel audit log" }, ]; const ALL = PERMS.map(p => p.id); const DEFAULT_ROLES = [ { id: "owner", name: "Owner", rank: 100, color: "#ffc36b", perms: ["*"], locked: 1 }, { id: "admin", name: "Admin", rank: 80, color: "#ff5e78", perms: ALL.filter(p => p !== "roles.manage") }, { id: "mod", name: "Moderator", rank: 60, color: "#9b5cff", perms: ["view.dashboard","view.modcalls","view.logs","view.bans","cmd.message","cmd.moderate","cmd.kick"] }, { id: "trial", name: "Trial Mod", rank: 40, color: "#2dd4bf", perms: ["view.dashboard","view.modcalls","view.logs","cmd.message","cmd.moderate"] }, { id: "viewer", name: "Viewer", rank: 10, color: "#8a96b2", perms: ["view.dashboard"] }, ]; const CMD_PERM = { h:"cmd.message", m:"cmd.message", pm:"cmd.message", kill:"cmd.moderate", refresh:"cmd.moderate", respawn:"cmd.moderate", jail:"cmd.moderate", unjail:"cmd.moderate", tp:"cmd.moderate", heal:"cmd.moderate", wanted:"cmd.moderate", unwanted:"cmd.moderate", load:"cmd.moderate", kick:"cmd.kick", ban:"cmd.ban", unban:"cmd.ban", pban:"cmd.ban", weather:"cmd.server", time:"cmd.server", pt:"cmd.server", prty:"cmd.server", startfire:"cmd.server", stopfire:"cmd.server", mod:"cmd.staff", unmod:"cmd.staff", admin:"cmd.staff", unadmin:"cmd.staff", helper:"cmd.staff", unhelper:"cmd.staff", }; const has = (perms, p) => perms.includes("*") || perms.includes(p); const permsOf = role => role ? (role.perms.includes("*") ? ["*", ...ALL] : role.perms) : []; /* ---------------- small helpers ---------------- */ const json = (obj, status = 200, extra = {}) => new Response(JSON.stringify(obj), { status, headers: { "Content-Type": "application/json", "Cache-Control": "no-store", ...extra } }); const err = (msg, status = 400, extra) => json({ error: msg, ...(extra || {}) }, status); const now = () => Math.floor(Date.now() / 1000); const enc = s => new TextEncoder().encode(s); const hex = buf => [...new Uint8Array(buf)].map(b => b.toString(16).padStart(2, "0")).join(""); const unhex = h => new Uint8Array(h.match(/../g).map(x => parseInt(x, 16))); const randHex = n => hex(crypto.getRandomValues(new Uint8Array(n))); const sha256 = async s => hex(await crypto.subtle.digest("SHA-256", enc(s))); function safeEq(a, b) { if (a.length !== b.length) return false; let r = 0; for (let i = 0; i < a.length; i++) r |= a.charCodeAt(i) ^ b.charCodeAt(i); return r === 0; } async function hashPw(pw, saltHex) { const salt = saltHex ? unhex(saltHex) : crypto.getRandomValues(new Uint8Array(16)); const key = await crypto.subtle.importKey("raw", enc(pw), "PBKDF2", false, ["deriveBits"]); const bits = await crypto.subtle.deriveBits({ name: "PBKDF2", hash: "SHA-256", salt, iterations: 100000 }, key, 256); return { hash: hex(bits), salt: hex(salt) }; } const cookie = (token, maxAge) => `sid=${token}; Path=/; HttpOnly; Secure; SameSite=Strict; Max-Age=${maxAge}`; const getCookie = (req, name) => (req.headers.get("Cookie") || "").split(/;\s*/).map(c => c.split("=")).find(([k]) => k === name)?.[1] || null; /* ---------------- database ---------------- */ let ready = false; async function init(db) { if (ready) return; await db.batch([ db.prepare(`CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE COLLATE NOCASE, roblox TEXT, discord TEXT, pass TEXT, salt TEXT, role TEXT, status TEXT, created INTEGER, approved_by TEXT, last_login INTEGER)`), db.prepare(`CREATE TABLE IF NOT EXISTS sessions (token TEXT PRIMARY KEY, user_id INTEGER, expires INTEGER)`), db.prepare(`CREATE TABLE IF NOT EXISTS roles (id TEXT PRIMARY KEY, name TEXT, rank INTEGER, color TEXT, perms TEXT, locked INTEGER DEFAULT 0)`), db.prepare(`CREATE TABLE IF NOT EXISTS audit (id INTEGER PRIMARY KEY AUTOINCREMENT, ts INTEGER, actor TEXT, action TEXT, detail TEXT)`), db.prepare(`CREATE TABLE IF NOT EXISTS attempts (k TEXT PRIMARY KEY, n INTEGER, reset INTEGER)`), ]); const { c } = await db.prepare("SELECT COUNT(*) AS c FROM roles").first(); if (!c) await db.batch(DEFAULT_ROLES.map(r => db.prepare("INSERT INTO roles (id,name,rank,color,perms,locked) VALUES (?,?,?,?,?,?)").bind(r.id, r.name, r.rank, r.color, JSON.stringify(r.perms), r.locked || 0))); ready = true; } async function roles(db) { const { results } = await db.prepare("SELECT * FROM roles ORDER BY rank DESC").all(); return results.map(r => ({ ...r, perms: JSON.parse(r.perms || "[]"), locked: !!r.locked })); } async function audit(db, actor, action, detail = "") { await db.prepare("INSERT INTO audit (ts,actor,action,detail) VALUES (?,?,?,?)").bind(now(), actor, action, String(detail).slice(0, 500)).run(); if (Math.random() < 0.02) await db.prepare("DELETE FROM audit WHERE id < (SELECT MAX(id) - 5000 FROM audit)").run(); } async function currentUser(req, db) { const t = getCookie(req, "sid"); if (!t) return null; const row = await db.prepare(`SELECT u.* FROM sessions s JOIN users u ON u.id = s.user_id WHERE s.token = ? AND s.expires > ?`).bind(await sha256(t), now()).first(); return row || null; } async function newSession(db, userId) { const t = randHex(32); await db.prepare("INSERT INTO sessions (token,user_id,expires) VALUES (?,?,?)").bind(await sha256(t), userId, now() + 7 * 86400).run(); if (Math.random() < 0.05) await db.prepare("DELETE FROM sessions WHERE expires < ?").bind(now()).run(); return t; } async function limited(db, key, max, windowSec) { const row = await db.prepare("SELECT * FROM attempts WHERE k = ?").bind(key).first(); if (!row || row.reset < now()) { await db.prepare("INSERT OR REPLACE INTO attempts (k,n,reset) VALUES (?,1,?)").bind(key, now() + windowSec).run(); return false; } if (row.n >= max) return true; await db.prepare("UPDATE attempts SET n = n + 1 WHERE k = ?").bind(key).run(); return false; } const publicUser = u => ({ id: u.id, username: u.username, roblox: u.roblox, discord: u.discord, role: u.role, status: u.status, created: u.created, approved_by: u.approved_by, last_login: u.last_login }); /* ---------------- ER:LC API (shared cache so many staff = few API calls) ---------------- */ const cache = new Map(); let lastCmdAt = 0; async function erlc(env, path, ttl) { const c = cache.get(path), t = Date.now(); if (c && c.exp > t) return c.p; const p = (async () => { const r = await fetch(UPSTREAM + path, { headers: { "Server-Key": env.ERLC_KEY, "Accept": "application/json" } }); const txt = await r.text(); let d = null; try { d = txt ? JSON.parse(txt) : null; } catch { d = null; } if (!r.ok) { const e = new Error((d && d.message) || `HTTP ${r.status}`); e.status = r.status; e.retry = d && d.retry_after; throw e; } return d; })(); cache.set(path, { p, exp: t + ttl * 1000 }); p.then(d => cache.set(path, { p: Promise.resolve(d), exp: t + ttl * 1000, last: d })) .catch(() => { const old = c && c.last; cache.set(path, { p: old !== undefined ? Promise.resolve(old) : p, exp: t + 5000, last: old }); }); return p; } /* ---------------- request handling ---------------- */ export default { async fetch(request, env, ctx) { const url = new URL(request.url), path = url.pathname, method = request.method; if (path === "/avatars") return avatars(url, ctx); if (!path.startsWith("/api/")) { return new Response(HTML, { headers: { "Content-Type": "text/html; charset=utf-8", "Cache-Control": "no-cache", "X-Frame-Options": "DENY", "Referrer-Policy": "no-referrer", "X-Content-Type-Options": "nosniff" } }); } if (!env.DB) return err("Setup isn't finished: add a D1 database binding named DB to this Worker.", 500); if (!env.ERLC_KEY) return err("Setup isn't finished: add the ERLC_KEY secret to this Worker.", 500); if (request.headers.get("X-Panel") !== "1") return err("Bad request", 400); // blocks cross-site form posts const db = env.DB; await init(db); const body = method === "POST" ? await request.json().catch(() => ({})) : {}; const ip = request.headers.get("CF-Connecting-IP") || "?"; try { /* ---- public ---- */ if (path === "/api/status") { const { c } = await db.prepare("SELECT COUNT(*) AS c FROM users").first(); return json({ needsSetup: !c }); } if (path === "/api/register" && method === "POST") { if (await limited(db, "reg:" + ip, 5, 3600)) return err("Too many sign-ups from your network. Try again later.", 429); const username = String(body.username || "").trim(), password = String(body.password || ""); const roblox = String(body.roblox || "").trim().slice(0, 40), discord = String(body.discord || "").trim().slice(0, 40); if (!/^[A-Za-z0-9_]{3,20}$/.test(username)) return err("Username must be 3–20 letters, numbers or underscores."); if (password.length < 8) return err("Password must be at least 8 characters."); if (!roblox) return err("Enter your Roblox username so staff know who you are."); const { c } = await db.prepare("SELECT COUNT(*) AS c FROM users").first(); const first = !c; if (first) { if (!env.SETUP_CODE) return err("Add a SETUP_CODE secret to the Worker before creating the Owner account.", 500); if (!safeEq(String(body.setupCode || ""), env.SETUP_CODE)) return err("Setup code is wrong.", 403); } if (await db.prepare("SELECT id FROM users WHERE username = ?").bind(username).first()) return err("That username is taken."); const { hash, salt } = await hashPw(password); const res = await db.prepare(`INSERT INTO users (username,roblox,discord,pass,salt,role,status,created,approved_by) VALUES (?,?,?,?,?,?,?,?,?)`) .bind(username, roblox, discord, hash, salt, first ? "owner" : null, first ? "active" : "pending", now(), first ? "setup" : null).run(); const id = res.meta.last_row_id; await audit(db, username, first ? "owner.created" : "account.requested", `Roblox: ${roblox}`); const t = await newSession(db, id); return json({ ok: true, status: first ? "active" : "pending" }, 200, { "Set-Cookie": cookie(t, 7 * 86400) }); } if (path === "/api/login" && method === "POST") { if (await limited(db, "login:" + ip, 10, 900)) return err("Too many login attempts. Wait 15 minutes.", 429); const u = await db.prepare("SELECT * FROM users WHERE username = ?").bind(String(body.username || "").trim()).first(); const { hash } = await hashPw(String(body.password || ""), u ? u.salt : "00".repeat(16)); if (!u || !safeEq(hash, u.pass)) return err("Wrong username or password.", 401); if (u.status === "denied") return err("Your access request was denied.", 403); if (u.status === "disabled") return err("Your account has been disabled.", 403); await db.prepare("UPDATE users SET last_login = ? WHERE id = ?").bind(now(), u.id).run(); const t = await newSession(db, u.id); return json({ ok: true, status: u.status }, 200, { "Set-Cookie": cookie(t, 7 * 86400) }); } if (path === "/api/logout" && method === "POST") { const t = getCookie(request, "sid"); if (t) await db.prepare("DELETE FROM sessions WHERE token = ?").bind(await sha256(t)).run(); return json({ ok: true }, 200, { "Set-Cookie": cookie("", 0) }); } /* ---- signed in ---- */ const me = await currentUser(request, db); if (!me) return err("Not signed in", 401); if (me.status === "disabled" || me.status === "denied") return err("Your account is not active.", 403); const allRoles = await roles(db); const myRole = allRoles.find(r => r.id === me.role); const perms = me.status === "active" ? permsOf(myRole) : []; const myRank = myRole ? myRole.rank : 0; if (path === "/api/me") { return json({ user: publicUser(me), role: myRole || null, perms, roles: allRoles.map(r => ({ id: r.id, name: r.name, rank: r.rank, color: r.color })), permList: has(perms, "roles.manage") ? PERMS : undefined }); } if (path === "/api/password" && method === "POST") { const cur = await hashPw(String(body.current || ""), me.salt); if (!safeEq(cur.hash, me.pass)) return err("Current password is wrong.", 403); if (String(body.next || "").length < 8) return err("New password must be at least 8 characters."); const { hash, salt } = await hashPw(String(body.next)); await db.prepare("UPDATE users SET pass = ?, salt = ? WHERE id = ?").bind(hash, salt, me.id).run(); await audit(db, me.username, "password.changed"); return json({ ok: true }); } if (me.status !== "active") return err("Your account is waiting for approval.", 403, { pending: true }); /* ---- live server data ---- */ if (path === "/api/snapshot") { if (!has(perms, "view.dashboard")) return err("No permission", 403); const want = [["server","/server",10],["players","/server/players",10],["queue","/server/queue",10],["vehicles","/server/vehicles",15],["staff","/server/staff",60]]; if (has(perms, "view.modcalls")) want.push(["calls","/server/modcalls",10]); if (has(perms, "view.logs")) want.push(["joins","/server/joinlogs",10],["kills","/server/killlogs",10],["cmds","/server/commandlogs",10]); if (has(perms, "view.bans")) want.push(["bans","/server/bans",60]); const out = { errors: [] }; for (const [k, p, ttl] of want) { try { out[k] = await erlc(env, p, ttl); } catch (e) { out.errors.push(e.status === 403 ? "The server key was rejected by PRC. Update the ERLC_KEY secret." : e.status === 429 ? "PRC rate limit hit; data will catch up shortly." : `${p}: ${e.message}`); if (e.status === 403) break; } } out.errors = [...new Set(out.errors)]; return json(out); } if (path === "/api/command" && method === "POST") { let cmd = String(body.command || "").replace(/[\r\n]+/g, " ").trim().slice(0, 300); if (!cmd) return err("Empty command"); if (!cmd.startsWith(":")) cmd = ":" + cmd; const verb = cmd.slice(1).split(/\s+/)[0].toLowerCase(); const need = CMD_PERM[verb] || "cmd.console"; if (!has(perms, need)) { await audit(db, me.username, "command.blocked", cmd); return err(`Your role can't run :${verb}.`, 403); } const wait = lastCmdAt + 5000 - Date.now(); if (wait > 0) return err(`Command cooldown, wait ${Math.ceil(wait / 1000)}s.`, 429, { retryAfter: Math.ceil(wait / 1000) }); lastCmdAt = Date.now(); const r = await fetch(UPSTREAM + "/server/command", { method: "POST", headers: { "Server-Key": env.ERLC_KEY, "Content-Type": "application/json" }, body: JSON.stringify({ command: cmd }) }); if (!r.ok) { const d = await r.json().catch(() => ({})); await audit(db, me.username, "command.failed", cmd); return err(d.message || `PRC returned ${r.status}`, r.status === 429 ? 429 : 502); } await audit(db, me.username, "command", cmd); for (const k of cache.keys()) if (k !== "/server/staff") cache.delete(k); return json({ ok: true }); } /* ---- account management ---- */ if (path === "/api/users" && method === "GET") { if (!has(perms, "users.manage")) return err("No permission", 403); const { results } = await db.prepare("SELECT * FROM users ORDER BY CASE status WHEN 'pending' THEN 0 ELSE 1 END, created DESC").all(); return json({ users: results.map(publicUser) }); } const um = path.match(/^\/api\/users\/(\d+)$/); if (um && method === "POST") { if (!has(perms, "users.manage")) return err("No permission", 403); const target = await db.prepare("SELECT * FROM users WHERE id = ?").bind(+um[1]).first(); if (!target) return err("User not found", 404); if (target.id === me.id) return err("You can't change your own account here."); const tRole = allRoles.find(r => r.id === target.role); if ((tRole ? tRole.rank : 0) >= myRank) return err("You can only manage people below your rank.", 403); const a = body.action, roleOk = id => { const r = allRoles.find(x => x.id === id); return r && r.rank < myRank; }; if (a === "approve" || a === "setRole") { if (!roleOk(body.role)) return err("You can only give roles below your own.", 403); await db.prepare("UPDATE users SET role = ?, status = 'active', approved_by = COALESCE(approved_by, ?) WHERE id = ?").bind(body.role, me.username, target.id).run(); await audit(db, me.username, a === "approve" ? "account.approved" : "role.changed", `${target.username} → ${allRoles.find(r => r.id === body.role).name}`); } else if (a === "deny") { await db.prepare("UPDATE users SET status = 'denied' WHERE id = ?").bind(target.id).run(); await db.prepare("DELETE FROM sessions WHERE user_id = ?").bind(target.id).run(); await audit(db, me.username, "account.denied", target.username); } else if (a === "disable" || a === "enable") { await db.prepare("UPDATE users SET status = ? WHERE id = ?").bind(a === "disable" ? "disabled" : (target.role ? "active" : "pending"), target.id).run(); if (a === "disable") await db.prepare("DELETE FROM sessions WHERE user_id = ?").bind(target.id).run(); await audit(db, me.username, "account." + a + "d", target.username); } else if (a === "resetPassword") { const temp = randHex(5); const { hash, salt } = await hashPw(temp); await db.prepare("UPDATE users SET pass = ?, salt = ? WHERE id = ?").bind(hash, salt, target.id).run(); await db.prepare("DELETE FROM sessions WHERE user_id = ?").bind(target.id).run(); await audit(db, me.username, "password.reset", target.username); return json({ ok: true, tempPassword: temp }); } else if (a === "delete") { await db.batch([db.prepare("DELETE FROM sessions WHERE user_id = ?").bind(target.id), db.prepare("DELETE FROM users WHERE id = ?").bind(target.id)]); await audit(db, me.username, "account.deleted", target.username); } else return err("Unknown action"); return json({ ok: true }); } /* ---- roles ---- */ if (path === "/api/roles-full") { if (!has(perms, "roles.manage")) return err("No permission", 403); return json({ roles: allRoles }); } if (path === "/api/roles" && method === "POST") { if (!has(perms, "roles.manage")) return err("No permission", 403); const name = String(body.name || "").trim().slice(0, 24), rank = Math.round(+body.rank); const color = /^#[0-9a-fA-F]{6}$/.test(body.color || "") ? body.color : "#8a96b2"; const p = (Array.isArray(body.perms) ? body.perms : []).filter(x => ALL.includes(x)); if (!name) return err("Give the role a name."); if (!(rank >= 1 && rank < myRank)) return err(`Rank must be between 1 and ${myRank - 1}.`); if (body.id) { const r = allRoles.find(x => x.id === body.id); if (!r) return err("Role not found", 404); if (r.locked || r.rank >= myRank) return err("You can't edit that role.", 403); await db.prepare("UPDATE roles SET name = ?, rank = ?, color = ?, perms = ? WHERE id = ?").bind(name, rank, color, JSON.stringify(p), r.id).run(); await audit(db, me.username, "role.edited", name); } else { const id = name.toLowerCase().replace(/[^a-z0-9]+/g, "-").replace(/^-|-$/g, "") + "-" + randHex(2); await db.prepare("INSERT INTO roles (id,name,rank,color,perms,locked) VALUES (?,?,?,?,?,0)").bind(id, name, rank, color, JSON.stringify(p)).run(); await audit(db, me.username, "role.created", name); } return json({ ok: true }); } const rm = path.match(/^\/api\/roles\/([a-z0-9-]+)\/delete$/); if (rm && method === "POST") { if (!has(perms, "roles.manage")) return err("No permission", 403); const r = allRoles.find(x => x.id === rm[1]); if (!r || r.locked || r.rank >= myRank) return err("You can't delete that role.", 403); const { c } = await db.prepare("SELECT COUNT(*) AS c FROM users WHERE role = ?").bind(r.id).first(); if (c) return err(`${c} account(s) still have this role. Move them first.`); await db.prepare("DELETE FROM roles WHERE id = ?").bind(r.id).run(); await audit(db, me.username, "role.deleted", r.name); return json({ ok: true }); } /* ---- audit ---- */ if (path === "/api/audit") { if (!has(perms, "audit.view")) return err("No permission", 403); const { results } = await db.prepare("SELECT * FROM audit ORDER BY id DESC LIMIT 300").all(); return json({ entries: results }); } return err("Not found", 404); } catch (e) { return err("Server error: " + (e && e.message || e), 500); } }, }; /* Roblox avatar headshots: /avatars?ids=1,2,3 → { "1": "https://...png" } */ async function avatars(url, ctx) { const ids = (url.searchParams.get("ids") || "").split(",").filter(x => /^\d+$/.test(x)).slice(0, 100); if (!ids.length) return json({}); const cacheKey = new Request("https://avatar-cache/" + ids.sort().join(",")); const hit = await caches.default.match(cacheKey); if (hit) return hit; const out = {}; try { const r = await fetch(`https://thumbnails.roblox.com/v1/users/avatar-headshot?userIds=${ids.join(",")}&size=150x150&format=Png&isCircular=false`); const j = await r.json(); for (const d of j.data || []) if (d.state === "Completed") out[d.targetId] = d.imageUrl; } catch {} const res = new Response(JSON.stringify(out), { headers: { "Content-Type": "application/json", "Cache-Control": "public, max-age=3600" } }); ctx.waitUntil(caches.default.put(cacheKey, res.clone())); return res; } const HTML = "\n\n
\n\n\nThanks, . A staff manager needs to approve your account and give you a role. This page checks again automatically.
\n \n