[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_161":162,"_163":164},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_88":70,"_89":31,"_68":-7,"_90":-5,"_13":91,"_92":93,"_11":94,"_95":96,"_97":98,"_99":-5,"_100":-5,"_101":-5,"_102":26,"_103":104,"_105":38,"_106":-5,"_107":-5,"_108":109},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":62,"_63":64,"_65":66,"_67":26},"query","handle","Necroventus","id","59861107-9fe2-4217-8338-ac39a73c592a","name","afflicted_api","createdAt",["D",1784127785480],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","","imageUrl","userId","3eba2917-258f-415c-82db-e6e5e6d56dab","pinnedFileId","4864c778-805e-11f1-9dd8-1607ee4eb77e","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",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_16":17,"_87":83},"org",{"_16":17,"_80":81,"_82":83,"_33":34,"_84":85,"_86":26},"branch",{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"isOwned","version",127,"main","9ee6f627-6368-4480-9c6d-e9f9e44d7826","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Andrew","avatar","https://lh3.googleusercontent.com/a/ACg8ocL7-1t8Her_LUvS1KN0SeqR6dkke2eejSOMLGoaABCP_CzEFbGb=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","path","adoptOrgId",{"_18":19,"_20":21,"_22":156,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_49":157,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":158,"_63":159,"_65":160,"_67":26},"tree",[147,148],[147,148],"counts",{"_137":42,"_138":122,"_139":42,"_140":141,"_142":143},"contents",[110,111],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_18":130,"_20":131,"_114":36,"_116":-5,"_117":71,"_118":69,"_120":38,"_22":132,"_68":133,"_123":134,"_125":135,"_127":26,"_128":-5,"_89":136},{"_18":112,"_20":113,"_114":115,"_116":-5,"_117":71,"_118":119,"_120":38,"_22":121,"_68":122,"_123":124,"_125":126,"_127":26,"_128":-5,"_89":129},"dbd07138-9786-4442-b4ba-8c675cba7772","migrate.ts","fileId","c955ed90-808f-11f1-bdbc-1607ee4eb77e","parentId","branchId","branchVersion",42,"latest",["D",1784479649387],1,"fileType","script","content","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","deleted","label",[113],"518f66f7-0b3e-44ef-b864-3cd31c258806","main.ts",["D",1787044866299],122,"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function (req: Request): Promise {\n const corsHeaders = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"POST, GET, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n };\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: corsHeaders });\n }\n const url = new URL(req.url);\n if (url.pathname === \"/favicon.ico\") {\n return new Response(null, { status: 204, headers: corsHeaders });\n }\n\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 = parseFloat(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.\", {\n status: 403,\n headers: corsHeaders,\n });\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 += `UUID: ${r.avatar_uuid} | Species: ${\n r.custom_species || \"Standard\"\n } | Group: ${r.age_group} | Bloodline: ${\n r.bloodline || \"None\"\n } | Blood: ${Number(r.blood_litres).toFixed(2)}L | Mana: ${\n Number(r.mana || 10).toFixed(1)\n } | Sire: ${r.sire_name} | Coven: ${r.house || \"Outcast\"}\\n`;\n }\n return new Response(output, { headers: corsHeaders });\n }\n\n if (!targetUuid) {\n return new Response(\"ERROR: Missing target UUID.\", {\n headers: corsHeaders,\n });\n }\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 headers: corsHeaders,\n });\n }\n return new Response(\"ERROR: Invalid admin action.\", {\n headers: corsHeaders,\n });\n } catch (e) {\n return new Response(\"ERROR: \" + e.message, { headers: corsHeaders });\n }\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"ERROR: POST only.\", {\n status: 400,\n headers: corsHeaders,\n });\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 REAL DEFAULT 0\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS system_config (\n key_name TEXT PRIMARY KEY, \n key_value TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS peace_zones (\n region TEXT PRIMARY KEY,\n pos_x REAL, pos_y REAL, pos_z REAL,\n radius REAL,\n expiration INTEGER,\n creator_name TEXT\n )\n `);\n\n const columns = [\n \"bloodline TEXT DEFAULT 'None'\",\n \"embraced_date TEXT DEFAULT 'Unknown'\",\n \"avatar_name TEXT DEFAULT 'Unknown'\",\n \"custom_species TEXT DEFAULT ''\",\n \"house TEXT DEFAULT 'Outcast'\",\n \"house_title TEXT DEFAULT ''\",\n \"loyalty_uuid TEXT DEFAULT ''\",\n \"killer_name TEXT DEFAULT ''\",\n \"death_date TEXT DEFAULT ''\",\n \"killer_uuid TEXT DEFAULT ''\",\n \"death_message TEXT DEFAULT ''\",\n \"coffin_count INTEGER DEFAULT 0\",\n \"coffin_date TEXT DEFAULT ''\",\n \"web_password TEXT DEFAULT ''\",\n \"kingdom TEXT DEFAULT 'Unbound'\",\n \"kingdom_title TEXT DEFAULT ''\",\n \"kingdom_loyalty TEXT DEFAULT ''\",\n \"mana REAL DEFAULT 10.0\",\n \"max_mana REAL DEFAULT 10.0\",\n ];\n\n for (const col of columns) {\n try {\n await sqlite.execute(`ALTER TABLE vampire_data ADD COLUMN ${col}`);\n } catch (e) {}\n }\n\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data RENAME COLUMN empire TO kingdom`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data RENAME COLUMN empire_title TO kingdom_title`,\n );\n } catch (e) {}\n try {\n await sqlite.execute(\n `ALTER TABLE vampire_data RENAME COLUMN empire_loyalty TO kingdom_loyalty`,\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 let getParam: (k: string) => any;\n const contentType = req.headers.get(\"content-type\") || \"\";\n\n if (contentType.includes(\"application/json\")) {\n const bodyJson = await req.json();\n getParam = (k: string) => bodyJson[k];\n } else {\n const bodyText = await req.text();\n const searchParams = new URLSearchParams(bodyText);\n getParam = (k: string) => searchParams.get(k);\n }\n\n const apiKey = getParam(\"key\") as string;\n const action = getParam(\"action\") as string;\n\n if (apiKey !== \"AfflictedSecUr3K3y!99\") {\n return new Response(\n JSON.stringify({ success: false, error: \"Access Denied.\" }),\n {\n status: 403,\n headers: { ...corsHeaders, \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n if (action === \"web_login\") {\n const loginId = getParam(\"login_id\") as string || \"\";\n const loginPass = getParam(\"password\") as string || \"\";\n if (!loginId.trim() || !loginPass.trim()) {\n return new Response(\n JSON.stringify({ success: false, error: \"Missing credentials\" }),\n { headers: { ...corsHeaders, \"Content-Type\": \"application/json\" } },\n );\n }\n const res = await sqlite.execute({\n sql:\n \"SELECT * FROM vampire_data WHERE (avatar_name COLLATE NOCASE = ? OR avatar_uuid = ?) AND web_password = ?\",\n args: [loginId.trim(), loginId.trim(), loginPass.trim()],\n });\n if (res.rows.length > 0) {\n let r: any = {};\n const rawRow = res.rows[0];\n if (Array.isArray(rawRow)) {\n res.columns.forEach((col, i) => r[col] = rawRow[i]);\n } else r = rawRow;\n return new Response(JSON.stringify({ success: true, profile: r }), {\n headers: { ...corsHeaders, \"Content-Type\": \"application/json\" },\n });\n } else {return new Response(\n JSON.stringify({\n success: false,\n error: \"Invalid username or password\",\n }),\n { headers: { ...corsHeaders, \"Content-Type\": \"application/json\" } },\n );}\n }\n\n const uuid = getParam(\"uuid\") as string;\n const targetUuid = getParam(\"target_uuid\") as string;\n const userName = getParam(\"username\") as string || \"Unknown\";\n const hudVersion = parseFloat((getParam(\"version\") as string) || \"1.5\");\n const regionName = getParam(\"region\") as string || \"Unknown\";\n\n if (\n !uuid &&\n ![\"register_server\", \"get_vampire_uuids\", \"deliver_hud\", \"check_peace\"]\n .includes(action)\n ) {\n return new Response(\"ERROR: Missing UUID.\", { headers: corsHeaders });\n }\n\n if (action === \"set_peace\") {\n const px = parseFloat(getParam(\"px\") as string);\n const py = parseFloat(getParam(\"py\") as string);\n const pz = parseFloat(getParam(\"pz\") as string);\n const rad = parseFloat(getParam(\"radius\") as string);\n const dur = parseInt(getParam(\"duration\") as string);\n let exp = -1;\n if (dur > 0) exp = Math.floor(Date.now() / 1000) + dur;\n\n await sqlite.execute({\n sql:\n \"INSERT INTO peace_zones (region, pos_x, pos_y, pos_z, radius, expiration, creator_name) VALUES (?, ?, ?, ?, ?, ?, ?) ON CONFLICT(region) DO UPDATE SET pos_x=?, pos_y=?, pos_z=?, radius=?, expiration=?, creator_name=?\",\n args: [\n regionName,\n px,\n py,\n pz,\n rad,\n exp,\n userName,\n px,\n py,\n pz,\n rad,\n exp,\n userName,\n ],\n });\n return new Response(\"PEACE_SET\", { headers: corsHeaders });\n }\n if (action === \"revoke_peace\") {\n await sqlite.execute({\n sql: \"DELETE FROM peace_zones WHERE region = ?\",\n args: [regionName],\n });\n return new Response(\"PEACE_REVOKED\", { headers: corsHeaders });\n }\n if (action === \"check_peace\") {\n const currentTime = Math.floor(Date.now() / 1000);\n await sqlite.execute({\n sql: \"DELETE FROM peace_zones WHERE expiration > 0 AND expiration < ?\",\n args: [currentTime],\n });\n const pRes = await sqlite.execute({\n sql: \"SELECT * FROM peace_zones WHERE region = ?\",\n args: [regionName],\n });\n if (pRes.rows.length > 0) {\n let pr: any = {};\n const rawPRow = pRes.rows[0];\n if (Array.isArray(rawPRow)) {\n pRes.columns.forEach((col, i) => pr[col] = rawPRow[i]);\n } else pr = rawPRow;\n return new Response(\n `PEACE_ACTIVE|${pr.pos_x},${pr.pos_y},${pr.pos_z}|${pr.radius}|${pr.expiration}|${pr.creator_name}`,\n { headers: corsHeaders },\n );\n }\n return new Response(\"PEACE_NONE\", { headers: corsHeaders });\n }\n\n if (action === \"register_server\") {\n const serverUrl = getParam(\"server_url\") as string;\n if (!serverUrl) {\n return new Response(\"ERROR_NO_URL\", { headers: corsHeaders });\n }\n await sqlite.execute({\n sql:\n \"INSERT INTO system_config (key_name, key_value) VALUES ('delivery_server', ?) ON CONFLICT(key_name) DO UPDATE SET key_value = ?\",\n args: [serverUrl, serverUrl],\n });\n return new Response(\"SERVER_REGISTERED\", { headers: corsHeaders });\n }\n\n if (action === \"deliver_hud\" && targetUuid) {\n const res = await sqlite.execute(\n \"SELECT key_value FROM system_config WHERE key_name = 'delivery_server'\",\n );\n if (res.rows.length > 0) {\n let deliveryUrl = Array.isArray(res.rows[0])\n ? res.rows[0][0]\n : (res.rows[0] as any).key_value;\n try {\n const fetchRes = await fetch(deliveryUrl, {\n method: \"POST\",\n body: targetUuid,\n });\n if (fetchRes.body) await fetchRes.text();\n return new Response(\"DELIVERY_DISPATCHED\", { headers: corsHeaders });\n } catch (e) {\n return new Response(\"ERROR_DISPATCHING\", { headers: corsHeaders });\n }\n }\n return new Response(\"ERROR_NO_SERVER\", { headers: corsHeaders });\n }\n\n if (action === \"get_vampire_uuids\") {\n const res = await sqlite.execute(\n \"SELECT avatar_uuid, is_vampire, custom_species FROM vampire_data\",\n );\n let uuids = [];\n for (const row of res.rows as any[]) {\n let rUuid = Array.isArray(row) ? row[0] : row.avatar_uuid;\n let rIsVamp = Array.isArray(row) ? row[1] : row.is_vampire;\n let rSpecies = Array.isArray(row) ? row[2] : row.custom_species;\n\n if (\n rSpecies === \"The Progenitor\" || rSpecies === \"Arch Vampire\" ||\n rSpecies === \"Vampire\" || (rIsVamp === 1 && rSpecies === \"\")\n ) {\n uuids.push(rUuid);\n }\n }\n return new Response(\"VAMP_UUIDS|\" + uuids.join(\",\"), {\n headers: corsHeaders,\n });\n }\n\n if (\n action === \"sync\" || action === \"bite\" || action === \"scan\" ||\n action === \"drain_energy\" || action === \"self_heal\" || action === \"compel\"\n ) {\n if (hudVersion < 1.5) {\n return new Response(\"UPDATE_REQUIRED\", { headers: corsHeaders });\n }\n }\n\n if (action === \"set_death_message\" && targetUuid) {\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET death_message = ? WHERE avatar_uuid = ?\",\n args: [\n (getParam(\"message\") as string || \"\").substring(0, 80),\n targetUuid,\n ],\n });\n return new Response(\"DEATH_MSG_SET\", { headers: corsHeaders });\n }\n if (action === \"set_password\") {\n const pass = (getParam(\"password\") as string || \"\").trim().substring(\n 0,\n 50,\n );\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET web_password = ? WHERE avatar_uuid = ?\",\n args: [pass, uuid],\n });\n return new Response(`PASSWORD_SET_SUCCESS|${pass}`, {\n headers: corsHeaders,\n });\n }\n\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET avatar_name = ? WHERE avatar_uuid = ?\",\n args: [userName, uuid],\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, house, house_title, loyalty_uuid, killer_name, death_date, killer_uuid, death_message, coffin_count, coffin_date, web_password, kingdom, kingdom_title, kingdom_loyalty, mana, max_mana 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 r = rawRow;\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 house: String(r.house || \"Outcast\"),\n house_title: String(r.house_title || \"\"),\n loyalty_uuid: String(r.loyalty_uuid || \"\"),\n killer: String(r.killer_name || \"\"),\n deathDate: String(r.death_date || \"\"),\n killerUuid: String(r.killer_uuid || \"\"),\n deathMsg: String(r.death_message || \"\"),\n coffinCount: Number(r.coffin_count || 0),\n coffinDate: String(r.coffin_date || \"\"),\n webPass: String(r.web_password || \"\"),\n kingdom: String(r.kingdom || \"Unbound\"),\n kingdom_title: String(r.kingdom_title || \"\"),\n kingdom_loyalty: String(r.kingdom_loyalty || \"\"),\n mana: Number(r.mana),\n max_mana: Number(r.max_mana),\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.mana)) p.mana = 10.0;\n if (isNaN(p.max_mana) || p.max_mana === 0) p.max_mana = 10.0;\n if (isNaN(p.age)) p.age = 0;\n if (isNaN(p.rich)) p.rich = 0;\n if (\n isNaN(p.gen) ||\n (p.gen === 0 && p.custom_species !== \"The Progenitor\" &&\n p.custom_species !== \"Arch Vampire\" &&\n p.custom_species !== \"High Priestess\" &&\n p.custom_species !== \"High Priest\")\n ) 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 let diffVal = 1;\n if (dateDiffRes.rows.length > 0) {\n diffVal = (dateDiffRes.rows[0] as any).diff ??\n (dateDiffRes.rows[0] as any)[0];\n }\n const daysPassed = Math.max(1, Number(diffVal) || 1);\n\n if (p.isVamp === 0) {\n if (p.blood <= 0.0) {\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET last_date_checked = ? WHERE avatar_uuid = ?\",\n args: [todayStr, id],\n });\n } else {\n let regenAmt = p.custom_species === \"Familiar\" ? 1.0 : 0.25;\n p.blood = Math.min(p.max, p.blood + (regenAmt * daysPassed));\n p.mana = Math.max(0, p.mana - (1.0 * daysPassed));\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = ?, mana = ?, last_date_checked = ? WHERE avatar_uuid = ?\",\n args: [p.blood, p.mana, todayStr, id],\n });\n }\n } else {\n let dailyDrain = p.age >= 1500\n ? 0.25\n : (p.age >= 1000 ? 0.50 : (p.age >= 500 ? 0.75 : 1.00));\n let prevBlood = p.blood;\n p.blood = Math.max(0.00, p.blood - (dailyDrain * daysPassed));\n p.age = p.age + daysPassed;\n\n p.rich = p.rich +\n ((p.custom_species === \"The Progenitor\" ? 100 : 0.25) *\n daysPassed);\n p.group = p.age >= 2000\n ? \"Eternal\"\n : (p.age >= 1500\n ? \"Progenitor\"\n : (p.age >= 1250\n ? \"Primogenitor\"\n : (p.age >= 1000\n ? \"Methuselah\"\n : (p.age >= 500\n ? \"Ancient\"\n : (p.age >= 250\n ? \"Elder\"\n : (p.age >= 50\n ? \"Blooded\"\n : (p.age >= 15 ? \"Neonate\" : \"Fledgling\")))))));\n\n if (p.blood <= 0.00 && prevBlood > 0.00) {\n p.killer = \"Hunger\";\n p.killerUuid = \"Hunger\";\n p.deathDate = todayStr;\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET blood_litres = ?, age_days = ?, last_date_checked = ?, age_group = ?, blood_richness = ?, killer_name = 'Hunger', killer_uuid = 'Hunger', death_date = ? WHERE avatar_uuid = ?`,\n args: [p.blood, p.age, todayStr, p.group, p.rich, todayStr, id],\n });\n } else {\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 }\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 return p;\n }\n const isVamp = forceVampire ? 1 : 0;\n const startBlood = isVamp ? 0.25 : 5.00;\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, house, house_title, loyalty_uuid, killer_name, death_date, killer_uuid, death_message, coffin_count, coffin_date, web_password, kingdom, kingdom_title, kingdom_loyalty, mana, max_mana) VALUES (?, ?, 5.00, ?, 1, 0, ?, ?, '', 'None', 0, 'None', ?, ?, '', 'Outcast', '', '', '', '', '', '', 0, '', '', 'Unbound', '', '', 10.0, 10.0)`,\n args: [\n id,\n startBlood,\n isVamp,\n todayStr,\n isVamp ? \"Fledgling\" : \"Human\",\n isVamp ? todayStr : \"Unknown\",\n defaultName,\n ],\n });\n return await getOrCreatePlayer(id, forceVampire, defaultName);\n }\n\n function getStatusAndSoul(subject: any) {\n let soulIntegrity = \"100%\";\n let status = (subject.blood <= 0.0)\n ? \"Dead\"\n : (subject.isVamp === 1 ? \"Undead\" : \"Alive\");\n let daysLeft = \"N/A\";\n if (subject.isVamp === 0 && subject.blood <= 0.0) {\n let daysDead = 0;\n if (subject.deathDate && subject.deathDate !== \"\") {\n daysDead = Math.floor(\n (new Date(todayStr).getTime() -\n new Date(subject.deathDate).getTime()) / 86400000,\n );\n }\n if (daysDead >= 7) {\n soulIntegrity = \"0%\";\n status = \"Ashen\";\n daysLeft = \"0\";\n } else {\n soulIntegrity = `${\n Math.max(0, 100 - Math.floor((daysDead / 7) * 100))\n }%`;\n daysLeft = (7 - daysDead).toString();\n }\n } else if (subject.isVamp === 1) {\n soulIntegrity = \"N/A\";\n if (subject.blood <= 0.0) status = \"Dead\";\n }\n let killerDisplay = subject.killer || \"\";\n if (\n subject.killerUuid && subject.killerUuid !== \"\" &&\n subject.killerUuid !== \"Hunger\"\n ) killerDisplay = `secondlife:///app/agent/${subject.killerUuid}/about`;\n else if (subject.killerUuid === \"Hunger\") killerDisplay = \"Hunger\";\n return { status, soulIntegrity, daysLeft, killerDisplay };\n }\n\n let player = await getOrCreatePlayer(uuid, false, userName);\n\n if (action === \"coffin_check\") {\n if (player.isVamp === 1) {\n const now = Date.now();\n let lastTime = parseInt(player.coffinDate) || 0;\n let cCount = player.coffinCount;\n if (now - lastTime >= 86400000) {\n cCount = 0;\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET coffin_count = 0, coffin_date = ? WHERE avatar_uuid = ?\",\n args: [now.toString(), uuid],\n });\n }\n return new Response(`COFFIN_ALLOWED|${cCount}`, {\n headers: corsHeaders,\n });\n }\n return new Response(\"COFFIN_DENIED\", { headers: corsHeaders });\n }\n\n if (action === \"coffin_reward\") {\n if (player.isVamp === 0) {\n return new Response(\"ERROR_NOT_VAMPIRE\", { headers: corsHeaders });\n }\n let cCount = player.coffinCount;\n let lastTime = parseInt(player.coffinDate) || 0;\n const now = Date.now();\n if (now - lastTime >= 86400000) {\n cCount = 0;\n lastTime = now;\n }\n if (cCount >= 3) {\n return new Response(\"ERROR_LIMIT_REACHED\", { headers: corsHeaders });\n }\n\n cCount++;\n let newRich = player.rich + 1;\n if (cCount === 1) lastTime = now;\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_richness = ?, coffin_count = ?, coffin_date = ? WHERE avatar_uuid = ?\",\n args: [newRich, cCount, lastTime.toString(), uuid],\n });\n return new Response(\n `COFFIN_SUCCESS|${Number(newRich).toFixed(2)}|${cCount}`,\n { headers: corsHeaders },\n );\n }\n\n if (action === \"kingdom_book_init\") {\n return new Response(\n `KINGDOM_MENU|${player.kingdom}|${player.kingdom_title}`,\n { headers: corsHeaders },\n );\n }\n if (action === \"kingdom_pledge\") {\n if (player.house === \"Outcast\") {\n return new Response(\"ERROR_NO_COVEN\", { headers: corsHeaders });\n }\n if (\n player.house_title !== \"Patriarch\" && player.house_title !== \"Matriarch\"\n ) return new Response(\"ERROR_NOT_COVEN_LEADER\", { headers: corsHeaders });\n const tRes = await sqlite.execute({\n sql: \"SELECT kingdom FROM vampire_data WHERE avatar_uuid = ?\",\n args: [targetUuid],\n });\n if (tRes.rows.length === 0) {\n return new Response(\"ERROR_USER_NOT_FOUND\", { headers: corsHeaders });\n }\n let tRow = tRes.rows[0] as any;\n let tEmp = Array.isArray(tRow) ? tRow[0] : tRow.kingdom;\n let titleToGive = tEmp !== \"Unbound\" ? \"Follower\" : \"\";\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET kingdom_loyalty = ?, kingdom = ?, kingdom_title = CASE WHEN house_title IN ('Patriarch', 'Matriarch') THEN ? ELSE ? END WHERE house = ?\",\n args: [targetUuid, tEmp, titleToGive, titleToGive, player.house],\n });\n return new Response(`KINGDOM_PLEDGED|${targetUuid}`, {\n headers: corsHeaders,\n });\n }\n\n if (action === \"kingdom_check_create\") {\n const clRes = await sqlite.execute({\n sql:\n \"SELECT count(DISTINCT house) as c FROM vampire_data WHERE kingdom_loyalty = ? AND house != 'Outcast' AND house != ''\",\n args: [uuid],\n });\n let cCount = Array.isArray(clRes.rows[0])\n ? clRes.rows[0][0]\n : (clRes.rows[0] as any).c || 0;\n if (cCount < 5) {\n return new Response(\"ERROR_NOT_ENOUGH_LOYALTY\", {\n headers: corsHeaders,\n });\n }\n return new Response(\"KINGDOM_READY\", { headers: corsHeaders });\n }\n if (action === \"kingdom_confirm_create\") {\n let parts = targetUuid.split(\"|\");\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET kingdom = ?, kingdom_title = 'Follower' WHERE kingdom_loyalty = ?\",\n args: [parts[0], uuid],\n });\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET kingdom = ?, kingdom_title = ? WHERE avatar_uuid = ?\",\n args: [parts[0], parts[1], uuid],\n });\n return new Response(`KINGDOM_CREATED|${parts[0]}`, {\n headers: corsHeaders,\n });\n }\n if (action === \"kingdom_leave\") {\n if (\n player.house_title !== \"Patriarch\" && player.house_title !== \"Matriarch\"\n ) return new Response(\"ERROR_NOT_COVEN_LEADER\", { headers: corsHeaders });\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET kingdom = 'Unbound', kingdom_title = '', kingdom_loyalty = '' WHERE house = ?\",\n args: [player.house],\n });\n return new Response(\"LEFT_KINGDOM\", { headers: corsHeaders });\n }\n if (action === \"kingdom_abolish\") {\n if (player.kingdom_title !== \"King\" && player.kingdom_title !== \"Queen\") {\n return new Response(\"ERROR_NOT_KING\", { headers: corsHeaders });\n }\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET kingdom = 'Unbound', kingdom_title = '', kingdom_loyalty = '' WHERE kingdom = ?\",\n args: [player.kingdom],\n });\n return new Response(\"KINGDOM_ABOLISHED\", { headers: corsHeaders });\n }\n if (action === \"book_init\") {\n return new Response(`BOOK_MENU|${player.house}|${player.house_title}`, {\n headers: corsHeaders,\n });\n }\n if (action === \"coven_info\") {\n if (player.house === \"Outcast\" || player.house === \"\") {\n return new Response(\"ERROR_COVEN_NOT_FOUND\", { headers: corsHeaders });\n }\n const cRes = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid, avatar_name, house_title FROM vampire_data WHERE house = ?\",\n args: [player.house],\n });\n let leaderLink = \"None\";\n let leadTitle = \"Leader\";\n let archonLink = \"None\";\n for (const row of cRes.rows as any[]) {\n let rUuid = Array.isArray(row) ? row[0] : row.avatar_uuid;\n let rTitle = Array.isArray(row) ? row[2] : row.house_title;\n if (rTitle === \"Patriarch\" || rTitle === \"Matriarch\") {\n leaderLink = `secondlife:///app/agent/${rUuid}/about`;\n leadTitle = rTitle;\n }\n if (rTitle === \"Archon\") {\n archonLink = `secondlife:///app/agent/${rUuid}/about`;\n }\n }\n return new Response(\n `COVEN_INFO|${player.house}|${leadTitle}|${leaderLink}|${archonLink}|${cRes.rows.length}`,\n { headers: corsHeaders },\n );\n }\n if (\n action === \"check_coven_name\" || action === \"check_coven_name_override\"\n ) {\n if (action === \"check_coven_name\") {\n const folRes = await sqlite.execute({\n sql: \"SELECT count(*) as c FROM vampire_data WHERE loyalty_uuid = ?\",\n args: [uuid],\n });\n let fCount = Array.isArray(folRes.rows[0])\n ? folRes.rows[0][0]\n : (folRes.rows[0] as any).c;\n if (fCount < 5) {\n return new Response(\"ERROR_NOT_ENOUGH_FOLLOWERS\", {\n headers: corsHeaders,\n });\n }\n }\n const existRes = await sqlite.execute({\n sql: \"SELECT 1 FROM vampire_data WHERE house = ?\",\n args: [targetUuid],\n });\n if (existRes.rows.length > 0) {\n return new Response(\"NAME_TAKEN\", { headers: corsHeaders });\n }\n return new Response(\n action === \"check_coven_name_override\"\n ? \"NAME_AVAILABLE_OVERRIDE\"\n : \"NAME_AVAILABLE\",\n { headers: corsHeaders },\n );\n }\n if (action === \"confirm_create_coven\") {\n let parts = targetUuid.split(\"|\");\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET house = ?, house_title = ?, kingdom = 'Unbound', kingdom_title = '', kingdom_loyalty = ? WHERE avatar_uuid = ?\",\n args: [parts[0], parts[1], uuid, uuid],\n });\n return new Response(`COVEN_CREATED|${parts[1]}`, {\n headers: corsHeaders,\n });\n }\n if (action === \"join_coven\") {\n const leaderRes = await sqlite.execute({\n sql:\n \"SELECT house, kingdom, kingdom_loyalty FROM vampire_data WHERE house = ?\",\n args: [targetUuid],\n });\n if (leaderRes.rows.length === 0) {\n return new Response(\"ERROR_COVEN_NOT_FOUND\", { headers: corsHeaders });\n }\n\n let row = leaderRes.rows[0] as any;\n let lHouse = Array.isArray(row) ? row[0] : row.house;\n let lEmp = Array.isArray(row) ? row[1] : row.kingdom;\n let lEmpLoy = Array.isArray(row) ? row[2] : row.kingdom_loyalty;\n\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET house = ?, kingdom = ?, kingdom_title = ?, kingdom_loyalty = ? WHERE avatar_uuid = ?\",\n args: [\n lHouse,\n lEmp,\n lEmp !== \"Unbound\" ? \"Follower\" : \"\",\n lEmpLoy,\n uuid,\n ],\n });\n return new Response(`JOINED_COVEN|${targetUuid}`, {\n headers: corsHeaders,\n });\n }\n if (action === \"assign_archon\") {\n if (player.house !== targetUuid) {\n return new Response(\"ERROR_NOT_IN_COVEN_ARCHON\", {\n headers: corsHeaders,\n });\n }\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET house_title = 'Archon' WHERE avatar_uuid = ?\",\n args: [uuid],\n });\n return new Response(`ARCHON_ASSIGNED|${targetUuid}`, {\n headers: corsHeaders,\n });\n }\n if (action === \"eject_member\" || action === \"remove_archon\") {\n const memRes = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid, house, house_title FROM vampire_data WHERE avatar_name = ?\",\n args: [targetUuid],\n });\n if (memRes.rows.length === 0) {\n return new Response(\"ERROR_USER_NOT_FOUND\", { headers: corsHeaders });\n }\n let mRow = memRes.rows[0] as any;\n let mUuid = Array.isArray(mRow) ? mRow[0] : mRow.avatar_uuid;\n let mHouse = Array.isArray(mRow) ? mRow[1] : mRow.house;\n let mTitle = Array.isArray(mRow) ? mRow[2] : mRow.house_title;\n if (mHouse !== player.house) {\n return new Response(\"ERROR_NOT_IN_COVEN\", { headers: corsHeaders });\n }\n if (action === \"eject_member\") {\n if (\n mTitle === \"Patriarch\" || mTitle === \"Matriarch\" ||\n mTitle === \"Archon\"\n ) {\n return new Response(\"ERROR_CANNOT_EJECT_SUPERIOR\", {\n headers: corsHeaders,\n });\n }\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET house = 'Outcast', house_title = '', kingdom = 'Unbound', kingdom_title = '', kingdom_loyalty = '' WHERE avatar_uuid = ?\",\n args: [mUuid],\n });\n return new Response(`MEMBER_EJECTED|${targetUuid}`, {\n headers: corsHeaders,\n });\n } else {\n if (mTitle !== \"Archon\") {\n return new Response(\"ERROR_NOT_ARCHON\", { headers: corsHeaders });\n }\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET house_title = '' WHERE avatar_uuid = ?\",\n args: [mUuid],\n });\n return new Response(`ARCHON_REMOVED|${targetUuid}`, {\n headers: corsHeaders,\n });\n }\n }\n if (action === \"demolish_coven\") {\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET house = 'Outcast', house_title = '', kingdom = 'Unbound', kingdom_title = '', kingdom_loyalty = '' WHERE house = ?\",\n args: [player.house],\n });\n return new Response(\"COVEN_DEMOLISHED\", { headers: corsHeaders });\n }\n if (action === \"leave_coven\") {\n if (\n player.house_title === \"Patriarch\" || player.house_title === \"Matriarch\"\n ) {\n return new Response(\"ERROR_LEADER_CANNOT_LEAVE\", {\n headers: corsHeaders,\n });\n }\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET house = 'Outcast', house_title = '', kingdom = 'Unbound', kingdom_title = '', kingdom_loyalty = '' WHERE avatar_uuid = ?\",\n args: [uuid],\n });\n return new Response(\"LEFT_COVEN\", { headers: corsHeaders });\n }\n if (action === \"pledge_loyalty\" || action === \"accept_familiar\") {\n const leaderUuid = action === \"pledge_loyalty\" ? targetUuid : uuid;\n const followerUuid = action === \"pledge_loyalty\" ? uuid : targetUuid;\n if (leaderUuid === followerUuid) {\n return new Response(\"ERROR_CANNOT_PLEDGE_SELF\", {\n headers: corsHeaders,\n });\n }\n const leaderRes = await sqlite.execute({\n sql:\n \"SELECT avatar_name, house, kingdom, kingdom_loyalty FROM vampire_data WHERE avatar_uuid = ?\",\n args: [leaderUuid],\n });\n if (leaderRes.rows.length === 0) {\n return new Response(\"ERROR_USER_NOT_FOUND\", { headers: corsHeaders });\n }\n let row = leaderRes.rows[0] as any;\n let lName = Array.isArray(row) ? row[0] : row.avatar_name;\n let lHouse = Array.isArray(row) ? row[1] : row.house;\n let lEmp = Array.isArray(row) ? row[2] : row.kingdom;\n let lEmpLoy = Array.isArray(row) ? row[3] : row.kingdom_loyalty;\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET loyalty_uuid = ?, house = ?, kingdom = ?, kingdom_title = ?, kingdom_loyalty = ? WHERE avatar_uuid = ?\",\n args: [\n leaderUuid,\n lHouse,\n lEmp,\n lEmp !== \"Unbound\" ? \"Follower\" : \"\",\n lEmpLoy,\n followerUuid,\n ],\n });\n return new Response(`FAMILIAR_ACCEPTED|${lName}`, {\n headers: corsHeaders,\n });\n }\n\n if (action === \"sync\") {\n const currentTime = Math.floor(Date.now() / 1000);\n await sqlite.execute({\n sql: \"DELETE FROM peace_zones WHERE expiration > 0 AND expiration < ?\",\n args: [currentTime],\n });\n const pRes = await sqlite.execute({\n sql:\n \"SELECT pos_x, pos_y, pos_z, radius FROM peace_zones WHERE region = ?\",\n args: [regionName],\n });\n let peaceData = \"None\";\n if (pRes.rows.length > 0) {\n let pr: any = {};\n const rawPRow = pRes.rows[0];\n if (Array.isArray(rawPRow)) {\n pRes.columns.forEach((col, i) => pr[col] = rawPRow[i]);\n } else pr = rawPRow;\n peaceData = `${pr.pos_x},${pr.pos_y},${pr.pos_z}|${pr.radius}`;\n }\n\n let displaySpecies = player.custom_species !== \"\"\n ? player.custom_species\n : (player.isVamp === 1 ? \"Vampire\" : \"Human\");\n let archVampName = \"None\";\n if (player.bloodline && player.bloodline !== \"None\") {\n const nobleRes = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid FROM vampire_data WHERE bloodline = ? AND custom_species IN ('Arch Vampire', 'The Progenitor', 'High Priestess', 'High Priest') LIMIT 1\",\n args: [player.bloodline],\n });\n if (nobleRes.rows.length > 0) {\n const aRow = nobleRes.rows[0] as any;\n archVampName = `secondlife:///app/agent/${\n Array.isArray(aRow) ? String(aRow[0]) : String(aRow.avatar_uuid)\n }/about`;\n }\n }\n\n let subsist = \"N/A\";\n if (player.isVamp === 1) {\n let drain = player.age >= 1500\n ? 0.25\n : (player.age >= 1000 ? 0.50 : (player.age >= 500 ? 0.75 : 1.00));\n subsist = \"-\" + drain.toFixed(2) + \"L/day\";\n } else if (player.custom_species === \"Familiar\") subsist = \"+1.00L/day\";\n else subsist = \"-1.00 Mana/day\";\n\n let followerCount = 0;\n let familiarCount = 0;\n const folRes = await sqlite.execute({\n sql: \"SELECT custom_species FROM vampire_data WHERE loyalty_uuid = ?\",\n args: [uuid],\n });\n for (const row of folRes.rows as any[]) {\n let cs = Array.isArray(row) ? row[0] : row.custom_species;\n followerCount++;\n if (cs === \"Familiar\") familiarCount++;\n }\n let followerOf = player.loyalty_uuid && player.loyalty_uuid !== \"\"\n ? `secondlife:///app/agent/${player.loyalty_uuid}/about`\n : \"None\";\n let { status, soulIntegrity, daysLeft, killerDisplay } = getStatusAndSoul(\n player,\n );\n const clRes = await sqlite.execute({\n sql:\n \"SELECT count(DISTINCT house) as c FROM vampire_data WHERE kingdom_loyalty = ? AND house != 'Outcast' AND house != ''\",\n args: [uuid],\n });\n let covenLoyaltyCount = Array.isArray(clRes.rows[0])\n ? clRes.rows[0][0]\n : (clRes.rows[0] as any).c || 0;\n\n return new Response(\n `DATA:\\nSpecies: ${displaySpecies}\\nKingdom: ${player.kingdom}\\nKingdom Title: ${player.kingdom_title}\\nCoven Loyalty: ${covenLoyaltyCount}\\nBloodline: ${player.bloodline}\\nArch Vampire: ${archVampName}\\nGeneration: ${player.gen}\\nEmbraced: ${player.embraced}\\nCoven: ${player.house}\\nCoven Title: ${player.house_title}\\nFollowers: ${followerCount}\\nFamiliars: ${familiarCount}\\nFollower Of: ${followerOf}\\nSire: ${player.sire}\\nAge Group: ${player.group}\\nAge: ${player.age}\\nVitae: ${\n Number(player.rich).toFixed(2)\n }\\nSubsistence: ${subsist}\\nBlood: ${player.blood.toFixed(2)}/${\n player.max.toFixed(2)\n }L\\nStatus: ${status}\\nKiller: ${killerDisplay}\\nDeath Date: ${player.deathDate}\\nSoul: ${soulIntegrity}\\nDays Until Ashen: ${daysLeft}\\nDeathMessage: ${player.deathMsg}\\nPassword: ${player.webPass}\\nMana: ${\n player.mana.toFixed(1)\n }/${player.max_mana.toFixed(1)}\\nPeaceData: ${peaceData}`,\n { headers: corsHeaders },\n );\n }\n\n if (action === \"scan\" && targetUuid) {\n let subject = await getOrCreatePlayer(targetUuid, false);\n let subjSpecies = subject.custom_species !== \"\"\n ? subject.custom_species\n : (subject.isVamp === 1 ? \"Vampire\" : \"Human\");\n let archVampNameSubj = \"None\";\n if (subject.bloodline && subject.bloodline !== \"None\") {\n const nobleResSubj = await sqlite.execute({\n sql:\n \"SELECT avatar_uuid FROM vampire_data WHERE bloodline = ? AND custom_species IN ('Arch Vampire', 'The Progenitor', 'High Priestess', 'High Priest') LIMIT 1\",\n args: [subject.bloodline],\n });\n if (nobleResSubj.rows.length > 0) {\n const aRow = nobleResSubj.rows[0] as any;\n archVampNameSubj = `secondlife:///app/agent/${\n Array.isArray(aRow) ? String(aRow[0]) : String(aRow.avatar_uuid)\n }/about`;\n }\n }\n let targetFollowerCount = 0;\n let targetFamiliarCount = 0;\n const folResSubj = await sqlite.execute({\n sql: \"SELECT custom_species FROM vampire_data WHERE loyalty_uuid = ?\",\n args: [targetUuid],\n });\n for (const row of folResSubj.rows as any[]) {\n let cs = Array.isArray(row) ? row[0] : row.custom_species;\n targetFollowerCount++;\n if (cs === \"Familiar\") targetFamiliarCount++;\n }\n let targetFollowerOf = subject.loyalty_uuid && subject.loyalty_uuid !== \"\"\n ? `secondlife:///app/agent/${subject.loyalty_uuid}/about`\n : \"None\";\n let { status, soulIntegrity, daysLeft, killerDisplay } = getStatusAndSoul(\n subject,\n );\n const clResSubj = await sqlite.execute({\n sql:\n \"SELECT count(DISTINCT house) as c FROM vampire_data WHERE kingdom_loyalty = ? AND house != 'Outcast' AND house != ''\",\n args: [targetUuid],\n });\n let covenLoyaltyCountSubj = Array.isArray(clResSubj.rows[0])\n ? clResSubj.rows[0][0]\n : (clResSubj.rows[0] as any).c || 0;\n\n return new Response(\n `SCAN_RESULT:\\nSpecies: ${subjSpecies}\\nKingdom: ${subject.kingdom}\\nKingdom Title: ${subject.kingdom_title}\\nCoven Loyalty: ${covenLoyaltyCountSubj}\\nBloodline: ${subject.bloodline}\\nArch Vampire: ${archVampNameSubj}\\nCoven: ${subject.house}\\nCoven Title: ${subject.house_title}\\nFollowers: ${targetFollowerCount}\\nFamiliars: ${targetFamiliarCount}\\nFollower Of: ${targetFollowerOf}\\nBlood: ${\n subject.blood.toFixed(2)\n }/${\n subject.max.toFixed(2)\n }L\\nStatus: ${status}\\nKiller: ${killerDisplay}\\nDeath Date: ${subject.deathDate}\\nSoul: ${soulIntegrity}\\nDays Until Ashen: ${daysLeft}\\nDeathMessage: ${subject.deathMsg}\\nAge Group: ${subject.group}\\nMana: ${\n subject.mana.toFixed(1)\n }/${subject.max_mana.toFixed(1)}`,\n { headers: corsHeaders },\n );\n }\n\n // --- COMPULSION LOGIC: PROGENITOR & HIERARCHY CHECKS ---\n if (action === \"compel\" && targetUuid) {\n let target = await getOrCreatePlayer(targetUuid, false);\n\n // Progenitor Immunity\n if (target.custom_species === \"The Progenitor\") {\n return new Response(\"FAIL_TOO_ANCIENT\", { headers: corsHeaders });\n }\n\n // If the attacker is NOT The Progenitor\n if (player.custom_species !== \"The Progenitor\") {\n // If the attacker is NOT an Arch Vampire, they cannot compel Arch Vampires\n if (\n player.custom_species !== \"Arch Vampire\" &&\n target.custom_species === \"Arch Vampire\"\n ) {\n return new Response(\"FAIL_TOO_ANCIENT\", { headers: corsHeaders });\n }\n\n // Regular vampires (and Arch Vampires) cannot compel someone older than them\n if (target.isVamp === 1 && target.age > player.age) {\n return new Response(\"FAIL_TOO_ANCIENT\", { headers: corsHeaders });\n }\n }\n\n if (target.isVamp === 0 && target.custom_species !== \"Familiar\") {\n return new Response(\"FAIL_HUMAN_COMPEL\", { headers: corsHeaders });\n }\n\n if (player.rich < 1.0) {\n return new Response(\"FAIL_VITAE\", { headers: corsHeaders });\n }\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_richness = MAX(0, blood_richness - 1) WHERE avatar_uuid = ?\",\n args: [uuid],\n });\n return new Response(\"COMPEL_SUCCESS\", { headers: corsHeaders });\n }\n\n if (action === \"self_heal\") {\n if (player.mana < 0.50) {\n return new Response(\"ATTACKER_DRY\", { headers: corsHeaders });\n }\n if (player.blood >= player.max) {\n return new Response(\"ATTACKER_FULL\", { headers: corsHeaders });\n }\n const healUpdate = await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = MIN(max_blood, blood_litres + ?), mana = MAX(0, mana - ?) WHERE avatar_uuid = ? RETURNING blood_litres, mana\",\n args: [0.25, 0.50, uuid],\n });\n let row = healUpdate.rows[0] as any;\n let newBlood = Number(Array.isArray(row) ? row[0] : row.blood_litres);\n let newMana = Number(Array.isArray(row) ? row[1] : row.mana);\n return new Response(\n `SELF_HEAL_SUCCESS:${newBlood.toFixed(2)}/${player.max.toFixed(2)}L|${\n newMana.toFixed(2)\n }`,\n { headers: corsHeaders },\n );\n }\n\n if (action !== null && action.startsWith(\"bite\") && targetUuid) {\n if (player.blood <= 0.0) {\n return new Response(\"ATTACKER_DRY\", { headers: corsHeaders });\n }\n let victim = await getOrCreatePlayer(targetUuid, false);\n if (victim.blood <= 0.0) {\n return new Response(\"VICTIM_DRY\", { headers: corsHeaders });\n }\n\n let drainAmount = 0.25;\n if (player.custom_species === \"The Progenitor\") {\n drainAmount = (action === \"bite_standard\") ? 0.50 : 1.00;\n } else if (player.custom_species === \"Arch Vampire\") drainAmount = 0.50;\n\n const victimUpdate = await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = MAX(0, blood_litres - ?) WHERE avatar_uuid = ? RETURNING blood_litres\",\n args: [drainAmount, targetUuid],\n });\n let vRow = victimUpdate.rows[0] as any;\n let newVictimBlood = Number(\n Array.isArray(vRow) ? vRow[0] : vRow.blood_litres,\n );\n\n let actualDrain = drainAmount;\n if (newVictimBlood === 0 && victim.blood < drainAmount) {\n actualDrain = victim.blood;\n }\n const vampUpdate = await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = MIN(max_blood, blood_litres + ?) WHERE avatar_uuid = ? RETURNING blood_litres\",\n args: [actualDrain, uuid],\n });\n let aRow = vampUpdate.rows[0] as any;\n let newVampireBlood = Number(\n Array.isArray(aRow) ? aRow[0] : aRow.blood_litres,\n );\n\n let victimDied = newVictimBlood === 0.00 && victim.blood > 0.00;\n\n if (player.isVamp === 1 && victim.isVamp === 1 && victimDied) {\n const newRich = player.rich + victim.rich;\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = 0, blood_richness = 0, killer_name = ?, killer_uuid = ?, death_date = ?, death_message = '' WHERE avatar_uuid = ?\",\n args: [userName, uuid, todayStr, targetUuid],\n });\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_richness = ? WHERE avatar_uuid = ?\",\n args: [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|${Number(newRich).toFixed(2)}`,\n { headers: corsHeaders },\n );\n }\n\n if (victimDied) {\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET killer_name = ?, killer_uuid = ?, death_date = ?, death_message = '' WHERE avatar_uuid = ?\",\n args: [userName, uuid, todayStr, targetUuid],\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 { headers: corsHeaders },\n );\n }\n\n if (action === \"set_victim_death_echo\" && targetUuid) {\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET death_message = ? WHERE avatar_uuid = ?\",\n args: [\n (getParam(\"message\") as string || \"\").substring(0, 80),\n targetUuid,\n ],\n });\n return new Response(\"VICTIM_ECHO_SET\", { headers: corsHeaders });\n }\n\n if (action === \"validate_turn\" && targetUuid) {\n let target = await getOrCreatePlayer(targetUuid, false);\n if (player.blood < 4.0) {\n return new Response(\"FAIL_SIRE_BLOOD\", { headers: corsHeaders });\n }\n if (player.rich < 2) {\n return new Response(\"FAIL_SIRE_RICHNESS\", { headers: corsHeaders });\n }\n if (target.isVamp === 1) {\n if (target.blood <= 0.0) {\n return new Response(\"RESURRECT_VALIDATED\", { headers: corsHeaders });\n }\n return new Response(\"FAIL_TARGET_ALREADY_VAMP\", {\n headers: corsHeaders,\n });\n }\n if (target.blood <= 0.0) {\n let { status } = getStatusAndSoul(target);\n if (status === \"Ashen\") {\n return new Response(\"FAIL_ASHEN\", { headers: corsHeaders });\n }\n return new Response(\"DEAD_HUMAN_VALIDATED\", { headers: corsHeaders });\n }\n if (target.custom_species === \"Familiar\") {\n return new Response(\"TURN_VALIDATED_VAMPIRE\", { headers: corsHeaders });\n }\n return new Response(\"TURN_VALIDATED_FAMILIAR\", { headers: corsHeaders });\n }\n\n if (action === \"complete_heal\" && targetUuid) {\n if (player.blood < 1.0) {\n return new Response(\"FAIL_SIRE_BLOOD\", { headers: corsHeaders });\n }\n const newSireBlood = Math.max(0.00, player.blood - 1.0);\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET blood_litres = ? WHERE avatar_uuid = ?\",\n args: [newSireBlood, uuid],\n });\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = 0.50, killer_name = '', killer_uuid = '', death_date = '', death_message = '', custom_species = '' WHERE avatar_uuid = ?\",\n args: [targetUuid],\n });\n return new Response(\"HEAL_COMPLETE_SUCCESS\", { headers: corsHeaders });\n }\n\n if (action === \"complete_turn\" && targetUuid) {\n let target = await getOrCreatePlayer(targetUuid, false);\n if (player.blood < 4.0 || player.rich < 2) {\n return new Response(\"FAIL_SIRE_BLOOD\", { headers: corsHeaders });\n }\n const newSireBlood = Math.max(0.00, player.blood - 4.0);\n const newSireRichness = Math.max(0, player.rich - 2);\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 let passBloodline = player.bloodline;\n if (passBloodline === \"None\" || passBloodline === \"\") {\n passBloodline = userName;\n await sqlite.execute({\n sql: \"UPDATE vampire_data SET bloodline = ? WHERE avatar_uuid = ?\",\n args: [passBloodline, uuid],\n });\n }\n\n let newKingdomTitle = player.kingdom !== \"Unbound\" ? \"Follower\" : \"\";\n\n if (target.isVamp === 1 && target.blood <= 0.0) {\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET blood_litres = ?, killer_name = '', killer_uuid = '', death_date = '', death_message = '' WHERE avatar_uuid = ?\",\n args: [Math.min(target.max, 4.0), targetUuid],\n });\n return new Response(\"RESURRECT_COMPLETE_SUCCESS\", {\n headers: corsHeaders,\n });\n } else if (\n target.custom_species !== \"Familiar\" && target.isVamp === 0 &&\n target.blood > 0.0\n ) {\n await sqlite.execute({\n sql:\n \"UPDATE vampire_data SET custom_species = 'Familiar', max_blood = 10.00, loyalty_uuid = ?, house = ?, kingdom = ?, kingdom_title = ?, kingdom_loyalty = ? WHERE avatar_uuid = ?\",\n args: [\n uuid,\n player.house,\n player.kingdom,\n newKingdomTitle,\n player.kingdom_loyalty,\n targetUuid,\n ],\n });\n return new Response(\"FAMILIAR_COMPLETE_SUCCESS\", {\n headers: corsHeaders,\n });\n } else {\n await sqlite.execute({\n sql:\n `UPDATE vampire_data SET is_vampire = 1, custom_species = '', generation = ?, sire_name = ?, bloodline = ?, embraced_date = ?, blood_litres = 0.25, max_blood = 5.00, age_group = 'Fledgling', age_days = 0, loyalty_uuid = ?, house = ?, house_title = '', kingdom = ?, kingdom_title = ?, kingdom_loyalty = ?, blood_richness = 0, killer_name = '', killer_uuid = '', death_date = '', death_message = '' WHERE avatar_uuid = ?`,\n args: [\n player.gen + 1,\n userName,\n passBloodline,\n todayStr,\n uuid,\n player.house,\n player.kingdom,\n newKingdomTitle,\n player.kingdom_loyalty,\n targetUuid,\n ],\n });\n return new Response(\"TURN_COMPLETE_SUCCESS\", { headers: corsHeaders });\n }\n }\n\n return new Response(\"ERROR: Unknown action.\", { headers: corsHeaders });\n } catch (error) {\n return new Response(\"ERROR: \" + error.message, { headers: corsHeaders });\n }\n}",[131],"pulls","branches","forks","envVars",{"_144":42,"_146":42},"connections",{"_144":42,"_145":42},"count","unfilledCount","emptyCount",{"_18":130,"_20":131,"_114":36,"_116":-5,"_117":71,"_118":69,"_120":38,"_22":153,"_68":133,"_123":134,"_125":135,"_127":26,"_128":-5,"_150":154,"_89":155},{"_18":112,"_20":113,"_114":115,"_116":-5,"_117":71,"_118":119,"_120":38,"_22":149,"_68":122,"_123":124,"_125":126,"_127":26,"_128":-5,"_150":151,"_89":152},["D",1784479649387],"children",[],[113],["D",1787044866299],[],[131],["D",1784127785480],["D",1789472446807],{"_16":17,"_87":83},{"_16":17,"_80":81,"_82":83,"_33":34,"_84":85,"_86":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"ctx",{"_61":-5,"_107":194,"_195":196,"_197":198,"_199":26,"_200":26,"_201":26,"_202":38,"_203":-5,"_204":-7,"_205":-7,"_206":42,"_207":26,"_208":26,"_209":-5,"_210":26,"_211":26,"_212":26,"_213":-5},"ENV",{"_165":166,"_167":168,"_169":70,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]