Creating Items In Both [MaNGOS] & [Antrix]

[fitzy86]

Ok.... ALOT AND ALOT HAVE ASKED!

2 ways to do this... manually through database or with DJRAVINES TBC ITEM CREATOR... Which u have to go through database anyway.

HERE YOU GO!

GETTING INTO THE DATABASE
The Way to create items in MaNGOS & Antirx is hard but after a while you get used to it...

In the databse for your server (mangos or antrix) you would have tables like item_loot_template, creature_loot etc...

Right Click item_template in MaNGOS & items in Antrix and click view data.

Now this should show you all your items in Your server...... now you have viewed your items succsesfully! If you would like a bigger view of items click the show all button... be careful this may take a while..

MAKING THE ITEMS

Firstly you will need to find the display id for a particular item you would like to use as your weapon...

to find this out goto Allakhazam.com

Once you have your id which can be found in the url of the item page you want... simply go back into your database and find that # you got of Allakhazam in the Entry slots.
*HINT* I suggest you click the entry slot and it will be in asending order.

Once you get to your selected item.. move across with the scroll on the bottom of the page to where its says table "DisplayId".... this is the MODEL of the weapon... VERY IMPORTANT. Save that on a peice of paper you would need later.

Scroll All the way down to the bottom of the items table.

Now... what ever the last entry number is you have to make a unique number above that number. so for eg.

If the last entry was 43566

I would create my "custom items" with a entry id of 50000+.

Now... Enter a unique entry then move along to the class then subclass and so on... for codes etc look at the bottom of this post.....
Once you get to your display id for your custom wep enter in the id that you found out before. hopefully its correct and you shall have the same model

Continue on with going through the tables and entering information.

REMEMBER TO SAVE THE FILES BEFORE EXISTING!

Reload your mangos.exe and realm.exe or antrix.exe and logon.exe and they should work perfectly...

I Have created syntax's for all the tables in the database... for items... so i suggest you download this
++++++++++++++++
Fitzy's Item Syntax's
++++++++++++++++
Here will cover all the codes and infomation you need to put in each table.

Please Ask Questions with any errors in the table etc...
IF THERE IS A TABLE YOUR NOT SURE OF PUT A 0 OR ASK ME

Cheers Fitzy



-----------------------------------
-DJRAVINES TBC ITEM CREATOR-
-----------------------------------
Click HERE @ WoWps.org

Click Here @ RageZone

[MentaL]

[Dandune]

Nice & Informative, I always love the style of yours & Ravine's guides too.

[fitzy86]

Means Alot Cheers ;)

[onokira]

great post, i'll try and see that it works or not

[doomling]

I followed all the directions, but when I go to put the item into SQLyog it gives me this error:
Error Code : 1136
Column count doesn't match value count at row 1
(0 ms taken)

any help appreciated

[fitzy86]

So ur using dj's item creator?

Ok.... I think its ur db it needs to be updated.
Make sure u copy everything in the text it gives u cause it needs also that INSERT TO-- Bit ....So copy all of it.

[doomling]

was told to hit "saveSQL" and then insert it from there, is that incorrect or something?

EDIT: found the problem, it was missing unk2 on the end

[ollee]

what field is the spell triggered when the item is used??? reins of the ancient wolf etc???

[Odyne]

I don't have some of the items like Thunderfury Legendary 1h from MC in my list. Any way to get those items listed? thx

[EvilRyu]

heh, great app:)

But depends on item id's and what db your using;)

But if you wanted to know how it's done, this covers it perfectly:)

[Odyne]

I am using:

SQLyog 6.0.2
Antrix 2.1.0
MySQL Server 5.0
Antrix Project Database

and the item creator tool linked here.

[abraxxas]

if created m first item without any knowledeg of everything ;P
But can anyone tell me if i there is somewere a page or info so i can see wich value has wich numer. for example wich number strenght has and so on ;P.. and were can i find out model ids of items?
btw awesome tool

[blukkie]

Ehm, I cant find any DisplayID on the allakhazam page. I tried CTRL+F aswell.

[weedsbave]

good afternoon prompt who for you was engaged in a design ? so all is good but as I looked for you problem with the spam of type of it spam

[keii]

I dont have in antrix db columns item_templates ; buycount etc... tough i have a rev7