Skip to content

Instantly share code, notes, and snippets.

@nzatsepilov

nzatsepilov/gist:8834163

Created February 5, 2014 22:04
Show Gist options
  • Save nzatsepilov/8834163 to your computer and use it in GitHub Desktop.
Save nzatsepilov/8834163 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
------------------
----- Zevrax -----
------------------
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '17494';
UPDATE `creature_template` SET `AIName` = 'EventAI', `minmana` = '1020', `maxmana` = '1020', `spell1` = NULL, `spell2` = NULL, `spell3` = NULL, `spell4` = NULL WHERE `entry` = '17494';
-- Фаза 0 (спавн/homeposition)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749401',
'17494',
'1',
'0',
'100',
'0',
'0',
'0',
'0',
'0',
'21',
'0',
'0',
'0',
'22',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Prevent Combat Movement and Set Phase to 0 on Spawn'
) ;
-- Пре-фаза 1 (каст спелла при аггро)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749402',
'17494',
'4',
'0',
'100',
'0',
'0',
'0',
'0',
'0',
'0',
'20791',
'1',
'0',
'23',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Cast Shadowbolt and Set Phase 1 on Aggro'
) ;
-- Фаза 1 (каст спелла Shadowbolt http://www.wowhead.com/spell=20791)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749403',
'17494',
'9',
'5',
'100',
'1',
'0',
'40',
'3500',
'3500',
'11',
'20791',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Cast Shadowbolt (Phase 1)'
) ;
-- Фаза 1 (каст спелла Immolate http://www.wowhead.com/spell=11962)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749404',
'17494',
'0',
'5',
'100',
'1',
'3500',
'4000',
'15000',
'15000',
'11',
'11962',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Cast Immolate (Phase 1)'
) ;
-- Фаза 1 (каст спелла Corruption http://www.wowhead.com/spell=21068)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749405',
'17494',
'0',
'5',
'100',
'1',
'12000',
'12500',
'24000',
'25000',
'11',
'21068',
'1',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Cast Corruption (Phase 1)'
) ;
-- Фаза 1 (каст спелла Curse of Weakness http://www.wowhead.com/spell=17227)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749406',
'17494',
'0',
'5',
'0',
'1',
'1000',
'2000',
'120000',
'120000',
'11',
'17227',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Cast Curse of Weakness (Phase 1)'
) ;
-- Фаза 1 (активация движения при 15% маны)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749407',
'17494',
'3',
'5',
'100',
'0',
'15',
'0',
'0',
'0',
'21',
'1',
'0',
'0',
'23',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'
) ;
-- Фаза 1 (активация движения при дистанции < 35 ядров)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749408',
'17494',
'9',
'5',
'100',
'0',
'35',
'80',
'0',
'0',
'21',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Start Combat Movement at 35 Yards (Phase 1)'
) ;
-- Фаза 1 (предотвращение движения на 15 ярдах)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749409',
'17494',
'9',
'5',
'100',
'0',
'5',
'15',
'0',
'0',
'21',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Prevent Combat Movement at 15 Yards (Phase 1)'
) ;
-- Фаза 1 (активация движения на расстоянии < 5 ярдов)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749410',
'17494',
'9',
'5',
'100',
'0',
'0',
'5',
'0',
'0',
'21',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Start Combat Movement Below 5 Yards (Phase 1)'
) ;
-- Фаза 2 (запас маны < 20%)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749411',
'17494',
'3',
'3',
'100',
'1',
'100',
'20',
'100',
'100',
'23',
'-1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Set Phase 1 when Mana is above 20% (Phase 2)'
) ;
-- Сброс фазы на 0 (эвейд)
INSERT INTO `creature_ai_scripts` (
`id`,
`entryOrGUID`,
`event_type`,
`event_inverse_phase_mask`,
`event_chance`,
`event_flags`,
`event_param1`,
`event_param2`,
`event_param3`,
`event_param4`,
`action1_type`,
`action1_param1`,
`action1_param2`,
`action1_param3`,
`action2_type`,
`action2_param1`,
`action2_param2`,
`action2_param3`,
`action3_type`,
`action3_param1`,
`action3_param2`,
`action3_param3`,
`comment`
)
VALUES
(
'1749412',
'17494',
'7',
'0',
'100',
'0',
'0',
'0',
'0',
'0',
'22',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'Zevrax - Set Phase to 0 on Evade'
) ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment