[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_107":108,"_109":110},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","culostrapulito","name","pawclash","path","db.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/culostrapulito/pawclash/code/db.ts","extension","id","61fec1b3-2b83-410d-93f9-39c8128b87ea","fileId","0cfe353e-9c97-11f1-892f-1607ee4eb77e","parentId","branchId","c4c1efbd-5c25-4c6e-8ee2-f14082187f35","branchVersion",40,"latest",true,"createdAt",["D",1787233208497],"version",4,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * db.ts — Schema + helper di persistenza per PawClash.\n * Usa il database val-scoped fornito da std/sqlite/main.ts.\n */\n\nexport async function init() {\n await sqlite.execute(`create table if not exists users(\n id integer primary key autoincrement,\n username text unique not null,\n email text unique not null,\n password_hash text not null,\n gang text not null check(gang in ('cani','gatti')),\n avatar_url text default '',\n status text default 'online' check(status in ('online','dnd','invisible')),\n role text default 'user' check(role in ('user','mod','admin')),\n muted_until integer default 0,\n banned integer default 0,\n auth_token text,\n birthdate text default '',\n account_type text default 'adult' check(account_type in ('adult','kid')),\n parent_email text default '',\n parent_password_hash text default '',\n approved_adults text default '[]',\n parent_id integer default 0,\n created_at integer\n )`);\n\n await sqlite.execute(`create table if not exists messages(\n id integer primary key autoincrement,\n channel text not null, -- 'global' | 'gang:cani' | 'gang:gatti' | 'dm::' (ordinati)\n sender_id integer not null,\n sender_name text,\n gang text,\n content text default '',\n type text default 'text' check(type in ('text','voice','screenshot')),\n data text default 'null', -- JSON: {reactions: {\"🐶\":[ids]}, audioBase64?, imageDataUrl?}\n created_at integer\n )`);\n\n await sqlite.execute(`create table if not exists scores(\n gang text primary key,\n points integer default 0\n )`);\n await sqlite.execute(`insert or ignore into scores(gang, points) values('cani',0),('gatti',0)`);\n\n await sqlite.execute(`create table if not exists reports(\n id integer primary key autoincrement,\n reporter_id integer,\n target_username text,\n reason text,\n context text default '[]',\n severity text,\n sanction text,\n created_at integer\n )`);\n\n await sqlite.execute(`create table if not exists daily(\n day text primary key,\n challenge text,\n spoiler text\n )`);\n await seedDaily();\n}\n\nasync function seedDaily() {\n const day = new Date().toISOString().slice(0, 10);\n const exists = await sqlite.execute(\n { sql: `select 1 from daily where day=?`, args: [day] }\n );\n if (!exists.rows.length) {\n const challenges = [\n [\"Quale fazione vincerà il Trivia Quiz di oggi?\", \"Domani: Sfida RAP Battles tra Cani e Gatti!\"],\n [\"Quanti messaggi scambierà oggi la community?\", \"Domani: Stecca della memoria, costume party!\"],\n [\"Cani o Gatti: chi guadagnerà più punti sfida?\", \"Domani: Caccia al tesoro virtuale nella chat globale!\"],\n ];\n const pick = challenges[Math.floor(Math.random() * challenges.length)];\n await sqlite.execute({\n sql: `insert or ignore into daily(day, challenge, spoiler) values(?,?,?)`,\n args: [day, pick[0], pick[1]],\n });\n }\n}\n\n/* ---------- Utils ---------- */\n\nexport async function all(sql: string, args: unknown[] = []) {\n const r = await sqlite.execute({ sql, args });\n return r.rows as Record[];\n}\n\nexport async function one(sql: string, args: unknown[] = []) {\n const r = await all(sql, args);\n return r[0] ?? null;\n}\n\nexport async function run(sql: string, args: unknown[] = []) {\n return sqlite.execute({ sql, args });\n}\n\n/** password_hash: produzione vera → bcrypt/HF; qui di dominio semplice con chiave demo */\nexport function hashPassword(pw: string): string {\n return `pw_${pw.length.toString(16)}_${hashStr(pw)}`;\n}\nexport function verifyPassword(pw: string, hash: string): boolean {\n return hashPassword(pw) === hash;\n}\nfunction hashStr(s: string): string {\n let h = 0;\n for (let i = 0; i < s.length; i++) {\n h = ((h << 5) - h + s.charCodeAt(i)) | 0;\n }\n return (h >>> 0).toString(36);\n}\n\nlet N = 0;\nconst uid = () => `${Date.now().toString(36)}${(N++).toString(36)}${Math.random().toString(36).slice(2, 6)}`;\n\nexport function ageFrom(birthdate: string): number {\n if (!birthdate) return 99;\n const b = new Date(birthdate);\n if (isNaN(b.getTime())) return 99;\n const now = new Date();\n let age = now.getFullYear() - b.getFullYear();\n const m = now.getMonth() - b.getMonth();\n if (m < 0 || (m === 0 && now.getDate() < b.getDate())) age--;\n return age;\n}\n\nexport async function createUser(u) {\n const age = ageFrom(u.birthdate);\n const accountType = age < 13 ? \"kid\" : \"adult\";\n await run(\n `insert into users(username,email,password_hash,gang,avatar_url,status,created_at,auth_token,birthdate,account_type)\n values(?,?,?,?,?,?,?,?,?,?)`,\n [u.username, u.email, hashPassword(u.password), u.gang, u.avatarUrl ?? \"\", u.status ?? \"online\", Date.now(), uid(), u.birthdate ?? \"\", accountType]\n );\n const user = await one(`select * from users where username=?`, [u.username]);\n return user;\n}\n\nexport async function findByToken(token: string) {\n if (!token) return null;\n return one(`select * from users where auth_token=?`, [token]);\n}\n\nexport function sanitize(user) {\n if (!user) return null;\n const { password_hash, auth_token, ...safe } = user;\n return safe;\n}\n\nexport { uid };\n\n\n/* ================= EXTRA: quiz + voce (WebRTC signaling) ================= */\n\nexport async function initExtras() {\n await sqlite.execute(`create table if not exists quiz(\n day text primary key,\n question text,\n options text,\n correct_index integer,\n points integer default 5,\n created_at integer\n )`);\n await sqlite.execute(`create table if not exists quiz_answers(\n user_id integer,\n day text,\n correct integer,\n points integer,\n primary key(user_id, day)\n )`);\n await sqlite.execute(`create table if not exists voice_members(\n room text,\n user_id integer,\n username text,\n gang text,\n joined_at integer,\n primary key(room, user_id)\n )`);\n await sqlite.execute(`create table if not exists voice_signals(\n id integer primary key autoincrement,\n room text,\n from_id integer,\n to_id integer,\n type text,\n payload text,\n created_at integer\n )`);\n}\n\n/* ---------- Quiz ---------- */\nexport async function getQuiz(day: string) {\n return one(`select * from quiz where day=?`, [day]);\n}\nexport async function setQuiz(q: { day: string; question: string; options: string[]; correct_index: number; points: number }) {\n await run(`insert or replace into quiz(day,question,options,correct_index,points,created_at) values(?,?,?,?,?,?)`,\n [q.day, q.question, JSON.stringify(q.options), q.correct_index, q.points, Date.now()]);\n}\nexport async function hasAnswered(userId: number, day: string) {\n return !!(await one(`select 1 from quiz_answers where user_id=? and day=?`, [userId, day]));\n}\nexport async function recordAnswer(userId: number, day: string, correct: boolean, points: number) {\n await run(`insert or replace into quiz_answers(user_id, day, correct, points) values(?,?,?,?)`,\n [userId, day, correct ? 1 : 0, points]);\n}\n\n/* ---------- Voce (signaling) ---------- */\nexport async function voiceJoin(room: string, u: { id: number; username: string; gang: string }) {\n await run(`insert or replace into voice_members(room,user_id,username,gang,joined_at) values(?,?,?,?,?)`,\n [room, u.id, u.username, u.gang, Date.now()]);\n}\nexport async function voiceLeave(room: string, userId: number) {\n await run(`delete from voice_members where room=? and user_id=?`, [room, userId]);\n}\nexport async function voiceMembers(room: string) {\n return all(`select user_id,username,gang from voice_members where room=?`, [room]);\n}\nexport async function voiceSignal(room: string, fromId: number, toId: number, type: string, payload: string) {\n await run(`insert into voice_signals(room,from_id,to_id,type,payload,created_at) values(?,?,?,?,?,?)`,\n [room, fromId, toId, type, payload, Date.now()]);\n}\nexport async function voicePoll(room: string, userId: number) {\n const rows = await all(\n `select * from voice_signals where room=? and to_id=? order by id asc`,\n [room, userId]\n );\n await run(`delete from voice_signals where room=? and to_id=?`, [room, userId]);\n return rows.map((r) => ({ from: r.from_id, type: r.type, payload: r.payload }));\n}\n/* ============ KIDS / PARENT ============ */\n\n// Migrazioni per la tabella users esistente (colonne aggiunte dopo la prima creazione)\nexport async function migrateUsers() {\n const cols: [string, string][] = [\n [\"birthdate\", \"text default ''\"],\n [\"account_type\", \"text default 'adult'\"],\n [\"parent_email\", \"text default ''\"],\n [\"parent_password_hash\", \"text default ''\"],\n [\"approved_adults\", \"text default '[]'\"],\n [\"parent_id\", \"integer default 0\"],\n ];\n for (const [name, def] of cols) {\n try { await sqlite.execute(`alter table users add column ${name} ${def}`); } catch { /* già presente */ }\n }\n}\n\nexport function approvedIds(user): number[] {\n try { const a = JSON.parse(user.approved_adults || \"[]\"); return Array.isArray(a) ? a : []; } catch { return []; }\n}\n\n// Il minore collega il genitore: verifica email+password di un account adulto\nexport async function linkParent(kidId: number, parentEmail: string, parentPassword: string) {\n const parent = await one(`select * from users where (email=? or username=?)`, [parentEmail, parentEmail]);\n if (!parent || parent.account_type !== \"adult\") return { ok: false, error: \"Genitore non trovato o non adulto.\" };\n if (!verifyPassword(parentPassword, parent.password_hash)) return { ok: false, error: \"Password del genitore non valida.\" };\n await run(`update users set parent_id=?, parent_email=?, parent_password_hash=? where id=?`,\n [parent.id, parent.email, hashPassword(parentPassword), kidId]);\n return { ok: true, parent: { id: parent.id, username: parent.username, email: parent.email } };\n}\n\nexport async function getChildren(parentId: number) {\n return all(`select * from users where parent_id=?`, [parentId]);\n}\n\nexport async function isParentOf(user, kidId: number) {\n return !!(await one(`select 1 from users where id=? and parent_id=?`, [kidId, user.id]));\n}\n\nexport async function setApproved(kidId: number, adultId: number, approved: boolean) {\n const kid = await one(`select * from users where id=?`, [kidId]);\n if (!kid) return false;\n const ids = approvedIds(kid);\n const idx = ids.indexOf(adultId);\n if (approved && idx < 0) ids.push(adultId);\n if (!approved && idx >= 0) ids.splice(idx, 1);\n await run(`update users set approved_adults=? where id=?`, [JSON.stringify(ids), kidId]);\n return true;\n}\n","deleted",false,"label",[14],"04621590-24d7-4a6e-a07f-c6eb4e83173c",["D",1787230784811],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","PawClash - social gaming e chat Cani vs Gatti","imageUrl","userId","0a880d95-63a6-4aa5-a9a6-f555d59e8e06","pinnedFileId","1ff2d258-9c97-11f1-929c-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a01f3f-02e6-7262-9080-38100524d429","tursoName","0462159024d74a6ea07fc6eb4e83173c","tursoHostname","0462159024d74a6ea07fc6eb4e83173c-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789484509295],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_106":102},"org",{"_9":10,"_99":100,"_101":102,"_55":56,"_103":104,"_105":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",76,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Culo Strapulito","avatar","https://lh3.googleusercontent.com/a/ACg8ocIeVk9HaXvlnsQ8A8vEjQDC-1WhW5qmqTX5X2uiOA3C_iuoKQ=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_140":141,"_142":143,"_144":145,"_146":42,"_147":42,"_148":42,"_149":32,"_150":-5,"_151":-7,"_152":-7,"_153":63,"_154":42,"_155":42,"_156":-5,"_157":42,"_158":42,"_159":42,"_160":-5},"ENV",{"_111":112,"_113":114,"_115":90,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]