[Guide] Safe and Easy way of Making Custom *Armor*Weapons*Bags*Etc.

[nether drake]

how can i get the display id ? sigh

[frostyman]

I dso it, and it is succesful, but when i try to additem it says its invalid

[alcanor1]

very good thank you for sharing

[zedicus10]

Is there a different place I can get models they dont have any good ones....

[TripZone]

good guide XD

[chernandez]

When I use SQLyog and Execute theres an error
Error occured at:2007-06-01 10:25:35
Line no.:0
Error Code: 1049 - Unknown database 'mangos_bc'

Query:
Over and over again Help!!

[Job For a Cowboy]

When I use SQLyog and Execute theres an error
Error occured at:2007-06-01 10:25:35
Line no.:0
Error Code: 1049 - Unknown database 'mangos_bc'

Query:
Over and over again Help!!

Use navicat, there are some cracks for it on mmowned

[Jimbo]

I tried this, but it doesn't work.. well it worked for 4 of my items, but the rest I get this message:
[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 '0,0,1141,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Crafted for the god of winter"' at line 2
[Msg] Finished - Unsuccessfully

Can you help me? Cause I don't really understand what it tells me to do

[Job For a Cowboy]

I tried this, but it doesn't work.. well it worked for 4 of my items, but the rest I get this message:
[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 '0,0,1141,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Crafted for the god of winter"' at line 2
[Msg] Finished - Unsuccessfully

Can you help me? Cause I don't really understand what it tells me to do

That red zero is susposed to be your ".additem ####" so change that

[Jimbo]

Thanks, but it didn't work =/ Any other suggestions?

[Runesixten]

I have maked a shield 2 times and it keeps saying "item cant be equipped" everything else is okay, maybe it thinks it is a bag or something, here is it INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, 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, RangedModRange, 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, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (456789,4,6,-1,"Big Bad Voodoo shield of da voodoo lord",30872,6,0,0,1000000,500000,14,-1,-1,70,1,0,0,0,0,0,0,0,0,1,0,6,999,6,999,6,999,5,999,5,999,5,999,12,999,14,999,15, 999,13,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,999,0,0,0,0,100,0,0,0,0,35844,1,0,0,0,0 ,35844,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,0,"Stay away from da voodoo",0,0,0,0,0,8,4,0,0,999,0,999,0,0,0,0,0,0,0,0,0,0,2871,0,0,0,0,"internalit emhanler",0);

[Job For a Cowboy]

I've made alot of item and never had any problems with them hwere is a sample of my shield

INSERT INTO items (entry, class, subclass, field4, name, 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 (5455618,4,6,-1,"Shield of Hope","Shield of Hope","Shield of Hope","Shield of Hope",20974,6,0,12676754,357687,14,-1,-1,0,0,0,0,0,0,0,0,0,0,1,0,7,126,0,0,4,76,0,0,3,84,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,9237,0,0,0,0,0,0,0,0,0,7600,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,1,"From Thrall's Himself",0,0,0,0,0,6,0,0,0,3245,0,250,0,0,0,0,0,0,0,0,0,0,90,0,0,0,0);

[Rave_xxl5000]

Does anyone know how to set the display ID manually, because everything else works fine?
I made my items, imported them and ran the .additem command, that part is very cool. But my 32 slot bags looks like a bracer, and my weapons are red question marks on the paper doll screen, then when I equip them, it looks like I'm holding a blue and white rubics cube.
I've checked my display ID's against Wowhead.com, Thottbot.com, and wow.allakhazam.com... and they match.
Is there a trick that I'm missing with the display ID, or is it because I'm running on the Ascent core?

(I thought Antrix was the same thing)

[Koest]

Cool +rep and btw..wow-v has Ids ..

[james07]

i need help with my server i laoded a DB on to sqlyog and when i get on wow there are no vendors or anytihn :S