diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-06-16 17:52:54 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-01-29 21:51:03 +0100 |
| commit | 5baf6ea4d95d5690272a83175c5a47ceefbc0c06 (patch) | |
| tree | f1150958170a247363af5198d9b08bd10f8d0fab /sql | |
| parent | 5d8172f2d751f10cda035cfed48ec5495b1cabe9 (diff) | |
Merge branch '3.3.5-frogger' into 3.3.5 (PR #17261)
(cherry picked from commit 90ff3ce8c8256796cb637fba52e8ae38a0751176)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_01_29_17_world_2016_06_16_00_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_29_17_world_2016_06_16_00_world.sql b/sql/updates/world/master/2017_01_29_17_world_2016_06_16_00_world.sql new file mode 100644 index 00000000000..f6958ad4dc7 --- /dev/null +++ b/sql/updates/world/master/2017_01_29_17_world_2016_06_16_00_world.sql @@ -0,0 +1,16 @@ +-- delete frogger spawn locations from `creature`, move them to `creature_summon_groups` +SET @FROGGER = 16027; +DELETE FROM `creature` WHERE `id` = @FROGGER; +DELETE FROM `creature_summon_groups` WHERE `summonerId`=533 AND `summonerType`=2; +INSERT INTO `creature_summon_groups` (`summonerType`,`summonerId`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`) VALUES +(2,533,0,@FROGGER,3175.281,-3134.764,293.4368,4.244924,3,7500), +(2,533,1,@FROGGER,3154.581,-3126.18 ,293.5911,4.430199,3,7500), +(2,533,2,@FROGGER,3128.622,-3119.604,293.4113,4.738929,3,7500); +DELETE FROM `waypoint_data` WHERE `id` BETWEEN @FROGGER*10+0 AND @FROGGER*10+2; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@FROGGER*10+0,1,3158.253,-3163.889,293.3027), +(@FROGGER*10+1,1,3145.881,-3158.563,293.3215), +(@FROGGER*10+2,1,3130.79 ,-3156.624,293.3239); +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN -76313 AND -76311 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@FROGGER AND `source_type`=0 AND `id` BETWEEN 2 AND 5; +UPDATE `creature_template` SET `unit_flags`=(`unit_flags`|256) WHERE `entry`=@FROGGER; |