BlueGit

projects-timfalken-com microchess

Files

microchess / web / lib / bootstrap.php

bootstrap.php

bootstrap.php 10.9 KiB Download Raw
1<?php
2declare(strict_types=1);
3require_once __DIR__.'/Chess.php';
4ini_set('display_errors','0');
5ini_set('log_errors','1');
6ini_set('error_log',dirname(__DIR__).'/data/php-errors.log');
7header('X-Content-Type-Options: nosniff');
8header('Referrer-Policy: same-origin');
9header("Content-Security-Policy: default-src 'self'; img-src 'self'; style-src 'self'; script-src 'self'; connect-src 'self'; frame-ancestors 'none'; base-uri 'self'; form-action 'self'");
10header('Cache-Control: no-store');
11
12function db(): PDO {
13 static $db;
14 if ($db) return $db;
15 $db=new PDO('sqlite:'.dirname(__DIR__).'/data/microchess.sqlite',null,null,[PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]);
16 $db->exec('PRAGMA journal_mode=WAL; PRAGMA foreign_keys=ON; PRAGMA busy_timeout=5000;');
17 $db->exec('CREATE TABLE IF NOT EXISTS users (id TEXT PRIMARY KEY, name TEXT NOT NULL);
18 CREATE TABLE IF NOT EXISTS user_avatars (user_id TEXT PRIMARY KEY REFERENCES users(id), avatar TEXT NOT NULL);
19 CREATE TABLE IF NOT EXISTS sessions (id TEXT PRIMARY KEY, payload TEXT NOT NULL, expires INTEGER NOT NULL);
20 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(a<b));
21 CREATE TABLE IF NOT EXISTS links (token TEXT PRIMARY KEY, owner TEXT NOT NULL REFERENCES users(id), kind TEXT NOT NULL, expires INTEGER NOT NULL, used INTEGER NOT NULL DEFAULT 0);
22 CREATE TABLE IF NOT EXISTS games (id INTEGER PRIMARY KEY AUTOINCREMENT, a TEXT NOT NULL REFERENCES users(id), b TEXT NOT NULL REFERENCES users(id), status TEXT NOT NULL, white TEXT, state TEXT, winner TEXT, reason TEXT, exit_a INTEGER DEFAULT 0, exit_b INTEGER DEFAULT 0, rematch_a INTEGER DEFAULT 0, rematch_b INTEGER DEFAULT 0, draw_offer TEXT, version INTEGER DEFAULT 0, created INTEGER NOT NULL);
23 CREATE TABLE IF NOT EXISTS results (id INTEGER PRIMARY KEY AUTOINCREMENT, game_id INTEGER NOT NULL REFERENCES games(id), a TEXT NOT NULL, b TEXT NOT NULL, winner TEXT, reason TEXT NOT NULL, state TEXT NOT NULL, ended INTEGER NOT NULL);
24 CREATE INDEX IF NOT EXISTS games_a ON games(a); CREATE INDEX IF NOT EXISTS games_b ON games(b);');
25 $columns=$db->query('PRAGMA table_info(games)')->fetchAll(PDO::FETCH_COLUMN,1);
26 if (!in_array('activity_at',$columns,true)) {
27 $db->exec('BEGIN IMMEDIATE');
28 try {
29 if (!in_array('activity_at',$db->query('PRAGMA table_info(games)')->fetchAll(PDO::FETCH_COLUMN,1),true)) {
30 $db->exec('ALTER TABLE games ADD COLUMN activity_at INTEGER');
31 $db->exec('UPDATE games SET activity_at=unixepoch() WHERE activity_at IS NULL');
32 }
33 $db->exec('COMMIT');
34 } catch (Throwable $e) { $db->exec('ROLLBACK');throw $e; }
35 }
36 $db->exec('CREATE TRIGGER IF NOT EXISTS games_activity_insert AFTER INSERT ON games BEGIN UPDATE games SET activity_at=unixepoch() WHERE id=NEW.id; END;
37 CREATE TRIGGER IF NOT EXISTS games_activity_update AFTER UPDATE OF version ON games BEGIN UPDATE games SET activity_at=unixepoch() WHERE id=NEW.id; END;');
38 // Assign existing accounts once as well as newly created accounts.
39 foreach ($db->query('SELECT id FROM users WHERE id NOT IN (SELECT user_id FROM user_avatars)')->fetchAll(PDO::FETCH_COLUMN) as $id) {
40 $avatars=avatarCatalog();
41 $q=$db->prepare('INSERT OR IGNORE INTO user_avatars(user_id,avatar) VALUES(?,?)');
42 $q->execute([$id,$avatars[random_int(0,count($avatars)-1)]['id']]);
43 }
44 return $db;
45}
46function query(string $sql,array $args=[]): PDOStatement { $s=db()->prepare($sql);$s->execute($args);return $s; }
47function profile(string $id): array {
48 return query('SELECT u.*,a.avatar FROM users u LEFT JOIN user_avatars a ON a.user_id=u.id WHERE u.id=?',[$id])->fetch();
49}
50function avatarCatalog(): array {
51 static $avatars;
52 return $avatars ??= json_decode(file_get_contents(dirname(__DIR__).'/assets/avatars/catalog.json'),true,512,JSON_THROW_ON_ERROR);
53}
54final class DatabaseSessions implements SessionHandlerInterface {
55 public function open(string $path,string $name): bool {return true;}
56 public function close(): bool {return true;}
57 public function read(string $id): string|false {return query('SELECT payload FROM sessions WHERE id=? AND expires>?',[$id,time()])->fetchColumn()?:'';}
58 public function write(string $id,string $data): bool {query('INSERT OR REPLACE INTO sessions VALUES(?,?,?)',[$id,$data,time()+3600]);return true;}
59 public function destroy(string $id): bool {query('DELETE FROM sessions WHERE id=?',[$id]);return true;}
60 public function gc(int $max_lifetime): int|false {return query('DELETE FROM sessions WHERE expires<?',[time()])->rowCount();}
61}
62function localDev(): bool {
63 $host=parse_url('http://'.($_SERVER['HTTP_HOST']??''),PHP_URL_HOST);
64 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);
65}
66function config(): array {
67 static $c;
68 if ($c !== null) return $c;
69 $path=dirname(__DIR__).'/data/config.php';
70 $lock=fopen(dirname(__DIR__).'/data/config.lock','c');
71 if ($lock===false) throw new RuntimeException('The data directory must be writable to initialize configuration.');
72 try {
73 if (!flock($lock,LOCK_EX)) throw new RuntimeException('Unable to lock configuration.');
74 if (!file_exists($path)) {
75 $template="<?php\n// Fill in these values on this server. Empty fields use environment variables.\nreturn [\n 'base_url' => '',\n 'client_id' => '',\n 'client_secret' => '',\n];\n";
76 if (file_put_contents($path,$template)!==strlen($template)) throw new RuntimeException('Unable to create data/config.php.');
77 }
78 $values=require $path;
79 if (!is_array($values)) throw new RuntimeException('data/config.php must return an array.');
80 } finally {
81 flock($lock,LOCK_UN);
82 fclose($lock);
83 }
84 foreach (['base_url'=>'MICROCHESS_BASE_URL','client_id'=>'MICROCHESS_CLIENT_ID','client_secret'=>'MICROCHESS_CLIENT_SECRET'] as $key=>$env) {
85 if (($values[$key]??'')==='') $values[$key]=getenv($env)?:'';
86 }
87 return $c=$values;
88}
89function baseUrl(): string {
90 if (localDev()) return 'http://'.$_SERVER['HTTP_HOST'].rtrim(dirname($_SERVER['SCRIPT_NAME']),'/');
91 $base=rtrim(config()['base_url'],'/');
92 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.");
93 return $base;
94}
95function authRequest(string $path,?array $form=null,?string $token=null): array {
96 $ch=curl_init('https://auth.timfalken.com'.$path);
97 $headers=['Accept: application/json','User-Agent: Microchess/1.0'];
98 if ($token) $headers[]='Authorization: Bearer '.$token;
99 curl_setopt_array($ch,[CURLOPT_RETURNTRANSFER=>true,CURLOPT_TIMEOUT=>15,CURLOPT_HTTPHEADER=>$headers]);
100 if ($form!==null) curl_setopt_array($ch,[CURLOPT_POST=>true,CURLOPT_POSTFIELDS=>http_build_query($form)]);
101 $body=curl_exec($ch); $status=curl_getinfo($ch,CURLINFO_RESPONSE_CODE);
102 $data=is_string($body)?json_decode($body,true):null;
103 if ($status!==200 || !is_array($data)) throw new RuntimeException('Authentication service unavailable or session expired. Please sign in again.');
104 return $data;
105}
106function loginUser(string $id,string $name): void {
107 query('INSERT INTO users VALUES(?,?) ON CONFLICT(id) DO UPDATE SET name=excluded.name',[$id,$name]);
108 $avatars=avatarCatalog();
109 query('INSERT OR IGNORE INTO user_avatars(user_id,avatar) VALUES(?,?)',[$id,$avatars[random_int(0,count($avatars)-1)]['id']]);
110 session_regenerate_id(true); $_SESSION['user']=$id; $_SESSION['csrf']=bin2hex(random_bytes(24));
111}
112// Generate the editable configuration on the first page request, including localhost.
113config();
114session_name('microchess_session');
115ini_set('session.use_strict_mode','1');
116session_set_cookie_params(['lifetime'=>0,'path'=>rtrim(dirname($_SERVER['SCRIPT_NAME']),'/').'/', 'secure'=>!localDev(),'httponly'=>true,'samesite'=>'Lax']);
117session_set_save_handler(new DatabaseSessions(),true);
118session_start();
119if (localDev() && !in_array($_SESSION['user']??'', ['local:test_user_1','local:test_user_2'],true)) {
120 unset($_SESSION['token'],$_SESSION['expires'],$_SESSION['validated']);
121 loginUser('local:test_user_1','test_user_1');
122}
123function user(): string {
124 if (!isset($_SESSION['user'])) fail('Please sign in.',401);
125 if (!localDev() && (($_SESSION['expires']??0)<time())) {unset($_SESSION['user']);fail('Your session expired. Please sign in again.',401);}
126 return $_SESSION['user'];
127}
128function fail(string $message,int $status=400): never {http_response_code($status);header('Content-Type: application/json');echo json_encode(['error'=>$message]);exit;}
129function jsonOut(mixed $data): never {header('Content-Type: application/json');echo json_encode($data,JSON_THROW_ON_ERROR);exit;}
130function pair(string $a,string $b): array { $p=[$a,$b];sort($p,SORT_STRING);return $p; }
131function finishGame(array $g,?string $winner,string $reason,array $s): void {
132 query("UPDATE games SET status='ended',winner=?,reason=?,state=?,draw_offer=NULL,version=version+1 WHERE id=?",[$winner,$reason,json_encode($s),$g['id']]);
133 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()]);
134}
135function startGame(string $a,string $b): int {
136 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()]);
137 return (int)db()->lastInsertId();
138}
139function gameView(array $g,string $u): array {
140 $other=$g['a']===$u?$g['b']:$g['a'];$side=$g['a']===$u?'a':'b';$opSide=$side==='a'?'b':'a';
141 $opponent=profile($other);
142 $s=$g['state']?json_decode($g['state'],true):null;
143 $color=$g['white']===$u?'w':'b';
144 return ['id'=>(int)$g['id'],'opponent'=>$opponent['name'],'opponentAvatar'=>$opponent['avatar'], 'status'=>$g['status'],'incoming'=>$g['b']===$u,'color'=>$color,
145 'inactiveDays'=>max(0,(int)floor((time()-($g['activity_at']??time()))/86400)),
146 'outcome'=>$g['winner']===null?'draw':($g['winner']===$u?'win':'loss'),
147 'state'=>$s,'yourTurn'=>$g['status']==='active' && $s['turn']===$color,'legal'=>$g['status']==='active' && $s['turn']===$color?Chess::legal($s):[],
148 'check'=>$s?Chess::check($s):false,'winner'=>$g['winner']?query('SELECT name FROM users WHERE id=?',[$g['winner']])->fetchColumn():null,'reason'=>$g['reason'],
149 'canRematch'=>!$g['exit_'.$opSide],'rematch'=>!!$g['rematch_'.$side],'opponentRematch'=>!!$g['rematch_'.$opSide], 'drawOffer'=>$g['draw_offer']?($g['draw_offer']===$u?'you':'opponent'):null,
150 'claimable'=>$s?Chess::claimable($s):false,'version'=>(int)$g['version']];
151}