Saving custom NPCs

[Tdiin]

Is there an easy way to save just my custom NPCs? I find myself restoring the original database then reinstalling my NPCs one by one. There has to be an easier way.

Any suggestions?

[blackdragonsdg]

Save your custom content to an sql file that way you can source it in just like you would the main database. You can create .sql files in notepad. Do it like you would a normal txt document except the name will look like mynpcs.sql then set the file type to all files.

[revloc02c]

Originally Posted by blackdragonsdg

Save your custom content to an sql file

I am just wondering what you do to do this.

[wolfwalkereci]

Use notepadd++ or your favorite text editor.
To elaborate on what black said here is a simple example:

UPDATE doors SET dest_zone = 'NONE' WHERE dest_zone = 'PoTranquility';

Then you just save to something you remember like Notranq.sql
In notepad save it as "all files" but in notepad++ you can set the file name to Notranq and on the save as type there is "Structured Query Language file (*.sql)" or just like notepad save it as Notranq.sql and save it as "All types (*.*)"

Make sense?