[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_336":337,"_338":339},"routes/_app.x.$handle.$name",{"_96":95,"_32":44,"_105":86,"_26":52,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",123,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":29},"file",{"_30":31,"_32":33,"_34":35,"_36":-5,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","games/roda-putar/untitled-folder-542","latestPath","games/roda-putar/views","fileId","89998a18-9dc2-11f1-8633-1607ee4eb77e","name","untitled-folder-542","fileType","directory","content","createdAt",["D",1787359428284],"branchVersion","branchId","bd2fe270-08f5-4680-8e93-d0b723d2f35b","id","a8f6ac52-3919-4075-bb42-dbbec1ede301","games_edukatif",["D",1787214292968],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","992961c3-d853-4f33-891e-6befa08ebdea","pinnedFileId","d6b97946-9c70-11f1-8f5e-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e816c-8138-77ee-90fb-c8d9a829576f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":54,"_101":102,"_103":24},"branch",{"_13":85,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",939,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","thesleepyholic","handle","displayName","The Sleepy Holic","avatar","https://lh3.googleusercontent.com/a/ACg8ocKWNutdQNCKQpzm17_HQMSp-JDJOlBElSxJRU2c9jv12VMyENZs=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_32":44,"_37":332,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":333,"_80":334,"_82":335,"_84":24},"tree",[198,211,214,215,216,217,218],"files",[198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218],"counts",{"_187":62,"_188":140,"_189":62,"_190":191,"_192":193},"contents",[126,127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":181,"_32":182,"_30":183,"_136":-5,"_40":41,"_39":184,"_138":58,"_37":185,"_13":140,"_34":35,"_36":-5,"_23":24,"_142":-5,"_26":186},{"_42":175,"_32":176,"_30":177,"_136":-5,"_40":41,"_39":178,"_138":58,"_37":179,"_13":158,"_34":35,"_36":-5,"_23":24,"_142":-5,"_26":180},{"_42":168,"_32":169,"_30":170,"_136":-5,"_40":41,"_39":171,"_138":58,"_37":172,"_13":158,"_34":141,"_36":173,"_23":24,"_142":-5,"_26":174},{"_42":160,"_32":161,"_30":162,"_136":-5,"_40":41,"_39":163,"_138":24,"_37":164,"_13":165,"_34":141,"_36":166,"_23":24,"_142":-5,"_26":167},{"_42":153,"_32":154,"_30":155,"_136":-5,"_40":41,"_39":156,"_138":24,"_37":157,"_13":158,"_34":141,"_36":52,"_23":24,"_142":-5,"_26":159},{"_42":144,"_32":145,"_30":56,"_136":-5,"_40":41,"_39":146,"_138":24,"_37":147,"_13":148,"_34":149,"_36":150,"_23":24,"_142":151,"_26":152},{"_42":133,"_32":134,"_30":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":139,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_26":143},"8a2275dc-ead8-404d-ab00-4b8756e972e2","supabase-client.ts","36281b06-9dc2-11f1-b7b0-1607ee4eb77e","parentId",111,"latest",["D",1787359297345],1,"script","label",[134],"2d16913b-9b7c-41a8-820e-bdd76ec3811d","main.ts",71,["D",1787294699000],10,"http","import {\n verifySession,\n createSessionToken,\n hashPassword,\n generateSalt,\n sessionCookie,\n clearSessionCookie,\n} from \"./auth.ts\";\nimport * as db from \"./database.ts\";\nimport { renderLogin } from \"./views/login.ts\";\nimport { renderHub } from \"./views/hub.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/bank-editor.ts\";\nimport { renderGamePlay } from \"./views/game-play.ts\";\nimport { renderRekap } from \"./views/rekap.ts\";\nimport { renderRodaDashboard } from \"./views/roda-dashboard.ts\";\nimport { renderRodaEditor } from \"./views/roda-editor.ts\";\nimport { renderRodaPlay } from \"./views/roda-play.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\n\nfunction html(content: string, extraHeaders: Record = {}) {\n return new Response(content, {\n headers: { \"content-type\": \"text/html\", ...extraHeaders },\n });\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n const method = req.method;\n\n // ============================================================\n // ===== AUTH ROUTES (tidak butuh session) =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/login\") {\n return html(await renderLogin());\n }\n\n if (method === \"POST\" && path === \"/api/register\") {\n try {\n const body = await req.json();\n if (!body.email || !body.password || !body.nama) {\n return json({ error: \"Nama, email, dan password wajib diisi\" }, 400);\n }\n if (body.password.length < 6) {\n return json({ error: \"Password minimal 6 karakter\" }, 400);\n }\n const existing = await db.getGuruByEmail(body.email);\n if (existing) {\n return json({ error: \"Email sudah terdaftar\" }, 400);\n }\n const salt = generateSalt();\n const hash = await hashPassword(body.password, salt);\n const guru = await db.createGuru(body.email, hash, salt, body.nama);\n const token = await createSessionToken(guru.id, guru.nama);\n return new Response(JSON.stringify({ ok: true }), {\n status: 200,\n headers: {\n \"content-type\": \"application/json\",\n \"set-cookie\": sessionCookie(token),\n },\n });\n } catch (e) {\n return json({ error: \"Gagal mendaftar: \" + (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path === \"/api/login\") {\n try {\n const body = await req.json();\n if (!body.email || !body.password) {\n return json({ error: \"Email dan password wajib diisi\" }, 400);\n }\n const guru = await db.getGuruByEmail(body.email);\n if (!guru) {\n return json({ error: \"Email atau password salah\" }, 401);\n }\n const hash = await hashPassword(body.password, guru.salt);\n if (hash !== guru.password_hash) {\n return json({ error: \"Email atau password salah\" }, 401);\n }\n const token = await createSessionToken(guru.id, guru.nama);\n return new Response(JSON.stringify({ ok: true }), {\n status: 200,\n headers: {\n \"content-type\": \"application/json\",\n \"set-cookie\": sessionCookie(token),\n },\n });\n } catch (e) {\n return json({ error: \"Gagal masuk: \" + (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path === \"/api/logout\") {\n return new Response(JSON.stringify({ ok: true }), {\n status: 200,\n headers: {\n \"content-type\": \"application/json\",\n \"set-cookie\": clearSessionCookie(),\n },\n });\n }\n\n // ============================================================\n // ===== CEK SESSION UNTUK SEMUA ROUTE LAIN =====\n // ============================================================\n\n const session = await verifySession(req);\n if (!session) {\n if (method === \"GET\" && !path.startsWith(\"/api/\")) {\n return new Response(null, { status: 302, headers: { location: \"/login\" } });\n }\n return json({ error: \"Unauthorized\" }, 401);\n }\n const guruId = session.guruId;\n\n // ============================================================\n // ===== HALAMAN (HTML) =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/\") {\n return html(await renderHub(guruId, session.nama));\n }\n\n // --- Kuis Kotak ---\n if (method === \"GET\" && path === \"/kuis-kotak\") {\n return html(await renderDashboard(guruId, session.nama));\n }\n if (method === \"GET\" && path.startsWith(\"/bank/\") && path.endsWith(\"/edit\")) {\n const bankId = path.split(\"/\")[2];\n return html(await renderBankEditor(bankId));\n }\n if (method === \"GET\" && path.startsWith(\"/main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderGamePlay(sesiId));\n }\n\n // --- Roda Putar Untung ---\n if (method === \"GET\" && path === \"/roda-putar\") {\n return html(await renderRodaDashboard(guruId, session.nama));\n }\n if (method === \"GET\" && path.startsWith(\"/roda-bank/\") && path.endsWith(\"/edit\")) {\n const bankId = path.split(\"/\")[2];\n return html(await renderRodaEditor(bankId));\n }\n if (method === \"GET\" && path.startsWith(\"/roda-main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderRodaPlay(sesiId));\n }\n\n if (method === \"GET\" && path === \"/rekap\") {\n return html(await renderRekap(guruId));\n }\n\n // ============================================================\n // ===== API: KUIS KOTAK - BANK SOAL =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/api/bank\") {\n try {\n return json(await db.getBankSoalList(guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"GET\" && path.startsWith(\"/api/bank/\") && path.split(\"/\").length === 4) {\n try {\n const bankId = path.split(\"/\")[3];\n return json(await db.getBankSoalById(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path === \"/api/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n const jumlahKotak = Number(body.jumlahKotak) || 16;\n if (jumlahKotak < 4 || jumlahKotak > 100) {\n return json({ error: \"Jumlah kotak harus antara 4 sampai 100\" }, 400);\n }\n return json(await db.createBankSoal(guruId, body.namaBank, body.mapel, body.kelas, jumlahKotak));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"DELETE\" && path.startsWith(\"/api/bank/\") && path.split(\"/\").length === 4) {\n try {\n const bankId = path.split(\"/\")[3];\n await db.deleteBankSoal(bankId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== API: KUIS KOTAK - SOAL =====\n // ============================================================\n\n if (method === \"GET\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")) {\n try {\n const bankId = path.split(\"/\")[3];\n return json(await db.getSoalByBank(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")) {\n try {\n const bankId = path.split(\"/\")[3];\n const body = await req.json();\n if (!body.nomorKotak || !body.pertanyaan) {\n return json({ error: \"Nomor kotak dan pertanyaan wajib diisi\" }, 400);\n }\n return json(await db.upsertSoal(bankId, body.nomorKotak, body.pertanyaan, body.jawaban, body.poin ?? 10, body.gambarUrl));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== API: KUIS KOTAK - SESI =====\n // ============================================================\n\n if (method === \"POST\" && path === \"/api/sesi\") {\n try {\n const body = await req.json();\n if (!body.bankId || !body.namaSesi || !Array.isArray(body.timList) || body.timList.length < 1 || body.timList.length > 20) {\n return json({ error: \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-20 tim)\" }, 400);\n }\n return json(await db.createSesi(body.bankId, guruId, body.namaSesi, body.kelas, body.modePembukaan === \"urut\" ? \"urut\" : \"bebas\", body.timList));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"GET\" && path.startsWith(\"/api/sesi/\") && path.split(\"/\").length === 4) {\n try {\n const sesiId = path.split(\"/\")[3];\n return json(await db.getSesiDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/kotak\")) {\n try {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n if (!body.nomorKotak) return json({ error: \"Nomor kotak wajib diisi\" }, 400);\n return json(await db.bukaKotak(sesiId, body.nomorKotak, body.timId ?? null, !!body.benar, body.poinDidapat ?? 0));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/giliran\")) {\n try {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n await db.updateGiliran(sesiId, body.giliranBaru ?? 0);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/selesai\")) {\n try {\n const sesiId = path.split(\"/\")[3];\n await db.selesaikanSesi(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== API: RODA PUTAR - BANK SOAL =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/api/roda/bank\") {\n try {\n return json(await db.getRodaBankList(guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path === \"/api/roda/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n return json(await db.createRodaBank(guruId, body.namaBank, body.mapel, body.kelas));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"DELETE\" && path.startsWith(\"/api/roda/bank/\") && path.split(\"/\").length === 5) {\n try {\n const bankId = path.split(\"/\")[4];\n await db.deleteRodaBank(bankId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== API: RODA PUTAR - SOAL =====\n // ============================================================\n\n if (method === \"GET\" && path.startsWith(\"/api/roda/bank/\") && path.endsWith(\"/soal\")) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getRodaSoalByBank(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/roda/bank/\") && path.endsWith(\"/soal\")) {\n try {\n const bankId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.pertanyaan) return json({ error: \"Pertanyaan wajib diisi\" }, 400);\n return json(await db.addRodaSoal(bankId, body.pertanyaan, body.jawaban));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"PUT\" && path.startsWith(\"/api/roda/soal/\")) {\n try {\n const soalId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.pertanyaan) return json({ error: \"Pertanyaan wajib diisi\" }, 400);\n return json(await db.updateRodaSoal(soalId, body.pertanyaan, body.jawaban));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"DELETE\" && path.startsWith(\"/api/roda/soal/\")) {\n try {\n const soalId = path.split(\"/\")[4];\n await db.deleteRodaSoal(soalId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== API: RODA PUTAR - SESI =====\n // ============================================================\n\n if (method === \"POST\" && path === \"/api/roda/sesi\") {\n try {\n const body = await req.json();\n if (!body.bankId || !body.namaSesi || !Array.isArray(body.timList) || body.timList.length < 1 || body.timList.length > 20) {\n return json({ error: \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-20 tim)\" }, 400);\n }\n return json(await db.createRodaSesi(body.bankId, guruId, body.namaSesi, body.kelas, body.timList));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"GET\" && path.startsWith(\"/api/roda/sesi/\") && path.split(\"/\").length === 5) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getRodaSesiDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/roda/sesi/\") && path.endsWith(\"/putaran\")) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.timId) return json({ error: \"Tim wajib diisi\" }, 400);\n await db.catatPutaran(sesiId, body.soalId ?? null, body.timId, !!body.benar, body.poinDidapat ?? 0, body.segmen ?? \"\");\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/roda/sesi/\") && path.endsWith(\"/giliran\")) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n await db.updateRodaGiliran(sesiId, body.giliranBaru ?? 0);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/roda/sesi/\") && path.endsWith(\"/selesai\")) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.selesaikanRodaSesi(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== API: REKAP (Kuis Kotak) =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/api/rekap\") {\n try {\n const kelas = url.searchParams.get(\"kelas\") ?? undefined;\n return json(await db.getRekapByKelas(guruId, kelas));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== 404 =====\n // ============================================================\n\n return new Response(\"Not found\", { status: 404 });\n}","gameskelas",[145],"ea0de4b7-bd80-43ea-a4f2-289fd9a6c245","db-core.ts","b3904b78-9dc1-11f1-986c-1607ee4eb77e",83,["D",1787359092721],2,[154],"534a5ecf-2ba3-4574-9f7b-e99aa20ef8d3","database.ts","9e39efba-9c70-11f1-919b-1607ee4eb77e",70,["D",1787294677394],5,"import { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nconst supabase = createClient(\n Deno.env.get(\"SUPABASE_URL\")!,\n Deno.env.get(\"SUPABASE_SERVICE_KEY\")!,\n);\n\n// ============================================================\n// ===== GURU (AUTH) =====\n// ============================================================\n\nexport async function getGuruByEmail(email: string) {\n const { data, error } = await supabase.from(\"game_guru\").select(\"*\").eq(\"email\", email).maybeSingle();\n if (error) throw error;\n return data;\n}\n\nexport async function createGuru(email: string, passwordHash: string, salt: string, nama: string) {\n const { data, error } = await supabase\n .from(\"game_guru\")\n .insert({ email, password_hash: passwordHash, salt, nama })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\n// ============================================================\n// ===== KUIS KOTAK: BANK SOAL =====\n// ============================================================\n\nexport async function getBankSoalList(guruId: string) {\n const { data, error } = await supabase\n .from(\"game_bank_soal\")\n .select(\"*\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function getBankSoalById(bankId: string) {\n const { data, error } = await supabase.from(\"game_bank_soal\").select(\"*\").eq(\"id\", bankId).single();\n if (error) throw error;\n return data;\n}\n\nexport async function createBankSoal(guruId: string, namaBank: string, mapel: string, kelas: string, jumlahKotak: number) {\n const { data, error } = await supabase\n .from(\"game_bank_soal\")\n .insert({ guru_id: guruId, nama_bank: namaBank, mapel, kelas, jumlah_kotak: jumlahKotak })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteBankSoal(bankId: string) {\n const { error } = await supabase.from(\"game_bank_soal\").delete().eq(\"id\", bankId);\n if (error) throw error;\n}\n\n// ============================================================\n// ===== KUIS KOTAK: SOAL =====\n// ============================================================\n\nexport async function getSoalByBank(bankId: string) {\n const { data, error } = await supabase\n .from(\"game_soal\")\n .select(\"*\")\n .eq(\"bank_id\", bankId)\n .order(\"nomor_kotak\");\n if (error) throw error;\n return data;\n}\n\nexport async function upsertSoal(bankId: string, nomorKotak: number, pertanyaan: string, jawaban: string, poin: number, gambarUrl?: string) {\n const { data, error } = await supabase\n .from(\"game_soal\")\n .upsert(\n { bank_id: bankId, nomor_kotak: nomorKotak, pertanyaan, jawaban, poin, gambar_url: gambarUrl ?? null },\n { onConflict: \"bank_id,nomor_kotak\" },\n )\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\n// ============================================================\n// ===== KUIS KOTAK: SESI =====\n// ============================================================\n\nexport async function createSesi(bankId: string, guruId: string, namaSesi: string, kelas: string, modePembukaan: \"bebas\" | \"urut\", timList: { nama: string; warna: string }[]) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_sesi\")\n .insert({ bank_id: bankId, guru_id: guruId, nama_sesi: namaSesi, kelas, mode_pembukaan: modePembukaan })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n }));\n const { data: timData, error: timError } = await supabase.from(\"game_tim\").insert(timRows).select();\n if (timError) throw timError;\n\n return { sesi, tim: timData };\n}\n\nexport async function getSesiDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase.from(\"game_sesi\").select(\"*\").eq(\"id\", sesiId).single();\n if (sesiError) throw sesiError;\n\n const { data: bank, error: bankError } = await supabase\n .from(\"game_bank_soal\")\n .select(\"jumlah_kotak\")\n .eq(\"id\", sesi.bank_id)\n .single();\n if (bankError) throw bankError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"game_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"nomor_kotak\");\n if (soalError) throw soalError;\n\n const { data: tim, error: timError } = await supabase\n .from(\"game_tim\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId)\n .order(\"urutan\");\n if (timError) throw timError;\n\n const { data: kotakTerpakai, error: kotakError } = await supabase\n .from(\"game_kotak_terpakai\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId);\n if (kotakError) throw kotakError;\n\n return { sesi, soal, tim, kotakTerpakai, jumlahKotak: bank?.jumlah_kotak ?? 16 };\n}\n\nexport async function bukaKotak(sesiId: string, nomorKotak: number, timId: string | null, benar: boolean, poinDidapat: number) {\n const { data, error } = await supabase\n .from(\"game_kotak_terpakai\")\n .insert({ sesi_id: sesiId, nomor_kotak: nomorKotak, tim_menjawab_id: timId, benar, poin_didapat: poinDidapat })\n .select()\n .single();\n if (error) throw error;\n\n if (timId && benar) {\n const { data: timSekarang } = await supabase.from(\"game_tim\").select(\"skor\").eq(\"id\", timId).single();\n await supabase.from(\"game_tim\").update({ skor: (timSekarang?.skor ?? 0) + poinDidapat }).eq(\"id\", timId);\n }\n\n return data;\n}\n\nexport async function updateGiliran(sesiId: string, giliranBaru: number) {\n const { error } = await supabase.from(\"game_sesi\").update({ giliran_tim_index: giliranBaru }).eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function selesaikanSesi(sesiId: string) {\n const { error } = await supabase\n .from(\"game_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\n// ============================================================\n// ===== KUIS KOTAK: REKAP =====\n// ============================================================\n\nexport async function getRekapByKelas(guruId: string, kelas?: string) {\n let query = supabase\n .from(\"game_sesi\")\n .select(\"*, game_tim(*)\")\n .eq(\"guru_id\", guruId)\n .eq(\"status\", \"selesai\")\n .order(\"tanggal\", { ascending: false });\n if (kelas) query = query.eq(\"kelas\", kelas);\n\n const { data, error } = await query;\n if (error) throw error;\n return data;\n}\n\n// ============================================================\n// ===== RODA PUTAR UNTUNG: BANK SOAL =====\n// ============================================================\n\nexport async function getRodaBankList(guruId: string) {\n const { data, error } = await supabase\n .from(\"roda_bank_soal\")\n .select(\"*, roda_soal(count)\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function createRodaBank(guruId: string, namaBank: string, mapel: string, kelas: string) {\n const { data, error } = await supabase\n .from(\"roda_bank_soal\")\n .insert({ guru_id: guruId, nama_bank: namaBank, mapel, kelas })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteRodaBank(bankId: string) {\n const { error } = await supabase.from(\"roda_bank_soal\").delete().eq(\"id\", bankId);\n if (error) throw error;\n}\n\n// ============================================================\n// ===== RODA PUTAR UNTUNG: SOAL =====\n// ============================================================\n\nexport async function getRodaSoalByBank(bankId: string) {\n const { data, error } = await supabase\n .from(\"roda_soal\")\n .select(\"*\")\n .eq(\"bank_id\", bankId)\n .order(\"created_at\");\n if (error) throw error;\n return data;\n}\n\nexport async function addRodaSoal(bankId: string, pertanyaan: string, jawaban: string) {\n const { data, error } = await supabase\n .from(\"roda_soal\")\n .insert({ bank_id: bankId, pertanyaan, jawaban })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function updateRodaSoal(soalId: string, pertanyaan: string, jawaban: string) {\n const { data, error } = await supabase\n .from(\"roda_soal\")\n .update({ pertanyaan, jawaban })\n .eq(\"id\", soalId)\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteRodaSoal(soalId: string) {\n const { error } = await supabase.from(\"roda_soal\").delete().eq(\"id\", soalId);\n if (error) throw error;\n}\n\n// ============================================================\n// ===== RODA PUTAR UNTUNG: SESI =====\n// ============================================================\n\nexport async function createRodaSesi(bankId: string, guruId: string, namaSesi: string, kelas: string, timList: { nama: string; warna: string }[]) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"roda_sesi\")\n .insert({ bank_id: bankId, guru_id: guruId, nama_sesi: namaSesi, kelas })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n }));\n const { data: timData, error: timError } = await supabase.from(\"roda_tim\").insert(timRows).select();\n if (timError) throw timError;\n\n return { sesi, tim: timData };\n}\n\nexport async function getRodaSesiDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase.from(\"roda_sesi\").select(\"*\").eq(\"id\", sesiId).single();\n if (sesiError) throw sesiError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"roda_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id);\n if (soalError) throw soalError;\n\n const { data: tim, error: timError } = await supabase\n .from(\"roda_tim\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId)\n .order(\"urutan\");\n if (timError) throw timError;\n\n const { data: soalTerpakai, error: terpakaiError } = await supabase\n .from(\"roda_soal_terpakai\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId);\n if (terpakaiError) throw terpakaiError;\n\n return { sesi, soal, tim, soalTerpakai };\n}\n\nexport async function catatPutaran(sesiId: string, soalId: string | null, timId: string, benar: boolean, poinDidapat: number, segmen: string) {\n if (soalId) {\n const { error } = await supabase\n .from(\"roda_soal_terpakai\")\n .insert({ sesi_id: sesiId, soal_id: soalId, tim_menjawab_id: timId, benar, poin_didapat: poinDidapat, segmen });\n if (error) throw error;\n }\n\n if (timId && benar && poinDidapat > 0) {\n const { data: timSekarang } = await supabase.from(\"roda_tim\").select(\"skor\").eq(\"id\", timId).single();\n await supabase.from(\"roda_tim\").update({ skor: (timSekarang?.skor ?? 0) + poinDidapat }).eq(\"id\", timId);\n }\n}\n\nexport async function updateRodaGiliran(sesiId: string, giliranBaru: number) {\n const { error } = await supabase.from(\"roda_sesi\").update({ giliran_tim_index: giliranBaru }).eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function selesaikanRodaSesi(sesiId: string) {\n const { error } = await supabase\n .from(\"roda_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\n// ============================================================\n// ===== RODA PUTAR UNTUNG: REKAP =====\n// ============================================================\n\nexport async function getRekapRodaByKelas(guruId: string, kelas?: string) {\n let query = supabase\n .from(\"roda_sesi\")\n .select(\"*, roda_tim(*)\")\n .eq(\"guru_id\", guruId)\n .eq(\"status\", \"selesai\")\n .order(\"tanggal\", { ascending: false });\n if (kelas) query = query.eq(\"kelas\", kelas);\n\n const { data, error } = await query;\n if (error) throw error;\n return data;\n}",[161],"34e0f9f7-2329-4657-a5ca-cb990c59951d","auth.ts","6e8ebe28-9c73-11f1-a8b3-1607ee4eb77e",27,["D",1787215541674],"const SESSION_SECRET = Deno.env.get(\"SESSION_SECRET\") || \"\";\nconst SESSION_MAX_AGE_MS = 1000 * 60 * 60 * 24 * 30; // 30 hari\n\nif (!SESSION_SECRET) {\n console.warn(\"PERINGATAN: SESSION_SECRET belum di-set di environment variables!\");\n}\n\nfunction toHex(buffer: ArrayBuffer): string {\n return Array.from(new Uint8Array(buffer)).map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nasync function hmac(data: string): Promise {\n const key = await crypto.subtle.importKey(\n \"raw\",\n new TextEncoder().encode(SESSION_SECRET),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sig = await crypto.subtle.sign(\"HMAC\", key, new TextEncoder().encode(data));\n return toHex(sig);\n}\n\nexport async function createSessionToken(guruId: string, nama: string): Promise {\n const payload = JSON.stringify({ guruId, nama, exp: Date.now() + SESSION_MAX_AGE_MS });\n const payloadB64 = btoa(payload);\n const sig = await hmac(payloadB64);\n return `${payloadB64}.${sig}`;\n}\n\nexport async function verifySession(req: Request): Promise<{ guruId: string; nama: string } | null> {\n const cookieHeader = req.headers.get(\"cookie\") || \"\";\n const match = cookieHeader.match(/session=([^;]+)/);\n if (!match) return null;\n const token = decodeURIComponent(match[1]);\n const [payloadB64, sig] = token.split(\".\");\n if (!payloadB64 || !sig) return null;\n const expectedSig = await hmac(payloadB64);\n if (expectedSig !== sig) return null;\n try {\n const payload = JSON.parse(atob(payloadB64));\n if (payload.exp < Date.now()) return null;\n return { guruId: payload.guruId, nama: payload.nama };\n } catch {\n return null;\n }\n}\n\nexport async function hashPassword(password: string, salt: string): Promise {\n const data = new TextEncoder().encode(password + \":\" + salt);\n const hashBuffer = await crypto.subtle.digest(\"SHA-256\", data);\n return toHex(hashBuffer);\n}\n\nexport function generateSalt(): string {\n const bytes = crypto.getRandomValues(new Uint8Array(16));\n return toHex(bytes.buffer);\n}\n\nexport function sessionCookie(token: string): string {\n const maxAgeSec = Math.floor(SESSION_MAX_AGE_MS / 1000);\n return `session=${encodeURIComponent(token)}; Path=/; HttpOnly; SameSite=Lax; Max-Age=${maxAgeSec}`;\n}\n\nexport function clearSessionCookie(): string {\n return `session=; Path=/; HttpOnly; SameSite=Lax; Max-Age=0`;\n}",[169],"a5f01678-8f40-4754-b592-9c087f0f18f5","views","f6179b4a-9dc1-11f1-865b-1607ee4eb77e",99,["D",1787359193118],[176],"141224d9-eabb-4789-92d4-2063be919ce1","games","d12ebe6c-9dc1-11f1-8450-1607ee4eb77e",88,["D",1787359122388],[182],"pulls","branches","forks","envVars",{"_194":196,"_197":62},"connections",{"_194":62,"_195":62},"count","unfilledCount",6,"emptyCount",{"_42":181,"_32":182,"_30":183,"_136":-5,"_40":41,"_39":184,"_138":58,"_37":329,"_13":140,"_34":35,"_36":-5,"_23":24,"_142":-5,"_220":330,"_26":331},{"_42":324,"_32":283,"_30":278,"_136":183,"_40":41,"_39":325,"_138":58,"_37":326,"_13":140,"_34":35,"_36":-5,"_23":24,"_142":-5,"_220":327,"_26":328},{"_42":319,"_32":176,"_30":293,"_136":278,"_40":41,"_39":320,"_138":58,"_37":321,"_13":140,"_34":35,"_36":-5,"_23":24,"_142":-5,"_220":322,"_26":323},{"_42":312,"_32":313,"_30":314,"_136":293,"_40":41,"_39":315,"_138":24,"_37":316,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":317,"_26":318},{"_42":305,"_32":306,"_30":307,"_136":293,"_40":41,"_39":308,"_138":24,"_37":309,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":310,"_26":311},{"_42":298,"_32":299,"_30":300,"_136":293,"_40":41,"_39":301,"_138":24,"_37":302,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":303,"_26":304},{"_42":290,"_32":291,"_30":292,"_136":293,"_40":41,"_39":294,"_138":24,"_37":295,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":296,"_26":297},{"_42":284,"_32":161,"_30":285,"_136":278,"_40":41,"_39":286,"_138":24,"_37":287,"_13":158,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":288,"_26":289},{"_42":276,"_32":253,"_30":277,"_136":278,"_40":41,"_39":279,"_138":24,"_37":280,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":281,"_26":282},{"_42":271,"_32":260,"_30":255,"_136":183,"_40":41,"_39":272,"_138":58,"_37":273,"_13":140,"_34":35,"_36":-5,"_23":24,"_142":-5,"_220":274,"_26":275},{"_42":267,"_32":33,"_30":31,"_136":255,"_40":41,"_39":14,"_138":24,"_37":268,"_13":62,"_34":35,"_36":-5,"_23":24,"_142":-5,"_220":269,"_26":270},{"_42":261,"_32":161,"_30":262,"_136":255,"_40":41,"_39":263,"_138":24,"_37":264,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":265,"_26":266},{"_42":252,"_32":253,"_30":254,"_136":255,"_40":41,"_39":256,"_138":24,"_37":257,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":258,"_26":259},{"_42":175,"_32":176,"_30":177,"_136":-5,"_40":41,"_39":178,"_138":58,"_37":249,"_13":158,"_34":35,"_36":-5,"_23":24,"_142":-5,"_220":250,"_26":251},{"_42":242,"_32":243,"_30":244,"_136":177,"_40":41,"_39":245,"_138":24,"_37":246,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":247,"_26":248},{"_42":235,"_32":236,"_30":237,"_136":177,"_40":41,"_39":238,"_138":24,"_37":239,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":240,"_26":241},{"_42":168,"_32":169,"_30":170,"_136":-5,"_40":41,"_39":171,"_138":58,"_37":232,"_13":158,"_34":141,"_36":173,"_23":24,"_142":-5,"_220":233,"_26":234},{"_42":160,"_32":161,"_30":162,"_136":-5,"_40":41,"_39":163,"_138":24,"_37":229,"_13":165,"_34":141,"_36":166,"_23":24,"_142":-5,"_220":230,"_26":231},{"_42":153,"_32":154,"_30":155,"_136":-5,"_40":41,"_39":156,"_138":24,"_37":226,"_13":158,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":227,"_26":228},{"_42":144,"_32":145,"_30":56,"_136":-5,"_40":41,"_39":146,"_138":24,"_37":223,"_13":148,"_34":149,"_36":150,"_23":24,"_142":151,"_220":224,"_26":225},{"_42":133,"_32":134,"_30":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":219,"_13":140,"_34":141,"_36":52,"_23":24,"_142":-5,"_220":221,"_26":222},["D",1787359297345],"children",[],[134],["D",1787294699000],[],[145],["D",1787359092721],[],[154],["D",1787294677394],[],[161],["D",1787215541674],[],[169],"2e45b852-4ebf-4e1b-9334-e0ac4efea6e8","login.ts","0322fa6e-9dc2-11f1-8479-1607ee4eb77e",101,["D",1787359207105],[],[176,236],"3e2316be-1790-447f-bc3c-600dc035df12","hub.ts","08121762-9dc2-11f1-be5f-1607ee4eb77e",103,["D",1787359214723],[],[176,243],["D",1787359193118],[212,213],[176],"86a94ca1-3d60-4162-9eda-3dd66f6bd58b","router.ts","1d8cce16-9dc2-11f1-97c0-1607ee4eb77e","122c696e-9dc2-11f1-a094-1607ee4eb77e",109,["D",1787359251184],[],[182,260,253],"roda-putar","74625d96-6835-436b-8adc-400e2cd22d49","196e2c44-9dc2-11f1-b5b4-1607ee4eb77e",107,["D",1787359244346],[],[182,260,161],"96a25d92-949b-4252-a882-5b0ad4e6af58",["D",1787359428284],[],[182,260,33],"7db4471b-95fd-418e-b09c-ea20b8606e40",105,["D",1787359234169],[208,209,210],[182,260],"b3cde821-39bb-4659-ad46-13621e520b50","ebe3c4c8-9dc1-11f1-a919-1607ee4eb77e","de507bbc-9dc1-11f1-97c0-1607ee4eb77e",95,["D",1787359168495],[],[182,283,253],"kuis-kotak","36981f8d-4daa-4c0d-943b-7c3013c27dd3","d70b4c24-9dc1-11f1-8727-1607ee4eb77e",93,["D",1787359154691],[],[182,283,161],"95d64ba5-f595-4c28-b595-fc970a1d151f","rekap.ts","766d7936-9dc2-11f1-8bb9-1607ee4eb77e","494a7346-9dc2-11f1-ad17-1607ee4eb77e",122,["D",1787359400670],[],[182,283,176,291],"9a1243bb-ca1f-45b0-b8b3-f8633b272967","play.ts","5d51443c-9dc2-11f1-b6ab-1607ee4eb77e",120,["D",1787359359093],[],[182,283,176,299],"5bad4e89-89b9-4bbe-b267-2ea6f1ea95af","dashboard.ts","52c55b98-9dc2-11f1-b3e3-1607ee4eb77e",116,["D",1787359342153],[],[182,283,176,306],"c7c186da-c53c-48d4-8934-df96db7eae74","bank-editor.ts","586491ae-9dc2-11f1-af7c-1607ee4eb77e",118,["D",1787359350390],[],[182,283,176,313],"756d84b6-dcc6-492d-9d3e-624aa0d48694",114,["D",1787359329490],[201,202,203,204],[182,283,176],"8134dfe3-aee3-4e4f-995c-1cb59aea6ef2",92,["D",1787359148187],[200,205,206],[182,283],["D",1787359122388],[199,207],[182],["D",1787214292968],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":54,"_101":102,"_103":24},{"_13":85,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_123":369,"_370":371,"_372":373,"_374":24,"_375":24,"_376":24,"_377":58,"_378":-5,"_379":-7,"_380":-7,"_381":62,"_382":24,"_383":24,"_384":-5,"_385":24,"_386":24,"_387":24,"_388":-5},"ENV",{"_340":341,"_342":343,"_344":86,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v123