\n \n\n\n",[18,69],"9b4ecfd0-38b3-11f1-aa9f-42b51c65c3df",["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",[18,93],"a25341ee-38b3-11f1-b9fb-42b51c65c3df",["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",[18,102],"a887fcd0-38b3-11f1-922c-42b51c65c3df",["D",1776247970282],[18,111],"pulls","branches",1,"forks","envVars",{"_227":26,"_229":26},"connections",{"_227":26,"_228":26},"count","unfilledCount","emptyCount",{"_37":379,"_13":371,"_67":365,"_47":-5,"_39":40,"_189":221,"_190":24,"_41":380,"_43":26,"_70":112,"_192":-5,"_71":30,"_193":-5,"_257":381,"_17":382},{"_37":372,"_13":373,"_67":374,"_47":365,"_39":40,"_189":221,"_190":24,"_41":375,"_43":26,"_70":84,"_192":376,"_71":30,"_193":-5,"_257":377,"_17":378},{"_37":362,"_13":363,"_67":364,"_47":365,"_39":40,"_189":366,"_190":24,"_41":367,"_43":26,"_70":84,"_192":368,"_71":30,"_193":-5,"_257":369,"_17":370},{"_37":188,"_13":18,"_67":113,"_47":-5,"_39":40,"_189":44,"_190":24,"_41":359,"_43":26,"_70":112,"_192":-5,"_71":30,"_193":-5,"_257":360,"_17":361},{"_37":216,"_13":111,"_67":110,"_47":113,"_39":40,"_189":105,"_190":24,"_41":356,"_43":26,"_70":112,"_192":-5,"_71":30,"_193":-5,"_257":357,"_17":358},{"_37":348,"_13":349,"_67":350,"_47":110,"_39":40,"_189":351,"_190":24,"_41":352,"_43":26,"_70":84,"_192":353,"_71":30,"_193":-5,"_257":354,"_17":355},{"_37":340,"_13":341,"_67":342,"_47":110,"_39":40,"_189":343,"_190":24,"_41":344,"_43":26,"_70":84,"_192":345,"_71":30,"_193":-5,"_257":346,"_17":347},{"_37":332,"_13":333,"_67":334,"_47":110,"_39":40,"_189":335,"_190":24,"_41":336,"_43":26,"_70":84,"_192":337,"_71":30,"_193":-5,"_257":338,"_17":339},{"_37":324,"_13":325,"_67":326,"_47":110,"_39":40,"_189":327,"_190":24,"_41":328,"_43":26,"_70":84,"_192":329,"_71":30,"_193":-5,"_257":330,"_17":331},{"_37":316,"_13":317,"_67":318,"_47":110,"_39":40,"_189":319,"_190":24,"_41":320,"_43":221,"_70":84,"_192":321,"_71":30,"_193":-5,"_257":322,"_17":323},{"_37":308,"_13":309,"_67":310,"_47":110,"_39":40,"_189":311,"_190":24,"_41":312,"_43":26,"_70":84,"_192":313,"_71":30,"_193":-5,"_257":314,"_17":315},{"_37":212,"_13":102,"_67":101,"_47":113,"_39":40,"_189":96,"_190":24,"_41":305,"_43":26,"_70":84,"_192":214,"_71":30,"_193":-5,"_257":306,"_17":307},{"_37":208,"_13":93,"_67":92,"_47":113,"_39":40,"_189":87,"_190":24,"_41":302,"_43":26,"_70":84,"_192":210,"_71":30,"_193":-5,"_257":303,"_17":304},{"_37":204,"_13":69,"_67":68,"_47":113,"_39":40,"_189":44,"_190":24,"_41":299,"_43":26,"_70":21,"_192":206,"_71":30,"_193":-5,"_257":300,"_17":301},{"_37":200,"_13":83,"_67":82,"_47":113,"_39":40,"_189":77,"_190":24,"_41":296,"_43":26,"_70":84,"_192":202,"_71":30,"_193":-5,"_257":297,"_17":298},{"_37":292,"_13":283,"_67":277,"_47":-5,"_39":40,"_189":287,"_190":24,"_41":293,"_43":26,"_70":112,"_192":-5,"_71":30,"_193":-5,"_257":294,"_17":295},{"_37":284,"_13":285,"_67":286,"_47":277,"_39":40,"_189":287,"_190":24,"_41":288,"_43":26,"_70":84,"_192":289,"_71":30,"_193":-5,"_257":290,"_17":291},{"_37":274,"_13":275,"_67":276,"_47":277,"_39":40,"_189":278,"_190":24,"_41":279,"_43":26,"_70":84,"_192":280,"_71":30,"_193":-5,"_257":281,"_17":282},{"_37":268,"_13":269,"_67":270,"_47":-5,"_39":40,"_189":153,"_190":24,"_41":271,"_43":26,"_70":112,"_192":-5,"_71":30,"_193":-5,"_257":272,"_17":273},{"_37":260,"_13":261,"_67":262,"_47":-5,"_39":40,"_189":263,"_190":24,"_41":264,"_43":26,"_70":21,"_192":265,"_71":30,"_193":-5,"_257":266,"_17":267},{"_37":251,"_13":252,"_67":126,"_47":-5,"_39":40,"_189":253,"_190":24,"_41":254,"_43":26,"_70":255,"_192":256,"_71":30,"_193":-5,"_257":258,"_17":259},"91953aec-38b3-11f1-937f-42b51c65c3df","main.tsx",5,["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","children",[],[252],"f0969126-38b3-11f1-92ed-42b51c65c3df","README.md","f09691e4-38b3-11f1-92ed-42b51c65c3df",17,["D",1776248091182],"# 📈 Emoji Stocks\n\nA clean, community-driven platform to upload, browse, and download Discord emojis.\n\n## Features\n\n- **🏠 Home** — Browse all emojis in a responsive grid, filter by category, click to view & download\n- **📤 Submit** — Upload PNG/GIF emojis under 500KB with name, tags, category, and description\n- **👤 Account** — Personal dashboard with upload stats, download counts, and community ranking\n- **🔐 Auth** — Simple username/password registration and login\n\n## Architecture\n\n```mermaid\ngraph TB\n Browser[React SPA] -->|API calls| Hono[Hono Backend]\n Hono --> SQLite[Val Town SQLite]\n Hono --> Blob[Val Town Blob Storage]\n SQLite -->|users, sessions, emoji metadata| DB[(Database)]\n Blob -->|PNG/GIF files| Files[(File Storage)]\n```\n\n## Tech Stack\n\n- **Frontend**: React 18 + Twind (Tailwind utility classes)\n- **Backend**: Hono on Val Town\n- **Database**: Val Town SQLite (users, sessions, emoji metadata)\n- **Storage**: Val Town Blob (emoji image files)\n- **Auth**: SHA-256 password hashing with session tokens\n",[],[261],"b58eac58-38bd-11f1-b7d2-42b51c65c3df","untitled-folder-5522","b58eacee-38bd-11f1-b7d2-42b51c65c3df",["D",1776252287112],[],[269],"802d20da-38b3-11f1-9f25-42b51c65c3df","categories.ts","802d21a2-38b3-11f1-9f25-42b51c65c3df","5e5cf5ad-b714-48ee-b97b-496afea816b0",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",[],[283,275],"shared","7db80be4-38b3-11f1-975d-42b51c65c3df","auth.ts","7db80cac-38b3-11f1-975d-42b51c65c3df",3,["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",[],[283,285],"7db833b2-38b3-11f1-975d-42b51c65c3df",["D",1776247898456],[246,247],[283],["D",1776247940744],[],[18,83],["D",1776247937191],[],[18,69],["D",1776247948100],[],[18,93],["D",1776247959878],[],[18,102],"ced11336-38b3-11f1-82dd-42b51c65c3df","SubmitPage.tsx","ced113e0-38b3-11f1-82dd-42b51c65c3df",14,["D",1776248034522],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef } from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"../api.ts\";\n\nconst CATEGORIES = [\n \"General\",\"Smileys\",\"Animals\",\"Food\",\"Activities\",\"Travel\",\"Objects\",\"Symbols\",\"Flags\",\"Memes\",\"Gaming\",\"Anime\",\"Custom\"\n];\n\ninterface SubmitPageProps {\n user: { id: number; username: string };\n onSuccess: () => void;\n}\n\nexport function SubmitPage({ user, onSuccess }: SubmitPageProps) {\n const [file, setFile] = useState(null);\n const [preview, setPreview] = useState(null);\n const [name, setName] = useState(\"\");\n const [tags, setTags] = useState(\"\");\n const [category, setCategory] = useState(\"General\");\n const [description, setDescription] = useState(\"\");\n const [error, setError] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [success, setSuccess] = useState(false);\n const inputRef = useRef(null);\n\n const handleFileChange = (e: React.ChangeEvent) => {\n const f = e.target.files?.[0];\n if (!f) return;\n if (![\"image/png\", \"image/gif\"].includes(f.type)) {\n setError(\"Only PNG or GIF files are allowed\");\n return;\n }\n if (f.size > 512000) {\n setError(\"File must be under 500KB\");\n return;\n }\n setError(\"\");\n setFile(f);\n const reader = new FileReader();\n reader.onload = (ev) => setPreview(ev.target?.result as string);\n reader.readAsDataURL(f);\n if (!name) setName(f.name.replace(/\\.(png|gif)$/i, \"\"));\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!file) { setError(\"Please select a file\"); return; }\n if (!name.trim()) { setError(\"Name is required\"); return; }\n setError(\"\");\n setLoading(true);\n try {\n const fd = new FormData();\n fd.append(\"file\", file);\n fd.append(\"name\", name.trim());\n fd.append(\"tags\", tags.trim());\n fd.append(\"category\", category);\n fd.append(\"description\", description.trim());\n await api.upload(fd);\n setSuccess(true);\n setTimeout(() => onSuccess(), 1500);\n } catch (err: any) {\n setError(err.message);\n } finally {\n setLoading(false);\n }\n };\n\n if (success) {\n return (\n

