ThunderCross ⚡ Every Character. One Arena.

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_211":212,"_213":214},"routes/_app.x.$handle.$name",{"_103":102,"_37":48,"_112":93,"_32":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":30,"_127":128,"_129":62,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_46":47,"_37":48,"_41":49,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","77233cf6-8114-4acc-827d-a1105ec99812","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":26,"_39":40,"_41":42,"_43":14,"_44":45,"_29":30},"previous","deleted",false,"deletedHere","path","style.css","latestPath","fileId","149250be-b18c-11f1-8598-1607ee4eb77e","name","fileType","content",":root {\n --bg: #0a0a14; --panel: #14142a; --panel-2: #1c1c38; --line: #2a2a52;\n --text: #eef0ff; --muted: #8b8fb5; --bolt: #ffd93d; --accent: #7c5cff; --hot: #ff3d81; --win: #3ddc84;\n}\n* { box-sizing: border-box; }\nbody {\n margin: 0; color: var(--text); min-height: 100vh;\n background: radial-gradient(1200px 600px at 50% -10%, #241a5c 0%, var(--bg) 60%);\n font: 16px/1.5 ui-sans-serif, system-ui, -apple-system, \"Segoe UI\", sans-serif;\n}\na { color: inherit; text-decoration: none; }\nheader {\n display: flex; align-items: center; gap: 18px; padding: 14px 22px; flex-wrap: wrap;\n border-bottom: 1px solid var(--line); position: sticky; top: 0; z-index: 10;\n backdrop-filter: blur(12px); background: rgba(10,10,20,.8);\n}\n.logo { font-weight: 800; font-size: 22px; letter-spacing: -.5px; }\n.logo span { color: var(--bolt); }\nnav { display: flex; gap: 4px; flex-wrap: wrap; }\nnav a { padding: 6px 12px; border-radius: 999px; color: var(--muted); font-size: 14px; font-weight: 600; }\nnav a:hover { color: var(--text); background: var(--panel); }\nnav a.active { color: #fff; background: var(--accent); }\n.me { margin-left: auto; }\n.wrap { max-width: 1100px; margin: 0 auto; padding: 26px 20px 80px; }\n.loading, .empty { text-align: center; color: var(--muted); padding: 40px; }\n.hero { text-align: center; padding: 20px 0 6px; }\n.hero h1 { font-size: clamp(30px, 6vw, 52px); margin: 0 0 8px; letter-spacing: -1.5px; }\n.hero h1 em { font-style: normal; color: var(--bolt); }\n.hero p, .muted { color: var(--muted); margin: 0; }\nh2 { font-size: 14px; text-transform: uppercase; letter-spacing: 1.5px; color: var(--muted); margin: 30px 0 14px; }\nh2:first-child { margin-top: 0; }\n\n.tabs { display: flex; flex-wrap: wrap; gap: 8px; justify-content: center; margin: 18px 0 20px; }\n.tab, .btn, .me {\n background: var(--panel); color: var(--muted); border: 1px solid var(--line);\n padding: 8px 14px; border-radius: 999px; cursor: pointer; font-size: 14px; font-weight: 600; font-family: inherit;\n}\n.tab:hover, .btn:hover, .me:hover { color: var(--text); border-color: var(--accent); }\n.tab.active, .btn.primary { background: var(--accent); border-color: var(--accent); color: #fff; }\n.btn.danger { border-color: var(--hot); color: var(--hot); }\n.btn.small { padding: 5px 10px; font-size: 12.5px; border-radius: 8px; }\n\n.grid { display: grid; grid-template-columns: repeat(auto-fill, minmax(220px, 1fr)); gap: 14px; }\n.card {\n background: linear-gradient(180deg, var(--panel-2), var(--panel)); border: 1px solid var(--line);\n border-radius: 16px; padding: 16px; display: flex; flex-direction: column; gap: 10px;\n transition: transform .12s, border-color .12s; position: relative;\n}\n.card:hover { transform: translateY(-3px); border-color: var(--accent); }\n.rank { position: absolute; top: 12px; right: 14px; color: var(--muted); font-weight: 800; font-size: 13px; }\n.rank.top { color: var(--bolt); }\n.avatar { width: 48px; height: 48px; border-radius: 12px; display: grid; place-items: center; font-size: 24px; background: #2a2050; border: 1px solid var(--line); }\n.name { font-weight: 700; font-size: 16px; }\n.from { color: var(--muted); font-size: 12.5px; }\n.pl { font-size: 12px; color: var(--muted); display: flex; justify-content: space-between; }\n.bar { height: 6px; border-radius: 99px; background: #24244a; overflow: hidden; }\n.bar > i { display: block; height: 100%; background: linear-gradient(90deg, var(--accent), var(--hot)); }\n.stats { display: flex; gap: 10px; font-size: 12.5px; color: var(--muted); }\n.stats b { color: var(--text); }\n.elo { color: var(--bolt); font-weight: 800; }\n\n.arena { display: grid; grid-template-columns: 1fr auto 1fr; gap: 14px; align-items: stretch; }\n.fighter {\n background: var(--panel); border: 1px solid var(--line); border-radius: 18px; padding: 26px 16px;\n text-align: center; cursor: pointer; transition: transform .12s, border-color .12s;\n}\n.fighter:hover { border-color: var(--bolt); transform: scale(1.02); }\n.fighter.won { border-color: var(--win); box-shadow: 0 0 0 3px rgba(61,220,132,.25); }\n.fighter.lost { opacity: .45; }\n.fighter .big { font-size: 56px; line-height: 1.1; }\n.fighter .name { font-size: 20px; margin-top: 6px; }\n.vs { display: grid; place-items: center; font-weight: 900; color: var(--bolt); font-size: 22px; }\n.result { text-align: center; margin: 14px 0; min-height: 26px; font-weight: 700; color: var(--bolt); }\n.center { text-align: center; }\n@media (max-width: 600px) { .arena { grid-template-columns: 1fr; } .vs { padding: 4px; } }\n\nol.board { list-style: none; padding: 0; margin: 0; counter-reset: r; }\nol.board li {\n counter-increment: r; display: flex; align-items: center; gap: 12px; padding: 11px 14px;\n background: var(--panel); border: 1px solid var(--line); border-radius: 12px; margin-bottom: 8px;\n}\nol.board li::before { content: counter(r); color: var(--muted); font-weight: 800; width: 22px; }\nol.board li:nth-child(1)::before { content: \"🥇\"; } ol.board li:nth-child(2)::before { content: \"🥈\"; } ol.board li:nth-child(3)::before { content: \"🥉\"; }\nol.board .pts { margin-left: auto; color: var(--bolt); font-weight: 700; font-size: 14px; white-space: nowrap; }\n.two { display: grid; grid-template-columns: 1fr 1fr; gap: 24px; }\n@media (max-width: 760px) { .two { grid-template-columns: 1fr; } }\n\n.detail { display: grid; grid-template-columns: 120px 1fr; gap: 22px; background: var(--panel); border: 1px solid var(--line); border-radius: 18px; padding: 24px; }\n.detail .big { font-size: 80px; text-align: center; }\n.detail h1 { margin: 0 0 4px; font-size: 32px; }\n@media (max-width: 600px) { .detail { grid-template-columns: 1fr; } .detail .big { font-size: 60px; } }\n\n.post { background: var(--panel); border: 1px solid var(--line); border-radius: 12px; padding: 12px 14px; margin-bottom: 8px; }\n.post .meta { font-size: 12.5px; color: var(--muted); display: flex; gap: 8px; flex-wrap: wrap; }\n.post .meta b { color: var(--text); }\n.post p { margin: 6px 0 0; white-space: pre-wrap; }\n.composer { display: flex; flex-direction: column; gap: 8px; background: var(--panel-2); border: 1px solid var(--line); border-radius: 14px; padding: 14px; margin-bottom: 18px; }\ntextarea, input, select {\n background: #0f0f22; color: var(--text); border: 1px solid var(--line); border-radius: 10px;\n padding: 10px; font: inherit; width: 100%; resize: vertical;\n}\n.row { display: flex; gap: 8px; align-items: center; flex-wrap: wrap; }\n.err { color: var(--hot); font-size: 13px; min-height: 18px; margin-top: 6px; }\n.tag { background: #221d47; color: var(--muted); border-radius: 6px; padding: 2px 8px; font-size: 12px; }\n\n.modal { position: fixed; inset: 0; background: rgba(0,0,0,.65); display: grid; place-items: center; z-index: 50; padding: 20px; }\n.modal-box { background: var(--panel); border: 1px solid var(--line); border-radius: 18px; padding: 24px; width: min(420px, 100%); display: flex; flex-direction: column; gap: 12px; }\n.modal-box h3 { margin: 0; }\n.modal-box label { display: flex; flex-direction: column; gap: 4px; font-size: 13px; color: var(--muted); }\n.hidden { display: none !important; }\nfooter { text-align: center; color: var(--muted); font-size: 13px; padding: 30px 20px; }\n","createdAt",["D",1789535062380],"branchVersion","branchId","76ee823b-b89b-4a08-87a7-69c9e148ad8c","id","d5f2797a-f47c-464e-a8c2-e034552cda7a","thundercross",["D",1789534890275],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Rank characters from movies, TV, anime, games & comics","imageUrl","0fd18287-2d7e-4e88-b2e8-e9d6b7f3764d","pinnedFileId","b32f8e4a-b18b-11f1-a615-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0a896-4a10-7420-8729-7e60c46e2a8a","tursoName","d5f2797af47c464ea8c2e034552cda7a","tursoHostname","d5f2797af47c464ea8c2e034552cda7a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789536037138],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_19":58,"_108":109,"_110":30},"branch",{"_13":92,"_37":93,"_46":45,"_94":47,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":48,"_101":102},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","onga","handle","displayName","O n g a","avatar","https://lh3.googleusercontent.com/a/ACg8ocJN8T3-zTL4h5W1RUrT9Pbh2xj-2t3J0W0iLsRdakR5XyU-acA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_46":47,"_37":48,"_41":206,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":207,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":208,"_87":209,"_89":210,"_91":30},"tree",[185,186,187,188,189],"files",[185,186,187,188,189],"counts",{"_175":66,"_176":157,"_177":66,"_178":179,"_180":181},"contents",[134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_46":168,"_37":169,"_35":170,"_140":-5,"_44":45,"_43":171,"_141":62,"_41":172,"_13":66,"_38":150,"_39":173,"_29":30,"_143":-5,"_32":174},{"_46":161,"_37":162,"_35":163,"_140":-5,"_44":45,"_43":164,"_141":62,"_41":165,"_13":157,"_38":26,"_39":166,"_29":30,"_143":-5,"_32":167},{"_46":153,"_37":154,"_35":60,"_140":-5,"_44":45,"_43":155,"_141":62,"_41":156,"_13":157,"_38":158,"_39":159,"_29":30,"_143":48,"_32":160},{"_46":145,"_37":146,"_35":147,"_140":-5,"_44":45,"_43":148,"_141":62,"_41":149,"_13":66,"_38":150,"_39":151,"_29":30,"_143":-5,"_32":152},{"_46":139,"_37":33,"_35":36,"_140":-5,"_44":45,"_43":14,"_141":62,"_41":142,"_13":66,"_38":26,"_39":40,"_29":30,"_143":-5,"_32":144},"c06d208b-586f-474f-b807-5a0780d1671c","parentId","latest",["D",1789535062380],"label",[33],"b6a0fbf0-68f0-4670-926a-f69b13cd16a6","seed.ts","e50858c0-b18b-11f1-8c9d-1607ee4eb77e",4,["D",1789534982620],"script","export const SEED = [\n // 🎬 Movies\n { name: \"Darth Vader\", franchise: \"Star Wars\", category: \"Movies\", emoji: \"🖤\", power: 92, bio: \"Sith Lord and former Jedi. Master of the dark side and the Force choke.\" },\n { name: \"Ellen Ripley\", franchise: \"Alien\", category: \"Movies\", emoji: \"🚀\", power: 78, bio: \"Warrant officer who out-survived the perfect organism. Twice.\" },\n { name: \"Neo\", franchise: \"The Matrix\", category: \"Movies\", emoji: \"🕶️\", power: 88, bio: \"The One. Bends the rules of the simulation at will.\" },\n { name: \"Indiana Jones\", franchise: \"Indiana Jones\", category: \"Movies\", emoji: \"🤠\", power: 70, bio: \"Archaeologist with a whip, a hat and a serious hatred of snakes.\" },\n { name: \"John Wick\", franchise: \"John Wick\", category: \"Movies\", emoji: \"🔫\", power: 85, bio: \"The Baba Yaga. Focus, commitment, sheer will.\" },\n { name: \"Thanos\", franchise: \"Marvel Cinematic Universe\", category: \"Movies\", emoji: \"🧤\", power: 97, bio: \"The Mad Titan. Inevitable, with or without the stones.\" },\n // 📺 TV Shows\n { name: \"Walter White\", franchise: \"Breaking Bad\", category: \"TV\", emoji: \"🧪\", power: 84, bio: \"Chemistry teacher turned kingpin. He is the one who knocks.\" },\n { name: \"Eleven\", franchise: \"Stranger Things\", category: \"TV\", emoji: \"🔮\", power: 80, bio: \"Telekinetic runaway from Hawkins Lab. Loves Eggos.\" },\n { name: \"Daenerys Targaryen\", franchise: \"Game of Thrones\", category: \"TV\", emoji: \"🐉\", power: 89, bio: \"Mother of Dragons, Breaker of Chains.\" },\n { name: \"Michael Scott\", franchise: \"The Office\", category: \"TV\", emoji: \"📄\", power: 60, bio: \"World's Best Boss. Self-declared.\" },\n { name: \"The Doctor\", franchise: \"Doctor Who\", category: \"TV\", emoji: \"🌀\", power: 90, bio: \"Time Lord from Gallifrey with a bigger-on-the-inside blue box.\" },\n { name: \"Omni-Man\", franchise: \"Invincible\", category: \"TV\", emoji: \"🦸\", power: 96, bio: \"Viltrumite conqueror disguised as Earth's greatest hero.\" },\n // 🎌 Anime\n { name: \"Goku\", franchise: \"Dragon Ball\", category: \"Anime\", emoji: \"🥋\", power: 99, bio: \"Saiyan raised on Earth. Always looking for a stronger opponent.\" },\n { name: \"Levi Ackerman\", franchise: \"Attack on Titan\", category: \"Anime\", emoji: \"🗡️\", power: 90, bio: \"Humanity's strongest soldier.\" },\n { name: \"Gojo Satoru\", franchise: \"Jujutsu Kaisen\", category: \"Anime\", emoji: \"♾️\", power: 97, bio: \"The Honored One. Wields Limitless and the Six Eyes.\" },\n { name: \"Monkey D. Luffy\", franchise: \"One Piece\", category: \"Anime\", emoji: \"🏴‍☠️\", power: 93, bio: \"Future King of the Pirates. Rubber body, iron will.\" },\n { name: \"Saitama\", franchise: \"One Punch Man\", category: \"Anime\", emoji: \"👊\", power: 100, bio: \"A hero for fun. One punch is usually enough.\" },\n { name: \"Naruto Uzumaki\", franchise: \"Naruto\", category: \"Anime\", emoji: \"🍥\", power: 94, bio: \"Seventh Hokage and jinchūriki of the Nine-Tails.\" },\n { name: \"Light Yagami\", franchise: \"Death Note\", category: \"Anime\", emoji: \"📓\", power: 75, bio: \"Genius student with a notebook that kills.\" },\n // 🎮 Games\n { name: \"Kratos\", franchise: \"God of War\", category: \"Games\", emoji: \"🪓\", power: 96, bio: \"Ghost of Sparta. Killed the Greek pantheon, moved to Norway.\" },\n { name: \"Master Chief\", franchise: \"Halo\", category: \"Games\", emoji: \"🛡️\", power: 91, bio: \"Spartan-117. Finishes the fight.\" },\n { name: \"Geralt of Rivia\", franchise: \"The Witcher\", category: \"Games\", emoji: \"🐺\", power: 87, bio: \"White Wolf. Monster hunter for hire.\" },\n { name: \"Lara Croft\", franchise: \"Tomb Raider\", category: \"Games\", emoji: \"🏹\", power: 79, bio: \"Archaeologist-adventurer with dual pistols.\" },\n { name: \"Link\", franchise: \"The Legend of Zelda\", category: \"Games\", emoji: \"🗡️\", power: 88, bio: \"Hero of Hyrule, bearer of the Triforce of Courage.\" },\n { name: \"Sephiroth\", franchise: \"Final Fantasy VII\", category: \"Games\", emoji: \"🌑\", power: 95, bio: \"One-Winged Angel. Very long sword.\" },\n { name: \"Doom Slayer\", franchise: \"DOOM\", category: \"Games\", emoji: \"💀\", power: 94, bio: \"Rip and tear, until it is done.\" },\n // 📚 Comics & Manga\n { name: \"Batman\", franchise: \"DC Comics\", category: \"Comics\", emoji: \"🦇\", power: 90, bio: \"The Dark Knight. Prep time is his superpower.\" },\n { name: \"Superman\", franchise: \"DC Comics\", category: \"Comics\", emoji: \"💠\", power: 98, bio: \"The Man of Steel. Truth, justice and a better tomorrow.\" },\n { name: \"Spider-Man\", franchise: \"Marvel Comics\", category: \"Comics\", emoji: \"🕷️\", power: 86, bio: \"Friendly neighborhood hero with great responsibility.\" },\n { name: \"Wonder Woman\", franchise: \"DC Comics\", category: \"Comics\", emoji: \"⚔️\", power: 93, bio: \"Amazon princess and demigoddess of Themyscira.\" },\n { name: \"Wolverine\", franchise: \"Marvel Comics\", category: \"Comics\", emoji: \"🐾\", power: 84, bio: \"Adamantium claws and a healing factor. Best there is.\" },\n { name: \"Guts\", franchise: \"Berserk\", category: \"Comics\", emoji: \"🗡️\", power: 89, bio: \"The Black Swordsman. Struggles against fate itself.\" },\n { name: \"Doctor Manhattan\", franchise: \"Watchmen\", category: \"Comics\", emoji: \"🔵\", power: 100, bio: \"Quantum god who sees all of time at once.\" },\n];\n",[146],"2f1a9f42-a7ac-41ec-a903-ad6432f9e11e","main.ts",5,["D",1789535016482],1,"http","import { Hono } from \"npm:hono\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { init, sqlite } from \"./db.ts\";\n\nawait init();\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\nconst clean = (s: unknown, max = 40) => String(s ?? \"\").trim().slice(0, max);\nconst handleOk = (h: string) => /^[a-zA-Z0-9_]{2,20}$/.test(h);\n\n// ---------- Static ----------\napp.get(\"/\", () => serveFile(\"index.html\"));\napp.get(\"/app.js\", () => serveFile(\"app.js\"));\napp.get(\"/style.css\", () => serveFile(\"style.css\"));\n\n// ---------- Characters & rankings ----------\napp.get(\"/api/characters\", async (c) => {\n const cat = c.req.query(\"category\");\n const sort = c.req.query(\"sort\") === \"power\" ? \"power DESC, elo DESC\" : \"elo DESC, wins DESC\";\n const { rows } = cat && cat !== \"All\"\n ? await sqlite.execute({ sql: `SELECT * FROM characters WHERE category = ? ORDER BY ${sort}`, args: [cat] })\n : await sqlite.execute(`SELECT * FROM characters ORDER BY ${sort}`);\n return c.json(rows);\n});\n\napp.get(\"/api/characters/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const [{ rows: ch }, { rows: posts }, { rows: recent }] = await Promise.all([\n sqlite.execute({ sql: \"SELECT * FROM characters WHERE id = ?\", args: [id] }),\n sqlite.execute({ sql: \"SELECT * FROM posts WHERE character_id = ? ORDER BY id DESC LIMIT 30\", args: [id] }),\n sqlite.execute({\n sql: `SELECT b.created_at, b.user, b.winner_id = ? AS won,\n w.name AS winner, w.emoji AS winner_emoji, l.name AS loser, l.emoji AS loser_emoji\n FROM battles b JOIN characters w ON w.id = b.winner_id JOIN characters l ON l.id = b.loser_id\n WHERE b.winner_id = ? OR b.loser_id = ? ORDER BY b.id DESC LIMIT 10`,\n args: [id, id, id],\n }),\n ]);\n if (!ch[0]) return c.json({ error: \"not found\" }, 404);\n return c.json({ ...ch[0], posts, recent });\n});\n\n// ---------- Trending: most battles in the last 24h ----------\napp.get(\"/api/trending\", async (c) => {\n const { rows } = await sqlite.execute(`\n SELECT ch.*, COUNT(b.id) AS activity,\n SUM(CASE WHEN b.winner_id = ch.id THEN 1 ELSE 0 END) AS recent_wins\n FROM characters ch\n JOIN battles b ON b.winner_id = ch.id OR b.loser_id = ch.id\n WHERE b.created_at >= datetime('now', '-1 day')\n GROUP BY ch.id ORDER BY activity DESC, recent_wins DESC LIMIT 10`);\n return c.json(rows);\n});\n\n// ---------- Battles ----------\napp.get(\"/api/battle\", async (c) => {\n const cat = c.req.query(\"category\");\n const { rows } = cat && cat !== \"All\"\n ? await sqlite.execute({ sql: \"SELECT * FROM characters WHERE category = ? ORDER BY RANDOM() LIMIT 2\", args: [cat] })\n : await sqlite.execute(\"SELECT * FROM characters ORDER BY RANDOM() LIMIT 2\");\n return c.json(rows);\n});\n\napp.post(\"/api/battle\", async (c) => {\n const { winnerId, loserId, user } = await c.req.json();\n const w = Number(winnerId), l = Number(loserId);\n if (!w || !l || w === l) return c.json({ error: \"bad ids\" }, 400);\n const u = clean(user, 20);\n const handle = handleOk(u) ? u : null;\n\n const { rows } = await sqlite.execute({ sql: \"SELECT id, elo FROM characters WHERE id IN (?, ?)\", args: [w, l] });\n const eloOf = (id: number) => Number(rows.find((r) => Number(r.id) === id)?.elo ?? 1200);\n const Rw = eloOf(w), Rl = eloOf(l);\n const K = 32;\n const expectW = 1 / (1 + 10 ** ((Rl - Rw) / 400));\n const delta = Math.round(K * (1 - expectW));\n\n const stmts: any[] = [\n { sql: \"UPDATE characters SET wins = wins + 1, elo = elo + ? WHERE id = ?\", args: [delta, w] },\n { sql: \"UPDATE characters SET losses = losses + 1, elo = elo - ? WHERE id = ?\", args: [delta, l] },\n { sql: \"INSERT INTO battles (winner_id, loser_id, user) VALUES (?, ?, ?)\", args: [w, l, handle] },\n ];\n if (handle) stmts.push({ sql: \"INSERT OR IGNORE INTO users (handle) VALUES (?)\", args: [handle] });\n await sqlite.batch(stmts);\n return c.json({ ok: true, delta });\n});\n\n// ---------- Leaderboards ----------\napp.get(\"/api/leaderboard\", async (c) => {\n const [{ rows: characters }, { rows: users }] = await Promise.all([\n sqlite.execute(\"SELECT id, name, emoji, franchise, elo, wins, losses FROM characters ORDER BY elo DESC LIMIT 10\"),\n sqlite.execute(`\n SELECT u.handle, u.emoji, COUNT(b.id) AS votes, COUNT(DISTINCT p.id) AS posts\n FROM users u LEFT JOIN battles b ON b.user = u.handle LEFT JOIN posts p ON p.user = u.handle\n GROUP BY u.handle ORDER BY votes DESC LIMIT 10`),\n ]);\n return c.json({ characters, users });\n});\n\n// ---------- Users ----------\napp.post(\"/api/users\", async (c) => {\n const { handle, emoji } = await c.req.json();\n const h = clean(handle, 20);\n if (!handleOk(h)) return c.json({ error: \"Handle must be 2–20 letters, numbers or _\" }, 400);\n await sqlite.execute({\n sql: \"INSERT INTO users (handle, emoji) VALUES (?, ?) ON CONFLICT(handle) DO UPDATE SET emoji = excluded.emoji\",\n args: [h, clean(emoji, 8) || \"⚡\"],\n });\n return c.json({ ok: true, handle: h });\n});\n\napp.get(\"/api/users/:handle\", async (c) => {\n const h = c.req.param(\"handle\");\n const [{ rows: user }, { rows: stats }, { rows: favs }, { rows: posts }] = await Promise.all([\n sqlite.execute({ sql: \"SELECT * FROM users WHERE handle = ?\", args: [h] }),\n sqlite.execute({ sql: \"SELECT COUNT(*) AS votes FROM battles WHERE user = ?\", args: [h] }),\n sqlite.execute({\n sql: `SELECT ch.id, ch.name, ch.emoji, COUNT(*) AS n FROM battles b JOIN characters ch ON ch.id = b.winner_id\n WHERE b.user = ? GROUP BY ch.id ORDER BY n DESC LIMIT 5`,\n args: [h],\n }),\n sqlite.execute({ sql: \"SELECT p.*, ch.name AS character_name FROM posts p LEFT JOIN characters ch ON ch.id = p.character_id WHERE p.user = ? ORDER BY p.id DESC LIMIT 20\", args: [h] }),\n ]);\n if (!user[0]) return c.json({ error: \"not found\" }, 404);\n return c.json({ ...user[0], votes: stats[0].votes, favorites: favs, posts });\n});\n\n// ---------- Discussions ----------\napp.get(\"/api/posts\", async (c) => {\n const { rows } = await sqlite.execute(`\n SELECT p.*, ch.name AS character_name, ch.emoji AS character_emoji, u.emoji AS user_emoji\n FROM posts p LEFT JOIN characters ch ON ch.id = p.character_id LEFT JOIN users u ON u.handle = p.user\n ORDER BY p.id DESC LIMIT 50`);\n return c.json(rows);\n});\n\napp.post(\"/api/posts\", async (c) => {\n const { user, body, characterId } = await c.req.json();\n const h = clean(user, 20), text = clean(body, 500);\n if (!handleOk(h)) return c.json({ error: \"Create a profile first\" }, 400);\n if (text.length < 2) return c.json({ error: \"Say a little more\" }, 400);\n await sqlite.batch([\n { sql: \"INSERT OR IGNORE INTO users (handle) VALUES (?)\", args: [h] },\n { sql: \"INSERT INTO posts (user, character_id, body) VALUES (?, ?, ?)\", args: [h, characterId ? Number(characterId) : null, text] },\n ]);\n return c.json({ ok: true });\n});\n\n// SPA fallback\napp.get(\"*\", () => serveFile(\"index.html\"));\n\nexport default app.fetch;\n",[154],"243ed630-6d7b-4124-ac83-56c9f3752c8b","index.html","b33715e8-b18b-11f1-a615-1607ee4eb77e",6,["D",1789535062326],"\n\n\n\n\nThunderCross ⚡ Every Character. One Arena.\n\n\n\n\n\n

