[Realese]Chrispeee NEW updated Ascent Repack

[sess839]

Could I just copy and paste my maps from my old Antrix Server?

yea as long as its current with 2.1 there shouldn't be a problem.

[phc_chaos]

i downloaded this.. does it need antrix to work or something? every vendor download i use always fails I dont know how to get them to work..

any advice?

i have tompack on my computer..
MySQL / realmid / Mangos
and I start them up in that order..

so this is antrix only right or can it be used with mangos to?
sorry I have these noob questions but i've been trying to get these vendors and crap for months..

link for antrix or whatev plz ?

[Losheau]

Do mounts work? Also is this compatible with Patch 2.2.0?

[bomber1392]

this is kool and all but you said dont use the realserver and i have that problem like they have it closes instantly i reped you also but i connect just no realm plz help thanks

[phc_chaos]

this is kool and all but you said dont use the realserver and i have that problem like they have it closes instantly i reped you also but i connect just no realm plz help thanks

is yer realmlist correct?
and are the maps and stuff there?

[Mazzox]

The blood elf and dreanei problem would be your fault. You didn't enable TBC on your account in SQLyog/Navicat.

Could you explains where to enable it ? I searched the database but cant find where to enable TBC!

[Mesmoras]

It's in many guides posted all over this sight bro. :squint: Go to you accounts table and set flags from 0 to 8

[Mazzox]

It's in many guides posted all over this sight bro. :squint: Go to you accounts table and set flags from 0 to 8

But not in any of the ones i used to set up my server
Found it after a bit of searching just before you posted, thanx anyways! =)

[clxwing]

Just a quick question if someone could answer it for me please. I downloaded the latest repack and got it online with no problems. My only issue is the instance Naxxramas. I did update to ver 1415 of ascent to see if it was a problem there since it has a script for it but everytime I try to teleport there it says invalid instance. Does anyone have a working Naxxramus or maybe its something im doing. Any help would be greatly appreciated. By the way your repacks are awesome.

Thanks,
Scott

[sess839]

ya I have been having a problem with this instance too, so its not just you.

[Losheau]

Just a quick question if someone could answer it for me please. I downloaded the latest repack and got it online with no problems. My only issue is the instance Naxxramas. I did update to ver 1415 of ascent to see if it was a problem there since it has a script for it but everytime I try to teleport there it says invalid instance. Does anyone have a working Naxxramus or maybe its something im doing. Any help would be greatly appreciated. By the way your repacks are awesome.

Thanks,
Scott

Naxxramas has never worked they're missing 3 or 4 map pieces for it so thats why it says it is an "Invalid Instance."


Question:
Antrix.exe pop-ups then closes any reason why?

2nd Question I get this Error When Executing the DB