🎉

Emoji uploaded!

Redirecting to home...

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

📤 Submit Emoji

Upload a PNG or GIF under 500KB

\n\n

\n {/* File Upload */}\n

inputRef.current?.click()}>\n \n {preview ? (\n

\n $\"Preview\"$ \n {file?.name} ({(file!.size / 1024).toFixed(1)} KB)\n Click to change\n

\n ) : (\n

📁

Click to select a PNG or GIF file

Max 500KB

\n )}\n

\n\n {/* Name */}\n

\n Name *\n setName(e.target.value)} maxLength={32}\n className=\"w-full px-4 py-2.5 border border-gray-200 rounded-xl focus:ring-2 focus:ring-indigo-500 focus:border-transparent outline-none transition-all text-sm\"\n placeholder=\"e.g. happy_pepe\" required />\n

\n\n {/* Tags */}\n

\n Tags\n setTags(e.target.value)}\n className=\"w-full px-4 py-2.5 border border-gray-200 rounded-xl focus:ring-2 focus:ring-indigo-500 focus:border-transparent outline-none transition-all text-sm\"\n placeholder=\"happy, pepe, meme (comma separated)\" />\n

\n\n {/* Category */}\n

\n Category\n \n

\n\n {/* Description */}\n

\n Description\n

setDescription(e.target.value)} rows={3}\n            className=\"w-full px-4 py-2.5 border border-gray-200 rounded-xl focus:ring-2 focus:ring-indigo-500 focus:border-transparent outline-none transition-all text-sm resize-none\"\n            placeholder=\"A short description of this emoji...\" />\n        </div>\n\n        {error && <div className=\"text-red-500 text-sm bg-red-50 px-3 py-2 rounded-lg\">{error}</div>}\n\n        <button type=\"submit\" disabled={loading}\n          className=\"w-full py-3 bg-indigo-500 text-white rounded-xl font-semibold hover:bg-indigo-600 transition-all disabled:opacity-50 text-sm shadow-sm\">\n          {loading ? \"Uploading...\" : \"🚀 Submit Emoji\"}\n        </button>\n      </form>\n    </div>\n  );\n}\n",[],[18,111,309],"eacabc90-38b3-11f1-922c-42b51c65c3df","Nav.tsx","a887cc56-38b3-11f1-922c-42b51c65c3df",16,["D",1776248081443],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } 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 [menuOpen, setMenuOpen] = useState(false);\n\n  const link = (p: string, label: string, mobile = false) => (\n    <button onClick={() => { onNavigate(p); setMenuOpen(false); }}\n      className={`px-4 py-2 rounded-lg text-sm font-semibold transition-all ${\n        mobile ? \"w-full text-left\" : \"\"\n      } ${\n        page === p ? \"bg-indigo-500 text-white shadow-md\" : \"text-gray-600 hover:bg-gray-100\"\n      }`}>\n      {label}\n    </button>\n  );\n\n  return (\n    <nav className=\"bg-white border-b border-gray-200 sticky top-0 z-50\">\n      <div className=\"max-w-5xl mx-auto px-4 h-14 flex items-center justify-between\">\n        {/* Logo */}\n        <button onClick={() => { onNavigate(\"home\"); setMenuOpen(false); }} className=\"flex items-center gap-2 group shrink-0\">\n          <span className=\"text-xl\">📈</span>\n          <span className=\"text-lg font-extrabold text-gray-900 group-hover:text-indigo-600 transition-colors hidden sm:inline\">\n            Emoji Stocks\n          </span>\n        </button>\n\n        {/* Desktop Nav */}\n        <div className=\"hidden md:flex items-center gap-1\">\n          {link(\"home\", \"🏠 Home\")}\n          {link(\"submit\", \"📤 Submit\")}\n          {link(\"account\", \"👤 Account\")}\n        </div>\n\n        {/* Desktop Auth */}\n        <div className=\"hidden md:flex items-center gap-2\">\n          {user ? (\n            <div className=\"flex items-center gap-3\">\n              <span className=\"text-sm font-medium text-gray-700\">@{user.username}</span>\n              <button onClick={onLogout}\n                className=\"text-xs px-3 py-1.5 rounded-lg bg-gray-100 text-gray-600 hover:bg-red-50 hover:text-red-600 transition-all font-medium\">\n                Logout\n              </button>\n            </div>\n          ) : (\n            <>\n              <button onClick={onLogin}\n                className=\"text-sm px-4 py-2 rounded-lg bg-gray-100 text-gray-700 hover:bg-gray-200 transition-all font-medium\">\n                Log in\n              </button>\n              <button onClick={onRegister}\n                className=\"text-sm px-4 py-2 rounded-lg bg-indigo-500 text-white hover:bg-indigo-600 transition-all font-medium shadow-sm\">\n                Sign up\n              </button>\n            </>\n          )}\n        </div>\n\n        {/* Mobile Menu Button */}\n        <button onClick={() => setMenuOpen(!menuOpen)} className=\"md:hidden p-2 text-gray-600 hover:bg-gray-100 rounded-lg\">\n          <svg width=\"24\" height=\"24\" fill=\"none\" stroke=\"currentColor\" strokeWidth=\"2\" strokeLinecap=\"round\">\n            {menuOpen\n              ? <><line x1=\"18\" y1=\"6\" x2=\"6\" y2=\"18\"/><line x1=\"6\" y1=\"6\" x2=\"18\" y2=\"18\"/></>\n              : <><line x1=\"3\" y1=\"6\" x2=\"21\" y2=\"6\"/><line x1=\"3\" y1=\"12\" x2=\"21\" y2=\"12\"/><line x1=\"3\" y1=\"18\" x2=\"21\" y2=\"18\"/></>}\n          </svg>\n        </button>\n      </div>\n\n      {/* Mobile Menu */}\n      {menuOpen && (\n        <div className=\"md:hidden border-t border-gray-100 bg-white px-4 py-3 space-y-1\">\n          {link(\"home\", \"🏠 Home\", true)}\n          {link(\"submit\", \"📤 Submit\", true)}\n          {link(\"account\", \"👤 Account\", true)}\n          <div className=\"border-t border-gray-100 pt-2 mt-2\">\n            {user ? (\n              <div className=\"flex items-center justify-between\">\n                <span className=\"text-sm font-medium text-gray-700\">@{user.username}</span>\n                <button onClick={() => { onLogout(); setMenuOpen(false); }}\n                  className=\"text-xs px-3 py-1.5 rounded-lg bg-gray-100 text-gray-600 font-medium\">\n                  Logout\n                </button>\n              </div>\n            ) : (\n              <div className=\"flex gap-2\">\n                <button onClick={() => { onLogin(); setMenuOpen(false); }}\n                  className=\"flex-1 text-sm py-2 rounded-lg bg-gray-100 text-gray-700 font-medium\">\n                  Log in\n                </button>\n                <button onClick={() => { onRegister(); setMenuOpen(false); }}\n                  className=\"flex-1 text-sm py-2 rounded-lg bg-indigo-500 text-white font-medium\">\n                  Sign up\n                </button>\n              </div>\n            )}\n          </div>\n        </div>\n      )}\n    </nav>\n  );\n}\n",[],[18,111,317],"b96a0020-38b3-11f1-809f-42b51c65c3df","HomePage.tsx","b96a0192-38b3-11f1-809f-42b51c65c3df",12,["D",1776247998611],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"../api.ts\";\nimport { EmojiModal } from \"./EmojiModal.tsx\";\n\nexport function HomePage() {\n  const [emojis, setEmojis] = useState<any[]>([]);\n  const [categories, setCategories] = useState<string[]>([]);\n  const [activeCategory, setActiveCategory] = useState(\"All\");\n  const [selectedEmoji, setSelectedEmoji] = useState<any>(null);\n  const [loading, setLoading] = useState(true);\n\n  const loadEmojis = async (cat?: string) => {\n    setLoading(true);\n    try {\n      const data = await api.getEmojis(cat);\n      setEmojis(data.emojis || []);\n    } catch { setEmojis([]); }\n    setLoading(false);\n  };\n\n  useEffect(() => {\n    api.getCategories().then(d => setCategories(d.categories || [])).catch(() => {});\n    loadEmojis();\n  }, []);\n\n  const handleCategoryChange = (cat: string) => {\n    setActiveCategory(cat);\n    loadEmojis(cat);\n  };\n\n  return (\n    <div>\n      {/* Hero */}\n      <div className=\"text-center mb-8\">\n        <h1 className=\"text-3xl font-extrabold text-gray-900 mb-2\">\n          📈 Discover & Share Emojis\n        </h1>\n        <p className=\"text-gray-500\">Browse community-uploaded emojis for Discord and more</p>\n      </div>\n\n      {/* Category Filters */}\n      <div className=\"flex flex-wrap gap-2 mb-6 justify-center\">\n        {categories.map(cat => (\n          <button key={cat} onClick={() => handleCategoryChange(cat)}\n            className={`px-4 py-1.5 rounded-full text-sm font-medium transition-all ${\n              activeCategory === cat\n                ? \"bg-indigo-500 text-white shadow-md\"\n                : \"bg-white text-gray-600 border border-gray-200 hover:border-indigo-300 hover:text-indigo-600\"\n            }`}>\n            {cat}\n          </button>\n        ))}\n      </div>\n\n      {/* Grid */}\n      {loading ? (\n        <div className=\"text-center py-20 text-gray-400\">Loading emojis...</div>\n      ) : emojis.length === 0 ? (\n        <div className=\"text-center py-20\">\n          <div className=\"text-5xl mb-4\">📭</div>\n          <p className=\"text-gray-500 text-lg\">No emojis yet. Be the first to upload!</p>\n        </div>\n      ) : (\n        <div className=\"grid grid-cols-2 sm:grid-cols-3 md:grid-cols-4 gap-4\">\n          {emojis.map((emoji: any) => (\n            <div key={emoji.id} onClick={() => setSelectedEmoji(emoji)}\n              className=\"bg-white rounded-2xl border border-gray-100 hover:border-indigo-200 hover:shadow-lg transition-all cursor-pointer group overflow-hidden\">\n              <div className=\"aspect-square flex items-center justify-center p-4 bg-gray-50/50\">\n                <img src={api.fileUrl(emoji.file_key)} alt={emoji.name}\n                  className=\"w-[128px] h-[128px] object-contain group-hover:scale-110 transition-transform\" loading=\"lazy\" />\n              </div>\n              <div className=\"p-3 border-t border-gray-50\">\n                <h3 className=\"font-semibold text-gray-900 text-sm truncate\">{emoji.name}</h3>\n                <div className=\"flex items-center justify-between mt-1\">\n                  <span className=\"text-xs text-gray-400\">@{emoji.username}</span>\n                  <span className=\"text-xs text-gray-400 flex items-center gap-1\">\n                    ⬇ {emoji.downloads}\n                  </span>\n                </div>\n              </div>\n            </div>\n          ))}\n        </div>\n      )}\n\n      {selectedEmoji && (\n        <EmojiModal emoji={selectedEmoji} onClose={() => setSelectedEmoji(null)} />\n      )}\n    </div>\n  );\n}\n",[],[18,111,325],"c0ad4e6e-38b3-11f1-95fc-42b51c65c3df","EmojiModal.tsx","c0ad4f2c-38b3-11f1-95fc-42b51c65c3df",13,["D",1776248010794],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"../api.ts\";\n\ninterface EmojiModalProps {\n  emoji: any;\n  onClose: () => void;\n}\n\nexport function EmojiModal({ emoji, onClose }: EmojiModalProps) {\n  const handleDownload = () => {\n    const a = document.createElement(\"a\");\n    a.href = api.downloadUrl(emoji.id);\n    a.download = emoji.name;\n    document.body.appendChild(a);\n    a.click();\n    document.body.removeChild(a);\n  };\n\n  return (\n    <div className=\"fixed inset-0 bg-black/40 backdrop-blur-sm z-50 flex items-center justify-center p-4\"\n      onClick={onClose}>\n      <div className=\"bg-white rounded-2xl shadow-2xl w-full max-w-md overflow-hidden\" onClick={e => e.stopPropagation()}>\n        <div className=\"bg-gray-50 flex items-center justify-center p-8\">\n          <img src={api.fileUrl(emoji.file_key)} alt={emoji.name}\n            className=\"w-[128px] h-[128px] object-contain\" />\n        </div>\n        <div className=\"p-6\">\n          <h2 className=\"text-xl font-bold text-gray-900 mb-1\">{emoji.name}</h2>\n          <p className=\"text-sm text-gray-500 mb-4\">by @{emoji.username}</p>\n          {emoji.description && (\n            <p className=\"text-sm text-gray-600 mb-4\">{emoji.description}</p>\n          )}\n          <div className=\"flex flex-wrap gap-2 mb-4\">\n            <span className=\"px-2.5 py-1 bg-indigo-50 text-indigo-600 rounded-full text-xs font-medium\">\n              {emoji.category}\n            </span>\n            {emoji.tags && emoji.tags.split(\",\").map((t: string) => t.trim()).filter(Boolean).map((tag: string) => (\n              <span key={tag} className=\"px-2.5 py-1 bg-gray-100 text-gray-600 rounded-full text-xs font-medium\">\n                #{tag}\n              </span>\n            ))}\n          </div>\n          <div className=\"flex items-center gap-3 text-sm text-gray-500 mb-5\">\n            <span>⬇ {emoji.downloads} downloads</span>\n            <span>·</span>\n            <span>{(emoji.file_size / 1024).toFixed(1)} KB</span>\n            <span>·</span>\n            <span>{emoji.file_type === \"image/gif\" ? \"GIF\" : \"PNG\"}</span>\n          </div>\n          <div className=\"flex gap-3\">\n            <button onClick={handleDownload}\n              className=\"flex-1 py-2.5 bg-indigo-500 text-white rounded-xl font-semibold hover:bg-indigo-600 transition-all text-sm shadow-sm\">\n              ⬇ Download (128px)\n            </button>\n            <button onClick={onClose}\n              className=\"px-5 py-2.5 bg-gray-100 text-gray-600 rounded-xl font-medium hover:bg-gray-200 transition-all text-sm\">\n              Close\n            </button>\n          </div>\n        </div>\n      </div>\n    </div>\n  );\n}\n",[],[18,111,333],"afe36758-38b3-11f1-809f-42b51c65c3df","AuthModal.tsx","afe3682a-38b3-11f1-809f-42b51c65c3df",11,["D",1776247982632],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"../api.ts\";\n\ninterface AuthModalProps {\n  mode: \"login\" | \"register\";\n  onSwitch: () => void;\n  onClose: () => void;\n  onAuth: (user: any) => void;\n}\n\nexport function AuthModal({ mode, onSwitch, onClose, onAuth }: AuthModalProps) {\n  const [username, setUsername] = useState(\"\");\n  const [password, setPassword] = useState(\"\");\n  const [error, setError] = useState(\"\");\n  const [loading, setLoading] = useState(false);\n\n  const handleSubmit = async (e: React.FormEvent) => {\n    e.preventDefault();\n    setError(\"\");\n    setLoading(true);\n    try {\n      const fn = mode === \"login\" ? api.login : api.register;\n      const data = await fn(username, password);\n      onAuth(data.user);\n    } catch (err: any) {\n      setError(err.message);\n    } finally {\n      setLoading(false);\n    }\n  };\n\n  return (\n    <div className=\"fixed inset-0 bg-black/40 backdrop-blur-sm z-50 flex items-center justify-center p-4\"\n      onClick={onClose}>\n      <div className=\"bg-white rounded-2xl shadow-2xl w-full max-w-sm p-8\" onClick={e => e.stopPropagation()}>\n        <div className=\"text-center mb-6\">\n          <div className=\"text-3xl mb-2\">{mode === \"login\" ? \"👋\" : \"🚀\"}</div>\n          <h2 className=\"text-2xl font-bold text-gray-900\">\n            {mode === \"login\" ? \"Welcome back\" : \"Create account\"}\n          </h2>\n          <p className=\"text-gray-500 text-sm mt-1\">\n            {mode === \"login\" ? \"Sign in to your account\" : \"Join the emoji community\"}\n          </p>\n        </div>\n        <form onSubmit={handleSubmit} className=\"space-y-4\">\n          <div>\n            <label className=\"block text-sm font-medium text-gray-700 mb-1\">Username</label>\n            <input type=\"text\" value={username} onChange={e => setUsername(e.target.value)}\n              className=\"w-full px-4 py-2.5 border border-gray-200 rounded-xl focus:ring-2 focus:ring-indigo-500 focus:border-transparent outline-none transition-all text-sm\"\n              placeholder=\"Enter username\" autoFocus required />\n          </div>\n          <div>\n            <label className=\"block text-sm font-medium text-gray-700 mb-1\">Password</label>\n            <input type=\"password\" value={password} onChange={e => setPassword(e.target.value)}\n              className=\"w-full px-4 py-2.5 border border-gray-200 rounded-xl focus:ring-2 focus:ring-indigo-500 focus:border-transparent outline-none transition-all text-sm\"\n              placeholder=\"Enter password\" required />\n          </div>\n          {error && <div className=\"text-red-500 text-sm bg-red-50 px-3 py-2 rounded-lg\">{error}</div>}\n          <button type=\"submit\" disabled={loading}\n            className=\"w-full py-2.5 bg-indigo-500 text-white rounded-xl font-semibold hover:bg-indigo-600 transition-all disabled:opacity-50 text-sm shadow-sm\">\n            {loading ? \"...\" : mode === \"login\" ? \"Sign in\" : \"Create account\"}\n          </button>\n        </form>\n        <p className=\"text-center text-sm text-gray-500 mt-5\">\n          {mode === \"login\" ? \"Don't have an account?\" : \"Already have an account?\"}{\" \"}\n          <button onClick={onSwitch} className=\"text-indigo-500 font-semibold hover:underline\">\n            {mode === \"login\" ? \"Sign up\" : \"Sign in\"}\n          </button>\n        </p>\n      </div>\n    </div>\n  );\n}\n",[],[18,111,341],"d7ab0494-38b3-11f1-92ed-42b51c65c3df","AccountPage.tsx","d7ab0584-38b3-11f1-92ed-42b51c65c3df",15,["D",1776248049372],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"../api.ts\";\n\ninterface AccountPageProps {\n  user: { id: number; username: string };\n}\n\nexport function AccountPage({ user }: AccountPageProps) {\n  const [stats, setStats] = useState<any>(null);\n  const [loading, setLoading] = useState(true);\n\n  useEffect(() => {\n    api.getStats().then(d => { setStats(d); setLoading(false); }).catch(() => setLoading(false));\n  }, []);\n\n  if (loading) {\n    return <div className=\"text-center py-20 text-gray-400\">Loading dashboard...</div>;\n  }\n\n  if (!stats) {\n    return <div className=\"text-center py-20 text-gray-500\">Could not load stats</div>;\n  }\n\n  return (\n    <div>\n      <div className=\"text-center mb-8\">\n        <div className=\"w-20 h-20 bg-indigo-100 rounded-full flex items-center justify-center mx-auto mb-3\">\n          <span className=\"text-3xl\">👤</span>\n        </div>\n        <h1 className=\"text-2xl font-extrabold text-gray-900\">@{user.username}</h1>\n        <p className=\"text-gray-500 text-sm\">Your emoji dashboard</p>\n      </div>\n\n      {/* Stats Cards */}\n      <div className=\"grid grid-cols-2 md:grid-cols-4 gap-4 mb-8\">\n        <StatCard icon=\"📦\" label=\"Total Emojis\" value={stats.totalEmojis} />\n        <StatCard icon=\"⬇\" label=\"Total Downloads\" value={stats.totalDownloads} />\n        <StatCard icon=\"📊\" label=\"Avg Downloads\" value={stats.avgDownloads} />\n        <StatCard icon=\"🏆\" label=\"Ranking\" value={`#${stats.rank} / ${stats.totalUsers}`} />\n      </div>\n\n      {/* User's Emojis */}\n      <h2 className=\"text-lg font-bold text-gray-900 mb-4\">Your Emojis</h2>\n      {stats.emojis.length === 0 ? (\n        <div className=\"text-center py-12 bg-white rounded-2xl border border-gray-100\">\n          <div className=\"text-4xl mb-3\">📭</div>\n          <p className=\"text-gray-500\">You haven't uploaded any emojis yet</p>\n        </div>\n      ) : (\n        <div className=\"grid grid-cols-2 sm:grid-cols-3 md:grid-cols-4 gap-4\">\n          {stats.emojis.map((emoji: any) => (\n            <div key={emoji.id} className=\"bg-white rounded-2xl border border-gray-100 overflow-hidden\">\n              <div className=\"aspect-square flex items-center justify-center p-3 bg-gray-50/50\">\n                <img src={api.fileUrl(emoji.file_key)} alt={emoji.name}\n                  className=\"w-[96px] h-[96px] object-contain\" loading=\"lazy\" />\n              </div>\n              <div className=\"p-3 border-t border-gray-50\">\n                <h3 className=\"font-semibold text-gray-900 text-xs truncate\">{emoji.name}</h3>\n                <div className=\"flex items-center justify-between mt-1\">\n                  <span className=\"text-xs text-indigo-500 font-medium\">{emoji.category}</span>\n                  <span className=\"text-xs text-gray-400\">⬇ {emoji.downloads}</span>\n                </div>\n              </div>\n            </div>\n          ))}\n        </div>\n      )}\n    </div>\n  );\n}\n\nfunction StatCard({ icon, label, value }: { icon: string; label: string; value: any }) {\n  return (\n    <div className=\"bg-white rounded-2xl border border-gray-100 p-5 text-center\">\n      <div className=\"text-2xl mb-2\">{icon}</div>\n      <div className=\"text-2xl font-bold text-gray-900\">{value}</div>\n      <div className=\"text-xs text-gray-500 mt-1\">{label}</div>\n    </div>\n  );\n}\n",[],[18,111,349],["D",1776247970282],[235,236,237,238,239,240],[18,111],["D",1776247937191],[234,241,242,243,244],[18],"7a6848aa-38b3-11f1-a989-42b51c65c3df","queries.ts","7a684954-38b3-11f1-a989-42b51c65c3df","fdd95334-22a7-477d-b4a0-b09dd6343548",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",[],[371,363],"database","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",[],[371,373],"715096aa-38b3-11f1-9d78-42b51c65c3df",["D",1776247877648],[231,232],[371],["D",1776247871105],["D",1789497078049],{"_11":12,"_166":74},{"_11":12,"_162":-5,"_73":74,"_31":72,"_163":164,"_165":30},{"_43":153,"_13":16,"_37":40,"_154":115,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":14,"_161":12},"ctx",{"_57":-5,"_185":421,"_422":423,"_424":425,"_426":30,"_427":30,"_428":30,"_429":24,"_430":-5,"_431":-7,"_432":-7,"_433":26,"_434":30,"_435":30,"_436":-5,"_437":30,"_438":30,"_439":30,"_440":-5},"ENV",{"_392":393,"_394":395,"_396":16,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412,"_413":414,"_415":416,"_417":418,"_419":420},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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"]
</article></body></html>

History · frontend