Skip to content

gitflarePublicPartly agent-ready40

orbit-duel

Real-time two-player orbital combat game on Cloudflare Workers and Durable Objects.

main
Add the Apache-2.0 licence0413e56
TypeScript43 lines1.9 KB
export interface Entry { name: string; score: number; created_at: number } export function cleanEntry(r: any): Entry | null {  if (!r || typeof r.name !== 'string' || !Number.isFinite(Number(r.score))) return null;  return { name: r.name.slice(0, 16), score: Math.trunc(Number(r.score)), created_at: Number(r.created_at) || 0 };} export function cleanMode(m: string | null): string {  return m && /^[a-z0-9_-]{1,16}$/i.test(m) ? m : 'duel';} let ready: WeakSet<object> = new WeakSet();export async function ensureSchema(db: any): Promise<void> {  if (!db || ready.has(db)) return;  await db.batch([    db.prepare('CREATE TABLE IF NOT EXISTS scores (id INTEGER PRIMARY KEY, game_mode TEXT, name TEXT, score INTEGER, created_at INTEGER)'),    db.prepare('CREATE INDEX IF NOT EXISTS idx_scores_mode_score ON scores (game_mode, score DESC)'),    db.prepare('CREATE INDEX IF NOT EXISTS idx_scores_created ON scores (created_at)'),  ]);  ready.add(db);} export async function topScores(db: any, mode: string): Promise<{ entries: Entry[]; available: boolean }> {  if (!db) return { entries: [], available: false };  try {    await ensureSchema(db);    const r = await db.prepare('SELECT name, score, created_at FROM scores WHERE game_mode = ? ORDER BY score DESC, created_at ASC LIMIT 20').bind(cleanMode(mode)).all();    const entries = ((r.results ?? []) as any[]).map(cleanEntry).filter((e): e is Entry => e !== null);    return { entries, available: true };  } catch {    return { entries: [], available: false };  }} export async function writeScores(db: any, mode: string, rows: { name: string; score: number }[]): Promise<void> {  if (!db || !rows.length) return;  try {    await ensureSchema(db);    const now = Date.now();    await db.batch(rows.map((r) => db.prepare('INSERT INTO scores (game_mode, name, score, created_at) VALUES (?, ?, ?, ?)').bind(mode, r.name, r.score, now)));  } catch {}}