Also ich habe mir gestern mal auf http://wow-v.com/ ein Item erstellt das dann in meine mangos Datenbank gebatcht und wollte es mir dann adden
aber leider zeigt er mir wenn ich die ID des Items (999999) Eingebe immer an "Invalid Item" aber ich habe das Item doch richtig in meine Db reingepatcht und es ist auch kein Fehler dabei aufgetreten
Ich weiß net was ich machen soll
bitte helft mir

Also es sind eigentlich mehrere:
1.
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 (999999, 2, 7, -1, "Die Unaufhaltbare Macht", 999999, 5, 0, 0, 10009, 10009, 13, -1, -1, 999, 245, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 1, 99999, 3, 99999, 4, 99999, 5, 99999, 12, 99999, 7, 99999, 31, 99999, 15, 99999, 14, 99999, 1, 99999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 1, 9999999999, 9999999999, 2, 9999999999, 9999999999, 3, 9999999999, 9999999999, 5, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 18060, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 0, 1, "Wer das hat ist ein Admin", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 4, 0, 4, 0, 4, 0, 3303, 0, 0, 0, 'internalitemhanler', 0);

2.
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 (9999999, 4, 4, -1, "Die Unaufhaltbare Macht", 9999999, 5, 0, 0, 999, 999, 3, -1, -1, 999, 245, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 99999, 4, 99999, 5, 99999, 3, 99999, 15, 99999, 14, 99999, 7, 99999, 16, 99999, 35, 99999, 36, 99999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "Wer das hat ist ein Admin", 0, 0, 0, 0, 0, 6, 0, 0, 0, 99999999, 0, 99999, 0, 0, 0, 0, 8, 0, 8, 0, 8, 0, 3305, 0, 0, 0, 'internalitemhanler', 0);

3.
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 (99999999, 1, 0, -1, "Die Unaufhaltbare Macht", 99999999, 5, 0, 0, 999, 999, 18, -1, -1, 999, 245, 0, 0, 0, 0, 0, 0, 0, 4, 4, 36, 3, 99999, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 20, 99999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 1, "ADMIN TASCHE", 0, 0, 0, 0, 0, 8, 0, 0, 0, 99999999, 0, 0, 0, 0, 0, 0, 2, 0, 2, 0, 2, 0, 3305, 0, 0, 0, 'internalitemhanler', 0);

So das waren alle =)
hoffe das hilft

Es gibt eigentlich nur den Fehler das ich die Items net adden kann beim batchen läuft alles ohne Fehler durch
nur wenn ich sie mir eben adden will kommt immer "Invalid Item"