Emoji Stocks

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_265":266,"_267":268},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_113":95,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":64,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",9,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","dee87010-fc5b-442b-943f-4fc5041adbdb","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","frontend/App.tsx","latestPath","fileId","a253428e-38b3-11f1-b9fb-42b51c65c3df","name","App.tsx","fileType","script","content","/** @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","createdAt",["D",1776247959878],"branchVersion","branchId","6d6990c8-38b3-11f1-975d-42b51c65c3df","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",{"_105":104,"_112":108},"org",{"_105":104,"_106":-5,"_107":108,"_19":60,"_109":110,"_111":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"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",{"_48":49,"_37":50,"_43":260,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":261,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":262,"_89":263,"_91":264,"_93":30},"tree",[178,181,186,189],"files",[178,179,180,181,182,183,184,185,186,187,188,189],"counts",{"_168":68,"_169":165,"_170":68,"_171":172,"_173":174},"contents",[135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":162,"_37":163,"_35":164,"_141":-5,"_46":47,"_45":165,"_143":64,"_43":166,"_13":68,"_39":154,"_41":-5,"_29":30,"_147":-5,"_32":167},{"_48":156,"_37":157,"_35":158,"_141":-5,"_46":47,"_45":159,"_143":64,"_43":160,"_13":68,"_39":154,"_41":-5,"_29":30,"_147":-5,"_32":161},{"_48":149,"_37":150,"_35":151,"_141":-5,"_46":47,"_45":152,"_143":64,"_43":153,"_13":68,"_39":154,"_41":-5,"_29":30,"_147":-5,"_32":155},{"_48":139,"_37":140,"_35":62,"_141":-5,"_46":47,"_45":142,"_143":64,"_43":144,"_13":68,"_39":145,"_41":146,"_29":30,"_147":-5,"_32":148},"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",[140],"7db833b2-38b3-11f1-975d-42b51c65c3df","shared","5e5cf5ad-b714-48ee-b97b-496afea816b0",3,["D",1776247898456],"directory",[150],"94cdbcd4-38b3-11f1-937f-42b51c65c3df","frontend","2f94ac99-211b-4d47-b744-7193d0b74f68",6,["D",1776247937191],[157],"715096aa-38b3-11f1-9d78-42b51c65c3df","database","fdd95334-22a7-477d-b4a0-b09dd6343548",1,["D",1776247877648],[163],"pulls","branches","forks","envVars",{"_175":68,"_177":68},"connections",{"_175":68,"_176":68},"count","unfilledCount","emptyCount",{"_48":162,"_37":163,"_35":164,"_141":-5,"_46":47,"_45":165,"_143":64,"_43":257,"_13":68,"_39":154,"_41":-5,"_29":30,"_147":-5,"_191":258,"_32":259},{"_48":250,"_37":251,"_35":252,"_141":164,"_46":47,"_45":165,"_143":64,"_43":253,"_13":68,"_39":40,"_41":254,"_29":30,"_147":-5,"_191":255,"_32":256},{"_48":242,"_37":243,"_35":244,"_141":164,"_46":47,"_45":245,"_143":64,"_43":246,"_13":68,"_39":40,"_41":247,"_29":30,"_147":-5,"_191":248,"_32":249},{"_48":156,"_37":157,"_35":158,"_141":-5,"_46":47,"_45":159,"_143":64,"_43":239,"_13":68,"_39":154,"_41":-5,"_29":30,"_147":-5,"_191":240,"_32":241},{"_48":235,"_37":38,"_35":36,"_141":158,"_46":47,"_45":14,"_143":64,"_43":236,"_13":68,"_39":40,"_41":42,"_29":30,"_147":-5,"_191":237,"_32":238},{"_48":227,"_37":228,"_35":229,"_141":158,"_46":47,"_45":230,"_143":64,"_43":231,"_13":68,"_39":40,"_41":232,"_29":30,"_147":-5,"_191":233,"_32":234},{"_48":220,"_37":221,"_35":222,"_141":158,"_46":47,"_45":159,"_143":64,"_43":223,"_13":68,"_39":26,"_41":224,"_29":30,"_147":-5,"_191":225,"_32":226},{"_48":212,"_37":213,"_35":214,"_141":158,"_46":47,"_45":215,"_143":64,"_43":216,"_13":68,"_39":40,"_41":217,"_29":30,"_147":-5,"_191":218,"_32":219},{"_48":149,"_37":150,"_35":151,"_141":-5,"_46":47,"_45":152,"_143":64,"_43":209,"_13":68,"_39":154,"_41":-5,"_29":30,"_147":-5,"_191":210,"_32":211},{"_48":202,"_37":203,"_35":204,"_141":151,"_46":47,"_45":152,"_143":64,"_43":205,"_13":68,"_39":40,"_41":206,"_29":30,"_147":-5,"_191":207,"_32":208},{"_48":194,"_37":195,"_35":196,"_141":151,"_46":47,"_45":197,"_143":64,"_43":198,"_13":68,"_39":40,"_41":199,"_29":30,"_147":-5,"_191":200,"_32":201},{"_48":139,"_37":140,"_35":62,"_141":-5,"_46":47,"_45":142,"_143":64,"_43":190,"_13":68,"_39":145,"_41":146,"_29":30,"_147":-5,"_191":192,"_32":193},["D",1776247931788],"children",[],[140],"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",[],[150,195],"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",[],[150,203],["D",1776247898456],[187,188],[150],"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",[],[157,213],"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",[],[157,221],"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",[],[157,228],"a25341ee-38b3-11f1-b9fb-42b51c65c3df",["D",1776247959878],[],[157,38],["D",1776247937191],[182,183,184,185],[157],"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",[],[163,243],"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",[],[163,251],["D",1776247877648],[179,180],[163],["D",1776247871105],["D",1789497078049],{"_105":104,"_112":108},{"_105":104,"_106":-5,"_107":108,"_19":60,"_109":110,"_111":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_132":298,"_299":300,"_301":302,"_303":30,"_304":30,"_305":30,"_306":64,"_307":-5,"_308":-7,"_309":-7,"_310":68,"_311":30,"_312":30,"_313":-5,"_314":30,"_315":30,"_316":30,"_317":-5},"ENV",{"_269":270,"_271":272,"_273":95,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297},"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 · v9