Query:
INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435, 23420,32352,10)
Error occured at:2007-09-14 16:50:05
Line no.:1
Error Code: 1062 - Duplicate entry '593432' for key 1
Query:
INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435, 23420,32352,10)
Error occured at:2007-09-14 16:50:10
Line no.:1
Error Code: 1062 - Duplicate entry '593432' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 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, 0, 0, 0, 0, 0, 0, 0, 18050, 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, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-09-14 16:50:20
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 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, 0, 0, 0, 0, 0, 0, 0, 18050, 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, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-09-14 16:58:58
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO `creatureloot` VALUES (593412,22917,32837,5),(593413,22917,32838,5),(593414,22917,31091,100),(593415,2 2917,31090,100),(593416,22917,31089,100),(593417,22917,32375,10),(593418,22917,3 2374,10),(593419,22917,32497,10),(593420,22917,32496,10),(593421,22917,32500,10) ,(593422,22917,32525,10),(593423,22917,32471,10),(593424,22917,32336,10),(593425 ,22917,32524,10),(593426,22917,32483,10),(593427,22917,32235,10),(593431,22917,3 2521,10)
Error occured at:2007-09-14 17:03:24
Line no.:1
Error Code: 1062 - Duplicate entry '593412' for key 1
Query:
INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435, 23420,32352,10)
Error occured at:2007-09-14 17:03:29
Line no.:1
Error Code: 1062 - Duplicate entry '593432' for key 1
Query:
INSERT INTO `creatureloot` VALUES (593428,22949,32331,10),(593429,22949,32376,10),(593430,22949,32519,10)
Error occured at:2007-09-14 17:03:33
Line no.:1
Error Code: 1062 - Duplicate entry '593428' for key 1
Query:
INSERT INTO `creatureloot` VALUES (593385,21867,32280,10),(593386,21867,32323,10),(593387,21867,32324,10),(593388, 21867,32325,10),(593389,21867,32326,10),(593390,21867,32327,10),(593391,21867,32 328,10),(593392,21867,32329,10),(593393,21867,32330,10),(593394,21867,32348,10), (593395,21867,32510,10),(593396,21867,32512,10),(593397,21867,32737,10),(593398, 21867,32739,10),(593399,21867,32745,10),(593400,21867,32745,10),(593401,21867,32 747,10),(593402,21867,32749,10),(593403,21867,32751,10),(593404,21867,32752,10), (593405,21867,32755,10),(593406,21867,32738,10),(593407,21867,32744,10),(593408, 21867,32753,1),(593409,21867,32750,1),(593410,21867,32746,1),(593411,21867,32753 ,1)
Error occured at:2007-09-14 17:03:37
Line no.:1
Error Code: 1062 - Duplicate entry '593385' for key 1
Query:
/* Creature_Proto */
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-09-14 21:07:49
Line no.:137
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
/* Creature_Proto */
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-09-14 21:07:54
Line no.:137
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
/* Creature_Proto */
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-09-14 21:08:26
Line no.:137
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
/* Creature_Proto */
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-09-14 21:17:03
Line no.:137
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
/* Creature_Proto */
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-09-14 21:17:14
Line no.:137
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
/* Creature_Proto */
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-09-14 21:17:28
Line no.:137
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
/* Creature_Proto */
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-09-14 21:19:27
Line no.:137
Error Code: 1136 - Column count doesn't match value count 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 (120004,11,2,-1,"Endless Arrow Quiver","Endless Arrow Quiver","Endless Arrow Quiver","Endless Arrow Quiver",4324,5,0,100000,100000000,18,-1,-1,230,70,0,0,0,0,0,0,0,0,1,32,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,0,0,0,0,0,0,0,0,0,0,0,0,0,29414,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,"You shall never go back to a arrow vendor.",0,0,0,0,0,-1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-17 18:28:32
Line no.:2
Error Code: 1062 - Duplicate entry '120004' for key 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 (1937431,4,1,-1,"Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet",42765,2,0,1500,1000,1,-1,-1,10,1,0,0,0,0,0,0,0,1,1,0,3,10,4,10,5,10,6,20,7,15,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,75,0,0,0,0,0,0,0,0,0,7597,1,0,0,0,0,9140,1,0,0,0,0,33021,1 ,0,0,0,0,33021,1,0,0,0,0,0,0,0,0,0,0,0,"Courrpted armor passed to only the most worthy.",0,0,0,0,0,6,0,0,0,0,0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 18:59:50
Line no.:2
Error Code: 1062 - Duplicate entry '1937431' for key 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 (1937431,4,1,-1,"Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet",42765,2,0,1500,1000,1,-1,-1,10,1,0,0,0,0,0,0,0,1,1,0,3,10,4,10,5,10,6,20,7,15,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,75,0,0,0,0,0,0,0,0,0,7597,1,0,0,0,0,9140,1,0,0,0,0,33021,1 ,0,0,0,0,33021,1,0,0,0,0,0,0,0,0,0,0,0,"Courrpted armor passed to only the most worthy.",0,0,0,0,0,6,0,0,0,0,0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 19:00:25
Line no.:2
Error Code: 1062 - Duplicate entry '1937431' for key 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 (100000,4,1,-1,"Primal Gloves","Primal Gloves","Primal Gloves","Primal Gloves",41154,4,0,0000,0000,10,-1,-1,150,80,0,0,0,0,0,0,0,2,1,0,18,1000,5,1000,21,1000,30,1000,7,1000,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,1000,1000,1000,1000,1000,1000,1000,0,0,0,35 844,1,0,0,0,0,35844,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,500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 19:00:40
Line no.:4
Error Code: 1062 - Duplicate entry '100000' for key 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 (100000,4,1,-1,"Primal Gloves","Primal Gloves","Primal Gloves","Primal Gloves",41154,4,0,0000,0000,10,-1,-1,150,80,0,0,0,0,0,0,0,2,1,0,18,1000,5,1000,21,1000,30,1000,7,1000,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,1000,1000,1000,1000,1000,1000,1000,0,0,0,35 844,1,0,0,0,0,35844,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,500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 19:01:15
Line no.:4
Error Code: 1062 - Duplicate entry '100000' for key 1
Query:
.sqlINSERT 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 (1937431,4,1,-1,"Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet",42765,2,0,1500,1000,1,-1,-1,10,1,0,0,0,0,0,0,0,1,1,0,3,10,4,10,5,10,6,20,7,15,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,75,0,0,0,0,0,0,0,0,0,7597,1,0,0,0,0,9140,1,0,0,0,0,33021,1 ,0,0,0,0,33021,1,0,0,0,0,0,0,0,0,0,0,0,"Courrpted armor passed to only the most worthy.",0,0,0,0,0,6,0,0,0,0,0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 19:21:58
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.sqlINSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4' at line 1
Query:
.sqlINSERT 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 (1937431,4,1,-1,"Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet",42765,2,0,1500,1000,1,-1,-1,10,1,0,0,0,0,0,0,0,1,1,0,3,10,4,10,5,10,6,20,7,15,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,75,0,0,0,0,0,0,0,0,0,7597,1,0,0,0,0,9140,1,0,0,0,0,33021,1 ,0,0,0,0,33021,1,0,0,0,0,0,0,0,0,0,0,0,"Courrpted armor passed to only the most worthy.",0,0,0,0,0,6,0,0,0,0,0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 19:21:59
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.sqlINSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4' at line 1
Query:
.sqlINSERT 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 (1937431,4,1,-1,"Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet",42765,2,0,1500,1000,1,-1,-1,10,1,0,0,0,0,0,0,0,1,1,0,3,10,4,10,5,10,6,20,7,15,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,75,0,0,0,0,0,0,0,0,0,7597,1,0,0,0,0,9140,1,0,0,0,0,33021,1 ,0,0,0,0,33021,1,0,0,0,0,0,0,0,0,0,0,0,"Courrpted armor passed to only the most worthy.",0,0,0,0,0,6,0,0,0,0,0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 19:22:00
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.sqlINSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4' at line 1
Query:
.sqlINSERT 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 (1937431,4,1,-1,"Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet",42765,2,0,1500,1000,1,-1,-1,10,1,0,0,0,0,0,0,0,1,1,0,3,10,4,10,5,10,6,20,7,15,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,75,0,0,0,0,0,0,0,0,0,7597,1,0,0,0,0,9140,1,0,0,0,0,33021,1 ,0,0,0,0,33021,1,0,0,0,0,0,0,0,0,0,0,0,"Courrpted armor passed to only the most worthy.",0,0,0,0,0,6,0,0,0,0,0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 19:22:01
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.sqlINSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4' at line 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 (1937431,4,1,-1,"Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet","Corrupted Hero's Helmet",42765,2,0,1500,1000,1,-1,-1,10,1,0,0,0,0,0,0,0,1,1,0,3,10,4,10,5,10,6,20,7,15,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,75,0,0,0,0,0,0,0,0,0,7597,1,0,0,0,0,9140,1,0,0,0,0,33021,1 ,0,0,0,0,33021,1,0,0,0,0,0,0,0,0,0,0,0,"Courrpted armor passed to only the most worthy.",0,0,0,0,0,6,0,0,0,0,0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-18 19:22:47
Line no.:2
Error Code: 1062 - Duplicate entry '1937431' for key 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 (120011,1,0,-1,"Endless Bag of Tears","Endless Bag of Tears","Endless Bag of Tears","Endless Bag of Tears",3213,5,0,0000,0000,18,-1,-1,0,0,0,0,0,0,0,0,0,0,1,32,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,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,0,0,0 ,0,0,0,0,0,0,0,0,1,"You see tears falling",0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Error occured at:2007-09-19 19:50:21
Line no.:2
Error Code: 1062 - Duplicate entry '120011' for key 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 (120008,4,1,-1,"Shield of Stan","Shield of Stan","Shield of Stan","Shield of Stan",19840,5,0,0000,0000,14,-1,-1,700,70,0,0,0,0,0,0,0,1,1,0,1,100,3,25,4,30,5,10,6,5,7,50,12,75,15,50,35,50,13, 25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3750,25,25,25,25,25,25,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,0,1,"It was said that Stan himself used this shield.",0,0,0,0,0,5,4,0,0,500,0,100,0,0,0,0,2,0,4,0,8,0,2888,0,0,0,0)
Error occured at:2007-09-21 18:03:01
Line no.:2
Error Code: 1062 - Duplicate entry '120008' for key 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 (120012,4,1,-1,"Chest Armor of Stan","Chest Armor of Stan","Chest Armor of Stan","Chest Armor of Stan",36077,5,0,0000,0000,5,-1,-1,70,70,0,0,0,0,0,0,0,1,1,0,1,150,3,50,3,50,5,50,6,50,7,50,13,50,31,50,33,50,14, 50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1600,30,30,30,30,30,30,0,0,0,17713,1,0,0,0,0,18 060,1,0,0,0,0,35842,1,0,0,0,0,14056,1,0,0,0,0,15820,1,0,0,0,0,1,"Looks like Stan forgot to wash it.",0,0,0,0,0,7,0,0,0,0,0,200,0,0,0,0,0,0,0,0,0,0,2874,0,0,0,0)
Error occured at:2007-09-21 18:03:19
Line no.:2
Error Code: 1062 - Duplicate entry '120012' for key 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 (120018,4,1,-1,"Belt of Stan","Belt of Stan","Belt of Stan","Belt of Stan",26437,5,0,0000,0000,6,-1,-1,300,70,0,0,0,0,0,0,0,1,1,0,1,100,3,50,4,50,5,50,6,50,7,50,12,20,13,10,14,20,35 ,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,800,15,15,15,15,15,15,0,0,0,7599,1,0,0,0,0,140 52,1,0,0,0,0,35893,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"This belt has kept Stans pants up. Hope it will do the same for you!",0,0,0,0,0,7,0,0,0,0,0,150,0,0,0,0,2,0,4,0,8,0,2865,0,0,0,0)
Error occured at:2007-09-21 18:03:34
Line no.:2
Error Code: 1062 - Duplicate entry '120018' for key 1
Query:
INSERT INTO `trainers` VALUES ('372', '186', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60', '0', 'Hello, Ãâââà ¢â€šÂ¬Ã…¡Ã‚¬Ã…ÂÂÂ**.')
Error occured at:2007-09-27 18:06:05
Line no.:964350
Error Code: 1406 - Data too long for column 'TalkText' at row 1
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
Error occured at:2007-09-27 18:08:28
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
Error occured at:2007-09-27 18:11:48
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

For the sake of Double Posting I didn't post my other error which went over the limit of 50,000 characters. I had 89341 Characters lol.

[Chrispee]

looooool u need to delete your old db mate first then execute mine

[Losheau]

lol oops my bad Thanks

I have noob moments every now and then

[Mesmoras]

If you think antrix is better, then you fail...

[private server]

Ok i dont know whats going on but mine says unable to validate game version. I dont think i have all the maps also, so if someone could healp me out it would be much appreciated
note: I am kinda New at this so if whatevers wrong is obvious im srry