[Mangos] Trembon 2.3.2 Repack

[trembon]

Trembon's 2.3.2 Repack

------------------------------------------------------
Website: .:Trembons Mangos Compiles:.
------------------------------------------------------
Normal Compile:

Server Files (Mangos Rev 5050, ScriptDev2 Rev 231): 
http://rapidshare.com/files/84967341/mangos_rev5050_sd231_trembon.zip

NOTE: This is tested by me and it's working, tho IT MIGHT show some errors at startup, but do no harm if you havent done terribly wrong :P.
NOTE2: DBC and MAP files can be found bellow.
------------------------------------------------------
EasYtoUse Repack v8:

This pack is made to be easy, contains all files you need except the map files (see below for link).
So just unpack, batch the mangos.sql, characters.sql and realmd.sql, or just use the new db installer.
then edit the config files and run it :)


This pack contains Mangos Rev 5029, ScriptDev2 Rev 226, Silvermoon DB Rev x4 and dbc files. (WoW 2.3.2)

Server: 
http://rapidshare.com/files/84286530/easytousepack_v8_trembon.zip

NOTE: Map files link can be found below.
------------------------------------------------------

SQL Files:
(Silvermoon DB Rev x4, realmd.sql, characters.sql) -
http://rapidshare.com/files/84278823/sql_ps_revx4.zip
(UDB Rev 334, realmd.sql, characters.sql) -
http://rapidshare.com/files/82241188/sql_udb_rev334.zip

DBC Files:
(WoW 2.3.2) -
http://rapidshare.com/files/82808758/dbc_2.3.2.zip
Maps (Wow 2.3.2):
http://rapidshare.com/files/83717699/maps_2.3.2.part01.rar
http://rapidshare.com/files/83721860/maps_2.3.2.part02.rar
http://rapidshare.com/files/83746334/maps_2.3.2.part03.rar

------------------------------------------------------
Changed so old releases only is aviable from the website now :)

A guide for how to setup the server is aviable in the help section.

Changelogs -
Mangos: http://mangos.svn.sourceforge.net/viewvc/mangos/?view=log
ScriptDev2: http://scriptdev2.svn.sourceforge.net/viewvc/scriptdev2/?view=log
UnifiedDB: http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/?view=log
Project Silvermoon: http://www.projectsilvermoon.net/

// Trembon

[MentaL]

[trembon]

updated

[razer901]

not sure if i have understand this, but can i use EasYtoUse Repack v8: to make a server?? and if i can, how do i do it? any guides or something?

[Frozenx51]

wow.. why are all the mobs half there normal size? anyone else having this issue?

[trembon]

@ Frozenx51 - try reinstall the database? :P

@ razer901 - sry, no guides for it atm

[Frozenx51]

i just tried your silvermoon X5 database and i totaly wiped out my mysql.. talking everything mangos realmd characters all of it to start from scratch. and this is the error i got when loading mangos..

wondering if i did something wrong.. after deleting everything i started with the mangos.sql

gona try your easy repack and see if that does anything new.


[CODE]Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-13 21:14:05
Line no.:25
Error Code: 1050 - Table 'account_data' already exists

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-13 21:14:22
Line no.:25
Error Code: 1050 - Table 'account_data' already exists

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-13 21:14:32
Line no.:25
Error Code: 1050 - Table 'account_data' already exists

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-13 21:15:03
Line no.:25
Error Code: 1050 - Table 'account_data' already exists

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-13 21:15:07
Line no.:25
Error Code: 1050 - Table 'account_data' already exists

Query:
INSERT INTO `vendors` VALUES ('50000', '16677', '1', '0', '0')

Error occured at:2008-01-14 02:18:26
Line no.:181
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `vendors` VALUES ('50000', '16677', '1', '0', '0')

Error occured at:2008-01-14 02:18:51
Line no.:181
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `vendors` VALUES ('50000', '16677', '1', '0', '0')

