diff options
| -rw-r--r-- | sql/updates/world/2014_12_27_00_world.sql | 73 |
1 files changed, 73 insertions, 0 deletions
diff --git a/sql/updates/world/2014_12_27_00_world.sql b/sql/updates/world/2014_12_27_00_world.sql new file mode 100644 index 00000000000..d1273193738 --- /dev/null +++ b/sql/updates/world/2014_12_27_00_world.sql @@ -0,0 +1,73 @@ +-- +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE entry IN (32451); + +UPDATE `creature` SET `modelid`=0, movementType=2 WHERE guid IN (114330, 114331); + +DELETE FROM creature_addon WHERE guid = 114331; +INSERT INTO creature_addon (guid, path_id, mount, bytes1, bytes2, emote,auras) VALUES (114331, 1143310, 0, 0, 1, 0, ''); + +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (32451); +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 +(32451, 0, 0, 0, 1, 0, 100, 0, 5000, 5000, 120000, 120000, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Dalaran Citizen - Ooc - talk'); + +DELETE FROM waypoint_data WHERE id=1143310; +INSERT INTO waypoint_data (id, POINT, position_x, position_y, position_z, orientation, delay, move_type, ACTION, action_chance, wpguid) VALUES +(1143310, 1, 5961.356445, 661.699219, 641.721252, 0, 0, 0, 0, 100, 0), +(1143310, 2, 5954.011230, 657.709167, 641.991577, 0, 0, 0, 0, 100, 0), +(1143310, 3, 5947.983887, 658.844055, 642.101562, 0, 0, 0, 0, 100, 0), +(1143310, 4, 5950.894043, 662.109314, 641.363831, 0, 0, 0, 0, 100, 0), +(1143310, 5, 5959.004395, 674.209778, 640.880432, 0, 0, 0, 0, 100, 0), +(1143310, 6, 5961.065430, 680.407043, 640.494263, 0, 0, 0, 0, 100, 0), +(1143310, 7, 5962.776367, 679.769470, 640.680603, 0, 0, 0, 0, 100, 0), +(1143310, 8, 5963.701172, 675.173035, 640.749817, 0, 0, 0, 0, 100, 0), +(1143310, 9, 5963.879883, 666.781982, 641.512024, 0, 20000, 0, 0, 100, 0); + +DELETE FROM creature_text WHERE entry IN (32451); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(32451, 0, 0, 'She said to meet her right here... maybe I''m in the wrong place?', 12, 0, 100, 1, 0, 0, 'Dalaran Citizen', 33069), +(32451, 0, 1, 'Luckily, the Lich King''s grasp has not reached Dalaran yet.', 12, 0, 100, 1, 0, 0, 'Dalaran Citizen', 33068), +(32451, 0, 2, 'Sometimes it''s nice to get away from the sanctum and get some fresh air.', 12, 0, 100, 1, 0, 0, 'Dalaran Citizen', 33067); + +UPDATE `creature` SET movementType=2 WHERE guid IN (28686); + +DELETE FROM creature_addon WHERE guid IN (28686); +INSERT INTO creature_addon (guid, path_id, mount, bytes1, bytes2, emote,auras) +VALUES (28686, 286860, 0, 0, 0, 0, ''); + +DELETE FROM waypoint_data WHERE id IN (286860); +INSERT INTO waypoint_data (id, POINT, position_x, position_y, position_z, orientation, delay, move_type, ACTION, action_chance, wpguid)VALUES +(286860, 1, 5960.950195, 598.314026, 650.627014, 0, 0, 0, 0, 100, 0), +(286860, 2, 5957.295898, 617.082153, 650.627258, 0, 0, 0, 0, 100, 0), +(286860, 3, 5894.468262, 657.878052, 644.688843, 0, 0, 0, 0, 100, 0), +(286860, 4, 5823.077637, 714.962402, 641.066895, 0, 0, 0, 0, 100, 0), +(286860, 5, 5799.794922, 719.503174, 640.661865, 0, 0, 0, 0, 100, 0), +(286860, 6, 5770.590820, 703.946777, 641.473755, 0, 0, 0, 0, 100, 0), +(286860, 7, 5728.678223, 659.602661, 645.874878, 0, 0, 0, 0, 100, 0), +(286860, 8, 5716.125977, 657.985718, 646.207947, 0, 0, 0, 0, 100, 0), +(286860, 9, 5701.286621, 654.542480, 646.277710, 0, 0, 0, 0, 100, 0), +(286860, 10, 5697.024902, 648.178040, 646.409180, 0, 0, 0, 0, 100, 0), +(286860, 11, 5728.723633, 617.990295, 647.119080, 0, 0, 0, 0, 100, 0), +(286860, 12, 5764.286621, 595.154358, 649.794617, 0, 0, 0, 0, 100, 0), +(286860, 13, 5771.400391, 598.777588, 650.299805, 0, 0, 0, 0, 100, 0), +(286860, 14, 5798.370605, 631.354919, 647.415161, 0, 20000, 0, 0, 100, 0), +(286860, 15, 5809.011719, 632.435669, 647.466370, 0, 0, 0, 0, 100, 0), +(286860, 16, 5813.840332, 639.437012, 647.445251, 0, 0, 0, 0, 100, 0), +(286860, 17, 5812.633301, 647.708679, 647.411682, 0, 0, 0, 0, 100, 0), +(286860, 18, 5837.737305, 679.004089, 643.481323, 0, 0, 0, 0, 100, 0), +(286860, 19, 5863.233887, 672.251282, 644.026489, 0, 0, 0, 0, 100, 0), +(286860, 20, 5872.090332, 660.963562, 644.639648, 0, 0, 0, 0, 100, 0), +(286860, 21, 5871.882812, 655.302795, 645.210327, 0, 0, 0, 0, 100, 0), +(286860, 22, 5866.628906, 656.807068, 645.358337, 0, 0, 0, 0, 100, 0), +(286860, 23, 5858.618164, 665.766174, 647.507935, 0, 0, 0, 0, 100, 0), +(286860, 24, 5854.410645, 663.378418, 647.491699, 0, 0, 0, 0, 100, 0), +(286860, 25, 5853.316406, 646.056763, 647.511597, 0, 0, 0, 0, 100, 0), +(286860, 26, 5855.305664, 646.037170, 647.511597, 0, 20000, 0, 0, 100, 0), +(286860, 27, 5853.801270, 644.892761, 647.511597, 0, 0, 0, 0, 100, 0), +(286860, 28, 5854.399902, 639.586365, 647.511597, 0, 0, 0, 0, 100, 0), +(286860, 29, 5861.342773, 632.158997, 647.913147, 0, 0, 0, 0, 100, 0), +(286860, 30, 5873.931152, 637.613953, 646.993347, 0, 0, 0, 0, 100, 0), +(286860, 31, 5888.598145, 639.828796, 646.219421, 0, 0, 0, 0, 100, 0), +(286860, 32, 5911.427246, 634.141296, 645.621460, 0, 0, 0, 0, 100, 0), +(286860, 33, 5944.164062, 622.176941, 650.655151, 0, 0, 0, 0, 100, 0), +(286860, 34, 5958.649414, 608.832092, 650.627136, 0, 0, 0, 0, 100, 0), +(286860, 35, 5960.950195, 598.314026, 650.627014, 0, 20000, 0, 0, 100, 0); |