[{"_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","boh","name","bubble","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/boh/bubble/code/db.ts","extension","id","77e15f67-d1fb-44bb-87cd-2a6c439c82e6","fileId","c1f8e3e2-9d7a-11f1-b3ef-1607ee4eb77e","parentId","branchId","619b1123-b1f7-4e0c-b131-2749ec7bfb30","branchVersion",13,"latest",true,"createdAt",["D",1787328997735],"version",3,"fileType","script","content","// Bubble — persistenza (SQLite project-scoped di Val Town)\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL, -- hash (demo: sha256 via WebCrypto)\n age INTEGER NOT NULL,\n tier TEXT NOT NULL, -- 'adult' (14+) | 'kids' (<14)\n parent_id INTEGER,\n parent_pending INTEGER DEFAULT 0,\n level INTEGER DEFAULT 1, -- Livello Forza dell'Ordine\n xp INTEGER DEFAULT 0,\n reports_correct INTEGER DEFAULT 0,\n reports_total INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS friendships (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_a INTEGER NOT NULL,\n user_b INTEGER NOT NULL,\n UNIQUE(user_a, user_b)\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n sender INTEGER NOT NULL,\n receiver INTEGER NOT NULL,\n body TEXT NOT NULL,\n kind TEXT DEFAULT 'text', -- text | sticker | ai_mod\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS reports (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n reporter INTEGER NOT NULL,\n target INTEGER NOT NULL,\n reason TEXT NOT NULL,\n verdict TEXT DEFAULT 'pending', -- pending | founded | dismissed\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nexport type User = {\n id: number;\n username: string;\n age: number;\n tier: \"adult\" | \"kids\";\n parent_id: number | null;\n parent_pending: number;\n level: number;\n xp: number;\n};\n\n// --- hash password (demo, WebCrypto) ---\nexport async function hashPassword(pw: string): Promise {\n const data = new TextEncoder().encode(\"bubble::\" + pw);\n const digest = await crypto.subtle.digest(\"SHA-256\", data);\n return [...new Uint8Array(digest)].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nexport function userFromRow(row: any): User {\n return {\n id: row.id,\n username: row.username,\n age: row.age,\n tier: row.tier,\n parent_id: row.parent_id,\n parent_pending: row.parent_pending,\n level: row.level,\n xp: row.xp,\n };\n}\n\nexport async function findByUsername(username: string): Promise {\n const r = await sqlite.execute({ sql: \"SELECT * FROM users WHERE username = ?\", args: [username] });\n return r.rows.length ? userFromRow(r.rows[0]) : null;\n}\n\nexport async function findById(id: number): Promise {\n const r = await sqlite.execute({ sql: \"SELECT * FROM users WHERE id = ?\", args: [id] });\n return r.rows.length ? userFromRow(r.rows[0]) : null;\n}\n\nexport async function createUser(username: string, passwordHash: string, age: number): Promise {\n const tier = age >= 14 ? \"adult\" : \"kids\";\n await sqlite.execute({\n sql: \"INSERT INTO users (username, password, age, tier) VALUES (?,?,?,?)\",\n args: [username, passwordHash, age, tier],\n });\n return (await findByUsername(username))!;\n}\n\nexport async function checkPassword(username: string, passwordHash: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE username = ? AND password = ?\",\n args: [username, passwordHash],\n });\n return r.rows.length ? userFromRow(r.rows[0]) : null;\n}\n\n// --- amicizie ---\nexport async function addFriend(a: number, b: number) {\n const lo = Math.min(a, b);\n const hi = Math.max(a, b);\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO friendships (user_a, user_b) VALUES (?,?)\",\n args: [lo, hi],\n });\n}\n\nexport async function contactsOf(userId: number): Promise {\n const r = await sqlite.execute({\n sql: `SELECT u.* FROM users u\n JOIN friendships f ON (f.user_a = u.id OR f.user_b = u.id)\n WHERE (f.user_a = ? OR f.user_b = ?) AND u.id != ?`,\n args: [userId, userId, userId],\n });\n return r.rows.map(userFromRow);\n}\n\n// --- messaggi ---\nexport async function sendMessage(sender: number, receiver: number, body: string, kind = \"text\") {\n await sqlite.execute({\n sql: \"INSERT INTO messages (sender, receiver, body, kind) VALUES (?,?,?,?)\",\n args: [sender, receiver, body, kind],\n });\n}\n\nexport async function thread(a: number, b: number) {\n const r = await sqlite.execute({\n sql: `SELECT * FROM messages\n WHERE (sender=? AND receiver=?) OR (sender=? AND receiver=?)\n ORDER BY id ASC`,\n args: [a, b, b, a],\n });\n return r.rows;\n}\n\n// --- segnalazioni & gamification ---\nexport async function addReport(reporter: number, target: number, reason: string): Promise {\n const r = await sqlite.execute({\n sql: \"INSERT INTO reports (reporter, target, reason) VALUES (?,?,?)\",\n args: [reporter, target, reason],\n });\n return Number(r.lastInsertRowid);\n}\n\nexport async function resolveReport(reportId: number, verdict: \"founded\" | \"dismissed\") {\n await sqlite.execute({ sql: \"UPDATE reports SET verdict = ? WHERE id = ?\", args: [verdict, reportId] });\n const r = await sqlite.execute({ sql: \"SELECT * FROM reports WHERE id = ?\", args: [reportId] });\n if (!r.rows.length) return;\n const reporter = await findById(r.rows[0].reporter);\n if (!reporter || reporter.tier === \"kids\") return; // i kids non accumulano punti\n const correct = verdict === \"founded\" ? 1 : 0;\n await sqlite.execute({\n sql: \"UPDATE users SET reports_total = reports_total + 1, reports_correct = reports_correct + ?, xp = xp + ? WHERE id = ?\",\n args: [correct, correct ? 25 : -10, reporter.id],\n });\n // ricalcola livello: ogni 100 XP un livello\n const u = (await findById(reporter.id))!;\n const newLevel = Math.max(1, Math.floor(u.xp / 100) + 1);\n await sqlite.execute({ sql: \"UPDATE users SET level = ? WHERE id = ?\", args: [newLevel, u.id] });\n}\n\n// --- pairing genitore-figlio ---\nexport async function requestParent(childId: number, parentUsername: string): Promise {\n const parent = await findByUsername(parentUsername);\n if (!parent || parent.tier !== \"adult\") return null;\n await sqlite.execute({ sql: \"UPDATE users SET parent_pending = ? WHERE id = ?\", args: [parent.id, childId] });\n return parent;\n}\n\nexport async function approveParent(childId: number, parentId: number): Promise {\n const child = await findById(childId);\n if (!child) return false;\n await sqlite.execute({ sql: \"UPDATE users SET parent_id = ?, parent_pending = 0 WHERE id = ?\", args: [parentId, childId] });\n return true;\n}\n\nexport async function pendingKidsFor(parentId: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE parent_pending = ? AND tier = 'kids'\",\n args: [parentId],\n });\n return r.rows.map(userFromRow);\n}\n\n\n// --- Chat dedicata AI Mod (sempre pronta, in primo piano) ---\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS aimod_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n sender TEXT NOT NULL, -- 'user' | 'ai'\n body TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nexport async function aimodThread(userId: number) {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM aimod_messages WHERE user_id = ? ORDER BY id ASC\",\n args: [userId],\n });\n return r.rows;\n}\n\nexport async function aimodSend(userId: number, sender: \"user\" | \"ai\", body: string) {\n await sqlite.execute({\n sql: \"INSERT INTO aimod_messages (user_id, sender, body) VALUES (?,?,?)\",\n args: [userId, sender, body],\n });\n}\n","deleted",false,"label",[14],"34cb4f20-4a6e-4a39-87da-83a8bbc146a5",["D",1787328583979],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Bubble - app di messaggistica futuristica e anonima","imageUrl","userId","86c0904a-df90-4b28-8be9-0d0cd34688de","pinnedFileId","ca38b974-9d7a-11f1-ae75-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a02515-3428-7129-a58d-ee30dee1111b","tursoName","34cb4f204a6e4a3987da83a8bbc146a5","tursoHostname","34cb4f204a6e4a3987da83a8bbc146a5-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789501263826],"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",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","BCG Collaborazioni","avatar","https://lh3.googleusercontent.com/a/ACg8ocK88V05YV8HsO4yAaG3hTsa_rYvYnQ7JithXHAoBkrpvT9HmN8=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"]