Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2015, 09:44 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default NPC Pathing

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.

Any help would be appreciated!

Peyton
Reply With Quote
  #2  
Old 06-03-2015, 10:21 PM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

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
Reply With Quote
  #3  
Old 06-03-2015, 10:44 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

Are the grids per NPC in the database or by zone?

Peyton
Reply With Quote
  #4  
Old 06-03-2015, 10:52 PM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

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
Reply With Quote
  #5  
Old 06-03-2015, 10:55 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

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.

Peyton
Reply With Quote
  #6  
Old 06-03-2015, 10:57 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

Found them now to try and figure out how the NPC pulls the particular grid ID.
Reply With Quote
  #7  
Old 06-03-2015, 11:04 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

Ok found the commands in game to find out an NPC grid assignment.
Reply With Quote
  #8  
Old 06-03-2015, 11:41 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

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!

Peyton
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:36 PM.


 

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.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3