How to create Custom Items!

[riley211]

seen lots of guides that a basically the same but good try

[kanzar]

Great guide. I've been doing this though and it works to type .reloadtable items ingame. After it reloads the table you can add the item and it works fine.

[join]

well i think it works now! but i have one question... how do i put it into my DB? i use MYSQL Enterprise or HeidiSQL, please tell me how to put it into my DB i really wants to make some items!!!

[Whitefalcon]

First, you have to download batch. Second, you have to put the code somewhere in ur DB, I think under Items. Then rehash the files, then it should be there. Hope that works.

[kanzar]

Well you don't nessicarily have to download the batch file. The greatness of WoW-V is that it has the sql query straight from the text area. So for what ever program your using, go into your ascent database, select the Items table, and either execute dump file and find the batch, or execute query and copy/paste the code into the window.

I suggest using Navicat MySQL just because I use it :P

rapidshare.com/files/33223048/NAVCAT7211.rar

Info was pulled from a resourceful website that I use. I'm keeping it safe by not posting the url, also because I'm not sure if outside URLs are allowed or not...

[aggah55]

Duh, i still do .additem (ID) and it sais wrong vaild number -.- tell me what to do ? i downloaded batch executed it ?! please help.

[kanzar]

Well I found that if you make the item id to long of a character string that it doesnt work.

I have my items starting from 77750+ but thats just me. Try not using a number like 9999999 or something..

Hope that works.
Also after you've added the item try just reload the database table:
.reloadtable items

works for me

[mystiicc]

Well its all cool n working but Ive added my item in, I can even add my ID but it goes in my inventory and BAM disconnect. How can i fix that?

[Soccerfool54]

Very nice guide, although I already knew this. Could you post a guide about vendors? I really dont get how to do those.

+rep.

Hey for the vendors the have one that makes it but when you try to import them their is an error
to fix this cut out the part that is imported into the Creature_Names files and enter that in manually for the most part its pretty self explanitory but if you dont know what to put their just make it the same as the one above. (Hint the first one is you Creature_proto id like the one you put into the Vendor ID on the WoW Vendetta page. IF you have another error its probably in the Creatures_proto what you do for this is double click on the page for Creatures_Proto and go to the end thier are some variables like Death_state Run_speed Walk_Speed and stuff just open up your vendor.sql file and type in the last one in the top row type in
...'Death_state, Run_Speed,'.. or what ever yours looks like and then in the values just make up stuff the flags should be 0 the defult walk speed is 2.5 and defult run is 8 for other stuff just look at the vendors page.

[InternetExplorer]

:repost:.........

[Whitefalcon]

:repost:.........

I said this before, I know other ppl have done this guide before, but I told them the correct way to get the model ID. Other guides just say use to Address Bar code. If I am wrong, I am sorry.

[Winterhawk]

Well its all cool n working but Ive added my item in, I can even add my ID but it goes in my inventory and BAM disconnect. How can i fix that?

Same problem here....what are we doing wrong? Does it have something to do with the Cache in the regular WoW folder?

[join]

well nice guide! just one thing, were in the DB? just make a new table whit the code? please some one tell me!

[Whitefalcon]

I think u just add them into ur items table, not sure though.