PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]); $db->exec('PRAGMA journal_mode=WAL; PRAGMA foreign_keys=ON; PRAGMA busy_timeout=5000;'); $db->exec('CREATE TABLE IF NOT EXISTS users (id TEXT PRIMARY KEY, name TEXT NOT NULL); CREATE TABLE IF NOT EXISTS user_avatars (user_id TEXT PRIMARY KEY REFERENCES users(id), avatar TEXT NOT NULL); CREATE TABLE IF NOT EXISTS sessions (id TEXT PRIMARY KEY, payload TEXT NOT NULL, expires INTEGER NOT NULL); CREATE TABLE IF NOT EXISTS friends (a TEXT NOT NULL REFERENCES users(id), b TEXT NOT NULL REFERENCES users(id), PRIMARY KEY(a,b), CHECK(aquery('PRAGMA table_info(games)')->fetchAll(PDO::FETCH_COLUMN,1); if (!in_array('activity_at',$columns,true)) { $db->exec('BEGIN IMMEDIATE'); try { if (!in_array('activity_at',$db->query('PRAGMA table_info(games)')->fetchAll(PDO::FETCH_COLUMN,1),true)) { $db->exec('ALTER TABLE games ADD COLUMN activity_at INTEGER'); $db->exec("UPDATE games SET activity_at=CAST(strftime('%s','now') AS INTEGER) WHERE activity_at IS NULL"); } $db->exec('COMMIT'); } catch (Throwable $e) { $db->exec('ROLLBACK');throw $e; } } // Replace legacy triggers once, including databases already migrated on newer SQLite. $legacy=$db->query("SELECT sql FROM sqlite_master WHERE type='trigger' AND name IN ('games_activity_insert','games_activity_update')")->fetchAll(PDO::FETCH_COLUMN); if (array_filter($legacy,static fn(string $sql): bool => stripos($sql,'unixepoch(')!==false)) { $db->exec('BEGIN IMMEDIATE'); try { $db->exec('DROP TRIGGER IF EXISTS games_activity_insert; DROP TRIGGER IF EXISTS games_activity_update;'); activityTriggers($db); $db->exec('COMMIT'); } catch (Throwable $e) { $db->exec('ROLLBACK');throw $e; } } else { activityTriggers($db); } // Assign existing accounts once as well as newly created accounts. foreach ($db->query('SELECT id FROM users WHERE id NOT IN (SELECT user_id FROM user_avatars)')->fetchAll(PDO::FETCH_COLUMN) as $id) { $avatars=avatarCatalog(); $q=$db->prepare('INSERT OR IGNORE INTO user_avatars(user_id,avatar) VALUES(?,?)'); $q->execute([$id,$avatars[random_int(0,count($avatars)-1)]['id']]); } $db->exec('CREATE TABLE IF NOT EXISTS ratings (user_id TEXT PRIMARY KEY REFERENCES users(id), rating INTEGER NOT NULL DEFAULT 1200, played INTEGER NOT NULL DEFAULT 0); CREATE TABLE IF NOT EXISTS rating_changes (result_id INTEGER PRIMARY KEY REFERENCES results(id), a_before INTEGER NOT NULL, b_before INTEGER NOT NULL, delta INTEGER NOT NULL); CREATE TABLE IF NOT EXISTS matchmaking (user_id TEXT PRIMARY KEY REFERENCES users(id), joined INTEGER NOT NULL); CREATE TABLE IF NOT EXISTS matchmaking_clock (id INTEGER PRIMARY KEY CHECK(id=1), checked INTEGER NOT NULL); INSERT OR IGNORE INTO matchmaking_clock VALUES(1,0);'); $db->exec('CREATE TABLE IF NOT EXISTS replays (result_id INTEGER PRIMARY KEY REFERENCES results(id), white TEXT NOT NULL, moves BLOB NOT NULL); CREATE INDEX IF NOT EXISTS results_ended ON results(ended);'); if (!in_array('turn_order',$db->query('PRAGMA table_info(games)')->fetchAll(PDO::FETCH_COLUMN,1),true)) { $db->exec('BEGIN IMMEDIATE'); try { if (!in_array('turn_order',$db->query('PRAGMA table_info(games)')->fetchAll(PDO::FETCH_COLUMN,1),true)) { $db->exec('ALTER TABLE games ADD COLUMN turn_order INTEGER NOT NULL DEFAULT 0'); $db->exec('UPDATE games SET turn_order=id'); } $db->exec('COMMIT'); } catch (Throwable $e) {$db->exec('ROLLBACK');throw $e;} } $db->exec("CREATE TRIGGER IF NOT EXISTS games_turn_insert AFTER INSERT ON games BEGIN UPDATE games SET turn_order=(SELECT COALESCE(MAX(turn_order),0)+1 FROM games) WHERE id=NEW.id; END; CREATE TRIGGER IF NOT EXISTS games_turn_update AFTER UPDATE OF state ON games WHEN NEW.state IS NOT OLD.state BEGIN UPDATE games SET turn_order=(SELECT COALESCE(MAX(turn_order),0)+1 FROM games) WHERE id=NEW.id; END;"); $q=$db->query("SELECT r.id,r.state,g.white FROM results r JOIN games g ON g.id=r.game_id WHERE r.state=g.state AND g.status='ended' AND NOT EXISTS (SELECT 1 FROM replays p WHERE p.result_id=r.id)"); foreach ($q->fetchAll() as $r) { $position=json_decode($r['state'],true); if (!empty($position['history'])) { try {saveReplay((int)$r['id'],$r['white'],$position);} catch (PDOException $e) {if ($e->getCode()!=='23000') throw $e;} } } return $db; } function activityTriggers(PDO $db): void { $db->exec("CREATE TRIGGER IF NOT EXISTS games_activity_insert AFTER INSERT ON games BEGIN UPDATE games SET activity_at=CAST(strftime('%s','now') AS INTEGER) WHERE id=NEW.id; END; CREATE TRIGGER IF NOT EXISTS games_activity_update AFTER UPDATE OF version ON games BEGIN UPDATE games SET activity_at=CAST(strftime('%s','now') AS INTEGER) WHERE id=NEW.id; END;"); } function query(string $sql,array $args=[]): PDOStatement { $s=db()->prepare($sql);$s->execute($args);return $s; } function profile(string $id): array { return query('SELECT u.*,a.avatar,COALESCE(r.rating,1200) AS rating,COALESCE(r.played,0) AS ratedGames FROM users u LEFT JOIN user_avatars a ON a.user_id=u.id LEFT JOIN ratings r ON r.user_id=u.id WHERE u.id=?',[$id])->fetch(); } function avatarCatalog(): array { static $avatars; return $avatars ??= json_decode(file_get_contents(dirname(__DIR__).'/assets/avatars/catalog.json'),true,512,JSON_THROW_ON_ERROR); } final class DatabaseSessions implements SessionHandlerInterface { public function open(string $path,string $name): bool {return true;} public function close(): bool {return true;} public function read(string $id): string|false {return query('SELECT payload FROM sessions WHERE id=? AND expires>?',[$id,time()])->fetchColumn()?:'';} public function write(string $id,string $data): bool {query('INSERT OR REPLACE INTO sessions VALUES(?,?,?)',[$id,$data,time()+3600]);return true;} public function destroy(string $id): bool {query('DELETE FROM sessions WHERE id=?',[$id]);return true;} public function gc(int $max_lifetime): int|false {return query('DELETE FROM sessions WHERE expiresrowCount();} } function localDev(): bool { $host=parse_url('http://'.($_SERVER['HTTP_HOST']??''),PHP_URL_HOST); return is_string($host) && in_array(strtolower($host),['localhost','127.0.0.1','[::1]'],true) && in_array($_SERVER['REMOTE_ADDR']??'', ['127.0.0.1','::1'],true); } function config(): array { static $c; if ($c !== null) return $c; $path=dirname(__DIR__).'/data/config.php'; $lock=fopen(dirname(__DIR__).'/data/config.lock','c'); if ($lock===false) throw new RuntimeException('The data directory must be writable to initialize configuration.'); try { if (!flock($lock,LOCK_EX)) throw new RuntimeException('Unable to lock configuration.'); if (!file_exists($path)) { $template=" '',\n 'client_id' => '',\n 'client_secret' => '',\n];\n"; if (file_put_contents($path,$template)!==strlen($template)) throw new RuntimeException('Unable to create data/config.php.'); } $values=require $path; if (!is_array($values)) throw new RuntimeException('data/config.php must return an array.'); } finally { flock($lock,LOCK_UN); fclose($lock); } foreach (['base_url'=>'MICROCHESS_BASE_URL','client_id'=>'MICROCHESS_CLIENT_ID','client_secret'=>'MICROCHESS_CLIENT_SECRET'] as $key=>$env) { if (($values[$key]??'')==='') $values[$key]=getenv($env)?:''; } return $c=$values; } function baseUrl(): string { if (localDev()) return 'http://'.$_SERVER['HTTP_HOST'].rtrim(dirname($_SERVER['SCRIPT_NAME']),'/'); $base=rtrim(config()['base_url'],'/'); if (!str_starts_with($base,'https://')) throw new RuntimeException("Set 'base_url' in data/config.php to this application's production HTTPS URL, or set MICROCHESS_BASE_URL. The data directory is excluded from deployment; update this file on the production server separately."); return $base; } function authRequest(string $path,?array $form=null,?string $token=null): array { $ch=curl_init('https://auth.timfalken.com'.$path); $headers=['Accept: application/json','User-Agent: Microchess/1.0']; if ($token) $headers[]='Authorization: Bearer '.$token; curl_setopt_array($ch,[CURLOPT_RETURNTRANSFER=>true,CURLOPT_TIMEOUT=>15,CURLOPT_HTTPHEADER=>$headers]); if ($form!==null) curl_setopt_array($ch,[CURLOPT_POST=>true,CURLOPT_POSTFIELDS=>http_build_query($form)]); $body=curl_exec($ch); $status=curl_getinfo($ch,CURLINFO_RESPONSE_CODE); $data=is_string($body)?json_decode($body,true):null; if ($status!==200 || !is_array($data)) throw new RuntimeException('Authentication service unavailable or session expired. Please sign in again.'); return $data; } function loginUser(string $id,string $name): void { query('INSERT INTO users VALUES(?,?) ON CONFLICT(id) DO UPDATE SET name=excluded.name',[$id,$name]); $avatars=avatarCatalog(); query('INSERT OR IGNORE INTO user_avatars(user_id,avatar) VALUES(?,?)',[$id,$avatars[random_int(0,count($avatars)-1)]['id']]); session_regenerate_id(true); $_SESSION['user']=$id; $_SESSION['csrf']=bin2hex(random_bytes(24)); } // Generate the editable configuration on the first page request, including localhost. config(); session_name('microchess_session'); ini_set('session.use_strict_mode','1'); session_set_cookie_params(['lifetime'=>0,'path'=>rtrim(dirname($_SERVER['SCRIPT_NAME']),'/').'/', 'secure'=>!localDev(),'httponly'=>true,'samesite'=>'Lax']); session_set_save_handler(new DatabaseSessions(),true); session_start(); if (localDev() && !in_array($_SESSION['user']??'', ['local:test_user_1','local:test_user_2'],true)) { unset($_SESSION['token'],$_SESSION['expires'],$_SESSION['validated']); loginUser('local:test_user_1','test_user_1'); } function user(): string { if (!isset($_SESSION['user'])) fail('Please sign in.',401); if (!localDev() && (($_SESSION['expires']??0)$message]);exit;} function jsonOut(mixed $data): never {header('Content-Type: application/json');echo json_encode($data,JSON_THROW_ON_ERROR);exit;} function pair(string $a,string $b): array { $p=[$a,$b];sort($p,SORT_STRING);return $p; } function rivalry(string $u,string $other): array { $r=query('SELECT COUNT(*) AS total,COALESCE(SUM(winner=?),0) AS wins,COALESCE(SUM(winner IS NULL),0) AS ties FROM results WHERE (a=? AND b=?) OR (a=? AND b=?)',[$u,$u,$other,$other,$u])->fetch(); return ['wins'=>(int)$r['wins'],'losses'=>(int)$r['total']-(int)$r['wins']-(int)$r['ties'],'ties'=>(int)$r['ties']]; } function befriend(string $a,string $b): void { $p=pair($a,$b); query('INSERT OR IGNORE INTO friends VALUES(?,?)',$p); query('DELETE FROM friend_requests WHERE a=? AND b=?',$p); } // Two bytes per ply: source square, destination square and resulting piece (promotion included). // Only the initial board is stored in full; no repeated position snapshots. function saveReplay(int $result,string $white,array $s): void { $history=$s['history']; $packed=substr($history[0],0,21); $pieces='.prnbqkPRNBQK'; for ($i=1;$iprepare('INSERT INTO replays VALUES(?,?,?)'); $q->bindValue(1,$result);$q->bindValue(2,$white);$q->bindValue(3,$packed,PDO::PARAM_LOB);$q->execute(); query("UPDATE results SET state='{}' WHERE id=?",[$result]); } function replayPositions(string $packed): array { $board=str_split(substr($packed,0,20));$turn=$packed[20]; $positions=[['board'=>$board,'turn'=>$turn,'ply'=>0,'last'=>null]]; for ($i=21;$i$board,'turn'=>$turn,'ply'=>count($positions),'last'=>['from'=>$from,'to'=>$to]]; } return $positions; } function finishGame(array $g,?string $winner,string $reason,array $s): void { $final=$s;$final['history']=[]; $finished=query("UPDATE games SET status='ended',winner=?,reason=?,state=?,draw_offer=NULL,version=version+1 WHERE id=? AND status='active' AND version=?",[$winner,$reason,json_encode($final),$g['id'],$g['version']]); if ($finished->rowCount()!==1) throw new DomainException('The game has changed. Please try again.'); query('INSERT INTO results(game_id,a,b,winner,reason,state,ended) VALUES(?,?,?,?,?,?,?)',[$g['id'],$g['a'],$g['b'],$winner,$reason,json_encode($s),time()]); $result=(int)db()->lastInsertId(); saveReplay($result,$g['white'],$s); $a=(int)profile($g['a'])['rating'];$b=(int)profile($g['b'])['rating']; $score=$winner===null?0.5:($winner===$g['a']?1:0); $delta=(int)round(32*($score-1/(1+10**(($b-$a)/400)))); query('INSERT INTO rating_changes VALUES(?,?,?,?)',[$result,$a,$b,$delta]); foreach ([[$g['a'],$a+$delta],[$g['b'],$b-$delta]] as [$id,$rating]) { query('INSERT INTO ratings(user_id,rating,played) VALUES(?,?,1) ON CONFLICT(user_id) DO UPDATE SET rating=excluded.rating,played=ratings.played+1',[$id,$rating]); } } // Called inside BEGIN IMMEDIATE: selecting pairs and consuming entries is atomic. function matchPlayers(bool $force=false): void { $now=time(); if (!$force && (int)query('SELECT checked FROM matchmaking_clock WHERE id=1')->fetchColumn()>$now-60) return; query('UPDATE matchmaking_clock SET checked=? WHERE id=1',[$now]); $pool=query('SELECT m.*,COALESCE(r.rating,1200) AS rating FROM matchmaking m LEFT JOIN ratings r ON r.user_id=m.user_id WHERE m.joined>? ORDER BY m.joined,m.user_id',[$now-86400])->fetchAll(); $used=[]; foreach ($pool as $a) { if (isset($used[$a['user_id']])) continue; $best=null;$distance=PHP_INT_MAX; foreach ($pool as $b) { if ($a['user_id']===$b['user_id'] || isset($used[$b['user_id']])) continue; $gap=abs($a['rating']-$b['rating']); $limit=min(500,100+50*intdiv(max(0,$now-$a['joined']),60),100+50*intdiv(max(0,$now-$b['joined']),60)); if ($gap<=$limit && $gap<$distance) {$best=$b;$distance=$gap;} } if ($best===null) continue; startGame($a['user_id'],$best['user_id']); query('DELETE FROM matchmaking WHERE user_id IN (?,?)',[$a['user_id'],$best['user_id']]); $used[$a['user_id']]=$used[$best['user_id']]=true; } } function startGame(string $a,string $b): int { query("INSERT INTO games(a,b,status,white,state,created) VALUES(?,?,'active',?,?,?)",[$a,$b,random_int(0,1)?$a:$b,json_encode(Chess::initial()),time()]); return (int)db()->lastInsertId(); } function gameView(array $g,string $u): array { $other=$g['a']===$u?$g['b']:$g['a'];$side=$g['a']===$u?'a':'b';$opSide=$side==='a'?'b':'a'; $opponent=profile($other); $s=$g['state']?json_decode($g['state'],true):null; $color=$g['white']===$u?'w':'b'; return ['id'=>(int)$g['id'],'turnOrder'=>(int)$g['turn_order'],'replayId'=>$g['status']==='ended'?(int)query('SELECT MAX(result_id) FROM replays JOIN results ON results.id=replays.result_id WHERE game_id=?',[$g['id']])->fetchColumn():null,'opponentId'=>$other,'rivalry'=>rivalry($u,$other),'opponent'=>$opponent['name'],'opponentAvatar'=>$opponent['avatar'],'opponentRating'=>(int)$opponent['rating'], 'status'=>$g['status'],'incoming'=>$g['b']===$u,'color'=>$color, 'inactiveDays'=>max(0,(int)floor((time()-($g['activity_at']??time()))/86400)), 'outcome'=>$g['winner']===null?'draw':($g['winner']===$u?'win':'loss'), 'state'=>$s,'yourTurn'=>$g['status']==='active' && $s['turn']===$color,'legal'=>$g['status']==='active' && $s['turn']===$color?Chess::legal($s):[], 'check'=>$s?Chess::check($s):false,'winner'=>$g['winner']?query('SELECT name FROM users WHERE id=?',[$g['winner']])->fetchColumn():null,'reason'=>$g['reason'], 'canRematch'=>!$g['exit_'.$opSide],'rematch'=>!!$g['rematch_'.$side],'opponentRematch'=>!!$g['rematch_'.$opSide], 'drawOffer'=>$g['draw_offer']?($g['draw_offer']===$u?'you':'opponent'):null, 'claimable'=>$s?Chess::claimable($s):false,'version'=>(int)$g['version']]; }