[bombhell]

Here are the Sites you will need
[Only registered and activated users can see links. ] This is a database of EVERY item in the 2.3 verson....


[Only registered and activated users can see links. ] This is where and what you use to make the item (amor , wepon , bag , ammo etc. )



ok....... now lets look at some of the things you can do with the weapon creator

You can make a 2h sword 1h .....or make it a dagger and theres many other thigns it can do i just wanted to point out that its kool ...(lol)

Any way lets make a completely unfair SUPER god like admin sword..thing...of ...DOOM!!!!!!


First go to wow head and look up the 2 handed weapon
Corrupted Ashbringer
[Only registered and activated users can see links. ] there the link for you people who are lazy



ok now copy the # there (this is the item id ) 22691 and look it up on what ever sql you are useing ....( Note : your Server Should be running or you obviously cant get into mysql) and go to (in my ocation) Ascent > Items > and in search type the # you got from the sword
scroll to the right a bit and you should see the collemn called "display id" copy that # and go to the weapn creator site listed abve and paste it into the display id

now in entry # type something easy to rember like 1234566

i make my Admin items "artifacts " like in this occation ....and i would call the sword "Admin sword of doom " and in the qute section would be like FEAR THIS SWORD OF DOOMZORZ

ok now that you've had your fun scroll down to item type
equip as a 1h and the type is 1hsword duribilty is 1000 ( amazing you have no idea )

under item base stats seath as a 2 hand of the equip it on your back effect and no ammo speed is 1000 (this is done in millaseconds so 1000 is 1.0 )

leave item requirments alone you dont REALLY need that

now you have item dammage dont go over 1,000,000 on it lol it wont work if you do

but ill put like ...500 as min dammage 1000 as max for physical and i wont make any others

now item stats dont go over 50,000 on your stats or again it wont work you can do + all stats + crit rateing etc .

item resits i sugest not going over 50 on every thing i mean cmon you wont need resists after the rapeing stats youve given your weapon

and finaly item bonuses -

i would do steal life and attack power my personal favs

item sockts arent in the need
and leave buy price alone
and sell price 9000 g lol its fun
and finaly just type in the code you get into your Query and click run and it should be in your item table

i hope you enjoy this guide i bombhell have wrote out X_X lol it took a while but it was fun......sorta.....any way if you enjoyed this please <3 ya'll at mm owned and once again enjoy the guide (if i didnt metion above you have to register to use weapon creator but its not that much work for this awsome tool ^_^)~~~Edit~~~


Yeah please leave comments as well <3

[flamecircle]

Awesome But i'm using HeidiSQL, cant seem to find Ascent -> Items ->
Could you help me out please?

[Kolbein]

My server worked just fine yesterday, but now when I start the Ascent.exe,
this error shows up!

[freeza888]

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (147,2,7,-1,"Amin Doom Blade","Amin Doom Blade","Amin Doom Blade","Amin Doom Blade",22691,6,0,50000000,10000000,13,1,-1,260,255,0,0,0,0,0,0,0,1,1,0,4,500,3,500,6,500,7,1000,0,0,0,0,0,0,0,0,0,0,0,0,2 000,5000,2,0,0,0,0,0,0,0,0,0,0,0,0,0,100,1000,100,100,100,100,1000,0,0,34696,2,0 ,0,0,0,17713,1,0,0,0,0,18060,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,1, 1,0,0,0,0,1000,0,0,0,0,1,0,2,0,8,0,106,0,0,0,0);

[colincancer]

k, just something that might help out some ppl, i use this website method alot and all i do is when im done i DL the batch, aka i open it up with HeidiSQl i click on the query tab and right click and hit run, easiest way to do it, i think, if you odnt understand what im saying just say so :P and ill explain it better.

[colincancer]

and Kolbein something that might help ur server out is making sure all of ur .config files r all there.

[pasi4002]

umm when ever i tried to import it using Navicat it says unsuccesfull and 2 errors wtf?

[Rekcah]

Does anyone have an idea on how to get the classes from the ID you get from the item in the database? When I check an item it just says a number as class and I want to know what number corresponds to which class, like cloth, mail etc.

[cooper101]

I went to wow-v.com and i made the vendor and I'm useing heidiSql. So when i inport the item sql it says unknown line level in col. 1.