[5.X.X] Хмелеварня Буйных Портеров - Форум

Страница 1 из 1 1
Модератор форума: Dimitro

Форум » TrinityCore » Патчи / Моды / Фиксы для Trinity » [5.X.X] Хмелеварня Буйных Портеров (Базовое"не близлайк" заселение)

[5.X.X] Хмелеварня Буйных Портеров

Thermaplugg

Database Developer

Репутация: 895

просто оставлю это здесь smile

-- описание
грубый черновой вариант(из того что было) заселение инста Хмелеварня Буйных Портеров (обычка) под JadeCore и не только
- заселение(только нипы и эмоции к ним)
- типа скрипты босов(всех трех)

-- скрины

-- собственно сам код

Код

-- Stormstout Brewery // Non Blizzlike Normal Mode

DELETE FROM `access_requirement` WHERE `mapId`=961;
INSERT INTO `access_requirement` VALUES
(961, 1, 85, 0, 0, 0, 0, 0, 0, '', 'Stormstout Brewery (Entrace)'),
(961, 2, 91, 0, 0, 0, 0, 0, 0, '', 'Stormstout Brewery (Entrace) - Heroic'); -- Close Heroic

DELETE FROM `areatrigger_teleport` WHERE `id` IN (7705, 7755);
INSERT INTO `areatrigger_teleport` VALUES
(7705, 'Stormstout Brewery (Entrance)', 961, -733.359, 1269.48, 117.108, 1.84789),
(7755, 'Stormstout Brewery (Exit)', 870, -709.609, 1264.54, 137.024, 0.32012);