\n ThunderCross ⚡\n \n \n

\n\n

⚡ Charging up…

\n\n\n\n\n\n\n\n\n",[162],"8c12d2f6-8617-4d8c-9a7c-9864efdb2f19","db.ts","e501ae76-b18b-11f1-8c9d-1607ee4eb77e",3,["D",1789534982578],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { SEED } from \"./seed.ts\";\n\nexport { sqlite };\n\nexport async function init() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS characters (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL,\n franchise TEXT NOT NULL,\n category TEXT NOT NULL,\n emoji TEXT NOT NULL,\n power INTEGER NOT NULL,\n bio TEXT DEFAULT '',\n wins INTEGER DEFAULT 0,\n losses INTEGER DEFAULT 0,\n elo INTEGER DEFAULT 1200,\n UNIQUE(name, franchise)\n )`,\n `CREATE TABLE IF NOT EXISTS battles (\n id INTEGER PRIMARY KEY,\n winner_id INTEGER NOT NULL,\n loser_id INTEGER NOT NULL,\n user TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS users (\n handle TEXT PRIMARY KEY,\n emoji TEXT DEFAULT '⚡',\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS posts (\n id INTEGER PRIMARY KEY,\n user TEXT NOT NULL,\n character_id INTEGER,\n body TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n `CREATE INDEX IF NOT EXISTS battles_time ON battles(created_at)`,\n ]);\n\n const { rows } = await sqlite.execute(\"SELECT COUNT(*) AS n FROM characters\");\n if (Number(rows[0].n) === 0) {\n await sqlite.batch(\n SEED.map((c) => ({\n sql: \"INSERT OR IGNORE INTO characters (name, franchise, category, emoji, power, bio) VALUES (?,?,?,?,?,?)\",\n args: [c.name, c.franchise, c.category, c.emoji, c.power, c.bio],\n })),\n );\n }\n}\n",[169],"pulls","branches","forks","envVars",{"_182":66,"_184":66},"connections",{"_182":66,"_183":66},"count","unfilledCount","emptyCount",{"_46":168,"_37":169,"_35":170,"_140":-5,"_44":45,"_43":171,"_141":62,"_41":203,"_13":66,"_38":150,"_39":173,"_29":30,"_143":-5,"_191":204,"_32":205},{"_46":161,"_37":162,"_35":163,"_140":-5,"_44":45,"_43":164,"_141":62,"_41":200,"_13":157,"_38":26,"_39":166,"_29":30,"_143":-5,"_191":201,"_32":202},{"_46":153,"_37":154,"_35":60,"_140":-5,"_44":45,"_43":155,"_141":62,"_41":197,"_13":157,"_38":158,"_39":159,"_29":30,"_143":48,"_191":198,"_32":199},{"_46":145,"_37":146,"_35":147,"_140":-5,"_44":45,"_43":148,"_141":62,"_41":194,"_13":66,"_38":150,"_39":151,"_29":30,"_143":-5,"_191":195,"_32":196},{"_46":139,"_37":33,"_35":36,"_140":-5,"_44":45,"_43":14,"_141":62,"_41":190,"_13":66,"_38":26,"_39":40,"_29":30,"_143":-5,"_191":192,"_32":193},["D",1789535062380],"children",[],[33],["D",1789534982620],[],[146],["D",1789535016482],[],[154],["D",1789535062326],[],[162],["D",1789534982578],[],[169],["D",1789534890275],["D",1789536037138],{"_103":102,"_111":107},{"_103":102,"_104":105,"_106":107,"_19":58,"_108":109,"_110":30},{"_13":92,"_37":93,"_46":45,"_94":47,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":48,"_101":102},"ctx",{"_85":-5,"_131":244,"_245":246,"_247":248,"_249":30,"_250":30,"_251":30,"_252":62,"_253":-5,"_254":-7,"_255":-7,"_256":66,"_257":30,"_258":30,"_259":-5,"_260":30,"_261":30,"_262":30,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":93,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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"]

Create your fighter profile

Diff · v7