[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_247":248,"_249":250},"routes/_app.x.$handle.$name",{"_107":106,"_38":51,"_116":97,"_33":117,"_13":14,"_118":-5,"_11":119,"_120":121,"_122":123,"_124":125,"_126":127,"_26":-5,"_128":-5,"_129":-5,"_130":31,"_131":132,"_133":66,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":61,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":78,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":90,"_91":92,"_93":94,"_95":31},"version",53,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","92c46bd0-bda1-4224-8f35-9c146eafea90","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","reminder.cron.ts","latestPath","fileId","b9a44596-b1b7-11f1-b638-1607ee4eb77e","name","fileType","interval","content","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { currentStageDuration, migrate, syncStageTick } from \"./db.ts\";\nimport { sendNtfy } from \"./ntfy.ts\";\n\n/**\n * Läuft alle X Minuten (im Val Town Dashboard einstellbar, empfohlen: alle 15 Min).\n *\n * Macht in dieser Reihenfolge:\n * 1. Prüft, ob noch wachsende Pflanzen inzwischen ausgewachsen sind -> setzt\n * matured/matured_at/decays_at.\n * 2. Prüft, ob der \"12-Unique-Crops\"-Eintrag (is_bonus_source) inzwischen\n * verfallen ist -> falls ja: rechnet alle noch wachsenden Pflanzen auf den\n * aktuellen Stand um (mit der bisherigen, schnellen Dauer) und schaltet\n * danach global auf die langsame Dauer um.\n * 3. Verschickt ntfy-Pushes: 12h, 6h, 2h und 1h vor Verfall + genau bei Verfall.\n */\n\n/** Feste Erinnerungs-Schwellen in Stunden vor Verfall (nicht änderbar, nur an/aus) */\nconst REMINDER_HOURS = [12, 6, 2, 1];\nexport default async function () {\n await migrate();\n const now = Date.now();\n\n const settings = (await sqlite.execute(\"SELECT * FROM settings WHERE id = 1\"))\n .rows[0] as any;\n const plants = (await sqlite.execute(\"SELECT * FROM plants\")).rows as any[];\n\n const dur = currentStageDuration(settings);\n\n // \"Next Stage\"-Timer weiterzählen (auch wenn gerade niemand die Seite offen hat)\n await syncStageTick(settings, now);\n\n // 1. Reife prüfen\n for (const p of plants) {\n if (p.matured) continue;\n const elapsedSec = (now - settings.last_recalc_at) / 1000;\n const consumed = elapsedSec / dur;\n const remaining = p.stages_remaining - consumed;\n if (remaining <= 0) {\n const maturedAt = now;\n const decaysAt = p.decay_days != null\n ? maturedAt + p.decay_days * 86400000\n : null;\n await sqlite.execute({\n sql:\n \"UPDATE plants SET matured = 1, matured_at = ?, stages_remaining = 0, decays_at = ? WHERE id = ?\",\n args: [maturedAt, decaysAt, p.id],\n });\n p.matured = 1;\n p.matured_at = maturedAt;\n p.decays_at = decaysAt;\n }\n }\n\n // 2. Bonus-Quelle (12 Unique Crops) verfallen? -> global umrechnen & umschalten\n const bonusSource = plants.find((p) => p.is_bonus_source === 1);\n if (\n bonusSource &&\n settings.bonus_active &&\n bonusSource.matured &&\n bonusSource.decays_at != null &&\n bonusSource.decays_at <= now\n ) {\n for (const p of plants) {\n if (p.matured || p.id === bonusSource.id) continue;\n const elapsedSec = (now - settings.last_recalc_at) / 1000;\n const consumed = elapsedSec / dur; // dur = noch die schnelle Dauer bis hierhin\n const newRemaining = Math.max(0, p.stages_remaining - consumed);\n await sqlite.execute({\n sql: \"UPDATE plants SET stages_remaining = ? WHERE id = ?\",\n args: [newRemaining, p.id],\n });\n }\n await sqlite.execute({\n sql:\n \"UPDATE settings SET bonus_active = 0, last_recalc_at = ? WHERE id = 1\",\n args: [now],\n });\n await sendNtfy(\n settings.ntfy_topic,\n \"12-Unique-Bonus verloren\",\n \"🌱 Die 12 Unique Crops sind verfallen. Wachstum in allen Greenhouses läuft ab jetzt langsamer weiter.\",\n );\n }\n\n // 3. Verfalls-Reminder verschicken\n const maturing = (\n await sqlite.execute(\n \"SELECT * FROM plants WHERE matured = 1 AND decays_at IS NOT NULL\",\n )\n ).rows as any[];\n\n const reminderMs = (settings.reminder_hours_before ?? 12) * 3600 * 1000;\n\n for (const p of maturing) {\n const remainingMs = p.decays_at - now;\n\n if (!p.notified_reminder && remainingMs <= reminderMs && remainingMs > 0) {\n const hrs = (remainingMs / 3600000).toFixed(1);\n await sendNtfy(\n settings.ntfy_topic,\n `Greenhouse ${p.plot}: ${p.name}`,\n `⏳ Verfällt in ca. ${hrs}h – Zeit zum Ernten!`,\n );\n await sqlite.execute({\n sql: \"UPDATE plants SET notified_reminder = 1 WHERE id = ?\",\n args: [p.id],\n });\n }\n\n if (!p.notified_0 && remainingMs <= 0) {\n await sendNtfy(\n settings.ntfy_topic,\n `Greenhouse ${p.plot}: ${p.name}`,\n `💀 Ist JETZT verfallen (oder verfällt in diesem Moment)!`,\n 5,\n );\n await sqlite.execute({\n sql: \"UPDATE plants SET notified_0 = 1 WHERE id = ?\",\n args: [p.id],\n });\n }\n }\n}","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { currentStageDuration, migrate, syncStageTick } from \"./db.ts\";\nimport { sendNtfy } from \"./ntfy.ts\";\n\n/**\n * Läuft alle X Minuten (im Val Town Dashboard einstellbar, empfohlen: alle 15 Min).\n *\n * Macht in dieser Reihenfolge:\n * 1. Prüft, ob noch wachsende Pflanzen inzwischen ausgewachsen sind -> setzt\n * matured/matured_at/decays_at.\n * 2. Prüft, ob der \"12-Unique-Crops\"-Eintrag (is_bonus_source) inzwischen\n * verfallen ist -> falls ja: rechnet alle noch wachsenden Pflanzen auf den\n * aktuellen Stand um (mit der bisherigen, schnellen Dauer) und schaltet\n * danach global auf die langsame Dauer um.\n * 3. Verschickt ntfy-Pushes: 12h, 6h, 2h und 1h vor Verfall + genau bei Verfall.\n */\n\n/** Feste Erinnerungs-Schwellen in Stunden vor Verfall (nicht änderbar, nur an/aus) */\nconst REMINDER_HOURS = [12, 6, 2, 1];\n\nexport default async function () {\n await migrate();\n const now = Date.now();\n\n const settings = (await sqlite.execute(\"SELECT * FROM settings WHERE id = 1\"))\n .rows[0] as any;\n const plants = (await sqlite.execute(\"SELECT * FROM plants\")).rows as any[];\n\n const dur = currentStageDuration(settings);\n\n // \"Next Stage\"-Timer weiterzählen (auch wenn gerade niemand die Seite offen hat)\n await syncStageTick(settings, now);\n\n // 1. Reife prüfen\n for (const p of plants) {\n if (p.matured) continue;\n const elapsedSec = (now - settings.last_recalc_at) / 1000;\n const consumed = elapsedSec / dur;\n const remaining = p.stages_remaining - consumed;\n if (remaining <= 0) {\n const maturedAt = now;\n const decaysAt = p.decay_days != null\n ? maturedAt + p.decay_days * 86400000\n : null;\n await sqlite.execute({\n sql:\n \"UPDATE plants SET matured = 1, matured_at = ?, stages_remaining = 0, decays_at = ? WHERE id = ?\",\n args: [maturedAt, decaysAt, p.id],\n });\n p.matured = 1;\n p.matured_at = maturedAt;\n p.decays_at = decaysAt;\n }\n }\n\n // 2. Bonus-Quelle (12 Unique Crops) verfallen? -> global umrechnen & umschalten\n const bonusSource = plants.find((p) => p.is_bonus_source === 1);\n if (\n bonusSource &&\n settings.bonus_active &&\n bonusSource.matured &&\n bonusSource.decays_at != null &&\n bonusSource.decays_at <= now\n ) {\n for (const p of plants) {\n if (p.matured || p.id === bonusSource.id) continue;\n const elapsedSec = (now - settings.last_recalc_at) / 1000;\n const consumed = elapsedSec / dur; // dur = noch die schnelle Dauer bis hierhin\n const newRemaining = Math.max(0, p.stages_remaining - consumed);\n await sqlite.execute({\n sql: \"UPDATE plants SET stages_remaining = ? WHERE id = ?\",\n args: [newRemaining, p.id],\n });\n }\n await sqlite.execute({\n sql:\n \"UPDATE settings SET bonus_active = 0, last_recalc_at = ? WHERE id = 1\",\n args: [now],\n });\n await sendNtfy(\n settings.ntfy_topic,\n \"12-Unique-Bonus verloren\",\n \"🌱 Die 12 Unique Crops sind verfallen. Wachstum in allen Greenhouses läuft ab jetzt langsamer weiter.\",\n );\n }\n\n // 3. Verfalls-Reminder verschicken\n const maturing = (\n await sqlite.execute(\n \"SELECT * FROM plants WHERE matured = 1 AND decays_at IS NOT NULL\",\n )\n ).rows as any[];\n\n const reminderMs = (settings.reminder_hours_before ?? 12) * 3600 * 1000;\n\n for (const p of maturing) {\n const remainingMs = p.decays_at - now;\n\n if (!p.notified_reminder && remainingMs <= reminderMs && remainingMs > 0) {\n const hrs = (remainingMs / 3600000).toFixed(1);\n await sendNtfy(\n settings.ntfy_topic,\n `Greenhouse ${p.plot}: ${p.name}`,\n `⏳ Verfällt in ca. ${hrs}h – Zeit zum Ernten!`,\n );\n await sqlite.execute({\n sql: \"UPDATE plants SET notified_reminder = 1 WHERE id = ?\",\n args: [p.id],\n });\n }\n\n if (!p.notified_0 && remainingMs <= 0) {\n await sendNtfy(\n settings.ntfy_topic,\n `Greenhouse ${p.plot}: ${p.name}`,\n `💀 Ist JETZT verfallen (oder verfällt in diesem Moment)!`,\n 5,\n );\n await sqlite.execute({\n sql: \"UPDATE plants SET notified_0 = 1 WHERE id = ?\",\n args: [p.id],\n });\n }\n }\n}","createdAt",["D",1789584877384],"branchVersion","branchId","5bd398ad-12ba-4028-8eba-dfbdf14ab02c","id","7b15d8d4-1b2f-4c9d-a82c-e6a4fd2392bd","greenhouse-tracker",["D",1789553752971],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","greenhouse","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/9f884213-1c58-4d50-e789-8eb14c19df01/square512?exp=1789625358&sig=91f327518e1ad97b4e2190d36f4eadb480ec3cf55e2b8bcceef635ddd5e6e03f","022b11bc-119b-4032-ae93-0ecc18984e24","pinnedFileId","cc386f34-b1b7-11f1-b8f5-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0a9b4-b1bb-7471-9346-c6e90094b3d4","tursoName","7b15d8d41b2f4c9da82ce6a4fd2392bd","tursoHostname","7b15d8d41b2f4c9da82ce6a4fd2392bd-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789554646443],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_107":106,"_115":111},"org",{"_107":106,"_108":109,"_110":111,"_19":62,"_112":113,"_114":31},"branch",{"_13":96,"_38":97,"_49":48,"_98":50,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":51,"_105":106},"isOwned",100,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Sirboros","handle","displayName","Tobago Pollheimer","avatar","https://lh3.googleusercontent.com/a/ACg8ocJphoRvccoKjRnJlHS7fIdlDPDRKBxYRZzBAA_kSYW2xxVTEQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":242,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":61,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":243,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":244,"_91":245,"_93":246,"_95":31},"tree",[200,203,204,205,206,207],"files",[200,201,202,203,204,205,206,207],"counts",{"_189":70,"_190":191,"_192":70,"_193":194,"_195":196},"contents",[138,139,140,141,142,143],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":183,"_38":56,"_36":184,"_146":-5,"_47":48,"_46":185,"_148":66,"_44":186,"_13":70,"_39":187,"_41":-5,"_30":31,"_153":-5,"_33":188},{"_49":176,"_38":177,"_36":178,"_146":-5,"_47":48,"_46":179,"_148":31,"_44":180,"_13":173,"_39":26,"_41":181,"_30":31,"_153":-5,"_33":182},{"_49":168,"_38":169,"_36":170,"_146":-5,"_47":48,"_46":171,"_148":31,"_44":172,"_13":173,"_39":165,"_41":174,"_30":31,"_153":-5,"_33":175},{"_49":159,"_38":160,"_36":161,"_146":-5,"_47":48,"_46":162,"_148":66,"_44":163,"_13":164,"_39":165,"_41":166,"_30":31,"_153":-5,"_33":167},{"_49":155,"_38":34,"_36":37,"_146":-5,"_47":48,"_46":14,"_148":31,"_44":156,"_13":157,"_39":40,"_41":43,"_30":31,"_153":-5,"_33":158},{"_49":144,"_38":145,"_36":64,"_146":-5,"_47":48,"_46":147,"_148":31,"_44":149,"_13":150,"_39":151,"_41":152,"_30":31,"_153":-5,"_33":154},"79498a1f-6377-4cac-8193-fe02cc4ba0ca","site.http.ts","parentId",43,"latest",["D",1789583768920],7,"http","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport {\n currentStageDuration,\n estimateMaturesAt,\n liveStagesRemaining,\n migrate,\n syncStageTick,\n} from \"./db.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\n\nasync function getSettings() {\n return (await sqlite.execute(\"SELECT * FROM settings WHERE id = 1\"))\n .rows[0] as any;\n}\n\nasync function getPlant(id: number) {\n return (await sqlite.execute({\n sql: \"SELECT * FROM plants WHERE id = ?\",\n args: [id],\n })).rows[0] as any;\n}\n\n/**\n * `stages_remaining` in der DB ist relativ zu settings.last_recalc_at gespeichert.\n * Diese Funktion rechnet einen \"live\"-Stufenwert (so wie er im UI steht) in den\n * zu speichernden Wert um – sonst würde jede Bearbeitung um die Zeit seit dem\n * letzten Recalc daneben liegen.\n */\nfunction storedForLiveStages(settings: any, now: number, liveStages: number) {\n const dur = currentStageDuration(settings);\n const elapsedSec = (now - settings.last_recalc_at) / 1000;\n return Math.max(0, liveStages) + elapsedSec / dur;\n}\n\nexport default async function (req: Request): Promise {\n await migrate();\n const url = new URL(req.url);\n\n // ---------- API ----------\n\n if (url.pathname === \"/api/state\" && req.method === \"GET\") {\n const settings = await getSettings();\n const now = Date.now();\n const stage = await syncStageTick(settings, now);\n const plants =\n (await sqlite.execute(\"SELECT * FROM plants ORDER BY plot, created_at\"))\n .rows as any[];\n\n const enriched = plants.map((p) => ({\n ...p,\n live_stages_remaining: liveStagesRemaining(p, settings, now),\n est_matures_at: estimateMaturesAt(p, settings, now),\n current_stage_seconds: currentStageDuration(settings),\n }));\n\n return json({\n settings: {\n ...settings,\n stage_tick_at: stage.stage_tick_at,\n stage_counter: stage.stage_counter,\n },\n plants: enriched,\n now,\n stage_tick_at: stage.stage_tick_at,\n stage_counter: stage.stage_counter,\n });\n }\n\n if (url.pathname === \"/api/plants\" && req.method === \"POST\") {\n const body = await req.json();\n const now = Date.now();\n if (body.is_bonus_source) {\n await sqlite.execute(\n \"UPDATE plants SET is_bonus_source = 0 WHERE is_bonus_source = 1\",\n );\n }\n\n if (body.already_matured) {\n // Pflanze ist im Spiel schon ausgewachsen: Verfallszeit kommt direkt aus\n // dem Plant-Diagnostics-Tooltip (in Millisekunden ab jetzt), kein\n // Umweg über Wachstumsstufen nötig.\n const decaysAt = body.decays_in_ms != null\n ? now + body.decays_in_ms\n : null;\n await sqlite.execute({\n sql:\n `INSERT INTO plants (plot, name, is_bonus_source, stages_remaining, matured, matured_at, decay_days, decays_at, created_at)\n VALUES (?, ?, ?, 0, 1, ?, NULL, ?, ?)`,\n args: [\n body.plot,\n body.name,\n body.is_bonus_source ? 1 : 0,\n now,\n decaysAt,\n now,\n ],\n });\n } else {\n await sqlite.execute({\n sql:\n `INSERT INTO plants (plot, name, is_bonus_source, stages_remaining, matured, decay_days, created_at)\n VALUES (?, ?, ?, ?, 0, ?, ?)`,\n args: [\n body.plot,\n body.name,\n body.is_bonus_source ? 1 : 0,\n body.stages_remaining,\n body.decay_days === \"\" || body.decay_days == null\n ? null\n : body.decay_days,\n now,\n ],\n });\n }\n return json({ ok: true });\n }\n\n const plantMatch = url.pathname.match(/^\\/api\\/plants\\/(\\d+)$/);\n\n if (plantMatch && req.method === \"PATCH\") {\n const id = Number(plantMatch[1]);\n const body = await req.json();\n const allowed = [\n \"name\",\n \"stages_remaining\",\n \"decay_days\",\n \"matured\",\n \"matured_at\",\n \"decays_at\",\n \"notified_reminder\",\n \"notified_0\",\n ];\n const fields: string[] = [];\n const args: unknown[] = [];\n for (const key of allowed) {\n if (key in body) {\n fields.push(`${key} = ?`);\n args.push(body[key]);\n }\n }\n if (body.is_bonus_source) {\n await sqlite.execute(\n \"UPDATE plants SET is_bonus_source = 0 WHERE is_bonus_source = 1\",\n );\n fields.push(\"is_bonus_source = 1\");\n }\n if (fields.length) {\n args.push(id);\n await sqlite.execute({\n sql: `UPDATE plants SET ${fields.join(\", \")} WHERE id = ?`,\n args,\n });\n }\n return json({ ok: true });\n }\n\n // Verbleibende Wachstumsstufen setzen (Wert wie im UI, \"live\")\n const stagesMatch = url.pathname.match(/^\\/api\\/plants\\/(\\d+)\\/stages$/);\n if (stagesMatch && req.method === \"POST\") {\n const id = Number(stagesMatch[1]);\n const body = await req.json();\n const now = Date.now();\n const settings = await getSettings();\n const live = Math.max(0, Number(body.stages) || 0);\n await sqlite.execute({\n sql:\n `UPDATE plants SET stages_remaining = ?, matured = 0, matured_at = NULL,\n decays_at = NULL, notified_reminder = 0, notified_0 = 0 WHERE id = ?`,\n args: [storedForLiveStages(settings, now, live), id],\n });\n return json({ ok: true });\n }\n\n // Timer-Korrektur: verschiebt den Wachstums- bzw. Verfalls-Timer um delta_ms\n const shiftMatch = url.pathname.match(/^\\/api\\/plants\\/(\\d+)\\/shift$/);\n if (shiftMatch && req.method === \"POST\") {\n const id = Number(shiftMatch[1]);\n const body = await req.json();\n const deltaMs = Number(body.delta_ms) || 0;\n const now = Date.now();\n const settings = await getSettings();\n const plant = await getPlant(id);\n if (!plant) return json({ error: \"not found\" }, 404);\n\n if (!plant.matured) {\n const durMs = currentStageDuration(settings) * 1000;\n const live = liveStagesRemaining(plant, settings, now);\n const newLive = Math.max(0, live + deltaMs / durMs);\n await sqlite.execute({\n sql: \"UPDATE plants SET stages_remaining = ? WHERE id = ?\",\n args: [storedForLiveStages(settings, now, newLive), id],\n });\n } else if (plant.decays_at != null) {\n await sqlite.execute({\n sql: \"UPDATE plants SET decays_at = ? WHERE id = ?\",\n args: [plant.decays_at + deltaMs, id],\n });\n }\n return json({ ok: true });\n }\n\n const setDecayMatch = url.pathname.match(/^\\/api\\/plants\\/(\\d+)\\/set-decay$/);\n if (setDecayMatch && req.method === \"POST\") {\n const id = Number(setDecayMatch[1]);\n const body = await req.json();\n const now = Date.now();\n const plant = await getPlant(id);\n const decaysAt = body.decays_in_ms != null ? now + body.decays_in_ms : null;\n await sqlite.execute({\n sql:\n `UPDATE plants SET matured = 1, matured_at = ?, stages_remaining = 0, decays_at = ?,\n notified_reminder = 0, notified_0 = 0 WHERE id = ?`,\n args: [plant?.matured ? plant.matured_at : now, decaysAt, id],\n });\n return json({ ok: true });\n }\n\n if (plantMatch && req.method === \"DELETE\") {\n const id = Number(plantMatch[1]);\n await sqlite.execute({\n sql: \"DELETE FROM plants WHERE id = ?\",\n args: [id],\n });\n return json({ ok: true });\n }\n\n if (url.pathname === \"/api/settings\" && req.method === \"POST\") {\n const body = await req.json();\n const allowed = [\n \"fast_stage_seconds\",\n \"slow_stage_seconds\",\n \"ntfy_topic\",\n \"reminder_hours_before\",\n ];\n const fields: string[] = [];\n const args: unknown[] = [];\n for (const key of allowed) {\n if (key in body) {\n fields.push(`${key} = ?`);\n args.push(body[key]);\n }\n }\n if (fields.length) {\n await sqlite.execute({\n sql: `UPDATE settings SET ${fields.join(\", \")} WHERE id = 1`,\n args,\n });\n }\n return json({ ok: true });\n }\n\n if (url.pathname === \"/api/notes\" && req.method === \"POST\") {\n const body = await req.json();\n await sqlite.execute({\n sql: \"UPDATE settings SET notes = ? WHERE id = 1\",\n args: [String(body.notes ?? \"\")],\n });\n return json({ ok: true });\n }\n\n // \"Next Stage\"-Timer: Zähler manuell korrigieren oder Timer neu starten\n if (url.pathname === \"/api/stage\" && req.method === \"POST\") {\n const body = await req.json();\n const now = Date.now();\n const settings = await getSettings();\n\n if (body.reset) {\n const durMs = currentStageDuration(settings) * 1000;\n await sqlite.execute({\n sql: \"UPDATE settings SET stage_tick_at = ? WHERE id = 1\",\n args: [now + durMs],\n });\n } else if (body.delta != null) {\n await sqlite.execute({\n sql: \"UPDATE settings SET stage_counter = MAX(0, stage_counter + ?) WHERE id = 1\",\n args: [Number(body.delta) || 0],\n });\n }\n return json({ ok: true });\n }\n\n // Manuelles Umschalten (falls du die 12 Unique Crops neu pflanzt und den\n // Bonus wieder aktivierst, ohne auf den automatischen Verfall zu warten)\n if (url.pathname === \"/api/bonus-toggle\" && req.method === \"POST\") {\n const settings = await getSettings();\n const plants =\n (await sqlite.execute(\"SELECT * FROM plants WHERE matured = 0\"))\n .rows as any[];\n const now = Date.now();\n const dur = currentStageDuration(settings);\n for (const p of plants) {\n const elapsedSec = (now - settings.last_recalc_at) / 1000;\n const newRemaining = Math.max(0, p.stages_remaining - elapsedSec / dur);\n await sqlite.execute({\n sql: \"UPDATE plants SET stages_remaining = ? WHERE id = ?\",\n args: [newRemaining, p.id],\n });\n }\n await sqlite.execute({\n sql:\n \"UPDATE settings SET bonus_active = ?, last_recalc_at = ? WHERE id = 1\",\n args: [settings.bonus_active ? 0 : 1, now],\n });\n return json({ ok: true });\n }\n\n if (url.pathname === \"/api/test-push\" && req.method === \"POST\") {\n const settings = await getSettings();\n const { sendNtfy } = await import(\"./ntfy.ts\");\n const result = await sendNtfy(\n settings.ntfy_topic,\n \"Test-Push Greenhouse Tracker\",\n \"🧪 Wenn du das siehst, funktioniert ntfy!\",\n );\n return json(result);\n }\n\n // ---------- Frontend (statische Dateien) ----------\n\n if (req.method === \"GET\" && url.pathname.startsWith(\"/public/\")) {\n return serveFile(url.pathname);\n }\n\n if (url.pathname === \"/app.ts\" && req.method === \"GET\") {\n return serveFile(\"/public/app.ts\");\n }\n\n if (url.pathname === \"/\" && req.method === \"GET\") {\n return serveFile(\"/public/index.html\");\n }\n\n return json({ error: \"not found\" }, 404);\n}","label",[145],"2491df75-7316-4304-bfa0-4060d34e3365",["D",1789584877384],23,[34],"9f61c657-8609-4894-b779-f9384c5c37e8","ntfy.ts","990ff65e-b1b7-11f1-b9b8-1607ee4eb77e",39,["D",1789583727108],4,"script","/**\n * Schickt eine Push-Nachricht über ntfy.sh.\n *\n * Wichtig: HTTP-Header dürfen nur Latin-1 (ByteString) enthalten. Emojis in\n * Title/Tags lassen `fetch()` mit\n * \"Failed to construct 'Request': 'headers' of 'RequestInit' ... is not a valid ByteString\"\n * abbrechen. Deshalb werden Header-Werte auf reines ASCII reduziert – Emojis\n * gehören in den Nachrichtentext (Body, UTF-8).\n */\n\nexport type NtfyResult = { ok: boolean; status?: number; error?: string };\n\nfunction headerSafe(value: string): string {\n return value.replace(/[^\\x20-\\x7E]/g, \"\").replace(/\\s+/g, \" \").trim();\n}\n\nexport async function sendNtfy(\n topic: string,\n title: string,\n message: string,\n priority: 1 | 2 | 3 | 4 | 5 = 4,\n tags = \"seedling\",\n): Promise {\n if (!topic) return { ok: false, error: \"Kein ntfy-Topic gesetzt\" };\n\n try {\n const res = await fetch(`https://ntfy.sh/${encodeURIComponent(topic)}`, {\n method: \"POST\",\n headers: {\n \"Title\": headerSafe(title),\n \"Priority\": String(priority),\n \"Tags\": headerSafe(tags),\n },\n body: message,\n });\n\n if (!res.ok) {\n const text = await res.text().catch(() => \"\");\n console.error(\"ntfy push fehlgeschlagen:\", res.status, text);\n return { ok: false, status: res.status, error: text.slice(0, 300) };\n }\n return { ok: true, status: res.status };\n } catch (err) {\n console.error(\"ntfy push fehlgeschlagen:\", err);\n return { ok: false, error: String(err) };\n }\n}",[160],"7dbee08a-3410-47e7-9ddf-375d9d7332a1","db.ts","9c058108-b1b7-11f1-b337-1607ee4eb77e",51,["D",1789584868472],6,"import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * Legt Tabellen an, falls sie noch nicht existieren, und ergänzt Spalten,\n * die später dazugekommen sind (\"lazy migrate\"). Läuft bei jedem Request und\n * Cron-Lauf – ist billig, wenn alles schon existiert.\n */\n\nasync function columnExists(table: string, column: string): Promise {\n const res = await sqlite.execute(`PRAGMA table_info(${table})`);\n return (res.rows as any[]).some((r) => r.name === column);\n}\n\nasync function addColumn(table: string, column: string, ddl: string) {\n if (await columnExists(table, column)) return;\n await sqlite.execute(`ALTER TABLE ${table} ADD COLUMN ${column} ${ddl}`);\n}\n\nexport async function migrate() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS settings (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n fast_stage_seconds INTEGER NOT NULL DEFAULT 6260,\n slow_stage_seconds INTEGER NOT NULL DEFAULT 14400,\n bonus_active INTEGER NOT NULL DEFAULT 1,\n last_recalc_at INTEGER NOT NULL,\n ntfy_topic TEXT NOT NULL DEFAULT '',\n reminder_hours_before REAL NOT NULL DEFAULT 12,\n stage_tick_at INTEGER,\n stage_counter INTEGER NOT NULL DEFAULT 0,\n notes TEXT NOT NULL DEFAULT '',\n reminders_enabled INTEGER NOT NULL DEFAULT 1\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS plants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plot INTEGER NOT NULL,\n name TEXT NOT NULL,\n is_bonus_source INTEGER NOT NULL DEFAULT 0,\n stages_remaining REAL NOT NULL,\n matured INTEGER NOT NULL DEFAULT 0,\n matured_at INTEGER,\n decay_days REAL,\n decays_at INTEGER,\n notified_reminder INTEGER NOT NULL DEFAULT 0,\n notified_0 INTEGER NOT NULL DEFAULT 0,\n notified_stages TEXT NOT NULL DEFAULT '[]',\n created_at INTEGER NOT NULL\n )\n `);\n\n // Spalten für den \"Next Stage\"-Timer + Notizen nachrüsten\n await addColumn(\"settings\", \"stage_tick_at\", \"INTEGER\");\n await addColumn(\"settings\", \"stage_counter\", \"INTEGER NOT NULL DEFAULT 0\");\n await addColumn(\"settings\", \"notes\", \"TEXT NOT NULL DEFAULT ''\");\n await addColumn(\n \"settings\",\n \"reminders_enabled\",\n \"INTEGER NOT NULL DEFAULT 1\",\n );\n // Welche Erinnerungs-Schwellen (Stunden vor Verfall) schon verschickt wurden\n await addColumn(\"plants\", \"notified_stages\", \"TEXT NOT NULL DEFAULT '[]'\");\n\n const existing = await sqlite.execute(\"SELECT id FROM settings WHERE id = 1\");\n if (existing.rows.length === 0) {\n await sqlite.execute({\n sql:\n `INSERT INTO settings (id, fast_stage_seconds, slow_stage_seconds, bonus_active, last_recalc_at, ntfy_topic, reminder_hours_before, stage_counter, notes)\n VALUES (1, 6260, 14400, 1, ?, '', 12, 0, '')`,\n args: [Date.now()],\n });\n }\n}\n\nexport function currentStageDuration(settings: any): number {\n return settings.bonus_active\n ? settings.fast_stage_seconds\n : settings.slow_stage_seconds;\n}\n\n/** Wie viele Stufen sind JETZT noch übrig (live, ohne DB-Schreibzugriff) */\nexport function liveStagesRemaining(\n plant: any,\n settings: any,\n now: number,\n): number {\n if (plant.matured) return 0;\n const dur = currentStageDuration(settings);\n const elapsedSec = (now - settings.last_recalc_at) / 1000;\n return Math.max(0, plant.stages_remaining - elapsedSec / dur);\n}\n\n/** Geschätzter Zeitpunkt, wann die Pflanze ausgewachsen ist (live geschätzt) */\nexport function estimateMaturesAt(\n plant: any,\n settings: any,\n now: number,\n): number | null {\n if (plant.matured) return plant.matured_at;\n const dur = currentStageDuration(settings);\n const remaining = liveStagesRemaining(plant, settings, now);\n return now + remaining * dur * 1000;\n}\n\n/**\n * \"Next Stage\"-Timer: hält fest, wann die nächste Wachstumsstufe durch ist,\n * und zählt jede durchgelaufene Stufe im Zähler hoch.\n */\nexport async function syncStageTick(settings: any, now: number) {\n const durMs = currentStageDuration(settings) * 1000;\n let tickAt: number = settings.stage_tick_at ?? now + durMs;\n let count: number = settings.stage_counter ?? 0;\n\n if (settings.stage_tick_at == null) {\n await sqlite.execute({\n sql: \"UPDATE settings SET stage_tick_at = ? WHERE id = 1\",\n args: [tickAt],\n });\n } else if (durMs > 0 && tickAt <= now) {\n const passed = Math.floor((now - tickAt) / durMs) + 1;\n tickAt += passed * durMs;\n count += passed;\n await sqlite.execute({\n sql: \"UPDATE settings SET stage_tick_at = ?, stage_counter = ? WHERE id = 1\",\n args: [tickAt, count],\n });\n }\n\n return { stage_tick_at: tickAt, stage_counter: count };\n}",[169],"730d8876-2957-46f6-adba-89e0bdb7e3ff","README.md","dc4a03c4-b1b7-11f1-b337-1607ee4eb77e",49,["D",1789584436138],"# Greenhouse Tracker\n\nWeb-App für Hypixel Skyblock (Garden / Greenhouse) – läuft komplett auf Val Town.\n\n[App öffnen](url:site.http.ts)\n\n## Was die App macht\n\n- Alle 3 Greenhouses untereinander, mit Live-Countdown pro Pflanze\n- **Grün** = „reift in …\", **Rot** = „Verfall in …\", **Blau** = Timer ist\n abgelaufen und zählt jetzt nach oben (`+1h 20m`)\n- Unter jedem Countdown steht in Grau die **genaue Uhrzeit** des Ereignisses\n (`reift am 17.09. 08:14`) – auch nach dem Verfall bleibt sie stehen, damit du\n weißt, wann es passiert ist\n- Oben rechts der **Next-Stage-Timer** mit Zähler und `−`/`+` zum manuellen\n Korrigieren (der Zähler zählt pro durchgelaufener Wachstumsstufe automatisch\n eins hoch)\n- Oben unter der Überschrift eine graue Box mit den **nächsten Ereignissen** und\n deren exakter Zeit\n- Unten ein **Notizen-Feld** (speichert automatisch)\n- Cronjob prüft im Hintergrund und schickt Pushes via ntfy.sh\n- Wenn das „12 Unique Crops\"-Setup verfällt, rechnet die App automatisch alle\n laufenden Pflanzungen auf die langsamere Wachstumsgeschwindigkeit um\n\n## Dateien\n\n| Datei | Typ | Zweck |\n| --- | --- | --- |\n| `site.http.ts` | HTTP | API + liefert das Frontend aus |\n| `public/index.html` | Datei | Markup + Styles |\n| `public/app.ts` | Datei | Client-Logik (wird als `/app.ts` ausgeliefert) |\n| `db.ts` | Modul | Schema/Migration + Timer-Mathematik |\n| `ntfy.ts` | Modul | Push-Versand an ntfy.sh |\n| `reminder.cron.ts` | Interval | Reife/Verfall prüfen + Pushes |\n\n## ntfy einrichten (wichtig!)\n\n1. Installier die **ntfy** App auf dem Handy (Play Store / App Store, kostenlos).\n2. Denk dir einen langen, einzigartigen Topic-Namen aus, z. B.\n `greenhouse-decay-k9x2mQ7p` (nicht erratbar, damit niemand sonst mitliest).\n3. In der ntfy-App: **Server auf `https://ntfy.sh` lassen** – *nicht* die\n Val-URL eintragen! Diese Web-App ist kein ntfy-Server, sie schickt nur\n Nachrichten an ntfy.sh. Trägt man hier die Val-URL ein, kommt\n `WebSocketNotSupportedException: Expected HTTP 101 response but was '404'`.\n4. `+` → Topic abonnieren → genau den Topic-Namen eingeben (Groß-/Kleinschreibung\n zählt).\n5. In der Web-App unter „⚙️ Einstellungen\" denselben Topic-Namen eintragen und\n speichern.\n6. „Test-Push senden\" – die Antwort zeigt jetzt direkt, ob ntfy den Push\n angenommen hat (`{\"ok\":true,\"status\":200}`) oder was schiefging.\n\n> Emojis dürfen **nicht** in HTTP-Headern stehen (ntfy-Titel), sonst bricht\n> `fetch()` mit `not a valid ByteString` ab. `ntfy.ts` filtert Header deshalb auf\n> ASCII und packt Emojis in den Nachrichtentext.\n\n## Timer korrigieren\n\nLäuft die Web-App dem echten Spiel auseinander: auf die Pflanze tippen → im\nSheet „Timer korrigieren\" mit `−30m / −10m / −5m / −1m / +1m / +5m / +10m / +30m`.\nBei einer wachsenden Pflanze verschiebt das den **Wachstums**-Timer, bei einer\nausgewachsenen den **Verfalls**-Timer.\n\nIm gleichen Sheet:\n\n- **Verbleibende Wachstumsstufen** neu setzen (Wert wie im Plant Diagnostics Tool)\n- **Verfalls-Timer setzen** (Tage/Stunden/Minuten)\n- **Ausgewachsen** / **Wieder wachsend** umschalten\n- **🗑️ Entfernen** = geerntet/verfallen, raus aus der Liste\n\n## Next-Stage-Timer\n\nDer Timer oben rechts läuft über die eingestellte Stage-Dauer und zählt bei\njeder durchgelaufenen Stufe den Zähler eins hoch. Passt er nicht zum Spiel:\n\n- `−` / `+` neben der Zahl = Zähler manuell um 1 korrigieren\n- „Stage-Timer neu starten\" in den Einstellungen = Timer auf „jetzt + eine Stage\"\n\n## Einstellungen (⚙️)\n\n- **Stage-Dauer mit/ohne Bonus**: Sekunden pro Wachstumsstufe, wie im Plant\n Diagnostics Tool angezeigt (Baseline ohne Bonus 4h = 14400s; mit vollem Bonus\n ca. 1h44m20s = 6260s)\n- **Erinnerung X Stunden vorher**: Standard 12h\n\n## Wichtig zu wissen\n\n- Alles läuft serverseitig auf Val Town – die Seite muss **nicht** geöffnet sein,\n damit Pushes ankommen.\n- Die App kann nicht selbst erkennen, wann im Spiel eine der 12 Unique Crops\n stirbt – diese Pflanze wie jede andere mit Verfallsdauer eintragen und als\n „Bonus-Quelle\" markieren. Sobald ihr Timer abläuft, übernimmt die App den Rest.",[177],"9c9fa5b9-1f2d-436a-97dd-cc839b0c1a9d","f22b8b5f-3ea3-4a19-bdfb-347a42345350",41,["D",1789583738697],"directory",[56],"pulls","branches",1,"forks","envVars",{"_197":70,"_199":70},"connections",{"_197":70,"_198":70},"count","unfilledCount","emptyCount",{"_49":183,"_38":56,"_36":184,"_146":-5,"_47":48,"_46":185,"_148":66,"_44":239,"_13":70,"_39":187,"_41":-5,"_30":31,"_153":-5,"_209":240,"_33":241},{"_49":231,"_38":232,"_36":233,"_146":184,"_47":48,"_46":234,"_148":31,"_44":235,"_13":70,"_39":165,"_41":236,"_30":31,"_153":-5,"_209":237,"_33":238},{"_49":224,"_38":225,"_36":226,"_146":184,"_47":48,"_46":185,"_148":31,"_44":227,"_13":70,"_39":26,"_41":228,"_30":31,"_153":-5,"_209":229,"_33":230},{"_49":176,"_38":177,"_36":178,"_146":-5,"_47":48,"_46":179,"_148":31,"_44":221,"_13":173,"_39":26,"_41":181,"_30":31,"_153":-5,"_209":222,"_33":223},{"_49":168,"_38":169,"_36":170,"_146":-5,"_47":48,"_46":171,"_148":31,"_44":218,"_13":173,"_39":165,"_41":174,"_30":31,"_153":-5,"_209":219,"_33":220},{"_49":159,"_38":160,"_36":161,"_146":-5,"_47":48,"_46":162,"_148":66,"_44":215,"_13":164,"_39":165,"_41":166,"_30":31,"_153":-5,"_209":216,"_33":217},{"_49":155,"_38":34,"_36":37,"_146":-5,"_47":48,"_46":14,"_148":31,"_44":212,"_13":157,"_39":40,"_41":43,"_30":31,"_153":-5,"_209":213,"_33":214},{"_49":144,"_38":145,"_36":64,"_146":-5,"_47":48,"_46":147,"_148":31,"_44":208,"_13":150,"_39":151,"_41":152,"_30":31,"_153":-5,"_209":210,"_33":211},["D",1789583768920],"children",[],[145],["D",1789584877384],[],[34],["D",1789583727108],[],[160],["D",1789584868472],[],[169],["D",1789584436138],[],[177],"e1ee1e4e-cca8-4161-8a8e-30d53b74be70","index.html","69ece288-b1fd-11f1-8db7-1607ee4eb77e",["D",1789583738697],"\n\n\n\n\nGreenhouse Tracker\n\n\n\n\n\n

