API tools faq
paste
Advertisement
bucur35

Untitled

bucur35
Oct 7th, 2014
250
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 6.84 KB | None | 0 0
raw download clone embed print report
  1.    
  2.  
  3.     UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=49244;
  4.     UPDATE `creature_template` SET `gossip_menu_id`=49244 WHERE  `entry`=49244;
  5.     UPDATE `creature_template` SET `npcflag`=1 WHERE  `entry`=49244;
  6.          
  7.     DELETE FROM `npc_text` WHERE `ID`=49244;
  8.     INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`, `WDBVerified`) VALUES
  9.     (49244, 'Rush their positions! Themoose is with us.. our victory is assured!', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 1);
  10.          
  11.     DELETE FROM `gossip_menu_option` WHERE `menu_id`=49244;
  12.     INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
  13.     (49244, 0, 0, 'Im ready to help you captain.', 1, 1, 0, 0, 0, 0, NULL);
  14.          
  15.     DELETE FROM `gossip_menu` WHERE `entry`=49244;
  16.     INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  17.     (49244, 49244);
  18.          
  19.     DELETE FROM `waypoints` WHERE  `entry`=49244;
  20.     INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  21.     (49244, 1, -10984.414, -879.282, 116.566, 'Captain WP 1'),
  22.     (49244, 2, -10995.639, -866.830, 129.477, 'Captain WP 2'),
  23.     (49244, 3, -11002.901, -833.493, 149.487, 'Captain WP 3'),
  24.     (49244, 4, -11031.048, -811.134, 174.932, 'Captain WP 4'),
  25.     (49244, 5, -11036.527, -878.147, 186.028, 'Captain WP 5'),
  26.     (49244, 6, -11083.195, -896.697, 211.222, 'Captain WP 6'),
  27.     (49244, 6, -11072.984, -929.698, 231.142, 'Captain WP 7'),
  28.     (49244, 6, -11080.125, -936.659, 238.426, 'Captain WP 8'),
  29.     (49244, 6, -11119.959, -896.009, 256.455, 'Captain WP 9'),
  30.     (49244, 6, -11186.232, -837.901, 259.966, 'Captain WP 10');
  31.          
  32.     DELETE FROM `smart_scripts` WHERE  `entryorguid`=49244;
  33.     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
  34.     (49244, 0, 0, 1, 62, 0, 100, 0, 41631, 0, 0, 0, 53, 1, 41631, 0, 25551, 300000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 'On Gossip - Start WP'),
  35.     (49244, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 'On Link - Close Gossip'),
  36.     (49244, 0, 2, 0, 40, 0, 100, 0, 10, 0, 0, 0, 33, 49244, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 'On Link - Close Gossip');
  37.          
  38.     DELETE FROM `conditions` WHERE `SourceGroup`=49244;
  39.     INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  40.     (15, 49244, 0, 0, 0, 9, 0, 28486, 0, 0, 0, 0, '', 'show gossip if player has quest');
  41.          
  42.     SET @ID := 49281;
  43.      
  44.     DELETE FROM `creature` WHERE  `id`=@ID;
  45.     INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES (342086, 49281, 1, 1, 1, 0, 0, -11028.4, -731.131, 77.9428, 0.565385, 600, 10, 0, 42, 0, 1, 0, 0, 0);
  46.     (181788, @ID, 1, 1, 1, 0, 0, -11029.5, -816.176, 173.586, 2.9764, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  47.     (181787, @ID, 1, 1, 1, 0, 0, -11024.6, -818.364, 170.085, 2.72087, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  48.     (181786, @ID, 1, 1, 1, 0, 0, -11029, -820.031, 174.756, 2.16028, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  49.     (181785, @ID, 1, 1, 1, 0, 0, -11026.5, -817.164, 171.464, 3.05164, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  50.     (181783, @ID, 1, 1, 1, 0, 0, -11038.4, -873.497, 187.279, 1.11849, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  51.     (181782, @ID, 1, 1, 1, 0, 0, -11044.4, -878.688, 189.63, 1.01104, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  52.     (181781, @ID, 1, 1, 1, 0, 0, -11036.1, -868.955, 186.844, 4.33877, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  53.     (181780, @ID, 1, 1, 1, 0, 0, -11049.8, -894.835, 191.103, 0.739683, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  54.     (181779, @ID, 1, 1, 1, 0, 0, -11044.5, -883.702, 189.295, 0.0271608, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  55.     (181778, @ID, 1, 1, 1, 0, 0, -11142, -893.889, 262.356, 1.20428, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  56.     (181777, @ID, 1, 1, 1, 0, 0, -11143.5, -862.748, 260.951, 5.42797, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  57.     (181776, @ID, 1, 1, 1, 0, 0, -11143.6, -880.375, 262.462, 0.366519, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  58.     (181775, @ID, 1, 1, 1, 0, 0, -11134.1, -907.203, 261.484, 1.20428, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  59.     (181773, @ID, 1, 1, 1, 0, 0, -11122.8, -916.799, 260.583, 1.65806, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  60.     (181772, @ID, 1, 1, 1, 0, 0, -11128.7, -855.106, 261.194, 5.25344, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  61.     (181771, @ID, 1, 1, 1, 0, 0, -11108.7, -856.323, 260.776, 4.27606, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  62.     (181770, @ID, 1, 1, 1, 0, 0, -11119.4, -850.068, 261.836, 4.45059, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  63.     (342084, @ID, 1, 1, 1, 0, 0, -11078.3, -658.838, 77.9435, 1.78668, 600, 10, 0, 42, 0, 1, 0, 0, 0),
  64.     (342085, @ID, 1, 1, 1, 0, 0, -11252.6, -868.013, 152.611, 1.49608, 600, 10, 0, 42, 0, 1, 0, 0, 0);
  65.      
  66.     SET @GUID := 181793;
  67.      
  68.     INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
  69.     (@GUID, 49244, 1, 1, 1, 0, 0, -10969.3, -907.321, 106.724, 2.18166, 120, 0, 0, 1, 0, 0, 0, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!