diff options
| -rw-r--r-- | sql/updates/world/master/2022_09_09_01_world.sql | 163 |
1 files changed, 163 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_09_09_01_world.sql b/sql/updates/world/master/2022_09_09_01_world.sql new file mode 100644 index 00000000000..07d7e3cd9a9 --- /dev/null +++ b/sql/updates/world/master/2022_09_09_01_world.sql @@ -0,0 +1,163 @@ +SET @CGUID := 1051413; +SET @OGUID := 600234; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+28; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 153239, 2175, 10424, 10530, '0', 0, 0, 0, 1, 454.729156494140625, -2102.0869140625, 130.526397705078125, 3.068993806838989257, 7200, 0, 0, 217, 0, 0, 0, 0, 0, 45114), -- Ogre Brute (Area: -Unknown- - Difficulty: 0) +(@CGUID+1, 153581, 2175, 10424, 10530, '0', 0, 0, 0, 1, 509.7882080078125, -1965.4879150390625, 144.52081298828125, 1.031827330589294433, 7200, 0, 0, 279, 0, 0, 0, 0, 0, 45114), -- Grunk (Area: -Unknown- - Difficulty: 0) (Auras: 246849 - -Unknown-) +(@CGUID+2, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 467.7725830078125, -2003.888916015625, 143.8871002197265625, 1.62632906436920166, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+3, 153239, 2175, 10424, 10530, '0', 0, 0, 0, 1, 481.30902099609375, -1975.1649169921875, 143.1035308837890625, 4.41829681396484375, 7200, 0, 0, 217, 0, 0, 0, 0, 0, 45114), -- Ogre Brute (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 526.701416015625, -2001.1024169921875, 142.98779296875, 0.027794346213340759, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+5, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 431.08160400390625, -2025.2257080078125, 132.452880859375, 3.692021131515502929, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+6, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 498.973968505859375, -2046.9288330078125, 144.2474365234375, 0.442503392696380615, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+7, 153239, 2175, 10424, 10530, '0', 0, 0, 0, 1, 457.604156494140625, -2044.4461669921875, 143.176605224609375, 0.766060471534729003, 7200, 10, 0, 217, 0, 1, 0, 0, 0, 45114), -- Ogre Brute (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+8, 153238, 2175, 10424, 10530, '0', 0, 0, 0, 0, 543.55206298828125, -2003.375, 142.649017333984375, 0.492633670568466186, 7200, 0, 0, 50, 0, 0, 0, 0, 0, 45114), -- Tamed Boar (Area: -Unknown- - Difficulty: 0) +(@CGUID+9, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 533.013916015625, -2079.671875, 158.34222412109375, 5.339074611663818359, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+10, 153238, 2175, 10424, 10530, '0', 0, 0, 0, 0, 542.66668701171875, -1997.77783203125, 142.4593658447265625, 5.80480813980102539, 7200, 0, 0, 50, 0, 0, 0, 0, 0, 45114), -- Tamed Boar (Area: -Unknown- - Difficulty: 0) +(@CGUID+11, 153238, 2175, 10424, 10530, '0', 0, 0, 0, 0, 540.1107177734375, -2001.9852294921875, 142.73614501953125, 5.420380115509033203, 7200, 4, 0, 50, 0, 1, 0, 0, 0, 45114), -- Tamed Boar (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+12, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 474.05035400390625, -1932.060791015625, 155.3624725341796875, 5.49060821533203125, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+13, 153238, 2175, 10424, 10530, '0', 0, 0, 0, 0, 539.99957275390625, -1994.472412109375, 142.8594970703125, 2.248490333557128906, 7200, 4, 0, 50, 0, 1, 0, 0, 0, 45114), -- Tamed Boar (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+14, 153239, 2175, 10424, 10530, '0', 0, 0, 0, 1, 479.986114501953125, -2113.833251953125, 132.5481414794921875, 4.657485008239746093, 7200, 0, 0, 217, 0, 0, 0, 0, 0, 45114), -- Ogre Brute (Area: -Unknown- - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+15, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 578.02777099609375, -1979.513916015625, 171.6934051513671875, 1.193202733993530273, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+16, 153239, 2175, 10424, 10530, '0', 0, 0, 0, 1, 578.06768798828125, -2046.3541259765625, 159.592681884765625, 5.034889698028564453, 7200, 0, 0, 217, 0, 0, 0, 0, 0, 45114), -- Ogre Brute (Area: -Unknown- - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+17, 153582, 2175, 10424, 10530, '0', 0, 0, 0, 1, 591.78302001953125, -2010.626708984375, 175.675933837890625, 0.113099128007888793, 7200, 0, 0, 248, 382, 0, 0, 0, 0, 45114), -- Wug (Area: -Unknown- - Difficulty: 0) +(@CGUID+18, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 582.30206298828125, -1974.63720703125, 170.8436126708984375, 5.720551013946533203, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+19, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 559.86456298828125, -2101.833251953125, 161.2359619140625, 1.117576360702514648, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+20, 153238, 2175, 10424, 10530, '0', 0, 0, 0, 0, 595.2257080078125, -2064.536376953125, 161.243377685546875, 0.601261317729949951, 7200, 0, 0, 50, 0, 0, 0, 0, 0, 45114), -- Tamed Boar (Area: -Unknown- - Difficulty: 0) (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+21, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 592.87152099609375, -2062.473876953125, 160.633148193359375, 5.45097970962524414, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+22, 154103, 2175, 10424, 10530, '0', 0, 0, 0, 0, 602.060302734375, -2062.95703125, 159.5788421630859375, 2.146738052368164062, 7200, 0, 0, 205, 0, 0, 0, 0, 0, 45114), -- Ogre Chef (Area: -Unknown- - Difficulty: 0) (Auras: 299441 - -Unknown-) +(@CGUID+23, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 571.03643798828125, -2105.01220703125, 160.8884735107421875, 4.798206806182861328, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+24, 153239, 2175, 10424, 10530, '0', 0, 0, 0, 1, 603.23089599609375, -2121.41845703125, 158.9243316650390625, 3.034203290939331054, 7200, 0, 0, 217, 0, 0, 0, 0, 0, 45114), -- Ogre Brute (Area: -Unknown- - Difficulty: 0) +(@CGUID+25, 153242, 2175, 10424, 10530, '0', 0, 0, 0, 0, 649.20660400390625, -2064.651123046875, 159.3798828125, 2.090809583663940429, 7200, 0, 0, 149, 382, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) +(@CGUID+26, 153239, 2175, 10424, 10530, '0', 0, 0, 0, 1, 675.47222900390625, -2036.986083984375, 171.5338134765625, 4.335721492767333984, 7200, 0, 0, 217, 0, 0, 0, 0, 0, 45114), -- Ogre Brute (Area: -Unknown- - Difficulty: 0) +(@CGUID+27, 153583, 2175, 10424, 10530, '0', 0, 0, 0, 1, 663.19268798828125, -2127.892333984375, 161.383514404296875, 5.686066150665283203, 7200, 0, 0, 310, 0, 0, 0, 0, 0, 45114), -- Jugnug (Area: -Unknown- - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+28, 153239, 2175, 10424, 10530, '0', 0, 0, 0, 1, 732.875, -2071.0869140625, 120.14874267578125, 5.224806785583496093, 7200, 0, 0, 217, 0, 0, 0, 0, 0, 45114); -- Ogre Brute (Area: -Unknown- - Difficulty: 0) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+28; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+14, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Ogre Brute - 145953 - Cosmetic - Sleep Zzz +(@CGUID+0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Ogre Brute +(@CGUID+5, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Ogre Shadowcaster - 145953 - Cosmetic - Sleep Zzz +(@CGUID+6, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Ogre Brute +(@CGUID+3, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Ogre Brute +(@CGUID+2, 0, 0, 0, 0, 28, 0, 0, 0, 0, ''), -- Ogre Shadowcaster +(@CGUID+12, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Ogre Shadowcaster - 145953 - Cosmetic - Sleep Zzz +(@CGUID+9, 0, 0, 0, 0, 28, 0, 0, 0, 0, ''), -- Ogre Shadowcaster +(@CGUID+23, 0, 0, 8, 0, 0, 0, 0, 0, 0, ''), -- Ogre Shadowcaster +(@CGUID+16, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Ogre Brute - 145953 - Cosmetic - Sleep Zzz +(@CGUID+21, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Ogre Brute +(@CGUID+20, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '145363'), -- Tamed Boar - 145363 - Permanent Feign Death (Stun, Untrackable, Immune) +(@CGUID+24, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Ogre Brute +(@CGUID+25, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- Ogre Shadowcaster +(@CGUID+18, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Ogre Shadowcaster - 145953 - Cosmetic - Sleep Zzz +(@CGUID+15, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- Ogre Shadowcaster +(@CGUID+19, 0, 0, 0, 1, 378, 0, 0, 0, 0, ''), -- Ogre Shadowcaster +(@CGUID+26, 0, 0, 0, 1, 378, 0, 0, 0, 0, ''); -- Ogre Brute + +-- Creature Addon Template +DELETE FROM `creature_template_addon` WHERE `entry` IN (153583 /*153583 (Jugnug) - Cosmetic - Sleep Zzz*/, 153582 /*153582 (Wug)*/, 153242 /*153242 (Ogre Shadowcaster)*/, 154103 /*154103 (Ogre Chef) - -Unknown-*/, 153581 /*153581 (Grunk) - -Unknown-*/); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(153583, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- 153583 (Jugnug) - Cosmetic - Sleep Zzz +(153582, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 153582 (Wug) +(153242, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- 153242 (Ogre Shadowcaster) +(154103, 0, 0, 0, 1, 0, 0, 0, 0, 0, '299441'), -- 154103 (Ogre Chef) - -Unknown- +(153581, 0, 0, 0, 1, 0, 0, 0, 0, 0, '246849'); -- 153581 (Grunk) - -Unknown- + +-- Creature Template +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=2057, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=153583; -- Jugnug +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=2057, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=154103; -- Ogre Chef +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=2057, `BaseAttackTime`=1500, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=153582; -- Wug +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=2057, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=153238; -- Tamed Boar +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=2057, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=153242; -- Ogre Shadowcaster +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=2057, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=153581; -- Grunk +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=2057, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=153239; -- Ogre Brute + +-- GameObject Template +DELETE FROM `gameobject_template` WHERE `entry`=351477; +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(351477, 10, 14627, 'Catapult', 'questinteract', 'Placing', '', 1, 2173, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 35196, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 956, 45114); -- Catapult + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+3; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 351477, 2175, 10424, 10530, '0', 0, 0, 463.779510498046875, -1997.0816650390625, 143.712860107421875, 2.96053171157836914, 0, 0, 0.995904922485351562, 0.09040689468383789, 7200, 255, 1, 45114), -- Catapult (Area: -Unknown- - Difficulty: 0) +(@OGUID+1, 351477, 2175, 10424, 10530, '0', 0, 0, 489.869781494140625, -2051.572998046875, 143.9427032470703125, 3.69792795181274414, 0, 0, -0.96156024932861328, 0.274594068527221679, 7200, 255, 1, 45114), -- Catapult (Area: -Unknown- - Difficulty: 0) +(@OGUID+2, 351477, 2175, 10424, 10530, '0', 0, 0, 610.732666015625, -2118.416748046875, 158.92596435546875, 4.408715248107910156, 0, 0, -0.8059244155883789, 0.592018485069274902, 7200, 255, 1, 45114), -- Catapult (Area: -Unknown- - Difficulty: 0) +(@OGUID+3, 351477, 2175, 10424, 10530, '0', 0, 0, 535.9757080078125, -2085.546875, 158.3209686279296875, 4.0296630859375, 0, 0, -0.90302562713623046, 0.429586708545684814, 7200, 255, 1, 45114); -- Catapult (Area: -Unknown- - Difficulty: 0) + +-- Creature Text +DELETE FROM `creature_text` WHERE `CreatureID`= 154103; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(154103, 0, 0, 'This gonna be off hook!', 12, 0, 100, 0, 0, 0, 0, 0, 'Ogre Chef'), +(154103, 1, 0, 'Me gonna take everyone on ride to flavor... flavor... uh. Flavor place!', 12, 0, 100, 0, 0, 0, 0, 0, 'Ogre Chef'); + +-- Waypoints for CGUID+7 +SET @PATH := @CGUID+7 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 433.2153, -2065.714, 131.6825, NULL, 0), +(@PATH, 1, 421.6146, -2073.545, 127.4143, NULL, 4047), +(@PATH, 2, 433.2153, -2065.714, 131.6825, NULL, 0), +(@PATH, 3, 449.408, -2052.332, 140.1065, NULL, 0), +(@PATH, 4, 457.6042, -2044.446, 143.1766, NULL, 3797), +(@PATH, 5, 449.408, -2052.332, 140.1065, NULL, 0); + +UPDATE `creature` SET `position_x`= 433.2153, `position_y`= -2065.714, `position_z`= 131.6825, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+7; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+7; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+7, @PATH, 1); + +-- Waypoints for CGUID+22 +SET @PATH := @CGUID+22 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 599.7882, -2059.458, 159.6127, NULL, 0), +(@PATH, 1, 601.1042, -2056.816, 159.5922, NULL, 8568), +(@PATH, 2, 592.4792, -2051.382, 159.6127, NULL, 4460), +(@PATH, 3, 604.8143, -2067.198, 159.5378, NULL, 6575); + +UPDATE `creature` SET `position_x`= 599.7882, `position_y`= -2059.458, `position_z`= 159.6127, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+22; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+22; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `auras`) VALUES +(@CGUID+22, @PATH, 1, '299441'); + + -- Ogre Chef smart ai +SET @ENTRY := 154103; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +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 +(@ENTRY, 0, 0, 0, 34, 0, 100, 0, 2, 1, 0, 0, 80, 15410300, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 1 - Self: Start timed action list id #15410300 (update out of combat)'), +(@ENTRY, 0, 1, 0, 34, 0, 100, 0, 2, 2, 0, 0, 80, 15410301, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 2 - Self: Start timed action list id #15410301 (update out of combat)'), +(@ENTRY, 0, 2, 0, 34, 0, 100, 0, 2, 3, 0, 0, 80, 15410302, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 3 - Self: Start timed action list id #15410302 (update out of combat)'); + + -- Timed list 15410300 smart ai +SET @ENTRY := 15410300; +DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY; +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 +(@ENTRY, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Set stand state to KNEEL'), +(@ENTRY, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 90, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 6 seconds - Self: Set stand state to STAND'), +(@ENTRY, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Talk 1 to Self'); + + -- Timed list 15410301 smart ai +SET @ENTRY := 15410301; +DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY; +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 +(@ENTRY, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 17, 69, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Set emote state to 69'), +(@ENTRY, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 2 seconds - Self: Set emote state to 0'); + + -- Timed list 15410302 smart ai +SET @ENTRY := 15410302; +DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY; +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 +(@ENTRY, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 17, 69, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Set emote state to 69'), +(@ENTRY, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 2 seconds - Self: Set emote state to 0'), +(@ENTRY, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Talk 0 to Self'); + + -- Ogre Shadowcaster smart ai +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = -(@CGUID+4); +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = 153242; +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 +(-(@CGUID+4), 0, 0, 0, 1, 0, 100, 0, 0, 0, 7000, 7000, 5, 11, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 7 seconds (0s initially) (OOC) - Self: Play emote 11'), +(-(@CGUID+4), 0, 1, 0, 1, 0, 100, 0, 3000, 3000, 7000, 7000, 5, 25, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 7 seconds (3s initially) (OOC) - Self: Play emote 25'); |