diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_12_27_00_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_12_27_00_world.sql b/sql/updates/world/3.3.5/2019_12_27_00_world.sql new file mode 100644 index 00000000000..18152fda17f --- /dev/null +++ b/sql/updates/world/3.3.5/2019_12_27_00_world.sql @@ -0,0 +1,12 @@ +-- +UPDATE `creature_addon` SET `auras`="" WHERE `guid` IN (46075, 46076, 46077, 46078, 46079, 46080, 46081, 46082, 46083, 46084, 46085, 46086, 46087, 46088, 46089, 46090, 46091, 46092, 46093, 46094, 46096, 46097, 46098, 46099, 46100, 46101, 46102, 46103, 46104, 46105, 46106, 46107, 46108, 46109, 46110, 46111, 46112, 46113, 46114, 46115, 46116, 46117, 46118, 46119, 46120, 46121, 46122, 46123, 46124, 46125, 46126, 46127, 41065, 41066, 41067, 41068, 41069, 41070, 41071, 41072, 41074, 41076, 41077, 41078, 41080, 41081, 41082, 41083, 41029, 41030, 41031, 41032, 41034, 40438, 36501, 36514, 36169, 36170, 36171, 36172, 36173, 36176, 36177, 36096, 29210, 32204, 32205, 32206, 32207, 32208, 32209, 32211, 27106, 27107, 25797, 24774, 21680, 21682, 20260,20316,20368, 6456, 45350, 46760, 46762, 17821, 17839, 17841, 17844, 17845, 17848, 17858, 17881, 17882, 17892, 17904, 17915, 17916, 17970, 18007, 18013, 18125, 18193, 18257, 18295, 18398, 18406, 18412, 18426, 18467, 19064, 19071, 19076, 19103, 19104, 19126, 19127, 19130, 19156, 19157, 19158, 19159, 19160, 19163, 19164, 19165, 19166, 19169, 19173, 19181, 19185, 29810, 30038, 38319, 38320, 38325, 44762, 44771, 44928, 44940, 44980, 32022, 31866, 9628, 9675, 9711, 48790, 48792, 48968, 48969, 48972, 48973, 48974, 91336, 91337, 8199, 48850, 91026, 91020, 90839, 90840, 90841, 90842, 90843, 90818, 90819, 90820, 90822, 90823, 90824, 90826, 90830, 90831, 90833, 90825, 90832, 90653, 90654, 90655, 90656, 90657, 90658, 90659, 90660, 90661, 90662, 90667, 90668, 90669, 90670, 90671, 90676, 90677, 90678, 90679, 90680, 90681, 90682, 90683, 90684,90631, 90632, 90633, 90635, 90641, 90642, 90643, 90644, 90645, 90647, 90648, 90649, 90636, 47781, 47782, 47783, 47784, 47785, 47786, 47787, 47788, 47789, 47790, 47799, 47800, 47801, 47802, 47803, 90624, 90625, 90626, 90627, 90628, 90629, 90604, 90620, 47736, 47741, 47773, 47774, 47734, 47735, 47739, 47740, 47749, 47750, 47751, 47758, 47759, 47760, 47762, 47765, 47766, 47771, 47772); +UPDATE `smart_scripts` SET `event_type`=23, `event_phase_mask`=0, `event_param2`=0 WHERE `entryorguid` IN (8913) AND `source_type`=0 AND `id`=6; +UPDATE `creature_addon` SET `auras`="52742" WHERE `guid` IN (52447,52449); +UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `guid` IN (52447,52449); +UPDATE `creature` SET `position_x`=458.4017, `position_y`=379.9645, `position_z`=195.0024, `orientation`=6.279088 WHERE `guid`= 52449; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (8409); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (8409) 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 +(8409,0,0,0,23,0,100,0,12544,0,3000,3000,11,12544,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caravan Master Tset - On missing aura - Cast 'Frost Armor'"), +(8409,0,1,0,0,0,100,0,1000,2000,1500,2000,11,21369,64,0,0,0,0,2,0,0,0,0,0,0,0,"Caravan Master Tset - IC - Cast Frostbolt"), +(8409,0,2,0,0,0,100,0,4000,5000,9000,12000,11,11831,1,0,0,0,0,2,0,0,0,0,0,0,0,"Caravan Master Tset - IC - Cast Frost Nova"); |