Just a follow up, incase anybody searches and finds this post.
There may be an easier way, if there is, perhaps someone can chime in.
Using Heidi I found my custom entries and using the right-click context menu exported the grid to an SQL file. For anybody that's interested, you are given the option to export as a new entry, or a replacement entry. So in the case of my Sirens Grotto safe point change, I used a replace; where the new item and merchantlist entries were inserts (new).
As far as the server rules go, I ended up just exporting the whole "rule_values" table to a SQL file all it's own.
Anyway, from there the process was simply; source "drop_system.sql", source "peqbeta.sql", source "custom.sql" (the file created above), and finally source "rules.sql". No errors/warnings/etc. Pretty clean process, something easy enough to do each time you'd like to update to the newest PEQ dump. Even easier if you stay ontop of the DB changes as you make them and just keep the custom.sql current.
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?
Hopefully this will help someone who has custom entries in the DB, but still wants to stay current with PEQ.
|
Threaded Mode
