Code:
Query:
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 (35004,2,0,-1,"Arcums Thundersword","Arcums Thundersword","Arcums Thundersword","Arcums Thundersword",30606,5,0,6753540000,0000,13,-1,-1,255,255,0,0,0,0,0,0,0,2,1,0,1,1000,3,1000,4,1000,14,1000,0,0,0,0,0,0,0,0,0,0,0,0,7000,9000,0,7000,9000,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.00,0,0,34696,2,0,0,0,0,14049,1,0,0,0,0,35844,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"ZzZZapPpP",0,0,0,0,0,1,3,0,0,0,0,300,0,0,0,0,1,0,2,0,4,0,2910,0,0,0,0)
Error occured at:2007-09-20 18:28:48
Line no.:2
Error Code: 1264 - Out of range value adjusted for column 'buyprice' at row 1
Query:
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 (35009,2,7,-1,"Arcums Thundesword","Arcums Thundesword","Arcums Thundesword","Arcums Thundesword",30606,5,0,453465760000,0000,13,-1,-1,255,255,0,0,0,0,0,0,0,2,1,0,3,1000,1,1000,5,1000,14,1000,0,0,0,0,0,0,0,0,0,0,0,0,7000,9000,0,7000,9000,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,34696,2,0,0,0,0,15831,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"zap!!",0,0,0,0,0,1,3,0,0,0,0,300,0,0,0,0,1,0,2,0,4,0,1585,0,0,0,0)
Error occured at:2007-09-20 18:32:04
Line no.:2
Error Code: 1264 - Out of range value adjusted for column 'buyprice' at row 1
Query:
DELETE FROM creature_template WHERE entry BETWEEN '500000' AND '500100'
Error occured at:2007-09-20 18:54:19
Line no.:3
Error Code: 1146 - Table 'antrix.creature_template' doesn't exist
Query:
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 (111000,4,4,-1,"Deathknight Corruptors Gauntlets","Deathknight Corruptors Gauntlets","Deathknight Corruptors Gauntlets","Deathknight Corruptors Gauntlets",35050,5,0,150000000,5000000,10,2,-1,150,80,0,0,0,0,0,0,0,1,1,0,4,106,5,90,7,95,19,45,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,2113,0,0,0,50,50,0,0,0,0,35954,1,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,6,0,0,0,0,0,250,0,0,0,0,2,0,4,0,8,0,2874,0,0,0,0)
Error occured at:2007-09-20 19:00:13
Line no.:2
Error Code: 1062 - Duplicate entry '111000' for key 1
Query:
/*Data for the table `creature_proto` */
insert into `creature_proto`(`entry`,`level`,`faction`,`health`,`mana`,`scale`,`npcflags`,`attacktime`,`mindamage`,`maxdamage`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`mountdisplayid`,`item1slotdisplay`,`item1info1`,`item1info2`,`item2slotdisplay`,`item2info1`,`item2info2`,`item3slotdisplay`,`item3info1`,`item3info2`,`respawntime`,`resistance0_armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money`) values (A BUNCH OF RANDOM NUBERS.....)
Error occured at:2007-09-20 19:36:09
Line no.:211
Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes
Query:
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 (35001,2,2,-1,"Arcums Firebow","Arcums Firebow","Arcums Firebow","Arcums Firebow",35870,0,0,100000000,0000,15,-1,-1,105,100,0,0,0,0,0,0,0,1,1,0,1,1000,3,1000,4,1000,20,1000,13,1000,0,0,0,0,0,0,0,0,0,0,7000,9000,0,7000,9000,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,2,100,28735,1,0,0,0,0,17713,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Burn baby burn...",0,0,0,0,0,1,0,0,0,0,0,300,0,0,0,0,1,0,2,0,4,0,106,0,0,0,0)
Error occured at:2007-09-21 17:47:19
Line no.:2
Error Code: 1062 - Duplicate entry '35001' for key 1
Query:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(32000, "Dungeon Set 1", "Dungeon Set 1", 0, 4, 0, 3, 0, NULL, 19216, 1, 1, 1, 0)
Error occured at:2007-09-22 21:54:23
Line no.:4
Error Code: 1062 - Duplicate entry '32000' for key 1
Query:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(32001, "Dungeon Set 2", "Dungeon Set 2", 0, 4, 0, 3, 0, 0, 12910, 1, 1, 1, 0)
Error occured at:2007-09-22 21:57:58
Line no.:9
Error Code: 1062 - Duplicate entry '32001' for key 1
Query:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(32000, "Dungeon Set 1", "Dungeon Set 1", 0, 4, 0, 3, 0, NULL, 19216, 1, 1, 1, 0)
Error occured at:2007-09-22 21:59:07
Line no.:4
Error Code: 1062 - Duplicate entry '32000' for key 1
Query:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(32000, "Dungeon Set 1", "Dungeon Set 1", 0, 4, 0, 3, 0, NULL, 19216, 1, 1, 1, 0)
Error occured at:2007-09-22 21:59:12
Line no.:4
Error Code: 1062 - Duplicate entry '32000' for key 1
Query:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(32000, "Dungeon Set 1", "Dungeon Set 1", 0, 4, 0, 3, 0, NULL, 19216, 1, 1, 1, 0)
Error occured at:2007-09-22 22:46:42
Line no.:4
Error Code: 1062 - Duplicate entry '32000' for key 1
wtf DO I CHANGE FOR IT TO WORK! oops caps lol