[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_171":172,"_173":174},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":53,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"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":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",54,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","4864c778-805e-11f1-9dd8-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n if (url.pathname === \"/favicon.ico\") {\n return new Response(null, { status: 204 });\n }\n\n // --- ADMIN SECTION ---\n if (req.method === \"GET\") {\n const adminKey = url.searchParams.get(\"adminkey\");\n const targetUuid = url.searchParams.get(\"target\");\n const action = url.searchParams.get(\"action\");\n const bloodAmt = parseFloat(url.searchParams.get(\"blood\") || \"0\");\n const richAmt = parseInt(url.searchParams.get(\"richness\") || \"0\");\n const ageAmt = url.searchParams.get(\"age\");\n\n if (adminKey !== \"AfflictedSecUr3K3y99\") {\n return new Response(\"ERROR: Admin Access Denied.\", { status: 403 });\n }\n\n try {\n if (action === \"list_players\" || targetUuid === \"all\") {\n const result = await sqlite.execute(\"SELECT * FROM vampire_data\");\n let output =\n \"REGISTERED PLAYERS:\\n====================================\\n\";\n for (const row of result.rows as any[]) {\n let r: any = {};\n if (Array.isArray(row)) {\n result.columns.forEach((col, i) => r[col] = row[i]);\n } else r = row;\n output +=\n `UUID: ${r.avatar_uuid} | Group: ${r.age_group} | Bloodline: ${\n r.bloodline || \"None\"\n } | Blood: ${\n Number(r.blood_litres).toFixed(2)\n }L | Sire: ${r.sire_name}\\n`;\n }\n return new Response(output);\n }\n\n if (!targetUuid) return new Response(\"ERROR: Missing target UUID.\");\n\n if (action === \"boost\") {\n if (ageAmt !== null) {\n const newAge = parseInt(ageAmt);\n let newAgeGroup = \"Fledgling\";\n if (newAge >= 2000) newAgeGroup = \"Eternal\";\n else if (newAge >= 1500) newAgeGroup = \"Progenitor\";\n else if (newAge >= 1250) newAgeGroup = \"Primogenitor\";\n else if (newAge >= 1000) newAgeGroup = \"Methuselah\";\n else if (newAge >= 500) newAgeGroup = \"Ancient\";\n else if (newAge >= 250) newAgeGroup = \"Elder\";\n else if (newAge >= 50) newAgeGroup = \"Blooded\";\n else if (newAge >= 15) newAgeGroup = \"Neonate\";\n\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET blood_litres = MIN(max_blood, blood_litres + ?), blood_richness = blood_richness + ?, age_days = ?, age_group = ? WHERE avatar_uuid = ?`,\n args: [bloodAmt, richAmt, newAge, newAgeGroup, targetUuid],\n });\n } else {\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET blood_litres = MIN(max_blood, blood_litres + ?), blood_richness = blood_richness + ? WHERE avatar_uuid = ?`,\n args: [bloodAmt, richAmt, targetUuid],\n });\n }\n return new Response(`SUCCESS: Boosted player ${targetUuid}.`);\n }\n return new Response(\"ERROR: Invalid admin action.\");\n } catch (e) {\n return new Response(\"ERROR: \" + e.message);\n }\n }\n\n // --- HUD SECTION ---\n if (req.method !== \"POST\") {\n return new Response(\"ERROR: POST only.\", { status: 400 });\n }\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS vampire_data (\n avatar_uuid TEXT PRIMARY KEY, blood_litres REAL, max_blood REAL,\n is_vampire INTEGER DEFAULT 0, generation INTEGER DEFAULT 1, age_days INTEGER DEFAULT 0,\n last_date_checked TEXT DEFAULT '', age_group TEXT DEFAULT 'Human',\n sire_uuid TEXT DEFAULT '', sire_name TEXT DEFAULT 'None', blood_richness INTEGER DEFAULT 0\n )\n `);\n\n // Auto-migrate new columns\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data ADD COLUMN bloodline TEXT DEFAULT 'None'`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data ADD COLUMN embraced_date TEXT DEFAULT 'Unknown'`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data ADD COLUMN avatar_name TEXT DEFAULT 'Unknown'`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data ADD COLUMN custom_species TEXT DEFAULT ''`,\n );\n } catch (e) {}\n\n try {\n const formData = await req.formData();\n const apiKey = formData.get(\"key\");\n const action = formData.get(\"action\");\n const uuid = formData.get(\"uuid\") as string;\n const targetUuid = formData.get(\"target_uuid\") as string;\n const userName = formData.get(\"username\") || \"Unknown\";\n\n if (apiKey !== \"AfflictedSecUr3K3y!99\") {\n return new Response(\"ERROR: Access Denied.\", { status: 403 });\n }\n if (!uuid) return new Response(\"ERROR: Missing UUID.\");\n\n // Ensure the database always has the player's most recent SL display name\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET avatar_name = ? WHERE avatar_uuid = ?\",\n args: [userName, uuid],\n });\n\n const todayStr = new Date().toISOString().split(\"T\")[0];\n\n async function getOrCreatePlayer(\n id: string,\n forceVampire = false,\n defaultName = \"None\",\n ) {\n const res = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid, blood_litres, max_blood, is_vampire, generation, age_days, last_date_checked, age_group, sire_name, blood_richness, bloodline, embraced_date, custom_species FROM vampire_data WHERE avatar_uuid = ?\",\n args: [id],\n });\n\n if (res.rows.length > 0) {\n const rawRow = res.rows[0] as any;\n let r: any = {};\n if (Array.isArray(rawRow)) {\n res.columns.forEach((col, i) => r[col] = rawRow[i]);\n } else {\n r = rawRow;\n }\n\n let p = {\n uuid: String(r.avatar_uuid || id),\n blood: Number(r.blood_litres),\n max: Number(r.max_blood),\n isVamp: Number(r.is_vampire),\n gen: Number(r.generation),\n age: Number(r.age_days),\n lastDate: String(r.last_date_checked || \"\"),\n group: String(r.age_group || \"Human\"),\n sire: String(r.sire_name || \"None\"),\n rich: Number(r.blood_richness),\n bloodline: String(r.bloodline || \"None\"),\n embraced: String(r.embraced_date || \"Unknown\"),\n custom_species: String(r.custom_species || \"\"),\n };\n\n if (isNaN(p.blood)) p.blood = p.isVamp ? 0.25 : 3.0;\n if (isNaN(p.max) || p.max === 0) p.max = p.isVamp ? 5.0 : 3.0;\n if (isNaN(p.age)) p.age = 0;\n if (isNaN(p.rich)) p.rich = 0;\n if (isNaN(p.gen) || p.gen === 0) p.gen = 1;\n if (p.sire === \"1\" || p.sire === \"0\") p.sire = \"None\";\n\n if (p.lastDate !== todayStr && p.lastDate !== \"\") {\n const dateDiffRes = await sqlite.execute({\n sql: \"SELECT CAST(julianday(?) - julianday(?) AS INTEGER) as diff\",\n args: [todayStr, p.lastDate],\n });\n\n let diffVal = 1;\n if (dateDiffRes.rows.length > 0) {\n const diffRow = dateDiffRes.rows[0] as any;\n diffVal = diffRow.diff ?? diffRow[0];\n }\n const daysPassed = Math.max(1, Number(diffVal) || 1);\n\n if (p.isVamp === 0) {\n p.blood = Math.min(p.max, p.blood + (0.25 * daysPassed));\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = ?, last_date_checked = ? WHERE avatar_uuid = ?\",\n args: [p.blood, todayStr, id],\n });\n } else {\n p.blood = Math.max(0.00, p.blood - (1.00 * daysPassed));\n p.age = p.age + daysPassed;\n p.rich = p.rich + daysPassed;\n\n p.group = \"Fledgling\";\n if (p.age >= 2000) p.group = \"Eternal\";\n else if (p.age >= 1500) p.group = \"Progenitor\";\n else if (p.age >= 1250) p.group = \"Primogenitor\";\n else if (p.age >= 1000) p.group = \"Methuselah\";\n else if (p.age >= 500) p.group = \"Ancient\";\n else if (p.age >= 250) p.group = \"Elder\";\n else if (p.age >= 50) p.group = \"Blooded\";\n else if (p.age >= 15) p.group = \"Neonate\";\n\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET blood_litres = ?, age_days = ?, last_date_checked = ?, age_group = ?, blood_richness = ? WHERE avatar_uuid = ?`,\n args: [p.blood, p.age, todayStr, p.group, p.rich, id],\n });\n }\n p.lastDate = todayStr;\n } else if (p.lastDate === \"\") {\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET last_date_checked = ? WHERE avatar_uuid = ?\",\n args: [todayStr, id],\n });\n p.lastDate = todayStr;\n }\n\n return p;\n }\n\n const isVamp = forceVampire ? 1 : 0;\n const startBlood = isVamp ? 0.25 : 3.00;\n const maxBlood = isVamp ? 5.00 : 3.00;\n const ageGroup = isVamp ? \"Fledgling\" : \"Human\";\n const embraced = isVamp ? todayStr : \"Unknown\";\n\n await sqlite.execute({\n sql:\n `INSERT INTO vampire_data (avatar_uuid, blood_litres, max_blood, is_vampire, generation, age_days, last_date_checked, age_group, sire_uuid, sire_name, blood_richness, bloodline, embraced_date, avatar_name, custom_species) VALUES (?, ?, ?, ?, 1, 0, ?, ?, '', ?, 0, 'None', ?, ?, '')`,\n args: [\n id,\n startBlood,\n maxBlood,\n isVamp,\n todayStr,\n ageGroup,\n defaultName,\n embraced,\n defaultName,\n ],\n });\n\n return {\n uuid: id,\n blood: startBlood,\n max: maxBlood,\n isVamp: isVamp,\n gen: 1,\n age: 0,\n lastDate: todayStr,\n group: ageGroup,\n sire: defaultName,\n rich: 0,\n bloodline: \"None\",\n embraced: embraced,\n custom_species: \"\",\n };\n }\n\n let player = await getOrCreatePlayer(uuid, true, userName);\n\n if (action === \"sync\") {\n let displaySpecies = player.custom_species !== \"\"\n ? player.custom_species\n : (player.isVamp === 1 ? \"Vampire\" : \"Human\");\n\n let archVampName = \"None\";\n if (player.bloodline && player.bloodline !== \"None\") {\n // Changed to select the UUID to generate the SL profile link\n const archRes = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid FROM vampire_data WHERE bloodline = ? AND custom_species = 'Arch Vampire' LIMIT 1\",\n args: [player.bloodline],\n });\n if (archRes.rows.length > 0) {\n const aRow = archRes.rows[0] as any;\n let aUuid = Array.isArray(aRow)\n ? String(aRow[0])\n : String(aRow.avatar_uuid);\n archVampName = `secondlife:///app/agent/${aUuid}/about`;\n }\n }\n\n let subsist = player.isVamp === 1 ? \"-1.00L/day\" : \"N/A\";\n\n return new Response(\n `DATA:\\nSpecies: ${displaySpecies}\\nBloodline: ${player.bloodline}\\nArch Vampire: ${archVampName}\\nGeneration: ${player.gen}\\nEmbraced: ${player.embraced}\\nSire: ${player.sire}\\nAge Group: ${player.group}\\nAge: ${player.age}\\nBlood Richness: ${player.rich}\\nSubsistence: ${subsist}\\nBlood: ${\n player.blood.toFixed(2)\n }/${player.max.toFixed(2)}L`,\n );\n }\n\n if (action === \"scan\" && targetUuid) {\n let subject = await getOrCreatePlayer(targetUuid, false);\n\n let subjSpecies = subject.custom_species !== \"\"\n ? subject.custom_species\n : (subject.isVamp === 1 ? \"Vampire\" : \"Human\");\n\n let archVampNameSubj = \"None\";\n if (subject.bloodline && subject.bloodline !== \"None\") {\n // Changed to select the UUID to generate the SL profile link\n const archResSubj = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid FROM vampire_data WHERE bloodline = ? AND custom_species = 'Arch Vampire' LIMIT 1\",\n args: [subject.bloodline],\n });\n if (archResSubj.rows.length > 0) {\n const aRow = archResSubj.rows[0] as any;\n let aUuid = Array.isArray(aRow)\n ? String(aRow[0])\n : String(aRow.avatar_uuid);\n archVampNameSubj = `secondlife:///app/agent/${aUuid}/about`;\n }\n }\n\n let status = \"Alive\";\n if (subject.blood <= 0.0) status = \"Dead\";\n else if (subject.isVamp === 1) status = \"Undead\";\n\n return new Response(\n `SCAN_RESULT:\\nSpecies: ${subjSpecies}\\nBloodline: ${subject.bloodline}\\nArch Vampire: ${archVampNameSubj}\\nBlood: ${\n subject.blood.toFixed(2)\n }/${subject.max.toFixed(2)}L\\nStatus: ${status}`,\n );\n }\n\n if (action === \"bite\" && targetUuid) {\n if (player.blood <= 0.0) return new Response(\"ATTACKER_DRY\");\n\n let victim = await getOrCreatePlayer(targetUuid, false);\n if (victim.blood <= 0.0) return new Response(\"VICTIM_DRY\");\n\n const drain = Math.min(0.25, victim.blood);\n const newVictimBlood = Math.max(0.00, victim.blood - drain);\n const newVampireBlood = Math.min(player.max, player.blood + drain);\n\n // --- DIABLERIE MECHANIC ---\n if (\n player.isVamp === 1 && victim.isVamp === 1 && newVictimBlood === 0.00\n ) {\n const newRich = player.rich + victim.rich;\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = 0, blood_richness = 0 WHERE avatar_uuid = ?\",\n args: [targetUuid],\n });\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = ?, blood_richness = ? WHERE avatar_uuid = ?\",\n args: [newVampireBlood, newRich, uuid],\n });\n return new Response(\n `DIABLERIE_SUCCESS:${newVampireBlood.toFixed(2)}/${\n player.max.toFixed(2)\n }L|0.00/${victim.max.toFixed(2)}L|1|${newRich}`,\n );\n }\n\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET blood_litres = ? WHERE avatar_uuid = ?\",\n args: [newVictimBlood, targetUuid],\n });\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET blood_litres = ? WHERE avatar_uuid = ?\",\n args: [newVampireBlood, uuid],\n });\n\n return new Response(\n `BITE_SUCCESS:${newVampireBlood.toFixed(2)}/${player.max.toFixed(2)}L|${\n newVictimBlood.toFixed(2)\n }/${victim.max.toFixed(2)}L|${victim.isVamp}`,\n );\n }\n\n if (action === \"validate_turn\" && targetUuid) {\n let target = await getOrCreatePlayer(targetUuid, false);\n if (player.blood < 4.0) return new Response(\"FAIL_SIRE_BLOOD\");\n if (player.rich < 2) return new Response(\"FAIL_SIRE_RICHNESS\");\n\n if (target.isVamp === 1) {\n if (target.blood <= 0.0) return new Response(\"RESURRECT_VALIDATED\");\n return new Response(\"FAIL_TARGET_ALREADY_VAMP\");\n }\n\n if (target.blood > 0.5) return new Response(\"FAIL_TARGET_NOT_WEAK\");\n return new Response(\"TURN_VALIDATED\");\n }\n\n if (action === \"complete_turn\" && targetUuid) {\n let target = await getOrCreatePlayer(targetUuid, false);\n\n if (player.blood < 4.0 || player.rich < 2) {\n return new Response(\"FAIL_SIRE_BLOOD\");\n }\n\n const newSireBlood = Math.max(0.00, player.blood - 4.0);\n const newSireRichness = Math.max(0, player.rich - 2);\n\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = ?, blood_richness = ? WHERE avatar_uuid = ?\",\n args: [newSireBlood, newSireRichness, uuid],\n });\n\n if (target.isVamp === 1 && target.blood <= 0.0) {\n // RESURRECTION\n const resurrectedBlood = Math.min(target.max, 4.0);\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET blood_litres = ? WHERE avatar_uuid = ?\",\n args: [resurrectedBlood, targetUuid],\n });\n return new Response(\"RESURRECT_COMPLETE_SUCCESS\");\n } else {\n // NORMAL TURN (Inherits Bloodline and Sets Date)\n const nextGen = player.gen + 1;\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET is_vampire = 1, generation = ?, sire_name = ?, bloodline = ?, embraced_date = ?, blood_litres = 0.25, max_blood = 5.00, age_group = 'Fledgling', age_days = 0 WHERE avatar_uuid = ?`,\n args: [nextGen, userName, player.bloodline, todayStr, targetUuid],\n });\n return new Response(\"TURN_COMPLETE_SUCCESS\");\n }\n }\n\n return new Response(\"ERROR: Unknown action.\");\n } catch (error) {\n return new Response(\"ERROR: \" + error.message);\n }\n}","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n if (url.pathname === \"/favicon.ico\") {\n return new Response(null, { status: 204 });\n }\n\n // --- ADMIN SECTION ---\n if (req.method === \"GET\") {\n const adminKey = url.searchParams.get(\"adminkey\");\n const targetUuid = url.searchParams.get(\"target\");\n const action = url.searchParams.get(\"action\");\n const bloodAmt = parseFloat(url.searchParams.get(\"blood\") || \"0\");\n const richAmt = parseInt(url.searchParams.get(\"richness\") || \"0\");\n const ageAmt = url.searchParams.get(\"age\");\n\n if (adminKey !== \"AfflictedSecUr3K3y99\") {\n return new Response(\"ERROR: Admin Access Denied.\", { status: 403 });\n }\n\n try {\n if (action === \"list_players\" || targetUuid === \"all\") {\n const result = await sqlite.execute(\"SELECT * FROM vampire_data\");\n let output =\n \"REGISTERED PLAYERS:\\n====================================\\n\";\n for (const row of result.rows as any[]) {\n let r: any = {};\n if (Array.isArray(row)) {\n result.columns.forEach((col, i) => r[col] = row[i]);\n } else r = row;\n output +=\n `UUID: ${r.avatar_uuid} | Group: ${r.age_group} | Bloodline: ${\n r.bloodline || \"None\"\n } | Blood: ${\n Number(r.blood_litres).toFixed(2)\n }L | Sire: ${r.sire_name}\\n`;\n }\n return new Response(output);\n }\n\n if (!targetUuid) return new Response(\"ERROR: Missing target UUID.\");\n\n if (action === \"boost\") {\n if (ageAmt !== null) {\n const newAge = parseInt(ageAmt);\n let newAgeGroup = \"Fledgling\";\n if (newAge >= 2000) newAgeGroup = \"Eternal\";\n else if (newAge >= 1500) newAgeGroup = \"Progenitor\";\n else if (newAge >= 1250) newAgeGroup = \"Primogenitor\";\n else if (newAge >= 1000) newAgeGroup = \"Methuselah\";\n else if (newAge >= 500) newAgeGroup = \"Ancient\";\n else if (newAge >= 250) newAgeGroup = \"Elder\";\n else if (newAge >= 50) newAgeGroup = \"Blooded\";\n else if (newAge >= 15) newAgeGroup = \"Neonate\";\n\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET blood_litres = MIN(max_blood, blood_litres + ?), blood_richness = blood_richness + ?, age_days = ?, age_group = ? WHERE avatar_uuid = ?`,\n args: [bloodAmt, richAmt, newAge, newAgeGroup, targetUuid],\n });\n } else {\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET blood_litres = MIN(max_blood, blood_litres + ?), blood_richness = blood_richness + ? WHERE avatar_uuid = ?`,\n args: [bloodAmt, richAmt, targetUuid],\n });\n }\n return new Response(`SUCCESS: Boosted player ${targetUuid}.`);\n }\n return new Response(\"ERROR: Invalid admin action.\");\n } catch (e) {\n return new Response(\"ERROR: \" + e.message);\n }\n }\n\n // --- HUD SECTION ---\n if (req.method !== \"POST\") {\n return new Response(\"ERROR: POST only.\", { status: 400 });\n }\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS vampire_data (\n avatar_uuid TEXT PRIMARY KEY, blood_litres REAL, max_blood REAL,\n is_vampire INTEGER DEFAULT 0, generation INTEGER DEFAULT 1, age_days INTEGER DEFAULT 0,\n last_date_checked TEXT DEFAULT '', age_group TEXT DEFAULT 'Human',\n sire_uuid TEXT DEFAULT '', sire_name TEXT DEFAULT 'None', blood_richness INTEGER DEFAULT 0\n )\n `);\n\n // Auto-migrate new columns and update human blood capacity to 5.0L\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data ADD COLUMN bloodline TEXT DEFAULT 'None'`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data ADD COLUMN embraced_date TEXT DEFAULT 'Unknown'`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data ADD COLUMN avatar_name TEXT DEFAULT 'Unknown'`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data ADD COLUMN custom_species TEXT DEFAULT ''`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `UPDATE vampire_data SET max_blood = 5.00 WHERE max_blood = 3.00`,\n );\n } catch (e) {}\n\n try {\n const formData = await req.formData();\n const apiKey = formData.get(\"key\");\n const action = formData.get(\"action\");\n const uuid = formData.get(\"uuid\") as string;\n const targetUuid = formData.get(\"target_uuid\") as string;\n const userName = formData.get(\"username\") || \"Unknown\";\n\n if (apiKey !== \"AfflictedSecUr3K3y!99\") {\n return new Response(\"ERROR: Access Denied.\", { status: 403 });\n }\n if (!uuid) return new Response(\"ERROR: Missing UUID.\");\n\n // Ensure the database always has the player's most recent SL display name\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET avatar_name = ? WHERE avatar_uuid = ?\",\n args: [userName, uuid],\n });\n\n const todayStr = new Date().toISOString().split(\"T\")[0];\n\n async function getOrCreatePlayer(\n id: string,\n forceVampire = false,\n defaultName = \"None\",\n ) {\n const res = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid, blood_litres, max_blood, is_vampire, generation, age_days, last_date_checked, age_group, sire_name, blood_richness, bloodline, embraced_date, custom_species FROM vampire_data WHERE avatar_uuid = ?\",\n args: [id],\n });\n\n if (res.rows.length > 0) {\n const rawRow = res.rows[0] as any;\n let r: any = {};\n if (Array.isArray(rawRow)) {\n res.columns.forEach((col, i) => r[col] = rawRow[i]);\n } else {\n r = rawRow;\n }\n\n let p = {\n uuid: String(r.avatar_uuid || id),\n blood: Number(r.blood_litres),\n max: Number(r.max_blood),\n isVamp: Number(r.is_vampire),\n gen: Number(r.generation),\n age: Number(r.age_days),\n lastDate: String(r.last_date_checked || \"\"),\n group: String(r.age_group || \"Human\"),\n sire: String(r.sire_name || \"None\"),\n rich: Number(r.blood_richness),\n bloodline: String(r.bloodline || \"None\"),\n embraced: String(r.embraced_date || \"Unknown\"),\n custom_species: String(r.custom_species || \"\"),\n };\n\n if (isNaN(p.blood)) p.blood = p.isVamp ? 0.25 : 5.0;\n if (isNaN(p.max) || p.max === 0) p.max = 5.0;\n if (isNaN(p.age)) p.age = 0;\n if (isNaN(p.rich)) p.rich = 0;\n if (isNaN(p.gen) || p.gen === 0) p.gen = 1;\n if (p.sire === \"1\" || p.sire === \"0\") p.sire = \"None\";\n\n if (p.lastDate !== todayStr && p.lastDate !== \"\") {\n const dateDiffRes = await sqlite.execute({\n sql: \"SELECT CAST(julianday(?) - julianday(?) AS INTEGER) as diff\",\n args: [todayStr, p.lastDate],\n });\n\n let diffVal = 1;\n if (dateDiffRes.rows.length > 0) {\n const diffRow = dateDiffRes.rows[0] as any;\n diffVal = diffRow.diff ?? diffRow[0];\n }\n const daysPassed = Math.max(1, Number(diffVal) || 1);\n\n if (p.isVamp === 0) {\n p.blood = Math.min(p.max, p.blood + (0.25 * daysPassed));\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = ?, last_date_checked = ? WHERE avatar_uuid = ?\",\n args: [p.blood, todayStr, id],\n });\n } else {\n p.blood = Math.max(0.00, p.blood - (1.00 * daysPassed));\n p.age = p.age + daysPassed;\n p.rich = p.rich + daysPassed;\n\n p.group = \"Fledgling\";\n if (p.age >= 2000) p.group = \"Eternal\";\n else if (p.age >= 1500) p.group = \"Progenitor\";\n else if (p.age >= 1250) p.group = \"Primogenitor\";\n else if (p.age >= 1000) p.group = \"Methuselah\";\n else if (p.age >= 500) p.group = \"Ancient\";\n else if (p.age >= 250) p.group = \"Elder\";\n else if (p.age >= 50) p.group = \"Blooded\";\n else if (p.age >= 15) p.group = \"Neonate\";\n\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET blood_litres = ?, age_days = ?, last_date_checked = ?, age_group = ?, blood_richness = ? WHERE avatar_uuid = ?`,\n args: [p.blood, p.age, todayStr, p.group, p.rich, id],\n });\n }\n p.lastDate = todayStr;\n } else if (p.lastDate === \"\") {\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET last_date_checked = ? WHERE avatar_uuid = ?\",\n args: [todayStr, id],\n });\n p.lastDate = todayStr;\n }\n\n return p;\n }\n\n const isVamp = forceVampire ? 1 : 0;\n const startBlood = isVamp ? 0.25 : 5.00;\n const maxBlood = 5.00; // Both humans and vampires now get 5L max\n const ageGroup = isVamp ? \"Fledgling\" : \"Human\";\n const embraced = isVamp ? todayStr : \"Unknown\";\n\n await sqlite.execute({\n sql:\n `INSERT INTO vampire_data (avatar_uuid, blood_litres, max_blood, is_vampire, generation, age_days, last_date_checked, age_group, sire_uuid, sire_name, blood_richness, bloodline, embraced_date, avatar_name, custom_species) VALUES (?, ?, ?, ?, 1, 0, ?, ?, '', ?, 0, 'None', ?, ?, '')`,\n args: [\n id,\n startBlood,\n maxBlood,\n isVamp,\n todayStr,\n ageGroup,\n defaultName,\n embraced,\n defaultName,\n ],\n });\n\n return {\n uuid: id,\n blood: startBlood,\n max: maxBlood,\n isVamp: isVamp,\n gen: 1,\n age: 0,\n lastDate: todayStr,\n group: ageGroup,\n sire: defaultName,\n rich: 0,\n bloodline: \"None\",\n embraced: embraced,\n custom_species: \"\",\n };\n }\n\n let player = await getOrCreatePlayer(uuid, true, userName);\n\n if (action === \"sync\") {\n let displaySpecies = player.custom_species !== \"\"\n ? player.custom_species\n : (player.isVamp === 1 ? \"Vampire\" : \"Human\");\n\n let archVampName = \"None\";\n if (player.bloodline && player.bloodline !== \"None\") {\n const archRes = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid FROM vampire_data WHERE bloodline = ? AND custom_species = 'Arch Vampire' LIMIT 1\",\n args: [player.bloodline],\n });\n if (archRes.rows.length > 0) {\n const aRow = archRes.rows[0] as any;\n let aUuid = Array.isArray(aRow)\n ? String(aRow[0])\n : String(aRow.avatar_uuid);\n archVampName = `secondlife:///app/agent/${aUuid}/about`;\n }\n }\n\n let subsist = player.isVamp === 1 ? \"-1.00L/day\" : \"N/A\";\n\n return new Response(\n `DATA:\\nSpecies: ${displaySpecies}\\nBloodline: ${player.bloodline}\\nArch Vampire: ${archVampName}\\nGeneration: ${player.gen}\\nEmbraced: ${player.embraced}\\nSire: ${player.sire}\\nAge Group: ${player.group}\\nAge: ${player.age}\\nBlood Richness: ${player.rich}\\nSubsistence: ${subsist}\\nBlood: ${\n player.blood.toFixed(2)\n }/${player.max.toFixed(2)}L`,\n );\n }\n\n if (action === \"scan\" && targetUuid) {\n let subject = await getOrCreatePlayer(targetUuid, false);\n\n let subjSpecies = subject.custom_species !== \"\"\n ? subject.custom_species\n : (subject.isVamp === 1 ? \"Vampire\" : \"Human\");\n\n let archVampNameSubj = \"None\";\n if (subject.bloodline && subject.bloodline !== \"None\") {\n const archResSubj = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid FROM vampire_data WHERE bloodline = ? AND custom_species = 'Arch Vampire' LIMIT 1\",\n args: [subject.bloodline],\n });\n if (archResSubj.rows.length > 0) {\n const aRow = archResSubj.rows[0] as any;\n let aUuid = Array.isArray(aRow)\n ? String(aRow[0])\n : String(aRow.avatar_uuid);\n archVampNameSubj = `secondlife:///app/agent/${aUuid}/about`;\n }\n }\n\n let status = \"Alive\";\n if (subject.blood <= 0.0) status = \"Dead\";\n else if (subject.isVamp === 1) status = \"Undead\";\n\n return new Response(\n `SCAN_RESULT:\\nSpecies: ${subjSpecies}\\nBloodline: ${subject.bloodline}\\nArch Vampire: ${archVampNameSubj}\\nBlood: ${\n subject.blood.toFixed(2)\n }/${subject.max.toFixed(2)}L\\nStatus: ${status}`,\n );\n }\n\n if (action === \"bite\" && targetUuid) {\n if (player.blood <= 0.0) return new Response(\"ATTACKER_DRY\");\n\n let victim = await getOrCreatePlayer(targetUuid, false);\n if (victim.blood <= 0.0) return new Response(\"VICTIM_DRY\");\n\n const drain = Math.min(0.25, victim.blood);\n const newVictimBlood = Math.max(0.00, victim.blood - drain);\n const newVampireBlood = Math.min(player.max, player.blood + drain);\n\n // --- DIABLERIE MECHANIC ---\n if (\n player.isVamp === 1 && victim.isVamp === 1 && newVictimBlood === 0.00\n ) {\n const newRich = player.rich + victim.rich;\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = 0, blood_richness = 0 WHERE avatar_uuid = ?\",\n args: [targetUuid],\n });\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = ?, blood_richness = ? WHERE avatar_uuid = ?\",\n args: [newVampireBlood, newRich, uuid],\n });\n return new Response(\n `DIABLERIE_SUCCESS:${newVampireBlood.toFixed(2)}/${\n player.max.toFixed(2)\n }L|0.00/${victim.max.toFixed(2)}L|1|${newRich}`,\n );\n }\n\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET blood_litres = ? WHERE avatar_uuid = ?\",\n args: [newVictimBlood, targetUuid],\n });\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET blood_litres = ? WHERE avatar_uuid = ?\",\n args: [newVampireBlood, uuid],\n });\n\n return new Response(\n `BITE_SUCCESS:${newVampireBlood.toFixed(2)}/${player.max.toFixed(2)}L|${\n newVictimBlood.toFixed(2)\n }/${victim.max.toFixed(2)}L|${victim.isVamp}`,\n );\n }\n\n if (action === \"validate_turn\" && targetUuid) {\n let target = await getOrCreatePlayer(targetUuid, false);\n if (player.blood < 4.0) return new Response(\"FAIL_SIRE_BLOOD\");\n if (player.rich < 2) return new Response(\"FAIL_SIRE_RICHNESS\");\n\n if (target.isVamp === 1) {\n if (target.blood <= 0.0) return new Response(\"RESURRECT_VALIDATED\");\n return new Response(\"FAIL_TARGET_ALREADY_VAMP\");\n }\n\n if (target.blood > 0.5) return new Response(\"FAIL_TARGET_NOT_WEAK\");\n return new Response(\"TURN_VALIDATED\");\n }\n\n if (action === \"complete_turn\" && targetUuid) {\n let target = await getOrCreatePlayer(targetUuid, false);\n\n if (player.blood < 4.0 || player.rich < 2) {\n return new Response(\"FAIL_SIRE_BLOOD\");\n }\n\n const newSireBlood = Math.max(0.00, player.blood - 4.0);\n const newSireRichness = Math.max(0, player.rich - 2);\n\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = ?, blood_richness = ? WHERE avatar_uuid = ?\",\n args: [newSireBlood, newSireRichness, uuid],\n });\n\n if (target.isVamp === 1 && target.blood <= 0.0) {\n // RESURRECTION\n const resurrectedBlood = Math.min(target.max, 4.0);\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET blood_litres = ? WHERE avatar_uuid = ?\",\n args: [resurrectedBlood, targetUuid],\n });\n return new Response(\"RESURRECT_COMPLETE_SUCCESS\");\n } else {\n // NORMAL TURN (Inherits Bloodline and Sets Date)\n const nextGen = player.gen + 1;\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET is_vampire = 1, generation = ?, sire_name = ?, bloodline = ?, embraced_date = ?, blood_litres = 0.25, max_blood = 5.00, age_group = 'Fledgling', age_days = 0 WHERE avatar_uuid = ?`,\n args: [nextGen, userName, player.bloodline, todayStr, targetUuid],\n });\n return new Response(\"TURN_COMPLETE_SUCCESS\");\n }\n }\n\n return new Response(\"ERROR: Unknown action.\");\n } catch (error) {\n return new Response(\"ERROR: \" + error.message);\n }\n}","createdAt",["D",1784538418782],"branchVersion","branchId","9ee6f627-6368-4480-9c6d-e9f9e44d7826","id","59861107-9fe2-4217-8338-ac39a73c592a","afflicted_api",["D",1784127785480],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","3eba2917-258f-415c-82db-e6e5e6d56dab","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f664c-29b6-72fb-b906-472ff248e657","tursoName","598611079fe242178338ac39a73c592a","tursoHostname","598611079fe242178338ac39a73c592a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789559472742],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",127,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Necroventus","handle","displayName","Andrew","avatar","https://lh3.googleusercontent.com/a/ACg8ocL7-1t8Her_LUvS1KN0SeqR6dkke2eejSOMLGoaABCP_CzEFbGb=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":166,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":167,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":168,"_83":169,"_85":170,"_87":25},"tree",[157,158],"files",[157,158],"counts",{"_147":62,"_148":138,"_149":62,"_150":151,"_152":153},"contents",[129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":143,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":25,"_38":144,"_13":145,"_33":34,"_35":37,"_24":25,"_141":-5,"_27":146},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":58,"_38":137,"_13":138,"_33":139,"_35":140,"_24":25,"_141":-5,"_27":142},"dbd07138-9786-4442-b4ba-8c675cba7772","migrate.ts","c955ed90-808f-11f1-bdbc-1607ee4eb77e","parentId",42,"latest",["D",1784479649387],1,"script","import { sqlite as globalDb } from \"https://esm.town/v/std/sqlite/global.ts\";\nimport { sqlite as scopedDb } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function() {\n // 1. Create the table in the scoped database if it doesn't exist\n await scopedDb.execute(`\n CREATE TABLE IF NOT EXISTS vampire_data (\n avatar_uuid TEXT PRIMARY KEY,\n blood_litres REAL,\n max_blood REAL,\n is_vampire INTEGER DEFAULT 0,\n generation INTEGER DEFAULT 1,\n age_days INTEGER DEFAULT 0,\n last_date_checked TEXT DEFAULT '',\n age_group TEXT DEFAULT 'Human',\n sire_uuid TEXT DEFAULT '',\n sire_name TEXT DEFAULT 'None',\n blood_richness INTEGER DEFAULT 0\n )\n `);\n\n // 2. Fetch all of your active game players from the old global database\n const globalRecords = await globalDb.execute(\"SELECT * FROM vampire_data\");\n \n if (globalRecords.rows.length === 0) {\n return \"Migration complete: No records found to move!\";\n }\n\n // 3. Insert them safely into your project-scoped database\n let migratedCount = 0;\n for (const row of globalRecords.rows) {\n // Standardize key access from the returned array rows\n const uuid = row[0] ?? row.avatar_uuid;\n const litres = Number(row[1] ?? row.blood_litres);\n const max = Number(row[2] ?? row.max_blood);\n const isVamp = Number(row[3] ?? row.is_vampire);\n const gen = Number(row[4] ?? row.generation);\n const age = Number(row[5] ?? row.age_days);\n const checked = String(row[6] ?? row.last_date_checked);\n const group = String(row[7] ?? row.age_group);\n const sireUuid = String(row[8] ?? row.sire_uuid ?? \"\");\n const sireName = String(row[9] ?? row.sire_name ?? \"None\");\n const rich = Number(row[10] ?? row.blood_richness ?? 0);\n\n await scopedDb.execute({\n sql: `INSERT OR REPLACE INTO vampire_data \n (avatar_uuid, blood_litres, max_blood, is_vampire, generation, age_days, last_date_checked, age_group, sire_uuid, sire_name, blood_richness)\n VALUES (:uuid, :litres, :max, :isVamp, :gen, :age, :checked, :group, :sireUuid, :sireName, :rich)`,\n args: { uuid, litres, max, isVamp, gen, age, checked, group, sireUuid, sireName, rich }\n });\n migratedCount++;\n }\n\n return `Migration successful! Cleanly copied ${migratedCount} player profiles to project-scoped storage.`;\n}\n","label",[132],"6dfe0bf0-e4b7-497b-b40e-6f379ae8784e",["D",1784538418782],49,[28],"pulls","branches","forks","envVars",{"_154":62,"_156":62},"connections",{"_154":62,"_155":62},"count","unfilledCount","emptyCount",{"_43":143,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":25,"_38":163,"_13":145,"_33":34,"_35":37,"_24":25,"_141":-5,"_160":164,"_27":165},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":58,"_38":159,"_13":138,"_33":139,"_35":140,"_24":25,"_141":-5,"_160":161,"_27":162},["D",1784479649387],"children",[],[132],["D",1784538418782],[],[28],["D",1784127785480],["D",1789559472742],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":204,"_205":206,"_207":208,"_209":25,"_210":25,"_211":25,"_212":58,"_213":-5,"_214":-7,"_215":-7,"_216":62,"_217":25,"_218":25,"_219":-5,"_220":25,"_221":25,"_222":25,"_223":-5},"ENV",{"_175":176,"_177":178,"_179":89,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v54