diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/dev/world_database.sql | 27 | ||||
| -rw-r--r-- | sql/updates/world/2014_08_26_05_world_sai.sql | 27 | ||||
| -rw-r--r-- | sql/updates/world/2014_08_26_06_world_creature_stats.sql | 74 | ||||
| -rw-r--r-- | sql/updates/world/2014_08_26_07_world_creature_stats.sql | 75 | ||||
| -rw-r--r-- | sql/updates/world/2014_08_26_08_world_creature_template.sql | 17 | ||||
| -rw-r--r-- | sql/updates/world/2014_08_27_00_world_misc.sql | 70 |
6 files changed, 275 insertions, 15 deletions
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/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_misc.sql b/sql/updates/world/2014_08_27_00_world_misc.sql new file mode 100644 index 00000000000..d97536a836d --- /dev/null +++ b/sql/updates/world/2014_08_27_00_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) |