[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":57,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","156f2738-2776-11f0-b46e-569c3dd06744","name","fileType","http","content","import { Bot, BotCommand, Context, InlineKeyboard } from \"https://esm.sh/grammy@1.19.2\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst BOT_TOKEN: string = \"7552420566:AAF8ek1oNLJpPL3wWoizh9flRf7lGJACXaI\";\nconst KEY: string = \"mightyGraySkink\" || \"\";\nconst SCHEMA_VERSION: number = 2;\n\n// Initialize the bot\nconst bot: Bot = new Bot(BOT_TOKEN);\n\ninterface User {\n id: number;\n username?: string;\n first_name?: string;\n last_name?: string;\n}\n\ninterface UserStats {\n messageCount: number;\n lastActive: string;\n}\n\n// Set up SQLite database\nasync function setupDatabase(): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY,\n username TEXT,\n first_name TEXT,\n last_name TEXT,\n chat_id INTEGER,\n joined_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n message_count INTEGER DEFAULT 0,\n last_active DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n}\n\nasync function updateUserStats(userId: number): Promise {\n await sqlite.execute(\n `\n UPDATE ${KEY}_users_${SCHEMA_VERSION}\n SET message_count = message_count + 1, last_active = CURRENT_TIMESTAMP\n WHERE id = ?\n `,\n [userId],\n );\n}\n\nasync function getUserStats(userId: number): Promise {\n const result = await sqlite.execute(\n `\n SELECT message_count, last_active\n FROM ${KEY}_users_${SCHEMA_VERSION}\n WHERE id = ?\n `,\n [userId],\n );\n\n if (result.rows.length > 0) {\n return {\n messageCount: result.rows[0].message_count,\n lastActive: result.rows[0].last_active,\n };\n }\n return null;\n}\n\n// Handle the /start command\nbot.command(\"start\", async (ctx: Context): Promise => {\n const user: User = ctx.from as User;\n const chatId: number = ctx.chat?.id || 0;\n\n // Save user to database\n await sqlite.execute(\n `\n INSERT OR REPLACE INTO ${KEY}_users_${SCHEMA_VERSION} \n (id, username, first_name, last_name, chat_id) \n VALUES (?, ?, ?, ?, ?)\n `,\n [user.id, user.username, user.first_name, user.last_name, chatId],\n );\n\n const keyboard = new InlineKeyboard()\n .text(\"Help\", \"help\")\n .text(\"My Stats\", \"stats\");\n\n await ctx.reply(`Welcome, ${user.first_name}! Your details have been saved. How can I assist you?`, {\n reply_markup: keyboard,\n });\n});\n\n// Handle the /help command\nbot.command(\"help\", async (ctx: Context): Promise => {\n await ctx.reply(\n \"Here are the available commands:\\n\"\n + \"/start - Start the bot\\n\"\n + \"/help - Show this help message\\n\"\n + \"/stats - Show your usage statistics\",\n );\n});\n\n// Handle the /stats command\nbot.command(\"stats\", async (ctx: Context): Promise => {\n const user: User = ctx.from as User;\n const stats = await getUserStats(user.id);\n\n if (stats) {\n await ctx.reply(\n `Here are your stats, ${user.first_name}:\\n`\n + `Messages sent: ${stats.messageCount}\\n`\n + `Last active: ${stats.lastActive}`,\n );\n } else {\n await ctx.reply(\"Sorry, I couldn't find your stats. Try sending a message first!\");\n }\n});\n\n// Handle regular messages\nbot.on(\"message\", async (ctx: Context): Promise => {\n const user: User = ctx.from as User;\n const messageText: string | undefined = ctx.message?.text;\n\n if (messageText) {\n await updateUserStats(user.id);\n await ctx.reply(`You said: ${messageText}`);\n }\n});\n\n// Handle callback queries\nbot.on(\"callback_query:data\", async (ctx: Context): Promise => {\n const callbackData = ctx.callbackQuery?.data;\n\n if (callbackData === \"help\") {\n await ctx.answerCallbackQuery();\n await ctx.reply(\n \"Here are the available commands:\\n\"\n + \"/start - Start the bot\\n\"\n + \"/help - Show this help message\\n\"\n + \"/stats - Show your usage statistics\",\n );\n } else if (callbackData === \"stats\") {\n await ctx.answerCallbackQuery();\n const user: User = ctx.from as User;\n const stats = await getUserStats(user.id);\n\n if (stats) {\n await ctx.reply(\n `Here are your stats, ${user.first_name}:\\n`\n + `Messages sent: ${stats.messageCount}\\n`\n + `Last active: ${stats.lastActive}`,\n );\n } else {\n await ctx.reply(\"Sorry, I couldn't find your stats. Try sending a message first!\");\n }\n }\n});\n\n// Error handling\nbot.catch((err: Error): void => {\n console.error(\"Error in bot:\", err);\n});\n\nexport default async function runBot(): Promise {\n try {\n await setupDatabase();\n console.log(\"Database setup complete\");\n\n const commands: BotCommand[] = [\n { command: \"start\", description: \"Start the bot\" },\n { command: \"help\", description: \"Show help information\" },\n { command: \"stats\", description: \"Show your usage statistics\" },\n ];\n await bot.api.setMyCommands(commands);\n\n console.log(\"Starting bot...\");\n await bot.start({\n onStart: (botInfo: User): void => {\n console.log(`Bot @${botInfo.username} started!`);\n },\n });\n } catch (error: unknown) {\n console.error(\"Failed to start the bot:\", error);\n }\n}\nrunBot();","import { Bot, BotCommand, Context, InlineKeyboard } from \"https://esm.sh/grammy@1.19.2\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst BOT_TOKEN: string = \"7552420566:AAF8ek1oNLJpPL3wWoizh9flRf7lGJACXaI\";\nconst KEY: string = \"mightyGraySkink\" || \"\";\nconst SCHEMA_VERSION: number = 2;\n\n// Initialize the bot\nconst bot: Bot = new Bot(BOT_TOKEN);\n\ninterface User {\n id: number;\n username?: string;\n first_name?: string;\n last_name?: string;\n}\n\ninterface UserStats {\n messageCount: number;\n lastActive: string;\n}\n\n// Set up SQLite database\nasync function setupDatabase(): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY,\n username TEXT,\n first_name TEXT,\n last_name TEXT,\n chat_id INTEGER,\n joined_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n message_count INTEGER DEFAULT 0,\n last_active DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n}\n\nasync function updateUserStats(userId: number): Promise {\n await sqlite.execute(\n `\n UPDATE ${KEY}_users_${SCHEMA_VERSION}\n SET message_count = message_count + 1, last_active = CURRENT_TIMESTAMP\n WHERE id = ?\n `,\n [userId],\n );\n}\n\nasync function getUserStats(userId: number): Promise {\n const result = await sqlite.execute(\n `\n SELECT message_count, last_active\n FROM ${KEY}_users_${SCHEMA_VERSION}\n WHERE id = ?\n `,\n [userId],\n );\n\n if (result.rows.length > 0) {\n return {\n messageCount: result.rows[0].message_count,\n lastActive: result.rows[0].last_active,\n };\n }\n return null;\n}\n\n// Handle the /start command\nbot.command(\"start\", async (ctx: Context): Promise => {\n const user: User = ctx.from as User;\n const chatId: number = ctx.chat?.id || 0;\n\n // Save user to database\n await sqlite.execute(\n `\n INSERT OR REPLACE INTO ${KEY}_users_${SCHEMA_VERSION} \n (id, username, first_name, last_name, chat_id) \n VALUES (?, ?, ?, ?, ?)\n `,\n [user.id, user.username, user.first_name, user.last_name, chatId],\n );\n\n const keyboard = new InlineKeyboard()\n .text(\"Help\", \"help\")\n .text(\"My Stats\", \"stats\");\n\n await ctx.reply(`Welcome, ${user.first_name}! Your details have been saved. How can I assist you?`, {\n reply_markup: keyboard,\n });\n});\n\n// Handle the /help command\nbot.command(\"help\", async (ctx: Context): Promise => {\n await ctx.reply(\n \"Here are the available commands:\\n\"\n + \"/start - Start the bot\\n\"\n + \"/help - Show this help message\\n\"\n + \"/stats - Show your usage statistics\",\n );\n});\n\n// Handle the /stats command\nbot.command(\"stats\", async (ctx: Context): Promise => {\n const user: User = ctx.from as User;\n const stats = await getUserStats(user.id);\n\n if (stats) {\n await ctx.reply(\n `Here are your stats, ${user.first_name}:\\n`\n + `Messages sent: ${stats.messageCount}\\n`\n + `Last active: ${stats.lastActive}`,\n );\n } else {\n await ctx.reply(\"Sorry, I couldn't find your stats. Try sending a message first!\");\n }\n});\n\n// Handle regular messages\nbot.on(\"message\", async (ctx: Context): Promise => {\n const user: User = ctx.from as User;\n const messageText: string | undefined = ctx.message?.text;\n\n if (messageText) {\n await updateUserStats(user.id);\n await ctx.reply(`You said: ${messageText}`);\n }\n});\n\n// Handle callback queries\nbot.on(\"callback_query:data\", async (ctx: Context): Promise => {\n const callbackData = ctx.callbackQuery?.data;\n\n if (callbackData === \"help\") {\n await ctx.answerCallbackQuery();\n await ctx.reply(\n \"Here are the available commands:\\n\"\n + \"/start - Start the bot\\n\"\n + \"/help - Show this help message\\n\"\n + \"/stats - Show your usage statistics\",\n );\n } else if (callbackData === \"stats\") {\n await ctx.answerCallbackQuery();\n const user: User = ctx.from as User;\n const stats = await getUserStats(user.id);\n\n if (stats) {\n await ctx.reply(\n `Here are your stats, ${user.first_name}:\\n`\n + `Messages sent: ${stats.messageCount}\\n`\n + `Last active: ${stats.lastActive}`,\n );\n } else {\n await ctx.reply(\"Sorry, I couldn't find your stats. Try sending a message first!\");\n }\n }\n});\n\n// Error handling\nbot.catch((err: Error): void => {\n console.error(\"Error in bot:\", err);\n});\n\nexport default async function runBot(): Promise {\n try {\n await setupDatabase();\n console.log(\"Database setup complete\");\n\n const commands: BotCommand[] = [\n { command: \"start\", description: \"Start the bot\" },\n { command: \"help\", description: \"Show help information\" },\n { command: \"stats\", description: \"Show your usage statistics\" },\n ];\n await bot.api.setMyCommands(commands);\n\n console.log(\"Starting bot...\");\n await bot.start({\n onStart: (botInfo: User): void => {\n console.log(`Bot @${botInfo.username} started!`);\n },\n });\n } catch (error: unknown) {\n console.error(\"Failed to start the bot:\", error);\n }\n}\n","createdAt",["D",1731763535343],"branchVersion","branchId","156c9b08-2776-11f0-b46e-569c3dd06744","id","156c4d9c-2776-11f0-b46e-569c3dd06744","mightyGraySkink",["D",1746204856750],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","71e33df7-b156-4c39-8850-4793840d56a7","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","6d11c4c5-1d74-4e4c-9c50-4ab8896fe472","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",29,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","farahani","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJvdnU2aHkyNG54cURvOWVqRW1CR0JNbUNENCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":150,"_79":151,"_81":152,"_83":25},"tree",[144],"files",[144],"counts",{"_133":61,"_134":135,"_136":61,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"159382cc-2776-11f0-b46e-569c3dd06744","parentId","latest",["D",1731763535343],6,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":61,"_143":61},"connections",{"_141":61,"_142":61},"count","unfilledCount","emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":145,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1731763535343],"children",[],[28],["D",1746204856750],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":57,"_195":-5,"_196":-7,"_197":-7,"_198":61,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":85,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v7