Sunday, March 19, 2017

How to remove or change mobs in eqemu everquest server akka installer

Edit: Actually the easiest way is to just remove lines from the npc_types table it seems.

1. open command prompt and type mysqldump -uroot -p peq > c:\eqemuserver\backups\database1.sql to save your database.  Make sure the path is correct and next time make it database2.sql etc.

2. Locate the npc you want to remove in npc_types table (make sure you are using heidisql).  Write down all the ID's of  the monsters you want to remove.

3. go to spawnentry table and sort by npcid.  Now delete every row that has an npcid of the monsters you want to remove.

Alternatively  to the step by step method above you can just delete rows from the spawn2 table but then if something else spawns 50% of the time in that spot and you don't want to get rid of that monster then you will need to use the method I laid out at the beginning of this post.

Note:  if you only want to remove spawns from certain zones or spots you will need to use the spawn2 table to pinpoint which spawngroups you want to remove monsters from then use that info when deleting rows from the spawnentry table.

for any questions please go to  My username is NostalgiaEQ