-- Ook-Ook (Normal and Heroic Mode) // Small Script
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `minlevel`=87, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `mindmg`=7000, `maxdmg`=10000, `attackpower`=30000, `dmg_multiplier`=3, `Health_mod`=44, `mechanic_immune_mask`=617299803 ,`flags_extra`=2, `difficulty_entry_2`=76637 WHERE `entry`=56637;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=56637;
INSERT INTO `smart_scripts` VALUES
(56637, 0, 0, 0, 11, 0, 100, 12, 0, 0, 0, 0, 90, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - On Respawn - Emote Sitting'),
(56637, 0, 1, 0, 4, 0, 100, 12, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - On Aggro - Say Text'),
(56637, 0, 2, 0, 0, 0, 100, 12, 10000, 10000, 15000, 15000, 11, 106807, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - On Combat - Cast Ground Pound'),
(56637, 0, 3, 4, 2, 0, 100, 13, 0, 90, 0, 0, 11, 106651, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - at 90% HP - Cast Going Bananas'),
(56637, 0, 4, 0, 61, 0, 100, 12, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - at 90% HP - Say Text'),
(56637, 0, 5, 6, 2, 0, 100, 13, 0, 60, 0, 0, 11, 106651, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - at 60% HP - Cast Going Bananas'),
(56637, 0, 6, 0, 61, 0, 100, 12, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - at 60% HP - Say Text'),
(56637, 0, 7, 8, 2, 0, 100, 13, 0, 30, 0, 0, 11, 106651, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - at 30% HP - Cast Going Bananas'),
(56637, 0, 8, 0, 61, 0, 100, 12, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - at 30% HP - Say Text'),
(56637, 0, 9, 0, 6, 0, 100, 12, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - On Death - Say Text'),
(56637, 0, 10, 11, 7, 0, 100, 12, 0, 0, 0, 0, 78, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - On Evade - Script Reset'),
(56637, 0, 11, 0, 61, 0, 100, 12, 0, 0, 0, 0, 28, 106651, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ook-Ook - On Evade - Remove Going Bananas');

DELETE FROM `creature_text` WHERE `entry`=56637;
INSERT INTO `creature_text` VALUES
(56637, 0, 0, 'Me gonna ook you in the dooker!', 14, 0, 100, 0, 0, 0, 'Ook-Ook - Aggro'),
(56637, 1, 0, 'Get Ooking party started!', 14, 0, 100, 153, 0, 0, 'Ook-Ook - at 90% HP'),
(56637, 2, 0, 'Come on and get your Ook on!', 14, 0, 100, 153, 0, 0, 'Ook-Ook - at 60% HP'),
(56637, 3, 0, 'We gonna Ook all night!', 14, 0, 100, 153, 0, 0, 'Ook-Ook - at 30% HP'),
(56637, 4, 0, 'Ook! Oooook!!', 14, 0, 100, 0, 0, 0, 'Ook-Ook - Death');

-- Sodden Hozen Brawler
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=86, `maxlevel`=86, `faction_A`=16, `faction_H`=16, `mindmg`=5000, `maxdmg`=8000, `attackpower`=25000, `dmg_multiplier`=3, `Health_mod`=7, `flags_extra`=0 WHERE `entry`=59605;
DELETE FROM `creature_template_addon` WHERE `entry`=59605;
INSERT INTO `creature_template_addon` VALUES (59605, 0, 0, 0, 1, 0, '107044'); -- Aura Aquatic Illusion
-- Inflamed Hozen Brawler
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=86, `maxlevel`=86, `faction_A`=16, `faction_H`=16, `mindmg`=5000, `maxdmg`=8000, `attackpower`=25000, `dmg_multiplier`=3, `Health_mod`=6, `flags_extra`=0 WHERE `entry`=56924;
DELETE FROM `creature_template_addon` WHERE `entry`=56924;
INSERT INTO `creature_template_addon` VALUES (56924, 0, 0, 0, 1, 0, '107175'); -- Aura Fiery Illusion
-- Drunken Hozen Brawler
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=86, `maxlevel`=86, `faction_A`=16, `faction_H`=16, `mindmg`=5000, `maxdmg`=8000, `attackpower`=25000, `dmg_multiplier`=3, `Health_mod`=8, `flags_extra`=0 WHERE `entry`=56862;
DELETE FROM `creature_template_addon` WHERE `entry`=56862;
INSERT INTO `creature_template_addon` VALUES (56862, 0, 0, 0, 1, 35, ''); -- Emote Combat
-- Hozen Bouncer
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=1, `maxlevel`=1, `faction_A`=15, `faction_H`=15, `mindmg`=7000, `maxdmg`=10000, `attackpower`=30000, `dmg_multiplier`=3, `Health_mod`=50, `flags_extra`=0 WHERE `entry`=56849;
-- Sleepy Hozen Brawler
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=86, `maxlevel`=86, `faction_A`=15, `faction_H`=15, `mindmg`=5000, `maxdmg`=8000, `attackpower`=25000, `dmg_multiplier`=3, `Health_mod`=5, `flags_extra`=0 WHERE `entry`=56863;
DELETE FROM `creature_template_addon` WHERE `entry`=56863;
INSERT INTO `creature_template_addon` VALUES (56863, 0, 0, 1, 1, 0, '55474'); -- Emote Sitting
-- Hozen Party Animal
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=85, `maxlevel`=85, `faction_A`=15, `faction_H`=15, `mindmg`=3000, `maxdmg`=6000, `attackpower`=20000, `dmg_multiplier`=2, `Health_mod`=2, `flags_extra`=0 WHERE `entry` IN (59684, 57097);
-- Hozen Party Animal
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=85, `maxlevel`=85, `faction_A`=15, `faction_H`=15, `mindmg`=3000, `maxdmg`=6000, `attackpower`=20000, `dmg_multiplier`=2, `Health_mod`=1.5, `flags_extra`=0 WHERE `entry`=56927;

-- Spawned NPC
DELETE FROM `creature` WHERE `map`=961 AND `id` IN (59605, 56924, 56863, 56862, 56927, 56849, 56637);
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `isActive`) VALUES
(@, 56637, 961, 0, 0, 6, 1, 0, 0, -755.478, 1350.81, 147.924, 1.85952, 86400, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Ook-Ook
(@, 56849, 961, 0, 0, 6, 1, 0, 0, -762.142, 1303.43, 147.702, 0.98223, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Hozen Bouncer
(@, 56849, 961, 0, 0, 6, 1, 0, 0, -724.109, 1313.01, 147.702, 2.65906, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -743.342, 1313.28, 147.702, 4.26128, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Hozen Party Animal
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -739.847, 1309.97, 147.696, 3.25754, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -748.229, 1312.01, 147.705, 5.89648, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -748.337, 1307.16, 147.697, 0.64216, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -760.492, 1322.22, 147.714, 2.71562, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -764.526, 1319.36, 147.709, 1.46212, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -761.483, 1327.49, 147.719, 4.00289, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -765.601, 1327.45, 147.719, 5.36162, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -735.406, 1329.56, 147.713, 1.13529, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -731.522, 1328.95, 147.709, 2.19176, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -738.727, 1333.99, 147.719, 5.58468, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -734.743, 1336.89, 147.719, 4.68539, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -776.997, 1336.37, 147.679, 1.33175, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -730.626, 1350.66, 147.697, 2.47439, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -732.832, 1358.12, 147.724, 0.80159, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -739.972, 1378.09, 147.711, 6.26483, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -738.919, 1382.31, 147.695, 5.50143, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -732.405, 1375.41, 147.723, 2.67792, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -733.199, 1380.01, 147.709, 3.78926, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -730.772, 1364.01, 147.728, 4.81421, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -726.939, 1360.85, 147.699, 3.00386, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -781.552, 1344.22, 147.689, 3.16565, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -790.255, 1345.83, 147.728, 6.13446, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -786.993, 1341.71, 147.707, 1.30426, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -792.718, 1362.42, 147.715, 0.24005, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -775.468, 1373.68, 147.728, 2.93319, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -779.798, 1370.36, 147.728, 1.24066, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -783.113, 1373.15, 147.692, 0.32959, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -778.309, 1377.93, 147.728, 4.77102, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -748.542, 1383.64, 147.726, 2.19099, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -746.985, 1387.99, 147.726, 4.30371, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -755.138, 1389.01, 147.722, 5.42055, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -751.511, 1390.26, 147.725, 5.22419, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -770.751, 1387.01, 147.718, 1.66299, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -767.139, 1414.33, 140.579, 2.65813, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -763.318, 1417.79, 142.393, 2.92202, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -763.294, 1422.16, 140.579, 3.23618, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -764.329, 1427.09, 140.579, 3.43646, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -765.613, 1432.04, 143.059, 3.94697, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56927, 961, 0, 0, 6, 1, 0, 0, -773.638, 1433.59, 140.579, 4.18259, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56862, 961, 0, 0, 6, 1, 0, 0, -774.436, 1419.67, 140.579, 1.91278, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Drunken Hozen Brawler
(@, 56862, 961, 0, 0, 6, 1, 0, 0, -776.078, 1425.26, 140.579, 5.00725, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56863, 961, 0, 0, 6, 1, 0, 0, -798.218, 1378.79, 127.791, 1.94287, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Sleepy Hozen Brawler
(@, 56863, 961, 0, 0, 6, 1, 0, 0, -810.274, 1380.54, 127.802, 0.25427, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56863, 961, 0, 0, 6, 1, 0, 0, -803.364, 1400.35, 127.795, 5.53999, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56863, 961, 0, 0, 6, 1, 0, 0, -787.534, 1397.21, 127.798, 5.90913, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56924, 961, 0, 0, 6, 1, 0, 0, -750.809, 1353.82, 119.875, 4.70752, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Inflamed Hozen Brawler
(@, 56924, 961, 0, 0, 6, 1, 0, 0, -761.102, 1350.77, 119.874, 5.31619, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56924, 961, 0, 0, 6, 1, 0, 0, -755.282, 1350.27, 119.896, 5.02169, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59605, 961, 0, 0, 6, 1, 0, 0, -743.597, 1296.06, 117.105, 5.37512, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Sodden Hozen Brawler
(@, 59605, 961, 0, 0, 6, 1, 0, 0, -737.423, 1297.69, 117.105, 4.61328, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0);

-- Hoptallus (Normal and Heroic Mode) // Small Script
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `minlevel`=87, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `mindmg`=7000, `maxdmg`=10000, `attackpower`=30000, `dmg_multiplier`=3, `Health_mod`=33, `mechanic_immune_mask`=617299803, `flags_extra`=2, `difficulty_entry_2`=76717 WHERE `entry`=56717;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=56717;
INSERT INTO `smart_scripts` VALUES
(56717, 0, 0, 0, 4, 0, 100, 12, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hoptallus - On Aggro - Say Text'),
(56717, 0, 1, 2, 0, 0, 100, 12, 10000, 10000, 50000, 50000, 11, 112992, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hoptallus - On Combat - Cast Furlwind'),
(56717, 0, 2, 0, 61, 0, 100, 12, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hoptallus - On Combat - Say Text'),
(56717, 0, 3, 4, 0, 0, 100, 12, 30000, 30000, 50000, 50000, 11, 112944, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Hoptallus - On Combat - Cast Carrot Breath'),
(56717, 0, 4, 0, 61, 0, 100, 12, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hoptallus - On Combat - Say Text'),
(56717, 0, 5, 0, 6, 0, 100, 12, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hoptallus - On Death - Say Text');

DELETE FROM `creature_text` WHERE `entry`=56717;
INSERT INTO `creature_text` VALUES
(56717, 0, 0, 'Oh yeah!', 14, 0, 100, 0, 0, 0, 'Hoptallus - Aggro'),
(56717, 1, 0, 'Gonna spins around!', 14, 0, 100, 0, 0, 0, 'Hoptallus - Furlwind'),
(56717, 2, 0, 'Urp...eats too many carrots...', 14, 0, 100, 0, 0, 0, 'Hoptallus - Carrot Breath'),
(56717, 3, 0, 'You have...turnip...for a head...', 14, 0, 100, 0, 0, 0, 'Hoptallus - Death');

-- Hopper
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=85, `maxlevel`=85, `faction_A`=16, `faction_H`=16, `mindmg`=3000, `maxdmg`=6000, `attackpower`=20000, `dmg_multiplier`=2, `Health_mod`=2, `flags_extra`=0 WHERE `entry` IN (56718, 59464);
-- Bopper
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=85, `maxlevel`=85, `faction_A`=16, `faction_H`=16, `mindmg`=3000, `maxdmg`=6000, `attackpower`=20000, `dmg_multiplier`=2, `Health_mod`=1, `flags_extra`=0 WHERE `entry` IN (59426, 59551);
-- Hopling
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=85, `maxlevel`=85, `faction_A`=16, `faction_H`=16, `mindmg`=3000, `maxdmg`=6000, `attackpower`=20000, `dmg_multiplier`=2, `Health_mod`=0.5, `flags_extra`=0 WHERE `entry` IN (59460, 59461, 59458, 59459, 56631, 60208);

-- Spawned NPC
DELETE FROM `creature` WHERE `map`=961 AND `id` IN (56718, 59460, 59426, 59461, 56717);
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `isActive`) VALUES
(@, 56717, 961, 0, 0, 6, 1, 0, 0, -692.011, 1243.86, 163.794, 1.83128, 86400, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Hoptallus
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -706.596, 1308.66, 163.637, 3.10909, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Hopling
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -709.482, 1305.66, 163.638, 2.95987, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56718, 961, 0, 0, 6, 1, 0, 0, -713.593, 1305.69, 163.631, 2.77137, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Hopper
(@, 59461, 961, 0, 0, 6, 1, 0, 0, -704.388, 1292.66, 163.723, 2.45093, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Hopling
(@, 59461, 961, 0, 0, 6, 1, 0, 0, -707.822, 1291.74, 163.724, 2.46271, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59426, 961, 0, 0, 6, 1, 0, 0, -707.786, 1297.31, 163.681, 2.50591, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Bopper
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -715.329, 1299.18, 163.647, 2.66299, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -719.637, 1295.43, 163.661, 2.17211, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56718, 961, 0, 0, 6, 1, 0, 0, -719.758, 1299.71, 163.639, 2.39202, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59461, 961, 0, 0, 6, 1, 0, 0, -725.033, 1311.48, 163.631, 3.07925, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59461, 961, 0, 0, 6, 1, 0, 0, -725.499, 1307.52, 163.624, 2.79258, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59426, 961, 0, 0, 6, 1, 0, 0, -729.803, 1310.45, 163.639, 2.91117, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -757.971, 1301.29, 163.629, 4.36023, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -760.698, 1301.98, 163.632, 4.43484, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56718, 961, 0, 0, 6, 1, 0, 0, -764.159, 1299.29, 163.622, 4.58014, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59461, 961, 0, 0, 6, 1, 0, 0, -774.038, 1283.24, 163.652, 5.05844, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59461, 961, 0, 0, 6, 1, 0, 0, -769.689, 1283.29, 163.659, 4.87859, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59426, 961, 0, 0, 6, 1, 0, 0, -771.609, 1279.25, 163.687, 5.17311, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -763.537, 1290.57, 163.633, 4.55814, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -758.007, 1287.28, 163.649, 4.02799, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56718, 961, 0, 0, 6, 1, 0, 0, -761.781, 1286.02, 163.649, 4.42462, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59461, 961, 0, 0, 6, 1, 0, 0, -760.083, 1258.76, 163.769, 3.95777, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59461, 961, 0, 0, 6, 1, 0, 0, -762.603, 1260.77, 163.756, 4.11485, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59426, 961, 0, 0, 6, 1, 0, 0, -764.766, 1257.88, 163.763, 4.19732, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -765.089, 1246.99, 163.755, 3.40799, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -763.703, 1244.86, 163.755, 3.22499, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56718, 961, 0, 0, 6, 1, 0, 0, -765.383, 1241.72, 163.755, 2.93047, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -794.005, 1239.37, 155.772, 2.21576, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -794.001, 1243.87, 155.772, 2.68307, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -804.477, 1263.65, 147.695, 1.13662, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59460, 961, 0, 0, 6, 1, 0, 0, -809.767, 1268.02, 147.666, 0.64182, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59426, 961, 0, 0, 6, 1, 0, 0, -799.022, 1243.63, 155.772, 1.84269, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 56718, 961, 0, 0, 6, 1, 0, 0, -805.011, 1268.94, 147.669, 0.66853, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0);

-- Yan-Zhu the Uncasked (Normal and Heroic Mode) // Small Script
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `minlevel`=87, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `mindmg`=7000, `maxdmg`=10000, `attackpower`=30000, `dmg_multiplier`=3, `Health_mod`=44, `mechanic_immune_mask`=617299803, `flags_extra`=2, `difficulty_entry_2`=79479 WHERE `entry`=59479;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=59479;
INSERT INTO `smart_scripts` VALUES
(59479, 0, 0, 1, 11, 0, 100, 12, 0, 0, 0, 0, 11, 114930, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On Respawn - Cast Aura'),
(59479, 0, 1, 2, 61, 0, 100, 12, 0, 0, 0, 0, 11, 114932, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On Respawn - Cast Aura'),
(59479, 0, 2, 0, 61, 0, 100, 12, 0, 0, 0, 0, 11, 114934, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On Respawn - Cast Aura'),
(59479, 0, 3, 4, 4, 0, 100, 12, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On Aggro - Set Phase'),
(59479, 0, 4, 0, 61, 0, 100, 12, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On Aggro - Stop Movement'),
(59479, 0, 6, 0, 9, 1, 100, 12, 5, 35, 2000, 2000, 11, 114548, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On ??? - Cast Bolt'),
(59479, 0, 7, 0, 0, 1, 100, 12, 10000, 10000, 15000, 15000, 11, 106851, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On Combat - Cast Blackout Brew'),
(59479, 0, 8, 0, 0, 1, 100, 12, 70000, 70000, 60000, 60000, 11, 115003, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On Combat - Cast Carbonation'),
(59479, 0, 9, 0, 7, 1, 100, 12, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Yan-Zhu the Uncasked - On Evade - Phase Reset');

-- Bloated Brew Alemental, Stout Brew Alemental
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=86, `maxlevel`=86, `faction_A`=16, `faction_H`=16, `mindmg`=5000, `maxdmg`=8000, `attackpower`=25000, `dmg_multiplier`=3, `Health_mod`=8, `flags_extra`=0 WHERE `entry` IN (59518, 59519);
-- Fizzy Brew Alemental
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=86, `maxlevel`=86, `faction_A`=16, `faction_H`=16, `mindmg`=5000, `maxdmg`=8000, `attackpower`=25000, `dmg_multiplier`=3, `Health_mod`=6, `flags_extra`=0 WHERE `entry`=59520;
-- Yeasty Brew Alemental
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=85, `maxlevel`=85, `faction_A`=16, `faction_H`=16, `mindmg`=3000, `maxdmg`=6000, `attackpower`=20000, `dmg_multiplier`=2, `Health_mod`=3, `flags_extra`=0 WHERE `entry`=66413;
-- Ancestral Brewmaster
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `minlevel`=85, `maxlevel`=85, `faction_A`=35, `faction_H`=35, `mindmg`=3000, `maxdmg`=6000, `attackpower`=20000, `dmg_multiplier`=2, `Health_mod`=0.5, `flags_extra`=0 WHERE `entry` IN (59075, 65375, 65376);
DELETE FROM `creature_template_addon` WHERE `entry` IN (65375, 65376);
INSERT INTO `creature_template_addon` VALUES
(65375, 0, 0, 0, 1, 1, ''), -- Emote Say
(65376, 0, 0, 7, 1, 0, ''); -- Emote Sleeping

-- Spawned NPC
DELETE FROM `creature` WHERE `map`=961 AND `id` IN (59518, 66413, 59075, 65375, 65376, 59520, 59519, 59479);
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `isActive`) VALUES
(@, 59479, 961, 0, 0, 6, 1, 0, 0, -703.426, 1162.78, 167.142, 0.33001, 86400, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Yan-Zhu the Uncasked
(@, 59519, 961, 0, 0, 6, 1, 0, 0, -661.589, 1088.29, 159.699, 3.23518, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Stout Brew Alemental
(@, 59520, 961, 0, 0, 6, 1, 0, 0, -661.454, 1093.96, 159.699, 3.94204, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Fizzy Brew Alemental
(@, 59520, 961, 0, 0, 6, 1, 0, 0, -703.081, 1083.64, 148.197, 2.45843, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59520, 961, 0, 0, 6, 1, 0, 0, -708.642, 1083.59, 148.197, 1.56699, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65376, 961, 0, 0, 6, 1, 0, 0, -753.559, 1161.99, 140.144, 5.92965, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Ancestral Brewmaster
(@, 65376, 961, 0, 0, 6, 1, 0, 0, -710.543, 1141.89, 140.169, 1.16707, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65376, 961, 0, 0, 6, 1, 0, 0, -701.659, 1184.59, 140.168, 5.60064, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65376, 961, 0, 0, 6, 1, 0, 0, -677.189, 1171.49, 140.175, 2.61613, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -751.924, 1150.84, 140.141, 5.97913, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Ancestral Brewmaster
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -744.473, 1148.98, 140.167, 2.99539, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -749.291, 1142.08, 140.144, 5.42778, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -744.079, 1136.47, 140.149, 2.23514, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -730.747, 1166.26, 140.173, 2.87272, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -738.264, 1168.04, 140.172, 5.91221, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -732.787, 1136.15, 140.169, 5.87946, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -727.085, 1134.02, 140.142, 2.66325, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -692.272, 1146.69, 140.169, 0.22537, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -685.449, 1148.79, 140.169, 3.40624, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -674.675, 1157.79, 140.176, 1.12229, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -672.123, 1163.69, 140.176, 4.24033, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -725.128, 1172.42, 140.161, 1.13407, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -722.994, 1177.27, 140.173, 4.30316, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -687.741, 1188.46, 140.166, 0.22772, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 65375, 961, 0, 0, 6, 1, 0, 0, -681.503, 1190.07, 140.168, 3.38895, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59075, 961, 0, 0, 6, 1, 0, 0, -639.163, 1181.87, 140.174, 0.32118, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Ancestral Brewmaster
(@, 59075, 961, 0, 0, 6, 1, 0, 0, -634.813, 1183.21, 140.179, 3.43921, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 66413, 961, 0, 0, 6, 1, 0, 0, -693.369, 1158.95, 140.639, 2.58942, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Yeasty Brew Alemental
(@, 66413, 961, 0, 0, 6, 1, 0, 0, -706.056, 1155.59, 140.639, 1.11601, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 66413, 961, 0, 0, 6, 1, 0, 0, -709.616, 1168.16, 140.639, 5.82526, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 66413, 961, 0, 0, 6, 1, 0, 0, -696.802, 1171.77, 140.639, 4.17199, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0),
(@, 59518, 961, 0, 0, 6, 1, 0, 0, -655.407, 1187.65, 140.103, 0.27887, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0); -- Bloated Brew Alemental

-- Spawned NPC
DELETE FROM `creature` WHERE `map`=961 AND `id` IN (59822, 59704, 59074, 64361);
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `isActive`) VALUES
(@, 64361, 961, 0, 0, 6, 1, 0, 0, -703.022, 1183.06, 167.733, 2.77797, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Chen Stormstout
(@, 59074, 961, 0, 0, 6, 1, 0, 0, -709.718, 1185.04, 167.714, 5.01557, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Uncle Gao
(@, 59704, 961, 0, 0, 6, 1, 0, 0, -725.485, 1278.31, 116.845, 4.20589, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0), -- Chen Stormstout
(@, 59822, 961, 0, 0, 6, 1, 0, 0, -723.629, 1272.09, 116.845, 2.65159, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 0); -- Auntie Stormstout

Сообщение # 1 отредактировано MENZ411 - Суббота, 26.04.2014, 19:09