[{"_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",44,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","76693fdc-9109-45e9-9000-7db0a601d91e","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 } 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: X Stunden vor Verfall + genau bei Verfall.\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 let plants = (await sqlite.execute(\"SELECT * FROM plants\")).rows as any[];\n\n const dur = currentStageDuration(settings);\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: X Stunden vor Verfall + genau bei Verfall.\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 let plants = (await sqlite.execute(\"SELECT * FROM plants\")).rows as any[];\n\n const dur = currentStageDuration(settings);\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",1789583772916],"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=1789625343&sig=ec0bfaa2587d7b762f6065d1eb1abd1d4cad36f97b7b4a297dd82f2f6a74287c","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":175,"_38":176,"_36":177,"_146":-5,"_47":48,"_46":178,"_148":31,"_44":179,"_13":180,"_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":164,"_39":165,"_41":173,"_30":31,"_153":-5,"_33":174},{"_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],"49b8fd3c-90d5-410c-b18e-f43949572794",["D",1789583772916],17,[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],"cfd89d6c-7d53-458e-ab80-00d4e1dc3e79","db.ts","9c058108-b1b7-11f1-b337-1607ee4eb77e",40,["D",1789583727170],"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 )\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 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\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],"2fb5b303-7ad3-4463-8396-634ef582f2d5","README.md","dc4a03c4-b1b7-11f1-b337-1607ee4eb77e",23,["D",1789553876194],5,"# Greenhouse Tracker – Deployment-Anleitung\n\n## Was das ist\n\nEine kleine Web-App (läuft komplett auf Val Town, kostenlos):\n\n- Seite zeigt alle 3 Greenhouses untereinander mit Live-Countdown pro Pflanze\n- Cronjob prüft alle X Minuten im Hintergrund, ob etwas bald verfällt, und\n schickt dir dann eine Push-Nachricht via ntfy.sh\n- Wenn dein \"12 Unique Crops\"-Setup verfällt, rechnet die App automatisch alle\n anderen laufenden Pflanzungen auf die langsamere Wachstumsgeschwindigkeit um\n\n## Schritt 1 – Val Town Account\n\n1. Geh auf https://www.val.town und registrier dich kostenlos (GitHub-Login geht\n auch).\n\n## Schritt 2 – Neues Projekt anlegen\n\n1. Klick auf \"New\" → \"Project\" (bzw. \"New Val\" → Project-Ansicht, je nach\n aktuellem UI).\n2. Gib ihm einen Namen, z. B. `greenhouse-tracker`.\n3. Lege darin **vier Dateien** an, exakt mit diesen Namen (der Name entscheidet,\n ob es ein HTTP-Endpoint, ein Cronjob oder ein normales Modul wird):\n - `db.ts`\n - `ntfy.ts`\n - `site.http.ts` ← muss \"http\" im Namen haben\n - `reminder.cron.ts` ← muss \"cron\" im Namen haben\n4. Kopier den Inhalt aus den gleichnamigen Dateien, die ich dir hier gebaut\n habe, 1:1 in die jeweilige Datei rein und speichern.\n\n## Schritt 3 – Cronjob-Intervall einstellen\n\nIn der Val-Town-Oberfläche bei `reminder.cron.ts` gibt es eine Einstellung für\nden Zeitplan (Cron-Ausdruck). Empfehlung: alle 15 Minuten, z. B. `*/15 * * * *`.\n\n## Schritt 4 – Seite öffnen\n\n`site.http.ts` bekommt automatisch eine öffentliche URL (Format ungefähr\n`https://DEINUSERNAME-greenhouse-tracker.web.val.run` o.ä. – Val Town zeigt sie\ndir direkt in der Oberfläche an). Die kannst du:\n\n- am Handy im Browser öffnen\n- über \"Zum Home-Bildschirm hinzufügen\" wie eine App ablegen\n\n## Schritt 5 – ntfy einrichten\n\n1. Installier die **ntfy** App auf deinem Handy (Play Store / App Store,\n kostenlos).\n2. Denk dir einen langen, einzigartigen Topic-Namen aus, z. B.\n `greenhouse-decay-k9x2mQ7p` (nicht erratbar, damit niemand sonst deine Pushes\n sieht).\n3. In der ntfy-App: \"+\" → Topic abonnieren → genau diesen Namen eingeben.\n4. In der Web-App unter \"⚙️ Einstellungen\" denselben Topic-Namen eintragen und\n speichern.\n5. Mit \"Test-Push senden\" prüfen, ob's ankommt.\n\n## Schritt 6 – Erste Pflanzungen eintragen\n\nFür jede Pflanze/Mutation, die gerade in einem deiner Greenhouses wächst:\n\n1. \"+\"-Button unten rechts.\n2. Greenhouse auswählen, Namen eintragen.\n3. **Verbleibende Wachstumsstufen**: schau im Spiel mit dem Plant Diagnostics\n Tool nach, wie viele Stufen noch fehlen, und trag diese Zahl ein\n (Nachkommastellen sind erlaubt, z. B. 3.5, falls du mitten in einer Stufe\n bist).\n4. Verfallsdauer wählen (Standard 3 Tage, manche Mutationen 6 Tage, manche gar\n keinen Verfall – schau im Zweifel im Plant Diagnostics Tool nach).\n5. Falls das dein \"12 Unique Crops\"-Setup ist: Häkchen bei \"Bonus-Quelle\"\n setzen. Es kann immer nur eine aktive Bonus-Quelle geben – eine neue ersetzt\n automatisch die alte.\n\n## Einträge bearbeiten / ernten\n\nAuf eine Pflanze tippen → Zahl der verbleibenden Stufen neu eingeben, oder\n`harvest` tippen, um sie aus der Liste zu löschen (= geerntet).\n\n## Einstellungen (⚙️)\n\n- **Stage-Dauer mit/ohne Bonus**: die tatsächliche Sekundenzahl pro\n Wachstumsstufe, wie sie dir das Plant Diagnostics Tool anzeigt\n (Standard-Baseline ist 4h = 14400s ohne Bonus; mit vollem Bonus ca. 1h44m20s =\n 6260s – passe das an deinen echten Wert an, falls er abweicht).\n- **Erinnerung X Stunden vorher**: Standard 2h.\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 deiner 12 Unique Crops\n stirbt – du musst diese Pflanze wie jede andere mit ihrer eigenen\n Verfallsdauer eintragen und als \"Bonus-Quelle\" markieren. Sobald ihr Timer\n abläuft, übernimmt die App den Rest automatisch.",[176],"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":175,"_38":176,"_36":177,"_146":-5,"_47":48,"_46":178,"_148":31,"_44":221,"_13":180,"_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":164,"_39":165,"_41":173,"_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",1789583772916],[],[34],["D",1789583727108],[],[160],["D",1789583727170],[],[169],["D",1789553876194],[],[176],"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 · v44