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

[X-Gogeta]

Nice guide +rep after i pass some around

[frankieboi]

i tryed to make a bag. called "lolbag"
tyed in containers. no problem ad all. giving it a high item ID so i dont destroy onens of those already there.
display ID i took "Large Red Sack" "4056 (found in navicat)"
downloading it. batch file it and get this error

"[Err] 1054 - Unknown column 'name' in 'field list'
[Msg] Finished - Unsuccessfully"

did the same things when i tryed to make a weapon. is it the name iam typing wrong or is it any of the ID's??

would really apreasiate a quick answer (sorry for the bad english :P )

[Job For a Cowboy]

i tryed to make a bag. called "lolbag"
tyed in containers. no problem ad all. giving it a high item ID so i dont destroy onens of those already there.
display ID i took "Large Red Sack" "4056 (found in navicat)"
downloading it. batch file it and get this error

"[Err] 1054 - Unknown column 'name' in 'field list'
[Msg] Finished - Unsuccessfully"

did the same things when i tryed to make a weapon. is it the name iam typing wrong or is it any of the ID's??

would really apreasiate a quick answer (sorry for the bad english :P )

some times the DB gets confused but the Item is still imported, happened to me acouple of times

[ucwicket420]

mine keeps saying




[Err] 1054 - Unknown column 'name' in 'field list'
[Err] 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 (420420,4,2,-1,"Helm of UC","Helm of UC","Helm of UC","Helm of UC",28856,5,0,0000,100000000,1,-1,-1,5,1,0,0,0,0,0,0,0,2,1,0,1,10000,3,10000,4,10000,5,10000,13,10000,21,10000,12,1 0000,18,10000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100000,100000,100000,100000, 100000,100000,100000,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060 ,1,0,0,0,0,18060,1,0,0,0,0,2,"The Uber Crue Helm",0,0,0,0,0,8,0,0,0,1337,0,1337,0,0,0,0,2,0,2,0,2,0,90,0,0,0,0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------



BTW im runnin ASCENT

[samuel2k6]

Could some one pls help me, my problem is that i made a weapon and i uploaded it to my database but i made it with the wrong display ID, could some one tell me how to find the weapon in the database and change the display ID. It would be really apreciated

[PolitisktNamn]

Nice thx xD

[kanqaz]

Nearly to many guides to wow-v :P

[wowowner]

i had to get a different server and i wanted to add my custom weapons back and everyone of the say [Err] 1054 - Unknown column 'name' in 'field list'
[Err] 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 (061895,2,7,-1,"Apocalypse","Apocalypse","Apocalypse","Apocalypse",34112,6,0,500000000,500000 000,13,-1,-1,0,0,0,0,0,0,0,0,0,2,5,0,1,99999,19,99999,7,99999,14,99999,24,99999,15,99999,32 ,99999,4,99999,7,99999,20,99999,9999999999,9999999999,0,9999999999,9999999999,0, 9999999999,9999999999,0,9999999999,9999999999,0,9999999999,9999999999,0,0,999999 99,99999999,99999999,99999999,99999999,99999999,100,0,0,35844,1,0,0,0,0,18060,1, 0,0,0,0,34696,2,0,0,0,0,17713,1,0,0,0,0,7597,1,0,0,0,0,0,"It is a sign of a Apocalypse",0,0,0,0,0,1,1,0,0,0,0,99999999,0,0,0,0,2,0,4,0,8,0,2873,0,0,0,0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[wowowner]

someone pls help me because they all do it

[Soren93]

What is a DB file :S

[Soren93]

What is a DB file :S

[Job For a Cowboy]

A Database File is where you go into your server and do amazing things!

[vernath]

Awesomeness! Though i think it's been posted before +Rep for you!

[Job For a Cowboy]

i was actually the one who posted this first
and still haven't gotten your rep

[Gadella]

Could i get some help please?
I used this guide:
http://www.mmowned.com/forums/emulat...eb-repack.html
But i just cant find out HOW to do it? and i want to do it so much :<