[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_107":108,"_109":110},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","StonedSheamus","name","The-Wandering-Clerik","path","store.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/StonedSheamus/The-Wandering-Clerik/code/store.ts","extension","id","491334fd-5ea7-4e2d-8708-41861bebc263","fileId","76549674-aa1e-11f1-9321-1607ee4eb77e","parentId","branchId","14611edd-64e7-4a83-ae11-563983a50244","branchVersion",35,"latest",true,"createdAt",["D",1788756910186],"version",3,"fileType","script","content","// =============================================================================\n// store.ts — persistence, backed by Val Town's built-in SQLite. Characters,\n// merchant offers, and the quest board are stored as JSON blobs. A small\n// `meta` table tracks cross-cycle timing (when the merchant last posted an\n// ad, etc.) since the bot now runs as a Cron val that restarts every few\n// minutes rather than one continuous process.\n// =============================================================================\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Character, Merchant, MerchantOffer } from \"./game.ts\";\nimport { Quest, QuestBoard } from \"./quests.ts\";\n\nlet initialized = false;\n\nexport async function initStore(): Promise {\n if (initialized) return;\n await sqlite.execute(`\n create table if not exists huntandhoard_characters (\n username text primary key,\n data text not null,\n updated_at integer not null\n )\n `);\n await sqlite.execute(`\n create table if not exists huntandhoard_merchant (\n id integer primary key check (id = 1),\n offers text not null,\n updated_at integer not null\n )\n `);\n await sqlite.execute(`\n create table if not exists huntandhoard_channels (\n channel text primary key,\n added_by text not null,\n added_at integer not null\n )\n `);\n await sqlite.execute(`\n create table if not exists huntandhoard_quests (\n id integer primary key check (id = 1),\n quests text not null,\n updated_at integer not null\n )\n `);\n await sqlite.execute(`\n create table if not exists huntandhoard_meta (\n key text primary key,\n value text not null\n )\n `);\n initialized = true;\n}\n\nfunction keyOf(username: string): string {\n return String(username || \"\").trim().toLowerCase();\n}\n\n// -----------------------------------------------------------------------\n// Characters\n// -----------------------------------------------------------------------\nexport async function getCharacter(\n username: string,\n): Promise {\n await initStore();\n const result = await sqlite.execute({\n sql: \"select data from huntandhoard_characters where username = ?\",\n args: [keyOf(username)],\n });\n if (!result.rows.length) return null;\n const row = result.rows[0] as any;\n const character = JSON.parse(row.data) as Character;\n if (!character.questProgress) character.questProgress = {}; // back-compat\n return character;\n}\n\nexport async function saveCharacter(character: Character): Promise {\n await initStore();\n await sqlite.execute({\n sql: `insert into huntandhoard_characters (username, data, updated_at)\n values (?, ?, ?)\n on conflict(username) do update set data = excluded.data, updated_at = excluded.updated_at`,\n args: [keyOf(character.username), JSON.stringify(character), Date.now()],\n });\n}\n\nexport async function deleteCharacter(username: string): Promise {\n await initStore();\n await sqlite.execute({\n sql: \"delete from huntandhoard_characters where username = ?\",\n args: [keyOf(username)],\n });\n}\n\n// -----------------------------------------------------------------------\n// Merchant\n// -----------------------------------------------------------------------\nexport async function getMerchantOffers(): Promise {\n await initStore();\n const result = await sqlite.execute(\n \"select offers from huntandhoard_merchant where id = 1\",\n );\n if (!result.rows.length) {\n const fresh = Merchant.rollOffers();\n await saveMerchantOffers(fresh);\n return fresh;\n }\n const row = result.rows[0] as any;\n return JSON.parse(row.offers) as MerchantOffer[];\n}\n\nexport async function saveMerchantOffers(\n offers: MerchantOffer[],\n): Promise {\n await initStore();\n await sqlite.execute({\n sql: `insert into huntandhoard_merchant (id, offers, updated_at)\n values (1, ?, ?)\n on conflict(id) do update set offers = excluded.offers, updated_at = excluded.updated_at`,\n args: [JSON.stringify(offers), Date.now()],\n });\n}\n\n// -----------------------------------------------------------------------\n// Channel roster\n// -----------------------------------------------------------------------\nexport async function getChannels(): Promise {\n await initStore();\n const result = await sqlite.execute(\n \"select channel from huntandhoard_channels order by added_at asc\",\n );\n return (result.rows as any[]).map((row) => row.channel as string);\n}\n\nexport async function addChannel(\n channel: string,\n addedBy: string,\n): Promise {\n await initStore();\n await sqlite.execute({\n sql: `insert into huntandhoard_channels (channel, added_by, added_at)\n values (?, ?, ?)\n on conflict(channel) do nothing`,\n args: [channel.toLowerCase(), addedBy, Date.now()],\n });\n}\n\nexport async function removeChannel(channel: string): Promise {\n await initStore();\n await sqlite.execute({\n sql: \"delete from huntandhoard_channels where channel = ?\",\n args: [channel.toLowerCase()],\n });\n}\n\n// -----------------------------------------------------------------------\n// Quest board\n// -----------------------------------------------------------------------\nexport async function getQuestBoard(): Promise {\n await initStore();\n const result = await sqlite.execute(\n \"select quests from huntandhoard_quests where id = 1\",\n );\n if (!result.rows.length) {\n const fresh = QuestBoard.rollBoard();\n await saveQuestBoard(fresh);\n return fresh;\n }\n const row = result.rows[0] as any;\n return JSON.parse(row.quests) as Quest[];\n}\n\nexport async function saveQuestBoard(quests: Quest[]): Promise {\n await initStore();\n await sqlite.execute({\n sql: `insert into huntandhoard_quests (id, quests, updated_at)\n values (1, ?, ?)\n on conflict(id) do update set quests = excluded.quests, updated_at = excluded.updated_at`,\n args: [JSON.stringify(quests), Date.now()],\n });\n}\n\n// -----------------------------------------------------------------------\n// Meta — small key/value store for cross-cycle timing\n// -----------------------------------------------------------------------\nexport async function getMeta(key: string): Promise {\n await initStore();\n const result = await sqlite.execute({\n sql: \"select value from huntandhoard_meta where key = ?\",\n args: [key],\n });\n if (!result.rows.length) return null;\n return (result.rows[0] as any).value as string;\n}\n\nexport async function setMeta(key: string, value: string): Promise {\n await initStore();\n await sqlite.execute({\n sql: `insert into huntandhoard_meta (key, value) values (?, ?)\n on conflict(key) do update set value = excluded.value`,\n args: [key, value],\n });\n}","deleted",false,"label",[14],"18a739db-79f6-405b-989c-5ec0b798f374",["D",1788715747973],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","cc37ba10-6e6d-4af6-a801-9955c92d23c4","pinnedFileId","77260020-aa18-11f1-9dac-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a04ba1-c79f-7319-b4f2-7c4f3772837b","tursoName","18a739db79f6405b989c5ec0b798f374","tursoHostname","18a739db79f6405b989c5ec0b798f374-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789500689328],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_106":102},"org",{"_9":10,"_99":100,"_101":102,"_55":56,"_103":104,"_105":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",65,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Shea Stolp","avatar","https://lh3.googleusercontent.com/a/ACg8ocIWmQgR3gyoMMicg2zCAoN1c7i36qX5mf9gRIdIXm8F2mo-ig=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_140":141,"_142":143,"_144":145,"_146":42,"_147":42,"_148":42,"_149":32,"_150":-5,"_151":-7,"_152":-7,"_153":63,"_154":42,"_155":42,"_156":-5,"_157":42,"_158":42,"_159":42,"_160":-5},"ENV",{"_111":112,"_113":114,"_115":90,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]