[SAI] Arch Mage Xintor + Lieutenant Commander Thalvos

Convert:

EDIT BIO: new version:

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (16977,16978);
DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (16977,16978); -- clean old EAI
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (16977,16978);
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 
(16977,0,0,0,25,0,100,0,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - prevent combat movement on spawn'),
(16977,0,1,0,4,0,100,0,0,0,0,0,11,20823,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Arch Mage Xintor - cast fireball on aggro'),
(16977,0,2,0,4,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - set phase 1 on aggro'),
(16977,0,3,0,9,1,100,0,0,40,2400,3800,11,20823,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Arch Mage Xintor - cast fireball'),
(16977,0,4,0,3,1,100,0,0,15,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - start normal attack on 15% mana'),
(16977,0,5,0,3,1,100,0,0,15,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - set phase 2 on 15% mana'),
(16977,0,6,0,9,1,100,0,35,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - combatmovement'),
(16977,0,7,0,9,1,100,0,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - combatmovement'),
(16977,0,8,0,9,1,100,0,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - combatmovement'),
(16977,0,9,0,3,1,100,0,30,100,100,100,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - set phase 1 on 30% mana'),
(16977,0,10,0,0,1,50,0,6000,8000,9000,12000,11,15735,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Arch Mage Xintor - cast arcane missles'),
(16977,0,11,0,2,0,100,0,0,50,0,0,11,33245,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - 50% hp - cast ice barrier'),
(16977,0,12,0,2,0,100,0,0,50,0,0,11,27646,0,0,0,0,0,5,0,0,0,0,0,0,0, 'Arch Mage Xintor - 50% hp - cast blizzard'),
(16977,0,13,0,2,0,100,0,0,15,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'Arch Mage Xintor - flee on 15% hp'),
(16977,0,14,0,7,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'Arch Mage Xintor - set phase 0 on evade'),
(16978,0,0,0,0,0,50,0,4000,4000,8000,8000,11,8242,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Lieutenant Commander Thalvos - Cast Shield Slam'),
(16978,0,1,0,0,0,50,0,5000,5000,10000,10000,11,20823,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Lieutenant Commander Thalvos - Cast Strike'),
(16978,0,2,0,25,0,100,0,0,0,0,0,11,27978,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lieutenant Commander Thalvos - Shroud of Death'); -- replaced Shroud of Death with Shroud of Death
[/sql]

SmartAIMgr: Entry 16977 SourceType 0 Event 2 Action 21 uses min/max params wrong (15/0) skipped

linking tho this line:

(16977,0,2,0,3,0,100,0,15,0,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Arch Mage Xintor - combatmovement’),

also we need to find a replacement for Shroud of Death to make him look ghostly like all other mobs in the area…

tried casting a different shroud of death:

27978 does not invis everything so we can use that

EDIT: see top post

than why it is moved to completely when its not 100% working? oO

and i dont see any comment in that fix

is trinity forgetting its standards? /emoticons/default_wink.png

i have already posted that concern in dev forum… and i just moved these to proper section.

He was bugging out cause the EAI script was using 15736, which is the triggered spell, it should have been 15735.

He still needs some TLC to get the movement part touched up as that is not working correctly from what i see in the old EAI script.

Query : UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry IN (16977,16978)
Error Code : 1146

Table ‘site.creature_template’ doesn’t exist

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000


Query : DELETE FROM creature_ai_scripts WHERE creature_id IN (16977,16978)

Error Code : 1146

Table ‘site.creature_ai_scripts’ doesn’t exist

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000


Query : – clean old EAI DELETE FROM smart_scripts WHERE entryorguid IN (16977,16978)

Error Code : 1146

Table ‘site.smart_scripts’ doesn’t exist

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000


Query : INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,`event_flags…

Error Code : 1146

Table ‘site.smart_scripts’ doesn’t exist

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000


0 row(s) affected

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000


check if you have the correct database selected and check your db-revision, it runs fine for me…

Here’s the update for Arch-mage Xintor, test if all phases are actually working correctly now

moved to post 1

Is it normal that Lieutenant Commander Thalvos is only visible when in gm mode?

I posted a bug about this, but I haven’t seen never something like that on a regular creature.

It has something to do with a spell that the npc is using. When you’re on the quest to kill him, you should get a spell that allows you to see him, hence, kill him. Hope that explains your problem.

This is the problem, even with the quest, you can’t see him.

above querys should fix that issue, its something related to gen_shroud_of_death

Ok, tested.

You can close the ticket 856 if you commit that to git.

Just a question, it is me, or your second query has a typo that deletes the content of previous one?

DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (16977); -- clean old EAI DELETE FROM `smart_scripts` WHERE `entryorguid` IN (16977,16978);[/sql]

Check the first post StormByte, Bio updates it as it goes.

merged & updated

Sorry for being a bit heavy, ZxBiohazardZx, you made a typo while merging in this line:

(16977,0,14,0,7,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'Arch Mage Xintor - set phase 0 on evade');

Notice the ; instead of a , there /emoticons/default_smile.png

Update: That query gives 1 warning

thats not being heavy, thats called paying attention and helping out, nice spot there, updated&fixed

Thanks /emoticons/default_smile.png

Last thing: (I hope):

Could this warning:

SHOW WARNINGS;

±--------±-----±--------------------------------------------------------+

| Level | Code | Message |

±--------±-----±--------------------------------------------------------+

| Warning | 1264 | Out of range value for column ‘action_param1’ at row 10 |

±--------±-----±--------------------------------------------------------+

Be harmfull for the behaviour of this SAI?

action_param1 is INT(10) UNSIGNED, but -1 is given as a value in:

(16977,0,9,0,3,1,100,30,100,100,100,0,21,-1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Arch Mage Xintor - set phase 1 on 30% mana'),