2.4 And Items..

[Kurosan]

Well, after the new update from sectorseven.. I can no longer put new items in the db.

http://i29.tinypic.com/a4v4hd.jpg

Help? Thanks ;o

[C-Death]

My problem is that all it says is invalid item code if i try to add in game. So, any help at all lol

[2dgreengiant]

what did you use to make those items?

[Kurosan]

WoW V, it's probably not updated yet, im guessing.. Is there a tutorial on making items?

[C-Death]

Greengiat, i used ACDBE

[latruwski]

Well, after the new update from sectorseven.. I can no longer put new items in the db.

http://i29.tinypic.com/a4v4hd.jpg

Help? Thanks ;o

copy paste the itemquery you are trying to execute and i'll find the syntax...

[Kurosan]

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 (90001,2,4,-1,"Beginners Hammer","Beginners Hammer","Beginners Hammer","Beginners Hammer",8568,2,0,,,13,-1,-1,0,14,0,0,0,0,0,0,0,1,1,0, 4,8, 7,7, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,32,58,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2500,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,0,0,0,0,1,"",0,0,0,0,0,1,3,0,0,0,0,85,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0);

There ya go =o

[maryus101]

There ya go =o

Try use SQLyog Enterprise . Its 100 times best than navicat or other applications.

[Kurosan]

Try use SQLyog Enterprise . Its 100 times best than navicat or other applications.

No thanks..

[Kurosan]

Still need help.. =[

[Aes]

i added a item from wow-v and it worked perfectly fine.
open notepad>paste the code>save it as 'item'.sql>rightclick your db or whatever and select execute>click the ... and find the item>select it and execute it.
if you get an error tell me.

[Kurosan]

seems they did some updates so it works now, thanks =P

[delldude1989]

Try it Now

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, ReqDisenchantSkill, unk2)
VALUES (90001,2,4,-1,"Beginners Hammer","Beginners Hammer","Beginners Hammer","Beginners Hammer",8568,2,0,,,13,-1,-1,0,14,0,0,0,0,0,0,0,1,1,0, 4,8, 7,7, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,32,58,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2500,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,0,0,0,0,1,"",0,0,0,0,0,1,3,0,0,0,0,85,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0);