Emoji Stocks

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_285":286,"_287":288},"routes/_app.x.$handle.$name",{"_112":111,"_38":57,"_120":102,"_33":121,"_13":14,"_122":-5,"_11":123,"_124":125,"_126":127,"_128":129,"_130":131,"_27":-5,"_132":-5,"_133":-5,"_134":31,"_135":136,"_137":71,"_138":-5,"_139":-5,"_140":141},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_55":56,"_38":57,"_44":58,"_59":-5,"_60":31,"_61":62,"_63":62,"_64":65,"_66":-5,"_19":67,"_68":69,"_70":71,"_72":-5,"_73":-5,"_74":75,"_76":77,"_78":79,"_80":81,"_82":83,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":31},"version",10,"changes",[25,26],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","dee87010-fc5b-442b-943f-4fc5041adbdb","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_27":49,"_29":-7,"_30":31,"_32":31,"_33":50,"_35":50},{"_27":28,"_29":-7,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous","deleted",false,"deletedHere","path","frontend/components/Nav.tsx","latestPath","fileId","a887cc56-38b3-11f1-922c-42b51c65c3df","name","Nav.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface NavProps {\n page: string;\n onNavigate: (p: any) => void;\n user: any;\n onLogout: () => void;\n onLogin: () => void;\n onRegister: () => void;\n}\n\nexport function Nav({ page, onNavigate, user, onLogout, onLogin, onRegister }: NavProps) {\n const link = (p: string, label: string) => (\n \n );\n\n return (\n

\n \n

\n {link(\"home\", \"🏠 Home\")}\n {link(\"submit\", \"📤 Submit\")}\n {link(\"account\", \"👤 Account\")}\n

\n {user ? (\n

\n @{user.username}\n \n

\n ) : (\n <>\n \n \n \n )}\n

\n );\n}\n","createdAt",["D",1776247970282],"branchVersion","branchId","6d6990c8-38b3-11f1-975d-42b51c65c3df",{"_36":51,"_38":52,"_40":53,"_42":-5,"_44":54,"_46":14,"_47":48,"_30":31},"frontend/components","1e871d3f-ddfc-4377-abf7-b5cc2c42c949","components","directory",["D",1776247970282],"id","6d6924d0-38b3-11f1-975d-42b51c65c3df","emoji-stocks",["D",1776247871105],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Discord emoji sharing platform - upload, browse, download","imageUrl","76bc32aa-9423-4ad6-9dc6-ec95cd0150fa","pinnedFileId","91953baa-38b3-11f1-937f-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d909c-3adb-7264-b953-27d10f1e1b4a","tursoName","6d6924d038b311f1975d42b51c65c3df","tursoHostname","6d6924d038b311f1975d42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497078049],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_112":111,"_119":115},"org",{"_112":111,"_113":-5,"_114":115,"_19":67,"_116":117,"_118":31},"branch",{"_13":101,"_38":102,"_55":48,"_103":56,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":57,"_110":111},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Reyster","handle","displayName","avatar","https://avatars.githubusercontent.com/u/270369291?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_55":56,"_38":57,"_44":280,"_59":-5,"_60":31,"_61":62,"_63":62,"_64":65,"_66":-5,"_19":67,"_68":69,"_70":71,"_72":-5,"_73":-5,"_74":75,"_76":77,"_78":79,"_80":81,"_82":281,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":282,"_96":283,"_98":284,"_100":31},"tree",[184,187,194,197],"files",[184,185,186,187,188,189,190,191,192,193,194,195,196,197],"counts",{"_174":75,"_175":171,"_176":75,"_177":178,"_179":180},"contents",[142,143,144,145],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_55":168,"_38":169,"_36":170,"_148":-5,"_47":48,"_46":171,"_150":71,"_44":172,"_13":75,"_40":53,"_42":-5,"_30":31,"_154":-5,"_33":173},{"_55":162,"_38":163,"_36":164,"_148":-5,"_47":48,"_46":165,"_150":71,"_44":166,"_13":75,"_40":53,"_42":-5,"_30":31,"_154":-5,"_33":167},{"_55":156,"_38":157,"_36":158,"_148":-5,"_47":48,"_46":159,"_150":71,"_44":160,"_13":75,"_40":53,"_42":-5,"_30":31,"_154":-5,"_33":161},{"_55":146,"_38":147,"_36":69,"_148":-5,"_47":48,"_46":149,"_150":71,"_44":151,"_13":75,"_40":152,"_42":153,"_30":31,"_154":-5,"_33":155},"91953aec-38b3-11f1-937f-42b51c65c3df","main.tsx","parentId",5,"latest",["D",1776247931788],"http","import { Hono } from \"npm:hono@4\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport {\n createUser, getUserByUsername, createSession, getSession, deleteSession,\n insertEmoji, getAllEmojis, getEmojiById, incrementDownload, getUserStats,\n getCategories, getUserById,\n} from \"./database/queries.ts\";\nimport { hashPassword, verifyPassword, generateToken } from \"./shared/auth.ts\";\nimport { CATEGORIES } from \"./shared/categories.ts\";\n\nconst app = new Hono();\n\napp.onError((err) => Promise.reject(err));\n\n// Run migrations on first request\nlet migrated = false;\napp.use(\"*\", async (c, next) => {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n await next();\n});\n\n// Helper: get current user from session cookie\nasync function getCurrentUser(c: any) {\n const cookie = c.req.header(\"Cookie\") || \"\";\n const match = cookie.match(/session=([^;]+)/);\n if (!match) return null;\n const session = await getSession(match[1]);\n if (!session) return null;\n return getUserById((session as any).user_id);\n}\n\n// ── API Routes ──\n\n// Auth\napp.post(\"/api/register\", async (c) => {\n const { username, password } = await c.req.json();\n if (!username || !password) return c.json({ error: \"Username and password required\" }, 400);\n if (username.length < 3 || username.length > 20) return c.json({ error: \"Username must be 3-20 characters\" }, 400);\n if (password.length < 4) return c.json({ error: \"Password must be at least 4 characters\" }, 400);\n if (!/^[a-zA-Z0-9_]+$/.test(username)) return c.json({ error: \"Username: letters, numbers, underscore only\" }, 400);\n const existing = await getUserByUsername(username);\n if (existing) return c.json({ error: \"Username already taken\" }, 409);\n const hash = await hashPassword(password);\n await createUser(username, hash);\n const user = await getUserByUsername(username);\n const token = generateToken();\n await createSession(token, (user as any).id);\n return c.json({ ok: true, user: { id: (user as any).id, username } }, 200, {\n \"Set-Cookie\": `session=${token}; Path=/; HttpOnly; SameSite=Lax; Max-Age=2592000`,\n });\n});\n\napp.post(\"/api/login\", async (c) => {\n const { username, password } = await c.req.json();\n if (!username || !password) return c.json({ error: \"Username and password required\" }, 400);\n const user = await getUserByUsername(username) as any;\n if (!user) return c.json({ error: \"Invalid credentials\" }, 401);\n const valid = await verifyPassword(password, user.password_hash);\n if (!valid) return c.json({ error: \"Invalid credentials\" }, 401);\n const token = generateToken();\n await createSession(token, user.id);\n return c.json({ ok: true, user: { id: user.id, username: user.username } }, 200, {\n \"Set-Cookie\": `session=${token}; Path=/; HttpOnly; SameSite=Lax; Max-Age=2592000`,\n });\n});\n\napp.post(\"/api/logout\", async (c) => {\n const cookie = c.req.header(\"Cookie\") || \"\";\n const match = cookie.match(/session=([^;]+)/);\n if (match) await deleteSession(match[1]);\n return c.json({ ok: true }, 200, {\n \"Set-Cookie\": \"session=; Path=/; HttpOnly; Max-Age=0\",\n });\n});\n\napp.get(\"/api/me\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) return c.json({ user: null });\n return c.json({ user: { id: (user as any).id, username: (user as any).username } });\n});\n\n// Emojis\napp.get(\"/api/emojis\", async (c) => {\n const category = c.req.query(\"category\");\n const emojis = await getAllEmojis(category);\n return c.json({ emojis });\n});\n\napp.get(\"/api/emojis/:id\", async (c) => {\n const emoji = await getEmojiById(Number(c.req.param(\"id\")));\n if (!emoji) return c.json({ error: \"Not found\" }, 404);\n return c.json({ emoji });\n});\n\napp.get(\"/api/categories\", async (c) => {\n const cats = await getCategories();\n return c.json({ categories: [\"All\", ...CATEGORIES], active: cats });\n});\n\napp.post(\"/api/emojis/upload\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) return c.json({ error: \"Login required\" }, 401);\n const form = await c.req.formData();\n const file = form.get(\"file\") as File | null;\n const name = (form.get(\"name\") as string || \"\").trim();\n const tags = (form.get(\"tags\") as string || \"\").trim();\n const category = (form.get(\"category\") as string) || \"General\";\n const description = (form.get(\"description\") as string || \"\").trim();\n if (!file) return c.json({ error: \"File required\" }, 400);\n if (!name) return c.json({ error: \"Name required\" }, 400);\n if (name.length > 32) return c.json({ error: \"Name too long (max 32)\" }, 400);\n const validTypes = [\"image/png\", \"image/gif\"];\n if (!validTypes.includes(file.type)) return c.json({ error: \"Only PNG or GIF files allowed\" }, 400);\n if (file.size > 512000) return c.json({ error: \"File must be under 500KB\" }, 400);\n const ext = file.type === \"image/gif\" ? \"gif\" : \"png\";\n const key = `emoji-stocks/${Date.now()}-${Math.random().toString(36).slice(2)}.${ext}`;\n const buffer = await file.arrayBuffer();\n await blob.set(key, new Uint8Array(buffer));\n await insertEmoji({\n userId: (user as any).id,\n name,\n tags,\n category,\n description,\n fileKey: key,\n fileType: file.type,\n fileSize: file.size,\n });\n return c.json({ ok: true });\n});\n\n// Serve emoji file\napp.get(\"/api/file/:key{.+}\", async (c) => {\n const key = c.req.param(\"key\");\n try {\n const data = await blob.get(key);\n const bytes = new Uint8Array(await data.arrayBuffer());\n const ct = key.endsWith(\".gif\") ? \"image/gif\" : \"image/png\";\n return new Response(bytes, {\n headers: { \"Content-Type\": ct, \"Cache-Control\": \"public, max-age=86400\" },\n });\n } catch {\n return c.json({ error: \"File not found\" }, 404);\n }\n});\n\n// Download (increments counter)\napp.get(\"/api/download/:id\", async (c) => {\n const emoji = await getEmojiById(Number(c.req.param(\"id\"))) as any;\n if (!emoji) return c.json({ error: \"Not found\" }, 404);\n await incrementDownload(emoji.id);\n try {\n const data = await blob.get(emoji.file_key);\n const bytes = new Uint8Array(await data.arrayBuffer());\n const ext = emoji.file_type === \"image/gif\" ? \"gif\" : \"png\";\n return new Response(bytes, {\n headers: {\n \"Content-Type\": emoji.file_type,\n \"Content-Disposition\": `attachment; filename=\"${emoji.name}.${ext}\"`,\n \"Cache-Control\": \"no-cache\",\n },\n });\n } catch {\n return c.json({ error: \"File not found\" }, 404);\n }\n});\n\n// Account stats\napp.get(\"/api/account/stats\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) return c.json({ error: \"Login required\" }, 401);\n const stats = await getUserStats((user as any).id);\n return c.json(stats);\n});\n\n// Source\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Serve frontend\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path));\napp.get(\"*\", (c) => serveFile(\"/frontend/index.html\"));\n\nexport default app.fetch;\n","label",[147],"7db833b2-38b3-11f1-975d-42b51c65c3df","shared","5e5cf5ad-b714-48ee-b97b-496afea816b0",3,["D",1776247898456],[157],"94cdbcd4-38b3-11f1-937f-42b51c65c3df","frontend","2f94ac99-211b-4d47-b744-7193d0b74f68",6,["D",1776247937191],[163],"715096aa-38b3-11f1-9d78-42b51c65c3df","database","fdd95334-22a7-477d-b4a0-b09dd6343548",1,["D",1776247877648],[169],"pulls","branches","forks","envVars",{"_181":75,"_183":75},"connections",{"_181":75,"_182":75},"count","unfilledCount","emptyCount",{"_55":168,"_38":169,"_36":170,"_148":-5,"_47":48,"_46":171,"_150":71,"_44":277,"_13":75,"_40":53,"_42":-5,"_30":31,"_154":-5,"_199":278,"_33":279},{"_55":270,"_38":271,"_36":272,"_148":170,"_47":48,"_46":171,"_150":71,"_44":273,"_13":75,"_40":41,"_42":274,"_30":31,"_154":-5,"_199":275,"_33":276},{"_55":262,"_38":263,"_36":264,"_148":170,"_47":48,"_46":265,"_150":71,"_44":266,"_13":75,"_40":41,"_42":267,"_30":31,"_154":-5,"_199":268,"_33":269},{"_55":162,"_38":163,"_36":164,"_148":-5,"_47":48,"_46":165,"_150":71,"_44":259,"_13":75,"_40":53,"_42":-5,"_30":31,"_154":-5,"_199":260,"_33":261},{"_55":255,"_38":52,"_36":51,"_148":164,"_47":48,"_46":14,"_150":71,"_44":256,"_13":75,"_40":53,"_42":-5,"_30":31,"_154":-5,"_199":257,"_33":258},{"_55":251,"_38":39,"_36":37,"_148":51,"_47":48,"_46":14,"_150":31,"_44":252,"_13":75,"_40":41,"_42":43,"_30":31,"_154":-5,"_199":253,"_33":254},{"_55":243,"_38":244,"_36":245,"_148":164,"_47":48,"_46":246,"_150":71,"_44":247,"_13":75,"_40":41,"_42":248,"_30":31,"_154":-5,"_199":249,"_33":250},{"_55":235,"_38":236,"_36":237,"_148":164,"_47":48,"_46":238,"_150":71,"_44":239,"_13":75,"_40":41,"_42":240,"_30":31,"_154":-5,"_199":241,"_33":242},{"_55":228,"_38":229,"_36":230,"_148":164,"_47":48,"_46":165,"_150":71,"_44":231,"_13":75,"_40":27,"_42":232,"_30":31,"_154":-5,"_199":233,"_33":234},{"_55":220,"_38":221,"_36":222,"_148":164,"_47":48,"_46":223,"_150":71,"_44":224,"_13":75,"_40":41,"_42":225,"_30":31,"_154":-5,"_199":226,"_33":227},{"_55":156,"_38":157,"_36":158,"_148":-5,"_47":48,"_46":159,"_150":71,"_44":217,"_13":75,"_40":53,"_42":-5,"_30":31,"_154":-5,"_199":218,"_33":219},{"_55":210,"_38":211,"_36":212,"_148":158,"_47":48,"_46":159,"_150":71,"_44":213,"_13":75,"_40":41,"_42":214,"_30":31,"_154":-5,"_199":215,"_33":216},{"_55":202,"_38":203,"_36":204,"_148":158,"_47":48,"_46":205,"_150":71,"_44":206,"_13":75,"_40":41,"_42":207,"_30":31,"_154":-5,"_199":208,"_33":209},{"_55":146,"_38":147,"_36":69,"_148":-5,"_47":48,"_46":149,"_150":71,"_44":198,"_13":75,"_40":152,"_42":153,"_30":31,"_154":-5,"_199":200,"_33":201},["D",1776247931788],"children",[],[147],"802d20da-38b3-11f1-9f25-42b51c65c3df","categories.ts","802d21a2-38b3-11f1-9f25-42b51c65c3df",4,["D",1776247902586],"export const CATEGORIES = [\n \"General\",\n \"Smileys\",\n \"Animals\",\n \"Food\",\n \"Activities\",\n \"Travel\",\n \"Objects\",\n \"Symbols\",\n \"Flags\",\n \"Memes\",\n \"Gaming\",\n \"Anime\",\n \"Custom\",\n] as const;\n\nexport type Category = typeof CATEGORIES[number];\n",[],[157,203],"7db80be4-38b3-11f1-975d-42b51c65c3df","auth.ts","7db80cac-38b3-11f1-975d-42b51c65c3df",["D",1776247898456],"// Simple password hashing (no external deps) using Web Crypto\nexport async function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + \"emoji-stocks-salt-2024\");\n const hash = await crypto.subtle.digest(\"SHA-256\", data);\n return Array.from(new Uint8Array(hash)).map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nexport async function verifyPassword(password: string, hash: string): Promise {\n const computed = await hashPassword(password);\n return computed === hash;\n}\n\nexport function generateToken(): string {\n const arr = new Uint8Array(32);\n crypto.getRandomValues(arr);\n return Array.from(arr).map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n",[],[157,211],["D",1776247898456],[195,196],[157],"96ed3fee-38b3-11f1-a989-42b51c65c3df","index.tsx","96ed40a2-38b3-11f1-a989-42b51c65c3df",7,["D",1776247940744],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./App.tsx\";\n\nconst root = ReactDOM.createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[163,221],"94cdabae-38b3-11f1-937f-42b51c65c3df","index.html","94cdac80-38b3-11f1-937f-42b51c65c3df",["D",1776247937191],"\n\n\n \n \n Emoji Stocks\n \n \n \n \n \n\n\n

\n \n\n\n",[],[163,229],"9b4ecfd0-38b3-11f1-aa9f-42b51c65c3df","api.ts","9b4ed070-38b3-11f1-aa9f-42b51c65c3df",8,["D",1776247948100],"const BASE = \"\";\n\nasync function req(url: string, opts?: RequestInit) {\n const res = await fetch(BASE + url, { ...opts, credentials: \"include\" });\n const data = await res.json();\n if (!res.ok) throw new Error(data.error || \"Request failed\");\n return data;\n}\n\nexport const api = {\n register: (username: string, password: string) =>\n req(\"/api/register\", { method: \"POST\", headers: { \"Content-Type\": \"application/json\" }, body: JSON.stringify({ username, password }) }),\n login: (username: string, password: string) =>\n req(\"/api/login\", { method: \"POST\", headers: { \"Content-Type\": \"application/json\" }, body: JSON.stringify({ username, password }) }),\n logout: () => req(\"/api/logout\", { method: \"POST\" }),\n me: () => req(\"/api/me\"),\n getEmojis: (category?: string) => req(`/api/emojis${category && category !== \"All\" ? `?category=${encodeURIComponent(category)}` : \"\"}`),\n getEmoji: (id: number) => req(`/api/emojis/${id}`),\n getCategories: () => req(\"/api/categories\"),\n upload: (formData: FormData) => req(\"/api/emojis/upload\", { method: \"POST\", body: formData }),\n getStats: () => req(\"/api/account/stats\"),\n fileUrl: (key: string) => `/api/file/${key}`,\n downloadUrl: (id: number) => `/api/download/${id}`,\n};\n",[],[163,236],"a25341ee-38b3-11f1-b9fb-42b51c65c3df","App.tsx","a253428e-38b3-11f1-b9fb-42b51c65c3df",9,["D",1776247959878],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"./api.ts\";\nimport { Nav } from \"./components/Nav.tsx\";\nimport { HomePage } from \"./components/HomePage.tsx\";\nimport { SubmitPage } from \"./components/SubmitPage.tsx\";\nimport { AccountPage } from \"./components/AccountPage.tsx\";\nimport { AuthModal } from \"./components/AuthModal.tsx\";\n\ntype Page = \"home\" | \"submit\" | \"account\";\ntype User = { id: number; username: string } | null;\n\nexport function App() {\n const [page, setPage] = useState(\"home\");\n const [user, setUser] = useState(null);\n const [showAuth, setShowAuth] = useState(false);\n const [authMode, setAuthMode] = useState<\"login\" | \"register\">(\"login\");\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n api.me().then(d => { setUser(d.user); setLoading(false); }).catch(() => setLoading(false));\n }, []);\n\n const navigate = useCallback((p: Page) => {\n if ((p === \"submit\" || p === \"account\") && !user) {\n setAuthMode(\"login\");\n setShowAuth(true);\n return;\n }\n setPage(p);\n }, [user]);\n\n const onAuth = (u: any) => {\n setUser(u);\n setShowAuth(false);\n };\n\n const onLogout = async () => {\n await api.logout();\n setUser(null);\n setPage(\"home\");\n };\n\n if (loading) {\n return (\n

\n );\n }\n\n return (\n

{ setAuthMode(\"login\"); setShowAuth(true); }}\n onRegister={() => { setAuthMode(\"register\"); setShowAuth(true); }} />\n

\n {page === \"home\" && }\n {page === \"submit\" && user && setPage(\"home\")} />}\n {page === \"account\" && user && }\n

\n \n {showAuth && (\n setAuthMode(m => m === \"login\" ? \"register\" : \"login\")}\n onClose={() => setShowAuth(false)} onAuth={onAuth} />\n )}\n

\n );\n}\n",[],[163,244],"a887cb3e-38b3-11f1-922c-42b51c65c3df",["D",1776247970282],[],[163,52,39],"a887fcd0-38b3-11f1-922c-42b51c65c3df",["D",1776247970282],[189],[163,52],["D",1776247937191],[188,190,191,192,193],[163],"7a6848aa-38b3-11f1-a989-42b51c65c3df","queries.ts","7a684954-38b3-11f1-a989-42b51c65c3df",2,["D",1776247892888],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ── Users ──\nexport async function createUser(username: string, passwordHash: string) {\n return sqlite.execute({\n sql: \"INSERT INTO users (username, password_hash) VALUES (?, ?)\",\n args: [username, passwordHash],\n });\n}\n\nexport async function getUserByUsername(username: string) {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE username = ?\",\n args: [username],\n });\n return r.rows[0] || null;\n}\n\nexport async function getUserById(id: number) {\n const r = await sqlite.execute({\n sql: \"SELECT id, username, created_at FROM users WHERE id = ?\",\n args: [id],\n });\n return r.rows[0] || null;\n}\n\n// ── Sessions ──\nexport async function createSession(token: string, userId: number) {\n return sqlite.execute({\n sql: \"INSERT INTO sessions (token, user_id) VALUES (?, ?)\",\n args: [token, userId],\n });\n}\n\nexport async function getSession(token: string) {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM sessions WHERE token = ?\",\n args: [token],\n });\n return r.rows[0] || null;\n}\n\nexport async function deleteSession(token: string) {\n return sqlite.execute({\n sql: \"DELETE FROM sessions WHERE token = ?\",\n args: [token],\n });\n}\n\n// ── Emojis ──\nexport async function insertEmoji(data: {\n userId: number;\n name: string;\n tags: string;\n category: string;\n description: string;\n fileKey: string;\n fileType: string;\n fileSize: number;\n}) {\n return sqlite.execute({\n sql: `INSERT INTO emojis (user_id, name, tags, category, description, file_key, file_type, file_size)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [data.userId, data.name, data.tags, data.category, data.description, data.fileKey, data.fileType, data.fileSize],\n });\n}\n\nexport async function getAllEmojis(category?: string) {\n if (category && category !== \"All\") {\n const r = await sqlite.execute({\n sql: `SELECT e.*, u.username FROM emojis e JOIN users u ON e.user_id = u.id\n WHERE e.category = ? ORDER BY e.created_at DESC`,\n args: [category],\n });\n return r.rows;\n }\n const r = await sqlite.execute(\n \"SELECT e.*, u.username FROM emojis e JOIN users u ON e.user_id = u.id ORDER BY e.created_at DESC\",\n );\n return r.rows;\n}\n\nexport async function getEmojiById(id: number) {\n const r = await sqlite.execute({\n sql: \"SELECT e.*, u.username FROM emojis e JOIN users u ON e.user_id = u.id WHERE e.id = ?\",\n args: [id],\n });\n return r.rows[0] || null;\n}\n\nexport async function incrementDownload(id: number) {\n return sqlite.execute({\n sql: \"UPDATE emojis SET downloads = downloads + 1 WHERE id = ?\",\n args: [id],\n });\n}\n\nexport async function getUserStats(userId: number) {\n const emojis = await sqlite.execute({\n sql: \"SELECT * FROM emojis WHERE user_id = ? ORDER BY created_at DESC\",\n args: [userId],\n });\n const stats = await sqlite.execute({\n sql: `SELECT COUNT(*) as total_emojis, COALESCE(SUM(downloads),0) as total_downloads,\n COALESCE(AVG(downloads),0) as avg_downloads FROM emojis WHERE user_id = ?`,\n args: [userId],\n });\n // Ranking by total downloads\n const ranking = await sqlite.execute({\n sql: `SELECT user_id, SUM(downloads) as total_dl FROM emojis\n GROUP BY user_id ORDER BY total_dl DESC`,\n });\n let rank = 1;\n for (const row of ranking.rows) {\n if ((row as any).user_id === userId) break;\n rank++;\n }\n return {\n emojis: emojis.rows,\n totalEmojis: (stats.rows[0] as any)?.total_emojis || 0,\n totalDownloads: (stats.rows[0] as any)?.total_downloads || 0,\n avgDownloads: Math.round((stats.rows[0] as any)?.avg_downloads || 0),\n rank,\n totalUsers: ranking.rows.length || 1,\n };\n}\n\nexport async function getCategories() {\n const r = await sqlite.execute(\"SELECT DISTINCT category FROM emojis ORDER BY category\");\n return r.rows.map((row: any) => row.category);\n}\n",[],[169,263],"715069be-38b3-11f1-9d78-42b51c65c3df","migrations.ts","71506a7c-38b3-11f1-9d78-42b51c65c3df",["D",1776247877648],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS sessions (\n token TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (user_id) REFERENCES users(id)\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS emojis (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n tags TEXT DEFAULT '',\n category TEXT DEFAULT 'General',\n description TEXT DEFAULT '',\n file_key TEXT NOT NULL,\n file_type TEXT NOT NULL,\n file_size INTEGER NOT NULL,\n downloads INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (user_id) REFERENCES users(id)\n )`,\n },\n ]);\n}\n",[],[169,271],["D",1776247877648],[185,186],[169],["D",1776247871105],["D",1789497078049],{"_112":111,"_119":115},{"_112":111,"_113":-5,"_114":115,"_19":67,"_116":117,"_118":31},{"_13":101,"_38":102,"_55":48,"_103":56,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":57,"_110":111},"ctx",{"_94":-5,"_139":318,"_319":320,"_321":322,"_323":31,"_324":31,"_325":31,"_326":71,"_327":-5,"_328":-7,"_329":-7,"_330":75,"_331":31,"_332":31,"_333":-5,"_334":31,"_335":31,"_336":31,"_337":-5},"ENV",{"_289":290,"_291":292,"_293":102,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317},"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 · v10