Custom Vendor help.

[NEferiouis07]

I know this question has probably been asked thousands of times, i searched for an hour or so and couldn't find anything on the subject, but if you have the time please help me in my endeavor thank you.



I downloaded custom vendors, and was wondering where is the world database file in Navicat to upload these vendors? Also, how do I do it? I use ArcEmu for 2.4.3.

[kreegoth]

If you downloaded a VENDORS.SQL or something just right click the World Database click execute batch file and select the sql.. If you already have a Table there itll unsuccessfully do it.
If you want to use the full table you downloaded.. Delete the OLD Vendors table and THEN execute the Vendors.Sql. If you only wanna use the Customized stuff out of it then without deleting old table Execute it as mentioned above and make sure continue on Errors is checkmarked..

[NEferiouis07]

Ahh i see, but where is world database?

[Maybepie]

They're usually called Mangos or Ascent.
If you still can't find anything, please upload a printscreen of Navicat, and we'll be able to take a closer look.
Good luck.

[NEferiouis07]

Thank you both for your input, it really helped me out a lot. +rep ^^. Now im trying to upload my weapon with heidisql, i just use ncdb?

[kreegoth]

Use Naviact to load it into database yes. If its from WOW-v itll be a SQL they have you download.. do it same way you did vendors.. sometimes youll get stuff in Query you can do through the query tab in Navicat..

[NEferiouis07]

Ahh i see thanks a lot man, thats what I didn't understand, im back to navicat.

[NEferiouis07]

Ok i pasted it into query, and hit run, but when im ingame i can't add the item. At the end it says effected rows 1, so im guessing it worked and it gives the time, but i cant do .spawn npc or .additem ect

[Aznex]

Make sure u did it correctly and it actually worked without errors

[kreegoth]

Make sure the item ID is under 200000 and make sure you delete cache and restart server before trying to add it..

[NEferiouis07]

Do I paste it into the query? Or just exectue batch file in the database it goes into ?

[kreegoth]

If its a SQL just execute it .. if its a copied and pasted query use the query tab in Navicat..

[NEferiouis07]

Thanks for all your help man it really helped me out.

[kreegoth]

Np if you have anymore questions about it feel free to send me a PM and ill help ya figure it out

[NEferiouis07]

Thanks will do.