diff options
| -rw-r--r-- | sql/updates/world/2011_02_05_0_world_sai.sql | 109 |
1 files changed, 109 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_05_0_world_sai.sql b/sql/updates/world/2011_02_05_0_world_sai.sql new file mode 100644 index 00000000000..f68f044e2f1 --- /dev/null +++ b/sql/updates/world/2011_02_05_0_world_sai.sql @@ -0,0 +1,109 @@ +SET @GUID = 208787; -- creature.guid (need 2) + +SET @Diver=31689; -- Gnome Diver +UPDATE `creature_template` SET `AIName`='SmartAI',`vehicleid`=0,`InhabitType`=4 WHERE `entry`=@Diver; -- Gnome Diver +UPDATE `creature_template` SET `InhabitType`=7 WHERE `entry` IN (31719,31768,31769); -- Cosmetic Frenzy, Stabled Hunter Pet -- flying +-- Model data +UPDATE `creature_model_info` SET `bounding_radius`=0.3519,`combat_reach`=1,`gender`=0 WHERE `modelid`=27657; -- Gnome Diver +UPDATE `creature_model_info` SET `bounding_radius`=0.09,`combat_reach`=1,`gender`=2 WHERE `modelid`=23514; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.245,`combat_reach`=1,`gender`=2 WHERE `modelid`=23513; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.35,`combat_reach`=0,`gender`=2 WHERE `modelid`=2955; -- Cosmetic Albino Snake +UPDATE `creature_model_info` SET `bounding_radius`=0.374,`combat_reach`=0,`gender`=2 WHERE `modelid`=27718; -- Cosmetic Smolderweb Hatchling +UPDATE `creature_model_info` SET `bounding_radius`=0.35,`combat_reach`=0,`gender`=2 WHERE `modelid`=2954; -- Cosmetic Ribbon Snake +UPDATE `creature_model_info` SET `bounding_radius`=0.25,`combat_reach`=0,`gender`=2 WHERE `modelid`=5555; -- Cosmetic Cat Set 2/2 +UPDATE `creature_model_info` SET `bounding_radius`=0.35,`combat_reach`=0,`gender`=2 WHERE `modelid`=1206; -- Cosmetic Black Kingsnake +UPDATE `creature_model_info` SET `bounding_radius`=0.3519,`combat_reach`=1,`gender`=1 WHERE `modelid`=25791; -- Breanni +UPDATE `creature_model_info` SET `bounding_radius`=0.35,`combat_reach`=0,`gender`=2 WHERE `modelid`=2957; -- Cosmetic Brown Snake +UPDATE `creature_model_info` SET `bounding_radius`=0.15,`combat_reach`=1,`gender`=2 WHERE `modelid`=3233; -- Cosmetic Cockroach +UPDATE `creature_model_info` SET `bounding_radius`=0.3,`combat_reach`=0,`gender`=2 WHERE `modelid`=27719; -- Cosmetic Worg Pup +UPDATE `creature_model_info` SET `bounding_radius`=0,`combat_reach`=1,`gender`=2 WHERE `modelid`=1141; -- Cosmetic Rat +UPDATE `creature_model_info` SET `bounding_radius`=0.6,`combat_reach`=0,`gender`=2 WHERE `modelid`=27682; -- Cosmetic Pig +UPDATE `creature_model_info` SET `bounding_radius`=0.25,`combat_reach`=0,`gender`=2 WHERE `modelid`=5586; -- Cosmetic Cat Set 1/2 +UPDATE `creature_model_info` SET `bounding_radius`=0.2,`combat_reach`=0,`gender`=2 WHERE `modelid`=27881; -- Cosmetic Turtle +UPDATE `creature_model_info` SET `bounding_radius`=0.2749995,`combat_reach`=0,`gender`=2 WHERE `modelid`=23519; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.28,`combat_reach`=0,`gender`=2 WHERE `modelid`=27690; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.45,`combat_reach`=1,`gender`=2 WHERE `modelid`=4636; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=1.122,`combat_reach`=0,`gender`=2 WHERE `modelid`=2540; -- Stabled Hunter Pet +UPDATE `creature_model_info` SET `bounding_radius`=0.383,`combat_reach`=1,`gender`=1 WHERE `modelid`=25607; -- Tassia Whisperglen + +-- Addon data +DELETE FROM `creature_template_addon` WHERE `entry` IN (@Diver,28951,28690,31719,31742,31709,31795,31714,31729,31710,31711,31733,31796,31732,31735,31728,31740,31741,31755,31756,31757,31758,31768,31769); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@Diver,0,33554432,1,0, '59562 0'), -- Gnome Diver +(28951,0,0,257,0, '60913 0 61354 0'), -- Breanni +(28690,0,0,257,0, NULL), -- Tassia Whisperglen +(31719,0,0,1,0, NULL), -- Cosmetic Frenzy +(31742,0,0,1,0, NULL), -- Cosmetic Prairie Dog +(31709,0,0,1,0, NULL), -- Cosmetic Albino Snake +(31795,0,0,1,0, NULL), -- Cosmetic Smolderweb Hatchling +(31714,0,0,1,0, NULL), -- Cosmetic Ribbon Snake +(31729,0,0,1,0, NULL), -- Cosmetic Cat Set 2/2 +(31710,0,0,1,0, NULL), -- Cosmetic Black Kingsnake +(31711,0,0,1,0, NULL), -- Cosmetic Brown Snake +(31733,0,0,1,0, NULL), -- Cosmetic Cockroach +(31796,0,0,1,0, NULL), -- Cosmetic Worg Pup +(31732,0,0,1,0, NULL), -- Cosmetic Rat +(31735,0,0,1,0, NULL), -- Cosmetic Pig +(31728,0,0,1,0, NULL), -- Cosmetic Cat Set 1/2 +(31740,0,0,1,0, NULL), -- Cosmetic Turtle +(31741,0,0,1,0, NULL), -- Cosmetic Rabbit +(31755,0,0,1,0, NULL), -- Stabled Hunter Pet +(31756,0,0,1,0, NULL), -- Stabled Hunter Pet +(31757,0,0,1,0, NULL), -- Stabled Hunter Pet +(31758,0,0,1,0, NULL), -- Stabled Hunter Pet +(31768,0,0,1,0, NULL), -- Stabled Hunter Pet +(31769,0,0,1,0, NULL); -- Stabled Hunter Pet + +-- Random movement for two of the Stabled Hunter Pets +UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid` IN (97556,97653); + +-- Aura used by all Cosmetic* npcs in Dalaran +-- DELETE FROM `spell_dbc` WHERE `Id`=28782; +-- INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES (28782, 'Dalaran Cosmetic Aura - Unknown effect'); + +-- SAI/Gnome Diver: reply to emotes +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, 'Gnome Diver: 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, 'Gnome Diver: 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, 'Gnome Diver: 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, 'Gnome Diver: 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, 'Gnome Diver: 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, 'Gnome Diver: 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, 'Gnome Diver: Rude - Rude'); + +-- Waypoints for flying birds +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (31768,31769)); +DELETE FROM `creature` WHERE `id` IN (31768,31769); +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES +(@GUID+0,31768,571,1,1,0,0,5864.76025,561.5035,656.350159,3.38593864,120,0,0,1,0,0,2,0,0,0), +(@GUID+1,31769,571,1,1,0,0,5871.1377,556.659363,660.738953,1.44698894,120,0,0,1,0,0,2,0,0,0); +INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES +(@GUID+0,(@GUID+0)*10), +(@GUID+1,(@GUID+1)*10); +DELETE FROM `waypoint_data` WHERE `id` IN ((@GUID+0)*10,(@GUID+1)*10); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +((@GUID+0)*10,00,5865.73,561.7454,656.3502), +((@GUID+0)*10,01,5864.76,561.5035,656.3502), +((@GUID+0)*10,02,5865.858,545.6048,657.8221), +((@GUID+0)*10,03,5856.59,546.2563,657.8221), +((@GUID+0)*10,04,5851.967,553.7063,657.8221), +((@GUID+0)*10,05,5848.848,559.3509,657.8221), +((@GUID+0)*10,06,5855.463,567.5033,657.8221), +((@GUID+0)*10,07,5861.43,566.0272,657.8221), +((@GUID+0)*10,08,5870.177,562.2965,657.8221), +((@GUID+0)*10,09,5872.478,553.6407,657.8221), +((@GUID+0)*10,10,5864.64,545.9483,657.8221), +((@GUID+0)*10,11,5856.267,546.3598,657.8221), +((@GUID+0)*10,12,5851.878,553.7315,657.8221), +((@GUID+0)*10,13,5848.888,559.2279,657.8221), +((@GUID+0)*10,14,5848.888,559.2279,657.8221), +((@GUID+1)*10,0,5856.941,550.4024,656.2946), +((@GUID+1)*10,1,5856.993,551.4011,656.2946), +((@GUID+1)*10,2,5852.679,558.0845,660.739), +((@GUID+1)*10,3,5852.628,548.4319,660.739), +((@GUID+1)*10,4,5862.95,547.2537,660.739), +((@GUID+1)*10,5,5871.105,556.4464,660.739), +((@GUID+1)*10,6,5866.302,565.8504,660.739), +((@GUID+1)*10,7,5857.606,565.6177,660.739), +((@GUID+1)*10,8,5857.606,565.6177,660.739); |