[HowTo] Items machen

Page 2 of 4 1 2 34
05/27/2008 22:07 Ashintaro#16
ok geht doch!

Noch ne Frage, wo bekomm ich kostenlos dieses Navicat her?
05/28/2008 15:57 Jangomasterofd#17
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
05/28/2008 17:24 Gordge#18
Quote:
Originally Posted by Jangomasterofd View Post
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
06/02/2008 20:56 Thumb#19
Quote:
Originally Posted by Ediso View Post
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?:confused:
06/03/2008 17:10 Cronaj#20
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
06/06/2008 20:59 John Marston#21
Hm Ediso mich nimmt's nur Wunder ob der Premium Acc link in deiner Signatur funzt ^^ bei mir funzt er ned
06/17/2008 20:36 undi4champ#22
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?
06/18/2008 08:23 Gordge#23
Quote:
Originally Posted by undi4champ View Post
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 :)
06/18/2008 13:51 undi4champ#24
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
06/18/2008 14:21 Gordge#25
die mangos war schon richtig.... nur muss deine itemid um einiges höher sein... versuch mal ab 600.000 :)
dann sollte es klapen :)
06/18/2008 14:56 undi4champ#26
hab die waffe gebatch aberw enn ich dann im spiel .additem 600000 mach komm invalid id weist du da auch rat? ^^
06/18/2008 16:09 Gordge#27
nach dem batchen neustarten :)
06/18/2008 20:10 undi4champ#28
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)
06/20/2008 20:05 Spiolito#29
wie findet man denn eine id, die nicht vergeben ist?
06/20/2008 20:23 Bibo88k#30
Versuchs einfach mit ner relativ hohen zahl, random zahlen wird blizard schon nicht genommen haben. 500.000 wird schon net vergeben sein^^
Page 2 of 4 1 2 34