[CODE]-- Gnome Diver, Dalaran
SET @Diver = 31689;
– Shouldn’t be a vehicle; uses SAI
UPDATE creature_template SET AIName=‘SmartAI’,vehicleid=0,InhabitType=4 WHERE entry=@Diver;
– Model data
UPDATE creature_model_info SET bounding_radius=0.3519,combat_reach=1,gender=0 WHERE modelid=27657;
– Addon data
DELETE FROM creature_template_addon WHERE entry=@Diver;
INSERT INTO creature_template_addon (entry,mount,bytes1,bytes2,emote,auras) VALUES
(@Diver,0,33554432,1,0, ‘59562 0’);
– Reply to emote SmartAI
DELETE FROM smart_scripts WHERE entryorguid=@Diver 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
(@Diver,0,0,0,22,0,100,0,78,5000,5000,0,5,66,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Salute - Salute’),
(@Diver,0,1,0,22,0,100,0,21,5000,5000,0,5,2,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Cheer - Bow’),
(@Diver,0,2,0,22,0,100,0,101,5000,5000,0,5,3,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Wave - Wave’),
(@Diver,0,3,0,22,0,100,0,34,5000,5000,0,5,94,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Dance - Dance’),
(@Diver,0,4,0,22,0,100,0,328,5000,5000,0,5,11,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Flirt - Laugh’),
(@Diver,0,5,0,22,0,100,0,58,5000,5000,0,5,23,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Kiss - Flex’),
(@Diver,0,6,0,22,0,100,0,77,5000,5000,0,5,14,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Rude - Rude’);[/sql]
The InhabitType 4 (flying) is a hack. The npc is inside an aquarium (part of the map, not a GO) but he should be standing still, if we set InhabitType to 1 (ground only) he falls down.
[/CODE]