[Guide]Making Custom Items/Vendors

[HumanAlien]

thanks :P !

[freezer1012]

Lol ive used wow-v sooooo any times... I love it

[kristian92]

wow-w is the only site i know of. are there more item creator web-sites?

[varden107]

nice. cool. ty. =)

[wowstorm]

nice. cool. ty. =)

thanks :P !

cool thanks for this

No Problem Guys Happy to Help

wow-V is the only site i know of. are there more item creator web-sites?

Wow-V is the only Site i think, You can always try doing it directly into the database but i don't recommend it unless you A)Know what your Adding/Editing B)Want some special Proc Or Equip Display Animation.

I did everything in this guide, but when I execute the batch file at the end I get and error

table: mangos.items doesn't exist...

I'm not sure what im doing wrong. Am I supposed to have this mangos.items table and where if I am??

Yes, you downloaded the wrong Batch, Download an antrix/ascent one instead.

i get

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '35844,1,0,0,0,0,0,0,0,0,0,0,2,'May He Who Owns This Have Great Power!',0,0,0,0,0' at line 2
[Msg] Finished - Unsuccessfully

Hmm, i am not sure, but normally when you get this there is a problem with you SQL or the Item.sql you are trying to execute this can be caused by 's in the Name or Description and by other non numberical/alphabetical entrys try removing the ! on your description. Which is

"May He Who Owns This Have Great Power!"

i dont get it, ive read like 5 of theses and do it how the guide says, and even try diff ways. but every time i go to execute the batch file it gives me an error. one guide said that means i have the wrong entry id, but i put in 91111 and 91112. what might i be doing wrong?

Please Specify your error/problem Aka:What edsactly error are you getting. (When you get the error press ok and click open error file and scroll down to bottem and tell me the last error it had.)

the site didnt gev me the right display ID.

You might be useing a rev/db with different display id codes, Either try another id download list, or tell me the item you want and i'll give you it. (Please try the first one before asking me.)

I agree, the custom weapon I make hasn't worked, do I need to restart the server or something?

Login into your server on a admin/gm account and type .reload items then wait for it to reload then do .additem "theentryidyouset"

i find it funny how long it takes for sum1 2 help....

I'm sorry but i can't help, when i've been away. And instead of going off in a mood, keep a positive attitude. Thats the reason i'm doing this massive post now.

You can get the display ID for an item by going to wow.allakhzam and searching for an item. On the page, usually right below the item name is a link to an XML page. Click it and scroll down till you see "DisplayID" in the value, that's the number your looking for.

True, But not very reliable

[PolishMaster2]

I agree, the custom weapon I make hasn't worked, do I need to restart the server or something?

yes, if you had the server running when you executed the batch file.

[PolishMaster2]

and why is a guide needed for this...

can't you just say "go to Wow-V.com and make your weapon with an id different from everything else and the display id the display id of the item you want it to look like, then download it from the right link depending on what kind of server you have" ?

[moomoo712]

thank you for the guide it helped greatly

[dfmnlx]

I Cant execute it gives me an error can u help me?

[Titansruler]

Little question, how do you delete an item from your database?

[wowstorm]

I Cant execute it gives me an error can u help me?

I Can't help you if you don't tell me the error please post it.

Little question, how do you delete an item from your database?

RightClick on a line that you want deleting (Navicat) And Press the Subtract ( Its -) and press ok that will delete that line then restart your server or type .reload items Small note if anyone has the item when it is deleted it will register it as it still there. (Weird Huh?)

[whoami33]

how do i execute the batch file? i right cliked on the Ascent database but it didnt have that option.. am i missing something? BTW im using SQLyog

[Performer]

Vampiricdust's Scripts

Is a better site too convert Item ID's Into Display ID's

Just type item ID into the Iteam ID box click find and voila Display ID appears.

[Mahona]

YES Thanks soooo much!!!!

[Mahona]

how do i execute the batch file? i right cliked on the Ascent database but it didnt have that option.. am i missing something? BTW im using SQLyog

I have SQLyog too.

Here is the SQLyog version of importing the customized item:

Right click on your Ascent/Antrix Database.

Click on "Restore from SQL Dump"

Click on the Browse button and search for the batch file you just downloaded.

Then Click Execute!

Problems that may occur:

Errors after clicking Execute:

Reason: You most probably have downloaded the WRONG batch...

Solution: Download the other batch file, usually the batch on top. It SHOULD work! (note: there is a MaNGOS tab and an Ascent/Antrix tab on the top right of the box under the preview. Make sure you clicked on ASCENT/ANTRIX !!!!)

Hope this helped

BTW i also need help ith the Vendor Fixes..... :banned: