Masuk - Game Kelas Seru

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_352":353,"_354":355},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_106":87,"_27":37,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":59,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":37,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",138,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","games/kuis-kotak/router.ts","latestPath","fileId","ebe3c4c8-9dc1-11f1-a919-1607ee4eb77e","name","router.ts","fileType","script","content","","import * as db from \"./database.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/bank-editor.ts\";\nimport { renderGamePlay } from \"./views/play.ts\";\nimport { renderRekap } from \"./views/rekap.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}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nexport async function handleKuisKotak(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n namaGuru: string,\n): Promise {\n // ===== HALAMAN =====\n if (method === \"GET\" && path === \"/kuis-kotak\") {\n return html(await renderDashboard(guruId, namaGuru));\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 if (method === \"GET\" && path === \"/rekap\") {\n return html(await renderRekap(guruId));\n }\n\n // ===== API: BANK SOAL =====\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 if (\n method === \"GET\" && path.startsWith(\"/api/bank/\") &&\n path.split(\"/\").length === 4\n ) {\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 if (method === \"POST\" && path === \"/api/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) {\n return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n }\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(\n await db.createBankSoal(\n guruId,\n body.namaBank,\n body.mapel,\n body.kelas,\n jumlahKotak,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/bank/\") &&\n path.split(\"/\").length === 4\n ) {\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 // ===== API: SOAL =====\n if (\n method === \"GET\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")\n ) {\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 if (\n method === \"POST\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")\n ) {\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(\n await db.upsertSoal(\n bankId,\n body.nomorKotak,\n body.pertanyaan,\n body.jawaban,\n body.poin ?? 10,\n body.gambarUrl,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SESI =====\n if (method === \"POST\" && path === \"/api/sesi\") {\n try {\n const body = await req.json();\n if (\n !body.bankId || !body.namaSesi || !Array.isArray(body.timList) ||\n body.timList.length < 1 || body.timList.length > 20\n ) {\n return json({\n error:\n \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-20 tim)\",\n }, 400);\n }\n return json(\n await db.createSesi(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n body.modePembukaan === \"urut\" ? \"urut\" : \"bebas\",\n body.timList,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/sesi/\") &&\n path.split(\"/\").length === 4\n ) {\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 if (\n method === \"POST\" && path.startsWith(\"/api/sesi/\") &&\n path.endsWith(\"/kotak\")\n ) {\n try {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n if (!body.nomorKotak) {\n return json({ error: \"Nomor kotak wajib diisi\" }, 400);\n }\n return json(\n await db.bukaKotak(\n sesiId,\n body.nomorKotak,\n body.timId ?? null,\n !!body.benar,\n body.poinDidapat ?? 0,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sesi/\") &&\n path.endsWith(\"/giliran\")\n ) {\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 if (\n method === \"POST\" && path.startsWith(\"/api/sesi/\") &&\n path.endsWith(\"/selesai\")\n ) {\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 // ===== API: REKAP =====\n if (method === \"GET\" && path === \"/api/rekap\") {\n try {\n const url = new URL(req.url);\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 return null;\n}","createdAt",["D",1787359607480],"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",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"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",{"_44":45,"_32":46,"_39":348,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":37,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":349,"_81":350,"_83":351,"_85":25},"tree",[193,209,212,213,214,215],"files",[193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215],"counts",{"_182":63,"_183":180,"_184":63,"_185":186,"_187":188},"contents",[127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":175,"_32":176,"_30":177,"_136":-5,"_42":43,"_41":178,"_138":59,"_39":179,"_13":180,"_34":173,"_36":-5,"_24":25,"_142":-5,"_27":181},{"_44":168,"_32":169,"_30":170,"_136":-5,"_42":43,"_41":171,"_138":59,"_39":172,"_13":140,"_34":173,"_36":-5,"_24":25,"_142":-5,"_27":174},{"_44":161,"_32":162,"_30":163,"_136":-5,"_42":43,"_41":164,"_138":59,"_39":165,"_13":140,"_34":35,"_36":166,"_24":25,"_142":-5,"_27":167},{"_44":153,"_32":154,"_30":155,"_136":-5,"_42":43,"_41":156,"_138":59,"_39":157,"_13":158,"_34":35,"_36":159,"_24":25,"_142":-5,"_27":160},{"_44":144,"_32":145,"_30":57,"_136":-5,"_42":43,"_41":146,"_138":25,"_39":147,"_13":148,"_34":149,"_36":150,"_24":25,"_142":151,"_27":152},{"_44":133,"_32":134,"_30":135,"_136":-5,"_42":43,"_41":137,"_138":59,"_39":139,"_13":140,"_34":35,"_36":141,"_24":25,"_142":-5,"_27":143},"23eaec3a-e2a3-4937-8b98-a83fd1156545","supabase-client.ts","36281b06-9dc2-11f1-b7b0-1607ee4eb77e","parentId",131,"latest",["D",1787359474898],2,"import { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nexport const supabase = createClient(\n Deno.env.get(\"SUPABASE_URL\")!,\n Deno.env.get(\"SUPABASE_SERVICE_KEY\")!,\n);","label",[134],"d9f34fa1-4ab8-45ab-9823-ef22e7ad7261","main.ts",134,["D",1787359543309],11,"http","import {\n clearSessionCookie,\n createSessionToken,\n generateSalt,\n hashPassword,\n sessionCookie,\n verifySession,\n} from \"./auth.ts\";\nimport * as dbCore from \"./db-core.ts\";\nimport { renderLogin } from \"./views/login.ts\";\nimport { renderHub } from \"./views/hub.ts\";\nimport { handleKuisKotak } from \"./games/kuis-kotak/router.ts\";\nimport { handleRodaPutar } from \"./games/roda-putar/router.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) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\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 (shared, 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 dbCore.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 dbCore.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 dbCore.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, {\n status: 302,\n headers: { location: \"/login\" },\n });\n }\n return json({ error: \"Unauthorized\" }, 401);\n }\n const guruId = session.guruId;\n const namaGuru = session.nama;\n\n // ============================================================\n // ===== HUB (shared) =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/\") {\n return html(await renderHub(guruId, namaGuru));\n }\n\n // ============================================================\n // ===== DELEGASI KE MODUL GAME =====\n // Setiap modul mengembalikan Response kalau route-nya cocok,\n // atau null kalau bukan urusannya — lalu diteruskan ke modul berikutnya.\n // ============================================================\n\n const kuisKotakResponse = await handleKuisKotak(\n req,\n method,\n path,\n guruId,\n namaGuru,\n );\n if (kuisKotakResponse) return kuisKotakResponse;\n\n const rodaPutarResponse = await handleRodaPutar(\n req,\n method,\n path,\n guruId,\n namaGuru,\n );\n if (rodaPutarResponse) return rodaPutarResponse;\n\n // ============================================================\n // ===== 404 =====\n // ============================================================\n\n return new Response(\"Not found\", { status: 404 });\n}","gameskelas",[145],"173e9b66-f9c2-4d94-9bab-a0eca131bb9d","db-core.ts","b3904b78-9dc1-11f1-986c-1607ee4eb77e",132,["D",1787359509276],3,"import { supabase } from \"./supabase-client.ts\";\n\nexport async function getGuruByEmail(email: string) {\n const { data, error } = await supabase.from(\"game_guru\").select(\"*\").eq(\n \"email\",\n email,\n ).maybeSingle();\n if (error) throw error;\n return data;\n}\n\nexport async function createGuru(\n email: string,\n passwordHash: string,\n salt: string,\n nama: string,\n) {\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}",[154],"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}",[162],"a5f01678-8f40-4754-b592-9c087f0f18f5","views","f6179b4a-9dc1-11f1-865b-1607ee4eb77e",99,["D",1787359193118],"directory",[169],"141224d9-eabb-4789-92d4-2063be919ce1","games","d12ebe6c-9dc1-11f1-8450-1607ee4eb77e",88,["D",1787359122388],1,[176],"pulls","branches","forks","envVars",{"_189":191,"_192":63},"connections",{"_189":63,"_190":63},"count","unfilledCount",6,"emptyCount",{"_44":175,"_32":176,"_30":177,"_136":-5,"_42":43,"_41":178,"_138":59,"_39":345,"_13":180,"_34":173,"_36":-5,"_24":25,"_142":-5,"_217":346,"_27":347},{"_44":340,"_32":300,"_30":296,"_136":177,"_42":43,"_41":341,"_138":59,"_39":342,"_13":180,"_34":173,"_36":-5,"_24":25,"_142":-5,"_217":343,"_27":344},{"_44":335,"_32":169,"_30":311,"_136":296,"_42":43,"_41":336,"_138":59,"_39":337,"_13":180,"_34":173,"_36":-5,"_24":25,"_142":-5,"_217":338,"_27":339},{"_44":328,"_32":329,"_30":330,"_136":311,"_42":43,"_41":331,"_138":25,"_39":332,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":333,"_27":334},{"_44":322,"_32":279,"_30":323,"_136":311,"_42":43,"_41":324,"_138":25,"_39":325,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":326,"_27":327},{"_44":316,"_32":264,"_30":317,"_136":311,"_42":43,"_41":318,"_138":25,"_39":319,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":320,"_27":321},{"_44":308,"_32":309,"_30":310,"_136":311,"_42":43,"_41":312,"_138":25,"_39":313,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":314,"_27":315},{"_44":301,"_32":257,"_30":302,"_136":296,"_42":43,"_41":303,"_138":25,"_39":304,"_13":158,"_34":35,"_36":305,"_24":25,"_142":-5,"_217":306,"_27":307},{"_44":295,"_32":33,"_30":31,"_136":296,"_42":43,"_41":14,"_138":25,"_39":297,"_13":140,"_34":35,"_36":38,"_24":25,"_142":-5,"_217":298,"_27":299},{"_44":290,"_32":255,"_30":250,"_136":177,"_42":43,"_41":291,"_138":59,"_39":292,"_13":180,"_34":173,"_36":-5,"_24":25,"_142":-5,"_217":293,"_27":294},{"_44":285,"_32":169,"_30":266,"_136":250,"_42":43,"_41":286,"_138":59,"_39":287,"_13":180,"_34":173,"_36":-5,"_24":25,"_142":-5,"_217":288,"_27":289},{"_44":278,"_32":279,"_30":280,"_136":266,"_42":43,"_41":281,"_138":25,"_39":282,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":283,"_27":284},{"_44":271,"_32":272,"_30":273,"_136":266,"_42":43,"_41":274,"_138":25,"_39":275,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":276,"_27":277},{"_44":263,"_32":264,"_30":265,"_136":266,"_42":43,"_41":267,"_138":25,"_39":268,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":269,"_27":270},{"_44":256,"_32":257,"_30":258,"_136":250,"_42":43,"_41":259,"_138":25,"_39":260,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":261,"_27":262},{"_44":248,"_32":33,"_30":249,"_136":250,"_42":43,"_41":251,"_138":25,"_39":252,"_13":180,"_34":35,"_36":37,"_24":25,"_142":-5,"_217":253,"_27":254},{"_44":168,"_32":169,"_30":170,"_136":-5,"_42":43,"_41":171,"_138":59,"_39":245,"_13":140,"_34":173,"_36":-5,"_24":25,"_142":-5,"_217":246,"_27":247},{"_44":237,"_32":238,"_30":239,"_136":170,"_42":43,"_41":240,"_138":25,"_39":241,"_13":140,"_34":35,"_36":242,"_24":25,"_142":-5,"_217":243,"_27":244},{"_44":229,"_32":230,"_30":231,"_136":170,"_42":43,"_41":232,"_138":25,"_39":233,"_13":140,"_34":35,"_36":234,"_24":25,"_142":-5,"_217":235,"_27":236},{"_44":161,"_32":162,"_30":163,"_136":-5,"_42":43,"_41":164,"_138":59,"_39":226,"_13":140,"_34":35,"_36":166,"_24":25,"_142":-5,"_217":227,"_27":228},{"_44":153,"_32":154,"_30":155,"_136":-5,"_42":43,"_41":156,"_138":59,"_39":223,"_13":158,"_34":35,"_36":159,"_24":25,"_142":-5,"_217":224,"_27":225},{"_44":144,"_32":145,"_30":57,"_136":-5,"_42":43,"_41":146,"_138":25,"_39":220,"_13":148,"_34":149,"_36":150,"_24":25,"_142":151,"_217":221,"_27":222},{"_44":133,"_32":134,"_30":135,"_136":-5,"_42":43,"_41":137,"_138":59,"_39":216,"_13":140,"_34":35,"_36":141,"_24":25,"_142":-5,"_217":218,"_27":219},["D",1787359474898],"children",[],[134],["D",1787359543309],[],[145],["D",1787359509276],[],[154],["D",1787215541674],[],[162],"15bc6465-17c0-47e8-860b-7f7e1f2e07ae","login.ts","0322fa6e-9dc2-11f1-8479-1607ee4eb77e",135,["D",1787359562689],"export async function renderLogin(errorMsg?: string): Promise {\n return `\n\n\n \n \n Masuk - Game Kelas Seru\n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[169,230],"88b136e4-6ea1-45b5-bafe-f0cb8443b6fe","hub.ts","08121762-9dc2-11f1-be5f-1607ee4eb77e",136,["D",1787359573942],"export async function renderHub(\n guruId: string,\n namaGuru: string,\n): Promise {\n return `\n\n\n \n \n Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[169,238],["D",1787359193118],[210,211],[169],"86a94ca1-3d60-4162-9eda-3dd66f6bd58b","1d8cce16-9dc2-11f1-97c0-1607ee4eb77e","122c696e-9dc2-11f1-a094-1607ee4eb77e",109,["D",1787359251184],[],[176,255,33],"roda-putar","74625d96-6835-436b-8adc-400e2cd22d49","database.ts","196e2c44-9dc2-11f1-b5b4-1607ee4eb77e",107,["D",1787359244346],[],[176,255,257],"8ce50a5a-d466-49a4-b12f-24c97c2570b8","play.ts","9b40a53a-9dc2-11f1-a6c9-1607ee4eb77e","89998a18-9dc2-11f1-8633-1607ee4eb77e",130,["D",1787359461734],[],[176,255,169,264],"9e4b7e2b-281d-4290-b2da-9cf9b1bda9bb","editor.ts","9345ab5a-9dc2-11f1-b3e3-1607ee4eb77e",128,["D",1787359453724],[],[176,255,169,272],"e1c6e0a7-d923-4785-88b3-47113cbe745e","dashboard.ts","8ec04144-9dc2-11f1-a56c-1607ee4eb77e",126,["D",1787359442028],[],[176,255,169,279],"e97daa62-78e9-44b2-97cb-dace918a7ce1",124,["D",1787359432574],[204,205,206],[176,255,169],"7db4471b-95fd-418e-b09c-ea20b8606e40",105,["D",1787359234169],[203,207,208],[176,255],"23391cfc-cc8f-4c67-8144-fe54c9aea795","de507bbc-9dc1-11f1-97c0-1607ee4eb77e",["D",1787359607480],[],[176,300,33],"kuis-kotak","a8601f65-63ab-4eac-ac18-d25190386697","d70b4c24-9dc1-11f1-8727-1607ee4eb77e",137,["D",1787359595676],"import { supabase } from \"../../supabase-client.ts\";\n\n// ===== BANK SOAL =====\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(\n \"id\",\n bankId,\n ).single();\n if (error) throw error;\n return data;\n}\n\nexport async function createBankSoal(\n guruId: string,\n namaBank: string,\n mapel: string,\n kelas: string,\n jumlahKotak: number,\n) {\n const { data, error } = await supabase\n .from(\"game_bank_soal\")\n .insert({\n guru_id: guruId,\n nama_bank: namaBank,\n mapel,\n kelas,\n jumlah_kotak: jumlahKotak,\n })\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(\n \"id\",\n bankId,\n );\n if (error) throw error;\n}\n\n// ===== SOAL =====\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(\n bankId: string,\n nomorKotak: number,\n pertanyaan: string,\n jawaban: string,\n poin: number,\n gambarUrl?: string,\n) {\n const { data, error } = await supabase\n .from(\"game_soal\")\n .upsert(\n {\n bank_id: bankId,\n nomor_kotak: nomorKotak,\n pertanyaan,\n jawaban,\n poin,\n gambar_url: gambarUrl ?? null,\n },\n { onConflict: \"bank_id,nomor_kotak\" },\n )\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\n// ===== SESI =====\n\nexport async function createSesi(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n modePembukaan: \"bebas\" | \"urut\",\n timList: { nama: string; warna: string }[],\n) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_sesi\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n mode_pembukaan: modePembukaan,\n })\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\")\n .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\")\n .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 {\n sesi,\n soal,\n tim,\n kotakTerpakai,\n jumlahKotak: bank?.jumlah_kotak ?? 16,\n };\n}\n\nexport async function bukaKotak(\n sesiId: string,\n nomorKotak: number,\n timId: string | null,\n benar: boolean,\n poinDidapat: number,\n) {\n const { data, error } = await supabase\n .from(\"game_kotak_terpakai\")\n .insert({\n sesi_id: sesiId,\n nomor_kotak: nomorKotak,\n tim_menjawab_id: timId,\n benar,\n poin_didapat: poinDidapat,\n })\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\")\n .eq(\"id\", timId).single();\n await supabase.from(\"game_tim\").update({\n skor: (timSekarang?.skor ?? 0) + poinDidapat,\n }).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({\n giliran_tim_index: giliranBaru,\n }).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// ===== REKAP =====\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}",[],[176,300,257],"95d64ba5-f595-4c28-b595-fc970a1d151f","rekap.ts","766d7936-9dc2-11f1-8bb9-1607ee4eb77e","494a7346-9dc2-11f1-ad17-1607ee4eb77e",122,["D",1787359400670],[],[176,300,169,309],"9a1243bb-ca1f-45b0-b8b3-f8633b272967","5d51443c-9dc2-11f1-b6ab-1607ee4eb77e",120,["D",1787359359093],[],[176,300,169,264],"5bad4e89-89b9-4bbe-b267-2ea6f1ea95af","52c55b98-9dc2-11f1-b3e3-1607ee4eb77e",116,["D",1787359342153],[],[176,300,169,279],"c7c186da-c53c-48d4-8934-df96db7eae74","bank-editor.ts","586491ae-9dc2-11f1-af7c-1607ee4eb77e",118,["D",1787359350390],[],[176,300,169,329],"756d84b6-dcc6-492d-9d3e-624aa0d48694",114,["D",1787359329490],[196,197,198,199],[176,300,169],"8134dfe3-aee3-4e4f-995c-1cb59aea6ef2",92,["D",1787359148187],[195,200,201],[176,300],["D",1787359122388],[194,202],[176],["D",1787214292968],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":385,"_386":387,"_388":389,"_390":25,"_391":25,"_392":25,"_393":59,"_394":-5,"_395":-7,"_396":-7,"_397":63,"_398":25,"_399":25,"_400":-5,"_401":25,"_402":25,"_403":25,"_404":-5},"ENV",{"_356":357,"_358":359,"_360":87,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v138