Development::Database/World BuildingWorld Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.
I am trying to do some editing on NPCs already in a zone. They are pathing constantly and I want to stop the pathing. I cannot seem to understand how to do that at all.
You can look up the their grids in the database and delete them if you want them to stop forever, just delete their specific rows for the specific mobs you want to stop. But it's final unless you readd them
There is a grids table in the db, look in there and see how they are identified, I can't remember exactly as I don't have a db in front of me atm. If nobody else answers or you don't figure it out, I will respond in the morning when I get home
Thank you! I found the grid_entries and am looking based on the zone ID. I lloked up one of the NPCs by name in the npc_types looking for some kind of identifier linking it to the particular zone so I would know which grid entries to remove. So working on that one.
Ok I found how it works in the database. But ingame I can target the NPC and enter #gassign 0 to remove the NPC/Spawn Group from the grid assignment. This was pretty fun finding out where the actually database info was located. It was in the spawn2 database table.
Thanks for getting me to the right areas in the database!
Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.