[Tutorial] Making Custom Items using Navicat

[Ariac]

First tutorial, don't hate me for it. I did a search around the forums and didn't find anything about making custom items by editing your MySQL database. There was Clain's Post (http://www.ac-web.org/forum/showthread.php?t=5851) using a website, for those that want to do it that way.

Anyways, on to the Tutorial.

STEP 1: (Optional) Getting Navicat.
Download Navicat or your preferred MySQL database manager of your choice. The screenshots I'll be using will be from Navicat.
If you want, you can download it free (Lite or Full Trial, legally) here (http://www.navicat.com/download.html?gclid=CLa0-ZyJjZECFQUllgodZnAJFw).
Complete the installation, I hope I won't have to explain this part, open up Navicat.

STEP 2: Opening MySQL
Open up your MySQL database you use with your server. If you're using Ascent rev 7.4, the file you're looking for is in C:\AC Web Ultimate Repack\Server. Double-click the one called MySQL, and it should open up a screen like this.

http://img233.imageshack.us/img233/198/mysqlscreenmu4.png

After you see that you're ready to edit your database!

STEP 3: Setting up.
Open up Navicat (Or other program), make sure you're connected to your database (default name//pass is root//ascent), and browse on over to your Ascent Database, and open up your Items table.

http://img229.imageshack.us/img229/3077/ascentscreenub6.png
http://img221.imageshack.us/img221/903/itemsscreenai9.png

You should see a whoollee bunch of numbers, names, ect ect, if you want, you an clear this up by adding a filter. Click the Filter Wizard, click <Click here to add>, and make the filter by entry, and put in a high number (20000-100000) where the <?> is. Press the <Click here (ctrl+r) to apply>. If you get one line that says (Null) a bunch of times, it means the number is available.

http://img221.imageshack.us/img221/2400/filterscreenin7.png
http://img89.imageshack.us/img89/796/nullscreeney2.png

STEP 4: Making your own items!
At this point, you should see a line with a bunch of (Null)s. If you don't, fear not, just click on the + at the bottom to add in a line. So here you are looking at your table. The top should say a list of the categories.

Here we go..

Entry: The item number. Whatever this is, it's the number you use to add the item to the game. (.additem <entry #>)

Class: This is the type of item. IE: Weapon, Armor, Bag, ect ect.
0 = Consumable
1 = Container
2 = Weapon
3 = Gem
4 = Armor
5 = Unknown
6 = Projectile
7 = Trade Goods
8 = Fish Scale (They get a category all by themselves!)
9 = Recipe
11 = Quiver/Ammopouch
12 = Quest Items
13 = Keys
14 = Unused Mounts
15 = Misc (Gray Drops/Mounts/Flavor Items)

Subclass:
Only gonna do a few here. Otherwise this post would be even bigger.
Weapons:
0 = One-Handed Axe
1 = Two-Handed Axe
2 = Bow
3 = Gun
4 = One-Handed Mace
5 = Two-Handed Mace
6 = Polearm
7 = One-Handed Sword
8 = Two-Handed Sword
10 = Staff
13 = Fist
14 = Universal (Everyone can use it)
15 = Daggers
16 = Thrown
18 = Crossbow
19 = Wands
20 = Fishing Poles

Gems:
0 = Red
1 = Blue
2 = Yellow
3 = Purple
4 = Green
5 = Orange
6 = Meta
7 = Misc (Low level gems)
8 = Prismatic

Armor:
0 = Shirt/Ring/Off-hand/Tabard/Neck/Trinket
1-4 = Basic Armor (Gloves/Chest/Belt/Feet/Waist/Head/Bracers/Pants/Shoulders)
6 = Shield
7-9= Librams/Idols/Totems

field4:
Leave at -1

Name1-4:
The name of the item, as it appears in the game. Only name1 is needed.

DisplayID:
What the item will look like. Find an item you like, and take it's ID.

Quality:
0 = Poor (Grey)
1 = Common (White)
2 = Uncommon (Green)
3 = Rare (Blue)
4 = Epic (Purple)
5 = Legendary (Orange)
6 = Artifact (Gold)

Flags:
Not a clue. Leave at 0. (If you do know, please do tell!)

BuyPrice:
How much it costs to buy from a vendor. (In copper) 1g = 10000 copper.

SellPrice:
How much money you will get when you sell the item to the vendor.

InventoryType:
Where the item can equip to on the Equipment Tab.
0 = Inventory (Can't equip)
1 = Head
2 = Neck
3 = Shoulders
4 = Shirt
5 = Chest
6 = Belt
7 = Legs
8 = Feet
9 = Wrist
10 = Gloves
11 = Ring
12 = Trinket
13 = One-Hander
14 = Shield
15 = Ranged (Bow)
16 = Back
17 = Two-Hander
18 = Bag (Can be equipped on a bag slot)
19 = Tabard
20 = Chest
21 = Main-Hand
22 = Off-Hand Weapon
23 = Off-Hand Misc
24 = Ammo
25 = Thrown
26 = Ranged Gun

AllowableClass/AllowableRace:
Defines if it's Class or Race Specific. IE: Hunter Only, Blood Elf Only
See Golepa's post (http://www.ac-web.org/forum/showthread.php?t=4274#2) for codes.

ItemLevel:
Level of the Item. (No real game impact. Make it 10000 if you want)

RequiredLevel:
Minimum level required to equip the item. (If applicable.)
0 is for everyone.

RequiredSkill:
What profession is required to use it. IE: Tailoring, Blacksmithing, ect ect.
40 = Poisons
129 = First Aid
164 = Blacksmithing
165 = Leatherworking
171 = Alchemy
182 = Herbalism
185 = Cooking
197 = Tailoring
202 = Engineering
333 = Enchanting
356 = Fishing
755 = Jewelcrafting
762 = Riding

RequiredSkillRank:
What skill level of the above skill do you need. 1-375

RequiredSkillSubRank:
Specialty Profession Rank. IE: Shadowcloth Tailor, Armorsmith, Dragonscale Leatherworker.

RequiredPlayerRank1-2:
PvP rank requirements. NO LONGER IN USE. IE: Requires Grand Marshal.

RequiredFaction:
What faction do you need to have to use this item. IE: Stormwind, Sha'tar, Thunder Bluff.
You can find these in D0nd4K!NG's post (http://www.ac-web.org/forum/showthread.php?t=5496).

RequiredFactionStanding:
What you need to be at with above faction.
1 = Hated
2 = Hostile
3 = Unfriendly
4 = Neutral
5 = Friendly
6 = Honored
7 = Revered
8 = Exalted

Unique:
Is the item unique? (Can only have a limited amount. Defined in MaxCount)
0 = No
1 = Yes

MaxCount:
How many of the unique item you can have.

ContainerSlots:
If the item is a bag, how many slots does it have.

StatType1-10:
What stat does this item have. IE: Stam, Str, Agl, ect ect

Bigger list, thanks to Godfree. His post here (http://www.ac-web.org/forum/showthread.php?t=11117).

StatValue1-10:
How much of the above stat to give. Can be negative.

-If we want 10 stamina.. it would look like
-StatType1 = 7; StatValue1 = 10

dmg_min1-5:
What is the minimum damage this item will do on an attack.

dmg_max1-5:
What is the maximum damage this item will do on an attack.

dmg_type1-5:
What kind of damage this item does.
0 = Physical
1 = Holy
2 = Fire
3 = Nature
4 = Frost
5 = Shadow
6 = Arcane

-I want a weapon that deals 100-200 Physical damage, but with 10-20 -Shadow damage. I would first fill out the physical part.
-dmg_min1 = 100; dmg_max1 = 200; dmg_type1 = 0
-Then the shadow part.
-dmg_min2 = 10; dmg_max2 = 20; dmg_type2 = 5

Armor:
How much armor the item gives.

holy_res:
How much Holy resistance the item gives.

fire_res:
How much Fire resistance the item gives.

nature_res:
How much Nature resistance the item gives.

frost_res:
How much Frost resistance the item gives.

shadow_res:
How much Shadow resistance the item gives.

arcane_res:
How much Arcane resistance the item gives.

Delay:
Swing time in milliseconds. (1000 = 1 sec)

-Depending on what you put for your min and max damage, your weapon DPS -is calculated from this. If your min and max was 500-1000, and you have a -delay of 2 seconds, you would take your average swing (750), and divide it -by your delay (in seconds). So DPS would be 750/2. Which is 375 DPS.

Ammotype:
What kind of ammo does this weapon use.
2 = Arrows
3 = Bullets
4 = Thrown

Range:
Range of the weapon.

[Ariac]

Spellid_1-5:
Does this weapon have a spell attached? IE: Frostbolt, Ignore Armor, Kill Stuff

Spelltrigger_1-5:
What causes the spell to be used.
0 = Use
1 = Equip
2 = Chance-on-Hit

SpellCharges_1-5:
How many times this effect can be used before making it unusable.

SpellCooldown_1-5:
How often this effect can be used (Or how often it can proc). Time in milliseconds.

SpellCategory_1-5:
Does it share a cooldown with anything else?
-1 = No Category
0 = GCD

SpellCategoryCooldown_1-5:
How long of a cooldown will it impose on the shared Category.

Bonding:
How the item bonds.
0 = Does not Bind
1 = Bind on Pickup
2 = Bind on Equip
3 = Bind on Use
4 = Quest Item

Description:
The yellow text underneath the item info.

Page_id:
Can you read it? If yes, like the ID of the text it links to. Otherwise put 0.

Page_language:
Assuming what language it's in. Put 0.

quest_id:
Is this item linked to a quest? As in a required item for completion. ID of the quest goes here.

lock_id:
Assuming that this means is it locked. Set to 0.

lock_material:
No idea. Set to -1.

Sheathid:
When you're not using the weapon, where does it go.
0 = Can't see
1 = Back
2 = Back
3 = Side
4 = Back (Shield)
7 = Fist

Randomprop:
No idea. Leave at 0.

unk203_1:
No idea. Leave at 0.

block:
Block value of the item.

itemset:
As seen in cruiser101's post (http://www.ac-web.org/forum/showthread.php?t=9314).

MaxDurability:
How much durability does the item have.

Zoneid:
No idea. Leave at 0.

mapID:
Is this item bound to a certain map? (Not sure)

bagfamily:
What kind of bags can this item go into. Leave at 0.

totemcategory:
I got nothing. Leave at 0.

socket_color_1-3:
What color socket does it have.
1 = Meta
2 = Red
4 = Yellow
8 = Blue

unk201_3-7:
Dunno. Leave at 0.

socketbonus:
What is the socketbonus for having all the right color gems?
Best find one on an item you like and copy it over.

GemProperties:
Dunno. Unless you're making a gem, don't worry about it.

ItemExtendedCost:
Does this item cost any items? IE: Spirit Shards.

ArenaRankRequirement:
What arena ranking do you need to use this.
Leave at 0, unless you want to mess with it.

ReqDisenchantskill:
How much enchanting do you need to have to DE this.
0-375
-1 = Cannot be Disenchanted.

Unk2:
No Idea. Leave at 0.

WHEW.. fill in the desired information, and now that that's done.. make sure you save your work. (In navicat just close the window), and exit out of your program.

STEP 5:
Start your server!
If it's been on, all you need to do is type in " .reloadtable items "
and .additem <entry #> to bring it to life!

NOTE: Should you change your item, you need to delete the cache. Go into your World of Warcraft Directory, find the folder named Cache, and delete it. Start WoW up again.

Thanks for reading! I know it was a LONG ass post. My first tutorial. If anyone knows what information goes into the blanks I left, please do tell!

Enjoy,
Ariac


PS: Almost made the limit.. 11595 characters long. 11000 post limit. GG ME!

[Clain]

Very nice job, +rep.

For some reason I have to spread it =(

[wareagle920]

ill cover it clain :p

[Vex]

Very Nice! Thx! Long detailed Tutorials are good...very good.

[dondon]

Yeah :) Nice!

[bigmanqqq]

great job, very clear and easy to understand. Thanks a bunch!

[Xavian]

This was a very big help and i now have my very own custom weapon ;)

Thanks alot :D

[Clain]

Ariac your one of the few that actually learn and contribute here when they first join. That is one reason why I didn't disabl pms on you :P

[Ariac]

Heh, I'm pretty adept at learning. I've had to reset my server a few times.. (As in completely restarting it), because I'm messing around in things I shouldn't have. I didn't see an in-depth item tutorial, so I siad.. hell, I'll make one. But thanks! And.. Disable PMs.. o-o? I don't even use em.. to my knowledge.. lemmi check.. nope. Nutin'.

Also.. updated list thanks to Godfree's Post (http://www.ac-web.org/forum/showthread.php?t=11117).

[sudo1100]

I made my GM weapon based on this tut but it says "You'll never be able to equip that". I cleared cache and checked that it isn't race/class specific. What should i do?

[Ariac]

What kind of weapon do you want it to be? You have to make sure the main ones like Class/Subclass/InventoryType are the right thing. You also need to make sure you have the skill to wield said weapon.

[jlong]

The flags are whether its for TBC or not.
If you set it at 0 then anyone can have it and use it. If its at 8 then its TBC only.

[joelberg]

+rep DUDE ! :D really need this ^^

[karrz]

great tutorial +rep

[medawolf]

im pretty sure that the flags is TBC or non TBC 8 is TBC and 0 is non its like that when you use .account flags on a player if you have your own server

[Markspark762]

Thanks i love tutorials like this they are so easy to understand etc

[romanvitanza]

Well there is a much easer way.
Open WoW-V if you havnt already
Then enter the spawn code of the item you want.
then download the batch file.
NOW, go to ascent, right click it, export and then hit thr 3 ... and upload it

then .reload items

[poklm]

i get an error that says ACCSESS DENIED

[Cal27]

I made my GM weapon based on this tut but it says "You'll never be able to equip that". I cleared cache and checked that it isn't race/class specific. What should i do?
Make sure your allowable race/class are set to -1, not 0.

[ArticBlue]

Many Questions Comin xD
But You Have To Answer Mine ;D

I Got A Question Mark On My Item.
It Is Something With The Display ID.. Or Something.
Assist Me ! ( x)

[Willzors]

wow.. very well explained, but though.. when i try to equip the item it says i can't use the item.. even when i'm draging it.

nevermind i got it working ^^

[fournexus]

Thank you for the TUT i was in need of one. I have reddid the complete install 8 times since i started the private server 2 days ago.

[DelialFallen]

This is the most frustrating thing ever. I've made an item, it says I can't equip it. Checked to see if my allowable races was set to -1, set it to -1. Then I read a post above about someone who wasn't able to equip an item, said they found a way... but failed to share how. I've been browsing these forums for hours for an answer.

[djmatias]

i dont get anything to the connections PLS help

[lameRtje]

Question, if you make armor how can you get the profiency like "Leather"??

Cause i can't wear it because it says i've got the wrong proficiency

Greetz,,

lameRtje

[Osha]

Hey i did everything here.. but something aint right :S are you suppose to just close navicat? and when i try and add the id 5533021 it just says that it is not a vaild item :S and when i try to reload table it says bla bla bla server may experiance some lag then it says it failed :S is that normall? please help : D

Hey i did everything here.. but something aint right :S are you suppose to just close navicat? and when i try and add the id 5533021 it just says that it is not a vaild item :S and when i try to reload table it says bla bla bla server may experiance some lag then it says it failed :S is that normall? please help : D


tho it was a really good tut : D

[thekid753]

Great tutorial now i see what you ment when you said delete cache cuz i dident fallow that step and my game crashed T_T ill remember now

[a963b789]

Or you could just go on wow v >_>

[tisthename]

i can't use it! and i can't understand why, i did it just like another item, but it still didn't work! why not?:confused::confused:

[Germata]

ok i did everything you told me to do on the guide but when i am trying to reload the db it says Database reload failed.
And i also tryed it with an restart of the server.
didnt work always says 500000 is an invalid Item
pls help

[omgwtfdruid]

great tut man i could'nt find any like this :D

+rep

[gravemindx]

well, i love it!! :D:D, just made my GM weapon [maybe something to good :P]: omfg.jpg - ImageHost.org (http://g.imagehost.org/view/0113/omfg)

djmatias, explane it with a pic or something

oh and Osha & Germata, make sure you did it in the arcemu -> items database and you got a to high entry, just do it around the 9000 or somthing not 5000000+ :P, that will work [everyone that have a problem make sure you did it in the arcemu database, that is very important, and also dont give it to high entry, just arount 1000-12000] this did work for my, i had the problem too.

+rep if it works, please :D:D :P :D:D

[kenwood98]

i tried this and now ingame it says no items found not a single item apears.any advice on what happened

[chrono31]

You should tell everyone that you cant do this in the free version.

In order to use the filter wizard option you will need to buy
Enterprise.Because you cant access filter wizard in the free
version...

[Neglected]

Please note this tutorial dates back to 2008 and I hardly believe the OP is going to be updating it. Kenwood necro'd the topic. Use HeidiSQL, it's free and it has the same features.

[tjohnson22]

You can get navicat premium for free i have not even a trial version once downloaded it brings up the 30 day trial option press the cross on that window and it starts up i have had it for half a year at the moment.

Btw that was in response of Neglected's post :)