⚔️ Fantasy MUD - A Multiplayer Text Adventure

\n \n \n\n\n","label",[177,68],"gui","pulls","branches","forks","envVars",{"_185":26,"_187":26},"connections",{"_185":26,"_186":26},"count","unfilledCount","emptyCount",{"_33":275,"_13":274,"_66":267,"_43":-5,"_35":36,"_170":40,"_171":96,"_37":276,"_39":26,"_69":234,"_173":-5,"_70":24,"_175":-5,"_205":277,"_17":278},{"_33":264,"_13":265,"_66":266,"_43":267,"_35":36,"_170":268,"_171":96,"_37":269,"_39":270,"_69":220,"_173":271,"_70":24,"_175":-5,"_205":272,"_17":273},{"_33":260,"_13":252,"_66":247,"_43":-5,"_35":36,"_170":40,"_171":96,"_37":261,"_39":26,"_69":234,"_173":-5,"_70":24,"_175":-5,"_205":262,"_17":263},{"_33":253,"_13":254,"_66":255,"_43":247,"_35":36,"_170":40,"_171":96,"_37":256,"_39":26,"_69":220,"_173":257,"_70":24,"_175":-5,"_205":258,"_17":259},{"_33":244,"_13":245,"_66":246,"_43":247,"_35":36,"_170":40,"_171":96,"_37":248,"_39":26,"_69":220,"_173":249,"_70":24,"_175":-5,"_205":250,"_17":251},{"_33":240,"_13":177,"_66":169,"_43":-5,"_35":36,"_170":40,"_171":96,"_37":241,"_39":26,"_69":234,"_173":-5,"_70":24,"_175":-5,"_205":242,"_17":243},{"_33":168,"_13":68,"_66":67,"_43":169,"_35":36,"_170":76,"_171":96,"_37":237,"_39":40,"_69":21,"_173":174,"_70":24,"_175":-5,"_205":238,"_17":239},{"_33":232,"_13":224,"_66":218,"_43":-5,"_35":36,"_170":40,"_171":96,"_37":233,"_39":26,"_69":234,"_173":-5,"_70":24,"_175":-5,"_205":235,"_17":236},{"_33":225,"_13":226,"_66":227,"_43":218,"_35":36,"_170":40,"_171":96,"_37":228,"_39":26,"_69":220,"_173":229,"_70":24,"_175":-5,"_205":230,"_17":231},{"_33":215,"_13":216,"_66":217,"_43":218,"_35":36,"_170":40,"_171":96,"_37":219,"_39":26,"_69":220,"_173":221,"_70":24,"_175":-5,"_205":222,"_17":223},{"_33":208,"_13":209,"_66":210,"_43":-5,"_35":36,"_170":122,"_171":96,"_37":211,"_39":40,"_69":21,"_173":212,"_70":24,"_175":-5,"_205":213,"_17":214},{"_33":200,"_13":201,"_66":94,"_43":-5,"_35":36,"_170":40,"_171":96,"_37":202,"_39":26,"_69":203,"_173":204,"_70":24,"_175":-5,"_205":206,"_17":207},"e5c10b40-51fa-11f1-abda-ee650bb23af1","main.ts",["D",1779027346197],"http","// Fantasy MUD - Main HTTP Entry Point\nimport { Hono } from \"npm:hono@4\";\nimport { readFile, serveFile, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { initSchema } from \"./db/schema.ts\";\nimport { seedAll } from \"./db/seed.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport apiRoutes from \"./api/routes.ts\";\n\nconst app = new Hono();\n\n// Error handler for full stack traces\napp.onError((err) => Promise.reject(err));\n\n// Initialize database on first request\nlet dbInitialized = false;\napp.use(\"*\", async (c, next) => {\n if (!dbInitialized) {\n await initSchema();\n // Check if we need to seed\n const races = await sqlite.execute(\"SELECT COUNT(*) as count FROM races\");\n if ((races.rows[0] as any).count === 0) {\n await seedAll();\n console.log(\"Database seeded successfully!\");\n }\n dbInitialized = true;\n }\n await next();\n});\n\n// Mount API routes\napp.route(\"/api\", apiRoutes);\n\n// View source\napp.get(\"/source\", (c) => c.redirect(parseVal(import.meta.url).links.self.val));\n\n// Serve the web GUI\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/gui/index.html\", import.meta.url);\n return new Response(html, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n});\n\n// Health check\napp.get(\"/health\", (c) => c.json({ status: \"ok\", game: \"Fantasy MUD\" }));\n\nexport default app.fetch;\n","children",[],[201],"9afd5a68-51fb-11f1-9971-ee650bb23af1","README.md","019e364b-037b-778d-9380-81b59d54dbd6",["D",1779027650395],"# ⚔️ Fantasy MUD - Multiplayer Text Adventure\n\nA fully featured, web-based Multi-User Dungeon (MUD) with a rich fantasy world, REST API, and extensible database-driven content.\n\n## 🌍 World\n\n- **8 Continents**: Aetheria, Drak'thor, Silverwood, Irondeep, Mistral Isles, Shadowmere, Solaria, Frostheim\n- **120 Countries** with unique governments, cultures, currencies, and lore\n- **60+ Islands** (45 inhabited, 15 uninhabited) + **35 City-States**\n- **45+ Wilderness Areas** with varying danger levels\n- **20+ Explorable Locations** with interconnected rooms and detailed descriptions\n\n## 🎮 Features\n\n### Character System\n- **20 Races**: Human, Elf, Dwarf, Halfling, Orc, Dark Elf, Beastkin, Dragonborn, Demon, Angel, Fairy, Vampire, Werewolf, Goblin, Slime, Merfolk, Giant, Spirit, Golem, Undead\n- **15 Classes**: Warrior, Mage, Ranger, Rogue, Cleric, Paladin, Necromancer, Bard, Monk, Summoner, Berserker, Alchemist, Farmer, Merchant, Knight\n- Full stats: STR, DEX, INT, WIS, CON, CHA, LUK\n- Leveling system with class-based stat growth\n\n### Combat\n- Melee (swords, axes, daggers, maces, spears, unarmed)\n- Ranged (bows, crossbows, throwing stars, throwing daggers)\n- **12 Schools of Magic**: Destruction, Restoration, Alteration, Conjuration, Illusion, Mysticism, Enchanting, Necromancy, Nature Magic, Blood Magic, Divination, Rune Magic\n- **35+ Spells** and **16 Combat Skills**\n\n### World Interaction\n- **NPC Dialog Trees** with branching conversations per job type (21 dialog trees)\n- **25+ Named NPCs** with unique backstories, jobs, and personalities\n- **20 Monster Types** (some tameable, some mountable)\n- **Shops** with browsable inventory and buy/sell\n- **Gift Giving** to build relationships with NPCs\n- **Marriage** system with affection tracking\n- **Follower** recruitment and orders\n- **Creature Taming** and mounts\n\n### Economy & Crafting\n- **45+ Items**: weapons, armor, consumables, seeds, crops, gifts, tools\n- Multiple shop types (general, weapon, potion, seed)\n- Player-to-player trading\n- **Farming**: plant seeds, water crops, harvest\n- **Fishing** with luck-based catches\n- **Construction**: build houses, camps, villages, towns\n- **Property ownership** with farm plots\n\n### Guilds & Quests\n- **12 Guilds** (Adventure, Merchant, Warrior, Mage, Thief, Farming, Fishing, Monster Hunter, Healer, Taming)\n- **12 Quests** (main story, side quests, guild quests, events)\n- Guild ranking system (Novice → Grandmaster)\n\n### Travel\n- Boats, carriages, magical teleportation\n- Inter-continental and local routes\n\n### Social\n- Friend requests and acceptance\n- Private messaging between friends\n- Character and world export/import (JSON)\n\n### Calendar & Seasons\n- Spring, Summer, Autumn, Winter\n- Day advancement affects farming\n\n### Content Safety\n- Configurable toggles for romance, marriage, children per race/age\n- Trading of sentient beings disabled by default\n\n## 🖥️ Web GUI\n\nFull-featured browser interface with:\n- Account registration/login with session cookies\n- Detailed character creation (race, class, gender, biography)\n- Interactive game screen with location view, exits, NPCs, monsters, shops, travel\n- Shop browsing modal with buy functionality\n- Gift giving modal\n- Player trading\n- Command input (look, go, attack, fish, rest, stats, help)\n- Inventory management with equip/use\n- Quest tracker\n- Follower and tamed creature management\n- World map browser (continents, islands, guilds, magic schools)\n- Social panel (friends, messages, requests)\n- Export panel with full API documentation\n\n## 🔌 REST API\n\nAll features available via authenticated API (session cookie or `X-API-Key` header).\n\n### Auth\n- `POST /api/auth/register` - Create account\n- `POST /api/auth/login` - Login (returns session cookie + API key)\n- `POST /api/auth/logout` - Logout\n- `GET /api/auth/me` - Current user\n\n### Reference Data (public)\n- `GET /api/data/races|classes|magic-schools|spells|guilds|quests|continents|countries|islands|calendar`\n\n### Game Actions\n- `POST /api/game/look|move|attack|cast|fish|rest|use-item`\n- `POST /api/game/shop/buy|sell` · `GET /api/game/shop/:id/items`\n- `POST /api/game/dialog/start|continue`\n- `POST /api/game/gift|propose`\n- `POST /api/game/guild/join` · `POST /api/game/quest/accept`\n- `POST /api/game/trade/offer|respond`\n- `POST /api/game/follower/recruit|order` · `POST /api/game/tame`\n- `POST /api/game/farm/plant|water|harvest`\n- `POST /api/game/build|travel|advance-day`\n\n### World & Export\n- `GET /api/world/continents|countries/:id|islands`\n- `GET /api/export/character/:id|world`\n\n### Social\n- `POST /api/social/friend-request|friend-request/respond|message`\n- `GET /api/social/friend-requests|friends|messages`\n\n## 🔧 Modding\n\nAll game data lives in SQLite. To add content:\n1. Add rows to the appropriate tables (races, items, locations, etc.)\n2. Use the export/import API to share worlds\n3. Dialog trees, NPCs, and quests are all database-driven\n\n## Architecture\n\n```mermaid\ngraph TD\n A[Browser GUI] --> B[Hono HTTP Server]\n C[3rd Party Clients] --> B\n B --> D[API Routes]\n D --> E[Auth Module]\n D --> F[Game Engine]\n F --> G[SQLite Database]\n E --> G\n G --> H[Races/Classes/Items]\n G --> I[World Geography]\n G --> J[NPCs & Dialog]\n G --> K[Quests & Guilds]\n G --> L[Player Data]\n```\n",[],[209],"e5c02ec8-51fa-11f1-abda-ee650bb23af1","game-engine.ts","019e364b-037b-778d-9380-78aef8be1b6a","019e364b-037b-778d-9380-7f45e5025364",["D",1779027346197],"script","// Core game engine: character management, combat, movement, interactions\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ==================== CHARACTER CREATION ====================\nexport async function createCharacter(accountId: number, data: {\n name: string; raceId: number; classId: number; gender: string;\n appearance?: any; biography?: string;\n}) {\n const race = await sqlite.execute({ sql: \"SELECT * FROM races WHERE id = ? AND is_playable = 1\", args: [data.raceId] });\n if (race.rows.length === 0) throw new Error(\"Invalid or non-playable race\");\n const r = race.rows[0] as any;\n\n const cls = await sqlite.execute({ sql: \"SELECT * FROM classes WHERE id = ?\", args: [data.classId] });\n if (cls.rows.length === 0) throw new Error(\"Invalid class\");\n const c = cls.rows[0] as any;\n\n // Start in Valoria Capital (location 1)\n await sqlite.execute({\n sql: `INSERT INTO characters (account_id,name,race_id,class_id,level,experience,hp,max_hp,mp,max_mp,str,dex,int_stat,wis,con,cha,luk,gold,location_id,gender,age,appearance,biography,is_npc)\n VALUES (?,?,?,?,1,0,?,?,?,?,?,?,?,?,?,?,?,100,1,?,20,?,?,0)`,\n args: [\n accountId, data.name, data.raceId, data.classId,\n r.base_hp, r.base_hp, r.base_mp, r.base_mp,\n r.base_str, r.base_dex, r.base_int, r.base_wis, r.base_con, r.base_cha, r.base_luk,\n data.gender, JSON.stringify(data.appearance || {}), data.biography || \"\",\n ],\n });\n\n const result = await sqlite.execute({ sql: \"SELECT last_insert_rowid() as id\" });\n const charId = (result.rows[0] as any).id;\n\n // Give starting items\n await sqlite.execute({ sql: \"INSERT INTO inventory (character_id, item_id, quantity) VALUES (?, 4, 1)\", args: [charId] }); // Dagger\n await sqlite.execute({ sql: \"INSERT INTO inventory (character_id, item_id, quantity) VALUES (?, 21, 3)\", args: [charId] }); // 3 Health Potions\n await sqlite.execute({ sql: \"INSERT INTO inventory (character_id, item_id, quantity) VALUES (?, 24, 5)\", args: [charId] }); // 5 Bread\n\n // Learn Common language\n await sqlite.execute({ sql: \"INSERT INTO character_languages (character_id, language_id, proficiency) VALUES (?, 1, 100)\", args: [charId] });\n\n // Log\n await gameLog(charId, \"character_created\", `${data.name} has entered the world!`);\n\n return getCharacterFull(charId);\n}\n\nexport async function getCharacterFull(charId: number) {\n const result = await sqlite.execute({\n sql: `SELECT c.*, r.name as race_name, cl.name as class_name, l.name as location_name\n FROM characters c\n JOIN races r ON c.race_id = r.id\n JOIN classes cl ON c.class_id = cl.id\n LEFT JOIN locations l ON c.location_id = l.id\n WHERE c.id = ?`,\n args: [charId],\n });\n if (result.rows.length === 0) return null;\n return result.rows[0];\n}\n\nexport async function getCharactersByAccount(accountId: number) {\n const result = await sqlite.execute({\n sql: `SELECT c.*, r.name as race_name, cl.name as class_name, l.name as location_name\n FROM characters c\n JOIN races r ON c.race_id = r.id\n JOIN classes cl ON c.class_id = cl.id\n LEFT JOIN locations l ON c.location_id = l.id\n WHERE c.account_id = ? AND c.is_npc = 0`,\n args: [accountId],\n });\n return result.rows;\n}\n\n// ==================== MOVEMENT ====================\nexport async function move(charId: number, direction: string) {\n const char = await getCharacterFull(charId);\n if (!char) throw new Error(\"Character not found\");\n\n const exit = await sqlite.execute({\n sql: \"SELECT * FROM location_exits WHERE from_location_id = ? AND direction = ?\",\n args: [(char as any).location_id, direction],\n });\n if (exit.rows.length === 0) throw new Error(`No exit to the ${direction}`);\n\n const e = exit.rows[0] as any;\n if (e.is_locked) throw new Error(\"That way is locked\");\n\n await sqlite.execute({\n sql: \"UPDATE characters SET location_id = ? WHERE id = ?\",\n args: [e.to_location_id, charId],\n });\n\n const newLoc = await getLocationInfo(e.to_location_id);\n await gameLog(charId, \"move\", `Moved ${direction} to ${(newLoc as any).name}`);\n return { location: newLoc, message: `You travel ${direction}. ${e.description || \"\"}` };\n}\n\nexport async function getLocationInfo(locationId: number) {\n const loc = await sqlite.execute({ sql: \"SELECT * FROM locations WHERE id = ?\", args: [locationId] });\n if (loc.rows.length === 0) return null;\n\n const exits = await sqlite.execute({\n sql: \"SELECT le.*, l.name as destination_name FROM location_exits le JOIN locations l ON le.to_location_id = l.id WHERE le.from_location_id = ?\",\n args: [locationId],\n });\n\n const npcs = await sqlite.execute({\n sql: \"SELECT id, name, npc_job, race_id, gender FROM characters WHERE location_id = ? AND is_npc = 1 AND is_alive = 1\",\n args: [locationId],\n });\n\n const players = await sqlite.execute({\n sql: \"SELECT id, name, race_id, class_id, level, gender FROM characters WHERE location_id = ? AND is_npc = 0 AND is_alive = 1\",\n args: [locationId],\n });\n\n const monsters = await sqlite.execute({\n sql: `SELECT ms.id as spawn_id, mt.name, mt.level_min, mt.level_max, mt.behavior, mt.is_tameable\n FROM monster_spawns ms JOIN monster_templates mt ON ms.template_id = mt.id WHERE ms.location_id = ?`,\n args: [locationId],\n });\n\n const shops = await sqlite.execute({\n sql: \"SELECT id, name, shop_type FROM shops WHERE location_id = ?\",\n args: [locationId],\n });\n\n const travel = await sqlite.execute({\n sql: `SELECT tr.*, l.name as destination_name FROM travel_routes tr JOIN locations l ON tr.to_location_id = l.id WHERE tr.from_location_id = ? AND tr.is_available = 1`,\n args: [locationId],\n });\n\n return {\n ...(loc.rows[0] as any),\n exits: exits.rows,\n npcs: npcs.rows,\n players: players.rows,\n monsters: monsters.rows,\n shops: shops.rows,\n travel_routes: travel.rows,\n };\n}\n\n// ==================== LOOK / EXAMINE ====================\nexport async function look(charId: number) {\n const char = await getCharacterFull(charId);\n if (!char) throw new Error(\"Character not found\");\n return getLocationInfo((char as any).location_id);\n}\n\n// ==================== COMBAT ====================\nexport async function attack(charId: number, targetType: string, targetId: number) {\n const char = await getCharacterFull(charId) as any;\n if (!char) throw new Error(\"Character not found\");\n\n let target: any;\n if (targetType === \"monster\") {\n const spawn = await sqlite.execute({\n sql: `SELECT ms.*, mt.* FROM monster_spawns ms JOIN monster_templates mt ON ms.template_id = mt.id WHERE ms.id = ? AND ms.location_id = ?`,\n args: [targetId, char.location_id],\n });\n if (spawn.rows.length === 0) throw new Error(\"Monster not found here\");\n target = spawn.rows[0];\n } else if (targetType === \"character\") {\n const t = await getCharacterFull(targetId) as any;\n if (!t || t.location_id !== char.location_id) throw new Error(\"Target not found here\");\n target = t;\n } else {\n throw new Error(\"Invalid target type\");\n }\n\n // Simple combat calculation\n const playerDamage = Math.max(1, char.str + Math.floor(Math.random() * 10) - (target.defense || 3));\n const monsterDamage = Math.max(1, (target.attack || target.str || 5) + Math.floor(Math.random() * 6) - Math.floor(char.con / 3));\n\n const results: string[] = [];\n results.push(`You attack ${target.name} for ${playerDamage} damage!`);\n\n let targetHp = (target.hp || 50) - playerDamage;\n let playerHp = char.hp - monsterDamage;\n\n if (targetHp <= 0) {\n // Victory\n const expGain = (target.level_max || target.level || 1) * 25;\n const goldGain = Math.floor(Math.random() * 20) + 5;\n await sqlite.execute({\n sql: \"UPDATE characters SET hp = ?, experience = experience + ?, gold = gold + ? WHERE id = ?\",\n args: [Math.max(1, playerHp), expGain, goldGain, charId],\n });\n results.push(`${target.name} is defeated! You gain ${expGain} exp and ${goldGain} gold!`);\n\n // Check level up\n const newExp = char.experience + expGain;\n const expNeeded = char.level * 100;\n if (newExp >= expNeeded) {\n await levelUp(charId);\n results.push(\"🎉 Level up!\");\n }\n\n // Check drops\n if (target.drops) {\n try {\n const drops = JSON.parse(target.drops);\n for (const drop of drops) {\n if (Math.random() < (drop.rate || 0.5)) {\n await addToInventory(charId, drop.item_id, drop.quantity || 1);\n const item = await sqlite.execute({ sql: \"SELECT name FROM items WHERE id = ?\", args: [drop.item_id] });\n if (item.rows.length) results.push(`Obtained: ${(item.rows[0] as any).name}`);\n }\n }\n } catch {}\n }\n\n await gameLog(charId, \"combat_victory\", `Defeated ${target.name}`);\n } else {\n results.push(`${target.name} attacks you for ${monsterDamage} damage!`);\n playerHp = Math.max(1, playerHp);\n await sqlite.execute({ sql: \"UPDATE characters SET hp = ? WHERE id = ?\", args: [playerHp, charId] });\n\n if (playerHp <= 1) {\n results.push(\"⚠️ You are critically wounded! Retreat or heal!\");\n }\n }\n\n return {\n results,\n playerHp,\n playerMaxHp: char.max_hp,\n targetHp: Math.max(0, targetHp),\n victory: targetHp <= 0,\n };\n}\n\nasync function levelUp(charId: number) {\n const char = await getCharacterFull(charId) as any;\n const cls = await sqlite.execute({ sql: \"SELECT * FROM classes WHERE id = ?\", args: [char.class_id] });\n const c = cls.rows[0] as any;\n\n await sqlite.execute({\n sql: `UPDATE characters SET level = level + 1, experience = 0,\n max_hp = max_hp + ?, hp = max_hp + ?,\n max_mp = max_mp + ?, mp = max_mp + ?,\n str = str + ?, dex = dex + ?, int_stat = int_stat + ?,\n wis = wis + ?, con = con + ?\n WHERE id = ?`,\n args: [c.hp_per_level, c.hp_per_level, c.mp_per_level, c.mp_per_level,\n c.str_per_level, c.dex_per_level, c.int_per_level, c.wis_per_level, c.con_per_level, charId],\n });\n await gameLog(charId, \"level_up\", `Reached level ${char.level + 1}!`);\n}\n\n// ==================== INVENTORY ====================\nexport async function getInventory(charId: number) {\n const result = await sqlite.execute({\n sql: `SELECT i.*, it.name, it.description, it.item_type, it.subtype, it.damage, it.defense, it.value, it.rarity, it.equip_slot\n FROM inventory i JOIN items it ON i.item_id = it.id WHERE i.character_id = ?`,\n args: [charId],\n });\n return result.rows;\n}\n\nexport async function addToInventory(charId: number, itemId: number, quantity: number = 1) {\n const existing = await sqlite.execute({\n sql: \"SELECT id, quantity FROM inventory WHERE character_id = ? AND item_id = ? AND is_equipped = 0\",\n args: [charId, itemId],\n });\n if (existing.rows.length > 0) {\n await sqlite.execute({\n sql: \"UPDATE inventory SET quantity = quantity + ? WHERE id = ?\",\n args: [quantity, (existing.rows[0] as any).id],\n });\n } else {\n await sqlite.execute({\n sql: \"INSERT INTO inventory (character_id, item_id, quantity) VALUES (?, ?, ?)\",\n args: [charId, itemId, quantity],\n });\n }\n}\n\nexport async function removeFromInventory(charId: number, itemId: number, quantity: number = 1) {\n const existing = await sqlite.execute({\n sql: \"SELECT id, quantity FROM inventory WHERE character_id = ? AND item_id = ? AND is_equipped = 0\",\n args: [charId, itemId],\n });\n if (existing.rows.length === 0) throw new Error(\"Item not in inventory\");\n const inv = existing.rows[0] as any;\n if (inv.quantity < quantity) throw new Error(\"Not enough items\");\n if (inv.quantity === quantity) {\n await sqlite.execute({ sql: \"DELETE FROM inventory WHERE id = ?\", args: [inv.id] });\n } else {\n await sqlite.execute({ sql: \"UPDATE inventory SET quantity = quantity - ? WHERE id = ?\", args: [quantity, inv.id] });\n }\n}\n\nexport async function equipItem(charId: number, inventoryId: number) {\n const inv = await sqlite.execute({\n sql: `SELECT i.*, it.equip_slot, it.name FROM inventory i JOIN items it ON i.item_id = it.id WHERE i.id = ? AND i.character_id = ?`,\n args: [inventoryId, charId],\n });\n if (inv.rows.length === 0) throw new Error(\"Item not found\");\n const item = inv.rows[0] as any;\n if (!item.equip_slot) throw new Error(\"This item cannot be equipped\");\n\n // Unequip current\n await sqlite.execute({\n sql: \"UPDATE inventory SET is_equipped = 0, slot = NULL WHERE character_id = ? AND slot = ?\",\n args: [charId, item.equip_slot],\n });\n // Equip new\n await sqlite.execute({\n sql: \"UPDATE inventory SET is_equipped = 1, slot = ? WHERE id = ?\",\n args: [item.equip_slot, inventoryId],\n });\n return { message: `Equipped ${item.name}` };\n}\n\n// ==================== TRADING ====================\nexport async function createTradeOffer(fromCharId: number, toCharId: number, offeredItems: any[], offeredGold: number, requestedItems: any[], requestedGold: number) {\n await sqlite.execute({\n sql: `INSERT INTO trade_offers (from_character_id, to_character_id, offered_items, offered_gold, requested_items, requested_gold) VALUES (?,?,?,?,?,?)`,\n args: [fromCharId, toCharId, JSON.stringify(offeredItems), offeredGold, JSON.stringify(requestedItems), requestedGold],\n });\n return { message: \"Trade offer sent!\" };\n}\n\nexport async function respondToTrade(tradeId: number, charId: number, accept: boolean) {\n const trade = await sqlite.execute({\n sql: \"SELECT * FROM trade_offers WHERE id = ? AND to_character_id = ? AND status = 'pending'\",\n args: [tradeId, charId],\n });\n if (trade.rows.length === 0) throw new Error(\"Trade offer not found\");\n const t = trade.rows[0] as any;\n\n if (!accept) {\n await sqlite.execute({ sql: \"UPDATE trade_offers SET status = 'rejected' WHERE id = ?\", args: [tradeId] });\n return { message: \"Trade rejected\" };\n }\n\n // Transfer gold\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold - ? WHERE id = ?\", args: [t.offered_gold, t.from_character_id] });\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold + ? WHERE id = ?\", args: [t.offered_gold, t.to_character_id] });\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold - ? WHERE id = ?\", args: [t.requested_gold, t.to_character_id] });\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold + ? WHERE id = ?\", args: [t.requested_gold, t.from_character_id] });\n\n // Transfer items\n const offeredItems = JSON.parse(t.offered_items);\n for (const item of offeredItems) {\n await removeFromInventory(t.from_character_id, item.item_id, item.quantity || 1);\n await addToInventory(t.to_character_id, item.item_id, item.quantity || 1);\n }\n const requestedItems = JSON.parse(t.requested_items);\n for (const item of requestedItems) {\n await removeFromInventory(t.to_character_id, item.item_id, item.quantity || 1);\n await addToInventory(t.from_character_id, item.item_id, item.quantity || 1);\n }\n\n await sqlite.execute({ sql: \"UPDATE trade_offers SET status = 'accepted' WHERE id = ?\", args: [tradeId] });\n return { message: \"Trade completed!\" };\n}\n\n// ==================== SHOP INTERACTION ====================\nexport async function buyFromShop(charId: number, shopId: number, itemId: number, quantity: number = 1) {\n const shop = await sqlite.execute({ sql: \"SELECT * FROM shops WHERE id = ?\", args: [shopId] });\n if (shop.rows.length === 0) throw new Error(\"Shop not found\");\n const s = shop.rows[0] as any;\n\n const item = await sqlite.execute({ sql: \"SELECT * FROM items WHERE id = ?\", args: [itemId] });\n if (item.rows.length === 0) throw new Error(\"Item not found\");\n const it = item.rows[0] as any;\n\n const cost = Math.ceil(it.value * s.buy_modifier * quantity);\n const char = await getCharacterFull(charId) as any;\n if (char.gold < cost) throw new Error(`Not enough gold. Need ${cost}, have ${char.gold}`);\n\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold - ? WHERE id = ?\", args: [cost, charId] });\n await addToInventory(charId, itemId, quantity);\n await gameLog(charId, \"shop_buy\", `Bought ${quantity}x ${it.name} for ${cost} gold`);\n return { message: `Bought ${quantity}x ${it.name} for ${cost} gold`, cost };\n}\n\nexport async function sellToShop(charId: number, shopId: number, itemId: number, quantity: number = 1) {\n const shop = await sqlite.execute({ sql: \"SELECT * FROM shops WHERE id = ?\", args: [shopId] });\n if (shop.rows.length === 0) throw new Error(\"Shop not found\");\n const s = shop.rows[0] as any;\n\n const item = await sqlite.execute({ sql: \"SELECT * FROM items WHERE id = ?\", args: [itemId] });\n if (item.rows.length === 0) throw new Error(\"Item not found\");\n const it = item.rows[0] as any;\n\n const value = Math.floor(it.value * s.sell_modifier * quantity);\n await removeFromInventory(charId, itemId, quantity);\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold + ? WHERE id = ?\", args: [value, charId] });\n await gameLog(charId, \"shop_sell\", `Sold ${quantity}x ${it.name} for ${value} gold`);\n return { message: `Sold ${quantity}x ${it.name} for ${value} gold`, value };\n}\n\n// ==================== DIALOG ====================\nexport async function startDialog(charId: number, npcId: number) {\n const char = await getCharacterFull(charId) as any;\n const npc = await getCharacterFull(npcId) as any;\n if (!npc || !npc.is_npc) throw new Error(\"NPC not found\");\n if (npc.location_id !== char.location_id) throw new Error(\"NPC is not here\");\n\n // Find best matching dialog tree\n const trees = await sqlite.execute({\n sql: `SELECT * FROM dialog_trees WHERE (npc_id = ? OR npc_id IS NULL) AND (job_filter = ? OR job_filter IS NULL) ORDER BY priority DESC, npc_id DESC LIMIT 1`,\n args: [npcId, npc.npc_job],\n });\n\n if (trees.rows.length === 0) {\n return { npc_name: npc.name, text: \"...\", options: [] };\n }\n\n const tree = trees.rows[0] as any;\n const greeting = await sqlite.execute({\n sql: \"SELECT * FROM dialog_nodes WHERE tree_id = ? AND node_key = 'greeting'\",\n args: [tree.id],\n });\n\n if (greeting.rows.length === 0) {\n return { npc_name: npc.name, text: `${npc.name} nods at you.`, options: [] };\n }\n\n const node = greeting.rows[0] as any;\n const options = await sqlite.execute({\n sql: \"SELECT * FROM dialog_options WHERE node_id = ? ORDER BY sort_order\",\n args: [node.id],\n });\n\n return {\n npc_name: npc.name,\n npc_job: npc.npc_job,\n tree_id: tree.id,\n node_key: node.node_key,\n text: node.text,\n options: options.rows,\n };\n}\n\nexport async function continueDialog(charId: number, treeId: number, nodeKey: string) {\n const node = await sqlite.execute({\n sql: \"SELECT * FROM dialog_nodes WHERE tree_id = ? AND node_key = ?\",\n args: [treeId, nodeKey],\n });\n\n if (node.rows.length === 0) {\n return { text: \"The conversation ends.\", options: [] };\n }\n\n const n = node.rows[0] as any;\n const options = await sqlite.execute({\n sql: \"SELECT * FROM dialog_options WHERE node_id = ? ORDER BY sort_order\",\n args: [n.id],\n });\n\n // Apply effects if any\n if (n.effects && n.effects !== \"{}\") {\n try {\n const effects = JSON.parse(n.effects);\n if (effects.give_item) await addToInventory(charId, effects.give_item, effects.quantity || 1);\n if (effects.give_gold) await sqlite.execute({ sql: \"UPDATE characters SET gold = gold + ? WHERE id = ?\", args: [effects.give_gold, charId] });\n if (effects.give_exp) await sqlite.execute({ sql: \"UPDATE characters SET experience = experience + ? WHERE id = ?\", args: [effects.give_exp, charId] });\n } catch {}\n }\n\n return {\n tree_id: treeId,\n node_key: n.node_key,\n text: n.text,\n options: options.rows,\n };\n}\n\n// ==================== RELATIONSHIPS ====================\nexport async function getRelationship(charAId: number, charBId: number) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM relationships WHERE (character_a_id = ? AND character_b_id = ?) OR (character_a_id = ? AND character_b_id = ?)\",\n args: [charAId, charBId, charBId, charAId],\n });\n return result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function giveGift(charId: number, targetId: number, itemId: number) {\n const item = await sqlite.execute({ sql: \"SELECT * FROM items WHERE id = ?\", args: [itemId] });\n if (item.rows.length === 0) throw new Error(\"Item not found\");\n const it = item.rows[0] as any;\n\n await removeFromInventory(charId, itemId, 1);\n\n const affectionGain = it.gift_value || Math.floor(it.value / 5) || 5;\n\n // Check content toggles for romance\n const existing = await getRelationship(charId, targetId);\n if (existing) {\n await sqlite.execute({\n sql: \"UPDATE relationships SET affection = affection + ?, friendship = friendship + ? WHERE id = ?\",\n args: [affectionGain, Math.floor(affectionGain / 2), (existing as any).id],\n });\n } else {\n await sqlite.execute({\n sql: \"INSERT INTO relationships (character_a_id, character_b_id, affection, friendship) VALUES (?, ?, ?, ?)\",\n args: [charId, targetId, affectionGain, Math.floor(affectionGain / 2)],\n });\n }\n\n await gameLog(charId, \"gift\", `Gave ${it.name} to character ${targetId}`);\n return { message: `You gave ${it.name}. Affection +${affectionGain}!`, affection_gain: affectionGain };\n}\n\nexport async function proposeMarriage(charId: number, targetId: number) {\n // Check toggle\n const toggle = await sqlite.execute({\n sql: \"SELECT * FROM content_toggles WHERE toggle_type = 'marriage' AND is_enabled = 1\",\n args: [],\n });\n if (toggle.rows.length === 0) throw new Error(\"Marriage is currently disabled\");\n\n const rel = await getRelationship(charId, targetId) as any;\n if (!rel || rel.affection < 100) throw new Error(\"Not enough affection for marriage (need 100+)\");\n\n await sqlite.execute({\n sql: \"UPDATE relationships SET is_married = 1, is_romantic = 1 WHERE id = ?\",\n args: [rel.id],\n });\n\n await gameLog(charId, \"marriage\", `Married character ${targetId}!`);\n return { message: \"Congratulations! You are now married! 💒\" };\n}\n\n// ==================== GUILDS ====================\nexport async function joinGuild(charId: number, guildId: number) {\n const guild = await sqlite.execute({ sql: \"SELECT * FROM guilds WHERE id = ?\", args: [guildId] });\n if (guild.rows.length === 0) throw new Error(\"Guild not found\");\n const g = guild.rows[0] as any;\n\n const char = await getCharacterFull(charId) as any;\n if (char.gold < g.join_fee) throw new Error(`Not enough gold. Need ${g.join_fee}`);\n\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM guild_members WHERE guild_id = ? AND character_id = ?\",\n args: [guildId, charId],\n });\n if (existing.rows.length > 0) throw new Error(\"Already a member\");\n\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold - ? WHERE id = ?\", args: [g.join_fee, charId] });\n await sqlite.execute({\n sql: \"INSERT INTO guild_members (guild_id, character_id, rank, reputation) VALUES (?, ?, 0, 0)\",\n args: [guildId, charId],\n });\n\n await gameLog(charId, \"guild_join\", `Joined ${g.name}`);\n return { message: `Welcome to ${g.name}! You start as a Novice.` };\n}\n\n// ==================== QUESTS ====================\nexport async function acceptQuest(charId: number, questId: number) {\n const quest = await sqlite.execute({ sql: \"SELECT * FROM quests WHERE id = ?\", args: [questId] });\n if (quest.rows.length === 0) throw new Error(\"Quest not found\");\n const q = quest.rows[0] as any;\n\n const char = await getCharacterFull(charId) as any;\n if (char.level < q.min_level) throw new Error(`Need level ${q.min_level} to accept this quest`);\n\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM character_quests WHERE character_id = ? AND quest_id = ? AND status = 'active'\",\n args: [charId, questId],\n });\n if (existing.rows.length > 0) throw new Error(\"Quest already active\");\n\n await sqlite.execute({\n sql: \"INSERT INTO character_quests (character_id, quest_id, status, current_step) VALUES (?, ?, 'active', 0)\",\n args: [charId, questId],\n });\n\n await gameLog(charId, \"quest_accept\", `Accepted quest: ${q.name}`);\n return { message: `Quest accepted: ${q.name}`, quest: q };\n}\n\nexport async function getActiveQuests(charId: number) {\n const result = await sqlite.execute({\n sql: `SELECT cq.*, q.name, q.description, q.steps, q.rewards FROM character_quests cq JOIN quests q ON cq.quest_id = q.id WHERE cq.character_id = ? AND cq.status = 'active'`,\n args: [charId],\n });\n return result.rows;\n}\n\n// ==================== FOLLOWERS ====================\nexport async function recruitFollower(charId: number, followerId: number) {\n const follower = await getCharacterFull(followerId) as any;\n if (!follower) throw new Error(\"Character not found\");\n\n const rel = await getRelationship(charId, followerId) as any;\n if (!rel || rel.friendship < 30) throw new Error(\"Not enough friendship to recruit (need 30+)\");\n\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO followers (leader_id, follower_id, role, current_order, loyalty, is_active) VALUES (?, ?, 'companion', 'follow', ?, 1)\",\n args: [charId, followerId, rel.friendship],\n });\n\n await gameLog(charId, \"recruit\", `Recruited ${follower.name} as a follower`);\n return { message: `${follower.name} has joined your party!` };\n}\n\nexport async function orderFollower(charId: number, followerId: number, order: string, details: any = {}) {\n const f = await sqlite.execute({\n sql: \"SELECT * FROM followers WHERE leader_id = ? AND follower_id = ? AND is_active = 1\",\n args: [charId, followerId],\n });\n if (f.rows.length === 0) throw new Error(\"Follower not found\");\n\n await sqlite.execute({\n sql: \"UPDATE followers SET current_order = ?, order_details = ? WHERE leader_id = ? AND follower_id = ?\",\n args: [order, JSON.stringify(details), charId, followerId],\n });\n\n return { message: `Ordered follower to: ${order}` };\n}\n\nexport async function getFollowers(charId: number) {\n const result = await sqlite.execute({\n sql: `SELECT f.*, c.name, c.level, c.hp, c.max_hp FROM followers f JOIN characters c ON f.follower_id = c.id WHERE f.leader_id = ? AND f.is_active = 1`,\n args: [charId],\n });\n return result.rows;\n}\n\n// ==================== TAMING ====================\nexport async function tamCreature(charId: number, spawnId: number) {\n const spawn = await sqlite.execute({\n sql: `SELECT ms.*, mt.* FROM monster_spawns ms JOIN monster_templates mt ON ms.template_id = mt.id WHERE ms.id = ?`,\n args: [spawnId],\n });\n if (spawn.rows.length === 0) throw new Error(\"Monster not found\");\n const m = spawn.rows[0] as any;\n if (!m.is_tameable) throw new Error(\"This creature cannot be tamed\");\n\n // Check if player has taming collar\n const collar = await sqlite.execute({\n sql: \"SELECT id FROM inventory WHERE character_id = ? AND item_id = 37\",\n args: [charId],\n });\n if (collar.rows.length === 0) throw new Error(\"You need a Taming Collar\");\n\n // Taming chance\n const char = await getCharacterFull(charId) as any;\n const chance = Math.max(10, 100 - m.tame_difficulty + Math.floor(char.cha / 2));\n const roll = Math.floor(Math.random() * 100);\n\n if (roll > chance) {\n await removeFromInventory(charId, 37, 1);\n return { message: `Taming failed! The ${m.name} broke free. (${roll} > ${chance})`, success: false };\n }\n\n await removeFromInventory(charId, 37, 1);\n await sqlite.execute({\n sql: `INSERT INTO tamed_creatures (owner_id, template_id, name, level, hp, max_hp, is_mount) VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [charId, m.template_id || m.id, m.name, m.level_min, m.hp, m.hp, m.is_mountable ? 1 : 0],\n });\n\n await gameLog(charId, \"tame\", `Tamed a ${m.name}!`);\n return { message: `You successfully tamed ${m.name}! 🎉`, success: true };\n}\n\nexport async function getTamedCreatures(charId: number) {\n const result = await sqlite.execute({\n sql: `SELECT tc.*, mt.name as species, mt.is_mountable FROM tamed_creatures tc JOIN monster_templates mt ON tc.template_id = mt.id WHERE tc.owner_id = ?`,\n args: [charId],\n });\n return result.rows;\n}\n\n// ==================== FARMING ====================\nexport async function plantCrop(charId: number, plotId: number, seedItemId: number) {\n const plot = await sqlite.execute({\n sql: `SELECT fp.*, p.owner_id FROM farm_plots fp JOIN properties p ON fp.property_id = p.id WHERE fp.id = ? AND p.owner_id = ?`,\n args: [plotId, charId],\n });\n if (plot.rows.length === 0) throw new Error(\"Farm plot not found or not owned\");\n const p = plot.rows[0] as any;\n if (p.crop_item_id) throw new Error(\"Plot already has a crop planted\");\n\n await removeFromInventory(charId, seedItemId, 1);\n\n const calendar = await sqlite.execute({ sql: \"SELECT * FROM game_calendar WHERE id = 1\" });\n const cal = calendar.rows[0] as any;\n\n await sqlite.execute({\n sql: \"UPDATE farm_plots SET crop_item_id = ?, planted_at = datetime('now'), growth_stage = 0, is_watered = 0 WHERE id = ?\",\n args: [seedItemId, plotId],\n });\n\n return { message: \"Crop planted! Remember to water it daily.\" };\n}\n\nexport async function waterCrop(charId: number, plotId: number) {\n await sqlite.execute({ sql: \"UPDATE farm_plots SET is_watered = 1 WHERE id = ?\", args: [plotId] });\n return { message: \"Crop watered! 💧\" };\n}\n\nexport async function harvestCrop(charId: number, plotId: number) {\n const plot = await sqlite.execute({\n sql: `SELECT fp.*, p.owner_id FROM farm_plots fp JOIN properties p ON fp.property_id = p.id WHERE fp.id = ? AND p.owner_id = ?`,\n args: [plotId, charId],\n });\n if (plot.rows.length === 0) throw new Error(\"Plot not found\");\n const p = plot.rows[0] as any;\n if (!p.crop_item_id) throw new Error(\"Nothing planted here\");\n if (p.growth_stage < 3) throw new Error(\"Crop not ready yet\");\n\n // Give harvest item (crop version of seed)\n const harvestItemId = p.crop_item_id + 4; // Seeds are id 26-29, crops are 30+\n const quantity = 1 + p.quality;\n\n await addToInventory(charId, harvestItemId > 31 ? 30 : harvestItemId, quantity);\n await sqlite.execute({\n sql: \"UPDATE farm_plots SET crop_item_id = NULL, planted_at = NULL, growth_stage = 0, is_watered = 0, quality = 1 WHERE id = ?\",\n args: [plotId],\n });\n\n return { message: `Harvested ${quantity} crops! 🌾` };\n}\n\n// ==================== CONSTRUCTION ====================\nexport async function startConstruction(charId: number, locationId: number, projectType: string, name: string) {\n const costs: Record = {\n house: 5000, camp: 500, village: 50000, town: 200000, wall: 2000, tower: 3000,\n };\n const cost = costs[projectType] || 5000;\n\n const char = await getCharacterFull(charId) as any;\n if (char.gold < cost) throw new Error(`Not enough gold. Need ${cost}`);\n\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold - ? WHERE id = ?\", args: [cost, charId] });\n await sqlite.execute({\n sql: `INSERT INTO construction_projects (owner_id, location_id, project_type, name, progress, total_work, status)\n VALUES (?, ?, ?, ?, 0, 100, 'building')`,\n args: [charId, locationId, projectType, name],\n });\n\n await gameLog(charId, \"construction\", `Started building: ${name}`);\n return { message: `Construction started: ${name} (${projectType}). Cost: ${cost} gold.` };\n}\n\n// ==================== TRAVEL ====================\nexport async function useTravel(charId: number, routeId: number) {\n const route = await sqlite.execute({ sql: \"SELECT * FROM travel_routes WHERE id = ? AND is_available = 1\", args: [routeId] });\n if (route.rows.length === 0) throw new Error(\"Travel route not available\");\n const r = route.rows[0] as any;\n\n const char = await getCharacterFull(charId) as any;\n if (char.location_id !== r.from_location_id) throw new Error(\"You're not at the departure point\");\n if (char.gold < r.cost) throw new Error(`Not enough gold. Need ${r.cost}`);\n\n await sqlite.execute({ sql: \"UPDATE characters SET gold = gold - ?, location_id = ? WHERE id = ?\", args: [r.cost, r.to_location_id, charId] });\n\n const dest = await getLocationInfo(r.to_location_id);\n await gameLog(charId, \"travel\", `Traveled via ${r.name} to ${(dest as any).name}`);\n return { message: `You travel via ${r.name}. Cost: ${r.cost} gold.`, location: dest };\n}\n\n// ==================== USE SPELL ====================\nexport async function castSpell(charId: number, spellId: number, targetType?: string, targetId?: number) {\n const char = await getCharacterFull(charId) as any;\n const spell = await sqlite.execute({ sql: \"SELECT * FROM spells WHERE id = ?\", args: [spellId] });\n if (spell.rows.length === 0) throw new Error(\"Spell not found\");\n const s = spell.rows[0] as any;\n\n if (char.mp < s.mp_cost) throw new Error(\"Not enough MP\");\n if (char.level < s.min_level) throw new Error(`Need level ${s.min_level}`);\n\n await sqlite.execute({ sql: \"UPDATE characters SET mp = mp - ? WHERE id = ?\", args: [s.mp_cost, charId] });\n\n const results: string[] = [`You cast ${s.name}!`];\n\n if (s.heal > 0) {\n await sqlite.execute({\n sql: \"UPDATE characters SET hp = MIN(max_hp, hp + ?) WHERE id = ?\",\n args: [s.heal, charId],\n });\n results.push(`Healed for ${s.heal} HP!`);\n }\n\n if (s.damage > 0 && targetType === \"monster\" && targetId) {\n results.push(`Dealt ${s.damage} magic damage!`);\n }\n\n return { results, mp_cost: s.mp_cost };\n}\n\n// ==================== EXPORT/IMPORT ====================\nexport async function exportCharacter(charId: number) {\n const char = await getCharacterFull(charId);\n const inventory = await getInventory(charId);\n const skills = await sqlite.execute({ sql: \"SELECT * FROM character_skills WHERE character_id = ?\", args: [charId] });\n const languages = await sqlite.execute({\n sql: \"SELECT cl.*, l.name FROM character_languages cl JOIN languages l ON cl.language_id = l.id WHERE cl.character_id = ?\",\n args: [charId],\n });\n const quests = await getActiveQuests(charId);\n const followers = await getFollowers(charId);\n const tamed = await getTamedCreatures(charId);\n\n return {\n version: 1,\n exported_at: new Date().toISOString(),\n character: char,\n inventory: inventory,\n skills: skills.rows,\n languages: languages.rows,\n quests,\n followers,\n tamed_creatures: tamed,\n };\n}\n\nexport async function exportWorld() {\n const tables = [\"races\", \"classes\", \"magic_schools\", \"spells\", \"continents\", \"countries\",\n \"wilderness_areas\", \"islands\", \"locations\", \"location_exits\", \"items\", \"monster_templates\",\n \"monster_spawns\", \"combat_skills\", \"guilds\", \"schools\", \"dialog_trees\", \"dialog_nodes\",\n \"dialog_options\", \"travel_routes\", \"shops\", \"quests\", \"content_toggles\", \"languages\",\n \"game_calendar\", \"clans\"];\n\n const world: Record = {};\n for (const table of tables) {\n try {\n const result = await sqlite.execute(`SELECT * FROM ${table}`);\n world[table] = result.rows;\n } catch { world[table] = []; }\n }\n return { version: 1, exported_at: new Date().toISOString(), world };\n}\n\n// ==================== CALENDAR ====================\nexport async function advanceDay() {\n const cal = await sqlite.execute({ sql: \"SELECT * FROM game_calendar WHERE id = 1\" });\n const c = cal.rows[0] as any;\n let day = c.current_day + 1;\n let season = c.current_season;\n let year = c.current_year;\n const seasons = JSON.parse(c.seasons);\n\n if (day > c.days_per_season) {\n day = 1;\n const idx = seasons.indexOf(season);\n if (idx >= seasons.length - 1) {\n season = seasons[0];\n year++;\n } else {\n season = seasons[idx + 1];\n }\n }\n\n await sqlite.execute({\n sql: \"UPDATE game_calendar SET current_day = ?, current_season = ?, current_year = ? WHERE id = 1\",\n args: [day, season, year],\n });\n\n // Advance farm growth\n await sqlite.execute({\n sql: \"UPDATE farm_plots SET growth_stage = growth_stage + 1 WHERE is_watered = 1 AND crop_item_id IS NOT NULL AND growth_stage < 4\",\n });\n await sqlite.execute({ sql: \"UPDATE farm_plots SET is_watered = 0\" });\n\n return { day, season, year };\n}\n\nexport async function getCalendar() {\n const cal = await sqlite.execute({ sql: \"SELECT * FROM game_calendar WHERE id = 1\" });\n return cal.rows[0];\n}\n\n// ==================== UTILITY ====================\nasync function gameLog(charId: number, eventType: string, message: string, data: any = {}) {\n await sqlite.execute({\n sql: \"INSERT INTO game_log (character_id, event_type, message, data) VALUES (?, ?, ?, ?)\",\n args: [charId, eventType, message, JSON.stringify(data)],\n });\n}\n\nexport async function getGameLog(charId: number, limit: number = 20) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM game_log WHERE character_id = ? ORDER BY id DESC LIMIT ?\",\n args: [charId, limit],\n });\n return result.rows;\n}\n\n// ==================== CONTENT TOGGLE CHECK ====================\nexport async function isContentEnabled(toggleType: string, raceId?: number, isSentient?: boolean, age?: number): Promise {\n let sql = \"SELECT * FROM content_toggles WHERE toggle_type = ?\";\n const args: any[] = [toggleType];\n\n if (raceId) { sql += \" AND (race_id = ? OR race_id IS NULL)\"; args.push(raceId); }\n if (isSentient !== undefined) { sql += \" AND (is_sentient = ? OR is_sentient IS NULL)\"; args.push(isSentient ? 1 : 0); }\n if (age !== undefined) {\n sql += \" AND (age_min IS NULL OR age_min <= ?) AND (age_max IS NULL OR age_max >= ?)\";\n args.push(age, age);\n }\n\n const result = await sqlite.execute({ sql, args });\n if (result.rows.length === 0) return true; // Default enabled if no toggle exists\n return (result.rows[0] as any).is_enabled === 1;\n}\n\n// ==================== REFERENCE DATA ====================\nexport async function getRaces() {\n return (await sqlite.execute(\"SELECT * FROM races WHERE is_playable = 1\")).rows;\n}\nexport async function getClasses() {\n return (await sqlite.execute(\"SELECT * FROM classes\")).rows;\n}\nexport async function getMagicSchools() {\n return (await sqlite.execute(\"SELECT * FROM magic_schools\")).rows;\n}\nexport async function getSpells() {\n return (await sqlite.execute(\"SELECT * FROM spells\")).rows;\n}\nexport async function getAllGuilds() {\n return (await sqlite.execute(\"SELECT * FROM guilds\")).rows;\n}\nexport async function getAllQuests() {\n return (await sqlite.execute(\"SELECT * FROM quests\")).rows;\n}\nexport async function getContinents() {\n return (await sqlite.execute(\"SELECT * FROM continents\")).rows;\n}\nexport async function getCountries(continentId?: number) {\n if (continentId) return (await sqlite.execute({ sql: \"SELECT * FROM countries WHERE continent_id = ?\", args: [continentId] })).rows;\n return (await sqlite.execute(\"SELECT * FROM countries\")).rows;\n}\nexport async function getIslands() {\n return (await sqlite.execute(\"SELECT * FROM islands\")).rows;\n}\n",[],[224,216],"lib","e5c01a3c-51fa-11f1-abda-ee650bb23af1","auth.ts","019e364b-037b-778d-9380-74273d7cb6ca",["D",1779027346197],"// Authentication: password hashing, sessions, API keys\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Simple hash using Web Crypto API\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + \"fantasy-mud-salt-v1\");\n const hash = await crypto.subtle.digest(\"SHA-256\", data);\n return Array.from(new Uint8Array(hash)).map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nfunction generateId(): string {\n return crypto.randomUUID();\n}\n\nexport async function register(username: string, password: string, email?: string) {\n if (!username || !password) throw new Error(\"Username and password required\");\n if (username.length < 3) throw new Error(\"Username must be at least 3 characters\");\n if (password.length < 6) throw new Error(\"Password must be at least 6 characters\");\n\n const existing = await sqlite.execute({ sql: \"SELECT id FROM accounts WHERE username = ?\", args: [username] });\n if (existing.rows.length > 0) throw new Error(\"Username already taken\");\n\n const passwordHash = await hashPassword(password);\n const apiKey = \"mk_\" + generateId().replace(/-/g, \"\");\n\n await sqlite.execute({\n sql: \"INSERT INTO accounts (username, password_hash, email, api_key) VALUES (?, ?, ?, ?)\",\n args: [username, passwordHash, email || null, apiKey],\n });\n\n const result = await sqlite.execute({ sql: \"SELECT id, username, api_key, is_admin FROM accounts WHERE username = ?\", args: [username] });\n return result.rows[0];\n}\n\nexport async function login(username: string, password: string) {\n const passwordHash = await hashPassword(password);\n const result = await sqlite.execute({\n sql: \"SELECT id, username, api_key, is_admin FROM accounts WHERE username = ? AND password_hash = ?\",\n args: [username, passwordHash],\n });\n if (result.rows.length === 0) throw new Error(\"Invalid username or password\");\n\n const account = result.rows[0] as any;\n const sessionId = generateId();\n const expiresAt = new Date(Date.now() + 7 * 24 * 60 * 60 * 1000).toISOString();\n\n await sqlite.execute({\n sql: \"INSERT INTO sessions (id, account_id, expires_at) VALUES (?, ?, ?)\",\n args: [sessionId, account.id, expiresAt],\n });\n\n await sqlite.execute({\n sql: \"UPDATE accounts SET last_login = datetime('now') WHERE id = ?\",\n args: [account.id],\n });\n\n return { sessionId, account };\n}\n\nexport async function getAccountFromSession(sessionId: string) {\n if (!sessionId) return null;\n const result = await sqlite.execute({\n sql: `SELECT a.id, a.username, a.api_key, a.is_admin FROM sessions s JOIN accounts a ON s.account_id = a.id WHERE s.id = ? AND s.expires_at > datetime('now')`,\n args: [sessionId],\n });\n return result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function getAccountFromApiKey(apiKey: string) {\n if (!apiKey) return null;\n const result = await sqlite.execute({\n sql: \"SELECT id, username, api_key, is_admin FROM accounts WHERE api_key = ?\",\n args: [apiKey],\n });\n return result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function authenticate(req: Request): Promise {\n // Try session cookie first\n const cookies = req.headers.get(\"cookie\") || \"\";\n const sessionMatch = cookies.match(/session=([^;]+)/);\n if (sessionMatch) {\n const account = await getAccountFromSession(sessionMatch[1]);\n if (account) return account;\n }\n // Try API key header\n const apiKey = req.headers.get(\"X-API-Key\") || req.headers.get(\"Authorization\")?.replace(\"Bearer \", \"\");\n if (apiKey) {\n const account = await getAccountFromApiKey(apiKey);\n if (account) return account;\n }\n return null;\n}\n\nexport async function requireAuth(req: Request): Promise {\n const account = await authenticate(req);\n if (!account) throw new Error(\"Authentication required\");\n return account;\n}\n\nexport async function logout(sessionId: string) {\n await sqlite.execute({ sql: \"DELETE FROM sessions WHERE id = ?\", args: [sessionId] });\n}\n",[],[224,226],"e5c0d792-51fa-11f1-abda-ee650bb23af1",["D",1779027346197],"directory",[196,197],[224],["D",1779027607969],[],[177,68],"e5c0183e-51fa-11f1-abda-ee650bb23af1",["D",1779027346197],[194],[177],"e5be8636-51fa-11f1-abda-ee650bb23af1","seed.ts","019e364b-037b-778d-9380-67e28b05b86b","019e364b-037b-778d-9380-6bdb1735a256",["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}",[],[252,245],"db","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",[],[252,254],"e5bf6fba-51fa-11f1-abda-ee650bb23af1",["D",1779027346197],[191,192],[252],"076b14a2-51fb-11f1-8f20-ee650bb23af1","routes.ts","019e364b-037b-778d-9380-598f6174896c","019e364b-037b-778d-9380-5e868b7a8177",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",[],[274,265],"api","e5be1868-51fa-11f1-abda-ee650bb23af1",["D",1779027346197],[189],[274],["D",1779027346197],["D",1789495880338],{"_11":12,"_137":73},{"_11":12,"_133":73,"_72":73,"_30":71,"_134":135,"_136":24},{"_39":122,"_13":16,"_33":36,"_123":84,"_124":63,"_125":64,"_126":88,"_127":128,"_129":130,"_131":14,"_132":12},"ctx",{"_52":-5,"_158":317,"_318":319,"_320":321,"_322":24,"_323":24,"_324":24,"_325":96,"_326":-5,"_327":-7,"_328":-7,"_329":26,"_330":24,"_331":24,"_332":-5,"_333":24,"_334":24,"_335":24,"_336":-5},"ENV",{"_288":289,"_290":291,"_292":16,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316},"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 · index.html