diff options
23 files changed, 34 insertions, 1615 deletions
diff --git a/sql/updates/287_world_scripts.sql b/sql/updates/287_world_scripts.sql index 8021ee2b01e..4a0c5031188 100644 --- a/sql/updates/287_world_scripts.sql +++ b/sql/updates/287_world_scripts.sql @@ -1,2 +1,3 @@ UPDATE `creature_template` SET `ScriptName` = 'npc_steam_tonk' WHERE `entry` = '19405'; -UPDATE `creature_template` SET `ScriptName` = 'npc_tonk_mine' WHERE `entry` = '15368';
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName` = 'npc_tonk_mine' WHERE `entry` = '15368'; + diff --git a/sql/updates/329_world_spell_proc_event.sql b/sql/updates/329_world.sql index a43aa8baa45..33f61416fb1 100644 --- a/sql/updates/329_world_spell_proc_event.sql +++ b/sql/updates/329_world.sql @@ -1,23 +1,3 @@ -/* -These are Trinity sql. Need to check if they should be added again. -[\sql\updates\230_world.sql] -Line 1 : UPDATE `spell_proc_event` SET `procFlags` = '8396800' WHERE `entry` =14774; -Line 2 : UPDATE `spell_proc_event` SET `procFlags` = '8396800' WHERE `entry` =14531; -[\sql\updates\233_world.sql] -Line 1 : UPDATE `spell_proc_event` SET `SchoolMask` = '1' WHERE `entry` = '41434'; -[\sql\updates\57_world_scripts.sql] -Line 34 : DELETE FROM `spell_proc_event` WHERE `entry` = 43983; -Line 35 : INSERT INTO `spell_proc_event` VALUES ('43983', '0', '0', '0', '0', '0', '16384', '0', '0'); -[\updates\78_world.sql] -Line 12 : DELETE FROM spell_proc_event WHERE entry IN (34139,42368,43726,46092); -Line 13 : INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -Line 19 : DELETE FROM spell_proc_event where entry IN (34598, 34584, 36488); -Line 20 : INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -[\updates\79_world.sql] -Line 1 : DELETE FROM spell_proc_event where entry = 42083; -Line 2 : INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -*/ - DROP TABLE IF EXISTS `spell_proc_event`; SET FOREIGN_KEY_CHECKS=0; @@ -602,4 +582,4 @@ INSERT INTO `spell_proc_event` VALUES ('28716', '0', '7', '16', '294912', '0', ' INSERT INTO `spell_proc_event` VALUES ('28744', '0', '7', '64', '278528', '0', '0', '0', '0'); INSERT INTO `spell_proc_event` VALUES ('12488', '0', '3', '128', '327680', '0', '0', '0', '0'); INSERT INTO `spell_proc_event` VALUES ('19573', '0', '9', '8388608', '16384', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33757', '0', '0', '0', '0', '0', '0', '0', '3');
\ No newline at end of file +INSERT INTO `spell_proc_event` VALUES ('33757', '0', '0', '0', '0', '0', '0', '0', '3'); diff --git a/sql/updates/332_world.sql b/sql/updates/332_world.sql new file mode 100644 index 00000000000..912173fcbbf --- /dev/null +++ b/sql/updates/332_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_target` WHERE `entry` in (30659); +INSERT INTO `spell_script_target` VALUES (30659, 1, 17281); + diff --git a/sql/updates/332_world_spell_script_target.sql b/sql/updates/332_world_spell_script_target.sql deleted file mode 100644 index bb102d9a134..00000000000 --- a/sql/updates/332_world_spell_script_target.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM `spell_script_target` WHERE `entry` in (30659); -INSERT INTO `spell_script_target` VALUES (30659, 1, 17281);
\ No newline at end of file diff --git a/sql/updates/333_world.sql b/sql/updates/333_world.sql new file mode 100644 index 00000000000..9bd405e3589 --- /dev/null +++ b/sql/updates/333_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (42083, 33727, 33754, 33755, 33756, 8516, 10608, 10610, 25583, 25584); +INSERT INTO `spell_proc_event` VALUES ('42083', '0', '0', '0', '0', '2', '0', '0', '0'); +INSERT INTO `spell_proc_event` VALUES ('33727', '0', '0', '0', '0', '0', '0', '0', '3'); +INSERT INTO `spell_proc_event` VALUES ('33754', '0', '0', '0', '0', '0', '0', '0', '3'); +INSERT INTO `spell_proc_event` VALUES ('33755', '0', '0', '0', '0', '0', '0', '0', '3'); +INSERT INTO `spell_proc_event` VALUES ('33756', '0', '0', '0', '0', '0', '0', '0', '3'); +INSERT INTO `spell_proc_event` VALUES ('8516', '0', '0', '0', '0', '0', '0', '0', '3'); +INSERT INTO `spell_proc_event` VALUES ('10608', '0', '0', '0', '0', '0', '0', '0', '3'); +INSERT INTO `spell_proc_event` VALUES ('10610', '0', '0', '0', '0', '0', '0', '0', '3'); +INSERT INTO `spell_proc_event` VALUES ('25583', '0', '0', '0', '0', '0', '0', '0', '3'); +INSERT INTO `spell_proc_event` VALUES ('25584', '0', '0', '0', '0', '0', '0', '0', '3'); diff --git a/sql/updates/333_world_spell_proc_event.sql b/sql/updates/333_world_spell_proc_event.sql deleted file mode 100644 index de0b3089259..00000000000 --- a/sql/updates/333_world_spell_proc_event.sql +++ /dev/null @@ -1,618 +0,0 @@ -/* -These are Trinity sql. Need to check if they should be added again. -[\sql\updates\230_world.sql] -Line 1 : UPDATE `spell_proc_event` SET `procFlags` = '8396800' WHERE `entry` =14774; -Line 2 : UPDATE `spell_proc_event` SET `procFlags` = '8396800' WHERE `entry` =14531; -[\sql\updates\233_world.sql] -Line 1 : UPDATE `spell_proc_event` SET `SchoolMask` = '1' WHERE `entry` = '41434'; -[\sql\updates\57_world_scripts.sql] -Line 34 : DELETE FROM `spell_proc_event` WHERE `entry` = 43983; -Line 35 : INSERT INTO `spell_proc_event` VALUES ('43983', '0', '0', '0', '0', '0', '16384', '0', '0'); -[\updates\78_world.sql] -Line 12 : DELETE FROM spell_proc_event WHERE entry IN (34139,42368,43726,46092); -Line 13 : INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -Line 19 : DELETE FROM spell_proc_event where entry IN (34598, 34584, 36488); -Line 20 : INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -[\updates\79_world.sql] -Line 1 : DELETE FROM spell_proc_event where entry = 42083; -Line 2 : INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES - -DELETE FROM spell_proc_event where entry = 35080; -INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -(35080,0,0,0,0,0x0000000000000000,0x00080001,0,60); -*/ - -DROP TABLE IF EXISTS `spell_proc_event`; - -SET FOREIGN_KEY_CHECKS=0; --- ---------------------------- --- Table structure for spell_proc_event --- ---------------------------- -CREATE TABLE `spell_proc_event` ( - `entry` smallint(6) unsigned NOT NULL default '0', - `SchoolMask` tinyint(4) NOT NULL default '0', - `SpellFamilyName` smallint(6) unsigned NOT NULL default '0', - `SpellFamilyMask` bigint(40) unsigned NOT NULL default '0', - `procFlags` int(10) unsigned NOT NULL default '0', - `procEx` int(10) unsigned NOT NULL default '0', - `ppmRate` float NOT NULL default '0', - `CustomChance` float NOT NULL default '0', - `Cooldown` int(10) unsigned NOT NULL default '0', - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- ---------------------------- --- Records --- ---------------------------- -INSERT INTO `spell_proc_event` VALUES ('9452', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34917', '32', '6', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34916', '32', '6', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34914', '32', '6', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29076', '20', '3', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29075', '20', '3', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29074', '20', '3', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12704', '0', '0', '0', '0', '0', '1.6626', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12289', '0', '4', '2', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12311', '0', '4', '2048', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28849', '0', '11', '128', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28847', '0', '7', '32', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28823', '0', '11', '192', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28809', '0', '6', '4096', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28719', '0', '7', '32', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12668', '0', '4', '2', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12703', '0', '0', '0', '0', '0', '1.33008', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12702', '0', '0', '0', '0', '0', '0.99756', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12701', '0', '0', '0', '0', '0', '0.66504', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12284', '0', '0', '0', '0', '0', '0.33252', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12797', '0', '4', '1024', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12799', '0', '4', '1024', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12800', '0', '4', '1024', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28595', '16', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28594', '16', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28593', '16', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12958', '0', '4', '2048', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13754', '0', '8', '16', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13867', '0', '8', '16', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14186', '0', '8', '1082131720', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14190', '0', '8', '9672066312', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14193', '0', '8', '9672066312', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14194', '0', '8', '9672066312', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14195', '0', '8', '9672066312', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28592', '16', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23721', '0', '9', '2048', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15277', '0', '0', '0', '0', '0', '6', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23572', '0', '11', '192', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23551', '0', '11', '192', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20235', '0', '10', '32768', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20234', '0', '10', '32768', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19415', '0', '9', '512', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15346', '0', '0', '0', '0', '0', '6', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19414', '0', '9', '512', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19413', '0', '9', '512', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15600', '0', '0', '0', '0', '0', '1', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19412', '0', '9', '512', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16850', '0', '7', '4', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16864', '0', '0', '0', '0', '0', '2', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16923', '0', '7', '4', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16924', '0', '7', '4', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16952', '0', '7', '4398046744576', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16954', '0', '7', '4398046744576', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19407', '0', '9', '512', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18096', '0', '5', '549755813984', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18073', '0', '5', '549755813984', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17793', '0', '5', '1', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17796', '0', '5', '1', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17801', '0', '5', '1', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18095', '0', '5', '10', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18094', '0', '5', '10', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17802', '0', '5', '1', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18119', '0', '5', '18416819766245', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18120', '0', '5', '18416819766245', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18121', '0', '5', '18416819766245', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18122', '0', '5', '18416819766245', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18123', '0', '5', '18416819766245', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19228', '0', '0', '64', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19232', '0', '9', '64', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19233', '0', '9', '64', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17803', '0', '5', '1', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16164', '0', '11', '2416967683', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15363', '0', '6', '17448312320', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15362', '0', '6', '17448312320', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15326', '0', '6', '8691163136', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20164', '0', '0', '0', '0', '0', '5', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20165', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20166', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20215', '0', '10', '3223322624', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20214', '0', '10', '3223322624', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20213', '0', '10', '3223322624', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20212', '0', '10', '3223322624', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20210', '0', '10', '3223322624', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15325', '0', '6', '8691163136', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15324', '0', '6', '8691163136', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20347', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20348', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20349', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20356', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20357', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20375', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20500', '0', '4', '268435456', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20501', '0', '4', '268435456', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20915', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20918', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20919', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20920', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('21890', '0', '4', '3763103747823', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15323', '0', '6', '8691163136', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15286', '32', '6', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23578', '0', '0', '0', '0', '0', '2', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23581', '0', '0', '0', '0', '0', '2', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23686', '0', '0', '0', '0', '0', '2', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23689', '0', '0', '0', '0', '0', '4', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23695', '0', '4', '2', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15268', '0', '6', '8691163136', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('25669', '0', '0', '0', '0', '0', '1', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('26016', '0', '0', '0', '0', '0', '2', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('26021', '0', '0', '0', '0', '0', '2', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('26119', '0', '10', '2416967683', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('26480', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27160', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27166', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27170', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27419', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27498', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27656', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27787', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14892', '0', '6', '17448312320', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12848', '4', '3', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12847', '4', '3', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12846', '4', '3', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('11255', '0', '3', '16384', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28789', '0', '10', '3221225472', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12360', '4', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28816', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12359', '4', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12358', '4', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12357', '4', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12598', '0', '3', '16384', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('11180', '16', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('11129', '0', '3', '274890489879', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29150', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29501', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29624', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29625', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29626', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29632', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29633', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29634', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29635', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29636', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29637', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30299', '36', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30675', '0', '11', '3', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30678', '0', '11', '3', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30679', '0', '11', '3', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30680', '0', '11', '3', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30681', '0', '11', '3', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31801', '0', '0', '0', '0', '0', '20', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31833', '0', '10', '2147483648', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31835', '0', '10', '2147483648', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31836', '0', '10', '2147483648', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30302', '36', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30301', '36', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32385', '0', '5', '73014445058', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32387', '0', '5', '73014445058', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32392', '0', '5', '73014445058', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32393', '0', '5', '73014445058', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32394', '0', '5', '73014445058', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('11120', '4', '3', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('11119', '4', '3', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('11103', '4', '3', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37195', '0', '10', '8388608', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37377', '32', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('39437', '4', '5', '824633725796', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33191', '0', '6', '4398054932480', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33192', '0', '6', '4398054932480', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33193', '0', '6', '4398054932480', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33194', '0', '6', '4398054932480', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33195', '0', '6', '4398054932480', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40475', '0', '0', '0', '0', '0', '3', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('41434', '0', '0', '0', '0', '0', '2', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('37523', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30293', '0', '5', '824633721729', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30295', '0', '5', '824633721729', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30296', '0', '5', '824633721729', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40407', '0', '0', '0', '0', '0', '6', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31895', '0', '0', '0', '0', '0', '5', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37247', '8', '0', '0', '0', '65536', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('33510', '0', '0', '0', '0', '0', '5', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16624', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28752', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16176', '0', '11', '448', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16235', '0', '11', '448', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16240', '0', '11', '448', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23920', '0', '0', '0', '0', '2048', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27811', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27815', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27816', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33142', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33145', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33146', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16487', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16489', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16492', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('26605', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16550', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('22648', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34320', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29977', '0', '3', '274890489879', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37443', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('38350', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('38347', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12834', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12849', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12867', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30160', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29179', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29180', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12317', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13045', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13046', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13047', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13048', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34500', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34502', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34503', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('9799', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('25988', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29062', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29064', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29065', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15088', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12319', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16256', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12971', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16281', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12972', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16282', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12973', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16283', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12974', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16284', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('42083', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34950', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34954', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28812', '0', '8', '33554438', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37227', '0', '11', '448', '0', '2', '0', '0', '60'); -INSERT INTO `spell_proc_event` VALUES ('32885', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('21882', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34258', '0', '10', '34359739392', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37237', '0', '11', '1', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37657', '0', '0', '0', '0', '2', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('40482', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37213', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14531', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14774', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16880', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('35121', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20705', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16958', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16961', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33648', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37189', '0', '10', '3221225472', '0', '2', '0', '0', '60'); -INSERT INTO `spell_proc_event` VALUES ('43338', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33150', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33154', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34497', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34498', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34499', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30802', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30808', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30809', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30810', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30811', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20049', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20056', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20057', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20058', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20059', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37519', '0', '0', '0', '0', '48', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('26107', '0', '7', '549764202496', '0', '116', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23548', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37514', '0', '0', '0', '0', '32', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40444', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20911', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20912', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20913', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20914', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27168', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17495', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('22618', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('25899', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27169', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31904', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32777', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20925', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20927', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20928', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27179', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12298', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12724', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12725', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12726', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12727', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32642', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33089', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('26128', '0', '0', '0', '0', '8', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29441', '0', '0', '0', '0', '8', '0', '0', '1'); -INSERT INTO `spell_proc_event` VALUES ('29444', '0', '0', '0', '0', '8', '0', '0', '1'); -INSERT INTO `spell_proc_event` VALUES ('29445', '0', '0', '0', '0', '8', '0', '0', '1'); -INSERT INTO `spell_proc_event` VALUES ('29446', '0', '0', '0', '0', '8', '0', '0', '1'); -INSERT INTO `spell_proc_event` VALUES ('29447', '0', '0', '0', '0', '8', '0', '0', '1'); -INSERT INTO `spell_proc_event` VALUES ('34749', '0', '0', '0', '0', '8', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13983', '0', '0', '0', '0', '24', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14070', '0', '0', '0', '0', '24', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14071', '0', '0', '0', '0', '24', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('41034', '0', '0', '0', '0', '1024', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32734', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('974', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('32593', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('32594', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('40899', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('324', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('325', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('905', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('945', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('8134', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('10431', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('10432', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('25469', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('25472', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('34355', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('39027', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('34827', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('24398', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('33736', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('41260', '0', '0', '0', '0', '0', '0', '0', '10'); -INSERT INTO `spell_proc_event` VALUES ('41262', '0', '0', '0', '0', '0', '0', '0', '10'); -INSERT INTO `spell_proc_event` VALUES ('34935', '0', '0', '0', '0', '0', '0', '0', '8'); -INSERT INTO `spell_proc_event` VALUES ('34938', '0', '0', '0', '0', '0', '0', '0', '8'); -INSERT INTO `spell_proc_event` VALUES ('34939', '0', '0', '0', '0', '0', '0', '0', '8'); -INSERT INTO `spell_proc_event` VALUES ('33746', '0', '0', '0', '0', '0', '0', '0', '10'); -INSERT INTO `spell_proc_event` VALUES ('33759', '0', '0', '0', '0', '0', '0', '0', '10'); -INSERT INTO `spell_proc_event` VALUES ('16620', '0', '0', '0', '0', '0', '0', '0', '30'); -INSERT INTO `spell_proc_event` VALUES ('21185', '0', '0', '0', '0', '0', '0', '0', '10'); -INSERT INTO `spell_proc_event` VALUES ('29801', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30030', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30033', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30701', '28', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30705', '28', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43748', '0', '11', '2416967680', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43750', '0', '11', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('42370', '0', '11', '64', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30881', '0', '0', '0', '0', '0', '0', '0', '5'); -INSERT INTO `spell_proc_event` VALUES ('30883', '0', '0', '0', '0', '0', '0', '0', '5'); -INSERT INTO `spell_proc_event` VALUES ('30884', '0', '0', '0', '0', '0', '0', '0', '5'); -INSERT INTO `spell_proc_event` VALUES ('30885', '0', '0', '0', '0', '0', '0', '0', '5'); -INSERT INTO `spell_proc_event` VALUES ('30886', '0', '0', '0', '0', '0', '0', '0', '5'); -INSERT INTO `spell_proc_event` VALUES ('34138', '0', '11', '128', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43728', '0', '11', '128', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('26135', '0', '10', '8388608', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43745', '0', '10', '2199023255552', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34139', '0', '10', '1073741824', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43741', '0', '10', '2147483648', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('42368', '0', '10', '1073741824', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34262', '0', '10', '8388608', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('41469', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33127', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29385', '0', '0', '0', '0', '0', '7', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43726', '0', '10', '1073741824', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('35100', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('35102', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('35103', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40485', '0', '9', '4294967296', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31124', '0', '8', '536870926', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31126', '0', '8', '536870926', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31233', '0', '8', '38658768896', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31239', '0', '8', '38658768896', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31240', '0', '8', '38658768896', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31241', '0', '8', '38658768896', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31242', '0', '8', '38658768896', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37168', '0', '8', '38658768896', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37170', '0', '0', '0', '0', '0', '1', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37165', '0', '8', '2098176', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31244', '0', '8', '38658768896', '0', '4', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31245', '0', '8', '38658768896', '0', '4', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('41393', '0', '0', '0', '0', '32', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14156', '0', '8', '4063232', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14160', '0', '8', '4063232', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14161', '0', '8', '4063232', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('38326', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17106', '0', '7', '524288', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17107', '0', '7', '524288', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17108', '0', '7', '524288', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43739', '0', '7', '2', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43737', '0', '7', '4672924418048', '0', '0', '0', '0', '10'); -INSERT INTO `spell_proc_event` VALUES ('39372', '48', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37568', '0', '6', '2048', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37594', '0', '6', '4096', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34753', '0', '6', '17179875328', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34859', '0', '6', '17179875328', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34860', '0', '6', '17179875328', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37603', '0', '6', '32768', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('38394', '0', '5', '6', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37384', '0', '5', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40478', '0', '5', '2', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37528', '0', '4', '4', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37516', '0', '4', '1024', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40458', '0', '4', '6601398288384', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('22007', '0', '3', '2097185', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('3232', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17364', '8', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30937', '32', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('15128', '4', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37193', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32776', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20132', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20131', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20128', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17794', '32', '0', '0', '0', '1', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31394', '32', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('25050', '4', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('24353', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20134', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17797', '32', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17798', '32', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('24389', '0', '3', '274890489879', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('20133', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('36111', '0', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29455', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34774', '0', '0', '0', '0', '0', '1.5', '0', '20'); -INSERT INTO `spell_proc_event` VALUES ('9784', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31785', '0', '0', '0', '34816', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('9782', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('24932', '0', '0', '0', '0', '2', '0', '0', '6'); -INSERT INTO `spell_proc_event` VALUES ('33776', '0', '0', '0', '34816', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34586', '0', '0', '0', '0', '0', '1.5', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('2565', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12169', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32587', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('38031', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34080', '0', '0', '0', '0', '8', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('42136', '0', '0', '0', '0', '0', '0', '0', '90'); -INSERT INTO `spell_proc_event` VALUES ('42135', '0', '0', '0', '0', '0', '0', '0', '90'); -INSERT INTO `spell_proc_event` VALUES ('23547', '0', '0', '0', '0', '32', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32837', '0', '0', '0', '0', '65536', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('17799', '32', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('17800', '32', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37197', '0', '0', '0', '0', '65536', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('23688', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('34783', '0', '0', '0', '0', '2048', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27521', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27774', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28802', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37600', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19184', '0', '9', '35184372088852', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19387', '0', '9', '35184372088852', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19388', '0', '9', '35184372088852', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37655', '0', '0', '0', '0', '0', '0', '0', '60'); -INSERT INTO `spell_proc_event` VALUES ('38334', '0', '0', '0', '0', '0', '0', '0', '60'); -INSERT INTO `spell_proc_event` VALUES ('12966', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12967', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12968', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12969', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12970', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16257', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16277', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16278', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16279', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('16280', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('36096', '0', '0', '0', '0', '2048', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43443', '0', '0', '0', '0', '2048', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30003', '0', '0', '0', '0', '2048', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27181', '1', '0', '0', '0', '256', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('41381', '0', '0', '0', '0', '256', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('38026', '1', '0', '0', '0', '256', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31569', '0', '3', '65536', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31570', '0', '3', '65536', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('7383', '1', '0', '0', '0', '256', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('39530', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33299', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37214', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('31794', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('18820', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('37601', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('43819', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('6346', '0', '0', '0', '0', '256', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23552', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('46025', '0', '0', '0', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40442', '0', '7', '4672924418068', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40470', '0', '10', '3229614080', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40438', '0', '6', '32832', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('40463', '0', '11', '68719476865', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12322', '0', '0', '0', '0', '0', '2', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12999', '0', '0', '0', '0', '0', '4', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13000', '0', '0', '0', '0', '0', '6', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13001', '0', '0', '0', '0', '0', '8', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13002', '0', '0', '0', '0', '0', '10', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14318', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('13165', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14319', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14320', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14321', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('14322', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('25296', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27044', '0', '9', '1', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('39443', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('39442', '0', '0', '0', '0', '1', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('35080', '0', '0', '0', '0', '0', '1', '0', '60'); -INSERT INTO `spell_proc_event` VALUES ('35077', '0', '0', '0', '0', '0', '0', '0', '60'); -INSERT INTO `spell_proc_event` VALUES ('35086', '0', '0', '0', '0', '0', '0', '0', '60'); -INSERT INTO `spell_proc_event` VALUES ('35083', '0', '0', '0', '0', '0', '0', '0', '60'); -INSERT INTO `spell_proc_event` VALUES ('18137', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('19308', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('19309', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('19310', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('19311', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('19312', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('25477', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('38327', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33881', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33882', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33883', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33719', '0', '0', '0', '0', '2048', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29834', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('29838', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('39958', '0', '0', '0', '0', '0', '0.7', '0', '40'); -INSERT INTO `spell_proc_event` VALUES ('1463', '0', '0', '0', '0', '1024', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('8494', '0', '0', '0', '0', '1024', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('8495', '0', '0', '0', '0', '1024', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('10191', '0', '0', '0', '0', '1024', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('10192', '0', '0', '0', '0', '1024', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('10193', '0', '0', '0', '0', '1024', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('27131', '0', '0', '0', '0', '1024', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('32844', '0', '0', '0', '0', '0', '2', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33076', '0', '0', '0', '656040', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('46662', '0', '0', '0', '0', '0', '0', '0', '20'); -INSERT INTO `spell_proc_event` VALUES ('38857', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('8178', '0', '0', '0', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('41635', '0', '0', '0', '656040', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('30823', '0', '0', '0', '0', '0', '10.5', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('24905', '0', '0', '0', '0', '0', '15', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('46098', '0', '11', '128', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('46092', '0', '10', '1073741824', '0', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('38290', '0', '0', '0', '0', '0', '1.6', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('45234', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('45243', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('45244', '0', '0', '0', '0', '2', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('23602', '0', '0', '0', '0', '64', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('45483', '0', '0', '0', '0', '0', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('45482', '0', '0', '0', '0', '0', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('45484', '0', '0', '0', '16384', '0', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('46569', '0', '0', '0', '0', '0', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('45481', '0', '0', '0', '0', '0', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('32748', '0', '8', '4294967296', '320', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('24658', '0', '0', '0', '82192', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('44835', '0', '7', '549755813888', '16', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('46832', '0', '7', '1', '0', '65536', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('45057', '0', '0', '0', '0', '0', '0', '0', '30'); -INSERT INTO `spell_proc_event` VALUES ('37173', '0', '8', '1126031951256', '0', '0', '0', '0', '30'); -INSERT INTO `spell_proc_event` VALUES ('45054', '0', '0', '0', '0', '0', '0', '0', '15'); -INSERT INTO `spell_proc_event` VALUES ('45354', '0', '0', '0', '0', '0', '0', '0', '45'); -INSERT INTO `spell_proc_event` VALUES ('41989', '0', '0', '0', '0', '0', '0.5', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('11185', '0', '3', '128', '327680', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12487', '0', '3', '128', '327680', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19572', '0', '9', '8388608', '16384', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28716', '0', '7', '16', '294912', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('28744', '0', '7', '64', '278528', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('12488', '0', '3', '128', '327680', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('19573', '0', '9', '8388608', '16384', '0', '0', '0', '0'); -INSERT INTO `spell_proc_event` VALUES ('33727', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('33754', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('33755', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('33756', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('33757', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('8516', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('10608', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('10610', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('25583', '0', '0', '0', '0', '0', '0', '0', '3'); -INSERT INTO `spell_proc_event` VALUES ('25584', '0', '0', '0', '0', '0', '0', '0', '3');
\ No newline at end of file diff --git a/sql/updates/334_world_trinity_string.sql b/sql/updates/334_world.sql index 6cd6cb7714a..6cd6cb7714a 100644 --- a/sql/updates/334_world_trinity_string.sql +++ b/sql/updates/334_world.sql diff --git a/sql/updates/356_world.sql b/sql/updates/356_world.sql index 9fbc2379976..9db8a85d7cd 100644 --- a/sql/updates/356_world.sql +++ b/sql/updates/356_world.sql @@ -1,2 +1,2 @@ DELETE FROM `spell_elixir` WHERE `entry` = 45373; -INSERT INTO `spell_elixir` VALUES (45373,0x1);
\ No newline at end of file +INSERT INTO `spell_elixir` VALUES (45373,0x1); diff --git a/sql/updates/373_world_scripts.sql b/sql/updates/373_world_scripts.sql index 537f5ac6e2a..db27ebe2441 100644 --- a/sql/updates/373_world_scripts.sql +++ b/sql/updates/373_world_scripts.sql @@ -1,3 +1,3 @@ -update creature_template set scriptname = 'boss_warchief_kargath_bladefist' where entry = 16808; -UPDATE `instance_template` SET `script`='instance_deadmines' WHERE map = 36; -UPDATE `item_template` SET `ScriptName`='item_defias_gunpowder' WHERE entry = 5397;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='boss_warchief_kargath_bladefist' WHERE `entry`=16808; +UPDATE `instance_template` SET `script`='instance_deadmines' WHERE `map`=36; +UPDATE `item_template` SET `ScriptName`='item_defias_gunpowder' WHERE `entry`=5397; diff --git a/sql/updates/377_world_scripts.sql b/sql/updates/377_world_scripts.sql index 3fb8ef12fe8..fe93962ef3a 100644 --- a/sql/updates/377_world_scripts.sql +++ b/sql/updates/377_world_scripts.sql @@ -1,10 +1,10 @@ -update creature_template set scriptname = 'npc_second_trial_paladin' where entry in (17809,17810,17811,17812); -update creature_template set scriptname = 'npc_second_trial_controller' where entry in (17807); -update gameobject_template set scriptname = 'go_second_trial' where entry in (182052); +UPDATE `creature_template` SET `ScriptName`='npc_second_trial_paladin' WHERE `entry` IN (17809,17810,17811,17812); +UPDATE `creature_template` SET `ScriptName`='npc_second_trial_controller' WHERE `entry` IN (17807); +UPDATE `gameobject_template` SET `ScriptName`='go_second_trial' WHERE `entry` IN (182052); -delete from `script_texts` where entry between -1645009 and -1645006; +DELETE FROM `script_texts` WHERE `entry` BETWEEN -1645009 AND -1645006; INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `comment`) VALUES (-1645006,'Let the trial begin, Bloodwrath, attack!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'), (-1645007,'Champion Lightrend, make me proud!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'), (-1645008,'Show this upstart how a real Blood Knight fights, Swiftblade!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'), -(-1645009,'Show $N the meaning of pain, Sunstriker!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE');
\ No newline at end of file +(-1645009,'Show $N the meaning of pain, Sunstriker!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'); diff --git a/sql/updates/381_world.sql b/sql/updates/381_world.sql deleted file mode 100644 index 742c8b7612b..00000000000 --- a/sql/updates/381_world.sql +++ /dev/null @@ -1,82 +0,0 @@ --- SELECT `gameobject_template` WHERE `entry` IN (186648, 187021, 186672, 186667); -DELETE FROM `gameobject_loot_template` WHERE `entry` IN (22699, 22790, 22797, 22968); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33480, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33481, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33483, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33489, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33590, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33591, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33805, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33971, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33490, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33491, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33492, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33493, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33494, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33495, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33496, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33497, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33498, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33499, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33500, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33809, 100, 0, 13, 7, 4); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33480, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33481, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33483, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33489, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33590, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33591, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33805, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33971, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33490, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33491, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33492, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33493, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33494, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33495, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33496, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33497, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33498, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33499, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33500, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33809, 100, 0, 13, 7, 4); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33480, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33481, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33483, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33489, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33590, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33591, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33805, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33971, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33490, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33491, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33492, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33493, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33494, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33495, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33496, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33497, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33498, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33499, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33500, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33809, 100, 0, 13, 7, 4); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33480, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33481, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33483, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33489, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33590, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33591, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33805, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33971, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33490, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33491, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33492, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33493, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33494, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33495, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33496, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33497, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33498, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33499, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33500, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33809, 100, 0, 13, 7, 4);
\ No newline at end of file diff --git a/sql/updates/389_world.sql b/sql/updates/389_world.sql index 5dc88d362ae..bbe7fb6fcc6 100644 --- a/sql/updates/389_world.sql +++ b/sql/updates/389_world.sql @@ -4,4 +4,4 @@ INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `commen INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-24133, 24135, 0, 'Wyvern Sting'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-27068, 27069, 0, 'Wyvern Sting'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49011, 49009, 0, 'Wyvern Sting'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49012, 49010, 0, 'Wyvern Sting');
\ No newline at end of file +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49012, 49010, 0, 'Wyvern Sting'); diff --git a/sql/updates/400_world.sql b/sql/updates/400_world.sql index c40981b6919..a2f7d1e6cea 100644 --- a/sql/updates/400_world.sql +++ b/sql/updates/400_world.sql @@ -7,4 +7,4 @@ INSERT INTO `spell_script_target` VALUES (5628, 1, 2012); INSERT INTO `spell_script_target` VALUES (5628, 1, 2013); INSERT INTO `spell_script_target` VALUES (5628, 1, 2014); INSERT INTO `spell_script_target` VALUES (45109, 1, 25084); -INSERT INTO `spell_script_target` VALUES (45149, 0, 300154);
\ No newline at end of file +INSERT INTO `spell_script_target` VALUES (45149, 0, 300154); diff --git a/sql/updates/426_world_scripts.sql b/sql/updates/426_world_scripts.sql index 1d653e57891..fde6ee6dbf2 100644 --- a/sql/updates/426_world_scripts.sql +++ b/sql/updates/426_world_scripts.sql @@ -1,14 +1,13 @@ -UPDATE gameobject_template set scriptName="go_altar_of_the_keepers" where entry = 130511; -UPDATE gameobject_template set scriptName="go_altar_of_archaedas" where entry = 133234; +UPDATE `gameobject_template` SET `ScriptName`='go_altar_of_the_keepers' WHERE `entry`=130511; +UPDATE `gameobject_template` SET `ScriptName`='go_altar_of_archaedas' WHERE `entry`=133234; -UPDATE instance_template SET script="instance_uldaman" where map = 70; +UPDATE `instance_template` SET `script`='instance_uldaman' WHERE `map`=70; -- Archaedas -UPDATE creature_template SET ScriptName="boss_archaedas" where entry = 2748; +UPDATE `creature_template` SET `ScriptName`='boss_archaedas' WHERE `entry`=2748; -- Archaedas' minions -UPDATE creature_template SET ScriptName="mob_archaedas_minions" where entry in ('7309', '7077', '7076', '10120'); +UPDATE `creature_template` SET `ScriptName`='mob_archaedas_minions' WHERE `entry` IN ('7309', '7077', '7076', '10120'); -- Stone keepers -UPDATE creature_template SET ScriptName="mob_stonekeepers" where entry = 4857; - +UPDATE `creature_template` SET `ScriptName`='mob_stonekeepers' WHERE `entry`=4857; diff --git a/sql/updates/full/characters.sql b/sql/updates/full/characters.sql deleted file mode 100644 index b3b5e264eec..00000000000 --- a/sql/updates/full/characters.sql +++ /dev/null @@ -1,29 +0,0 @@ -ALTER TABLE `arena_team_member` ADD COLUMN `points_to_add` int(10) UNSIGNED NOT NULL DEFAULT '0'; -DROP TABLE IF EXISTS `saved_variables`; -CREATE TABLE `saved_variables` ( - `NextArenaPointDistributionTime` timestamp NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; - -CREATE TABLE `game_event_save` ( - `event_id` mediumint(8) unsigned NOT NULL, - `state` tinyint(3) unsigned NOT NULL default '1', - `next_start` timestamp NOT NULL default '0000-00-00 00:00:00', - PRIMARY KEY (`event_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `game_event_condition_save` ( - `event_id` mediumint(8) unsigned NOT NULL, - `condition_id` mediumint(8) unsigned NOT NULL default '0', - `done` float default '0', - PRIMARY KEY (`event_id`,`condition_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `characters` - ADD `latency` int(11) unsigned NOT NULL default '0' AFTER `taxi_path`; - -ALTER TABLE `guild_bank_tab` - CHANGE COLUMN `TabText` `TabText` text; - -ALTER TABLE `character_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index` ; -ALTER TABLE `pet_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index` ; - diff --git a/sql/updates/full/realm.sql b/sql/updates/full/realm.sql deleted file mode 100644 index 37fe28db036..00000000000 --- a/sql/updates/full/realm.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE account - CHANGE COLUMN tbc expansion tinyint(3) unsigned NOT NULL default '0'; - -ALTER TABLE `account` - CHANGE COLUMN `email` `email` text;
\ No newline at end of file diff --git a/sql/updates/full/skip.txt b/sql/updates/full/skip.txt deleted file mode 100644 index 69c94018b6e..00000000000 --- a/sql/updates/full/skip.txt +++ /dev/null @@ -1,9 +0,0 @@ -117: eventai structure change from ACID -123: script text from SD2 -133: script text from SD2 -172: script text from SD2 -285: AV bg -329: proc flag -333: proc flag - -until 426
\ No newline at end of file diff --git a/sql/updates/full/world.sql b/sql/updates/full/world.sql deleted file mode 100644 index 111b83caa51..00000000000 --- a/sql/updates/full/world.sql +++ /dev/null @@ -1,430 +0,0 @@ -CREATE TABLE `game_event_battleground_holiday` ( - `event` int(10) unsigned NOT NULL, - `bgflag` int(10) unsigned NOT NULL default '0', - PRIMARY KEY (`event`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `spell_disabled`; -CREATE TABLE `spell_disabled` ( - `entry` int(11) unsigned NOT NULL default '0' COMMENT 'Spell entry', - `disable_mask` int(8) unsigned NOT NULL default '0', - `comment` varchar(64) NOT NULL default '', - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Disabled Spell System'; - -ALTER TABLE arena_team_member CHANGE played_week games_week int(10) unsigned NOT NULL default '0'; -ALTER TABLE arena_team_member CHANGE wons_week wins_week int(10) unsigned NOT NULL default '0'; -ALTER TABLE arena_team_member CHANGE played_season games_season int(10) unsigned NOT NULL default '0'; -ALTER TABLE arena_team_member CHANGE wons_season wins_season int(10) unsigned NOT NULL default '0'; - -TRUNCATE TABLE playercreateinfo_item; - -ALTER TABLE `guild_member` DROP INDEX `guid_key` , -ADD UNIQUE `guid_key` ( `guid` ); - -ALTER TABLE characters - CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0'; - -ALTER TABLE `quest_template` - ADD `RewHonorableKills` mediumint(9) unsigned NOT NULL default '0' AFTER `RewRepValue5`; - -ALTER TABLE event_scripts - DROP datatext, - ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; - -ALTER TABLE gameobject_scripts - DROP datatext, - ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; - -ALTER TABLE quest_end_scripts - DROP datatext, - ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; - -ALTER TABLE quest_start_scripts - DROP datatext, - ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; - -ALTER TABLE spell_scripts - DROP datatext, - ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; - -ALTER TABLE creature_movement - DROP `text1`, - DROP `text2`, - DROP `text3`, - DROP `text4`, - DROP `text5`, - ADD COLUMN textid1 int(11) NOT NULL default '0' AFTER waittime, - ADD COLUMN textid2 int(11) NOT NULL default '0' AFTER textid1, - ADD COLUMN textid3 int(11) NOT NULL default '0' AFTER textid2, - ADD COLUMN textid4 int(11) NOT NULL default '0' AFTER textid3, - ADD COLUMN textid5 int(11) NOT NULL default '0' AFTER textid4; - -ALTER TABLE `npc_option` - CHANGE COLUMN `id` `id` mediumint(8) unsigned NOT NULL default '0', - CHANGE COLUMN `gossip_id` `gossip_id` mediumint(8) unsigned NOT NULL default '0', - CHANGE COLUMN `action` `action` mediumint(8) unsigned NOT NULL default '0', - ADD COLUMN `box_money` int(10) unsigned NOT NULL default '0' AFTER `action`, - ADD COLUMN `coded` tinyint(3) unsigned NOT NULL default '0' AFTER `box_money`, - ADD COLUMN `box_text` text AFTER `option_text`; - -CREATE TABLE `locales_npc_option` ( - `entry` mediumint(8) unsigned NOT NULL default '0', - `option_text_loc1` text, - `option_text_loc2` text, - `option_text_loc3` text, - `option_text_loc4` text, - `option_text_loc5` text, - `option_text_loc6` text, - `option_text_loc7` text, - `option_text_loc8` text, - `box_text_loc1` text, - `box_text_loc2` text, - `box_text_loc3` text, - `box_text_loc4` text, - `box_text_loc5` text, - `box_text_loc6` text, - `box_text_loc7` text, - `box_text_loc8` text, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -ALTER TABLE `creature_template` - CHANGE COLUMN `flags` `unit_flags` int(10) unsigned NOT NULL default '0', - CHANGE COLUMN `flag1` `type_flags` int(10) unsigned NOT NULL default '0'; - - DELETE FROM `command` WHERE name IN ('possess', 'unpossess'); -INSERT INTO `command` (name,security,help) VALUES -('possess',3,'Syntax: .possess\r\n\r\nPossesses indefinitely the selected creature.'), -('unpossess',3,'Syntax: .unpossess\r\n\r\nIf you are possessed, unpossesses yourself; otherwise unpossesses current possessed target.'); - - - -DELETE FROM command WHERE name = 'reload all_locales'; -INSERT INTO `command` VALUES -('reload all_locales',3,'Syntax: .reload all_locales\r\n\r\nReload all `locales_*` tables with reload support added and that can be _safe_ reloaded.'); - -delete from `command` where `name` IN ('senditems','sendmail'); -insert into `command` (`name`, `security`, `help`) values -('senditems',3,'Syntax: .senditems #playername "#subject" "#text" itemid1[:count1] itemid2[:count2] ... itemidN[:countN]\r\n\r\nSend a mail to a player. Subject and mail text must be in "". If for itemid not provided related count values then expected 1, if count > max items in stack then items will be send in required amount stacks. All stacks amount in mail limited to 12.'), -('sendmail',1,'Syntax: .sendmail #playername "#subject" "#text"\r\n\r\nSend a mail to a player. Subject and mail text must be in "".'); - - DELETE FROM `command` WHERE name IN ('bindsight', 'unbindsight'); -INSERT INTO `command` (name,security,help) VALUES -('bindsight',3,'Syntax: .bindsight\r\n\r\nBinds vision to the selected unit indefinitely. Cannot be used while currently possessing a target.'), -('unbindsight',3,'Syntax: .unbindsight\r\n\r\nRemoves bound vision. Cannot be used while currently possessing a target.'); - - -DELETE FROM trinity_string WHERE entry IN (453); - --- add lang strings -DELETE FROM trinity_string WHERE entry BETWEEN 1000 AND 1006; -INSERT INTO trinity_string VALUES -(1000,'You froze player %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1001,'It might be amusing but no... you cant freeze yourself!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1002,'Invalid input check the name of target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1003,'You unfroze player %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1004,'There are no frozen players.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1005,'Following players are frozen on the server:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1006,'- %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); - --- add commands -DELETE FROM `command` WHERE `name` = 'freeze' or `name` = 'unfreeze' or name = 'listfreeze'; -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('freeze','2','Syntax: .freeze (#player)\r\n\"Freezes\" #player and disables his chat. When using this without #name it will freeze your target.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('unfreeze','2','Syntax: .unfreeze (#player)\r\n\"Unfreezes\" #player and enables his chat again. When using this without #name it will unfreeze your target.'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES ('listfreeze','1','Syntax: .listfreeze\r\n\r\nSearch and output all frozen players.'); - --- Add/Edit/Move lang strings -DELETE FROM `trinity_string` WHERE `entry` IN (25,52,54,55,56,171,401,413,438,593,594,595,596,597,598,599,614,615,636,637,638,809,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118); -DELETE FROM `trinity_string` WHERE `entry` BETWEEN '667' AND '687'; -DELETE FROM `trinity_string` WHERE `entry` BETWEEN '711' AND '716'; -DELETE FROM `trinity_string` WHERE `entry` BETWEEN '730' AND '747'; -DELETE FROM `trinity_string` WHERE `entry` BETWEEN '5000' AND '5006'; -INSERT INTO trinity_string VALUES -('25','Password not changed (unknown error)!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('52', 'Invaid item count (%u) for item %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('54','The new passwords do not match',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('55','Your password can\'t be longer than 16 characters (client limit), password not changed!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('56','Current Message of the day: \r\n%s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(171,'You are being teleported by server console command.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(401,'You change security level of account %s to %i.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(413,'Account not exist: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(438,'Found items %u: %u ( inventory %u mail %u auction %u guild %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(593,'Currently Banned Accounts:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(594,'| Account | BanDate | UnbanDate | Banned By | Ban Reason |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(595,'Currently Banned IPs:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(596,'| IP | BanDate | UnbanDate | Banned By | Ban Reason |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(597,'Current gamemasters:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(598,'| Account | GM |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(599,'No gamemasters.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('614', 'The Alliance flag has been respawned!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('615', 'The Horde flag has been respawned!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('636', 'The Battle for Eye of the Storm begins in 1 minute.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('637', 'The Battle for Eye of the Storm begins in 30 seconds.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('638', 'The Battle for Eye of the Storm has begun!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('667', 'The Alliance has taken control of the Mage Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('668', 'The Horde has taken control of the Mage Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('669', 'The Alliance has taken control of the Draenei Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('670', 'The Horde has taken control of the Draenei Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('671', 'The Alliance has taken control of the Blood Elf Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('672', 'The Horde has taken control of the Blood Elf Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('673', 'The Alliance has taken control of the Fel Reaver Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('674', 'The Horde has taken control of the Fel Reaver Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('675', 'The Alliance has lost control of the Mage Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('676', 'The Horde has lost control of the Mage Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('677', 'The Alliance has lost control of the Draenei Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('678', 'The Horde has lost control of the Draenei Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('679', 'The Alliance has lost control of the Blood Elf Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('680', 'The Horde has lost control of the Blood Elf Tower!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('681', 'The Alliance has lost control of the Fel Reaver Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('682', 'The Horde has lost control of the Fel Reaver Ruins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('683', '$N has taken the flag!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('684', 'The Alliance has captured the flag!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('685', 'The Horde has captured the flag!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('686', 'The Flag has been dropped!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('687', 'The flag has been reset', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('711', 'Your group is too large for this battleground. Please regroup to join.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('712', 'Your group is too large for this arena. Please regroup to join.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('713', 'You must be level %u to join an arena team!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('714', '%s is not high enough level to join your team', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('715', 'You don\'t meet Battleground level requirements', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('716', 'Your arena team is full, %s cannot join it.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('730', 'Your group has members not in your arena team. Please regroup to join.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('731', 'Your group does not have enough players to join this match.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('732', 'The Gold Team wins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('733', 'The Green Team wins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('734', 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('735', 'Your group has an offline member. Please remove him before joining.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('736', 'Your group has players from the opposing faction. You can\'t join the battleground as a group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('737', 'Your group has players from different battleground brakets. You can\'t join as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('738', 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('739', 'Someone in your party is Deserter. You can\'t join as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('740', 'Someone in your party is already in three battleground queues. You cannot join as group.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('741', 'You cannot teleport to a battleground or arena map.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('742', 'You cannot summon players to a battleground or arena map.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('743', 'You must be in GM mode to teleport to a player in a battleground.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('744', 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('745', 'Arena testing turned %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('746','|cffff0000[Automatic]:|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('747','|cffffff00[|c1f40af20Announce by|r |cffff0000%s|cffffff00]:|r %s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -('809','Account for character %s not found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('1000','Exiting daemon...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('1001','Account deleted: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('1002','Account %s NOT deleted (probably sql file format was updated)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('1003','Account %s NOT deleted (unknown error)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('1004','Account created: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -('1005','Account name can\'t be longer than 16 characters (client limit), account not created!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1006,'Account with this name already exist!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1007,'Account %s NOT created (probably sql file format was updated)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1008,'Account %s NOT created (unknown error)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1009,'Player %s (Guid: %u) Account %s (Id: %u) deleted.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1010,'| Account | Character | IP | GM | TBC |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1011,'|<Error> | %20s |<Error> |<Er>|<Err>|',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1100,'Account %s (Id: %u) have up to %u expansion allowed now.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1101,'Message of the day changed to:\r\n%s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1102,'Message sent to %s: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1103,'%d - %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1104,'%d - %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1105,'%d - %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1106,'%d - %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1107,'%d - %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1108,'%d - %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1109,'%d - %s %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1110,'%d - %s X:%f Y:%f Z:%f MapId:%d',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1111,'%d - %s X:%f Y:%f Z:%f MapId:%d',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1112,'Failed to open file: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1113,'Account %s (%u) have max amount allowed characters (client limit)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1114,'Dump file has broken data!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1115,'Invalid character name!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1116,'Invalid character guid!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1117,'Character guid %u in use!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1118,'%d - guild: %s (guid: %u) %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(5000,'You froze player %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(5001,'It might be amusing but no... you cant freeze yourself!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(5002,'Invalid input check the name of target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(5003,'You unfroze player %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(5004,'There are no frozen players.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(5005,'Following players are frozen on the server:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(5006,'- %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); - - --- cleanup command syntax -DELETE FROM command WHERE name IN ( - 'gm ingame','gm online', - 'ban','ban account','ban character','ban ip', - 'baninfo','baninfo account','baninfo character','baninfo ip','pdump load', - 'banlist','banlist account','banlist character','banlist ip','help','transport', - 'unban','unban account','unban character','unban ip','list item','pdump write', - 'acct','account','account create','account delete','account onlinelist', - 'account set addon','account set gmlevel','account set password', - 'chardelete','gm list','gm online','sendmessage','server corpses','server exit','server motd', - 'server set loglevel','server set motd','security' - -); - -INSERT INTO command VALUES -('gm ingame',0,'Syntax: .gm ingame\r\n\r\nDisplay a list of available in game Game Masters.'), -('ban account',3,'Syntax is: ban account $Name $bantime $reason\r\nBan account kick player.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'), -('ban character',3,'Syntax is: ban character $Name $bantime $reason\r\nBan account and kick player.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'), -('ban ip',3,'Syntax is: ban ip $Ip $bantime $reason\r\nBan IP.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'), -('baninfo account',3,'Syntax is: baninfo account\r\nWatch full information about a specific ban.'), -('baninfo character',3,'Syntax is: baninfo character\r\nWatch full information about a specific ban.'), -('baninfo ip',3,'Syntax is: baninfo ip\r\nWatch full information about a specific ban.'), -('banlist account',3,'Syntax is: banlist account [$Name]\r\nSearches the banlist for a account name pattern or show full list account bans.'), -('banlist character',3,'Syntax is: banlist character $Name\r\nSearches the banlist for a character name pattern. Pattern required.'), -('banlist ip',3,'Syntax is: banlist ip [$Ip]\r\nSearches the banlist for a IP pattern or show full list of IP bans.'), -('unban account',3,'Syntax is: unban account $Name\r\nUnban accounts for account name pattern.'), -('unban character',3,'Syntax is: unban character $Name\r\nUnban accounts for character name pattern.'), -('unban ip',3,'Syntax is: unban ip $Ip\r\nUnban accounts for IP pattern.'), -('pdump write',3,'Syntax is: pdump write $filename $playerNameOrGUID\r\nWrite character dump with name/guid $playerNameOrGUID to file $filename.'), -('pdump load',3,'Syntax is: pdump load $filename $account [$newname] [$newguid]\r\nLoad character dump from dump file into character list of $account with saved or $newname, with saved (or first free) or $newguid guid.'), -('list item',3,'Syntax: .list item #item_id [#max_count]\r\n\r\nOutput items with item id #item_id found in all character inventories, mails, auctions, and guild banks. Output item guids, item owner guid, owner account and owner name (guild name and guid in case guild bank). Will be output maximum #max_count items. If #max_count not provided use 10 as default value.'), -('help',0,'Syntax: .help [$command]\r\n\r\nDisplay usage instructions for the given $command. If no $command provided show list available commands.'), -('account',0,'Syntax: .account\r\n\r\nDisplay the access level of your account.'), -('account create',4,'Syntax: .account create $account $password\r\n\r\nCreate account and set password to it.'), -('account delete',4,'Syntax: .account delete $account\r\n\r\nDelete account with all characters.'), -('account onlinelist',4,'Syntax: .account onlinelist\r\n\r\nShow list of online accounts.'), -('account set addon',3,'Syntax: .account set addon [$account] #addon\r\n\r\nSet user (posible targeted) expansion addon level allowed. Addon values: 0 - normal, 1 - tbc, 2 - wotlk.'), -('account set gmlevel',4,'Syntax: .account set gmlevel [$account] #level\r\n\r\nSet the security level for targeted player (can''t be used at self) or for account $name to a level of #level.\r\n\r\n#level may range from 0 to 3.'), -('account set password',4,'Syntax: .account set password $account $password $password\r\n\r\nSet password for account.'), -('chardelete',4,'Syntax: .chardelete $charactername\r\n\r\nDelete character.'), -('gm list',3,'Syntax: .gm list\r\n\r\nDisplay a list of all Game Masters accounts and security levels.'), -('gm online',0,'Syntax: .gm online\r\n\r\nDisplay a list of available Game Masters.'), -('sendmessage',3,'Syntax: .sendmessage $playername $message\r\n\r\nSend screen message to player from ADMINISTRATOR.'), -('server corpses',2,'Syntax: .server corpses\r\n\r\nTriggering corpses expire check in world.'), -('server exit',4,'Syntax: .server exit\r\n\r\nTerminate Trinity NOW.'), -('server motd',0,'Syntax: .server motd\r\n\r\nShow server Message of the day.'), -('server set loglevel',4,'Syntax: .server set loglevel #level\r\n\r\nSet server log level (0 - errors only, 1 - basic, 2 - detail, 3 - debug).'), -('server set motd',3,'Syntax: .server set motd $MOTD\r\n\r\nSet server Message of the day.'); - -DELETE FROM command WHERE name IN ('npc follow','npc unfollow','waterwalk','repairitems'); - -INSERT INTO command VALUES -('repairitems',2,'Syntax: .repairitems\r\n\r\nRepair all selected player''s items.'), -('npc follow',2,'Syntax: .npc follow\r\n\r\nSelected creature start follow you until death/fight/etc.'), -('npc unfollow',2,'Syntax: .npc unfollow\r\n\r\nSelected creature (non pet) stop follow you.'), -('waterwalk',2,'Syntax: .waterwalk on/off\r\n\r\nSet on/off waterwalk state for selected player or self if no player selected.'); - -DELETE FROM trinity_string WHERE entry IN (171,172,336,337,338,339,340,341,342,5007,5008); - -INSERT INTO trinity_string VALUES -(172,'server console command',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(336,'You repair all %s''s items.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(337,'All your items repaired by %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(338,'You set waterwalk mode %s for %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(339,'Your waterwalk mode set to %s by %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(340,'%s is now following you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(341,'%s is not following you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(342,'%s is now not following you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(810,'You must be in a raid group to enter the instance %s!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(811,'You cannot enter %s while in a ghost mode!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); - -DELETE FROM trinity_string WHERE entry IN (57,58,5009); - -INSERT INTO trinity_string VALUES -(57,'Using World DB: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(58,'Using script library: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(5009,'Sound %u Played to server',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); - - -DELETE FROM `command` WHERE name IN ('pet create','pet learn','pet unlearn','pet tp','gobject activate','playall'); -INSERT INTO `command` (name,security,help) VALUES -('pet create',2,'Syntax: .pet create\r\n\r\nCreates a pet of the selected creature.'), -('pet learn',2,'Syntax: .pet learn\r\n\r\nLearn #spellid to pet.'), -('pet unlearn',2,'Syntax: .pet unlean\r\n\r\nunLearn #spellid to pet.'), -('pet tp',2,'Syntax: .pet tp #\r\n\r\nChange pet\'s amount of training points.'), -('modify gender',2,'Syntax: .modify gender\r\n\r\n.modify gender #male/female - Turns selected player into a male or female'), -('gobject activate',2,'Syntax: .gobject activate #guid\r\n\r\nActivates an object like a door or a button.'), -('playall',2,'Syntax: .playall #soundid\r\n\r\nPlayer a sound to whole server.'); - -DELETE FROM trinity_string WHERE entry IN (1119,1120,1121); - -INSERT INTO trinity_string VALUES -(1119,'You must use male or female as gender.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1120,'You change gender of %s to %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(1121,'Your gender changed to %s by %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); - - -DELETE FROM command WHERE name IN ('modify gender'); - -INSERT INTO command VALUES -('modify gender',2,'Syntax: .modify gender male/female\r\n\r\nChange gender of selected player.'); - - -delete from `command` where `name` IN ('senditems','sendmail'); -insert into `command` (`name`, `security`, `help`) values -('senditems',3,'Syntax: .senditems #playername "#subject" "#text" itemid1[:count1] itemid2[:count2] ... itemidN[:countN]\r\n\r\nSend a mail to a player. Subject and mail text must be in "". If for itemid not provided related count values then expected 1, if count > max items in stack then items will be send in required amount stacks. All stacks amount in mail limited to 12.'), -('sendmail',1,'Syntax: .sendmail #playername "#subject" "#text"\r\n\r\nSend a mail to a player. Subject and mail text must be in "".'); - - -delete from `command` where `name` = 'sendmoney'; -insert into `command` (`name`, `security`, `help`) values -('sendmoney',3,'Syntax: .sendmoney #playername "#subject" "#text" #money\r\n\r\nSend mail with money to a player. Subject and mail text must be in "".'); - - -DELETE FROM trinity_string WHERE entry IN (453); - - -DROP TABLE IF EXISTS `db_script_string`; -CREATE TABLE `db_script_string` ( - `entry` int(11) unsigned NOT NULL default '0', - `content_default` text NOT NULL, - `content_loc1` text, - `content_loc2` text, - `content_loc3` text, - `content_loc4` text, - `content_loc5` text, - `content_loc6` text, - `content_loc7` text, - `content_loc8` text, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - -DELETE FROM `command` WHERE `name` IN ( - 'server exit', - 'server idleshutdown', - 'server idleshutdown cancel', - 'server idlerestart', - 'server idlerestart cancel', - 'server restart', - 'server restart cancel', - 'server shutdown', - 'server shutdown cancel' -); - -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('server exit',4,'Syntax: .server exit\r\n\r\nTerminate mangosd NOW. Exit code 0.'), -('server idleshutdown',3,'Syntax: .server idleshutdown #delay [#exist_code]\r\n\r\nShut the server down after #delay seconds if no active connections are present (no players). Use #exist_code or 0 as program exist code.'), -('server idleshutdown cancel',3,'Syntax: .server idleshutdown cancel\r\n\r\nCancel the restart/shutdown timer if any.'), -('server idlerestart',3,'Syntax: .server idlerestart #delay\r\n\r\nRestart the server after #delay seconds if no active connections are present (no players). Use #exist_code or 2 as program exist code.'), -('server idlerestart cancel',3,'Syntax: .server idlerestart cancel\r\n\r\nCancel the restart/shutdown timer if any.'), -('server restart',3,'Syntax: .server restart #delay\r\n\r\nRestart the server after #delay seconds. Use #exist_code or 2 as program exist code.'), -('server restart cancel',3,'Syntax: .server restart cancel\r\n\r\nCancel the restart/shutdown timer if any.'), -('server shutdown',3,'Syntax: .server shutdown #delay [#exist_code]\r\n\r\nShut the server down after #delay seconds. Use #exist_code or 0 as program exist code.'), -('server shutdown cancel',3,'Syntax: .server shutdown cancel\r\n\r\nCancel the restart/shutdown timer if any.'); - -DELETE FROM trinity_string WHERE entry IN (251); -INSERT INTO trinity_string VALUES -(251,'Text%d (ID: %i): %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); - -DELETE FROM `trinity_string` WHERE `entry` BETWEEN 770 AND 787; -INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`) VALUES -(770,'Your group has members not in your arena team. Please regroup to join.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(771,'Your group does not have enough players to join this match.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(772,'The Gold Team wins!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(773,'The Green Team wins!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(774,'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(775,'Your group has an offline member. Please remove him before joining.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(776,'Your group has players from the opposing faction. You can\'t join the battleground as a group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(777,'Your group has players from different battleground brakets. You can\'t join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(778,'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(779,'Someone in your party is Deserter. You can\'t join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(780,'Someone in your party is already in three battleground queues. You cannot join as group.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(781,'You cannot teleport to a battleground or arena map.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(782,'You cannot summon players to a battleground or arena map.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(783,'You must be in GM mode to teleport to a player in a battleground.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(784,'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(785,'Arena testing turned %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(786,'|cffff0000[Automatic]:|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(787,'|cffffff00[|c1f40af20Announce by|r |cffff0000%s|cffffff00]:|r %s|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file diff --git a/sql/updates/full/world_script.sql b/sql/updates/full/world_script.sql deleted file mode 100644 index 278ed085a65..00000000000 --- a/sql/updates/full/world_script.sql +++ /dev/null @@ -1,93 +0,0 @@ -UPDATE `creature_template` SET `ScriptName` = 'boss_nalorakk' WHERE `entry` = 23576; -UPDATE `creature_template` set `ScriptName` = 'boss_akilzon' where entry = 23574; -UPDATE `creature_template` set `ScriptName` = 'mob_akilzon_eagle' where `entry`=24858; /*default is event ai*/ -UPDATE `creature_template` SET `ScriptName` = 'boss_halazzi' WHERE `entry` = '23577'; -UPDATE `creature_template` SET `ScriptName` = 'mob_halazzi_lynx' WHERE `entry` = '24143'; -UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = '24224'; /*totem default `spell1` = '43301' should be in DB*/ -UPDATE `creature_template` SET `ScriptName` = 'boss_janalai' WHERE `entry` = '23578'; -UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_hatcher' WHERE `entry` = '23818'; -UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_hatchling' WHERE `entry` = '23598'; -UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_egg' WHERE `entry` = '23817'; -UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_firebomb' WHERE `entry` = '23920'; -UPDATE `creature_template` SET `ScriptName` = 'boss_hexlord_malacrass' WHERE `entry` =24239; -UPDATE `creature_template` SET `ScriptName` = 'boss_alyson_antille' WHERE `entry` =24240; -UPDATE `creature_template` SET `ScriptName` = 'boss_thurg' WHERE `entry` =24241; -UPDATE `creature_template` SET `ScriptName` = 'boss_slither' WHERE `entry` =24242; -UPDATE `creature_template` SET `ScriptName` = 'boss_lord_raadan' WHERE `entry` =24243; -UPDATE `creature_template` SET `ScriptName` = 'boss_gazakroth' WHERE `entry` =24244; -UPDATE `creature_template` SET `ScriptName` = 'boss_fenstalker' WHERE `entry` =24245; -UPDATE `creature_template` SET `ScriptName` = 'boss_darkheart' WHERE `entry` =24246; -UPDATE `creature_template` SET `ScriptName` = 'boss_koragg' WHERE `entry` =24247; -UPDATE `creature_template` SET `ScriptName` = 'boss_zuljin' WHERE `entry` =23863; -UPDATE `creature_template` SET `ScriptName` = 'mob_zuljin_vortex' WHERE `entry` = '24136'; -UPDATE `creature_template` SET `ScriptName` = 'npc_zulaman_hostage' WHERE `entry` IN (23790, 23999, 24024, 24001); - --- sunwell -update instance_template set script = 'instance_sunwell_plateau' where map = 580; -UPDATE creature_template SET scriptname = 'boss_kalecgos' WHERE entry = 24850; -UPDATE creature_template SET scriptname = 'boss_sathrovarr' WHERE entry = 24892; -UPDATE creature_template SET scriptname = 'boss_kalec' WHERE entry = 24891; -UPDATE gameobject_template SET scriptname = 'kalocegos_teleporter' WHERE entry = 187055; -UPDATE creature_template SET ScriptName = 'boss_brutallus' WHERE entry = 24882; -UPDATE `creature_template` SET `ScriptName` = 'boss_felmyst' WHERE `entry` = 25038; -UPDATE `creature_template` SET `ScriptName` = 'mob_felmyst_vapor' WHERE `entry` = 25265; -UPDATE `creature_template` SET `ScriptName` = 'mob_felmyst_trail' WHERE `entry` = 25267; -update creature_template set scriptname = 'boss_sacrolash' where entry = 25165; -update creature_template set scriptname = 'boss_alythess' where entry = 25166; -update creature_template set scriptname = 'mob_shadow_image' where entry = 25214; - -UPDATE instance_template SET script="instance_uldaman" where map = 70; -UPDATE creature_template SET ScriptName="boss_archaedas" where entry = 2748; -UPDATE creature_template SET ScriptName="mob_archaedas_minions" where entry in ('7309', '7077', '7076', '10120'); -UPDATE creature_template SET ScriptName="mob_stonekeepers" where entry = 4857; -UPDATE gameobject_template set scriptName="go_altar_of_the_keepers" where entry = 130511; -UPDATE gameobject_template set scriptName="go_altar_of_archaedas" where entry = 133234; - -update creature_template SET scriptname='npc_overlord_morghor' WHERE entry=23139; -update creature_template SET scriptname='npc_lord_illidan_stormrage' WHERE entry=22083; -update creature_template SET scriptname='npc_yarzill_the_merc' WHERE entry=23141; - -UPDATE creature_template SET ScriptName = 'mob_toxic_sporebat' WHERE entry = '22140'; -UPDATE creature_template SET ScriptName = 'boss_leotheras_the_blind' WHERE entry = '21215'; -UPDATE creature_template SET ScriptName = 'boss_leotheras_the_blind_demonform' WHERE entry = '21875'; -UPDATE creature_template SET ScriptName = 'mob_greyheart_spellbinder' WHERE entry = '21806'; -UPDATE creature_template SET ScriptName = 'mob_inner_demon' WHERE entry = '21857'; -UPDATE creature_template SET ScriptName = 'boss_the_lurker_below' WHERE entry = '21217'; -UPDATE creature_template SET ScriptName = 'mob_coilfang_ambusher' WHERE entry = '21865'; -UPDATE creature_template SET ScriptName = 'mob_coilfang_guardian' WHERE entry = '21873'; - -update gameobject_template set scriptname = 'go_najentus_spine' where entry = 185584; -update creature_template set scriptname = 'mob_blade_of_azzinoth' where entry = 22996; -update creature_template set scriptname = 'mob_parasitic_shadowfiend' where entry = 23498; - -update `creature_template` set `ScriptName`='boss_alar' where `entry`='19514'; -update `creature_template` set `ScriptName`='mob_ember_of_alar' where `entry`='19551'; -update `creature_template` set `ScriptName`='mob_flame_patch_alar' where `entry`='20602'; -update gameobject_template set scriptname = "go_manticron_cube" where entry = 181713; -update creature_template set scriptname = "mob_abyssal" where entry = 17454; - -update creature_template set scriptname = 'boss_warchief_kargath_bladefist' where entry = 16808; -UPDATE `instance_template` SET `script`='instance_deadmines' WHERE map = 36; -UPDATE `item_template` SET `ScriptName`='item_defias_gunpowder' WHERE entry = 5397; - -UPDATE `creature_template` SET `ScriptName` = 'npc_twiggy_flathead' WHERE `entry` =6248; -UPDATE `item_template` SET `ScriptName`='item_arcane_charges' WHERE `entry`='34475'; -UPDATE `gameobject_template` SET `ScriptName` = 'go_kael_orb' WHERE `entry` = 188173; -UPDATE `gameobject_template` SET `ScriptName` = 'go_movie_orb' WHERE `entry` = 187578; -UPDATE `creature_template` SET `ScriptName`='npc_defias_traitor' WHERE `entry`='467'; -UPDATE `creature_template` SET `ScriptName`='npc_clintar_dreamwalker' WHERE `entry`=22834; -UPDATE `creature_template` SET `ScriptName`='npc_clintar_spirit' WHERE `entry` = 22916; -UPDATE `creature_template` SET `ScriptName`='mob_sparrowhawk' WHERE `entry`=22979; -UPDATE `creature_template` SET `ScriptName`='mob_rizzle_sprysprocket' WHERE `entry`=23002; -UPDATE `creature_template` SET `ScriptName`='mob_depth_charge' WHERE `entry`=23025; -UPDATE `creature_template` SET `ScriptName`='boss_pathaleon_the_calculator' WHERE `entry`=19220; -UPDATE `creature_template` SET `ScriptName`='mob_nether_wraith' WHERE `entry`=21062; -UPDATE `instance_template` SET `script`='instance_mechanar' WHERE `map`=554; -UPDATE `creature_template` SET `ScriptName`='npc_wounded_blood_elf' WHERE `entry`='16993'; -UPDATE `creature_template` SET `ScriptName` = 'mob_phase_hunter' WHERE `entry` = '18879'; - --- quest -update gameobject_template set scriptname = 'go_gilded_brazier' where entry = 181956; -update creature_template set scriptname = 'npc_second_trial_paladin' where entry in (17809,17810,17811,17812); -update creature_template set scriptname = 'npc_second_trial_controller' where entry in (17807); -update gameobject_template set scriptname = 'go_second_trial' where entry in (182052);
\ No newline at end of file diff --git a/sql/updates/full/world_script_text.sql b/sql/updates/full/world_script_text.sql deleted file mode 100644 index c3387110608..00000000000 --- a/sql/updates/full/world_script_text.sql +++ /dev/null @@ -1,7 +0,0 @@ -delete from `script_texts` where entry between -1645009 and -1645006; -INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `comment`) VALUES -(-1645006,'Let the trial begin, Bloodwrath, attack!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'), -(-1645007,'Champion Lightrend, make me proud!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'), -(-1645008,'Show this upstart how a real Blood Knight fights, Swiftblade!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'), -(-1645009,'Show $N the meaning of pain, Sunstriker!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,'master_kelerun_bloodmourn YELL_PHASE'); - diff --git a/sql/updates/full/world_spawn.sql b/sql/updates/full/world_spawn.sql deleted file mode 100644 index f5d30e5c48d..00000000000 --- a/sql/updates/full/world_spawn.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature` SET `position_x` = '117.8827',`position_y` = '921.2795',`position_z` = '33.8883',`orientation` = '1.5696' WHERE `id` = '24239' LIMIT 1;
\ No newline at end of file diff --git a/sql/updates/full/world_spell.sql b/sql/updates/full/world_spell.sql deleted file mode 100644 index e9b1a092c90..00000000000 --- a/sql/updates/full/world_spell.sql +++ /dev/null @@ -1,170 +0,0 @@ -DROP TABLE IF EXISTS `spell_linked_spell`; -CREATE TABLE `spell_linked_spell` ( - `spell_trigger` int(10) NOT NULL, - `spell_effect` int(10) NOT NULL default '0', - `type` smallint(3) unsigned NOT NULL default '0', - `comment` text NOT NULL, - PRIMARY KEY (`spell_trigger`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -ALTER TABLE `spell_linked_spell` DROP PRIMARY KEY; - -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (44008, 45265, 1, 'Static Disruption Visual'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES (-30410, 44032, 0, 'Manticron Cube Mind Exhaustion'); - --- class -delete from `spell_linked_spell` where `spell_trigger` in ('15237','15430','15431','27799','27800','27801','25331'); -insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('15237','23455','0','Holy Nova (rank1)'); -insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('15430','23458','0','Holy Nova (rank2)'); -insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('15431','23459','0','Holy Nova (rank3)'); -insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('27799','27803','0','Holy Nova (rank4)'); -insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('27800','27804','0','Holy Nova (rank5)'); -insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('27801','27805','0','Holy Nova (rank6)'); -insert into `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) values('25331','25329','0','Holy Nova (rank7)'); -DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (-19386, -24132, -24133, -27068, -49011, -49012); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-19386, 24131, 0, 'Wyvern Sting'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-24132, 24134, 0, 'Wyvern Sting'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-24133, 24135, 0, 'Wyvern Sting'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-27068, 27069, 0, 'Wyvern Sting'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49011, 49009, 0, 'Wyvern Sting'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49012, 49010, 0, 'Wyvern Sting'); - --- black temple -DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (39992, 39835, 42052, -41914, -41917, 41126, -41376, 39908); --- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39992, 39835, 1, 'Needle Spine'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39835, 39968, 1, 'Needle Spine'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41376, 41377, 0, 'Spite'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (41126, 41131, 1, 'Flame Crash'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41914, 41915, 0, 'Summon Parasitic Shadowfiend'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41917, 41915, 0, 'Summon Parasitic Shadowfiend'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39908, 40017, 1, 'Eye Blast'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (40604, 40616, 1, 'Fel Rage Aura'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (40616, 41625, 1, 'Fel Rage Aura'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (41292, 42017, 1, 'Aura of Suffering'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41292, -42017, 0, 'Aura of Suffering'); - --- sunwell -DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (44869, 46648, 46019, 46021, -46021, 46020); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (44869, 44866, 1, 'Spectral Blast Portal'); --- 46648 will cause severe lag seems should be casted by go --- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (44869, 46648, 1, 'Spectral Blast Visual'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (44869, 46019, 1, 'Spectral Blast Teleport'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46019, 46021, 1, 'Spectral Realm Aura'); --- 44852 makes boss friendly to you, weird --- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46021, 44852, 1, 'Spectral Realm Aura'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-46021, 46020, 0, 'Teleport: Normal Realm'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46020, 44867, 1, 'Spectral Exhaustion'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45661, 45665, 1, 'Encapsulate'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45347, -45348, 1, 'Remove Flame Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45348, -45347, 1, 'Remove Dark Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45248, 45347, 1, 'Apply Dark Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45329, 45347, 1, 'Apply Dark Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45256, 45347, 1, 'Apply Dark Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45270, 45347, 1, 'Apply Dark Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45342, 45348, 1, 'Apply Flame Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46771, 45348, 1, 'Apply Flame Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45271, 45347, 1, 'Apply Dark Touched'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (45246, 45348, 1, 'Apply Flame Touched'); - --- zulaman -DELETE FROM `spell_proc_event` WHERE `entry` = 43983; -INSERT INTO `spell_proc_event` VALUES ('43983', '0', '0', '0', '0', '0', '16384', '0', '0'); -DELETE FROM `spell_script_target` WHERE `entry` = 42577; -INSERT INTO `spell_script_target` VALUES ('42577', '1', '24136'); - --- sunwell -DELETE FROM `spell_script_target` WHERE `entry` in (44885,45388,45389,46350,45714); -INSERT INTO `spell_script_target` VALUES ('45388', '1', '25038'); -INSERT INTO `spell_script_target` VALUES ('45389', '1', '25265'); -INSERT INTO `spell_script_target` VALUES ('44885', '1', '25160'); -INSERT INTO `spell_script_target` VALUES ('46350', '1', '25160'); -INSERT INTO `spell_script_target` VALUES ('45714', '1', '25038'); - --- Magtheridon Earthquake -DELETE FROM spell_script_target WHERE `entry` IN (30657); -INSERT INTO spell_script_target VALUES ('30657', '1', '24136'); - -DELETE FROM `spell_script_target` WHERE `entry` in (30531,41455,42471,43734,42631); -INSERT INTO `spell_script_target` VALUES ('30531', '1', '17256'); -INSERT INTO `spell_script_target` VALUES ('41455', '1', '22949'); -INSERT INTO `spell_script_target` VALUES ('41455', '1', '22950'); -INSERT INTO `spell_script_target` VALUES ('41455', '1', '22951'); -INSERT INTO `spell_script_target` VALUES ('41455', '1', '22952'); -INSERT INTO `spell_script_target` VALUES ('42471', '1', '23817'); -INSERT INTO `spell_script_target` VALUES ('43734', '1', '23817'); -INSERT INTO `spell_script_target` VALUES ('42631', '1', '23920'); - -DELETE FROM spell_script_target WHERE `entry` IN (44320, 44321); -INSERT INTO spell_script_target () VALUES (44320, 1, 24723); -INSERT INTO spell_script_target () VALUES (44321, 1, 24723); - -DELETE FROM `spell_script_target` WHERE `entry` in (30659); -INSERT INTO `spell_script_target` VALUES (30659, 1, 17281); - -DELETE FROM `spell_script_target` WHERE `entry` IN (34186, 42492, 33831, 5628, 45109, 45149); -INSERT INTO `spell_script_target` VALUES (34186, 1, 16938); -INSERT INTO `spell_script_target` VALUES (42492, 1, 0); -INSERT INTO `spell_script_target` VALUES (33831, 1, 0); -INSERT INTO `spell_script_target` VALUES (5628, 1, 2011); -INSERT INTO `spell_script_target` VALUES (5628, 1, 2012); -INSERT INTO `spell_script_target` VALUES (5628, 1, 2013); -INSERT INTO `spell_script_target` VALUES (5628, 1, 2014); -INSERT INTO `spell_script_target` VALUES (45109, 1, 25084); -INSERT INTO `spell_script_target` VALUES (45149, 0, 300154); - - - - --- target position -DELETE FROM spell_target_position WHERE `id` IN (46019, 46020); -INSERT INTO spell_target_position () VALUES (46019, 580, 1704.34, 928.17, -74.558, 0); -INSERT INTO spell_target_position () VALUES (46020, 580, 1704.34, 928.17, 53.079, 0); - - --- creature trigger spell --- molten_flame -UPDATE creature_template SET spell1 = 40980, flags_extra = 128, speed = 1.0, scriptname = 'molten_flame' WHERE entry = 23095; --- volcano -UPDATE creature_template SET spell1 = 40117, flags_extra = 128, scriptname = '' WHERE entry = 23085; --- flame crash -update creature_template set spell1 = 40836, flags_extra = 128, scriptname = '' where entry = 23336; --- blaze -update creature_template set spell1 = 40610, flags_extra = 128, scriptname = '' where entry = 23259; - - --- proc event -UPDATE `spell_proc_event` SET `procFlags` = '8396800' WHERE `entry` =14774; -UPDATE `spell_proc_event` SET `procFlags` = '8396800' WHERE `entry` =14531; -UPDATE `spell_proc_event` SET `SchoolMask` = '1' WHERE `entry` = '41434'; - -DELETE FROM spell_proc_event where entry = 42083; -INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -(42083,0,0,0,0,0x0000000000000000,0x00401000,0,45); - -DELETE FROM `spell_elixir` WHERE `entry` = 45373; -INSERT INTO `spell_elixir` VALUES (45373,0x1); - -DELETE FROM spell_affect WHERE entry IN (30017,30280,44373) AND effectId = 0; -INSERT INTO spell_affect (entry, effectId, SpellFamilyMask) VALUES -(30017,0,0x0000000000000000), -(30280,0,0x0000000000000000), -(44373,0,0x0000000000000000); - -DELETE FROM spell_affect WHERE entry IN (34520,37508) AND effectId = 1; -INSERT INTO spell_affect (entry, effectId, SpellFamilyMask) VALUES -(34520,1,0x0000000000000000), -(37508,1,0x0000000000000000); - -DELETE FROM spell_proc_event WHERE entry IN (34139,42368,43726,46092); -INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -(34139,0,0,0,10,0x0000000040000000,0x08000000,0,0), -(42368,0,0,0,10,0x0000000040000000,0x08000000,0,0), -(43726,0,0,0,10,0x0000000040000000,0x08000000,0,0), -(46092,0,0,0,10,0x0000000040000000,0x08000000,0,0); - -DELETE FROM spell_proc_event where entry IN (34598, 34584, 36488); -INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES -(34598,0,0,0,0,0x0000000000000000,0x00020000,0,45), -(36488,0,0,0,0,0x0000000000000000,0x08000000,0,0), -(34584,0,0,0,0,0x0000000000000000,0x00004000,0,30);
\ No newline at end of file diff --git a/sql/updates/full/world_template.sql b/sql/updates/full/world_template.sql deleted file mode 100644 index 147b4c650e2..00000000000 --- a/sql/updates/full/world_template.sql +++ /dev/null @@ -1,129 +0,0 @@ --- zulaman -UPDATE `creature_template` SET `flags_extra` = 33 WHERE `entry` = 23576; /*zam bear boss no crush blow*/ -UPDATE `creature_template` SET `faction_A` = '1890', `faction_H` = '1890' WHERE `entry` in ('24240', '24241', '24242', '24243', '24244', '24245', '24246', '24247'); -UPDATE `creature_template` SET `minlevel` = '73', `maxlevel` = '73' WHERE `entry` IN (24187, 24136); - --- sunwell -REPLACE INTO `gameobject_template` VALUES (187366, 6, 4251, 'Blaze', '', 14, 0, 1, 0, 73, 2, 45246, 0, 1, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); -UPDATE creature_template SET faction_H = 14, faction_A = 14, minlevel = 73, maxlevel = 73,rank = 3, flags = 33554434, flag1 = 0 WHERE entry = 25214; -UPDATE `creature_template` SET `minlevel` = '70', `maxlevel` = '70',`faction_A` = '14', `faction_H` = '14' WHERE `entry` in (25265,25267,25268); -UPDATE `creature_template` SET `mindmg` = '1500', `maxdmg` = '2500', `minhealth` = '40000', `maxhealth` = '40000', `baseattacktime` = '2000' WHERE `entry` = 25268; -UPDATE creature_template SET minhealth = 2018275, maxhealth = minhealth = 2018275 WHERE entry = 24892; -UPDATE creature_template SET minlevel = 73, maxlevel = 73, minhealth = 828555, maxhealth = 828555, armor = 5000, mindmg = 1000, maxdmg = 2000 WHERE entry = 24891; -INSERT INTO creature_template_addon (entry) SELECT 24891 FROM creature_template_addon WHERE NOT EXISTS(SELECT * FROM creature_template_addon WHERE entry = 24891) LIMIT 1; -INSERT INTO creature_template_addon (entry) SELECT 24892 FROM creature_template_addon WHERE NOT EXISTS(SELECT * FROM creature_template_addon WHERE entry = 24892) LIMIT 1; -UPDATE creature_template_addon SET auras = '45769 0 45769 1' WHERE entry = 24850; -UPDATE creature_template_addon SET auras = '45769 0 45769 1 44801 0 44801 1 44801 2' WHERE entry = 24891; -UPDATE creature_template_addon SET auras = '45769 0 45769 1 44801 0 44801 1 44801 2 44800 0' WHERE entry = 24892; - --- black temple -update creature_template set minlevel = 73, maxlevel = 73, minhealth = 500000, maxhealth = 500000, mindmg = 3000, maxdmg = 4000 where entry = 23197; - -UPDATE `creature_template` SET`minlevel` = '60',`maxlevel` = '60',`minhealth` = '6900',`maxhealth` = '7200',`minmana` = '9476',`maxmana` = '9736',`armor` = '4000',speed` = '1.7',`rank` = '1',`mindmg` = '600',`maxdmg` = '1500',`attackpower` = '1200',`family` = '16',`minrangedmg` = '0',`maxrangedmg` = '0',`rangedattackpower` = '0',`resistance1` = '15',`resistance2` = '15',`resistance3` = '15',`resistance4` = '15',`resistance5` = '15',`resistance6` = '15',`ScriptName` = 'npc_kservant' WHERE `entry` = '19685'; -DELETE FROM `quest_start_scripts` WHERE `id`='10211'; -UPDATE `quest_template` SET `StartScript`='0' WHERE entry=10211; -UPDATE gameobject_template SET faction = 14 WHERE entry = 185134; - -update quest_template SET StartScript=0 WHERE entry=11108; - -DELETE FROM gameobject_template WHERE `entry` IN (187578, 188173); -INSERT INTO gameobject_template () VALUES (187578, 10, 4891, 'Scrying Orb', '', 0, 0, 2.16851, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'go_movie_orb'); -INSERT INTO gameobject_template () VALUES (188173, 10, 7161, 'Escape to the Isle of Quel\'Danas', '', 0, 0, 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, 'go_kael_orb'); - -UPDATE creature_template SET modelid_A = '17612', modelid_H = '17612' WHERE entry = '24745'; -UPDATE `creature_template` SET `minhealth` = '6900', `maxhealth` = '6900' WHERE `entry` = 24675; -UPDATE `creature_template` SET `minlevel` = '70', `maxlevel` = '70' WHERE `entry` = 24708; -UPDATE `creature_template` SET `minlevel` = '70', maxlevel` = '70' WHERE `entry` = 24666; -UPDATE `creature_template` SET `scale` = '0.5' WHERE `entry` = 24708; -update creature_template SET spell1=6474 WHERE entry=22487; -update creature_template SET spell1=3600 WHERE entry=22486; - -update creature_template set flags_extra = 128 where entry = 12999; - --- serpent -UPDATE creature_template SET modelid_A = '11686', modelid_H = '11686', flags_extra = '128' WHERE entry = '22207'; -UPDATE creature_model_info SET bounding_radius = '13', combat_reach = '20' WHERE modelid = '20216'; -UPDATE creature_template SET InhabitType = '3' WHERE entry = '21217'; - --- SELECT `gameobject_template` WHERE `entry` IN (186648, 187021, 186672, 186667); -DELETE FROM `gameobject_loot_template` WHERE `entry` IN (22699, 22790, 22797, 22968); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33480, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33481, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33483, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33489, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33590, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33591, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33805, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33971, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33490, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33491, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33492, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33493, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33494, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33495, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33496, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33497, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33498, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33499, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33500, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33809, 100, 0, 13, 7, 4); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33480, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33481, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33483, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33489, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33590, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33591, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33805, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33971, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33490, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33491, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33492, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33493, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33494, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33495, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33496, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33497, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33498, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33499, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33500, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33809, 100, 0, 13, 7, 4); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33480, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33481, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33483, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33489, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33590, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33591, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33805, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33971, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33490, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33491, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33492, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33493, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33494, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33495, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33496, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33497, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33498, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33499, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33500, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33809, 100, 0, 13, 7, 4); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33480, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33481, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33483, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33489, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33590, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33591, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33805, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33971, 0, 1, 13, 7, 1); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33490, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33491, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33492, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33493, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33494, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33495, 0, 1, 13, 7, 2); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33496, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33497, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33498, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33499, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33500, 0, 1, 13, 7, 3); -INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33809, 100, 0, 13, 7, 4); |