Error occured at:2008-01-14 02:18:53
Line no.:181
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype` int(11) unsigned NOT NULL default '0',
`cooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`type`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2008-01-14 13:32:06
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` blob,
`uiconfig1` blob,
`uiconfig2` blob,
`uiconfig3` blob,
`uiconfig4` blob,
`uiconfig5` blob,
`uiconfig6` blob,
`uiconfig7` blob,
`uiconfig8` blob,
PRIMARY KEY (`acct`),
UNIQUE KEY `a` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-14 13:32:20
Line no.:27
Error Code: 1050 - Table 'account_data' already exists

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-01-22 14:01:33
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-01-22 14:02:09
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-01-22 14:03:18
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0

Error occured at:2008-01-22 14:06:27
Line no.:1
Error Code: 1146 - Table 'mysql.user' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-01-22 14:07:22
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (66655,2,7,-1,"Fallenz Sword Of Power",46900,6,0,0,0000,0000,13,-1,-1,300,255,0,0,0,0,0,0,0,2,1,0, 1,99999, 3,99999, 4,99999, 5,99999, 6,99999, 7,99999, 12,99999, 14,99999, 15,99999, 31,99999,99999,99999,0,99999,99999,1,99999,99999,2,99999,99999,4,99999,99999,5,10000,99999999,99999999,99999999,99999999,99999999,99999999,1000,0,0,34696,2,0,0,0,0,17713,1,0,0,0,0,18060,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,1,"Fallen Staff Only",0,0,0,0,0,1,2,0,0,0,0,9999,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0,"internalitemhanler",0)

Error occured at:2008-01-22 20:52:40
Line no.:2
Error Code: 1264 - Out of range value adjusted for column 'stat_value1' at row 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (66655,2,7,-1,"Fallenz Sword Of Power",46900,6,0,0,0000,0000,13,-1,-1,300,255,0,0,0,0,0,0,0,2,1,0, 1,99999, 3,99999, 4,99999, 5,99999, 6,99999, 7,99999, 12,99999, 14,99999, 15,99999, 31,99999,99999,99999,0,99999,99999,1,99999,99999,2,99999,99999,4,99999,99999,5,10000,99999999,99999999,99999999,99999999,99999999,99999999,1000,0,0,34696,2,0,0,0,0,17713,1,0,0,0,0,18060,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,1,"Fallen Staff Only",0,0,0,0,0,1,2,0,0,0,0,9999,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0,"internalitemhanler",0)

Error occured at:2008-01-22 20:53:18
Line no.:2
Error Code: 1264 - Out of range value adjusted for column 'stat_value1' at row 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (66655,2,7,-1,"Fallenz Sword Of Power",46900,6,0,0,0000,0000,13,-1,-1,300,255,0,0,0,0,0,0,0,2,1,0, 1,99999, 3,99999, 4,99999, 5,99999, 6,99999, 7,99999, 12,99999, 14,99999, 15,99999, 31,99999,99999,99999,0,99999,99999,1,99999,99999,2,99999,99999,4,99999,99999,5,10000,99999999,99999999,99999999,99999999,99999999,99999999,1000,0,0,34696,2,0,0,0,0,17713,1,0,0,0,0,18060,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,1,"Fallen Staff Only",0,0,0,0,0,1,2,0,0,0,0,9999,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0,"internalitemhanler",0)

Error occured at:2008-01-22 20:54:43
Line no.:2
Error Code: 1264 - Out of range value adjusted for column 'stat_value1' at row 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (66655,2,7,-1,"Fallenz Sword Of Power",46900,6,0,0,0000,0000,13,-1,-1,300,255,0,0,0,0,0,0,0,2,1,0, 1,999, 3,999, 4,999, 5,999, 6,999, 7,999, 12,999, 13,999, 14,999, 35,999,999,999,0,999,999,0,999,999,0,999,999,0,999,999,0,999,999,999,999,999,999,999,1000,0,0,34696,2,0,0,0,0,18060,1,0,0,0,0,17713,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,1,"Fallen Staff Only",0,0,0,0,0,1,2,0,0,0,0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"internalitemhanler",0)

Error occured at:2008-01-22 21:10:21
Line no.:2
Error Code: 1062 - Duplicate entry '66655' for key 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (66655,2,7,-1,"Fallenz Sword Of Power",46900,6,0,0,0000,0000,13,-1,-1,300,255,0,0,0,0,0,0,0,2,1,0, 1,999, 3,999, 4,999, 5,999, 6,999, 7,999, 12,999, 13,999, 14,999, 35,999,999,999,0,999,999,0,999,999,0,999,999,0,999,999,0,999,999,999,999,999,999,999,1000,0,0,34696,2,0,0,0,0,18060,1,0,0,0,0,17713,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,1,"Fallen Staff Only",0,0,0,0,0,1,2,0,0,0,0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"internalitemhanler",0)

Error occured at:2008-01-22 21:10:23
Line no.:2
Error Code: 1062 - Duplicate entry '66655' for key 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (77783,2,15,-1,'GM Dagger2',43098,5,0,0,10000,100000,13,-1,-1,100,75,0,0,0,0,0,0,0,1,1,0,3,1000,1,50000,4,1000,6,1000,7,1000,12,1000,13,1000,14,1000,31,1000,32,1000,1000,5000,0,1000,5000,1,1000,5000,2,1000,5000,3,1000,5000,5,0,1000,1000,1000,1000,1000,1000,1200,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,2,'Dark Heaven',0,0,0,0,0,1,3,0,0,0,0,100000,0,0,0,0,4,0,1,0,2,0,90,0,0,0,0,'internalitemhanler',0)

Error occured at:2008-01-22 21:52:48
Line no.:44
Error Code: 1264 - Out of range value adjusted for column 'stat_value2' at row 1

Query:
DELETE FROM item_template WHERE entry BETWEEN '77770' AND '77783'

Error occured at:2008-01-22 21:55:12
Line no.:6
Error Code: 1146 - Table 'mangos.item_template' doesn't exist

Query:
DELETE FROM item_template WHERE entry BETWEEN '77770' AND '77783'

Error occured at:2008-01-22 21:55:28
Line no.:6
Error Code: 1146 - Table 'mangos.item_template' doesn't exist

Query:
DELETE FROM creature_template WHERE entry BETWEEN '500000' AND '500100'

Error occured at:2008-01-22 21:59:40
Line no.:3
Error Code: 1146 - Table 'mangos.creature_template' doesn't exist

Query:
DELETE FROM creature_template WHERE entry BETWEEN '500000' AND '500100'

Error occured at:2008-01-22 21:59:52
Line no.:3
Error Code: 1146 - Table 'mangos.creature_template' doesn't exist

Query:
DELETE FROM creature_template WHERE entry BETWEEN '500000' AND '500100'

Error occured at:2008-01-22 22:00:24
Line no.:3
Error Code: 1146 - Table 'characters.creature_template' doesn't exist

Query:
DELETE FROM creature_template WHERE entry BETWEEN '500000' AND '500100'

Error occured at:2008-01-22 22:00:29
Line no.:3
Error Code: 1146 - Table 'realmd.creature_template' doesn't exist

Query:
DELETE FROM creature_template WHERE entry BETWEEN '500000' AND '500100'

Error occured at:2008-01-22 22:00:36
Line no.:3
Error Code: 1146 - Table 'mangos.creature_template' doesn't exist

Query:
DELETE FROM creature_template WHERE entry BETWEEN '500000' AND '500100'

Error occured at:2008-01-22 22:04:49
Line no.:3
Error Code: 1146 - Table 'mangos.creature_template' doesn't exist

Query:
DELETE FROM creature_template WHERE entry BETWEEN '500000' AND '500100'

Error occured at:2008-01-22 22:05:57
Line no.:3
Error Code: 1146 - Table 'mangos.creature_template' doesn't exist

Query:
INSERT INTO `creature_template` VALUES ('500000', '15511', '0', 'Armor', 'Dungeon I', '70', '70', '100000', '100000', '50000', '60000', '1', '474', '16388', '1.15', '1', '624', '871', '100', '1600', '1760', '0', '0', '1', '0', '2', '0', '0', '0', '0', '57.728', '79.376', '100', '7', '7', '0', '138936390', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4890', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '51400', '', '0', '3', '0', '')

Error occured at:2008-01-22 22:06:47
Line no.:5
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_template` VALUES ('500000', '15511', '0', 'Armor', 'Dungeon I', '70', '70', '100000', '100000', '50000', '60000', '1', '474', '16388', '1.15', '1', '624', '871', '100', '1600', '1760', '0', '0', '1', '0', '2', '0', '0', '0', '0', '57.728', '79.376', '100', '7', '7', '0', '138936390', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4890', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '51400', '', '0', '3', '0', '')

Error occured at:2008-01-22 22:06:51
Line no.:5
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_template` VALUES ('500000', '15511', '0', 'Armor', 'Dungeon I', '70', '70', '100000', '100000', '50000', '60000', '1', '474', '16388', '1.15', '1', '624', '871', '100', '1600', '1760', '0', '0', '1', '0', '2', '0', '0', '0', '0', '57.728', '79.376', '100', '7', '7', '0', '138936390', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4890', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '51400', '', '0', '3', '0', '')

Error occured at:2008-01-22 22:07:50
Line no.:5
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_template` VALUES ('500000', '15511', '0', 'Armor', 'Dungeon I', '70', '70', '100000', '100000', '50000', '60000', '1', '474', '16388', '1.15', '1', '624', '871', '100', '1600', '1760', '0', '0', '1', '0', '2', '0', '0', '0', '0', '57.728', '79.376', '100', '7', '7', '0', '138936390', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4890', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '51400', '', '0', '3', '0', '')

Error occured at:2008-01-22 22:07:57
Line no.:5
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (77783,2,15,-1,'GM Dagger2',43098,5,0,0,10000,100000,13,-1,-1,100,75,0,0,0,0,0,0,0,1,1,0,3,1000,1,50000,4,1000,6,1000,7,1000,12,1000,13,1000,14,1000,31,1000,32,1000,1000,5000,0,1000,5000,1,1000,5000,2,1000,5000,3,1000,5000,5,0,1000,1000,1000,1000,1000,1000,1200,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,2,'Dark Heaven',0,0,0,0,0,1,3,0,0,0,0,100000,0,0,0,0,4,0,1,0,2,0,90,0,0,0,0,'internalitemhanler',0)

Error occured at:2008-01-22 22:08:16
Line no.:44
Error Code: 1264 - Out of range value adjusted for column 'stat_value2' at row 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (77783,2,15,-1,'GM Dagger2',43098,5,0,0,10000,100000,13,-1,-1,100,75,0,0,0,0,0,0,0,1,1,0,3,1000,1,50000,4,1000,6,1000,7,1000,12,1000,13,1000,14,1000,31,1000,32,1000,1000,5000,0,1000,5000,1,1000,5000,2,1000,5000,3,1000,5000,5,0,1000,1000,1000,1000,1000,1000,1200,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,2,'Dark Heaven',0,0,0,0,0,1,3,0,0,0,0,100000,0,0,0,0,4,0,1,0,2,0,90,0,0,0,0,'internalitemhanler',0)

Error occured at:2008-01-22 22:08:19
Line no.:44
Error Code: 1264 - Out of range value adjusted for column 'stat_value2' at row 1

Query:
CREATE TABLE `npc_gossip_textid` (
`creatureid` int(10) unsigned NOT NULL default '0',
`textid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`creatureid`),
UNIQUE KEY `index` (`creatureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='NPC System'

Error occured at:2008-01-22 23:05:11
Line no.:1202
Error Code: 1050 - Table 'npc_gossip_textid' already exists

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` longtext,
`uiconfig1` longtext,
`uiconfig2` longtext,
`uiconfig3` longtext,
`uiconfig4` longtext,
`uiconfig5` longtext,
`uiconfig6` longtext,
`uiconfig7` longtext,
`uiconfig8` longtext,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-22 23:05:27
Line no.:26
Error Code: 1050 - Table 'account_data' already exists

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` longtext,
`uiconfig1` longtext,
`uiconfig2` longtext,
`uiconfig3` longtext,
`uiconfig4` longtext,
`uiconfig5` longtext,
`uiconfig6` longtext,
`uiconfig7` longtext,
`uiconfig8` longtext,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-22 23:05:32
Line no.:26
Error Code: 1050 - Table 'account_data' already exists

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` longtext,
`uiconfig1` longtext,
`uiconfig2` longtext,
`uiconfig3` longtext,
`uiconfig4` longtext,
`uiconfig5` longtext,
`uiconfig6` longtext,
`uiconfig7` longtext,
`uiconfig8` longtext,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2008-01-22 23:05:35
Line no.:26
Error Code: 1050 - Table 'account_data' already exists

Query:
INSERT INTO `creature_names` VALUES ('50078', 'Reagent', 'Miscellaneous', '', '0', '7', '0', '3', '0', '0', '20023', '20023', '0', '0', '1', '0', '0', '0')

Error occured at:2008-01-23 09:51:36
Line no.:6
Error Code: 1366 - Incorrect integer value: '' for column 'mouseFlags' at row 1

Query:
INSERT INTO `creature_names` VALUES ('50078', 'Reagent', 'Miscellaneous', '', '0', '7', '0', '3', '0', '0', '20023', '20023', '0', '0', '1', '0', '0', '0')

Error occured at:2008-01-23 09:58:26
Line no.:6
Error Code: 1366 - Incorrect integer value: '' for column 'mouseFlags' at row 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (77783,2,15,-1,'GM Dagger2',43098,5,0,0,10000,100000,13,-1,-1,100,75,0,0,0,0,0,0,0,1,1,0,3,1000,1,50000,4,1000,6,1000,7,1000,12,1000,13,1000,14,1000,31,1000,32,1000,1000,5000,0,1000,5000,1,1000,5000,2,1000,5000,3,1000,5000,5,0,1000,1000,1000,1000,1000,1000,1200,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,2,'Dark Heaven',0,0,0,0,0,1,3,0,0,0,0,100000,0,0,0,0,4,0,1,0,2,0,90,0,0,0,0,'internalitemhanler',0)

Error occured at:2008-01-23 13:37:50
Line no.:44
Error Code: 1264 - Out of range value adjusted for column 'stat_value2' at row 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (66675,2,10,-1,"The Fallen One's Staff Of Death",31346,6,0,0,0000,0000,13,-1,-1,300,255,0,0,0,0,0,0,0,1,1,0, 1,999, 5,999, 6,999, 12,999, 14,999, 1,999, 13,999, 35,999, 30,999, 21,999,999,999,0,999,999,1,999,999,2,999,999,4,999,999,5,10000,999,999,999,999,999,999,1000,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,1,"Dont Fuck With This Bitch. "Server Owner"",0,0,0,0,0,1,2,0,0,0,0,999,0,0,0,0,1,0,2,0,8,0,0,0,0,0,0,"internalitemhanler",0)

Error occured at:2008-01-23 16:50:11
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 'Server Owner"",0,0,0,0,0,1,2,0,0,0,0,999,0,0,0,0,1,0,2,0,8,0,0,0,0,0,0,"internal' at line 2

Query:
INSERT INTO npc_vendor
(`entry`, `item`, `maxcount`, `incrtime`)
VALUES
(95000,75006,0,0)

Error occured at:2008-01-24 22:45:30
Line no.:36
Error Code: 1062 - Duplicate entry '95000-75006' for key 1

Query:
INSERT INTO creature_template
(`entry`, `modelid_a`, `modelid_h`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `ScriptName`)
VALUES
(95000, 11657, 11657, 'Fallenz Wow Donar Items', 'Donation Item Viewer', 255, 255, 90000000, 90000000, 90000000, 90000000, 1, 12, 12, 128, 1.1, 0, 100, 110, 800, 2500, 2500, 0, 0, 0, 0, 0, 0, 0, 200, 250, 800, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, '')

Error occured at:2008-01-24 22:47:02
Line no.:4
Error Code: 1062 - Duplicate entry '95000' for key 1

Query:
INSERT INTO npc_vendor
(`entry`, `item`, `maxcount`, `incrtime`)
VALUES
(94000,,0,0)

Error occured at:2008-01-24 22:49:38
Line no.:44
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 '0,0)' at line 4

Query:
INSERT INTO npc_vendor
(`entry`, `item`, `maxcount`, `incrtime`)
VALUES
(91001, , 0, 0)

Error occured at:2008-01-24 23:40:41
Line no.:8
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 ' 0, 0)' at line 4

Query:
INSERT INTO npc_vendor
(`entry`, `item`, `maxcount`, `incrtime`)
VALUES
(91002, , 0, 0)

Error occured at:2008-01-24 23:41:11
Line no.:8
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 ' 0, 0)' at line 4

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (66691,2,10,-1,"Fallenz Staff Of Life",31347,6,0,0,0000,0000,13,-1,-1,300,255,0,0,0,0,0,0,0,2,1,0, 5,999, 6,999, 7,999, 12,999, 13,999, 27,999, 24,999, 30,999, 18,999, 27,999,999,999,0,999,999,1,999,999,5,999,999,2,999,999,4,10000,999,999,999,999,999,999,150,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,1,"The Keeper Of All Life",0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,8,0,2,0,4,0,0,0,0,0,0,"internalitemhanler",0)

Error occured at:2008-01-25 16:30:04
Line no.:2
Error Code: 1146 - Table 'characters.item_template' doesn't exist

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (66682,4,1,-1,"Fallenz Belt Of Power",31110,6,0,0,0000,0000,6,-1,-1,300,255,0,0,0,0,0,0,0,1,1,0, 1,999, 3,999, 4,999, 5,999, 6,999, 7,999, 12,999, 13,999, 14,999, 35,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10000,999,999,999,999,999,999,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,35844,1,0,0,0,0,35844,1,0,0,0,0,17713,1,0,0,0,0,1,"Fallen Staff Only",0,0,0,0,0,7,0,0,0,0,0,999,0,0,0,0,1,0,2,0,8,0,0,0,0,0,0,"internalitemhanler",0)

Error occured at:2008-01-25 16:31:38
Line no.:2
Error Code: 1146 - Table 'characters.item_template' doesn't exist

Query:
INSERT INTO `creature_template` VALUES ('30000', '16015', '0', '16015', '0', 'Commandant Eligor Portelaube', '<FraternitÃÃ

[Frozenx51]

actualy, scratch what i said earyler.. looks like i got it to work now.. but when i try to load the characters and realmd it tells me this..

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2008-01-25 21:4 8:37
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

and ideas of what to do there?

[Frozenx51]

Nvm issue has been fixed.

Quick question tho.
can i get the npc ID's please.
with the size of the file.
looks like u made custom npc's at least i really really hope you did : P i really dont wana to go through all of that.. again.. lost all my data... accidental delete :'(

[trembon]

i have done nothing to the database, except fixing one or two errors.. so you cant ask me if there is any custom npc's.. sorry

[George SS]

Hey , Trembon easytouse pack is not working. Enemys disapear as soon as they try to attack you , also lvl 1 monsters , creeps are not atacable. please help with this issues.

p.s. some skills are bugged too

[trembon]

wierd, cant recall i got any of those errors with the monsters.. tried reinstall the db?

and with the skills.. yes they are bugged.. but they are core issued and nothing i can help with

[George SS]

yes i have tryed to reinstall it a few times .... but still the same error.
than i downloaded some new db's , witch has no bugs but still the same thing with the monsters . (note i only use maps files not vmaps) does that matter anyways?