🌿 Greenhouse Tracker

Hypixel Skyblock · Garden · Greenhouse

Next Stage

–

\n \n 0\n \n

\n\n

📝 Notizen

\n \n

\n \n \n

\n\n

\n \n

\n\n\n\n\n

Neue Pflanzung

\n Greenhouse\n \n Name (Crop / Mutation)\n \n

\n \n Schon ausgewachsen (Decay läuft im Spiel bereits)\n

\n\n

\n Verbleibende Wachstumsstufen (aus Plant Diagnostics Tool)\n \n Verfallsdauer nach dem Ausreifen\n \n

\n\n \n\n

\n \n Das ist mein \"12 Unique Crops\"-Setup (Wachstums-Boost-Quelle)\n

\n \n \n

\n\n\n

Pflanze

\n Name\n \n\n

\n Verbleibende Wachstumsstufen\n \n

\n\n Verfällt in (Tage / Stunden / Minuten)\n

Tage

Stunden

Minuten

\n \n

\n\n

\n Timer korrigieren (falls Web-App und Spiel auseinanderlaufen)\n

\n \n \n \n \n \n \n \n \n

\n\n

\n \n

\n \n \n

\n \n

\n\n\n

Einstellungen

\n ntfy.sh Topic (frei wählbarer, langer Name)\n \n

\n In der ntfy-App bleibt der Server auf https://ntfy.sh\n (nicht die Val-URL!) – die App abonniert nur das Topic. Diese Web-App schickt\n die Pushes an ntfy.sh, sie ist kein eigener ntfy-Server.\n

\n Stage-Dauer MIT 12-Unique-Bonus (Sekunden)\n \n Stage-Dauer OHNE Bonus (Sekunden)\n \n Erinnerung wie viele Stunden vor Verfall?\n \n

\n \n

\n \n \n

\n \n

\n\n\n\n",[],[56,225],"3ec3ca83-10a2-41e5-ad0a-166b1d919858","app.ts","75106888-b1fd-11f1-9258-1607ee4eb77e",42,["D",1789583757390],"/**\n * Client-Logik für den Greenhouse Tracker.\n * Wird von site.http.ts unter /app.ts ausgeliefert (serveFile transpiliert TS).\n *\n * Alles läuft über Event-Delegation (data-action=\"…\"), weil Funktionen in\n * einem

Diff · v53