Chrispeee Ascent Db [Realese NEw]

[LTGH]

Chrispeee for the own! i most try this out right now.

[SuperDemon]

is it work on antrix ?

[Guysus]

Thank you !!!

[balmug19]

ok im getting this problem trying to change my db



[Err] 1050 - Table 'accounts' already exists
[Err] -- ----------------------------
-- Table structure for accounts
-- ----------------------------
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=3 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

help me please

[Mesmoras]

It's saying you already have an accounts table in that database. If it's an existing db that's not chrispeee's, or if it's an existing account table then you should either create a new db (if it's an existing db) or drop the accounts table (if it's an existing account table).

[Squishyy]

Wont Work :*(




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, _type10, stat_value10, mg_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 (70000,4,1,-1,"WoWRawrz","WoWRawrz","WoWRawrz","WoWRawrz",1981,5,0,99999999999,10101,5,-1,-1,75,70,0,0,0,0,0,0,0,1,1,0,7,100,4,15,6,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,600,15,0,0,0,15,0,0,0,0,9336,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,"Teh Plate",0,0,0,0,0,7,0,0,0,20,0,90000000,0,0,0,0,2,0,1,0,8,0,69,0,0,0,0)
Error occured at:2007-09-15 20:11:35
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 (70000,4,1,-1,"WoWRawrz","WoWRawrz","WoWRawrz","WoWRawrz",1981,5,0,99999999999,10101,5,-1,-1,75,70,0,0,0,0,0,0,0,1,1,0,7,100,4,15,6,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,600,15,0,0,0,15,0,0,0,0,9336,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,"Teh Plate",0,0,0,0,0,7,0,0,0,20,0,90000000,0,0,0,0,2,0,1,0,8,0,69,0,0,0,0)
Error occured at:2007-09-15 20:11:57
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 (70000,4,1,-1,"WoWRawrz","WoWRawrz","WoWRawrz","WoWRawrz",1981,5,0,99999999999,10101,5,-1,-1,75,70,0,0,0,0,0,0,0,1,1,0,7,100,4,15,6,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,600,15,0,0,0,15,0,0,0,0,9336,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,"Teh Plate",0,0,0,0,0,7,0,0,0,20,0,90000000,0,0,0,0,2,0,1,0,8,0,69,0,0,0,0)
Error occured at:2007-09-15 20:12:12
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 (1,2,10,-1,"Staff of the admin","Staff of the admin","Staff of the admin","Staff of the admin",1,6,0,9999999999999999999,99999999999999,13,-1,-1,70,70,0,0,0,0,0,0,0,0,1,0,30,99999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20000,2 0000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100,100,100,100,100,0.50,0,0,33484,1,0,0,0, 0,33484,1,0,0,0,0,33484,1,0,0,0,0,33484,1,0,0,0,0,33484,1,0,0,0,0,1,"Only Admin has it UBMER",0,0,0,0,0,1,3,0,0,0,0,99999,0,0,0,0,0,0,0,0,0,0,426,0,0,0,0)
Error occured at:2007-09-15 20:13:08
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 (1,2,10,-1,"Staff of the admin","Staff of the admin","Staff of the admin","Staff of the admin",1,6,0,9999999999999999999,99999999999999,13,-1,-1,70,70,0,0,0,0,0,0,0,0,1,0,30,99999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20000,2 0000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100,100,100,100,100,0.50,0,0,33484,1,0,0,0, 0,33484,1,0,0,0,0,33484,1,0,0,0,0,33484,1,0,0,0,0,33484,1,0,0,0,0,1,"Only Admin has it UBMER",0,0,0,0,0,1,3,0,0,0,0,99999,0,0,0,0,0,0,0,0,0,0,426,0,0,0,0)
Error occured at:2007-09-15 20:13:28
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 (123,1,0,-1,"WoWRawr","WoWRawr","WoWRawr","WoWRawr",5672,5,0,0001,0001,18,-1,-1,99,1,0,0,0,0,0,0,0,4,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,0,"Its a little one ",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-15 20:13:41
Line no.:4
Error Code: 1062 - Duplicate entry '123' 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-15 20:13:45
Line no.:1
Error Code: 1062 - Duplicate entry '593428' 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 (65000,4,1,-1,"squishy","squishy","squishy","squishy",60000,5,0,1060900000000000000,90000000 00000220000,3,128,-1,100,0,0,0,0,0,0,0,0,1,1,0,1,10000,1,10000,1,10000,1,10000,19,10000,7,10000,21, 10000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000000,10000000,10000000,100000 00,10000000,1000000,100000,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0 ,35844,1,0,0,0,0,35844,1,0,0,0,0,0,"A Reward",0,0,0,0,0,7,0,0,0,100,0,200,0,0,0,0,0,0,0,0,0,0,426,0,0,0,0)
Error occured at:2007-09-15 20:13:51
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 (123,1,0,-1,"WoWRawr","WoWRawr","WoWRawr","WoWRawr",5672,5,0,0001,0001,18,-1,-1,99,1,0,0,0,0,0,0,0,4,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,0,"Its a little one ",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-15 20:13:55
Line no.:2
Error Code: 1062 - Duplicate entry '123' 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 (123,1,0,-1,"WoWRawr","WoWRawr","WoWRawr","WoWRawr",5672,5,0,0001,0001,18,-1,-1,99,1,0,0,0,0,0,0,0,4,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,0,"Its a little one ",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-15 20:13:58
Line no.:2
Error Code: 1062 - Duplicate entry '123' 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 (111008,4,1,-1,"Deathknight Corruptors Drape","Deathknight Corruptors Drape","Deathknight Corruptors Drape","Deathknight Corruptors Drape",22988,5,0,150000000,5000000,16,2,-1,150,80,0,0,0,0,0,0,0,1,1,0,4,90,5,79,7,89,19,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,1500,0,0,0,50,50,0,0,0,0,17625,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,0,0,0,0,0,250,0,0,0,0,2,0,4,0, 8,0,426,0,0,0,0)
Error occured at:2007-09-15 20:20:24
Line no.:2
Error Code: 1062 - Duplicate entry '111008' 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 (32158,2,0,-1,"PvP Reward","PvP Reward","PvP Reward","PvP Reward",45028,6,0,100000000000000,1000000000,13,-1,-1,80,70,0,0,0,0,0,0,0,1,1,0,7,200,4,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,350,650, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,.2478,0,0,36409,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,0,"For pvping",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0,104,0,0,0,0)
Error occured at:2007-09-16 11:13:32
Line no.:2
Error Code: 1264 - Out of range value adjusted for column 'buyprice' at row 1
Query:
INSERT INTO `gameobject_template` (`entry`,`type`,`displayId`,`name`,`faction`,`soun d0`,`sound2`) VALUES ('999000','22','4396','Alliance Portal to PVP ARENA','115','999003','1')
Error occured at:2007-09-16 12:21:39
Line no.:1
Error Code: 1146 - Table 'antrix.gameobject_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_

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 (1200002, ??, 814, 9999999, 99999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)
Error occured at:2007-09-20 18:01:39
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 '??, 814, 9999999, 99999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0' at line 2
Query:
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 (1200003, ??, 814, 90000000, 90000000, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)
Error occured at:2007-09-20 18:03:54
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 '??, 814, 90000000, 90000000, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, ' at line 2
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 (60007,2,7,-1,"The Sword Of 1k Truths","The Sword Of 1k Truths","The Sword Of 1k Truths","The Sword Of 1k Truths",19352,6,0,30000000,0000,13,-1,-1,100,70,0,0,0,0,0,0,0,2,1,0,3,20,4,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,0,$$ $,%%%,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01000,0,0,28735,1,0,0,0,0,35844,1,0,0, 0,0,34696,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Diabolid WoW Rocks And i Voted for it",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0,2869,0,0,0,0)
Error occured at:2007-09-20 19:05:28
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 '%%%,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01000,0,0,28735,1,0,0,0,0,35844,1,0,0,0 ,' at line 2
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 (60007,2,7,-1,"The Sword Of 1k Truths","The Sword Of 1k Truths","The Sword Of 1k Truths","The Sword Of 1k Truths",19352,6,0,30000000,0000,13,-1,-1,100,70,0,0,0,0,0,0,0,2,1,0,3,20,4,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,0,$$ $,%%%,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01000,0,0,28735,1,0,0,0,0,35844,1,0,0, 0,0,34696,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Diabolid WoW Rocks And i Voted for it",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0,2869,0,0,0,0)
Error occured at:2007-09-20 19:05:31
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 '%%%,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01000,0,0,28735,1,0,0,0,0,35844,1,0,0,0 ,' at line 2
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 (60000,4,1,-1,"Tier 7 Helmet of spell power","Tier 7 Helmet of spell power","Tier 7 Helmet of spell power","Tier 7 Helmet of spell power",22478,4,0,0000,0000,1,-1,-1,75,70,0,0,0,0,0,0,0,2,1,0,7,50,5,60,6,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,649,0,0,0,0,0,0,0,0,0,35887,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,"Tier Seven",0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,1,0,2,0,4,0,426,0,0,0,0)
Error occured at:2007-09-20 19:05:44
Line no.:2
Error Code: 1062 - Duplicate entry '60000' for key 1
Query:
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 (6000011, ??, 814, 999999, 999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)
Error occured at:2007-09-20 19:18:19
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 '??, 814, 999999, 999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0' at line 2
Query:
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 (60007, ??, 814, 999999, 999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)
Error occured at:2007-09-20 19:19:26
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 '??, 814, 999999, 999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0' at line 2
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 (60001,4,1,-1,"Tier 7 Shoulders of spell power","Tier 7 Shoulders of spell power","Tier 7 Shoulders of spell power","Tier 7 Shoulders of spell power",7888,4,0,0000,0000,3,-1,-1,0,70,0,0,0,0,0,0,0,2,1,0,7,100,5,34,6,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,1247,17,0,0,0,0,0,0,0,0,35893,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,"Tier Seven",0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,1,0,4,0,8,0,2869,0,0,0,0)
Error occured at:2007-09-20 21:26:22
Line no.:2
Error Code: 1062 - Duplicate entry '60001' 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 (6000010,2,7,-1,"Sword Of a thousand truths","Sword Of a thousand truths","Sword Of a thousand truths","Sword Of a thousand truths",4527,4,0,0000,0000,13,-1,-1,70,70,0,0,0,0,0,0,0,2,1,0,1,3000,5,50,30,100,28,100,0,0,0,0,0,0,0,0,0,0,0,0,1, 50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,34696,2,0,0,0,0,17713,1,0,0,0 ,0,35844,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"I am not an Rtard / MOM BATHROOM!",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0)
Error occured at:2007-09-20 21:49:09
Line no.:2
Error Code: 1062 - Duplicate entry '6000010' 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 (6000010,2,7,-1,"Sword Of a thousand truths","Sword Of a thousand truths","Sword Of a thousand truths","Sword Of a thousand truths",4527,4,0,0000,0000,13,-1,-1,70,70,0,0,0,0,0,0,0,2,1,0,1,3000,5,50,30,100,28,100,0,0,0,0,0,0,0,0,0,0,0,0,1, 50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,34696,2,0,0,0,0,17713,1,0,0,0 ,0,35844,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"I am not an Rtard / MOM BATHROOM!",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0)
Error occured at:2007-09-20 21:49:50
Line no.:2
Error Code: 1062 - Duplicate entry '6000010' 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 (6000012,2,7,-1,"Sword Of a thousand truths","Sword Of a thousand truths","Sword Of a thousand truths","Sword Of a thousand truths",4527,4,0,0000,0000,13,-1,-1,70,70,0,0,0,0,0,0,0,2,1,0,1,3000,5,50,30,100,28,100,0,0,0,0,0,0,0,0,0,0,0,0,50 ,150,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,34696,2,0,0,0,0,17713,1,0,0 ,0,0,35844,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"I am not an Rtard / MOM BATHROOM!",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0)
Error occured at:2007-09-20 21:51:03
Line no.:2
Error Code: 1062 - Duplicate entry '6000012' for key 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-22 12:43:30
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-09-22 12:49:18
Line no.:44
Error Code: 1050 - Table 'ai_agents' 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-22 12:59:10
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-22 12:59:30
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=3 DEFAULT CHARSET=latin1
Error occured at:2007-09-22 13:04:42
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

[Squishyy]

Theres more but, it was way to long

[Frosthowl]

This is a neat repack

[Frosthowl]

My friend and I are still having trouble with it though...Yes im trying to get 10 posts so we can pm chrispeee....

[Mesmoras]

Theres more but, it was way to long

I'd say drop your server db that you tried to execute that into, and create a new db and then execute again.

[Fronix]

Well its a good repack +rep on that (my friend got it working)
But i cant seem to get the ascent.exe to work

[Fronix]

Where can i find a website for my server that i can login to.
Like a Blizzlike website???

[Fronix]

I will post my ascent.conf, logonserver.conf and realms.conf here so u can look if its any thing wrong

[Fronix]

Nice repack but i cant start ascent.exe

I have exicuted your db called "new db" and i have putted the "WarpNPC.dll" and the other "WarpNPC" in the map called script_bin and i cant start it.

This is my antrix.conf:

#######################################################################
# Ascent Configuration File
# Last updated at revision 1457 by Burlex
#######################################################################

/********************************************************************************
 * How to use this config file:                                                 *
 * Config files are in a block->variable->setting format.                       *
 * A < signifies the opening of a block, the block name is expected after that. * 
 * After the block name, a space and then the settings sperated by = / ' '.     *
 *                                                                              *
 * e.g.                                                                         *
 * <block setting="0" someval = "1">                                            *
 *                                                                              *
 * Comments can be in C format, e.g. /* some stuff */, with a // at the start   *
 * of the line, or in shell format (#).                                         *
 ********************************************************************************/

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Database Section
#
#   Database.Host      - The hostname that the database is located on
#   Database.Username  - The username used for the mysql connection
#   Database.Password  - The password used for the mysql connection
#   Database.Name      - The database name
#   Database.Port      - Port that MySQL listens on. Usually 3306.
#   Database.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<WorldDatabase Hostname = "fragz.servegame.org" Username = "root" Password = "*****" Name = "antrix" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "fragz.servegame.org" Username = "root" Password = "*****" Name = "antrix" Port = "3306" Type = "1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Listen Config
#
#    Host
#        This is the address that the server will listen on.
#        To listen on all addresses, set it to 0.0.0.0
#        Default: 127.0.0.1 (localhost)
#
#    WorldServerPort
#        This is the port that the world server listens on.
#        It has to be the same as what is specified in the
#        realms table in the LogonDatabase.
#        Default: 8129
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Listen Host = "0.0.0.0"
        WorldServerPort = "8129">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Log Level Setup
#
#    Console Logging Level
#        This directive controls how much output the server will
#        display in it's console. Set to 0 for none, or -1 to disable.
#        -1 = Disabled; 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
#        Default: 3
#
#    World server packet logging feature
#        If this directive is turned on, a file called `world.log`
#        will be created in the server's directory and all packets
#        sent and received by clients will be dumped here in bfg
#        format.
#        Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogLevel Screen="0" File="-1" World="0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Server Settings
#
#    PlayerLimit
#        This directive controls the amount of sessions that will be
#        accepted by the server before it starts to add people to 
#        the server queue.
#        Default: 100
#
#    PlrUpdateDistance
#        This directive controls the distance (internal yards) that the player can "see" up to
#        and receieve updates for. For smaller servers, you can probably increase this number.
#        Increasing this number will also increase the servers bandwidth consumption and CPU usage.
#        Default: 80
#
#    Motd
#        This message will be displayed by the server in the chat
#        box every time any user logs on. Colors can be used in the
#        standard WoW format.
#        Default: "No MOTD specified
#
#    Send Build On Join
#        This directive controls whether the server's internal revision
#        will be sent to clients upon entering the world. Use it to help
#        testers report bugs.
#
#    Send Stats On Join
#        This directive controls whether the server will send the online player
#        count to a cilent when it enters the world.
#
#    Breathing Setup
#        If the breathing code is causing problems or you want to run a fun server, you can disable 
#        water checks by enabling this directive.
#        Default: 1
#
#    Level Cap
#        This variable controls the level that stats will be generated up to internally.
#        Beyond this level players can still see a higher level visually but their stats won't
#        increase beyond this point.
#        Default: 60
#
#    Expansion 1 Level Cap
#       This variable does the same thing as Level Cap above, except it applies to those who
#       have the first expansion: The Burning Crusade.
#       Default: 70
#
#    Seperate Channels Control
#        This directive controls whether horde and alliance chats will be seperated across channels.
#        Set to 1 for blizzlike seperated channels, or 0 to allow horde/alliance to speak to each other
#        across channels.
#        Default: 0
#
#    Compression Threshold
#        This directive controls the limit when update packets will be compressed using deflate.
#        For lower-bandwidth servers use a lower value at the cost of cpu time.
#        Default: 1000
#
#    Queue Update Rate
#        This directive controls how many milliseconds (ms) between the updates
#        that the queued players receieve telling them their position in the queue.
#        Default: 5000 (5 seconds).
#
#    Kick AFK Players
#        Time in milliseconds (ms) that a player will be kicked after they go afk.
#        Default: 0 (disabled)
#
#    Connection Timeout
#        This directive specifies the amount of seconds that the client will be disconnected
#        after if no ping packet is sent. It is advised to leave it at the default.
#        Default: 180
#
#    Realm Type
#        This is the realm type that will be used by the server to handle world pvp.
#        Default: 0 (pve)(RPPVE)
#        Other values: 1(pvp)(RPPVP)
#
#    AdjustPriority
#        Set the server to high process priority?
#        Default: 0
#
#    RequireAllSignatures
#        This directive controls whether the full 10 signatures will be required in order
#        to turn in a petition. Smaller servers would be better off having it turned off.
#        Default: off
#
#    ShowGMInWhoList
#        This directive controls whether GM's will be shown in player's who lists or not.
#        Default: on
#
#    MapUnloadTime
#        This directive controls whether to unload map cells after an idle period of <x> seconds.
#        Use on smaller servers or servers that are memory-limited. The server without cell unloading
#        can use over 1.2GB memory with all creatures loaded.
#        Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Server PlayerLimit = "100"
        PlrUpdateDistance = "80"
        Motd = "Welcome to FraGz WoW (FOLLOW RULES) www.fragzwow.inc.se"        
        SendBuildOnJoin = "1"
        SendStatsOnJoin = "1"
        EnableBreathing = "1"
        LevelCap = "70"
        Expansion1LevelCap = "70"
        SeperateChatChannels = "0"
        CompressionThreshold = "1000"
        QueueUpdateInterval = "5000"
        KickAFKPlayers = "0"
        ConnectionTimeout = "180"
        RealmType = "1"
        AdjustPriority = "0"
        RequireAllSignatures = "0"
        ShowGMInWhoList = "1"
        MapUnloadTime="0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Die Directive
#
#    If this triggers it means you didn't read your config file!
#    Just comment it or remove it when you've read this.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<die msg="I am a newb who didn't even read half my config file!">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Power regeneration multiplier setup
# 
#    These directives set up the multiplier in which regen values will be
#    multiplied by every 2 seconds.
#    Powers: 
#        Power1 = Mana, Power2 = Rage, Power3 = Energy
#    
#    Reputation:
#        Kill = Rep gained on kill, Quest = rep gained from quests
#
#    Honor:
#        Honor = multiplier used to calculate honor per-kill.
#
#    PvP:
#        PvPTimer = in ms, the timeout for pvp after turning it off. default: 5mins (300000)
#
#    XP:
#        The xp that a player receives from killing a creature will be multiplied
#        by this value in order to get his xp gain.
#
#    RestXP: 
#        Value is the amount of rest XP a player will recieve per minute of rest time.
#
#    Drop(Color):
#        These values will be multiplied by the drop percentages of the items for creatures
#        to determine which items to drop. All default to 1.
#        To allow you better control of drops, separate multipliers have been created for items 
#        of each quality group. 
#
#    DropMoney:
#        This value will be multiplied by any gold looted and pickpocketed
#
#    Save:
#        Value in milliseconds (ms) that will be between player autosaves.
#        Default: 300000 (5 minutes)
# 
#    SkillChance:
#        The chance that you have to level up a skill in melee or a profession is multiplied
#        by this value.
#        Default: 1
#
#    SkillRate:
#        The amount of "levels" your skill goes up each time you gain a level is multiplied
#        by this value.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Rates Health="1"
       Power1="1"
       Power2="1"
       Power3="1"
       QuestReputation="1"
       KillReputation="1"
       Honor="1"
       PvPTimer="300000"
       Compression="1"
       XP="2500"
       QuestXP="1500"
       RestXP="1"
       DropGrey="80"
       DropWhite="80"
       DropGreen="80"
       DropBlue="80"
       DropPurple="80"
       DropOrange="80"
       DropArtifact="80"
       DropMoney="700"
       Save="300000"
       SkillChance="1"
       SkillRate="1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# GM Client Channel
#
#   This should be set to 'gm_sync_channel' for the My_Master addon to work.
#
#   Default: gm_sync_channel
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<GMClient ReqGmClient = "0" GmClientChannel = "gm_sync_channel">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Terrain Configuration
#
#   Set the path to the map_xx.bin files and whether unloading should be enabled
#   for the main world maps here. Unloading the main world maps when they go idle
#   can save a great amount of memory if the cells aren't being activated/idled
#   often. Instance/Non-main maps will not be unloaded ever.
#
#   Default:
#      MapPath = "maps"
#      UnloadMaps = 1
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Terrain MapPath = "maps" UnloadMaps = "0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Log Settings
# 
#    Cheaters:
#        This directive sets up the cheater logging file, if turned on any
#        cheat / packet exploit / speedhack attempts will be logged here.
#
#    GMCommands:
#        These two directives set up the GM command logging fie. If turned on,
#        most gm commands will be logged for this file for abuse investigation, etc.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Log Cheaters="0" GMCommands="1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Mail System Setup
#
#    These directives control the limits and behaviour of the ingame mail system.
#    All options must have Mail prefixed before them.
#   
#    ReloadDelay                 
#        Controls the delay at which the database is "refreshed". Use it if you're
#        inserting mail from an external source, such as a web-based interface.
#        0 turns it off.
#        Default: 0
#
#    DisablePostageCostsForGM 
#        Enables/disables the postage costs for GM's. DisablePostageCosts overrides this.
#        Default: 1
#
#    DisablePostageCosts
#        Disables postage costs for all players.
#        Default: 0
#
#    DisablePostageDelayItems
#        Disables the one hour wait time when sending mail with items attached.
#        Default: 1
#
#    DisableMessageExpiry
#        Turns off the 30 day / 3 day after read message expiry time. 
#        WARNING: A mailbox still cannot show more than 50 items at once
#        (stupid limitation in client).
#        Default: 0
#
#    EnableInterfactionMail
#        Removes the faction limitation for sending mail messages. Applies to all players.
#        Default: 1
#
#    EnableInterfactionMailForGM 
#        Removes the faction limitation for sending mail messages, but only applies
#        to GM's. EnableInterfactionMail overrides this.
#        Default: 1
#   
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Mail ReloadDelay="0"
      DisablePostageCostsForGM="1"
      DisablePostageCosts="0"
      DisablePostageDelayItems="1"
      DisableMessageExpiry="0"
      EnableInterfactionMail="1"
      EnableInterfactionMailForGM="1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Status Dumper Config
#
#        These directives set up the status dumper plugin. Filename is an
#        absolute or relative path to the server binary. Interval is the
#        time that the stats will be dumped to xml.
#        Default: stats.xml / 120000 (2 minutes)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<StatDumper FileName = "stats.xml" Interval = "120000">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Startup Options
#
#    Preloading
#        This directive controls whether the entire world will be spawned at server
#        startup or on demand. It is advised to leave it disabled unless you are a
#        developer doing testing.
#        Default: off
#
#    Background Loot Loading
#        This directive controls whether loot will be loaded progressively during
#        startup or in the background in a seperate thread. Turning it on will
#        result in much faster startup times.
#        Default: on
#
#    Multithreaded Startup
#        This controls whether the server will spawn multiple worker threads to
#        use for loading the database and starting the server. Turning it on
#        increases the speed at which it starts up for each additional cpu in your
#        computer.
#        Default: on
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Startup Preloading = "0"
         BackgroundLootLoading = "1"
         EnableMultithreadedLoading = "1">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Flood Protection Setup
#
#    Lines
#        This is the number of "messages" or lines that it will allow before stopping messages from
#        being sent. This counter is reset every "Seconds" seconds.
#        Default: 0 (disabled)
#
#    Seconds
#        This is the number of seconds inbetween the Line counter being reset.
#        Default: 0 (disabled)
#
#    SendMessage
#        If this is enabled, a "Your message has triggered serverside flood protection. You can speak again in %u seconds."
#        message will be sent upon flood triggering.
#        Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<FloodProtection Lines = "0" Seconds = "0" SendMessage = "0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Setup
#
#    DisablePings   
#        This directive controls whether pings will be sent to the logonserver to check
#        if the connection is still "alive". Expect problems if it is disabled.
#        Default: 0
#
#    RemotePassword
#        This directive controls the password used to authenticate with the logonserver.
#        It must be the same between the two configs. If it is not, your server will
#        not register.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogonServer DisablePings = "1"
             RemotePassword = "fragz">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# AntiHack Setup
#
#    Teleport   
#        This directive controls anti-teleport hack checks will be enabled or not.
#        Default: 1
#
#    Speed
#        This directive controls anti-speed hack checks will be performed on player movement or not.
#        Default: 1
#
#    FallDamage
#        This directive controls anti-fall damage hack checks will be performed on player movement or not.
#        Default: 1
#
#    Flying
#        This directive controls whether flight hacks will be performed on players or not.
#        Default: 1
#
#    DisableOnGM
#        This directive controls hack checks will be disabled for GM's or not.
#        Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<AntiHack Teleport="1"
          Speed="1"
          FallDamage="1"
          Flying="1"
          DisableOnGM="0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Die Directive
#
#    If this triggers it means you didn't read your config file!
#    Just comment it or remove it when you've read this.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<die2 msg="I read nearly all my config file, but not the whole thing!">

And my logonserver.conf:
#######################################################################
# Ascent Realms Configuration File
# Last updated at revision 446 by Burlex
#######################################################################

/********************************************************************************
* How to use this config file: *
* Config files are in a block->variable->setting format. *
* A < signifies the opening of a block, the block name is expected after that. *
* After the block name, a space and then the settings sperated by = / ' '. *
* *
* e.g. *
* <block setting="0" someval = "1"> *
* *
* Comments can be in C format, e.g. /* some stuff */, with a // at the start *
* of the line, or in shell format (#). *
********************************************************************************/

# LogonDatabase Section
#
# These directives are the location of the `realms` and `accounts`
# tables.
#
# LogonDatabase.Host - The hostname that the database is located on
# LogonDatabase.Username - The username used for the mysql connection
# LogonDatabase.Password - The password used for the mysql connection
# LogonDatabase.Name - The database name
# LogonDatabase.Port - Port that MySQL listens on. Usually 3306.
# LogonDatabase.Type - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#

<LogonDatabase Hostname = "fragz.servegame.org"
Username = "root"
Password = "******"
Name = "antrix"
Port = "3306"
Type = "1">


# Host Directive
#
# This is the address that the realmlist will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# Note: ISHost is the interserver communication listener.
#

<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"
RealmListPort = "3724"
ServerPort = "8093">

# Server console logging level
#
# This directive controls how much output the server will
# display in it's console. Set to 0 for none.
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 3
#

<LogLevel Screen = "0"
File = "-1">

# Account Refresh Time
#
# This controls on which time interval accounts gets
# refreshed. (In seconds)
# Default = 600
#

<Rates AccountRefresh = "600">

# Accepted Build Range Setup
#
# These two directives set up which clients will be
# allowed to authenticate with the realm list.
#
# Set these to the same builds that the server was
# compiled for.
#
# As of the last update, version 2.1.1 was build 6739.
#

<Client MinBuild = "6739"
MaxBuild = "6898">

# WorldServer Setup
#
# This directive controls the password used to authenticate with the worldserver.
# It must be the same between the two configs. If it is not, your server will
# not register.
#
# Default: "change_me_logon"
#

<LogonServer RemotePassword = "change_me_logon">

And my relams.conf:
#######################################################################
# Ascent Realms Configuration File
# Last updated at revision 446 by Burlex
#######################################################################

/********************************************************************************
* How to use this config file: *
* Config files are in a block->variable->setting format. *
* A < signifies the opening of a block, the block name is expected after that. *
* After the block name, a space and then the settings sperated by = / ' '. *
* *
* e.g. *
* <block setting="0" someval = "1"> *
* *
* Comments can be in C format, e.g. /* some stuff */, with a // at the start *
* of the line, or in shell format (#). *
********************************************************************************/

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Section
#
# Address:
# The address (no port) of the server.
#
# Port:
# The port on which the logon server listens. (*** NOT 3724 ***)
#
# Name:
# Not really relavant, but name the logon.
#
# RealmCount:
# The number of realms in the next section.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogonServer Address = "fragz.servegame.org"
Port = "8093"
Name = "FraGz WoW"
RealmCount = "1">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Realm Section
#
# Name:
# The name of the realm.
#
# Address:
# The address (and port) of that realm.
#
# Icon:
# The type of realm (PVP, Normal, RPPVP, RP)
#
# Colour:
# Realm colour in realm list display.
#
# TimeZone:
# Time zone the realm is in.
#
# Population:
# (0 = low, 1 = medium, 2 = high)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Realm1 Name = "FraGz WoW (!!NEW!!)"
Address = "fragz.servegame.org:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">
____________________________

Plzz tell me what is wrong with these i cant find the problem.

THX in advance

[danewalton2]

All you got to do is follow this AC Web then click search type in tutorial presss go and hey presto video tutorial guides for dummies have fun.P.S you must register first hope it helps noobs to stop posting questions in here