⚔️ Fantasy MUD - A Multiplayer Text Adventure

\n \n \n\n\n",[],[172,233],["D",1779027346197],[201],[172],"e5be8636-51fa-11f1-abda-ee650bb23af1","seed.ts","019e364b-037b-778d-9380-67e28b05b86b",["D",1779027346197],"// Seed data: races, classes, magic schools, world geography, items, monsters, NPCs, dialogs\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function seedAll() {\n await seedRaces();\n await seedClasses();\n await seedMagicSchools();\n await seedSpells();\n await seedLanguages();\n await seedContinents();\n await seedCountries();\n await seedWilderness();\n await seedIslands();\n await seedLocations();\n await seedItems();\n await seedMonsters();\n await seedCombatSkills();\n await seedGuilds();\n await seedSchools();\n await seedNPCs();\n await seedDialogs();\n await seedTravelRoutes();\n await seedShops();\n await seedQuests();\n await seedContentToggles();\n}\n\nasync function seedRaces() {\n const races = [\n [\"Human\", \"Versatile and adaptable, humans thrive in all environments.\", 100, 50, 10, 10, 10, 10, 10, 10, 12, 1, 1, 1, 80, \"medium\"],\n [\"Elf\", \"Graceful and long-lived, elves have a deep connection to magic and nature.\", 90, 80, 8, 14, 14, 12, 8, 12, 10, 1, 1, 1, 500, \"medium\"],\n [\"Dwarf\", \"Stout and resilient, dwarves are master craftsmen and fierce warriors.\", 120, 30, 14, 8, 8, 10, 16, 8, 8, 1, 1, 1, 200, \"small\"],\n [\"Halfling\", \"Small and nimble, halflings are cheerful folk who love comfort and adventure.\", 80, 40, 6, 16, 8, 10, 10, 14, 18, 1, 1, 1, 100, \"small\"],\n [\"Orc\", \"Powerful and proud, orcs value strength and honor above all.\", 140, 20, 18, 8, 6, 8, 16, 6, 6, 1, 1, 1, 60, \"large\"],\n [\"Dark Elf\", \"Mysterious subterranean elves with innate dark magic affinity.\", 85, 90, 8, 14, 16, 12, 8, 10, 8, 1, 1, 1, 600, \"medium\"],\n [\"Beastkin\", \"Humanoids with animal features, known for keen senses and agility.\", 100, 40, 12, 16, 8, 10, 12, 10, 10, 1, 1, 1, 70, \"medium\"],\n [\"Dragonborn\", \"Descendants of ancient dragons, possessing draconic features and breath.\", 130, 60, 16, 8, 12, 10, 14, 10, 8, 1, 1, 1, 300, \"large\"],\n [\"Demon\", \"Beings from the demon realm, wielding dark powers and immense strength.\", 120, 80, 14, 10, 16, 8, 12, 12, 6, 1, 1, 1, 1000, \"medium\"],\n [\"Angel\", \"Celestial beings of light, blessed with healing magic and divine power.\", 100, 100, 10, 12, 16, 16, 10, 16, 10, 1, 1, 1, 1000, \"medium\"],\n [\"Fairy\", \"Tiny magical beings with wings, masters of illusion and nature magic.\", 40, 120, 4, 18, 18, 14, 4, 16, 16, 1, 1, 1, 400, \"tiny\"],\n [\"Vampire\", \"Undead nobles with superhuman abilities, weakened by sunlight.\", 110, 70, 14, 16, 14, 10, 12, 16, 8, 1, 1, 1, 0, \"medium\"],\n [\"Werewolf\", \"Shapeshifters cursed with lycanthropy, immensely powerful in beast form.\", 130, 30, 18, 14, 6, 8, 16, 8, 6, 1, 1, 1, 150, \"large\"],\n [\"Goblin\", \"Small, cunning creatures often underestimated by larger races.\", 60, 50, 6, 16, 12, 8, 8, 8, 14, 1, 1, 1, 40, \"small\"],\n [\"Slime\", \"Amorphous beings capable of absorbing and mimicking others.\", 80, 60, 6, 6, 12, 8, 20, 4, 10, 1, 1, 0, 0, \"medium\"],\n [\"Merfolk\", \"Aquatic beings who dwell in oceans and lakes, masters of water magic.\", 90, 80, 8, 12, 14, 12, 10, 14, 10, 1, 1, 1, 200, \"medium\"],\n [\"Giant\", \"Enormous humanoids of great strength but slow movement.\", 200, 20, 22, 4, 6, 8, 20, 6, 4, 1, 0, 1, 300, \"huge\"],\n [\"Spirit\", \"Ethereal beings tied to natural phenomena.\", 60, 100, 4, 14, 18, 16, 4, 12, 12, 1, 0, 1, 0, \"medium\"],\n [\"Golem\", \"Constructed beings animated by magic, incredibly durable.\", 180, 10, 20, 4, 4, 4, 22, 2, 2, 1, 0, 0, 0, \"large\"],\n [\"Undead\", \"Reanimated dead, ranging from mindless to cunning.\", 100, 40, 12, 8, 10, 6, 16, 4, 4, 0, 0, 0, 0, \"medium\"],\n ];\n for (const r of races) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO races (name,description,base_hp,base_mp,base_str,base_dex,base_int,base_wis,base_con,base_cha,base_luk,is_sentient,is_playable,can_speak,lifespan_years,size) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: r,\n });\n }\n}\n\nasync function seedClasses() {\n const classes = [\n [\"Warrior\", \"Masters of melee combat and heavy armor.\", 15, 2, 3, 1, 0, 0, 2, \"str\"],\n [\"Mage\", \"Scholars of the arcane arts, wielding destructive magic.\", 6, 12, 0, 1, 3, 2, 0, \"int\"],\n [\"Ranger\", \"Expert archers and survivalists at home in the wilderness.\", 10, 4, 1, 3, 1, 1, 1, \"dex\"],\n [\"Rogue\", \"Stealthy and cunning, specializing in critical strikes.\", 8, 3, 1, 3, 1, 0, 1, \"dex\"],\n [\"Cleric\", \"Divine healers and protectors blessed by the gods.\", 10, 8, 1, 0, 1, 3, 2, \"wis\"],\n [\"Paladin\", \"Holy warriors combining martial prowess with divine magic.\", 12, 6, 2, 0, 1, 2, 2, \"str\"],\n [\"Necromancer\", \"Dark mages who command the dead and drain life.\", 6, 12, 0, 0, 3, 2, 1, \"int\"],\n [\"Bard\", \"Charismatic performers who use music to cast spells.\", 8, 8, 0, 2, 2, 1, 0, \"cha\"],\n [\"Monk\", \"Disciplined martial artists who harness inner ki energy.\", 10, 6, 2, 3, 0, 2, 1, \"dex\"],\n [\"Summoner\", \"Mages who call forth creatures and spirits to fight.\", 6, 14, 0, 0, 3, 2, 0, \"int\"],\n [\"Berserker\", \"Fearless warriors who channel rage into devastating attacks.\", 16, 0, 4, 1, 0, 0, 3, \"str\"],\n [\"Alchemist\", \"Scientists and potion makers who use chemicals in combat.\", 8, 8, 0, 2, 3, 1, 1, \"int\"],\n [\"Farmer\", \"Hardworking folk skilled in agriculture and animal husbandry.\", 10, 4, 2, 1, 1, 2, 2, \"con\"],\n [\"Merchant\", \"Savvy traders with keen eyes for value and opportunity.\", 8, 4, 0, 1, 2, 2, 0, \"cha\"],\n [\"Knight\", \"Armored cavalry who fight from horseback with lance and sword.\", 14, 3, 3, 1, 0, 1, 2, \"str\"],\n ];\n for (const c of classes) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO classes (name,description,hp_per_level,mp_per_level,str_per_level,dex_per_level,int_per_level,wis_per_level,con_per_level,primary_stat) VALUES (?,?,?,?,?,?,?,?,?,?)`,\n args: c,\n });\n }\n}\n\nasync function seedMagicSchools() {\n const schools = [\n [\"Destruction\", \"Offensive magic dealing elemental damage: fire, frost, shock.\", \"int\", \"#ef4444\"],\n [\"Restoration\", \"Healing magic and protective wards against harm.\", \"wis\", \"#22c55e\"],\n [\"Alteration\", \"Magic that changes the physical world: shields, levitation, water walking.\", \"int\", \"#3b82f6\"],\n [\"Conjuration\", \"Summoning creatures and objects from other planes.\", \"int\", \"#8b5cf6\"],\n [\"Illusion\", \"Magic of deception: invisibility, charm, fear, silence.\", \"cha\", \"#ec4899\"],\n [\"Mysticism\", \"Arcane magic: telekinesis, soul trap, detect life, absorb magicka.\", \"wis\", \"#06b6d4\"],\n [\"Enchanting\", \"Imbuing items with magical properties and creating enchanted gear.\", \"int\", \"#f59e0b\"],\n [\"Necromancy\", \"Dark arts of raising the dead and draining life force.\", \"int\", \"#6b7280\"],\n [\"Nature Magic\", \"Druidic magic of plants, animals, and natural forces.\", \"wis\", \"#16a34a\"],\n [\"Blood Magic\", \"Forbidden magic using life force as fuel for powerful spells.\", \"con\", \"#dc2626\"],\n [\"Divination\", \"Seeing the future, scrying, and gaining forbidden knowledge.\", \"wis\", \"#a855f7\"],\n [\"Rune Magic\", \"Ancient magic inscribed in symbols and glyphs for delayed effects.\", \"int\", \"#d97706\"],\n ];\n for (const s of schools) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO magic_schools (name,description,primary_stat,color) VALUES (?,?,?,?)`,\n args: s,\n });\n }\n}\n\nasync function seedSpells() {\n const spells = [\n [\"Fireball\", 1, \"Hurls a ball of fire at the target.\", 15, 30, 0, 3, 1, 0, \"ranged\"],\n [\"Frost Bolt\", 1, \"Launches a shard of ice that slows the target.\", 10, 20, 0, 2, 1, 0, \"ranged\"],\n [\"Lightning Strike\", 1, \"Calls down a bolt of lightning.\", 20, 40, 0, 5, 2, 3, \"ranged\"],\n [\"Heal\", 2, \"Restores health to the target.\", 15, 0, 30, 1, 1, 0, \"touch\"],\n [\"Greater Heal\", 2, \"Powerful healing spell for critical wounds.\", 30, 0, 60, 5, 2, 5, \"touch\"],\n [\"Shield Ward\", 2, \"Creates a protective barrier absorbing damage.\", 20, 0, 0, 3, 3, 10, \"self\"],\n [\"Stoneflesh\", 3, \"Hardens your skin to stone, boosting defense.\", 25, 0, 0, 4, 2, 8, \"self\"],\n [\"Water Walking\", 3, \"Allows walking on water surfaces.\", 10, 0, 0, 3, 5, 0, \"self\"],\n [\"Summon Familiar\", 4, \"Summons a magical creature to aid you.\", 30, 0, 0, 5, 3, 0, \"self\"],\n [\"Summon Atronach\", 4, \"Summons an elemental atronach.\", 50, 0, 0, 10, 5, 15, \"self\"],\n [\"Invisibility\", 5, \"Makes you invisible until you attack.\", 35, 0, 0, 8, 3, 0, \"self\"],\n [\"Charm\", 5, \"Makes a target friendly temporarily.\", 20, 0, 0, 5, 2, 0, \"ranged\"],\n [\"Soul Trap\", 6, \"Traps the soul of a dying creature.\", 25, 0, 0, 6, 2, 5, \"ranged\"],\n [\"Detect Life\", 6, \"Reveals nearby living creatures.\", 10, 0, 0, 3, 3, 0, \"self\"],\n [\"Enchant Weapon\", 7, \"Temporarily enchants a weapon with magic.\", 30, 0, 0, 5, 3, 0, \"touch\"],\n [\"Raise Dead\", 8, \"Reanimates a fallen creature to fight for you.\", 40, 0, 0, 8, 3, 10, \"touch\"],\n [\"Entangle\", 9, \"Vines erupt from the ground to snare enemies.\", 15, 10, 0, 3, 2, 5, \"ranged\"],\n [\"Blood Bolt\", 10, \"Fires a bolt of blood that damages and heals you.\", 0, 25, 15, 6, 1, 3, \"ranged\"],\n [\"Scrying\", 11, \"See distant locations or people.\", 20, 0, 0, 8, 5, 0, \"self\"],\n [\"Rune Trap\", 12, \"Places a magical trap that explodes when triggered.\", 25, 35, 0, 5, 3, 0, \"ground\"],\n ];\n for (const s of spells) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO spells (name,school_id,description,mp_cost,damage,heal,min_level,cast_time,cooldown,range) VALUES (?,?,?,?,?,?,?,?,?,?)`,\n args: s,\n });\n }\n}\n\nasync function seedLanguages() {\n const langs = [\n [\"Common\", \"The universal trade language spoken across all continents.\", 1],\n [\"Elvish\", \"The melodic language of the elves.\", 3],\n [\"Dwarvish\", \"The guttural language of dwarves, carved into stone.\", 3],\n [\"Orcish\", \"The harsh, powerful language of the orc clans.\", 2],\n [\"Draconic\", \"The ancient language of dragons, used in powerful magic.\", 5],\n [\"Infernal\", \"The dark tongue of demons and devils.\", 4],\n [\"Celestial\", \"The radiant language of angels and divine beings.\", 4],\n [\"Sylvan\", \"The whispering language of fairies and forest spirits.\", 3],\n [\"Abyssal\", \"The chaotic language of undead and dark creatures.\", 4],\n [\"Merfolk\", \"The flowing, musical language spoken beneath the waves.\", 3],\n [\"Beast Tongue\", \"The primal language understood by beastkin and animals.\", 2],\n [\"Ancient\", \"A dead language found in ruins and ancient texts.\", 5],\n ];\n for (const l of langs) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO languages (name,description,difficulty) VALUES (?,?,?)`,\n args: l,\n });\n }\n}\n\nasync function seedContinents() {\n const continents = [\n [\"Aetheria\", \"A vast continent of rolling plains, ancient forests, and towering mountains. The seat of human civilization.\", \"temperate\", \"large\"],\n [\"Drak'thor\", \"A volcanic continent of harsh deserts and deep canyons. Home to orcs, dragonborn, and fire-adapted races.\", \"arid\", \"large\"],\n [\"Silverwood\", \"An enchanted continent of eternal forests and crystal lakes. The ancestral home of elves and fairies.\", \"temperate\", \"large\"],\n [\"Irondeep\", \"A mountainous continent riddled with vast underground cities. The dwarven homeland.\", \"cold\", \"medium\"],\n [\"Mistral Isles\", \"A tropical archipelago continent of countless islands and shallow seas. Home to merfolk and seafaring cultures.\", \"tropical\", \"medium\"],\n [\"Shadowmere\", \"A dark continent shrouded in perpetual twilight. Home to dark elves, vampires, and creatures of the night.\", \"cold\", \"large\"],\n [\"Solaria\", \"A sun-blessed continent of golden savannas and ancient temples. A melting pot of all races.\", \"hot\", \"large\"],\n [\"Frostheim\", \"An arctic continent of glaciers, tundra, and northern lights. Home to frost giants and hardy peoples.\", \"arctic\", \"medium\"],\n ];\n for (const c of continents) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO continents (name,description,climate,size) VALUES (?,?,?,?)`,\n args: c,\n });\n }\n}\n\nasync function seedCountries() {\n // 15+ countries per continent = 120+ total. We'll seed key ones per continent.\n const countries: any[][] = [];\n // Continent 1: Aetheria (temperate, human-dominated)\n const aetheriaCountries = [\n [\"Kingdom of Valoria\", 1, \"A prosperous human kingdom known for its knights and agriculture.\", \"monarchy\", 0, 1, \"Valoran Crown\"],\n [\"Republic of Mercanis\", 1, \"A diverse merchant republic where all races trade freely.\", \"republic\", 1, 1, \"Mercanis Ducat\"],\n [\"Thornwall Dominion\", 1, \"A militaristic nation guarding the border against wilderness threats.\", \"military junta\", 0, 1, \"Iron Mark\"],\n [\"Lushvale Confederacy\", 1, \"A peaceful federation of farming communities and halfling burrows.\", \"confederacy\", 1, 4, \"Lushvale Penny\"],\n [\"Stormreach Empire\", 1, \"A vast empire spanning the eastern coast, diverse and powerful.\", \"empire\", 1, 1, \"Imperial Gold\"],\n [\"Sakurai Shogunate\", 1, \"An isolationist nation with strict honor codes and samurai traditions.\", \"shogunate\", 0, 1, \"Ryo\"],\n [\"Moonvale Theocracy\", 1, \"A holy nation ruled by the Church of the Silver Moon.\", \"theocracy\", 0, 1, \"Silver Tithe\"],\n [\"Free City of Havenport\", 1, \"A massive port city-nation welcoming all races and creeds.\", \"city-state\", 1, 1, \"Haven Dollar\"],\n [\"Verdania\", 1, \"A nature-focused kingdom with strong druidic traditions.\", \"monarchy\", 0, 1, \"Leaf Crown\"],\n [\"Ashfeld\", 1, \"A frontier nation on the edge of volcanic badlands.\", \"feudalism\", 0, 1, \"Cinder Coin\"],\n [\"Brighthollow\", 1, \"A halfling-majority nation known for festivals and cuisine.\", \"democracy\", 0, 4, \"Brightpenny\"],\n [\"Irongate\", 1, \"A dwarven enclave within Aetheria, famous for metalwork.\", \"council\", 0, 3, \"Iron Ingot Note\"],\n [\"Crestwood Alliance\", 1, \"An alliance of mixed forest towns with elven and human populations.\", \"alliance\", 1, 2, \"Crest Mark\"],\n [\"Redmarch\", 1, \"A warrior nation on the southern steppe, influenced by nomadic cultures.\", \"tribal council\", 0, 1, \"Red Tooth\"],\n [\"Goldenfields\", 1, \"The breadbasket continent, endless farmlands feeding many nations.\", \"monarchy\", 0, 1, \"Wheat Crown\"],\n ];\n countries.push(...aetheriaCountries);\n\n // Continent 2: Drak'thor\n const drakthorCountries = [\n [\"Gor'mak Dominion\", 2, \"A mighty orc nation ruled by the strongest warchief.\", \"tribal\", 0, 5, \"Blood Fang\"],\n [\"Draconia\", 2, \"Kingdom of dragonborn, built around volcanic forges.\", \"monarchy\", 0, 8, \"Dragon Scale\"],\n [\"Sandveil Sultanate\", 2, \"A desert nation of merchant princes and hidden oases.\", \"sultanate\", 1, 1, \"Sand Dinar\"],\n [\"Ember Republic\", 2, \"A democratic nation of fire mages and engineers.\", \"republic\", 1, 1, \"Ember Coin\"],\n [\"Crimson Wastes Clans\", 2, \"Nomadic orc and beastkin tribes of the red desert.\", \"tribal\", 0, 7, \"Tooth\"],\n [\"Ashborn Theocracy\", 2, \"Worshippers of the Flame God, zealous and powerful.\", \"theocracy\", 0, 8, \"Flame Token\"],\n [\"Dusthaven\", 2, \"A frontier trading post that grew into a diverse nation.\", \"merchant council\", 1, 1, \"Dust Dollar\"],\n [\"Wyrmrest\", 2, \"An ancient dragonborn civilization guarding dragon tombs.\", \"monarchy\", 0, 8, \"Wyrm Coin\"],\n [\"Scaleforge\", 2, \"Industrial nation of dragonborn blacksmiths.\", \"meritocracy\", 0, 8, \"Forge Mark\"],\n [\"Sunstone Oasis\", 2, \"A jewel in the desert, known for magical academies.\", \"magocracy\", 1, 1, \"Sunstone Shard\"],\n [\"Blackfang Territory\", 2, \"Werewolf-dominated wild lands.\", \"pack hierarchy\", 0, 13, \"Fang\"],\n [\"Ironclaw Hold\", 2, \"Dwarven mining colony rich in rare ores.\", \"council\", 0, 3, \"Iron Claw\"],\n [\"Flameveil\", 2, \"A mysterious nation hidden behind walls of eternal fire.\", \"monarchy\", 0, 9, \"Veil Coin\"],\n [\"Nomad's Rest\", 2, \"The only permanent city of the desert nomads.\", \"elder council\", 1, 1, \"Rest Token\"],\n [\"Thornback Wilds\", 2, \"Beastkin territory in the rocky badlands.\", \"tribal\", 0, 7, \"Thorn Mark\"],\n ];\n countries.push(...drakthorCountries);\n\n // Continent 3-8: abbreviated for space, generating 15 each\n const continentData = [\n { id: 3, name: \"Silverwood\", races: [2, 6, 11], culture: \"elvish\" },\n { id: 4, name: \"Irondeep\", races: [3, 14, 1], culture: \"dwarven\" },\n { id: 5, name: \"Mistral Isles\", races: [16, 1, 7], culture: \"maritime\" },\n { id: 6, name: \"Shadowmere\", races: [6, 12, 9], culture: \"dark\" },\n { id: 7, name: \"Solaria\", races: [1, 7, 10], culture: \"diverse\" },\n { id: 8, name: \"Frostheim\", races: [1, 3, 13], culture: \"nordic\" },\n ];\n\n const govTypes = [\"monarchy\", \"republic\", \"theocracy\", \"tribal\", \"empire\", \"council\", \"magocracy\", \"democracy\", \"feudalism\", \"merchant council\", \"confederacy\", \"shogunate\", \"sultanate\", \"meritocracy\", \"city-state\"];\n \n for (const cont of continentData) {\n for (let i = 0; i < 15; i++) {\n const gov = govTypes[i % govTypes.length];\n const diverse = i % 3 === 0 ? 1 : 0;\n const race = cont.races[i % cont.races.length];\n countries.push([\n `${cont.name} Nation ${i + 1}`, cont.id,\n `A ${gov} in ${cont.name} with ${cont.culture} influences.`,\n gov, diverse, race, \"Gold\"\n ]);\n }\n }\n\n for (const c of countries) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO countries (name,continent_id,description,government_type,is_ethnically_diverse,primary_race_id,currency_name) VALUES (?,?,?,?,?,?,?)`,\n args: c,\n });\n }\n}\n\nasync function seedWilderness() {\n // 5-10 wilderness areas per continent\n const types = [\"forest\", \"swamp\", \"mountains\", \"plains\", \"desert\", \"tundra\", \"jungle\", \"caves\", \"volcanic\", \"haunted\"];\n for (let contId = 1; contId <= 8; contId++) {\n const count = 5 + Math.floor(contId * 0.8); // 5-10\n for (let i = 0; i < count; i++) {\n const terrain = types[(contId + i) % types.length];\n const danger = 1 + (i % 10);\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO wilderness_areas (name,continent_id,description,danger_level,terrain_type) VALUES (?,?,?,?,?)`,\n args: [`${terrain.charAt(0).toUpperCase() + terrain.slice(1)} of ${[\"Shadows\", \"Whispers\", \"Thorns\", \"Bones\", \"Mist\", \"Flame\", \"Frost\", \"Stars\", \"Doom\", \"Wonder\"][i % 10]}`, contId, `A dangerous ${terrain} wilderness.`, danger, terrain],\n });\n }\n }\n}\n\nasync function seedIslands() {\n const sizes = [\"tiny\", \"small\", \"medium\", \"large\"];\n // 50-60 islands + 30-40 city states\n for (let i = 1; i <= 60; i++) {\n const size = sizes[i % 4];\n const inhabited = i <= 45 ? 1 : 0;\n const continent = 1 + (i % 8);\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO islands (name,description,size,is_inhabited,is_city_state,nearest_continent_id) VALUES (?,?,?,?,?,?)`,\n args: [`Isle of ${[\"Coral\", \"Jade\", \"Ruby\", \"Pearl\", \"Amber\", \"Onyx\", \"Sapphire\", \"Emerald\", \"Diamond\", \"Opal\"][i % 10]} ${i}`, `A ${size} ${inhabited ? \"inhabited\" : \"uninhabited\"} island.`, size, inhabited, 0, continent],\n });\n }\n // City states (30-40)\n for (let i = 1; i <= 35; i++) {\n const continent = 1 + (i % 8);\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO islands (name,description,size,is_inhabited,is_city_state,nearest_continent_id,government_type) VALUES (?,?,?,?,?,?,?)`,\n args: [`City-State of ${[\"Azmara\", \"Brindle\", \"Calyx\", \"Delph\", \"Erynth\", \"Fyrn\", \"Galene\", \"Helios\", \"Ithara\", \"Jareth\"][i % 10]} ${i}`, `An independent island city-state.`, \"medium\", 1, 1, continent, \"city-state\"],\n });\n }\n}\n\nasync function seedLocations() {\n // Create core locations for the first few countries\n const locations = [\n // Valoria (country 1)\n [\"Valoria Capital\", \"The grand capital city with towering spires and busy markets.\", \"city\", 1, null, null, null, 0, 0, 1],\n [\"Valoria Market District\", \"A bustling marketplace with merchants from across the continent.\", \"district\", 1, null, null, 1, 1, 0, 1],\n [\"Valoria Castle\", \"The royal castle where the king holds court.\", \"building\", 1, null, null, 1, 0, 1, 1],\n [\"Valoria Training Grounds\", \"Where warriors hone their skills.\", \"training\", 1, null, null, 1, 2, 0, 1],\n [\"Valoria Magic Academy\", \"The premier school of magic in the kingdom.\", \"school\", 1, null, null, 1, -1, 1, 1],\n [\"Valoria Harbor\", \"A busy port with ships to distant lands.\", \"port\", 1, null, null, 1, 3, 0, 1],\n [\"Rosewood Village\", \"A peaceful farming village outside the capital.\", \"village\", 1, null, null, null, 5, 5, 1],\n [\"Rosewood Farm\", \"Fertile farmland available for purchase.\", \"farm\", 1, null, null, 7, 6, 5, 1],\n [\"Rosewood Inn\", \"A cozy inn where travelers rest and share stories.\", \"inn\", 1, null, null, 7, 5, 6, 1],\n [\"Deepwood Forest Entrance\", \"The edge of an ancient forest teeming with monsters.\", \"wilderness\", 1, null, null, null, 10, 10, 0],\n // Mercanis (country 2)\n [\"Mercanis Grand Bazaar\", \"The largest marketplace in the known world.\", \"city\", 2, null, null, null, 0, 0, 1],\n [\"Mercanis Port\", \"A massive port handling trade from all continents.\", \"port\", 2, null, null, 11, 1, 0, 1],\n [\"Mercanis Adventurer's Guild\", \"The central hub for adventurers.\", \"guild\", 2, null, null, 11, 0, 1, 1],\n // Gor'mak (country 16 in Drak'thor)\n [\"Gor'mak Stronghold\", \"A fortress city carved from volcanic rock.\", \"city\", 16, null, null, null, 0, 0, 1],\n [\"Gor'mak Arena\", \"A grand arena where warriors prove their worth.\", \"arena\", 16, null, null, 14, 1, 0, 0],\n // Island locations\n [\"Coral Port\", \"Main port of Isle of Coral 1.\", \"port\", null, 1, null, null, 0, 0, 1],\n [\"Azmara Central\", \"The heart of City-State of Azmara 1.\", \"city\", null, 61, null, null, 0, 0, 1],\n ];\n for (const l of locations) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO locations (name,description,location_type,country_id,island_id,wilderness_id,parent_location_id,x,y,is_safe_zone) VALUES (?,?,?,?,?,?,?,?,?,?)`,\n args: l,\n });\n }\n // Create exits between locations\n const exits = [\n [1, 2, \"east\", \"Walk to the Market District\"],\n [1, 3, \"north\", \"Approach the Castle\"],\n [1, 4, \"west\", \"Head to the Training Grounds\"],\n [1, 5, \"northwest\", \"Walk to the Magic Academy\"],\n [1, 6, \"south\", \"Go to the Harbor\"],\n [1, 7, \"northeast\", \"Travel to Rosewood Village\"],\n [2, 1, \"west\", \"Return to the Capital Center\"],\n [3, 1, \"south\", \"Leave the Castle\"],\n [4, 1, \"east\", \"Return to the Capital\"],\n [5, 1, \"southeast\", \"Leave the Academy\"],\n [6, 1, \"north\", \"Return to the Capital\"],\n [7, 1, \"southwest\", \"Travel to the Capital\"],\n [7, 8, \"east\", \"Go to the Farm\"],\n [7, 9, \"north\", \"Visit the Inn\"],\n [7, 10, \"east\", \"Enter the Forest\"],\n [8, 7, \"west\", \"Return to Village\"],\n [9, 7, \"south\", \"Leave the Inn\"],\n [10, 7, \"west\", \"Return to Village\"],\n ];\n for (const e of exits) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO location_exits (from_location_id,to_location_id,direction,description) VALUES (?,?,?,?)`,\n args: e,\n });\n }\n}\n\nasync function seedItems() {\n const items = [\n // Weapons - Melee\n [\"Iron Sword\", \"A basic but reliable iron sword.\", \"weapon\", \"sword\", 15, 0, 3.0, 50, \"common\", \"main_hand\"],\n [\"Steel Longsword\", \"A well-crafted steel longsword.\", \"weapon\", \"sword\", 25, 0, 4.0, 150, \"uncommon\", \"main_hand\"],\n [\"Battle Axe\", \"A heavy two-handed axe.\", \"weapon\", \"axe\", 35, 0, 6.0, 200, \"uncommon\", \"two_hand\"],\n [\"Dagger\", \"A small, quick dagger.\", \"weapon\", \"dagger\", 8, 0, 1.0, 25, \"common\", \"main_hand\"],\n [\"Staff\", \"A wooden staff for mages.\", \"weapon\", \"staff\", 5, 0, 2.0, 30, \"common\", \"two_hand\"],\n [\"Katana\", \"An elegant curved blade from the east.\", \"weapon\", \"sword\", 30, 0, 3.0, 300, \"rare\", \"main_hand\"],\n [\"Warhammer\", \"A devastating blunt weapon.\", \"weapon\", \"mace\", 30, 0, 5.0, 175, \"uncommon\", \"main_hand\"],\n [\"Spear\", \"A long-reaching piercing weapon.\", \"weapon\", \"polearm\", 20, 0, 4.0, 80, \"common\", \"two_hand\"],\n // Weapons - Ranged\n [\"Short Bow\", \"A simple short bow.\", \"weapon\", \"bow\", 12, 0, 2.0, 40, \"common\", \"two_hand\"],\n [\"Longbow\", \"A powerful longbow with great range.\", \"weapon\", \"bow\", 22, 0, 3.0, 120, \"uncommon\", \"two_hand\"],\n [\"Crossbow\", \"A mechanical crossbow, slow but powerful.\", \"weapon\", \"crossbow\", 28, 0, 5.0, 180, \"uncommon\", \"two_hand\"],\n [\"Throwing Stars\", \"Set of razor-sharp throwing stars.\", \"weapon\", \"thrown\", 10, 0, 0.5, 60, \"common\", \"ammo\"],\n [\"Throwing Daggers\", \"Balanced daggers designed for throwing.\", \"weapon\", \"thrown\", 12, 0, 0.8, 45, \"common\", \"ammo\"],\n [\"Iron Arrows (20)\", \"A bundle of iron arrows.\", \"ammo\", \"arrow\", 5, 0, 1.0, 10, \"common\", null],\n [\"Iron Bolts (20)\", \"A bundle of crossbow bolts.\", \"ammo\", \"bolt\", 7, 0, 1.0, 15, \"common\", null],\n // Armor\n [\"Leather Armor\", \"Basic leather protection.\", \"armor\", \"light\", 0, 10, 5.0, 60, \"common\", \"body\"],\n [\"Chain Mail\", \"Interlocking metal rings for solid defense.\", \"armor\", \"medium\", 0, 20, 12.0, 200, \"uncommon\", \"body\"],\n [\"Plate Armor\", \"Heavy full plate armor.\", \"armor\", \"heavy\", 0, 35, 25.0, 500, \"rare\", \"body\"],\n [\"Mage Robes\", \"Enchanted robes that boost magic.\", \"armor\", \"cloth\", 0, 5, 2.0, 100, \"uncommon\", \"body\"],\n [\"Iron Shield\", \"A sturdy iron shield.\", \"armor\", \"shield\", 0, 15, 6.0, 80, \"common\", \"off_hand\"],\n // Consumables\n [\"Health Potion\", \"Restores 50 HP.\", \"consumable\", \"potion\", 0, 0, 0.5, 25, \"common\", null],\n [\"Mana Potion\", \"Restores 30 MP.\", \"consumable\", \"potion\", 0, 0, 0.5, 30, \"common\", null],\n [\"Antidote\", \"Cures poison.\", \"consumable\", \"potion\", 0, 0, 0.3, 15, \"common\", null],\n [\"Bread\", \"Simple but filling bread.\", \"consumable\", \"food\", 0, 0, 0.3, 2, \"common\", null],\n [\"Grilled Fish\", \"A tasty grilled fish.\", \"consumable\", \"food\", 0, 0, 0.5, 8, \"common\", null],\n // Farming\n [\"Turnip Seeds\", \"Plant in spring for turnips.\", \"seed\", \"spring\", 0, 0, 0.1, 5, \"common\", null],\n [\"Strawberry Seeds\", \"Plant in spring for strawberries.\", \"seed\", \"spring\", 0, 0, 0.1, 15, \"common\", null],\n [\"Tomato Seeds\", \"Plant in summer for tomatoes.\", \"seed\", \"summer\", 0, 0, 0.1, 8, \"common\", null],\n [\"Pumpkin Seeds\", \"Plant in autumn for pumpkins.\", \"seed\", \"autumn\", 0, 0, 0.1, 10, \"common\", null],\n [\"Turnip\", \"A fresh turnip from the farm.\", \"crop\", \"vegetable\", 0, 0, 0.5, 10, \"common\", null],\n [\"Strawberry\", \"A sweet, red strawberry.\", \"crop\", \"fruit\", 0, 0, 0.2, 25, \"common\", null],\n // Gifts\n [\"Bouquet of Flowers\", \"A beautiful bouquet, perfect as a gift.\", \"gift\", \"romantic\", 0, 0, 0.3, 30, \"common\", null],\n [\"Chocolate Box\", \"Fine chocolates, a universally loved gift.\", \"gift\", \"romantic\", 0, 0, 0.5, 50, \"uncommon\", null],\n [\"Gemstone Ring\", \"A ring set with a sparkling gem.\", \"gift\", \"romantic\", 0, 0, 0.1, 200, \"rare\", null],\n // Misc\n [\"Fishing Rod\", \"A basic fishing rod.\", \"tool\", \"fishing\", 0, 0, 2.0, 50, \"common\", null],\n [\"Pickaxe\", \"For mining ore deposits.\", \"tool\", \"mining\", 0, 0, 4.0, 40, \"common\", null],\n [\"Watering Can\", \"For watering farm crops.\", \"tool\", \"farming\", 0, 0, 2.0, 30, \"common\", null],\n [\"Taming Collar\", \"Used to tame wild creatures.\", \"tool\", \"taming\", 0, 0, 1.0, 100, \"uncommon\", null],\n [\"Teleport Stone\", \"A one-use stone that teleports you to a waypoint.\", \"consumable\", \"magic\", 0, 0, 0.2, 500, \"rare\", null],\n ];\n for (const item of items) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO items (name,description,item_type,subtype,damage,defense,weight,value,rarity,equip_slot) VALUES (?,?,?,?,?,?,?,?,?,?)`,\n args: item,\n });\n }\n}\n\nasync function seedMonsters() {\n const monsters = [\n [\"Slime\", \"A gelatinous blob that attacks by engulfing prey.\", null, 1, 5, 30, 0, 4, 4, 1, 3, 2, 1, 1, 0, 20, \"neutral\"],\n [\"Wolf\", \"A wild wolf that hunts in packs.\", null, 1, 8, 40, 0, 6, 12, 2, 8, 4, 1, 0, 0, 30, \"aggressive\"],\n [\"Goblin Warrior\", \"A goblin armed with a crude sword.\", 14, 3, 10, 50, 10, 8, 10, 8, 10, 6, 0, 0, 0, 40, \"aggressive\"],\n [\"Forest Spider\", \"A large spider that spins webs to trap prey.\", null, 5, 15, 60, 0, 6, 14, 2, 12, 4, 0, 0, 0, 50, \"aggressive\"],\n [\"Dire Bear\", \"A massive bear far larger than normal.\", null, 8, 20, 120, 0, 18, 8, 3, 20, 4, 1, 1, 0, 60, \"neutral\"],\n [\"Skeleton\", \"An undead warrior animated by dark magic.\", 20, 5, 15, 50, 20, 10, 8, 4, 8, 2, 0, 0, 0, 0, \"aggressive\"],\n [\"Fire Elemental\", \"A being of pure fire.\", null, 15, 25, 80, 50, 4, 4, 18, 14, 6, 0, 0, 0, 0, \"aggressive\"],\n [\"Dragon Hatchling\", \"A young dragon, still very dangerous.\", null, 10, 30, 150, 60, 16, 10, 14, 12, 10, 1, 1, 1, 80, \"aggressive\"],\n [\"Trent\", \"An ancient tree spirit.\", null, 12, 25, 200, 40, 20, 2, 12, 16, 20, 1, 0, 1, 70, \"neutral\"],\n [\"Wild Horse\", \"A beautiful wild horse that can be tamed.\", null, 1, 5, 60, 0, 10, 16, 2, 10, 6, 1, 1, 0, 15, \"passive\"],\n [\"Griffin\", \"A majestic half-eagle, half-lion creature.\", null, 15, 30, 120, 20, 16, 16, 8, 12, 8, 1, 1, 1, 70, \"neutral\"],\n [\"Phoenix\", \"A legendary bird of fire that is reborn from its ashes.\", null, 25, 40, 100, 100, 8, 18, 20, 18, 8, 0, 1, 1, 95, \"neutral\"],\n [\"Minotaur\", \"A bull-headed humanoid of immense strength.\", null, 12, 25, 140, 10, 20, 8, 6, 8, 16, 0, 0, 1, 65, \"aggressive\"],\n [\"Fairy Dragon\", \"A tiny, playful dragon that uses illusion magic.\", null, 5, 15, 30, 80, 4, 18, 16, 14, 4, 1, 0, 1, 25, \"passive\"],\n [\"Kraken Spawn\", \"A lesser tentacle of the great Kraken.\", null, 20, 35, 180, 30, 18, 6, 10, 8, 16, 0, 0, 0, 0, \"aggressive\"],\n ];\n for (const m of monsters) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO monster_templates (name,description,race_id,level_min,level_max,hp,mp,str,dex,int_stat,attack,defense,is_tameable,is_mountable,is_sentient,tame_difficulty,behavior) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: m,\n });\n }\n // Spawn monsters in wilderness/dangerous locations\n const spawns = [\n [1, 10, 0.8, 10, 0], // Slimes in forest\n [2, 10, 0.6, 5, 0], // Wolves in forest\n [3, 10, 0.5, 3, 0], // Goblins in forest\n [10, 10, 0.3, 2, 0], // Wild horses in forest\n ];\n for (const s of spawns) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO monster_spawns (template_id,location_id,spawn_rate,max_count,is_boss) VALUES (?,?,?,?,?)`,\n args: s,\n });\n }\n}\n\nasync function seedCombatSkills() {\n const skills = [\n [\"Slash\", \"A basic sword attack.\", \"melee\", \"physical\", 10, 0, 5, \"melee\", 0, \"sword\", 1],\n [\"Power Strike\", \"A heavy overhead swing.\", \"melee\", \"physical\", 25, 0, 15, \"melee\", 3, \"sword\", 3],\n [\"Backstab\", \"Strike from behind for critical damage.\", \"melee\", \"physical\", 35, 0, 10, \"melee\", 5, \"dagger\", 5],\n [\"Quick Shot\", \"A rapid arrow shot.\", \"ranged\", \"physical\", 12, 0, 5, \"ranged\", 0, \"bow\", 1],\n [\"Power Shot\", \"A fully drawn, devastating arrow.\", \"ranged\", \"physical\", 30, 0, 15, \"ranged\", 4, \"bow\", 4],\n [\"Crossbow Snipe\", \"A precise crossbow shot at long range.\", \"ranged\", \"physical\", 35, 0, 10, \"ranged\", 5, \"crossbow\", 5],\n [\"Throwing Barrage\", \"Throw multiple projectiles at once.\", \"ranged\", \"physical\", 20, 0, 12, \"ranged\", 3, \"thrown\", 3],\n [\"Unarmed Strike\", \"A powerful punch or kick.\", \"melee\", \"physical\", 8, 0, 3, \"melee\", 0, null, 1],\n [\"Spinning Kick\", \"A devastating roundhouse kick.\", \"melee\", \"physical\", 20, 0, 10, \"melee\", 2, null, 4],\n [\"Shield Bash\", \"Slam your shield into the enemy.\", \"melee\", \"physical\", 12, 0, 8, \"melee\", 2, \"shield\", 2],\n [\"Berserk Rage\", \"Enter a rage, boosting damage but lowering defense.\", \"melee\", \"physical\", 40, 0, 25, \"melee\", 8, null, 8],\n [\"Flurry of Blows\", \"Rapid series of unarmed strikes.\", \"melee\", \"physical\", 30, 0, 20, \"melee\", 4, null, 6],\n ];\n for (const s of skills) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO combat_skills (name,description,skill_type,damage_type,base_damage,mp_cost,stamina_cost,range,cooldown,required_weapon_type,min_level) VALUES (?,?,?,?,?,?,?,?,?,?,?)`,\n args: s,\n });\n }\n}\n\nasync function seedGuilds() {\n const guilds = [\n [\"Valoria Adventurer's Guild\", \"adventure\", \"The premier adventurer's guild, offering quests of all difficulty.\", 1, 100, \"local\"],\n [\"Mercanis Trade Guild\", \"merchant\", \"A guild for merchants and traders across the continent.\", 11, 200, \"continental\"],\n [\"Brotherhood of Steel\", \"warrior\", \"An elite fighter's guild training the best warriors.\", 4, 150, \"local\"],\n [\"Arcane Circle\", \"mage\", \"A guild of mages dedicated to magical research.\", 5, 300, \"continental\"],\n [\"Shadow Guild\", \"thief\", \"A secretive guild operating in the shadows.\", 1, 50, \"continental\"],\n [\"Harvest Guild\", \"farming\", \"A guild for farmers, sharing techniques and seeds.\", 7, 50, \"local\"],\n [\"Fisher's Union\", \"fishing\", \"A guild for anglers and fishermen.\", 6, 30, \"local\"],\n [\"Monster Hunter's League\", \"combat\", \"Elite monster hunters taking on the most dangerous beasts.\", 13, 500, \"continental\"],\n [\"Continental Mage Association\", \"mage\", \"The largest mage guild spanning all of Aetheria.\", 11, 1000, \"continental\"],\n [\"Drak'thor War Band\", \"warrior\", \"Orcish warrior guild of Drak'thor.\", 14, 200, \"continental\"],\n ];\n for (const g of guilds) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO guilds (name,guild_type,description,location_id,join_fee,continent_scope) VALUES (?,?,?,?,?,?)`,\n args: g,\n });\n }\n}\n\nasync function seedSchools() {\n const schools = [\n [\"Valoria Royal Academy of Magic\", \"magic\", \"The kingdom's top magic academy.\", 5, 1, 500, 1],\n [\"Valoria Knight Academy\", \"combat\", \"Training the next generation of knights.\", 4, 1, 300, null],\n [\"Valoria General School\", \"general\", \"Basic education for all citizens.\", 1, 1, 50, null],\n [\"Mercanis School of Commerce\", \"general\", \"Teaching trade, negotiation, and economics.\", 11, 2, 200, null],\n [\"Mercanis Arcane Institute\", \"magic\", \"A diverse magic school welcoming all races.\", 11, 2, 400, 1],\n [\"Sunstone Academy of Destruction\", \"magic\", \"Specializing in destructive magic.\", 14, 10, 600, 1],\n [\"Silverwood Elven Academy\", \"magic\", \"Ancient elven magical traditions.\", null, null, 800, 5],\n [\"Irondeep School of Rune Magic\", \"magic\", \"Dwarven rune magic mastery.\", null, null, 700, 12],\n ];\n for (const s of schools) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO schools (name,school_type,description,location_id,country_id,enrollment_fee,magic_school_id) VALUES (?,?,?,?,?,?,?)`,\n args: s,\n });\n }\n}\n\nasync function seedNPCs() {\n // Create NPCs with jobs, families, and detailed attributes\n const npcs = [\n [\"King Aldric\", 1, 1, 1, 55, \"male\", \"The wise ruler of Valoria.\", \"ruler\", 1000, 100, 0],\n [\"Queen Elara\", 1, 5, 1, 48, \"female\", \"The compassionate queen and healer.\", \"ruler\", 900, 100, 0],\n [\"Captain Marcus\", 1, 1, 4, 35, \"male\", \"Head of the royal guard.\", \"guard_captain\", 200, 50, 0],\n [\"Merchant Galia\", 1, 1, 2, 42, \"female\", \"A shrewd merchant in the market.\", \"merchant\", 50, 30, 0],\n [\"Blacksmith Thorne\", 1, 3, 1, 55, \"male\", \"The best blacksmith in Valoria.\", \"blacksmith\", 80, 40, 0],\n [\"Healer Mira\", 2, 2, 5, 28, \"female\", \"A gentle elven healer at the temple.\", \"healer\", 60, 45, 0],\n [\"Wizard Aldous\", 1, 1, 2, 70, \"male\", \"Headmaster of the Magic Academy.\", \"teacher\", 300, 60, 0],\n [\"Innkeeper Rose\", 1, 4, 13, 38, \"female\", \"The cheerful innkeeper of Rosewood.\", \"innkeeper\", 40, 35, 0],\n [\"Farmer Dale\", 1, 1, 13, 45, \"male\", \"A hardworking farmer in Rosewood.\", \"farmer\", 20, 25, 0],\n [\"Sara\", 1, 1, 13, 22, \"female\", \"A young farmhand with dreams of adventure.\", \"farmhand\", 10, 15, 0],\n [\"Guild Master Hawk\", 1, 1, 1, 50, \"male\", \"Leader of the Adventurer's Guild.\", \"guild_master\", 500, 70, 0],\n [\"Fisher Old Tom\", 1, 1, 13, 65, \"male\", \"An old fisherman who knows every fishing spot.\", \"fisher\", 30, 40, 0],\n [\"Orc Chief Grom\", 5, 5, 11, 40, \"male\", \"The fearsome leader of Gor'mak.\", \"chief\", 800, 90, 0],\n [\"Elven Sage Lithiel\", 2, 2, 2, 350, \"female\", \"An ancient elf sage preserving old knowledge.\", \"sage\", 400, 80, 0],\n [\"Dark Elf Spy Vex\", 6, 6, 4, 120, \"male\", \"A mysterious dark elf with unknown motives.\", \"spy\", 100, 20, 0],\n [\"Beastkin Trader Fen\", 7, 7, 14, 30, \"female\", \"A fox beastkin running a curio shop.\", \"merchant\", 60, 35, 0],\n [\"Dragonborn Smith Pyra\", 8, 8, 1, 80, \"female\", \"A dragonborn who forges with her own breath.\", \"blacksmith\", 200, 55, 0],\n [\"Fairy Guide Pip\", 11, 11, 8, 200, \"other\", \"A tiny fairy who offers to guide travelers.\", \"guide\", 20, 50, 0],\n [\"Vampire Lord Kael\", 12, 12, 7, 500, \"male\", \"An ancient vampire who has renounced violence... mostly.\", \"noble\", 600, 40, 0],\n [\"Goblin Merchant Nix\", 14, 14, 14, 25, \"male\", \"A surprisingly honest goblin merchant.\", \"merchant\", 30, 25, 0],\n ];\n for (const n of npcs) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO characters (name,race_id,class_id,location_id,age,gender,biography,npc_job,reputation,gold,is_npc,hp,max_hp,mp,max_mp) VALUES (?,?,?,?,?,?,?,?,?,?,1,100,100,50,50)`,\n args: n,\n });\n }\n}\n\nasync function seedDialogs() {\n // Create dialog trees for key NPCs\n // King Aldric (character_id = 1 among NPCs, we'll use tree references)\n const trees = [\n [null, \"{}\", null, null, \"ruler\", null, null, null, 0],\n [null, \"{}\", null, null, \"merchant\", null, null, null, 0],\n [null, \"{}\", null, null, \"innkeeper\", null, null, null, 0],\n [null, \"{}\", null, null, \"blacksmith\", null, null, null, 0],\n [null, \"{}\", null, null, \"healer\", null, null, null, 0],\n [null, \"{}\", null, null, \"guild_master\", null, null, null, 0],\n [null, \"{}\", null, null, \"farmer\", null, null, null, 0],\n [null, \"{}\", null, null, \"fisher\", null, null, null, 0],\n [null, \"{}\", null, null, \"teacher\", null, null, null, 0],\n [null, \"{}\", null, null, null, null, null, 0, 10], // Low relationship generic\n ];\n for (const t of trees) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO dialog_trees (npc_id,trigger_condition,race_filter,class_filter,job_filter,age_min,age_max,relationship_min,priority) VALUES (?,?,?,?,?,?,?,?,?)`,\n args: t,\n });\n }\n\n // Dialog nodes for ruler NPCs\n const nodes = [\n // Tree 1: Ruler dialog\n [1, \"greeting\", \"npc\", \"Welcome to my court, adventurer. What brings you before the crown?\"],\n [1, \"quest\", \"npc\", \"The kingdom faces threats on many fronts. Will you aid us?\"],\n [1, \"lore\", \"npc\", \"Our kingdom was founded 500 years ago by the first King Aldric, my ancestor.\"],\n [1, \"farewell\", \"npc\", \"May the light guide your path, adventurer.\"],\n // Tree 2: Merchant dialog\n [2, \"greeting\", \"npc\", \"Welcome, welcome! Take a look at my wares. Best prices in town!\"],\n [2, \"buy\", \"npc\", \"Here's what I have for sale today.\"],\n [2, \"sell\", \"npc\", \"Let me see what you've got. I'll give you a fair price.\"],\n [2, \"haggle\", \"npc\", \"You drive a hard bargain! Fine, I can go a bit lower.\"],\n [2, \"farewell\", \"npc\", \"Come back anytime! And tell your friends!\"],\n // Tree 3: Innkeeper dialog\n [3, \"greeting\", \"npc\", \"Welcome to the inn, traveler! Need a room or perhaps a warm meal?\"],\n [3, \"room\", \"npc\", \"A room for the night costs 10 gold. Shall I prepare one?\"],\n [3, \"food\", \"npc\", \"Our special today is roast pheasant with herb potatoes. Only 5 gold!\"],\n [3, \"gossip\", \"npc\", \"I hear strange things have been happening in the forest lately...\"],\n [3, \"farewell\", \"npc\", \"Rest well, friend. The road is long.\"],\n // Tree 4: Blacksmith dialog\n [4, \"greeting\", \"npc\", \"Need something forged? You've come to the right place.\"],\n [4, \"buy\", \"npc\", \"Here's my finest work. Each piece is crafted with care.\"],\n [4, \"repair\", \"npc\", \"Bring me your damaged equipment. I'll have it good as new.\"],\n [4, \"craft\", \"npc\", \"If you have the materials, I can craft something special for you.\"],\n [4, \"farewell\", \"npc\", \"May your blade stay sharp, adventurer.\"],\n // Tree 5: Healer dialog\n [5, \"greeting\", \"npc\", \"Blessings upon you, child. Are you in need of healing?\"],\n [5, \"heal\", \"npc\", \"Let me channel the light to mend your wounds.\"],\n [5, \"cure\", \"npc\", \"Poison? Disease? I can help with both.\"],\n [5, \"farewell\", \"npc\", \"Walk in the light, dear one.\"],\n // Tree 6: Guild Master dialog\n [6, \"greeting\", \"npc\", \"Ah, an adventurer! Looking to join our guild or take on a quest?\"],\n [6, \"join\", \"npc\", \"The joining fee is 100 gold. You'll start as a Novice and work your way up.\"],\n [6, \"quest\", \"npc\", \"Here are the available quests. Choose wisely based on your skill level.\"],\n [6, \"rank\", \"npc\", \"You need to complete more quests to increase your rank.\"],\n [6, \"farewell\", \"npc\", \"Good hunting out there!\"],\n // Tree 7: Farmer dialog\n [7, \"greeting\", \"npc\", \"Howdy! Beautiful day for farming, ain't it?\"],\n [7, \"tips\", \"npc\", \"Remember to water your crops every day! And each crop has its season.\"],\n [7, \"seeds\", \"npc\", \"I can sell you some seeds if you're looking to start your own farm.\"],\n [7, \"weather\", \"npc\", \"Looks like rain tomorrow. Good for the crops!\"],\n [7, \"farewell\", \"npc\", \"Take care now! Come by if you need farming advice.\"],\n // Tree 8: Fisher dialog\n [8, \"greeting\", \"npc\", \"Ho there! Come to try your luck at fishing?\"],\n [8, \"tips\", \"npc\", \"The best fish bite at dawn and dusk. Use worms for river fish, lures for ocean.\"],\n [8, \"spots\", \"npc\", \"There's a secret fishing spot upstream. I'll mark it on your map... for a fee.\"],\n [8, \"farewell\", \"npc\", \"Tight lines, friend!\"],\n // Tree 9: Teacher dialog\n [9, \"greeting\", \"npc\", \"Welcome to the academy. Seeking knowledge?\"],\n [9, \"enroll\", \"npc\", \"Enrollment costs 500 gold. You'll learn the foundations of magic.\"],\n [9, \"study\", \"npc\", \"Which school of magic interests you? We teach all twelve.\"],\n [9, \"farewell\", \"npc\", \"Knowledge is the greatest power. Remember that.\"],\n ];\n for (const n of nodes) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO dialog_nodes (tree_id,node_key,speaker,text) VALUES (?,?,?,?)`,\n args: n,\n });\n }\n\n // Dialog options\n const options = [\n // Ruler greeting options\n [1, \"I seek a quest, Your Majesty.\", \"quest\", 1],\n [1, \"Tell me about the history of this land.\", \"lore\", 2],\n [1, \"I should be going. Farewell.\", \"farewell\", 3],\n // Merchant greeting options\n [5, \"Show me what you have for sale.\", \"buy\", 1],\n [5, \"I have some things to sell.\", \"sell\", 2],\n [5, \"Goodbye.\", \"farewell\", 3],\n // Innkeeper greeting options\n [10, \"I'd like a room.\", \"room\", 1],\n [10, \"What's on the menu?\", \"food\", 2],\n [10, \"Heard any rumors?\", \"gossip\", 3],\n [10, \"I'll be on my way.\", \"farewell\", 4],\n // Guild Master greeting options\n [25, \"I'd like to join the guild.\", \"join\", 1],\n [25, \"Any quests available?\", \"quest\", 2],\n [25, \"How do I rank up?\", \"rank\", 3],\n [25, \"See you around.\", \"farewell\", 4],\n // Teacher greeting options\n [37, \"I'd like to enroll.\", \"enroll\", 1],\n [37, \"I want to study a school of magic.\", \"study\", 2],\n [37, \"I'll come back later.\", \"farewell\", 3],\n ];\n for (const o of options) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO dialog_options (node_id,text,next_node_key,sort_order) VALUES (?,?,?,?)`,\n args: o,\n });\n }\n}\n\nasync function seedTravelRoutes() {\n const routes = [\n [\"Valoria Harbor Ferry\", 6, 12, \"boat\", 50, 30, \"A ferry service between Valoria and Mercanis.\"],\n [\"Coastal Trader Ship\", 6, 16, \"boat\", 100, 60, \"A trading ship that stops at various ports.\"],\n [\"Island Shuttle\", 6, 16, \"boat\", 30, 15, \"A small boat to nearby islands.\"],\n [\"Royal Carriage\", 1, 7, \"carriage\", 20, 10, \"A horse-drawn carriage between the capital and villages.\"],\n [\"Mage Teleporter (Valoria)\", 5, 11, \"teleport\", 200, 1, \"Instant magical teleportation between academy waypoints.\"],\n [\"Cross-Continental Ship\", 6, 14, \"boat\", 500, 120, \"A large ship sailing to Drak'thor.\"],\n ];\n for (const r of routes) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO travel_routes (name,from_location_id,to_location_id,travel_type,cost,travel_time,description) VALUES (?,?,?,?,?,?,?)`,\n args: r,\n });\n }\n}\n\nasync function seedShops() {\n const shops = [\n [\"Galia's General Store\", 2, null, \"general\", 1.0, 0.5],\n [\"Thorne's Smithy\", 2, null, \"weapon\", 1.1, 0.4],\n [\"Temple Healing Shop\", 1, null, \"potion\", 0.9, 0.5],\n [\"Rosewood Seed Shop\", 7, null, \"seed\", 1.0, 0.5],\n [\"Gor'mak War Shop\", 14, null, \"weapon\", 1.2, 0.3],\n ];\n for (const s of shops) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO shops (name,location_id,owner_npc_id,shop_type,buy_modifier,sell_modifier) VALUES (?,?,?,?,?,?)`,\n args: s,\n });\n }\n}\n\nasync function seedQuests() {\n const quests = [\n [\"Rat Problem\", \"Clear the rats from the Rosewood granary.\", \"side\", null, 1, '{\"gold\":50,\"exp\":100}', '[\"Kill 5 rats in the granary\",\"Report back to Farmer Dale\"]', 1, 0, 7],\n [\"The Missing Sword\", \"Find the blacksmith's stolen sword.\", \"side\", null, 3, '{\"gold\":150,\"exp\":300,\"item_id\":2}', '[\"Talk to witnesses\",\"Search the thieves hideout\",\"Return the sword\"]', 0, 0, 2],\n [\"Forest Investigation\", \"Investigate strange happenings in Deepwood Forest.\", \"main\", null, 5, '{\"gold\":300,\"exp\":500}', '[\"Enter the forest\",\"Find the source of corruption\",\"Defeat the corrupted treant\",\"Report to the Guild\"]', 0, 0, 10],\n [\"Guild Initiation\", \"Complete the adventurer guild's initiation test.\", \"guild\", 1, 1, '{\"gold\":100,\"exp\":200}', '[\"Defeat 3 slimes\",\"Collect 5 herbs\",\"Return to Guild Master\"]', 0, 0, 1],\n [\"Fishing Tournament\", \"Catch the biggest fish in the annual tournament.\", \"side\", 7, 1, '{\"gold\":200,\"exp\":150}', '[\"Catch 10 fish\",\"Submit your best catch\"]', 1, 0, 6],\n [\"Love Letter Delivery\", \"Deliver a love letter to the healer for a shy guard.\", \"side\", null, 1, '{\"gold\":30,\"exp\":50}', '[\"Accept the letter from the guard\",\"Deliver to Healer Mira\",\"Report back\"]', 0, 0, 1],\n [\"Dragon Sighting\", \"Investigate reports of a dragon near Drak'thor.\", \"main\", null, 15, '{\"gold\":1000,\"exp\":2000}', '[\"Travel to Drak\\'thor\",\"Find the dragon\\'s lair\",\"Negotiate or fight\",\"Return with proof\"]', 0, 1, 14],\n [\"Harvest Festival\", \"Help prepare for the seasonal harvest festival.\", \"event\", null, 1, '{\"gold\":100,\"exp\":200}', '[\"Gather 10 pumpkins\",\"Help decorate the village\",\"Attend the festival\"]', 1, 0, 7],\n ];\n for (const q of quests) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO quests (name,description,quest_type,guild_id,min_level,rewards,steps,is_repeatable,is_dynamic,location_id) VALUES (?,?,?,?,?,?,?,?,?,?)`,\n args: q,\n });\n }\n}\n\nasync function seedContentToggles() {\n // Default content toggles - all enabled by default, admin can disable\n const toggles = [\n [\"romance\", null, 1, 0, 18, null, 1, \"Romance for adult sentient beings\"],\n [\"romance\", null, 1, 0, null, 17, 0, \"Romance disabled for minors\"],\n [\"marriage\", null, 1, 0, 18, null, 1, \"Marriage for adult sentient beings\"],\n [\"marriage\", null, 1, 0, null, 17, 0, \"Marriage disabled for minors\"],\n [\"children\", null, 1, 0, 18, null, 1, \"Having children for adult sentient beings\"],\n [\"trading_sentient\", null, 1, 0, null, null, 0, \"Trading sentient beings - disabled by default\"],\n [\"trading_monster\", null, 0, 1, null, null, 1, \"Trading non-sentient monsters - enabled\"],\n [\"buying_sentient\", null, 1, 0, null, null, 0, \"Buying sentient beings - disabled by default\"],\n [\"buying_monster\", null, 0, 1, null, null, 1, \"Buying non-sentient monsters - enabled\"],\n ];\n for (const t of toggles) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO content_toggles (toggle_type,race_id,is_sentient,is_monster,age_min,age_max,is_enabled,description) VALUES (?,?,?,?,?,?,?,?)`,\n args: t,\n });\n }\n}",[],[177,244],"e5be1bec-51fa-11f1-abda-ee650bb23af1","schema.ts","019e364b-037b-778d-9380-63bc9e59f413",["D",1779027346197],"// Database schema initialization for the Fantasy MUD\n// All game data is stored in SQLite for easy modding and extension\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initSchema() {\n await sqlite.batch([\n // ==================== ACCOUNTS & AUTH ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS accounts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n email TEXT UNIQUE,\n api_key TEXT UNIQUE,\n is_admin INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now')),\n last_login TEXT\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n account_id INTEGER NOT NULL REFERENCES accounts(id),\n expires_at TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== RACES ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS races (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n description TEXT,\n base_hp INTEGER DEFAULT 100,\n base_mp INTEGER DEFAULT 50,\n base_str INTEGER DEFAULT 10,\n base_dex INTEGER DEFAULT 10,\n base_int INTEGER DEFAULT 10,\n base_wis INTEGER DEFAULT 10,\n base_con INTEGER DEFAULT 10,\n base_cha INTEGER DEFAULT 10,\n base_luk INTEGER DEFAULT 10,\n is_sentient INTEGER DEFAULT 1,\n is_playable INTEGER DEFAULT 1,\n can_speak INTEGER DEFAULT 1,\n lifespan_years INTEGER DEFAULT 80,\n size TEXT DEFAULT 'medium',\n traits TEXT DEFAULT '[]',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== CLASSES ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS classes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n description TEXT,\n hp_per_level INTEGER DEFAULT 10,\n mp_per_level INTEGER DEFAULT 5,\n str_per_level INTEGER DEFAULT 1,\n dex_per_level INTEGER DEFAULT 1,\n int_per_level INTEGER DEFAULT 1,\n wis_per_level INTEGER DEFAULT 1,\n con_per_level INTEGER DEFAULT 1,\n primary_stat TEXT DEFAULT 'str',\n allowed_races TEXT DEFAULT '[]',\n skills TEXT DEFAULT '[]',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== MAGIC SCHOOLS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS magic_schools (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n description TEXT,\n primary_stat TEXT DEFAULT 'int',\n opposing_school_id INTEGER REFERENCES magic_schools(id),\n color TEXT DEFAULT '#7c3aed',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS spells (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n school_id INTEGER REFERENCES magic_schools(id),\n description TEXT,\n mp_cost INTEGER DEFAULT 10,\n damage INTEGER DEFAULT 0,\n heal INTEGER DEFAULT 0,\n effect TEXT DEFAULT '{}',\n min_level INTEGER DEFAULT 1,\n cast_time INTEGER DEFAULT 1,\n cooldown INTEGER DEFAULT 0,\n range TEXT DEFAULT 'self',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== GEOGRAPHY ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS continents (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n description TEXT,\n climate TEXT DEFAULT 'temperate',\n size TEXT DEFAULT 'large',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS countries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n continent_id INTEGER REFERENCES continents(id),\n description TEXT,\n government_type TEXT DEFAULT 'monarchy',\n culture TEXT DEFAULT '{}',\n is_ethnically_diverse INTEGER DEFAULT 0,\n primary_race_id INTEGER REFERENCES races(id),\n currency_name TEXT DEFAULT 'gold',\n currency_exchange_rate REAL DEFAULT 1.0,\n laws TEXT DEFAULT '{}',\n traditions TEXT DEFAULT '[]',\n lore TEXT,\n history TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS wilderness_areas (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n continent_id INTEGER REFERENCES continents(id),\n description TEXT,\n danger_level INTEGER DEFAULT 1,\n terrain_type TEXT DEFAULT 'forest',\n resources TEXT DEFAULT '[]',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS islands (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT,\n size TEXT DEFAULT 'small',\n is_inhabited INTEGER DEFAULT 0,\n is_city_state INTEGER DEFAULT 0,\n nearest_continent_id INTEGER REFERENCES continents(id),\n government_type TEXT,\n primary_race_id INTEGER REFERENCES races(id),\n culture TEXT DEFAULT '{}',\n resources TEXT DEFAULT '[]',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== LOCATIONS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS locations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT,\n location_type TEXT DEFAULT 'town',\n country_id INTEGER REFERENCES countries(id),\n island_id INTEGER REFERENCES islands(id),\n wilderness_id INTEGER REFERENCES wilderness_areas(id),\n parent_location_id INTEGER REFERENCES locations(id),\n x INTEGER DEFAULT 0,\n y INTEGER DEFAULT 0,\n is_safe_zone INTEGER DEFAULT 1,\n shops TEXT DEFAULT '[]',\n services TEXT DEFAULT '[]',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS location_exits (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n from_location_id INTEGER REFERENCES locations(id),\n to_location_id INTEGER REFERENCES locations(id),\n direction TEXT NOT NULL,\n description TEXT,\n is_locked INTEGER DEFAULT 0,\n key_item_id INTEGER,\n travel_time INTEGER DEFAULT 1,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== TRAVEL SYSTEMS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS travel_routes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n from_location_id INTEGER REFERENCES locations(id),\n to_location_id INTEGER REFERENCES locations(id),\n travel_type TEXT NOT NULL,\n cost INTEGER DEFAULT 0,\n travel_time INTEGER DEFAULT 10,\n description TEXT,\n is_available INTEGER DEFAULT 1,\n required_item_id INTEGER,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== CHARACTERS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS characters (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n account_id INTEGER REFERENCES accounts(id),\n name TEXT NOT NULL,\n race_id INTEGER REFERENCES races(id),\n class_id INTEGER REFERENCES classes(id),\n level INTEGER DEFAULT 1,\n experience INTEGER DEFAULT 0,\n hp INTEGER DEFAULT 100,\n max_hp INTEGER DEFAULT 100,\n mp INTEGER DEFAULT 50,\n max_mp INTEGER DEFAULT 50,\n str INTEGER DEFAULT 10,\n dex INTEGER DEFAULT 10,\n int_stat INTEGER DEFAULT 10,\n wis INTEGER DEFAULT 10,\n con INTEGER DEFAULT 10,\n cha INTEGER DEFAULT 10,\n luk INTEGER DEFAULT 10,\n gold INTEGER DEFAULT 100,\n location_id INTEGER REFERENCES locations(id),\n gender TEXT DEFAULT 'neutral',\n age INTEGER DEFAULT 20,\n appearance TEXT DEFAULT '{}',\n biography TEXT DEFAULT '',\n title TEXT DEFAULT '',\n reputation INTEGER DEFAULT 0,\n karma INTEGER DEFAULT 0,\n is_npc INTEGER DEFAULT 0,\n npc_job TEXT,\n npc_schedule TEXT DEFAULT '{}',\n family_id INTEGER,\n clan_id INTEGER,\n is_alive INTEGER DEFAULT 1,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== ITEMS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT,\n item_type TEXT DEFAULT 'misc',\n subtype TEXT,\n damage INTEGER DEFAULT 0,\n defense INTEGER DEFAULT 0,\n weight REAL DEFAULT 1.0,\n value INTEGER DEFAULT 1,\n rarity TEXT DEFAULT 'common',\n effects TEXT DEFAULT '{}',\n requirements TEXT DEFAULT '{}',\n is_stackable INTEGER DEFAULT 0,\n max_stack INTEGER DEFAULT 99,\n is_quest_item INTEGER DEFAULT 0,\n is_gift INTEGER DEFAULT 0,\n gift_value INTEGER DEFAULT 0,\n equip_slot TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS inventory (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n character_id INTEGER REFERENCES characters(id),\n item_id INTEGER REFERENCES items(id),\n quantity INTEGER DEFAULT 1,\n is_equipped INTEGER DEFAULT 0,\n slot TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== COMBAT ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS combat_skills (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT,\n skill_type TEXT DEFAULT 'melee',\n damage_type TEXT DEFAULT 'physical',\n base_damage INTEGER DEFAULT 5,\n mp_cost INTEGER DEFAULT 0,\n stamina_cost INTEGER DEFAULT 5,\n range TEXT DEFAULT 'melee',\n cooldown INTEGER DEFAULT 0,\n required_weapon_type TEXT,\n min_level INTEGER DEFAULT 1,\n effects TEXT DEFAULT '{}',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS character_skills (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n character_id INTEGER REFERENCES characters(id),\n skill_id INTEGER,\n skill_type TEXT DEFAULT 'combat',\n proficiency INTEGER DEFAULT 1,\n experience INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== MONSTERS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS monster_templates (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT,\n race_id INTEGER REFERENCES races(id),\n level_min INTEGER DEFAULT 1,\n level_max INTEGER DEFAULT 10,\n hp INTEGER DEFAULT 50,\n mp INTEGER DEFAULT 0,\n str INTEGER DEFAULT 8,\n dex INTEGER DEFAULT 8,\n int_stat INTEGER DEFAULT 3,\n attack INTEGER DEFAULT 5,\n defense INTEGER DEFAULT 3,\n is_tameable INTEGER DEFAULT 0,\n is_mountable INTEGER DEFAULT 0,\n is_sentient INTEGER DEFAULT 0,\n tame_difficulty INTEGER DEFAULT 50,\n drops TEXT DEFAULT '[]',\n abilities TEXT DEFAULT '[]',\n behavior TEXT DEFAULT 'aggressive',\n habitat TEXT DEFAULT '[]',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS monster_spawns (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n template_id INTEGER REFERENCES monster_templates(id),\n location_id INTEGER REFERENCES locations(id),\n spawn_rate REAL DEFAULT 0.5,\n max_count INTEGER DEFAULT 5,\n is_boss INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== TAMING & MOUNTS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS tamed_creatures (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n owner_id INTEGER REFERENCES characters(id),\n template_id INTEGER REFERENCES monster_templates(id),\n name TEXT,\n level INTEGER DEFAULT 1,\n hp INTEGER DEFAULT 50,\n max_hp INTEGER DEFAULT 50,\n happiness INTEGER DEFAULT 50,\n loyalty INTEGER DEFAULT 50,\n is_mount INTEGER DEFAULT 0,\n is_active INTEGER DEFAULT 0,\n stats TEXT DEFAULT '{}',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== RELATIONSHIPS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS relationships (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n character_a_id INTEGER REFERENCES characters(id),\n character_b_id INTEGER REFERENCES characters(id),\n relationship_type TEXT DEFAULT 'acquaintance',\n affection INTEGER DEFAULT 0,\n friendship INTEGER DEFAULT 0,\n is_romantic INTEGER DEFAULT 0,\n is_married INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now')),\n UNIQUE(character_a_id, character_b_id)\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS families (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n head_of_family_id INTEGER REFERENCES characters(id),\n clan_id INTEGER,\n lore TEXT,\n reputation INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS children (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n parent_a_id INTEGER REFERENCES characters(id),\n parent_b_id INTEGER REFERENCES characters(id),\n child_character_id INTEGER REFERENCES characters(id),\n age_stage TEXT DEFAULT 'child',\n can_age_up INTEGER DEFAULT 0,\n age_up_consented INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== DIALOG ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS dialog_trees (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n npc_id INTEGER REFERENCES characters(id),\n trigger_condition TEXT DEFAULT '{}',\n race_filter TEXT,\n class_filter TEXT,\n job_filter TEXT,\n age_min INTEGER,\n age_max INTEGER,\n relationship_min INTEGER,\n priority INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS dialog_nodes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n tree_id INTEGER REFERENCES dialog_trees(id),\n node_key TEXT NOT NULL,\n speaker TEXT DEFAULT 'npc',\n text TEXT NOT NULL,\n condition TEXT DEFAULT '{}',\n effects TEXT DEFAULT '{}',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS dialog_options (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n node_id INTEGER REFERENCES dialog_nodes(id),\n text TEXT NOT NULL,\n next_node_key TEXT,\n condition TEXT DEFAULT '{}',\n effects TEXT DEFAULT '{}',\n sort_order INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== QUESTS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS quests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT,\n quest_type TEXT DEFAULT 'main',\n guild_id INTEGER,\n min_level INTEGER DEFAULT 1,\n rewards TEXT DEFAULT '{}',\n steps TEXT DEFAULT '[]',\n is_repeatable INTEGER DEFAULT 0,\n is_dynamic INTEGER DEFAULT 0,\n location_id INTEGER REFERENCES locations(id),\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS character_quests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n character_id INTEGER REFERENCES characters(id),\n quest_id INTEGER REFERENCES quests(id),\n status TEXT DEFAULT 'active',\n current_step INTEGER DEFAULT 0,\n progress TEXT DEFAULT '{}',\n assigned_to_follower_id INTEGER REFERENCES characters(id),\n started_at TEXT DEFAULT (datetime('now')),\n completed_at TEXT\n )`\n },\n // ==================== GUILDS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS guilds (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n guild_type TEXT DEFAULT 'adventure',\n description TEXT,\n location_id INTEGER REFERENCES locations(id),\n join_fee INTEGER DEFAULT 100,\n ranks TEXT DEFAULT '[\"Novice\",\"Apprentice\",\"Journeyman\",\"Expert\",\"Master\",\"Grandmaster\"]',\n lore TEXT,\n continent_scope TEXT DEFAULT 'local',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS guild_members (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n guild_id INTEGER REFERENCES guilds(id),\n character_id INTEGER REFERENCES characters(id),\n rank INTEGER DEFAULT 0,\n reputation INTEGER DEFAULT 0,\n joined_at TEXT DEFAULT (datetime('now')),\n UNIQUE(guild_id, character_id)\n )`\n },\n // ==================== SCHOOLS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS schools (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n school_type TEXT DEFAULT 'magic',\n description TEXT,\n location_id INTEGER REFERENCES locations(id),\n country_id INTEGER REFERENCES countries(id),\n enrollment_fee INTEGER DEFAULT 500,\n courses TEXT DEFAULT '[]',\n ranks TEXT DEFAULT '[\"Student\",\"Graduate\",\"Instructor\",\"Dean\"]',\n magic_school_id INTEGER REFERENCES magic_schools(id),\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== FARMING & HOUSING ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS properties (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n owner_id INTEGER REFERENCES characters(id),\n name TEXT NOT NULL,\n property_type TEXT DEFAULT 'house',\n location_id INTEGER REFERENCES locations(id),\n size TEXT DEFAULT 'small',\n rooms TEXT DEFAULT '[]',\n furniture TEXT DEFAULT '[]',\n farm_plots INTEGER DEFAULT 0,\n value INTEGER DEFAULT 1000,\n upgrades TEXT DEFAULT '[]',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS farm_plots (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n property_id INTEGER REFERENCES properties(id),\n crop_item_id INTEGER REFERENCES items(id),\n planted_at TEXT,\n harvest_at TEXT,\n quality INTEGER DEFAULT 1,\n is_watered INTEGER DEFAULT 0,\n growth_stage INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS construction_projects (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n owner_id INTEGER REFERENCES characters(id),\n location_id INTEGER REFERENCES locations(id),\n project_type TEXT DEFAULT 'house',\n name TEXT,\n required_resources TEXT DEFAULT '{}',\n supplied_resources TEXT DEFAULT '{}',\n progress INTEGER DEFAULT 0,\n total_work INTEGER DEFAULT 100,\n assigned_workers TEXT DEFAULT '[]',\n status TEXT DEFAULT 'planning',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== ECONOMY & TRADE ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS shops (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n location_id INTEGER REFERENCES locations(id),\n owner_npc_id INTEGER REFERENCES characters(id),\n shop_type TEXT DEFAULT 'general',\n buy_modifier REAL DEFAULT 1.0,\n sell_modifier REAL DEFAULT 0.5,\n inventory TEXT DEFAULT '[]',\n restock_interval INTEGER DEFAULT 24,\n last_restock TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS trade_routes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n from_country_id INTEGER REFERENCES countries(id),\n to_country_id INTEGER REFERENCES countries(id),\n goods TEXT DEFAULT '[]',\n volume INTEGER DEFAULT 100,\n is_active INTEGER DEFAULT 1,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS trade_offers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n from_character_id INTEGER REFERENCES characters(id),\n to_character_id INTEGER REFERENCES characters(id),\n offered_items TEXT DEFAULT '[]',\n offered_gold INTEGER DEFAULT 0,\n requested_items TEXT DEFAULT '[]',\n requested_gold INTEGER DEFAULT 0,\n status TEXT DEFAULT 'pending',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== FOLLOWERS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS followers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n leader_id INTEGER REFERENCES characters(id),\n follower_id INTEGER REFERENCES characters(id),\n role TEXT DEFAULT 'companion',\n current_order TEXT DEFAULT 'follow',\n order_details TEXT DEFAULT '{}',\n loyalty INTEGER DEFAULT 50,\n is_active INTEGER DEFAULT 1,\n created_at TEXT DEFAULT (datetime('now')),\n UNIQUE(leader_id, follower_id)\n )`\n },\n // ==================== SOCIAL / MESSAGING ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS friend_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n from_account_id INTEGER REFERENCES accounts(id),\n to_account_id INTEGER REFERENCES accounts(id),\n status TEXT DEFAULT 'pending',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n from_account_id INTEGER REFERENCES accounts(id),\n to_account_id INTEGER REFERENCES accounts(id),\n subject TEXT,\n body TEXT NOT NULL,\n is_read INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== CALENDAR & SEASONS ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS game_calendar (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n current_day INTEGER DEFAULT 1,\n current_season TEXT DEFAULT 'spring',\n current_year INTEGER DEFAULT 1,\n days_per_season INTEGER DEFAULT 28,\n seasons TEXT DEFAULT '[\"spring\",\"summer\",\"autumn\",\"winter\"]',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== CONTENT TOGGLES ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS content_toggles (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n toggle_type TEXT NOT NULL,\n race_id INTEGER REFERENCES races(id),\n is_sentient INTEGER,\n is_monster INTEGER,\n age_min INTEGER,\n age_max INTEGER,\n is_enabled INTEGER DEFAULT 1,\n description TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== LANGUAGES ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS languages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n description TEXT,\n difficulty INTEGER DEFAULT 1,\n primary_race_id INTEGER REFERENCES races(id),\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS character_languages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n character_id INTEGER REFERENCES characters(id),\n language_id INTEGER REFERENCES languages(id),\n proficiency INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now')),\n UNIQUE(character_id, language_id)\n )`\n },\n // ==================== CLANS & TRIBES ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS clans (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n country_id INTEGER REFERENCES countries(id),\n leader_id INTEGER REFERENCES characters(id),\n description TEXT,\n traditions TEXT DEFAULT '[]',\n reputation INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // ==================== GAME LOG ====================\n {\n sql: `CREATE TABLE IF NOT EXISTS game_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n character_id INTEGER REFERENCES characters(id),\n event_type TEXT NOT NULL,\n message TEXT NOT NULL,\n data TEXT DEFAULT '{}',\n created_at TEXT DEFAULT (datetime('now'))\n )`\n },\n // Initialize calendar if empty\n {\n sql: `INSERT OR IGNORE INTO game_calendar (id, current_day, current_season, current_year) VALUES (1, 1, 'spring', 1)`\n }\n ]);\n}\n",[],[177,251],["D",1779027346197],[198,199],[177],"076b14a2-51fb-11f1-8f20-ee650bb23af1","routes.ts","019e364b-037b-778d-9380-598f6174896c",3,["D",1779027402816],2,"// All API routes for the Fantasy MUD - authenticated via session or API key\nimport { Hono } from \"npm:hono@4\";\nimport { authenticate, requireAuth, register, login, logout } from \"../lib/auth.ts\";\nimport * as engine from \"../lib/game-engine.ts\";\n\nconst api = new Hono();\n\n// Helper to get active character for the account\nasync function getActiveChar(accountId: number, charId?: number) {\n if (charId) {\n const char = await engine.getCharacterFull(charId) as any;\n if (!char || char.account_id !== accountId) throw new Error(\"Character not found or not yours\");\n return char;\n }\n const chars = await engine.getCharactersByAccount(accountId);\n if (chars.length === 0) throw new Error(\"No characters found. Create one first.\");\n return chars[0];\n}\n\nfunction json(data: any, status = 200) {\n return new Response(JSON.stringify(data), { status, headers: { \"Content-Type\": \"application/json\" } });\n}\n\nfunction err(message: string, status = 400) {\n return json({ error: message }, status);\n}\n\n// ==================== AUTH ====================\napi.post(\"/auth/register\", async (c) => {\n try {\n const body = await c.req.json();\n const account = await register(body.username, body.password, body.email);\n return json({ ok: true, account });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/auth/login\", async (c) => {\n try {\n const body = await c.req.json();\n const { sessionId, account } = await login(body.username, body.password);\n const res = json({ ok: true, account });\n // Set cookie for browser clients\n const headers = new Headers(res.headers);\n headers.set(\"Set-Cookie\", `session=${sessionId}; Path=/; HttpOnly; SameSite=Lax; Max-Age=${7 * 24 * 3600}`);\n return new Response(res.body, { status: 200, headers });\n } catch (e: any) { return err(e.message, 401); }\n});\n\napi.post(\"/auth/logout\", async (c) => {\n const cookies = c.req.header(\"cookie\") || \"\";\n const match = cookies.match(/session=([^;]+)/);\n if (match) await logout(match[1]);\n const headers = new Headers();\n headers.set(\"Set-Cookie\", \"session=; Path=/; HttpOnly; Max-Age=0\");\n headers.set(\"Content-Type\", \"application/json\");\n return new Response(JSON.stringify({ ok: true }), { status: 200, headers });\n});\n\napi.get(\"/auth/me\", async (c) => {\n const account = await authenticate(c.req.raw);\n if (!account) return err(\"Not logged in\", 401);\n return json({ ok: true, account });\n});\n\n// ==================== REFERENCE DATA (public) ====================\napi.get(\"/data/races\", async () => json(await engine.getRaces()));\napi.get(\"/data/classes\", async () => json(await engine.getClasses()));\napi.get(\"/data/magic-schools\", async () => json(await engine.getMagicSchools()));\napi.get(\"/data/spells\", async () => json(await engine.getSpells()));\napi.get(\"/data/guilds\", async () => json(await engine.getAllGuilds()));\napi.get(\"/data/quests\", async () => json(await engine.getAllQuests()));\napi.get(\"/data/continents\", async () => json(await engine.getContinents()));\napi.get(\"/data/countries\", async (c) => {\n const contId = c.req.query(\"continent_id\");\n return json(await engine.getCountries(contId ? parseInt(contId) : undefined));\n});\napi.get(\"/data/islands\", async () => json(await engine.getIslands()));\napi.get(\"/data/calendar\", async () => json(await engine.getCalendar()));\n\n// ==================== CHARACTER ====================\napi.post(\"/characters\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await engine.createCharacter(account.id, body);\n return json({ ok: true, character: char });\n } catch (e: any) { return err(e.message); }\n});\n\napi.get(\"/characters\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const chars = await engine.getCharactersByAccount(account.id);\n return json(chars);\n } catch (e: any) { return err(e.message, 401); }\n});\n\napi.get(\"/characters/:id\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const char = await getActiveChar(account.id, parseInt(c.req.param(\"id\")));\n return json(char);\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== GAME ACTIONS ====================\napi.post(\"/game/look\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json().catch(() => ({}));\n const char = await getActiveChar(account.id, body.character_id);\n const location = await engine.look(char.id);\n return json({ ok: true, location });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/move\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.move(char.id, body.direction);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/attack\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.attack(char.id, body.target_type, body.target_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/cast\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.castSpell(char.id, body.spell_id, body.target_type, body.target_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== INVENTORY ====================\napi.get(\"/game/inventory/:charId\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const char = await getActiveChar(account.id, parseInt(c.req.param(\"charId\")));\n const inv = await engine.getInventory(char.id);\n return json(inv);\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/equip\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.equipItem(char.id, body.inventory_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== DIALOG ====================\napi.post(\"/game/dialog/start\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const dialog = await engine.startDialog(char.id, body.npc_id);\n return json({ ok: true, dialog });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/dialog/continue\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const dialog = await engine.continueDialog(char.id, body.tree_id, body.node_key);\n return json({ ok: true, dialog });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== SHOPS ====================\napi.get(\"/game/shop/:shopId/items\", async (c) => {\n try {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const shopId = parseInt(c.req.param(\"shopId\"));\n const shop = await sqlite.execute({ sql: \"SELECT * FROM shops WHERE id = ?\", args: [shopId] });\n if (shop.rows.length === 0) return err(\"Shop not found\");\n const s = shop.rows[0] as any;\n // Get items appropriate for shop type\n let itemFilter = \"\";\n if (s.shop_type === \"weapon\") itemFilter = \"AND (item_type = 'weapon' OR item_type = 'ammo' OR item_type = 'armor')\";\n else if (s.shop_type === \"potion\") itemFilter = \"AND (item_type = 'consumable')\";\n else if (s.shop_type === \"seed\") itemFilter = \"AND (item_type = 'seed' OR item_type = 'tool')\";\n else itemFilter = \"AND item_type NOT IN ('quest')\";\n const items = await sqlite.execute({\n sql: `SELECT *, CAST(value * ${s.buy_modifier} AS INTEGER) as buy_price, CAST(value * ${s.sell_modifier} AS INTEGER) as sell_price FROM items WHERE is_quest_item = 0 ${itemFilter} ORDER BY item_type, value`,\n });\n return json({ shop: s, items: items.rows });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/shop/buy\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.buyFromShop(char.id, body.shop_id, body.item_id, body.quantity || 1);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/shop/sell\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.sellToShop(char.id, body.shop_id, body.item_id, body.quantity || 1);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== TRADING ====================\napi.post(\"/game/trade/offer\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.createTradeOffer(char.id, body.to_character_id, body.offered_items || [], body.offered_gold || 0, body.requested_items || [], body.requested_gold || 0);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/trade/respond\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.respondToTrade(body.trade_id, char.id, body.accept);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== RELATIONSHIPS ====================\napi.post(\"/game/gift\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.giveGift(char.id, body.target_id, body.item_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/propose\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.proposeMarriage(char.id, body.target_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== GUILDS ====================\napi.post(\"/game/guild/join\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.joinGuild(char.id, body.guild_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== QUESTS ====================\napi.post(\"/game/quest/accept\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.acceptQuest(char.id, body.quest_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.get(\"/game/quests/:charId\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const char = await getActiveChar(account.id, parseInt(c.req.param(\"charId\")));\n const quests = await engine.getActiveQuests(char.id);\n return json(quests);\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== FOLLOWERS ====================\napi.post(\"/game/follower/recruit\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.recruitFollower(char.id, body.follower_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/follower/order\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.orderFollower(char.id, body.follower_id, body.order, body.details);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.get(\"/game/followers/:charId\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const char = await getActiveChar(account.id, parseInt(c.req.param(\"charId\")));\n const followers = await engine.getFollowers(char.id);\n return json(followers);\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== TAMING ====================\napi.post(\"/game/tame\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.tamCreature(char.id, body.spawn_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.get(\"/game/tamed/:charId\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const char = await getActiveChar(account.id, parseInt(c.req.param(\"charId\")));\n const tamed = await engine.getTamedCreatures(char.id);\n return json(tamed);\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== FARMING ====================\napi.post(\"/game/farm/plant\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.plantCrop(char.id, body.plot_id, body.seed_item_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/farm/water\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.waterCrop(char.id, body.plot_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/game/farm/harvest\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.harvestCrop(char.id, body.plot_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== CONSTRUCTION ====================\napi.post(\"/game/build\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.startConstruction(char.id, body.location_id || char.location_id, body.project_type, body.name);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== TRAVEL ====================\napi.post(\"/game/travel\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const result = await engine.useTravel(char.id, body.route_id);\n return json({ ok: true, ...result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== GAME LOG ====================\napi.get(\"/game/log/:charId\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const char = await getActiveChar(account.id, parseInt(c.req.param(\"charId\")));\n const log = await engine.getGameLog(char.id, parseInt(c.req.query(\"limit\") || \"20\"));\n return json(log);\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== CALENDAR ====================\napi.post(\"/game/advance-day\", async (c) => {\n try {\n await requireAuth(c.req.raw);\n const result = await engine.advanceDay();\n return json({ ok: true, calendar: result });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== EXPORT / IMPORT ====================\napi.get(\"/export/character/:charId\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const char = await getActiveChar(account.id, parseInt(c.req.param(\"charId\")));\n const data = await engine.exportCharacter(char.id);\n return json(data);\n } catch (e: any) { return err(e.message); }\n});\n\napi.get(\"/export/world\", async (c) => {\n try {\n await requireAuth(c.req.raw);\n const data = await engine.exportWorld();\n return json(data);\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== SOCIAL (friend requests, messages) ====================\napi.post(\"/social/friend-request\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n await sqlite.execute({\n sql: \"INSERT INTO friend_requests (from_account_id, to_account_id) VALUES (?, ?)\",\n args: [account.id, body.to_account_id],\n });\n return json({ ok: true, message: \"Friend request sent!\" });\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/social/friend-request/respond\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const status = body.accept ? \"accepted\" : \"rejected\";\n await sqlite.execute({\n sql: \"UPDATE friend_requests SET status = ? WHERE id = ? AND to_account_id = ?\",\n args: [status, body.request_id, account.id],\n });\n return json({ ok: true, message: `Friend request ${status}` });\n } catch (e: any) { return err(e.message); }\n});\n\napi.get(\"/social/friend-requests\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const result = await sqlite.execute({\n sql: `SELECT fr.*, a.username as from_username FROM friend_requests fr JOIN accounts a ON fr.from_account_id = a.id WHERE fr.to_account_id = ? AND fr.status = 'pending'`,\n args: [account.id],\n });\n return json(result.rows);\n } catch (e: any) { return err(e.message); }\n});\n\napi.get(\"/social/friends\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const result = await sqlite.execute({\n sql: `SELECT a.id, a.username FROM friend_requests fr JOIN accounts a ON (CASE WHEN fr.from_account_id = ? THEN fr.to_account_id ELSE fr.from_account_id END) = a.id WHERE (fr.from_account_id = ? OR fr.to_account_id = ?) AND fr.status = 'accepted'`,\n args: [account.id, account.id, account.id],\n });\n return json(result.rows);\n } catch (e: any) { return err(e.message); }\n});\n\napi.post(\"/social/message\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n // Check if they're friends\n const friends = await sqlite.execute({\n sql: `SELECT id FROM friend_requests WHERE ((from_account_id = ? AND to_account_id = ?) OR (from_account_id = ? AND to_account_id = ?)) AND status = 'accepted'`,\n args: [account.id, body.to_account_id, body.to_account_id, account.id],\n });\n if (friends.rows.length === 0) throw new Error(\"You can only message friends\");\n await sqlite.execute({\n sql: \"INSERT INTO messages (from_account_id, to_account_id, subject, body) VALUES (?, ?, ?, ?)\",\n args: [account.id, body.to_account_id, body.subject || \"\", body.body],\n });\n return json({ ok: true, message: \"Message sent!\" });\n } catch (e: any) { return err(e.message); }\n});\n\napi.get(\"/social/messages\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const result = await sqlite.execute({\n sql: `SELECT m.*, a.username as from_username FROM messages m JOIN accounts a ON m.from_account_id = a.id WHERE m.to_account_id = ? ORDER BY m.created_at DESC LIMIT 50`,\n args: [account.id],\n });\n return json(result.rows);\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== WORLD MAP ====================\napi.get(\"/world/continents\", async () => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const continents = await sqlite.execute(\"SELECT * FROM continents ORDER BY id\");\n const result = [];\n for (const c of continents.rows as any[]) {\n const countries = await sqlite.execute({ sql: \"SELECT id, name, government_type, is_ethnically_diverse FROM countries WHERE continent_id = ?\", args: [c.id] });\n const wilderness = await sqlite.execute({ sql: \"SELECT id, name, danger_level, terrain_type FROM wilderness_areas WHERE continent_id = ?\", args: [c.id] });\n result.push({ ...c, countries: countries.rows, wilderness: wilderness.rows });\n }\n return json(result);\n});\n\napi.get(\"/world/countries/:id\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const id = parseInt(c.req.param(\"id\"));\n const country = await sqlite.execute({ sql: \"SELECT c.*, cont.name as continent_name FROM countries c JOIN continents cont ON c.continent_id = cont.id WHERE c.id = ?\", args: [id] });\n if (country.rows.length === 0) return err(\"Country not found\");\n const locations = await sqlite.execute({ sql: \"SELECT id, name, location_type, is_safe_zone FROM locations WHERE country_id = ?\", args: [id] });\n return json({ ...country.rows[0], locations: locations.rows });\n});\n\napi.get(\"/world/islands\", async () => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const islands = await sqlite.execute(\"SELECT i.*, c.name as continent_name FROM islands i LEFT JOIN continents c ON i.nearest_continent_id = c.id ORDER BY i.is_city_state DESC, i.name\");\n return json(islands.rows);\n});\n\n// ==================== FISHING ====================\napi.post(\"/game/fish\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json().catch(() => ({}));\n const char = await getActiveChar(account.id, body.character_id);\n // Check if has fishing rod\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const rod = await sqlite.execute({ sql: \"SELECT id FROM inventory WHERE character_id = ? AND item_id = 35\", args: [char.id] });\n if (rod.rows.length === 0) return err(\"You need a Fishing Rod! Buy one from a shop.\");\n // Random fish catch\n const fishTypes = [\n { name: \"Small Trout\", value: 5, exp: 10 },\n { name: \"River Bass\", value: 12, exp: 20 },\n { name: \"Golden Carp\", value: 30, exp: 50 },\n { name: \"Silver Salmon\", value: 25, exp: 40 },\n { name: \"Giant Catfish\", value: 50, exp: 80 },\n { name: \"Mystic Koi\", value: 100, exp: 150 },\n { name: \"Old Boot\", value: 1, exp: 5 },\n ];\n const luck = (char as any).luk || 10;\n const roll = Math.random() * 100;\n const fishIndex = roll < 5 + luck ? 5 : roll < 15 + luck ? 4 : roll < 30 ? 3 : roll < 50 ? 2 : roll < 80 ? 1 : roll < 95 ? 0 : 6;\n const fish = fishTypes[fishIndex];\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold + ?, experience = experience + ? WHERE id = ?\", args: [fish.value, fish.exp, char.id] });\n return json({ ok: true, message: `🐟 You caught a ${fish.name}! Earned ${fish.value} gold and ${fish.exp} exp!`, fish: fish.name, value: fish.value, exp: fish.exp });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== USE ITEM ====================\napi.post(\"/game/use-item\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json();\n const char = await getActiveChar(account.id, body.character_id);\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const inv = await sqlite.execute({\n sql: \"SELECT i.*, it.* FROM inventory i JOIN items it ON i.item_id = it.id WHERE i.id = ? AND i.character_id = ?\",\n args: [body.inventory_id, char.id],\n });\n if (inv.rows.length === 0) return err(\"Item not found in inventory\");\n const item = inv.rows[0] as any;\n if (item.item_type !== \"consumable\") return err(\"This item cannot be used\");\n // Apply effects\n const results: string[] = [];\n if (item.subtype === \"potion\") {\n if (item.name.includes(\"Health\")) {\n await sqlite.execute({ sql: \"UPDATE characters SET hp = MIN(max_hp, hp + 50) WHERE id = ?\", args: [char.id] });\n results.push(\"Restored 50 HP!\");\n } else if (item.name.includes(\"Mana\")) {\n await sqlite.execute({ sql: \"UPDATE characters SET mp = MIN(max_mp, mp + 30) WHERE id = ?\", args: [char.id] });\n results.push(\"Restored 30 MP!\");\n } else if (item.name.includes(\"Antidote\")) {\n results.push(\"Cured all poisons!\");\n } else if (item.name.includes(\"Elixir\")) {\n await sqlite.execute({ sql: \"UPDATE characters SET hp = max_hp, mp = max_mp WHERE id = ?\", args: [char.id] });\n results.push(\"Fully restored HP and MP!\");\n }\n } else if (item.subtype === \"food\") {\n await sqlite.execute({ sql: \"UPDATE characters SET hp = MIN(max_hp, hp + 10) WHERE id = ?\", args: [char.id] });\n results.push(`Ate ${item.name}. Restored 10 HP!`);\n }\n // Remove from inventory\n await engine.removeFromInventory(char.id, item.item_id, 1);\n return json({ ok: true, results, message: results.join(\" \") });\n } catch (e: any) { return err(e.message); }\n});\n\n// ==================== REST / HEAL AT INN ====================\napi.post(\"/game/rest\", async (c) => {\n try {\n const account = await requireAuth(c.req.raw);\n const body = await c.req.json().catch(() => ({}));\n const char = await getActiveChar(account.id, body.character_id);\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const cData = char as any;\n if (cData.gold < 10) return err(\"Not enough gold (10g for rest)\");\n await sqlite.execute({ sql: \"UPDATE characters SET hp = max_hp, mp = max_mp, gold = gold - 10 WHERE id = ?\", args: [cData.id] });\n return json({ ok: true, message: \"🛏️ You rest at the inn. HP and MP fully restored! (-10g)\" });\n } catch (e: any) { return err(e.message); }\n});\n\nexport default api;\n",[],[182,261],["D",1779027346197],[196],[182],["D",1779027346197],["D",1789495880338],{"_11":12,"_37":38},{"_11":12,"_58":38,"_59":38,"_42":67,"_60":61,"_62":20},{"_92":93,"_13":94,"_27":95,"_96":63,"_97":98,"_99":100,"_101":33,"_102":28,"_103":104,"_105":14,"_106":12},"ctx",{"_34":-5,"_129":310,"_311":312,"_313":314,"_315":20,"_316":20,"_317":20,"_318":53,"_319":-5,"_320":-7,"_321":-7,"_322":22,"_323":20,"_324":20,"_325":-5,"_326":20,"_327":20,"_328":20,"_329":-5},"ENV",{"_281":282,"_283":284,"_285":94,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Remixes1

Remixes
1