[HowTo] Items machen

[Ashintaro]

ok geht doch!

Noch ne Frage, wo bekomm ich kostenlos dieses Navicat her?

[Jangomasterofd]

ne frage hab nen mangos server
in welche db muss ich das batche in die
mangos
realmd
character oder die
scriptdev2
oder muss ich die in den über ordner batchen ?
thx im voraus

[Gordge]

Originally Posted by Jangomasterofd

ne frage hab nen mangos server
in welche db muss ich das batche in die
mangos
realmd
character oder die
scriptdev2
oder muss ich die in den über ordner batchen ?
thx im voraus

realmd

[Thumb]

Originally Posted by Ediso

Schick mir die Datei ich änder sie so das es geht k?

Hab das gleiche problem dass der das nicht gebatcht kriegt ([Msg] Finished - Unsuccessfully). Wie muss man die datei ändern dass das geht?

[Cronaj]

Ok ich brauche hilfe habe mir da schon ein paar waffen gemacht kann sie auch runterladen aber naja da kommt das problem wenn ich sie in die DB's batche kommt da ne fehlermeldung (ach übringens habe nen mangos server)
Hir die fehlermeldung wenn ich die datei in meinen mangos DB batchen will


[Err] 1146 - Table 'mangos.items' doesn't exist
[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, ReqDisenchantSkill, unk2)
VALUES (99999,2,7,-1,"Schwert des Seelenverschlingers","Schwert des Seelenverschlingers","Schwert des Seelenverschlingers","Schwert des Seelenverschlingers",42188,6,0,4000000,3000000,13,-1,-1,200,250,0,0,0,0,0,0,0,0,1,0, 1,5000, 3,250, 4,250, 5,5000, 32,250, 34,250, 19,250, 25,250, 21,250, 27,250,2000,9000,0,2000,9000,5,0,0,0,0,0,0,0,0,0,2 00,200,200,200,200,200,200,1000,0,0,17713,1,0,0,0, 0,34696,2,0,0,0,0,18060,1,0,0,0,0,35844,1,0,0,0,0, 35844,1,0,0,0,0,1,"",0,0,0,0,0,-1,3,0,0,200,0,0,0,0,0,0,1,0,2,0,2,0,0,0,0,0);
[Msg] Finished - Unsuccessfully


Und hir die fehlermeldung wenn ichs in die realmd DB batchen will


[Err] 1146 - Table 'realmd.items' doesn't exist
[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, ReqDisenchantSkill, unk2)
VALUES (99999,2,7,-1,"Schwert des Seelenverschlingers","Schwert des Seelenverschlingers","Schwert des Seelenverschlingers","Schwert des Seelenverschlingers",42188,6,0,4000000,3000000,13,-1,-1,200,250,0,0,0,0,0,0,0,0,1,0, 1,5000, 3,250, 4,250, 5,5000, 32,250, 34,250, 19,250, 25,250, 21,250, 27,250,2000,9000,0,2000,9000,5,0,0,0,0,0,0,0,0,0,2 00,200,200,200,200,200,200,1000,0,0,17713,1,0,0,0, 0,34696,2,0,0,0,0,18060,1,0,0,0,0,35844,1,0,0,0,0, 35844,1,0,0,0,0,1,"",0,0,0,0,0,-1,3,0,0,200,0,0,0,0,0,0,1,0,2,0,2,0,0,0,0,0);
[Msg] Finished - Unsuccessfully


ich weiss auch net in welche DB ich es batchen müsste vllt sind ja beide falsch!?!

Bitte um hilfe

M.F.G

Cronaj

[John Marston]

Hm Ediso mich nimmt's nur Wunder ob der Premium Acc link in deiner Signatur funzt ^^ bei mir funzt er ned

[undi4champ]

ich habe folgende fehlermeldung beim batchen einer waffe
[Err] 1146 - Table 'characters.item_template' doesn't exist
[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, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (50002,2,0,-1,"ZErstörer der Allianz",45479,6,0,0,500000,10000,21,-1,-1,80,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,900,999,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0, 0,0,500,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,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"interna litemhanler",0);VALUES (50002,2,0,-1,"ZErstörer der Allianz",45479,6,0,0,500000,10000,21,-1,-1,80,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,900,999,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0, 0,0,500,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,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"interna litemhanler",0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------
kann mir da jemand helfen?

[Gordge]

Originally Posted by undi4champ

ich habe folgende fehlermeldung beim batchen einer waffe
[Err] 1146 - Table 'characters.item_template' doesn't exist
[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, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (50002,2,0,-1,"ZErstörer der Allianz",45479,6,0,0,500000,10000,21,-1,-1,80,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,900,999,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0, 0,0,500,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,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"interna litemhanler",0);VALUES (50002,2,0,-1,"ZErstörer der Allianz",45479,6,0,0,500000,10000,21,-1,-1,80,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,900,999,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0, 0,0,500,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,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"interna litemhanler",0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------
kann mir da jemand helfen?

du batchst in die falsche Datenbank, characters ist definitiv falsch, realm mangos ascent oder so wird die heissen, aber characters ist ganz bestimmt falsch

[undi4champ]

habs versucht in mangos zu batchen dann kommt aber folgende fehlermeldung
[Err] 1062 - Duplicate entry '50002' for key 1
[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, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (50002,2,0,-1,"Zerstörer der Allianz",45479,6,0,0,500000,10000,21,-1,-1,80,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,900,999,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0, 0,0,500,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,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"interna litemhanler",0);VALUES (50002,2,0,-1,"Zerstörer der Allianz",45479,6,0,0,500000,10000,21,-1,-1,80,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,900,999,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0, 0,0,500,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,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"interna litemhanler",0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------
:-)

bei realmd kommt

[Err] 1146 - Table 'realmd.item_template' doesn't exist
[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, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (50002,2,0,-1,"Zerstörer der Allianz",45479,6,0,0,500000,10000,21,-1,-1,80,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,900,999,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0, 0,0,500,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,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"interna litemhanler",0);VALUES (50002,2,0,-1,"Zerstörer der

[Gordge]

die mangos war schon richtig.... nur muss deine itemid um einiges höher sein... versuch mal ab 600.000
dann sollte es klapen

[undi4champ]

hab die waffe gebatch aberw enn ich dann im spiel .additem 600000 mach komm invalid id weist du da auch rat? ^^

[Gordge]

nach dem batchen neustarten

[undi4champ]

ah funzt danke das man die waffen nicht per rechtsklick anlegen kann ist normal oder?
kennt einer von euch rüssiteile die im spiel richtig cool aussehen? (werte egal)

[Spiolito]

wie findet man denn eine id, die nicht vergeben ist?

[Bibo88k]

Versuchs einfach mit ner relativ hohen zahl, random zahlen wird blizard schon nicht genommen haben. 500.000 wird schon net vergeben sein^^