Quote:
Originally Posted by AsmoTiC
Now with all that said, I did have one problem. Hopefully someone could offer advice. My two new NPC's didn't update, so I ended up reverting back to my backup. What all tables do I need to export so they are in the world? I exported each npc from the "npc_types" table, I exported both "spawngroup" values, and both "spawnentry" values. When I restarted the server and checked on them, they wern't up. Did I miss a table somewhere?
|
Incase anybody ever uses this as a rough guide for doing the same type of thing, I figured i'd post back what I did to fix my two missing NPCS.
Sure enough I missed the entries in the "spawn2" table. Once I exported them and merged them into the custom.sql, the whole process ended up working out. So if you have custom NPC's you want to save you'll need to grab the NPC data, and all Spawn data.
Here are the tables that had everything associated with them:
npc_types, spawngroup, spawnentry, and spawn2.
Again, ended up answering all my own questions over the course of a couple days. Hopefully anybody that does a search will find the thread and get some direction from it.