⚔️ Fantasy MUD - A Multiplayer Text Adventure

\n \n \n\n\n",[],[253,244],"gui","aedc2cd2-5203-11f1-b9d1-ee650bb23af1",["D",1779031119624],[201],[253],"faf6eaee-5203-11f1-91ca-ee650bb23af1","seed.ts","019e3684-9748-774e-8bea-c5f5ba2e9bf2","019e3684-9748-774e-8bea-cabb6d8aff10",8,["D",1779031247391],"// 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 // Format: [name, race_id, class_id, location_id, age, gender, biography, npc_job, reputation, gold]\n const npcs = [\n // Valoria Capital (location 1)\n [\"King Aldric\", 1, 1, 3, 55, \"male\", \"The wise ruler of Valoria.\", \"ruler\", 1000, 5000],\n [\"Queen Elara\", 1, 5, 3, 48, \"female\", \"The compassionate queen and healer.\", \"ruler\", 900, 5000],\n [\"Captain Marcus\", 1, 1, 4, 35, \"male\", \"Head of the royal guard.\", \"guard_captain\", 200, 500],\n [\"Guild Master Hawk\", 1, 1, 1, 50, \"male\", \"Leader of the Adventurer's Guild.\", \"guild_master\", 500, 2000],\n // Market District (location 2)\n [\"Merchant Galia\", 1, 14, 2, 42, \"female\", \"A shrewd merchant in the market.\", \"merchant\", 50, 3000],\n [\"Blacksmith Thorne\", 3, 1, 2, 55, \"male\", \"The best blacksmith in Valoria.\", \"blacksmith\", 80, 2000],\n // Castle (location 3) - King & Queen are here\n // Training Grounds (location 4)\n // Magic Academy (location 5)\n [\"Healer Mira\", 2, 5, 5, 128, \"female\", \"A gentle elven healer at the temple.\", \"healer\", 60, 500],\n [\"Wizard Aldous\", 1, 2, 5, 70, \"male\", \"Headmaster of the Magic Academy.\", \"teacher\", 300, 3000],\n // Harbor (location 6)\n [\"Harbor Master Finn\", 1, 14, 6, 52, \"male\", \"Manages all ship traffic and cargo.\", \"harbor_master\", 120, 1500],\n // Rosewood Village (location 7)\n [\"Farmer Dale\", 1, 13, 7, 45, \"male\", \"A hardworking farmer in Rosewood.\", \"farmer\", 20, 200],\n [\"Sara\", 1, 13, 7, 22, \"female\", \"A young farmhand with dreams of adventure.\", \"farmhand\", 10, 50],\n // Rosewood Farm (location 8)\n [\"Old MacDougal\", 1, 13, 8, 67, \"male\", \"A veteran farmer who knows every crop.\", \"farmer\", 40, 400],\n // Rosewood Inn (location 9)\n [\"Innkeeper Rose\", 4, 14, 9, 38, \"female\", \"The cheerful innkeeper of Rosewood.\", \"innkeeper\", 40, 800],\n [\"Fisher Old Tom\", 1, 13, 9, 65, \"male\", \"An old fisherman who knows every fishing spot.\", \"fisher\", 30, 200],\n // Deepwood Forest (location 10) - dangerous area\n [\"Forest Ranger Elindra\", 2, 3, 10, 200, \"female\", \"An elven ranger who patrols the forest edge.\", \"ranger\", 80, 300],\n // Mercanis (location 11)\n [\"Orc Chief Grom\", 5, 11, 14, 40, \"male\", \"The fearsome leader of Gor'mak.\", \"chief\", 800, 5000],\n [\"Elven Sage Lithiel\", 2, 2, 11, 350, \"female\", \"An ancient elf sage preserving old knowledge.\", \"sage\", 400, 2000],\n // Mercanis Port (location 12)\n [\"Dark Elf Spy Vex\", 6, 4, 12, 120, \"male\", \"A mysterious dark elf with unknown motives.\", \"spy\", 100, 1000],\n // Mercanis Guild (location 13)\n [\"Beastkin Trader Fen\", 7, 14, 13, 30, \"female\", \"A fox beastkin running a curio shop.\", \"merchant\", 60, 1500],\n // Gor'mak (location 14)\n [\"Dragonborn Smith Pyra\", 8, 1, 14, 80, \"female\", \"A dragonborn who forges with her own breath.\", \"blacksmith\", 200, 3000],\n // Gor'mak Arena (location 15)\n [\"Arena Champion Krag\", 5, 11, 15, 32, \"male\", \"Undefeated champion of the arena.\", \"champion\", 500, 4000],\n // Fairy Guide at various places\n [\"Fairy Guide Pip\", 11, 8, 1, 200, \"other\", \"A tiny fairy who offers to guide travelers.\", \"guide\", 20, 100],\n [\"Vampire Lord Kael\", 12, 7, 11, 500, \"male\", \"An ancient vampire who has renounced violence... mostly.\", \"noble\", 600, 10000],\n [\"Goblin Merchant Nix\", 14, 14, 14, 25, \"male\", \"A surprisingly honest goblin merchant.\", \"merchant\", 30, 800],\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}",[],[267,259],"db","aeda21f8-5203-11f1-b9d1-ee650bb23af1","schema.ts","019e3684-9748-774e-8bea-c1a74032923b",["D",1779031119624],"// 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",[],[267,269],"24f9ec4c-5204-11f1-8ecc-ee650bb23af1","run-seed.ts","24f9ecec-5204-11f1-8ecc-ee650bb23af1",["D",1779031317884],"import { seedAll } from \"./seed.ts\";\n\n// Run only the NPCs + downstream seeds that failed in the initial run\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Check if NPCs exist\nconst npcs = await sqlite.execute(\"SELECT COUNT(*) as c FROM characters WHERE is_npc = 1\");\nif ((npcs.rows[0] as any).c === 0) {\n console.log(\"Re-seeding NPCs and downstream data...\");\n await seedAll();\n console.log(\"Done! NPCs and downstream data seeded.\");\n} else {\n console.log(\"NPCs already exist, skipping.\");\n}\n\n// Verify counts\nconst counts = await Promise.all([\n sqlite.execute(\"SELECT COUNT(*) as c FROM characters WHERE is_npc = 1\"),\n sqlite.execute(\"SELECT COUNT(*) as c FROM dialog_trees\"),\n sqlite.execute(\"SELECT COUNT(*) as c FROM quests\"),\n sqlite.execute(\"SELECT COUNT(*) as c FROM shops\"),\n sqlite.execute(\"SELECT COUNT(*) as c FROM travel_routes\"),\n sqlite.execute(\"SELECT COUNT(*) as c FROM content_toggles\"),\n]);\nconsole.log(\"NPCs:\", (counts[0].rows[0] as any).c);\nconsole.log(\"Dialog Trees:\", (counts[1].rows[0] as any).c);\nconsole.log(\"Quests:\", (counts[2].rows[0] as any).c);\nconsole.log(\"Shops:\", (counts[3].rows[0] as any).c);\nconsole.log(\"Travel Routes:\", (counts[4].rows[0] as any).c);\nconsole.log(\"Content Toggles:\", (counts[5].rows[0] as any).c);\n",[],[267,276],"aedb5708-5203-11f1-b9d1-ee650bb23af1",["D",1779031119624],[197,198,199],[267],["D",1779031144532],[],[18,69],["D",1779031119624],[195],[18],["D",1779031119624],["D",1789498239291],{"_11":12,"_140":75},{"_11":12,"_136":75,"_74":75,"_31":73,"_137":138,"_139":30},{"_40":125,"_13":16,"_34":37,"_126":88,"_127":64,"_128":65,"_129":92,"_130":131,"_132":133,"_134":14,"_135":12},"ctx",{"_53":-5,"_161":330,"_331":332,"_333":334,"_335":30,"_336":30,"_337":30,"_338":24,"_339":-5,"_340":-7,"_341":-7,"_342":26,"_343":30,"_344":30,"_345":-5,"_346":30,"_347":30,"_348":30,"_349":-5},"ENV",{"_301":302,"_303":304,"_305":16,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · api