diff options
Diffstat (limited to 'sql')
20 files changed, 813 insertions, 16 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index c7e1372e9a1..6e3ab43e4ac 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2379,6 +2379,66 @@ LOCK TABLES `pool_quest_save` WRITE; UNLOCK TABLES; -- +-- Table structure for table `pvpstats_battlegrounds` +-- + +DROP TABLE IF EXISTS `pvpstats_battlegrounds`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pvpstats_battlegrounds` ( + `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, + `winner_faction` tinyint(4) NOT NULL, + `bracket_id` tinyint(3) unsigned NOT NULL, + `type` tinyint(3) unsigned NOT NULL, + `date` datetime NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `pvpstats_battlegrounds` +-- + +LOCK TABLES `pvpstats_battlegrounds` WRITE; +/*!40000 ALTER TABLE `pvpstats_battlegrounds` DISABLE KEYS */; +/*!40000 ALTER TABLE `pvpstats_battlegrounds` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `pvpstats_players` +-- + +DROP TABLE IF EXISTS `pvpstats_players`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pvpstats_players` ( + `battleground_id` bigint(20) unsigned NOT NULL, + `character_guid` int(10) unsigned NOT NULL, + `score_killing_blows` mediumint(8) unsigned NOT NULL, + `score_deaths` mediumint(8) unsigned NOT NULL, + `score_honorable_kills` mediumint(8) unsigned NOT NULL, + `score_bonus_honor` mediumint(8) unsigned NOT NULL, + `score_damage_done` mediumint(8) unsigned NOT NULL, + `score_healing_done` mediumint(8) unsigned NOT NULL, + `attr_1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `attr_2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `attr_3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `attr_4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `attr_5` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`battleground_id`,`character_guid`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `pvpstats_players` +-- + +LOCK TABLES `pvpstats_players` WRITE; +/*!40000 ALTER TABLE `pvpstats_players` DISABLE KEYS */; +/*!40000 ALTER TABLE `pvpstats_players` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `reserved_name` -- @@ -2457,4 +2517,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2014-01-26 14:39:20 +-- Dump completed on 2014-08-28 15:30:47 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 633b59e0556..3224b5b73a7 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -519,13 +519,11 @@ CREATE TABLE `creature_template` ( `speed_run` float NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value', `scale` float NOT NULL DEFAULT '1', `rank` tinyint(3) unsigned NOT NULL DEFAULT '0', - `mindmg` float NOT NULL DEFAULT '0', - `maxdmg` float NOT NULL DEFAULT '0', `dmgschool` tinyint(4) NOT NULL DEFAULT '0', - `attackpower` int(10) unsigned NOT NULL DEFAULT '0', - `dmg_multiplier` float NOT NULL DEFAULT '1', - `baseattacktime` int(10) unsigned NOT NULL DEFAULT '0', - `rangeattacktime` int(10) unsigned NOT NULL DEFAULT '0', + `BaseAttackTime` int(10) unsigned NOT NULL DEFAULT '0', + `RangeAttackTime` int(10) unsigned NOT NULL DEFAULT '0', + `BaseVariance` float NOT NULL DEFAULT '1', + `RangeVariance` float NOT NULL DEFAULT '1', `unit_class` tinyint(3) unsigned NOT NULL DEFAULT '0', `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', `unit_flags2` int(10) unsigned NOT NULL DEFAULT '0', @@ -535,9 +533,6 @@ CREATE TABLE `creature_template` ( `trainer_spell` mediumint(8) unsigned NOT NULL DEFAULT '0', `trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0', `trainer_race` tinyint(3) unsigned NOT NULL DEFAULT '0', - `minrangedmg` float NOT NULL DEFAULT '0', - `maxrangedmg` float NOT NULL DEFAULT '0', - `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `type_flags` int(10) unsigned NOT NULL DEFAULT '0', `lootid` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -565,9 +560,11 @@ CREATE TABLE `creature_template` ( `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3', `HoverHeight` float NOT NULL DEFAULT '1', - `Health_mod` float NOT NULL DEFAULT '1', - `Mana_mod` float NOT NULL DEFAULT '1', - `Armor_mod` float NOT NULL DEFAULT '1', + `HealthModifier` float NOT NULL DEFAULT '1', + `ManaModifier` float NOT NULL DEFAULT '1', + `ArmorModifier` float NOT NULL DEFAULT '1', + `DamageModifier` float NOT NULL DEFAULT '1', + `ExperienceModifier` float NOT NULL DEFAULT '1', `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0', `questItem1` int(10) unsigned NOT NULL DEFAULT '0', `questItem2` int(10) unsigned NOT NULL DEFAULT '0', @@ -2510,7 +2507,7 @@ CREATE TABLE `playercreateinfo_skills` ( `rank` smallint(5) unsigned NOT NULL DEFAULT '0', `comment` varchar(255) DEFAULT NULL, PRIMARY KEY (`raceMask`,`classMask`,`skill`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3597,7 +3594,7 @@ CREATE TABLE `waypoint_data` ( `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `delay` int(10) unsigned NOT NULL DEFAULT '0', - `move_flag` tinyint(4) NOT NULL DEFAULT '0', + `move_type` int(11) NOT NULL DEFAULT '0', `action` int(11) NOT NULL DEFAULT '0', `action_chance` smallint(6) NOT NULL DEFAULT '100', `wpguid` int(11) NOT NULL DEFAULT '0', @@ -3659,4 +3656,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2014-07-28 22:43:25 +-- Dump completed on 2014-08-27 14:06:19 diff --git a/sql/updates/auth/2014_08_24_00_auth_rbac_ahbot.sql b/sql/updates/auth/2014_08_28_00_auth_rbac_ahbot.sql index 7de587dc19f..7de587dc19f 100644 --- a/sql/updates/auth/2014_08_24_00_auth_rbac_ahbot.sql +++ b/sql/updates/auth/2014_08_28_00_auth_rbac_ahbot.sql diff --git a/sql/updates/characters/2014_08_28_00_characters_pvpstats.sql b/sql/updates/characters/2014_08_28_00_characters_pvpstats.sql new file mode 100644 index 00000000000..0e3c239f8e6 --- /dev/null +++ b/sql/updates/characters/2014_08_28_00_characters_pvpstats.sql @@ -0,0 +1,28 @@ +DROP TABLE IF EXISTS `pvpstats_battlegrounds`; +CREATE TABLE `pvpstats_battlegrounds` ( + `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, + `winner_faction` TINYINT NOT NULL, + `bracket_id` TINYINT UNSIGNED NOT NULL, + `type` TINYINT UNSIGNED NOT NULL, + `date` DATETIME NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB; + +DROP TABLE IF EXISTS `pvpstats_players`; +CREATE TABLE `pvpstats_players` ( + `battleground_id` BIGINT UNSIGNED NOT NULL, + `character_guid` INT UNSIGNED NOT NULL, + `score_killing_blows` MEDIUMINT UNSIGNED NOT NULL, + `score_deaths` MEDIUMINT UNSIGNED NOT NULL, + `score_honorable_kills` MEDIUMINT UNSIGNED NOT NULL, + `score_bonus_honor` MEDIUMINT UNSIGNED NOT NULL, + `score_damage_done` MEDIUMINT UNSIGNED NOT NULL, + `score_healing_done` MEDIUMINT UNSIGNED NOT NULL, + `attr_1` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0, + `attr_2` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0, + `attr_3` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0, + `attr_4` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0, + `attr_5` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0, + PRIMARY KEY (`battleground_id`, `character_guid`) +) ENGINE=InnoDB; + diff --git a/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql b/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql new file mode 100644 index 00000000000..494d324fc0e --- /dev/null +++ b/sql/updates/world/2014_08_25_00_world_item_enchantment_template.sql @@ -0,0 +1,40 @@ +DELETE FROM `item_enchantment_template` WHERE `entry` IN (161,162,163,381,382,383,384,385); +INSERT INTO `item_enchantment_template` (`entry`, `ench`, `chance`) VALUES +(161, 79, 51.35), +(161, 83, 48.65), +(162, 80, 48.65), +(162, 83, 51.35), +(163, 80, 44.6), +(163, 83, 55.4), +(381, 68, 8.1), +(381, 71, 14.5), +(381, 72, 7.7), +(381, 73, 7.3), +(381, 75, 7.7), +(381, 78, 14.9), +(381, 79, 8.8), +(381, 83, 14.3), +(381, 84, 8.2), +(381, 85, 8.5), +(382, 69, 18.7), +(382, 79, 12.5), +(382, 82, 18.8), +(382, 83, 17.4), +(382, 84, 12.8), +(382, 85, 19.8), +(383, 71, 35.5), +(383, 78, 11.5), +(383, 79, 11), +(383, 80, 26.3), +(383, 82, 15.7), +(384, 71, 28.8), +(384, 78, 24.1), +(384, 80, 22.9), +(384, 83, 13.6), +(384, 85, 10.6), +(385, 17, 13.2), +(385, 68, 22.4), +(385, 75, 17.6), +(385, 84, 12.7), +(385, 85, 10.2), +(385, 86, 23.9); diff --git a/sql/updates/world/2014_08_25_01_world_sai.sql b/sql/updates/world/2014_08_25_01_world_sai.sql new file mode 100644 index 00000000000..493a5dbed4b --- /dev/null +++ b/sql/updates/world/2014_08_25_01_world_sai.sql @@ -0,0 +1,180 @@ + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(28244,28333,28175,28176,28177,28178,28284); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28244,28333,28175,28176,28177,28178,28284) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(2824400,2817500,2817600,2817700,2817800,2833300,2828400,2828401,2878000) AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(28284, 0, 0, 0, 20, 0, 100, 0, 12553, 0, 0, 0, 80, 2828400, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - On Quest Reward (Skimmer Spinnerets) - Run Script 1'), +(28284, 0, 1, 0, 20, 0, 100, 0, 12583, 0, 0, 0, 80, 2828401, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - On Quest Reward (Crashed Sprayer) - Run Script 2'), +(28244, 0, 0, 1, 20, 0, 100, 0, 12584, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Quest Reward (Pure Evil) - Say Line 7 on Avenger Metz'), +(28244, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 28244, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Quest Reward (Pure Evil) - Start WP'), +(28244, 0, 2, 3, 40, 0, 100, 0, 1, 28244, 0, 0, 80, 2824400, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Reached WP2 - Run Script'), +(28244, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 54, 3000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Reached WP2 - Pause WP'), +(28244, 0, 4, 0, 40, 0, 100, 0, 3, 28244, 0, 0, 54, 100000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - On Reached WP3 - Pause WP'), +(28244, 0, 5, 0, 40, 0, 100, 0, 4, 28244, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1.56042, 'Eitrigg - On Reached WP4 - Set Orientation'), +(28175, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 28244, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Data Set 1 1 - Set Orientation'), +(28175, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Data Set 1 1 - Say Line 1'), +(28175, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 28175, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Data Set 1 1 - Start WP'), +(28175, 0, 3, 0, 40, 0, 100, 0, 1, 28175, 0, 0, 80, 2817500, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Reached WP4 - Run Script'), +(28175, 0, 4, 0, 40, 0, 100, 0, 1, 28175, 0, 0, 54, 18000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - On Reached WP3 - Pause WP'), +(28175, 0, 5, 0, 40, 0, 100, 0, 5, 28175, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1.54325, 'Crusade Commander Korfax - On Reached WP5 - Set Orientation'), +(28176, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 2817600, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rimblat Earthshatter - On Data Set - Run Script'), +(28177, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 2817700, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rayne - On Data Set - Run Script'), +(28178, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 2817800, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Avenger Metz - On Data Set - Run Script'), +(28333, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 11, 32567, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 1 1 - Cast Green Banish State'), +(28333, 0, 1, 0, 38, 0, 100, 0, 2, 2, 0, 0, 28, 32567, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 2 2 - Remove Green Banish State'), +(28333, 0, 2, 0, 38, 0, 100, 0, 3, 3, 0, 0, 11, 51367, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 3 3 - Cast Pure Evil: Entangling Roots Visual'), +(28333, 0, 3, 4, 38, 0, 100, 0, 4, 4, 0, 0, 28, 51367, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 4 4 - Remove Pure Evil: Entangling Roots Visual'), +(28333, 0, 4, 0, 61, 0, 100, 0, 4, 4, 0, 0, 11, 35487, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 4 4 - Cast Seed of Revitalization Lightning Cloud Visual'), +(28333, 0, 5, 0, 38, 0, 100, 0, 5, 5, 0, 0, 80, 2833300, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - On Data Set 5 5 - Run Script'), +(2878000, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 0'), +(2878000, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 1'), +(2878000, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 2'), +(2878000, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 3'), +(2878000, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Say Line 4'), +(2878000, 9, 5, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, 52322, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Cast \'Detonate Charges\''), +(2878000, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 52346, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Explosive Charges Bunny - On Script - Cast \'Kill Credit\''), +(2828400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 1 - Say Line 0'), +(2828400, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 11, 51322, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 1 - Cast Webbed'), +(2828400, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 1, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 1 - Say Line 1'), +(2828400, 9, 3, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 28, 51322, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 1 - Remove Aura - Webbed'), +(2828401, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 2 - Say Line 2'), +(2828401, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 5, 233, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 2 - Play emote 233'), +(2828401, 9, 2, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 3, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Specialist Cogwheel - Script 2 - Say Line 3'), +(2833300, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 51394, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - Script - Cast Decimate State'), +(2833300, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 11, 51393, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - Script - Cast Pure Evil: Saronite Knockback'), +(2833300, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 51394, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny (scale x0.25) - Script - Remove Decimate State'), +(2817500, 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 1, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Say Line 2'), +(2817500, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 2, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Say Line 3'), +(2817500, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, 51396, 0, 0, 0,0, 0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Cast Pure Evil: Korfaxs Cleave'), +(2817500, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 51396, 0, 0, 0,0, 0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Cast Pure Evil: Korfaxs Cleave'), +(2817500, 9, 4, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 51396, 0, 0, 0,0, 0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Cast Pure Evil: Korfaxs Cleave'), +(2817500, 9, 5, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 3, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Crusade Commander Korfax - Script - Say Line 3'), +(2817600, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 51380, 0, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rimblat Earthshatter - Script - Cast Lightning & Ice Channeling'), +(2817600, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 28, 51380, 0, 0, 0,0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rimblat Earthshatter - Script - Remove Lightning & Ice Channeling'), +(2817600, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 1, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rimblat Earthshatter - Script - Say Line'), +(2817700, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 28892, 0, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rayne - Script - Cast Nature Channeling'), +(2817700, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 45, 3, 3, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rayne - Script - Set Data 3 3 ELM General Purpose Bunny (scale x0.25)'), +(2817700, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 28, 28892, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rayne - Script - Remove Nature Channeling'), +(2817700, 9, 3, 0, 0, 0, 100, 0, 100, 100, 0, 0, 45, 4, 4, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rayne - Script - Set Data 4 4 ELM General Purpose Bunny (scale x0.25)'), +(2817700, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Rayne - Script - Say Line'), +(2817800, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Avenger Metz - Script - Say Line 4'), +(2817800, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 66, 0, 0, 0, 0, 0,0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Avenger Metz - Script - Set Orientation'), +(2817800, 9, 2, 0, 0, 0, 100, 0, 500, 500, 0, 0, 11, 51384, 0, 0, 0, 0,0, 19, 28333, 0, 0, 0, 0, 0, 0, 'Avenger Metz - Script - Cast Hammer of Wrath'), +(2817800, 9, 4, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 45, 5, 5, 0, 0, 0,0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Rayne - Script - Set Data 5 5 ELM General Purpose Bunny (scale x0.25)'), +(2817800, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 4, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Avenger Metz - Script - Say Line 5'), +(2824400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0,0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 1'), +(2824400, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 45, 1, 1, 0,0, 0, 0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data 1 1 ELM General Purpose Bunny (scale x0.25)'), +(2824400, 9, 2, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 1, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 2'), +(2824400, 9, 3, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 45, 1, 1, 0,0, 0, 0, 19, 28175, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data 1 1 on Crusade Commander Korfax'), +(2824400, 9, 4, 0, 0, 0, 100, 0, 16000, 16000, 0, 0, 1, 0, 0, 0, 0,0, 0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 1 on Avenger Metz'), +(2824400, 9, 5, 0, 0, 0, 100, 0, 17000, 17000, 0, 0, 1, 2, 0, 0, 0,0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 3'), +(2824400, 9, 6, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 0, 0, 0, 0, 0,0, 19, 28176, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line on Rimblat Earthshatter'), +(2824400, 9, 7, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 45, 1, 1, 0, 0, 0,0, 19, 28176, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data on Rimblat Earthshatter'), +(2824400, 9, 8, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 45, 1, 1, 0, 0, 0,0, 19, 28177, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data on Rayne'), +(2824400, 9, 9, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 1, 1, 0, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 2 on Avenger Metz'), +(2824400, 9, 10, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 3, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 4'), +(2824400, 9, 11, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 2, 0, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 3 on Avenger Metz'), +(2824400, 9, 12, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 4, 0, 0, 0, 0,0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 5'), +(2824400, 9, 13, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 45, 1, 1, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data on Avenger Metz'), +(2824400, 9, 14, 0, 0, 0, 100, 0, 11000, 11000, 0, 0, 1, 4, 0, 0, 0, 0,0, 19, 28175, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 5 on Crusade Commander Korfax'), +(2824400, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0,0, 19, 28177, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 2 on Rayne'), +(2824400, 9, 16, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 5, 0, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 6 on Avenger Metz'), +(2824400, 9, 17, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 1, 5, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 6'), +(2824400, 9, 18, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 6, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 7'), +(2824400, 9, 19, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 7, 0, 0,0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 8'), +(2824400, 9, 20, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 6, 0, 0, 0, 0,0, 19, 28178, 0, 0, 0, 0, 0, 0, 'Eitrigg - Script - Say Line 6 on Avenger Metz'), +(2824400, 9, 21, 0, 0, 0, 100, 0, 500, 500, 0, 0, 45, 2, 2, 0,0, 0, 0, 10, 112373, 28333, 0, 0, 0, 0, 0, 'Eitrigg - Script - Set Data 2 2 ELM General Purpose Bunny (scale x0.25)'); + +DELETE FROM `creature_text` WHERE `entry` IN(28176,28175,28177,28178,28244,28284,28780,28479,28514,28515,28516,28517); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(28479, 0, 0, 'Gods of old, we beseech you. What must we do? How can we save the gods of this land?', 15, 0, 100, 6, 0, 0, 'Witch Doctor Khufu',28431), +(28514, 0, 0, 'But try they must or all will be lost. The Drakkari will be the death of both themselves and their gods!', 12, 0, 100, 0, 0, 473, 'Nalorakk',28435), +(28515, 0, 0, 'The spotted one must be sought. Their fates are entwined.', 12, 0, 100, 0, 0, 9919, 'Jan''alai',28432), +(28516, 0, 0, 'But she is chained. A way must be found to free her.', 12, 0, 100, 0, 0, 12196, 'Akil''zon',28433), +(28517, 0, 0, 'To her altar this mortal must travel. What they must do will not be easy. In the end it may prove impossible.', 12, 0, 100, 0, 0, 643, 'Halazzi',28434), +(28176, 0, 0, 'Let us see if it is truly impervious.', 12, 0, 100, 1, 0, 0, 'Rimblat Earthshatter',27783), +(28176, 1, 0, 'Nothing.', 12, 0, 100, 1, 0, 0, 'Rimblat Earthshatter',27766), +(28175, 0, 0, 'Saronite you say?', 12, 0, 100, 0, 0, 0, 'Crusade Commander Korfax',27779), +(28175, 1, 0, 'Never heard of it. Looks like pure evil.', 12, 0, 100, 6, 0, 0, 'Crusade Commander Korfax',27748), +(28175, 2, 0, 'Let''s see how it holds up to the might of my axe!', 12, 0, 100, 0, 0, 0, 'Crusade Commander Korfax',27749), +(28175, 3, 0, 'What the? My reaper didn''t even scratch it! That''s the toughest ore I''ve ever seen!', 12, 0, 100, 0, 0, 0, 'Crusade Commander Korfax',27750), +(28175, 4, 0, 'Oof!', 12, 0, 100, 0, 0, 9410, 'Crusade Commander Korfax',27788), +(28177, 0, 0, 'By the Goddess. It''s as if Nature can''t touch it!', 12, 0, 100, 5, 0, 0, 'Rayne',27763), +(28177, 1, 0, 'Gah!', 12, 0, 100, 0, 0, 9410, 'Rayne',27786), +(28178, 0, 0, '%s rolls his eyes.', 16, 0, 100, 0, 0, 0, 'Avenger Metz',27784), +(28178, 1, 0, 'No surprise there.', 12, 0, 100, 0, 0, 0, 'Avenger Metz',27769), +(28178, 2, 0, 'What?', 12, 0, 100, 0, 0, 0, 'Avenger Metz',27770), +(28178, 3, 0, 'Fine. Just remember though, the power of the Holy Light isn''t something to be invoked casually, brother.', 12, 0, 100, 1, 0, 0, 'Avenger Metz',27771), +(28178, 4, 0, 'What''s it doing?!', 12, 0, 100, 5, 0, 0, 'Avenger Metz',27772), +(28178, 5, 0, 'Whoa!', 12, 0, 100, 0, 0, 9410, 'Avenger Metz',27787), +(28178, 6, 0, '%s grunts.', 16, 0, 100, 0, 0, 0, 'Avenger Metz',27776), +(28244, 0, 0, 'Now we will see why this ore is so important to the Scourge.', 12, 0, 100, 16, 0, 0, 'Eitrigg',27746), +(28244, 1, 0, 'Korfax, what can you tell from this saronite?', 12, 0, 100, 6, 0, 0, 'Eitrigg',27747), +(28244, 2, 0, 'Rayne, Rimblat, what about the power of nature and the elements?', 12, 0, 100, 6, 0, 0, 'Eitrigg',27759), +(28244, 3, 0, 'Metz?', 12, 0, 100, 6, 0, 0, 'Eitrigg',27767), +(28244, 4, 0, 'You know what.', 12, 0, 100, 25, 0, 0, 'Eitrigg',27768), +(28244, 5, 0, '%s dusts himself off.', 16, 0, 100, 0, 0, 9410, 'Eitrigg',27789), +(28244, 6, 0, 'Clearly this is getting us nowhere. We need to get this saronite to Highlord Fordring for further study.', 12, 0, 100, 1, 0, 0, 'Eitrigg',27774), +(28244, 7, 0, 'Thank you for trying, my friends. We''ll unlock its secrets. Hopefully before it''s too late.', 12, 0, 100, 1, 0, 0, 'Eitrigg',27775), +(28284, 0, 0, 'Oh, these are sticky! I wonder how they shoot the webbing?', 12, 0, 100, 0, 0, 0, 'Specialist Cogwheel',27734), +(28284, 1, 0, 'ACK! Oh no, I webbed myself! It''s sticky. MY HAIR!', 12, 0, 100, 15, 0, 6906, 'Specialist Cogwheel',27735), +(28284, 2, 0, 'Okay! Let me just see if I can fashion these disgusting parts into something useful.', 12, 0, 100, 0, 0, 0, 'Specialist Cogwheel',27736), +(28284, 3, 0, 'Eureka!', 12, 0, 100, 4, 0, 0, 'Specialist Cogwheel',27737), +(28780, 0, 0, 'Explosive Charges will detonate in 5 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28816), +(28780, 1, 0, 'Explosive Charges will detonate in 4 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28817), +(28780, 2, 0, 'Explosive Charges will detonate in 3 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28818), +(28780, 3, 0, 'Explosive Charges will detonate in 2 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28819), +(28780, 4, 0, 'Explosive Charges will detonate in 1 seconds...', 16, 0, 100, 0, 0, 0, 'Explosive Charges Bunny',28820); + +DELETE FROM `waypoints` WHERE `entry` IN(28175,28244); + +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(28175, 1,5448.54, -2645.614, 305.619, 'Crusade Commander Korfax'), +(28175, 2,5448.541, -2644.614, 305.619, 'Crusade Commander Korfax'), +(28175, 3,5448.541, -2643.614, 305.869, 'Crusade Commander Korfax'), +(28175, 4,5448.541, -2642.114, 306.119, 'Crusade Commander Korfax'), +(28175, 5,5448.66, -2639.83, 306.551, 'Crusade Commander Korfax'), +(28244, 1,5450.109, -2642.323, 306.6346, 'Eitrigg'), +(28244, 2,5450.109, -2643.323, 306.1346, 'Eitrigg'), +(28244, 3,5450.109, -2644.573, 305.8846, 'Eitrigg'), +(28244, 4,5450.15, -2639.06, 306.551, 'Eitrigg'); + +DELETE FROM `spell_scripts` WHERE `id`=51862; +INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES +(51862,0,0,15,51861,0,0,0,0,0,0), +(51862,0,0,15,52452,0,0,0,0,0,0), +(51862,0,0,15,52453,0,0,0,0,0,0), +(51862,0,0,15,52454,0,0,0,0,0,0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (51861,52452,52453,52454); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,51861,0,0,31,0,3,23837,98547,0,0,'','Spell Breaking Through Jin''Alai: Summon Akil''zon targets ELM General Purpose Bunny'), +(13,1,52452,0,0,31,0,3,23837,98549,0,0,'','Spell Breaking Through Jin''Alai: Summon Jan''Alai targets ELM General Purpose Bunny'), +(13,1,52453,0,0,31,0,3,23837,98546,0,0,'','Spell Breaking Through Jin''Alai: Summon Halazzi targets ELM General Purpose Bunny'), +(13,1,52454,0,0,31,0,3,23837,98548,0,0,'','Spell Breaking Through Jin''Alai: Summon Nalorakk targets ELM General Purpose Bunny'); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (28514,28515,28516,28517); +INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`bytes2`) VALUES +(28514,0,1), +(28515,0,1), +(28516,33554432,1), +(28517,0,1); + +UPDATE `creature_template` SET `minlevel`=83, `maxlevel`=83, `unit_flags`=512|256 WHERE `entry` IN (28514,28515,28516,28517); +UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry` IN(28479,28514,28515,28516,28517); +DELETE FROM `smart_scripts` WHERE `entryorguid` =28479 AND `source_type`=0 AND `id` IN (6,7); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(28514,28515,28516,28517) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` =2847900 AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(28479, 0, 6, 7, 20, 0, 100, 0, 12627, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - On Quest Reward (Breaking Through Jin''Alai) - Say'), +(28479, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 2847900, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - On Quest Reward (Breaking Through Jin''Alai) - Run Script'), +(28514, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 35426, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Nalorakk - On Just Summoned - Cast Arcane Explosion Visual'), +(28515, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 35426, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Jan''alai - On Just Summoned - Cast Arcane Explosion Visual'), +(28516, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 35426, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Akil''zon - On Just Summoned - Cast Arcane Explosion Visual'), +(28517, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 35426, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Halazzi - On Just Summoned - Cast Arcane Explosion Visual'), +(2847900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Set NPC Flags'), +(2847900, 9, 5, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28515, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Say Line (Jan alai)'), +(2847900, 9, 6, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28516, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Say Line (Akil zon)'), +(2847900, 9, 7, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28517, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Say Line (Halazzi)'), +(2847900, 9, 8, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 28514, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Say Line (Nalorakk)'), +(2847900, 9, 9, 0, 0, 0, 100, 0, 20000, 20000, 0, 0, 81, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Witch Doctor Khufu - Script - Set NPC Flags'); diff --git a/sql/updates/world/2014_08_25_02_world_sai.sql b/sql/updates/world/2014_08_25_02_world_sai.sql new file mode 100644 index 00000000000..2f31e348b53 --- /dev/null +++ b/sql/updates/world/2014_08_25_02_world_sai.sql @@ -0,0 +1,4 @@ +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=190590; +DELETE FROM `smart_scripts` WHERE `entryorguid`=190590 AND `source_type`=1; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(190590,1,0,0,70,0,100,0,2,0,0,0,70,60,0,0,0,0,0,1,0,0,0,0,0,0,0,'Unstable Explosives - On State Changed - Despawn for 60 sec'); diff --git a/sql/updates/world/2014_08_26_00_world_sai.sql b/sql/updates/world/2014_08_26_00_world_sai.sql new file mode 100644 index 00000000000..4c54d91a75b --- /dev/null +++ b/sql/updates/world/2014_08_26_00_world_sai.sql @@ -0,0 +1,4 @@ +UPDATE `smart_scripts` SET `event_flags`=0 WHERE `entryorguid`=5261 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_flags`=0 WHERE `entryorguid`=5263 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_flags`=0 WHERE `entryorguid`=5269 AND `source_type`=0 AND `id`IN(0,1,2); +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=5269 AND `source_type`=0 AND `id`IN(3); diff --git a/sql/updates/world/2014_08_26_01_world_spelldifficulty_dbc.sql b/sql/updates/world/2014_08_26_01_world_spelldifficulty_dbc.sql new file mode 100644 index 00000000000..90f327312ce --- /dev/null +++ b/sql/updates/world/2014_08_26_01_world_spelldifficulty_dbc.sql @@ -0,0 +1,52 @@ +DELETE FROM `spelldifficulty_dbc` WHERE `spellid0` IN (68186,28783,28785,28796,28794,28798,28732,29317,29865,29204,29484,28741,28776,54123,41926,56908,56910,28134,28135,28167,63018,63024,65737,64203,64227,57570,57579,57581,33783,56891,56926,34659,34653,30926,52429,52387,36705,48380,50988,51012,51136,58459,58462,58463,58456,58455,58458,58457,60181,60182); +INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`) VALUES +(68186,68186,68515), +(28783,28783,56090), +(28785,28785,54021), +(28796,28796,54098), +(28794,28794,54099), +(28798,28798,54100), +(28732,28732,54097), +(29317,29317,56405), +(29865,29865,55053), +(29204,29204,55052), +(29484,29484,54125), +(28741,28741,54122), +(28776,28776,54121), +(54123,54123,54124), +(41926,41926,59192), +(56908,56908,58956), +(56910,56910,58957), +(28134,28134,54529), +(28135,28135,54528), +(28167,28167,54531), +(63018,63018,65121), +(63024,63024,64234), +(65737,65737,64193), +(64203,64203,64235), +(64227,64227,64236), +(57570,57570,59126), +(57579,57579,59127), +(57581,57581,59128), +(33783,33783,39364), +(56891,56891,60032), +(56926,56926,60029), +(34659,34659,39131), +(34653,34653,36920), +(30926,30926,36921), +(52429,52429,59527), +(52387,52387,59528), +(36705,36705,39133), +(48380,48380,59320), +(50988,50988,59870), +(51012,51012,59868), +(51136,51136,59867), +(58459,58459,59256), +(58462,58462,59257), +(58463,58463,59258), +(58456,58456,59248), +(58455,58455,59245), +(58458,58458,59253), +(58457,58457,59251), +(60181,60181,60204), +(60182,60182,60205); diff --git a/sql/updates/world/2014_08_26_02_world_skill_fishing_base_level.sql b/sql/updates/world/2014_08_26_02_world_skill_fishing_base_level.sql new file mode 100644 index 00000000000..a59fecf04d6 --- /dev/null +++ b/sql/updates/world/2014_08_26_02_world_skill_fishing_base_level.sql @@ -0,0 +1,4 @@ +-- Add skill_fishing_base_level -20 to Undercity, based on other capital cities +DELETE FROM `skill_fishing_base_level` WHERE `entry`=1497; +INSERT INTO `skill_fishing_base_level` (`entry`, `skill`) VALUES +(1497, -20); diff --git a/sql/updates/world/2014_08_26_04_world_sai.sql b/sql/updates/world/2014_08_26_04_world_sai.sql new file mode 100644 index 00000000000..6a7a1ba87b7 --- /dev/null +++ b/sql/updates/world/2014_08_26_04_world_sai.sql @@ -0,0 +1,17 @@ +UPDATE `smart_scripts` SET `action_param2`=77 WHERE `entryorguid`=3019000 AND `source_type`=9 AND `id`=2; +UPDATE `smart_scripts` SET `action_param2`=30 WHERE `entryorguid`=2856608 AND `source_type`=9 AND `id`=1; +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=1814200 AND `source_type`=9 AND `id` IN(0,3,4,5); +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=1814300 AND `source_type`=9 AND `id` IN(0,1,2,4,5); +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=1814400 AND `source_type`=9 AND `id` IN(0,2,3,4); +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=1811000 AND `source_type`=9 AND `id` IN(0,1,2,3,4,5,6); +UPDATE `smart_scripts` SET `action_param2`=60 WHERE `entryorguid`=24170 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=60 WHERE `entryorguid`=177490 AND `source_type`=1 AND `id` IN(0,2); +UPDATE `smart_scripts` SET `action_param2`=42 WHERE `entryorguid`=3327300 AND `source_type`=9 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=20 WHERE `entryorguid`=3327300 AND `source_type`=9 AND `id`=5; +UPDATE `smart_scripts` SET `action_param2`=30 WHERE `entryorguid`=3249702 AND `source_type`=9 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=30 WHERE `entryorguid` IN(3249700,3249701) AND `source_type`=9 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=120 WHERE `entryorguid` IN(2397400,2397401,2397402,2397403) AND `source_type`=9 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=30 WHERE `entryorguid`=21926 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=60 WHERE `entryorguid`=3685607 AND `source_type`=9 AND `id`=4; +UPDATE `smart_scripts` SET `action_param2`=4 WHERE `entryorguid`=15951 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `action_param2`=60 WHERE `entryorguid`=20226 AND `source_type`=0 AND `id`=1; diff --git a/sql/updates/world/2014_08_26_05_world_sai.sql b/sql/updates/world/2014_08_26_05_world_sai.sql new file mode 100644 index 00000000000..b299dd1756c --- /dev/null +++ b/sql/updates/world/2014_08_26_05_world_sai.sql @@ -0,0 +1,27 @@ +UPDATE `creature_template` SET `unit_flags`=768,`AIName`='SmartAI' WHERE `entry`=29775; + +DELETE FROM `smart_scripts` WHERE `entryorguid` =2977500 AND `source_type`=9; +DELETE FROM `smart_scripts` WHERE `entryorguid`=29775 AND `source_type`=0; + +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(29775,0,0,0,54,0,100,0,0,0,0,0,80,2977500,2,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - On Just Summoned - Run Script"), +(29775,0,1,0,7,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - On Evade - Despawn"), +(2977500,9,0,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Say Line 1"), +(2977500,9,1,0,0,0,100,0,6000,6000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Say Line 2"), +(2977500,9,2,0,0,0,100,0,6000,6000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Say Line 3"), +(2977500,9,3,0,0,0,100,0,6000,6000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Say Line 4"), +(2977500,9,4,0,0,0,100,0,6000,6000,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Say Line 5"), +(2977500,9,5,0,0,0,100,0,6000,6000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Say Line 6"), +(2977500,9,6,0,0,0,100,0,6000,6000,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Say Line 7"), +(2977500,9,7,0,0,0,100,0,0,0,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Remove Unit Flags"), +(2977500,9,8,0,0,0,100,0,0,0,0,0,49,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Archivist Mechaton - Script - Remove Unit Flags"); + +DELETE FROM `creature_text` WHERE `entry`=29775; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(29775, 0, 0, 'Use of the Inventor''s Disk detected. Emergency protocol gamma activated.', 12, 0, 100, 0, 0, 0, 'Archivist Mechaton',30402), +(29775, 1, 0, 'Verifying status of Norgannon''s shell.', 12, 0, 100, 0, 0, 0, 'Archivist Mechaton',30403), +(29775, 2, 0, 'Norgannon''s shell accounted for and secure. It will be available for transfer once user''s identity has been verified.', 12, 0, 100, 1, 0, 0, 'Archivist Mechaton',30404), +(29775, 3, 0, 'Standby to verify identity as Keeper Mimir.', 12, 0, 100, 1, 0, 0, 'Archivist Mechaton',30405), +(29775, 4, 0, 'Identity verification failed. User is not Keeper Mimir.', 12, 0, 100, 25, 0, 0, 'Archivist Mechaton',30406), +(29775, 5, 0, 'The Inventor''s Disk has fallen into the hands of an unauthorized user. Activating defense protocol.', 12, 0, 100, 0, 0, 0, 'Archivist Mechaton',30407), +(29775, 6, 0, 'Impostor must be dealt with. The Inventor''s Disk must be recovered.', 12, 0, 100, 5, 0, 0, 'Archivist Mechaton',30408); diff --git a/sql/updates/world/2014_08_26_06_world_creature_stats.sql b/sql/updates/world/2014_08_26_06_world_creature_stats.sql new file mode 100644 index 00000000000..9f7d256fd63 --- /dev/null +++ b/sql/updates/world/2014_08_26_06_world_creature_stats.sql @@ -0,0 +1,74 @@ +-- Armor update for Warrior class from Bestiary +UPDATE `creature_classlevelstats` SET `basearmor`=15 WHERE `level`=1 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=16 WHERE `level`=2 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=41 WHERE `level`=3 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=76 WHERE `level`=4 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=120 WHERE `level`=5 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=174 WHERE `level`=6 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=239 WHERE `level`=7 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=316 WHERE `level`=8 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=406 WHERE `level`=9 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=512 WHERE `level`=10 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=538 WHERE `level`=11 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=573 WHERE `level`=12 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=608 WHERE `level`=13 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=642 WHERE `level`=14 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=677 WHERE `level`=15 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=713 WHERE `level`=16 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=748 WHERE `level`=17 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=782 WHERE `level`=18 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=817 WHERE `level`=19 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=852 WHERE `level`=20 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=888 WHERE `level`=21 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=922 WHERE `level`=22 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=957 WHERE `level`=23 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=992 WHERE `level`=24 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1026 WHERE `level`=25 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1061 WHERE `level`=26 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1097 WHERE `level`=27 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1130 WHERE `level`=28 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1165 WHERE `level`=29 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1200 WHERE `level`=30 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1234 WHERE `level`=31 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1270 WHERE `level`=32 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1304 WHERE `level`=33 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1340 WHERE `level`=34 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1373 WHERE `level`=35 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1480 WHERE `level`=36 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1593 WHERE `level`=37 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1709 WHERE `level`=38 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1834 WHERE `level`=39 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=1964 WHERE `level`=40 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2101 WHERE `level`=41 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2246 WHERE `level`=42 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2397 WHERE `level`=43 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2557 WHERE `level`=44 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2725 WHERE `level`=45 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2780 WHERE `level`=46 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2835 WHERE `level`=47 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2888 WHERE `level`=48 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2944 WHERE `level`=49 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=2999 WHERE `level`=50 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3052 WHERE `level`=51 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3108 WHERE `level`=52 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3163 WHERE `level`=53 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3216 WHERE `level`=54 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3271 WHERE `level`=55 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3327 WHERE `level`=56 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3380 WHERE `level`=57 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3435 WHERE `level`=58 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3489 WHERE `level`=59 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=3791 WHERE `level`=60 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=4091 WHERE `level`=61 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=4391 WHERE `level`=62 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=4691 WHERE `level`=63 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=4991 WHERE `level`=64 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=5291 WHERE `level`=65 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=5591 WHERE `level`=66 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=5892 WHERE `level`=67 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=6192 WHERE `level`=68 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=6492 WHERE `level`=69 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=6792 WHERE `level`=70 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=7089 WHERE `level`=71 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=7387 WHERE `level`=72 AND `class`=1; +UPDATE `creature_classlevelstats` SET `basearmor`=7684 WHERE `level`=73 AND `class`=1; diff --git a/sql/updates/world/2014_08_26_07_world_creature_stats.sql b/sql/updates/world/2014_08_26_07_world_creature_stats.sql new file mode 100644 index 00000000000..123f1218780 --- /dev/null +++ b/sql/updates/world/2014_08_26_07_world_creature_stats.sql @@ -0,0 +1,75 @@ +-- Armor update for Paladin class from Bestiary +-- 1 & 2 are estimated has I have no info for those levels of Paladin class. Also they are only used in db for totems +UPDATE `creature_classlevelstats` SET `basearmor`=13, `comment`= 'armor estimated' WHERE `level`=1 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=14, `comment`= 'armor estimated' WHERE `level`=2 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=37 WHERE `level`=3 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=67 WHERE `level`=4 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=105 WHERE `level`=5 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=150 WHERE `level`=6 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=205 WHERE `level`=7 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=268 WHERE `level`=8 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=342 WHERE `level`=9 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=426 WHERE `level`=10 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=450 WHERE `level`=11 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=479 WHERE `level`=12 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=507 WHERE `level`=13 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=537 WHERE `level`=14 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=566 WHERE `level`=15 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=596 WHERE `level`=16 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=625 WHERE `level`=17 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=652 WHERE `level`=18 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=683 WHERE `level`=19 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=712 WHERE `level`=20 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=740 WHERE `level`=21 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=770 WHERE `level`=22 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=800 WHERE `level`=23 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=829 WHERE `level`=24 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=858 WHERE `level`=25 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=887 WHERE `level`=26 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=916 WHERE `level`=27 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=946 WHERE `level`=28 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=975 WHERE `level`=29 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1004 WHERE `level`=30 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1033 WHERE `level`=31 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1063 WHERE `level`=32 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1091 WHERE `level`=33 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1121 WHERE `level`=34 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1149 WHERE `level`=35 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1234 WHERE `level`=36 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1325 WHERE `level`=37 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1418 WHERE `level`=38 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1517 WHERE `level`=39 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1619 WHERE `level`=40 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1727 WHERE `level`=41 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1841 WHERE `level`=42 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1958 WHERE `level`=43 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2082 WHERE `level`=44 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2211 WHERE `level`=45 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2255 WHERE `level`=46 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2300 WHERE `level`=47 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2344 WHERE `level`=48 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2389 WHERE `level`=49 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2432 WHERE `level`=50 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2477 WHERE `level`=51 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2522 WHERE `level`=52 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2566 WHERE `level`=53 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2610 WHERE `level`=54 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2654 WHERE `level`=55 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2699 WHERE `level`=56 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2744 WHERE `level`=57 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2788 WHERE `level`=58 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2832 WHERE `level`=59 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=3075 WHERE `level`=60 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=3316 WHERE `level`=61 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=3555 WHERE `level`=62 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=3795 WHERE `level`=63 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4036 WHERE `level`=64 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4275 WHERE `level`=65 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4515 WHERE `level`=66 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4755 WHERE `level`=67 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4995 WHERE `level`=68 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=5235 WHERE `level`=69 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=5474 WHERE `level`=70 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=5714 WHERE `level`=71 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=5954 WHERE `level`=72 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=6193 WHERE `level`=73 AND `class`=2; diff --git a/sql/updates/world/2014_08_26_08_world_creature_template.sql b/sql/updates/world/2014_08_26_08_world_creature_template.sql new file mode 100644 index 00000000000..b0e6ef7cbf6 --- /dev/null +++ b/sql/updates/world/2014_08_26_08_world_creature_template.sql @@ -0,0 +1,17 @@ +-- Gruul's Lair Damage Update +-- High King Maulgar +UPDATE `creature_template` SET `BaseAttackTime`=2300, `DamageModifier`=37.5 WHERE `entry`=18831; +-- Krosh Firehand +UPDATE `creature_template` SET `BaseAttackTime`=2000, `DamageModifier`=16 WHERE `entry`=18832; +-- Olm the Summoner +UPDATE `creature_template` SET `BaseAttackTime`=2000, `DamageModifier`=16 WHERE `entry`=18834; +-- Kiggler the Crazed +UPDATE `creature_template` SET `BaseAttackTime`=2000, `DamageModifier`=26 WHERE `entry`=18835; +-- Blindeye the Seer +UPDATE `creature_template` SET `BaseAttackTime`=2000, `DamageModifier`=6.55 WHERE `entry`=18836; +-- Gruul the Dragonkiller +UPDATE `creature_template` SET `BaseAttackTime`=2000, `DamageModifier`=24.4 WHERE `entry`=19044; +-- Lair Brute +UPDATE `creature_template` SET `BaseAttackTime`=2000, `DamageModifier`=28.75 WHERE `entry`=19389; +-- Gronn-Priest +UPDATE `creature_template` SET `BaseAttackTime`=2000, `DamageModifier`=24.95 WHERE `entry`=21350; diff --git a/sql/updates/world/2014_08_27_00_world_creature_template.sql b/sql/updates/world/2014_08_27_00_world_creature_template.sql new file mode 100644 index 00000000000..bfc5ed40f4e --- /dev/null +++ b/sql/updates/world/2014_08_27_00_world_creature_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `ScriptName`='' WHERE `ScriptName`='npc_valiant'; diff --git a/sql/updates/world/2014_08_27_01_world_sai.sql b/sql/updates/world/2014_08_27_01_world_sai.sql new file mode 100644 index 00000000000..783e0941fc0 --- /dev/null +++ b/sql/updates/world/2014_08_27_01_world_sai.sql @@ -0,0 +1,124 @@ +SET @Xarantaur := 30381; +SET @Stormhoof := 30388; +SET @Wind := 30474; +SET @WindImage := 30550; +SET @Spirit := 30479; +SET @Ride := 46598; +SET @DropHorn := 56892; +SET @Stun := 46957; + +DELETE FROM `creature_text` WHERE `entry` IN (@Xarantaur,@Wind,@Stormhoof,@Spirit,@WindImage); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(@Xarantaur, 0, 0, 'And it very nearly didn''t remember you. $N fought bravely against the North Wind to protect your story.', 12, 0, 100, 1, 0, 0, 'Xarantaur',32748), +(@Xarantaur, 1, 0, 'Your battle with the wind was hundreds of years ago, Stormhoof. You weakened it so much that it has been silent all these years.', 12, 0, 100, 273, 0, 0, 'Xarantaur',32750), +(@Xarantaur, 2, 0, 'But the North Wind did not silently accept defeat. Instead, it gathered power and bided its time, deciding the best revenge was to destroy your memory, and with it, your village.', 12, 0, 100, 1, 0, 0, 'Xarantaur',32751), +(@Xarantaur, 3, 0, 'The wind used its minions to distort the history of this place, changing the stories your people told, destroying the spirits of the honored dead.', 12, 0, 100, 1, 0, 0, 'Xarantaur',32752), +(@Xarantaur, 4, 0, 'It would''ve succeeded if $N and I hadn''t tracked the North Wind''s historical corruptions to their source: your ancient battle.', 12, 0, 100, 1, 0, 0, 'Xarantaur',32754), +(@Xarantaur, 5, 0, 'With my help, $N travelled back in time to your battle, and ensured that history was set right. The North Wind''s fate was sealed, and your story restored.', 12, 0, 100, 1, 0, 0, 'Xarantaur',32755), +(@Xarantaur, 6, 0, 'Rest well, hero.', 12, 0, 100, 273, 0, 0, 'Xarantaur',32762), +(@Xarantaur, 7, 0, 'This isn''t right at all, $n. In the tale Wind Tamer Barah told me, Stormhoof was a hero, not a villain.', 12, 0, 100, 6, 0, 0, 'Xarantaur',31041), +(@Xarantaur, 8, 0, 'The North Wind is the ancient enemy of the taunka, a ruler among the elements, and the very force which bleeds the life from these ancient people.', 12, 0, 100, 1, 0, 0, 'Xarantaur',31044), +(@Xarantaur, 9, 0, 'They would rather die than bow before the North Wind. Something is amiss here.', 12, 0, 100, 274, 0, 0, 'Xarantaur',31046), +(@Xarantaur, 10, 0, 'The Lorehammer...', 12, 0, 100, 25, 0, 0, 'Xarantaur',31049), +(@Xarantaur, 11, 0, 'It confirms our suspicions. The threads of time have been severed and rewoven in the wrong pattern. But, how?', 12, 0, 100, 1, 0, 0, 'Xarantaur',31050), +(@Xarantaur, 12, 0, 'There''s no doubt that something has distorted the true history of Stormhoof and the warriors of Camp Tunka''lo. But, what?', 12, 0, 100, 1, 0, 0, 'Xarantaur',31259), +(@Xarantaur, 13, 0, 'No! The true voice of history will triumph. We will restore all you have destroyed!', 12, 0, 100, 25, 0, 0, 'Xarantaur',31263), +(@Xarantaur, 14, 0, '$n, we must hurry and discover when the North Wind has started distorting the timeline. Only then can we defeat him and correct it.', 12, 0, 100, 1, 0, 0, 'Xarantaur',31264), +(@Stormhoof, 0, 0, 'The horn! Use the horn on it while it''s weak!', 14, 0, 100, 0, 0, 0, 'Stormhoof',31183), +(@Stormhoof, 1, 0, 'Go to the center of the temple and use the Horn of Elemental Fury!', 41, 0, 100, 0, 0, 0, 'Stormhoof',36207), +(@WindImage, 0, 0, 'Do not trouble yourself, little tauren. Neither Stormhoof, nor you and your ally will stand in my way.', 12, 0, 100, 1, 0, 0, 'Image of the North Wind',31260), +(@WindImage, 1, 0, 'Even now, my power grows. I have long waited for the day when my revenge would be complete.', 12, 0, 100, 1, 0, 0, 'Image of the North Wind',31261), +(@WindImage, 2, 0, 'Stormhoof and his kin will be erased from history and these lands will be restored to their rightful owner!', 12, 0, 100, 1, 0, 0, 'Image of the North Wind',31262), +(@Wind, 0, 0, 'Fool! You will never defeat me!', 14, 0, 100, 0, 0, 0, 'North Wind',31180), +(@Wind, 1, 0, 'I will never allow you to use the Horn of Elemental Fury against us! Die, weakling!', 14, 0, 100, 0, 0, 0, 'North Wind',31181), +(@Spirit, 0, 0, 'This is Camp Tunka''lo, the village ruled by my brother, but I... I don''t remember you.', 12, 0, 100, 6, 0, 0, 'Stormhoof''s Spirit',32747), +(@Spirit, 1, 0, 'The North Wind? It still troubles my people?', 12, 0, 100, 6, 0, 0, 'Stormhoof''s Spirit',32749), +(@Spirit, 2, 0, 'You both have my thanks and that of the village, though many will never know of your deeds.', 12, 0, 100, 2, 0, 0, 'Stormhoof''s Spirit',32756), +(@Spirit, 3, 0, 'I cannot remain here. I must return to my cairn where I belong, but when I see the ancestors again, it is I who will tell your story.', 12, 0, 100, 1, 0, 0, 'Stormhoof''s Spirit',32759); + + +UPDATE `creature_model_info` SET `bounding_radius`=0.6249996, `combat_reach`=2.7 WHERE `modelid`=26979; +UPDATE `creature_model_info` SET `bounding_radius`=0.6597218, `combat_reach`=2.85 WHERE `modelid`=26980; + +DELETE FROM `creature_equip_template` WHERE `entry`=@Spirit; +INSERT INTO `creature_equip_template` (`entry`,`id`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES +(@Spirit,1,42873,0,0); + +UPDATE `creature_template` SET `spell1`=56897,`spell2`=61668,`spell3`=56896,`AIName`='' WHERE `entry`=@Stormhoof; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=@Wind; +UPDATE `creature_template` SET `faction`=775,`unit_flags`=768 WHERE `entry`=@Spirit; + +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@Xarantaur,@Wind,@Spirit,@WindImage); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@Xarantaur,@Stormhoof,@Wind,@Spirit,@WindImage) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@Xarantaur*100,(@Xarantaur*100)+1) AND `source_type`=9; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=@Spirit*100 AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@Wind,0,0,0,0,0,100,0,1000,3000,8000,11000,11,61662,0,0,0,0,0,2,0,0,0,0,0,0,0,'North Wind - IC - Cast Cyclone'), +(@Wind,0,1,0,0,0,100,0,1000,8000,12000,16000,11,61663,0,0,0,0,0,2,0,0,0,0,0,0,0,'North Wind - IC - Gust of Wind'), +(@Wind,0,2,3,2,0,100,1,10,20,20000,20000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Between 10 and 20% HP - Set faction'), +(@Wind,0,3,4,61,0,100,0,0,0,0,0,1,0,1000,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Between 10 and 20% HP - Say line 0'), +(@Wind,0,4,5,61,0,100,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Between 10 and 20% HP - Stop autoattack'), +(@Wind,0,5,6,61,0,100,0,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Between 10 and 20% HP - Stop combat movement'), +(@Wind,0,6,7,61,0,100,0,0,0,0,0,101,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Between 10 and 20% HP - Set homeposition'), +(@Wind,0,7,0,61,0,100,0,0,0,0,0,102,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Between 10 and 20% HP - Stop health regen'), +(@Wind,0,8,9,52,0,100,0,0,@Wind,0,0,1,0,0,0,0,0,0,19,@Stormhoof,20,0,0,0,0,0,'North Wind - Text over - Stormhoof say line 0'), +(@Wind,0,9,10,61,0,100,0,0,0,0,0,1,1,1000,0,0,0,0,19,@Stormhoof,20,0,0,0,0,0,'North Wind - Text over - Spellcast Drop Horn of Elemental Fury'), +(@Wind,0,10,0,61,0,100,0,0,0,0,0,11,@DropHorn,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text over - Spellcast Drop Horn of Elemental Fury'), +(@Wind,0,11,12,52,0,100,0,1,@Stormhoof,0,0,28,@Ride,0,0,0,0,0,19,@Stormhoof,20,0,0,0,0,0,'North Wind - Text over - Remove aura Ride Vehicle Hardcoded'), +(@Wind,0,12,13,61,0,100,0,0,0,0,0,11,@Stun,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text Over - Spellcast Cosmetic - Stun (Permanent)'), +(@Wind,0,13,0,61,0,100,0,0,0,0,0,1,1,60000,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text Over - Say line 1'), +(@Wind,0,14,15,52,0,100,0,1,@Wind,0,0,2,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text over - Restore faction'), +(@Wind,0,15,16,61,0,100,0,0,0,0,0,20,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text over - Enable autocombat'), +(@Wind,0,16,17,61,0,100,0,0,0,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text over - Enable combat movement'), +(@Wind,0,17,18,61,0,100,0,0,0,0,0,28,@Stun,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text over - Remove aura Cosmetic - Stun (Permanent)'), +(@Wind,0,18,19,61,0,100,0,0,0,0,0,102,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text over - Start health regen'), +(@Wind,0,19,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'North Wind - Text over - Despawn'), +(@Xarantaur,0,0,1,20,1,100,0,13058,0,0,0,12,@Spirit,8,0,0,0,0,8,0,0,0,7765.307,-2831.78,1216.812,3.577925,'Xarantaur - Quest rewarded (phase 1)- Summon Stormhoof''s Spirit'), +(@Xarantaur,0,1,2,61,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Xarantaur - Quest rewarded (phase 1) - Set event phase 0'), +(@Xarantaur,0,2,0,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'Xarantaur - Quest rewarded (phase 1) - Store targetlist'), +(@Xarantaur,0,3,0,11,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Xarantaur - Respawn - Set event phase 1'), +(@Xarantaur,0,4,0,38,0,100,0,0,1,0,0,1,0,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Data 0 1 set - Say line 0'), +(@Xarantaur,0,5,0,38,0,100,0,0,2,0,0,1,4,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Data 0 2 set - Say line 4'), +(@Xarantaur,0,6,0,38,0,100,0,0,3,0,0,1,5,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Data 0 2 set - Say line 5'), +(@Xarantaur,0,7,8,20,1,100,0,13034,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'Xarantaur - Quest rewarded (The Witness and the Hero)- Store Targetlist'), +(@Xarantaur,0,8,0,61,1,100,0,0,0,0,0,80,@Xarantaur*100,2,0,0,0,0,1,0,0,0,0,0,0,0,'Xarantaur - Quest rewarded (The Witness and the Hero)- Run Script 1'), +(@Xarantaur,0,9,10,20,1,100,0,13038,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'Xarantaur - Quest rewarded (Distortions in Time)- Store Targetlist'), +(@Xarantaur,0,10,0,61,1,100,0,0,0,0,0,80,(@Xarantaur*100)+1,2,0,0,0,0,1,0,0,0,0,0,0,0,'Xarantaur - Quest rewarded (Distortions in Time)- Run Script 2'), +(@Xarantaur*100,9,0,0,0,0,100,0,1000,1000,0,0,1,7,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Script - Say Line 7'), +(@Xarantaur*100,9,1,0,0,0,100,0,6000,6000,0,0,1,8,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Script - Say Line 8'), +(@Xarantaur*100,9,2,0,0,0,100,0,6000,6000,0,0,1,9,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Script - Say Line 9'), +(@Xarantaur*100,9,3,0,0,0,100,0,6000,6000,0,0,1,10,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Script - Say Line 10'), +(@Xarantaur*100,9,4,0,0,0,100,0,6000,6000,0,0,1,11,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Script - Say Line 11'), +(@WindImage, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 16000, 11, 57322, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Image of the North Wind - On Data Set - Cast Lightning Nova'), +((@Xarantaur*100)+1,9,0,0,0,0,100,0,1000,1000,0,0,1,12,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Script 2 - Say Line 12'), +((@Xarantaur*100)+1,9,1,0,0,0,100,0,4000,4000,0,0,12,@WindImage,1,18000,0,0,0,8,0,0,0,7761.913, -2830.313, 1216.813, 4.310963,'Xarantaur - Script - Summon Image of the Northwind'), +((@Xarantaur*100)+1,9,2,0,0,0,100,0,1000,1000,0,0,45,1,1,0,0,0,0,19,@WindImage,0,0,0,0,0,0,'Xarantaur - Script 2- Set Data 1 1 to Image of the Northwind'), +((@Xarantaur*100)+1,9,3,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,19,@WindImage,0,0,0,0,0,0,'Xarantaur - Script 2- Say Line 1 (Image of the North Wind)'), +((@Xarantaur*100)+1,9,4,0,0,0,100,0,6000,6000,0,0,1,1,0,0,0,0,0,19,@WindImage,0,0,0,0,0,0,'Xarantaur - Script 2- Say Line 2 (Image of the North Wind)'), +((@Xarantaur*100)+1,9,5,0,0,0,100,0,6000,6000,0,0,1,2,0,0,0,0,0,19,@WindImage,0,0,0,0,0,0,'Xarantaur - Script 2- Say Line 3 (Image of the North Wind)'), +((@Xarantaur*100)+1,9,6,0,0,0,100,0,3000,3000,0,0,45,1,1,0,0,0,0,19,@WindImage,0,0,0,0,0,0,'Xarantaur - Script 2- Set Data 1 1 to Image of the Northwind'), +((@Xarantaur*100)+1,9,7,0,0,0,100,0,3000,3000,0,0,1,13,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Script2 - Say Line 13'), +((@Xarantaur*100)+1,9,8,0,0,0,100,0,6000,6000,0,0,1,14,0,0,0,0,0,12,1,0,0,0,0,0,0,'Xarantaur - Script 2- Say Line 14'), +(@Spirit,0,0,0,54,0,100,0,0,0,0,0,80,@Spirit*100,2,0,0,0,0,1,0,0,0,0,0,0,0,'Stormhoof''s Spirit - Just summoned - Run script'), +(@Spirit*100,9,0,0,0,0,100,0,2000,2000,0,0,69,0,0,0,0,0,0,8,0,0,0,7762.596,-2834.026,1216.85,0,'Stormhoof''s Spirit script - Move to position'), +(@Spirit*100,9,1,0,0,0,100,0,2500,2500,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stormhoof''s Spirit script - Say line 0'), +(@Spirit*100,9,2,0,0,0,100,0,6000,6000,0,0,45,0,1,0,0,0,0,19,@Xarantaur,20,0,0,0,0,0,'Stormhoof''s Spirit script - Set data 0 1 Xarantaur'), +(@Spirit*100,9,3,0,0,0,100,0,6000,6000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stormhoof''s Spirit script - Say line 1'), +(@Spirit*100,9,4,0,0,0,100,0,4500,4500,0,0,1,1,0,0,0,0,0,19,@Xarantaur,20,0,0,0,0,0,'Stormhoof''s Spirit script - Xarantaur say line 1'), +(@Spirit*100,9,5,0,0,0,100,0,7000,7000,0,0,1,2,0,0,0,0,0,19,@Xarantaur,20,0,0,0,0,0,'Stormhoof''s Spirit script - Xarantaur say line 2'), +(@Spirit*100,9,6,0,0,0,100,0,7000,7000,0,0,1,3,0,0,0,0,0,19,@Xarantaur,20,0,0,0,0,0,'Stormhoof''s Spirit script - Xarantaur say line 3'), +(@Spirit*100,9,7,0,0,0,100,0,6000,6000,0,0,45,0,2,0,0,0,0,19,@Xarantaur,20,0,0,0,0,0,'Stormhoof''s Spirit script - Set data 0 2 Xarantaur'), +(@Spirit*100,9,8,0,0,0,100,0,6000,6000,0,0,45,0,3,0,0,0,0,19,@Xarantaur,20,0,0,0,0,0,'Stormhoof''s Spirit script - Set data 0 3 Xarantaur'), +(@Spirit*100,9,9,0,0,0,100,0,6000,6000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stormhoof''s Spirit script - Say line 2'), +(@Spirit*100,9,10,0,0,0,100,0,6000,6000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stormhoof''s Spirit script - Say line 3'), +(@Spirit*100,9,11,0,0,0,100,0,6000,6000,0,0,1,6,0,0,0,0,0,19,@Xarantaur,20,0,0,0,0,0,'Stormhoof''s Spirit script - Xarantaur say line 6'), +(@Spirit*100,9,12,0,0,0,100,0,3000,3000,0,0,5,66,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stormhoof''s Spirit script - Play emote'), +(@Spirit*100,9,13,0,0,0,100,0,3000,3000,0,0,69,0,0,0,0,0,0,8,0,0,0,7765.107,-2832.312,1216.809,0,'Stormhoof''s Spirit script - Move to position'), +(@Spirit*100,9,14,0,0,0,100,0,2500,2500,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stormhoof''s Spirit script - Set orientation'); + +UPDATE `creature_template` SET `faction`=14, `unit_flags`=768 WHERE `entry`=@WindImage; + +DELETE FROM `creature_template_addon` WHERE `entry`=@WindImage; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(@WindImage, 0, 0x2000000, 0x1, ''); -- 30550 diff --git a/sql/updates/world/2014_08_27_02_world_misc.sql b/sql/updates/world/2014_08_27_02_world_misc.sql new file mode 100644 index 00000000000..d97536a836d --- /dev/null +++ b/sql/updates/world/2014_08_27_02_world_misc.sql @@ -0,0 +1,70 @@ +SET @OGUID := 75529; + + +UPDATE `creature_template` SET `AIName`='SmartAi' WHERE `entry`=29525; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=29525 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=30154 AND `source_type`=0 AND `id`=5; + +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(30154, 0, 5, 0, 6, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 103591, 29525, 0, 0, 0, 0, 0, 'Agnetta Tyrsdottar - On Death - Set Data to Zeev Fizzlespark'), +(29525, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 1, 0, 5000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Zeev Fizzlespark - On Data Set - Say Line'), +(29525, 0, 1, 0, 52, 0, 100, 0, 0, 29525, 0, 0, 53, 1, 29525, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Zeev Fizzlespark - On Data Set - Say Line'), +(29525, 0, 2, 0, 40, 0, 100, 0, 8, 29525, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Zeev Fizzlespark - On Reached WP8 - Despawn'); + +DELETE FROM `creature_text` WHERE `entry`=29525; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(29525, 0, 0, 'Thank you, thank you! Time to get away from these crazy blue women!', 12, 0, 100, 0, 0, 0, 'Zeev Fizzlespark',30803); + +DELETE FROM `waypoints` WHERE `entry` =29525; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(29525, 1,6887.515, -1586.146, 821.6108, 'Zeev Fizzlespark'), +(29525, 2,6879.559, -1576.52, 822.1594, 'Zeev Fizzlespark'), +(29525, 3,6864.559, -1565.27, 821.4094, 'Zeev Fizzlespark'), +(29525, 4,6864.395, -1565.045, 821.4877, 'Zeev Fizzlespark'), +(29525, 5,6859.145, -1561.045, 821.4877, 'Zeev Fizzlespark'), +(29525, 6,6847.645, -1552.295, 820.9877, 'Zeev Fizzlespark'), +(29525, 7,6844.395, -1549.795, 820.2377, 'Zeev Fizzlespark'), +(29525, 8,6839.645, -1546.045, 819.7377, 'Zeev Fizzlespark'); + +DELETE FROM `gameobject` WHERE `id` IN(191844,191845); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 191844, 571, 1, 1, 8535.68, -496.9023, 823.1414, 0.4014249, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+1, 191844, 571, 1, 1, 8546.7, -263.9755, 807.7084, 4.886924, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+2, 191845, 571, 1, 1, 8637.927, -217.2614, 570.3714, 0.5759573, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+3, 191844, 571, 1, 1, 8573.364, -92.22021, 673.306, 4.782203, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+4, 191845, 571, 1, 1, 8560.149, -62.62316, 702.3484, 2.740162, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+5, 191845, 571, 1, 1, 8626.088, 33.92166, 572.9097, 5.497789, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+6, 191845, 571, 1, 1, 8614.603, 88.68297, 637.397, 1.832595, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+7, 191844, 571, 1, 1, 8747.084, 9.606879, 296.9369, 2.932139, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+8, 191845, 571, 1, 1, 8579.567, 82.29688, 692.7102, 5.881761, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+9, 191845, 571, 1, 1, 8547.95, -10.12207, 741.0126, 0.06981169, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+10, 191844, 571, 1, 1, 8595.69, 112.1224, 662.7746, 1.727875, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+11, 191844, 571, 1, 1, 8607.703, 209.4077, 665.7949, 4.258607, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+12, 191844, 571, 1, 1, 8611.642, 271.6101, 615.5172, 6.248279, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+13, 191844, 571, 1, 1, 8748.884, 312.8568, 299.133, 6.073746, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+14, 191845, 571, 1, 1, 8621.576, 330.7877, 541.5576, 5.393069, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+15, 191845, 571, 1, 1, 8605.192, 312.1095, 579.5255, 2.251473, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+16, 191844, 571, 1, 1, 8684.777, 359.4482, 428.7368, 4.956738, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+17, 191844, 571, 1, 1, 8789.41, 71.40159, 293.1991, 3.787367, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+18, 191844, 571, 1, 1, 8763.857, -67.66808, 138.1753, 4.677484, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+19, 191844, 571, 1, 1, 8774.313, -173.6759, 149.9866, 1.06465, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+20, 191845, 571, 1, 1, 8789.631, -235.4283, 51.76108, 1.640607, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+21, 191844, 571, 1, 1, 8804.998, -172.7898, 84.4473, 3.47321, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+22, 191844, 571, 1, 1, 8699.403, -518.3983, 548.7347, 2.740162, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+23, 191844, 571, 1, 1, 8576.837, -359.9985, 752.7386, 5.67232, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+24, 191844, 571, 1, 1, 8814.698, 129.815, 148.0139, 3.543024, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+25, 191845, 571, 1, 1, 8843.197, 133.3464, 85.0244, 6.126106, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+26, 191844, 571, 1, 1, 8804.185, 280.4642, 290.4794, 0.4363316, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+27, 191844, 571, 1, 1, 8626.088, 33.92166, 572.9097, 5.497789, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+28, 191845, 571, 1, 1, 8670.649, -96.9744, 480.4034, 4.76475, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+29, 191844, 571, 1, 1, 8532.542, 68.41764, 725.706, 0.2094394, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+30, 191845, 571, 1, 1, 8533.337, -67.05301, 737.9224, 3.769912, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+31, 191845, 571, 1, 1, 8578.229, 145.1865, 697.3944, 0.9773831, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+32, 191844, 571, 1, 1, 8549.121, 307.6241, 663.9405, 0.5759573, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+33, 191845, 571, 1, 1, 8562.427, 317.5042, 614.5561, 6.248279, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+34, 191844, 571, 1, 1, 8518.978, 314.5187, 762.0441, 0.5061446, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+35, 191844, 571, 1, 1, 8748.884, 312.8568, 299.133, 6.073746, 0, 0, 0, 1, 120, 255, 1), -- 191844 (Area: 67) +(@OGUID+36, 191845, 571, 1, 1, 8632.458, -147.1184, 579.8124, 3.665196, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+37, 191845, 571, 1, 1, 8685.321, -255.6193, 550.6371, 4.415683, 0, 0, 0, 1, 120, 255, 1), -- 191845 (Area: 67) +(@OGUID+38, 191844, 571, 1, 1, 8558.689, -286.8528, 704.2544, 2.146753, 0, 0, 0, 1, 120, 255, 1); -- 191844 (Area: 67) diff --git a/sql/updates/world/2014_08_28_00_world_misc.sql b/sql/updates/world/2014_08_28_00_world_misc.sql new file mode 100644 index 00000000000..d12d56de004 --- /dev/null +++ b/sql/updates/world/2014_08_28_00_world_misc.sql @@ -0,0 +1,22 @@ +SET @ENTRY := 28511; + +UPDATE `creature_template` SET `spell1`=51859,`spell2`=51904,`spell3`=52006,`spell4`=0,`spell5`=52694,`unit_flags`=16777224,`InhabitType`=5,`ScriptName`='npc_eye_of_acherus' WHERE `entry` = @ENTRY; + +DELETE FROM `creature_template_addon` WHERE`entry`=@ENTRY; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(@ENTRY, 0, 0, 0x0, 0x1, 0, '51892'); + +DELETE FROM `waypoint_data` WHERE`id`=@ENTRY * 100; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@ENTRY * 100, 0, 2341.571, -5672.797, 538.3942, 0, 0, 1, 0, 100, 0), +(@ENTRY * 100, 1, 1957.396, -5844.105, 273.8667, 0, 0, 1, 0, 100, 0), +(@ENTRY * 100, 2, 1758.007, -5876.785, 166.8667, 0, 0, 1, 0, 100, 0); + +DELETE FROM `creature_text` WHERE`entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES +(@ENTRY, 0, 0, 'The Eye of Acherus launches towards its destination.', 42, 0, 100, 0, 0, 0, 'Eye of Acherus'), +(@ENTRY, 1, 0, 'The Eye of Acherus is in your control.', 42, 0, 100, 0, 0, 0, 'Eye of Acherus'); + +DELETE FROM `spell_script_names` WHERE spell_id=52694; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(52694,'spell_q12641_recall_eye_of_acherus'); diff --git a/sql/updates/world/2014_08_24_00_world_ahbot.sql b/sql/updates/world/2014_08_28_01_world_ahbot.sql index 9a5eab9f393..9a5eab9f393 100644 --- a/sql/updates/world/2014_08_24_00_world_ahbot.sql +++ b/sql/updates/world/2014_08_28_01_world_ahbot.sql |