Adding objects 'n such into MySQL using ArcEmu, Help?

[Valcon9]

Much like the title says, I've recently started with the private server scene, after finding my way around Navicat trying to see if I could figure out what I needed to put into where when adding objects from other repacks which the ArcEmu can use.

At the moment Im running with the Johved repack, so its all fairly stable server and client side, but I really want to start filling it out with content like malls and events that I see about the site. If anyone can give me any assistance or a hand with this Ill be grateful and +rep responces reguardless.

[Azshaz]

To add an object you type .go spawn id and to make it permanent type .go spawn id 1. I'm not sure how to make a vendor without wow-v.com, but here it is. (This is assuming you have HediSQL)

1) Go to Mob/NPC Creator | WoW-V.com

2) Enter the info. The entry ID should be 50000 if you've never made a vendor/npc before.

3) Once you've entered all the info, if you're running ArcEmu download the *ASCENT* one (the arcemu one doesn't work for me)

4) Open HediSQL, connect, and go to "Import -> Load SQL-File ..." then open your file, then press f9 on your keyboard.

You now have your vendor, but now to add the items. To add items to your vendor do the following.

1) Go to Vendor Creator | WoW-V.com

2) Enter all the info. The "Vendor EntryID" MUST match your npc's ID.

3) Look on wowhead for items. To find the ID number, look in the address bar and at the very end are some numbers. That is the ID. (For example: Martin Thunder looks like Martin Thunder - Item - World of Warcraft)

4) Once you've added all the items you want, download the ArcEmu SQL File.

5) Open HediSQL, connect, go to "Import -> Load SQL-File ..." then open the file. Press f9 ONCE (you'll be sorry if you press it again, multiple items in a vendor for the lose)

Go into WoW and login. Once you're in type .npc spawn id (assuming you used 50000 as the ID you'd type .npc spawn 50000). Talk to him to see if he sells and then if it works, congratulations.


Good luck!
~Azshaz