Jump to content
  • 0

Customer Vendors - On GM Island


Oscinu

Question

Hi All,

If you would like the Trainers / Vendors I have on GM Island and don't want to spend hours like I did then find the SQL Data Rows in the attached files, they are by no means perfect but got the job done for us. I am also sure someone with better knowledge of SQL could package these into a script so you don't need to manually import them.

Import the rows into corresponding tables from the filename

Caveat: 

creature: uses GUID of 200000+ so if you have already used these numbers change them

Creature_template: entry used are 100000+ so if you have already used these numbers change them

NPC_Vendor_template: entry used are 900+ so if you have already used these numbers change them and then change them to match in creature_template (VendorTemplateId column)

Import Example for Heidi:

Before proceeding take a backup of the database so you have a recovery point if anything goes wrong. 

1: Go to Tools and then Import CSV:

image.png.d82dd9d5e19d8daa9c9f02b710faed82.png

2: Select the File you want to import and make sure to change the destination table to the correct one

3: Change Options to ignore the first row as we don't want to import the column headers

4: Select the option of how you want to handle duplicate rows

5: As its a CSV file set the control characters as in the image below

image.png.7a869796da353e65d0b790b9285a24dd.png

After all 4 files have been imported you should tele to GM Island and have something like this

image.thumb.png.259a3f980c388337d806471d33a9a334.png

Trainers and Weapon skill vendors are inside.

Kind regards

Oscinu

 

NPC_Vendor_Template.csvNPC_Vendor.csvCreature_Template.csvCreature.csv

 

Edited by Oscinu
Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use