[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_209":210,"_211":212},"routes/_app.x.$handle.$name",{"_101":100,"_32":45,"_110":91,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"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":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",25,"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","reminder.cron.ts","latestPath","fileId","b9a44596-b1b7-11f1-b638-1607ee4eb77e","name","fileType","script","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 ?? 2) * 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 } 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",1789554050055],"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=1789625363&sig=355196cd214a97735cf8fe08d9889f9b5727dfc7b68ee7c8859e318b1e5e1339","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",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},"branch",{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"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",{"_43":44,"_32":45,"_38":204,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":205,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":206,"_85":207,"_87":208,"_89":25},"tree",[183,184,185,186,187],"files",[183,184,185,186,187],"counts",{"_172":64,"_173":174,"_175":64,"_176":177,"_178":179},"contents",[132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":165,"_32":166,"_30":167,"_139":-5,"_41":42,"_40":168,"_141":25,"_38":169,"_13":149,"_33":20,"_35":170,"_24":25,"_145":-5,"_27":171},{"_43":159,"_32":160,"_30":161,"_139":-5,"_41":42,"_40":149,"_141":25,"_38":162,"_13":156,"_33":34,"_35":163,"_24":25,"_145":-5,"_27":164},{"_43":151,"_32":152,"_30":153,"_139":-5,"_41":42,"_40":154,"_141":25,"_38":155,"_13":156,"_33":34,"_35":157,"_24":25,"_145":-5,"_27":158},{"_43":147,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":25,"_38":148,"_13":149,"_33":34,"_35":37,"_24":25,"_145":-5,"_27":150},{"_43":137,"_32":138,"_30":58,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":142,"_13":143,"_33":34,"_35":144,"_24":25,"_145":-5,"_27":146},"eefb6541-2316-4c81-a222-6e8aaa80aa77","site.http.ts","parentId",17,"latest",["D",1789553848856],4,"import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nimport {\n currentStageDuration,\n estimateMaturesAt,\n liveStagesRemaining,\n migrate,\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\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 =\n (await sqlite.execute(\"SELECT * FROM settings WHERE id = 1\"))\n .rows[0] as any;\n const plants =\n (await sqlite.execute(\"SELECT * FROM plants ORDER BY plot, created_at\"))\n .rows as any[];\n const now = Date.now();\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 return json({ settings, plants: enriched, now });\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 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 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 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 // 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 =\n (await sqlite.execute(\"SELECT * FROM settings WHERE id = 1\"))\n .rows[0] as any;\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 =\n (await sqlite.execute(\"SELECT * FROM settings WHERE id = 1\"))\n .rows[0] as any;\n const { sendNtfy } = await import(\"./ntfy.ts\");\n await sendNtfy(\n settings.ntfy_topic,\n \"🧪 Test\",\n \"Wenn du das siehst, funktioniert ntfy!\",\n );\n return json({ ok: true });\n }\n\n // ---------- Frontend ----------\n\n if (url.pathname === \"/\" && req.method === \"GET\") {\n return new Response(HTML, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n }\n\n return json({ error: \"not found\" }, 404);\n}\n\nconst HTML = `\n\n\n\n\nGreenhouse Tracker\n\n\n\n\n

🌿 Greenhouse Tracker

Hypixel Skyblock · Garden · Greenhouse

\n\n

\n \n

\n\n\n\n

Neue Pflanzung

\n Greenhouse\n \n Name (Crop / Mutation)\n \n Verbleibende Wachstumsstufen (aus Plant Diagnostics Tool)\n \n Verfallsdauer nach dem Ausreifen\n \n

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

\n \n \n

\n\n

Einstellungen

\n ntfy.sh Topic (frei wählbarer, langer Name)\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`;","label",[138],"61b2e76e-70b6-4067-8268-d2b6fa180e20",["D",1789554050055],5,[28],"467f7bcd-927f-4d1a-a8e6-3e004909b991","ntfy.ts","990ff65e-b1b7-11f1-b9b8-1607ee4eb77e",8,["D",1789553806118],3,"/**\n * Schickt eine Push-Nachricht über ntfy.sh.\n * Wenn kein Topic hinterlegt ist, passiert einfach nichts (kein Fehler).\n */\nexport async function sendNtfy(\n topic: string,\n title: string,\n message: string,\n priority: 1 | 2 | 3 | 4 | 5 = 4,\n) {\n if (!topic) return;\n try {\n await fetch(`https://ntfy.sh/${encodeURIComponent(topic)}`, {\n method: \"POST\",\n headers: {\n \"Title\": title,\n \"Priority\": String(priority),\n \"Tags\": \"seedling\",\n },\n body: message,\n });\n } catch (err) {\n console.error(\"ntfy push fehlgeschlagen:\", err);\n }\n}\n",[152],"46c8d6d2-7c6c-4166-8a6c-9e4148732bf5","db.ts","9c058108-b1b7-11f1-b337-1607ee4eb77e",["D",1789553787489],"import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * Legt Tabellen an, falls sie noch nicht existieren.\n * Wird bei jedem Request/Cron-Lauf aufgerufen (\"lazy migrate\") -\n * ist billig, wenn die Tabellen schon existieren.\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 2\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 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)\n VALUES (1, 6260, 14400, 1, ?, '', 2)`,\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 {\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}",[160],"2fb5b303-7ad3-4463-8396-634ef582f2d5","README.md","dc4a03c4-b1b7-11f1-b337-1607ee4eb77e",23,["D",1789553876194],"# 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.",[166],"pulls","branches",1,"forks","envVars",{"_180":64,"_182":64},"connections",{"_180":64,"_181":64},"count","unfilledCount","emptyCount",{"_43":165,"_32":166,"_30":167,"_139":-5,"_41":42,"_40":168,"_141":25,"_38":201,"_13":149,"_33":20,"_35":170,"_24":25,"_145":-5,"_189":202,"_27":203},{"_43":159,"_32":160,"_30":161,"_139":-5,"_41":42,"_40":149,"_141":25,"_38":198,"_13":156,"_33":34,"_35":163,"_24":25,"_145":-5,"_189":199,"_27":200},{"_43":151,"_32":152,"_30":153,"_139":-5,"_41":42,"_40":154,"_141":25,"_38":195,"_13":156,"_33":34,"_35":157,"_24":25,"_145":-5,"_189":196,"_27":197},{"_43":147,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":25,"_38":192,"_13":149,"_33":34,"_35":37,"_24":25,"_145":-5,"_189":193,"_27":194},{"_43":137,"_32":138,"_30":58,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":188,"_13":143,"_33":34,"_35":144,"_24":25,"_145":-5,"_189":190,"_27":191},["D",1789553848856],"children",[],[138],["D",1789554050055],[],[28],["D",1789553806118],[],[152],["D",1789553787489],[],[160],["D",1789553876194],[],[166],["D",1789553752971],["D",1789554646443],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"ctx",{"_83":-5,"_129":242,"_243":244,"_245":246,"_247":25,"_248":25,"_249":25,"_250":60,"_251":-5,"_252":-7,"_253":-7,"_254":64,"_255":25,"_256":25,"_257":-5,"_258":25,"_259":25,"_260":25,"_261":-5},"ENV",{"_213":214,"_215":216,"_217":91,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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 · v25