Waffen batchen buggt

Ich hab mir Tyras 7er runtergeladen und mir bei wow-v gleich mal ne Waffe erstellt^^ Nur wenn ich jetz mit navicat auf world db geh -> execute Batchfile
kommt immer :)

Quote:

[Err] 1062 - Duplicate entry '21400' for key 1 [Err] 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 (21400,2,8,-1,"Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen",31996,4,0,100000,100000,17,-1,-1,120,70,0,0,0,0,0,0,0,0,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,120,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,160,0,0,7600,1,0,0,0,0,28735,1,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,1,0,0, 0,0,100,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0);VALUES (21400,2,8,-1,"Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen",31996,4,0,100000,100000,17,-1,-1,120,70,0,0,0,0,0,0,0,0,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,120,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,160,0,0,7600,1,0,0,0,0,28735,1,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,1,0,0, 0,0,100,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0); [Msg] Finished - Unsuccessfully

Plx help^^

So wie ich das sehe ist die "Entry ID" doppelt vergeben, stell mal ne andere ein und versuchs nochmal ;)

Quote:

Originally Posted by psYcho aka. SLDZ So wie ich das sehe ist die "Entry ID" doppelt vergeben, stell mal ne andere ein und versuchs nochmal ;)

Genau die ID 21400

[Err] 1062 - Duplicate entry '21400' for key 1

n1 thx

Hmm hab die ID geänder nu kommt

Quote:

[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 (12000,2,8,-1,"Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen",31996,4,0,100000,100000,17,-1,-1,120,70,0,0,0,0,0,0,0,0,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,120,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,160,0,0,7600,1,0,0,0,0,28735,1,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,1,0,0, 0,0,100,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0);VALUES (12000,2,8,-1,"Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen",31996,4,0,100000,100000,17,-1,-1,120,70,0,0,0,0,0,0,0,0,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,120,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,160,0,0,7600,1,0,0,0,0,28735,1,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,1,0,0, 0,0,100,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0); [Msg] Finished - Unsuccessfully --------------------------------------------------

Edit: Help plx keine ahnung was da los is -.-

anyone knows whats my fault?

Bei mir dass gleiche -.-

[Err] 1146 - Table 'mangos.creature_names' doesn't exist
[Err] INSERT INTO `creature_names` VALUES ('235001', 'Gott der Natur', '', '', '0', '10', '0', '0', '0', null, '2160', '0', '0', '0', '1', '1', null, null);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

son scheiß kann weder npcs noch items ein batchen -.-

Kann es sein, dass du (Murachacha) die .sql Datei in die Falsche DB Batchen willst? :D Was anderes würde mir jetzt nicht einfallen :)

@Muracaha: Du machst was falsch:1) Entweder wie gesagt Falsche DB
2) Oder du hast ein Antrix und Batch die Mango datei

leute hab ne frage hab mir ne waffe gemacht aber wenn ich sie im spiel holen will kommt nur so ein rotes fragezeichnen im inventar und ich kann sie net anlegen

hoffe ihr könnt helfen

also bei mir kommt immer

[Err] 1054 - Unknown column 'ExtendedCost' in 'field list'
[Err] 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 (88388,2,2,-1,'Sunstrider`s Longbow',48294,5,0,0,00001,00001,15,-1,-1,171,70,0,0,0,0,0,0,0,1,0,0, 3,15, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0,259,383,0,82,140,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,3000,2,100,10149,2,0,0,0,0,44972,1,0,0,0,0,46 699,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'An heirloom of the Sunstrider Dynasty, this bow`s hilt feels warm to the touch and bowstring almost ethereal.',0,0,0,0,0,1,0,0,0,0,0,135,0,0,0,0,2,0,2 ,0,0,0,75,0,0,0,0,'internalitemhanler',0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------



kann mir da wer helfen?

Suchfunktion hat :

[Only registered and activated users can see links. Click Here To Register...]

ausgeworfen... les mal den letzten Post....

Quote:

Originally Posted by Battleman99 leute hab ne frage hab mir ne waffe gemacht aber wenn ich sie im spiel holen will kommt nur so ein rotes fragezeichnen im inventar und ich kann sie net anlegen hoffe ihr könnt helfen

JA das ist bi den meisten so zieh sie per Drag and Drop ( aufs item klicken mit links klick dan und das "c" fenster rein) an

mfg


<----

einfach rüberziehen -.- standart bei emulatoren... hoffe konnte helfen

Das is nich standart..... Bei den meisten Emulatoren gehts auch bugfrei vorallem wenn du einfach vorhande Items veränderst