API tools faq
paste
image

Light's Hope Chapel some...

image
Jan 21st, 2012
448
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 22.97 KB | None | 0 0
raw download clone embed print report
  1. -- ARGENT SENTRY
  2. DELETE FROM `creature` WHERE `id`='16378';
  3. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  4. VALUES
  5. ('16378', '0', '1', '1', '0', '0', '2308.77', '-5344.67', '91.6577', '2.32129', '610', '0', '0', '121500', '0', '0', '0'),
  6. ('16378', '0', '1', '1', '0', '0', '2182.43', '-5303.38', '101.613', '2.0615', '610', '0', '0', '121500', '0', '0', '0'),
  7. ('16378', '0', '1', '1', '0', '0', '2275.17', '-5394.57', '86.5703', '0.447865', '610', '3', '0', '121500', '0', '0', '1'),
  8. ('16378', '0', '1', '1', '0', '0', '2280.05', '-5292.46', '83.7396', '4.77984', '610', '0', '0', '121500', '0', '0', '0'), -- movement
  9. ('16378', '0', '1', '1', '0', '0', '2284.01', '-5291.78', '83.7781', '4.78055', '610', '0', '0', '121500', '0', '0', '0'), -- movement
  10. ('16378', '0', '1', '1', '0', '0', '2342.51', '-5371.9', '86.1964', '2.32234', '610', '3', '0', '121500', '0', '0', '1'),
  11. ('16378', '0', '1', '1', '0', '0', '2213.99', '-5308.82', '87.046', '0.848268', '610', '5', '0', '121500', '0', '0', '1'),
  12. ('16378', '0', '1', '1', '0', '0', '2263.06', '-5346.17', '87.0119', '1.6057', '610', '0', '0', '121500', '0', '0', '0'),
  13. ('16378', '0', '1', '1', '0', '0', '2354.78', '-5315.54', '86.4626', '1.5814', '610', '3', '0', '121500', '0', '0', '1'),
  14. ('16378', '0', '1', '1', '0', '0', '2287.33', '-5281.58', '82.3207', '1.69297', '610', '0', '0', '121500', '0', '0', '0'),
  15. ('16378', '0', '1', '1', '0', '0', '2222.83', '-5356.57', '93.6498', '1.26527', '610', '5', '0', '121500', '0', '0', '1'),
  16. ('16378', '0', '1', '1', '0', '0', '2317.23', '-5353.55', '87.8866', '3.64935', '610', '3', '0', '121500', '0', '0', '1'),
  17. ('16378', '0', '1', '1', '0', '0', '2297.88', '-5352.6', '91.6577', '2.07694', '610', '0', '0', '121500', '0', '0', '0'),
  18. ('16378', '0', '1', '1', '0', '0', '2320.16', '-5295.26', '82.0207', '3.78736', '610', '0', '0', '121500', '0', '0', '0'),
  19. ('16378', '0', '1', '1', '0', '0', '2226', '-5292.55', '81.349', '1.24343', '610', '5', '0', '121500', '0', '0', '1'),
  20. ('16378', '0', '1', '1', '0', '0', '2323', '-5326.13', '82.0478', '2.51327', '610', '0', '0', '121500', '0', '0', '0'),
  21. ('16378', '0', '1', '1', '0', '0', '2245.63', '-5341.06', '86.6369', '1.44862', '610', '0', '0', '121500', '0', '0', '0'),
  22. ('16378', '0', '1', '1', '0', '0', '2274.5', '-5340.08', '87.6035', '2.20322', '610', '0', '0', '121500', '0', '0', '0'),
  23. ('16378', '0', '1', '1', '0', '0', '2330.09', '-5302.7', '82.0478', '3.78736', '610', '0', '0', '121500', '0', '0', '0'),
  24. ('16378', '0', '1', '1', '0', '0', '2317.07', '-5288.9', '82.1457', '3.63029', '610', '0', '0', '121500', '0', '0', '0'),
  25. ('16378', '0', '1', '1', '0', '0', '2288.8', '-5319.14', '88.9963', '2.19912', '610', '0', '0', '121500', '0', '0', '0'),
  26. ('16378', '0', '1', '1', '0', '0', '2281.74', '-5323.96', '89.2463', '2.21657', '610', '0', '0', '121500', '0', '0', '0'),
  27. ('16378', '0', '1', '1', '0', '0', '2272.92', '-5280.93', '82.1957', '1.67552', '610', '0', '0', '121500', '0', '0', '0');
  28. UPDATE creature_template SET `modelid2` = "16148", `modelid3` = "16149", `modelid4` = "16150", `minlevel` = "70", `minhealth` = "121500", `maxhealth` = "121500", `armor` = "6740", `faction_A` = "794", `faction_H` = "794", `speed_run` = "2.28571", `mindmg` = "390", `maxdmg` = "585", `attackpower` = "146", `dmg_multiplier` = "2", `baseattacktime` = "3000", `rangeattacktime` = "3000", `unit_flags` = "33280", `minrangedmg` = "312", `maxrangedmg` = "468", `rangedattackpower` = "117", `spell1` = "25821", `spell2` = "18328", `spell3` = "19643", `spell4` = "23337", `AIName` = "EventAI", `movementId` = "199" WHERE entry=16378;
  29. INSERT INTO `creature_template_addon` () VALUES
  30. ('16378', '0', '0', '1', '16', '0', '0', '18950');
  31.  
  32. -- NÉMI AI
  33. INSERT INTO `creature_ai_scripts` (`creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`)
  34. VALUES
  35. ('16378', '9', '0', '100', '1', '0', '5', '8000', '14000', '11', '15618', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', 'Argent Sentry - Cast Snap Kick'),
  36. ('16378', '0', '0', '100', '1', '4000', '6000', '7000', '9000', '11', '19643', '1', '1', '40', '1', '0', '0', '0', '0', '0', '0', 'Argent Sentry - Cast Mortal Strike and Set Melee Weapon Model'),
  37. ('16378', '0', '0', '100', '1', '1000', '3000', '9000', '12000', '11', '18328', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Argent Sentry - Cast Incapacitating Shout'),
  38. ('16378', '9', '0', '100', '1', '20', '45', '2300', '3900', '11', '23337', '1', '0', '40', '2', '0', '0', '0', '0', '0', '0', 'Argent Sentry - Cast Shoot and Set Ranged Weapon Model'),
  39. ('16378', '4', '0', '100', '0', '0', '0', '0', '0', '11', '25821', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Argent Sentry - Cast Charge on Aggro');
  40.  
  41.  
  42. -- ARGENT OUTFITTER
  43. DELETE FROM `creature` WHERE `id`='16787';
  44.  
  45. -- ARGENT GUARD
  46. DELETE FROM `creature` WHERE `id`='11099';
  47.  
  48. -- [11033] - Smokey LaRue
  49. UPDATE `creature` SET `position_x`='2303.41', `position_y`='-5305.53', `position_z`='82.0796', `orientation`='2.19912', `curhealth`='3398', `curmana`='0' WHERE `id`='11033';
  50. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "3398", `maxhealth` = "3398", `armor` = "3221", `npcflag` = "3", `speed_walk` = "1", `mindmg` = "66", `maxdmg` = "99", `attackpower` = "25", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "53", `maxrangedmg` = "79", `rangedattackpower` = "20", `mingold` = "0", `maxgold` = "0" WHERE entry=11033;
  51.  
  52.  
  53. -- [11035] - Betina Bigglezink
  54. UPDATE `creature` SET `position_x`='2260.14', `position_y`='-5338.98', `position_z`='86.842', `orientation`='2.14675', `curhealth`='3758', `curmana`='0' WHERE `id`='11035';
  55. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "3758", `maxhealth` = "3758", `armor` = "3326", `npcflag` = "3", `speed_walk` = "1", `mindmg` = "68", `maxdmg` = "103", `attackpower` = "26", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "54", `maxrangedmg` = "82", `rangedattackpower` = "21", `spell1` = "18367", `mingold` = "0", `maxgold` = "0" WHERE entry=11035;
  56. DELETE FROM `gossip_menu_option` WHERE `menu_id`='3651';
  57. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  58. VALUES
  59. ('3651', '1', '0', 'Betina, I need a new Seal of the Dawn.', '1', '1', '-1', '0', '3651', '0', '0', '', '8', '5213', '0', '24', '13209', '1', '24', '19812', '1'),
  60. ('3651', '2', '0', 'Betina, I need a new Rune of the Dawn.', '1', '1', '-1', '0', '11035', '0', '0', '', '8', '5213', '0', '24', '19812', '1', '24', '13209', '1');
  61.  
  62.  
  63. -- [11036] - Leonid Barthalomew the Revered
  64. UPDATE `creature` SET `position_x`='2307.24', `position_y`='-5348.9', `position_z`='91.6577', `orientation`='2.72271', `curhealth`='4120', `curmana`='0' WHERE `id`='11036';
  65. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "4120", `maxhealth` = "4120", `armor` = "3750", `speed_walk` = "1", `mindmg` = "96", `maxdmg` = "144", `attackpower` = "36", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "33280", `minrangedmg` = "77", `maxrangedmg` = "115", `rangedattackpower` = "29", `mingold` = "0", `maxgold` = "0" WHERE entry=11036;
  66.  
  67.  
  68. -- [11039] - Duke Nicholas Zverenhoff
  69. UPDATE `creature` SET `position_x`='2255.89', `position_y`='-5337.72', `position_z`='86.2628', `orientation`='0.593412', `curhealth`='4120', `curmana`='0' WHERE `id`='11039';
  70. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "4120", `maxhealth` = "4120", `armor` = "3750", `speed_walk` = "1", `mindmg` = "96", `maxdmg` = "144", `attackpower` = "36", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "77", `maxrangedmg` = "115", `rangedattackpower` = "29", `mingold` = "0", `maxgold` = "0" WHERE entry=11039;
  71.  
  72.  
  73. -- [11063] - Carlin Redpath
  74. UPDATE `creature` SET `position_x`='2257.31', `position_y`='-5340.87', `position_z`='86.8037', `orientation`='1.48353', `curhealth`='3876', `curmana`='0' WHERE `id`='11063';
  75. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "3876", `maxhealth` = "3876", `armor` = "3379", `npcflag` = "3", `speed_walk` = "1", `mindmg` = "78", `maxdmg` = "117", `attackpower` = "29", `baseattacktime` = "1500", `rangeattacktime` = "1500", `minrangedmg` = "62", `maxrangedmg` = "94", `rangedattackpower` = "23", `spell1` = "18988", `mingold` = "0", `maxgold` = "0", `flags_extra` = "2" WHERE entry=11063;
  76.  
  77.  
  78. -- [16131] - Rohan the Assassin
  79. UPDATE `creature` SET `position_x`='2289.73', `position_y`='-5337.32', `position_z`='90.9632', `orientation`='5.70723', `curhealth`='152600', `curmana`='0' WHERE `id`='16131';
  80. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "7101", `minhealth` = "152600", `maxhealth` = "152600", `minmana` = "0", `maxmana` = "0", `armor` = "3750", `mindmg` = "128", `maxdmg` = "192", `attackpower` = "48", `dmg_multiplier` = "3.3", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "36864", `minrangedmg` = "102", `maxrangedmg` = "154", `rangedattackpower` = "38" WHERE entry=16131;
  81. DELETE FROM `gossip_menu` WHERE `entry`='7101';
  82. INSERT INTO `gossip_menu` () VALUES
  83. ('7101', '8355', '0', '0', '0', '0', '0', '0');
  84. DELETE FROM `gossip_menu_option` WHERE `menu_id`='7101';
  85. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  86. VALUES
  87. ('7101', '1', '0', 'Where can I find bone fragments?', '1', '1', '7145', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  88. DELETE FROM `gossip_menu` WHERE `entry`='7145';
  89. INSERT INTO `gossip_menu` () VALUES
  90. ('7145', '8409', '0', '0', '0', '0', '0', '0');
  91.  
  92. -- [16132] - Huntsman Leopold
  93. UPDATE `creature` SET `position_x`='2288.55', `position_y`='-5340.35', `position_z`='90.9632', `orientation`='0.575959', `curhealth`='122100', `curmana`='9736' WHERE `id`='16132';
  94. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "7102", `minhealth` = "122100", `maxhealth` = "122100", `armor` = "3713", `mindmg` = "119", `maxdmg` = "179", `attackpower` = "45", `dmg_multiplier` = "3.6", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "36864", `minrangedmg` = "95", `maxrangedmg` = "143", `rangedattackpower` = "36" WHERE entry=16132;
  95. DELETE FROM `gossip_menu` WHERE `entry`='7102';
  96. INSERT INTO `gossip_menu` () VALUES
  97. ('7102', '8356', '0', '0', '0', '0', '0', '0');
  98. DELETE FROM `gossip_menu_option` WHERE `menu_id`='7102';
  99. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  100. VALUES
  101. ('7102', '1', '0', 'Where can I find crypt fiend parts, Leopold?', '1', '1', '7144', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  102. DELETE FROM `gossip_menu` WHERE `entry`='7144';
  103. INSERT INTO `gossip_menu` () VALUES
  104. ('7144', '8408', '0', '0', '0', '0', '0', '0');
  105.  
  106. -- [16134] - Rimblat Earthshatter
  107. UPDATE `creature` SET `position_x`='2276.66', `position_y`='-5325.3', `position_z`='88.7947', `orientation`='4.81711', `curhealth`='122100', `curmana`='9736' WHERE `id`='16134';
  108. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "7103", `minhealth` = "122100", `maxhealth` = "122100", `armor` = "3713", `mindmg` = "119", `maxdmg` = "179", `attackpower` = "45", `dmg_multiplier` = "3.6", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "36864", `minrangedmg` = "95", `maxrangedmg` = "143", `rangedattackpower` = "36" WHERE entry=16134;
  109. DELETE FROM `gossip_menu` WHERE `entry`='7103';
  110. INSERT INTO `gossip_menu` () VALUES
  111. ('7103', '8357', '0', '0', '0', '0', '0', '0');
  112.  
  113. -- [16135] - Rayne
  114. UPDATE `creature` SET `position_x`='2277.14', `position_y`='-5328.59', `position_z`='88.8296', `orientation`='2.00713', `curhealth`='122100', `curmana`='9736' WHERE `id`='16135';
  115. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "122100", `maxhealth` = "122100", `armor` = "3713", `faction_A` = "1608", `faction_H` = "1608", `mindmg` = "119", `maxdmg` = "179", `attackpower` = "45", `dmg_multiplier` = "3.6", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "36864", `minrangedmg` = "95", `maxrangedmg` = "143", `rangedattackpower` = "36" WHERE entry=16135;
  116. DELETE FROM `gossip_menu_option` WHERE `menu_id`='7104';
  117. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  118. VALUES
  119. ('7104', '1', '0', 'Rayne, where should I look for savage fronds?', '1', '1', '7152', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  120. DELETE FROM `gossip_menu` WHERE `entry`='7152';
  121. INSERT INTO `gossip_menu` () VALUES
  122. ('7152', '8416', '0', '0', '0', '0', '0', '0');
  123.  
  124. -- [16212] - Dispatch Commander Metz
  125. UPDATE `creature` SET `position_x`='2314.55', `position_y`='-5322.86', `position_z`='82.0478', `orientation`='2.18166', `curhealth`='6104', `curmana`='0' WHERE `id`='16212';
  126. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "7157", `minhealth` = "6104", `maxhealth` = "6104", `armor` = "3750", `npcflag` = "3", `speed_walk` = "1", `speed_run` = "1.38571", `mindmg` = "96", `maxdmg` = "144", `attackpower` = "36", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "0", `minrangedmg` = "77", `rangedattackpower` = "29", `MovementType` = "1", `flags_extra` = "2" WHERE entry=16212;
  127. DELETE FROM `gossip_menu` WHERE `entry`='7157';
  128. INSERT INTO `gossip_menu` () VALUES
  129. ('7157', '8422', '0', '0', '0', '0', '0', '0');
  130.  
  131. -- [16256] - Jessica Chambers
  132. UPDATE `creature` SET `position_x`='2300.9', `position_y`='-5345.09', `position_z`='90.8799', `orientation`='2.16421', `curhealth`='2490', `curmana`='0' WHERE `id`='16256';
  133. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "7173", `minhealth` = "2490", `maxhealth` = "2490", `armor` = "3063", `npcflag` = "66177", `speed_walk` = "1", `mindmg` = "42", `maxdmg` = "62", `attackpower` = "16", `baseattacktime` = "1000", `rangeattacktime` = "1000", `unit_flags` = "4608", `minrangedmg` = "34", `maxrangedmg` = "50", `rangedattackpower` = "13", `MovementType` = "1" WHERE entry=16256;
  134. DELETE FROM `gossip_menu` WHERE `entry`='7153';
  135. INSERT INTO `gossip_menu` () VALUES
  136. ('7173', '8448', '0', '0', '0', '0', '0', '0');
  137. DELETE FROM `gossip_menu_option` WHERE `menu_id`='7153';
  138. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  139. VALUES
  140. ('7153', '1', '0', 'Arcanist Vandril that here makes these Forsaken?', '1', '1', '7211', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  141. DELETE FROM `gossip_menu` WHERE `entry`='7211';
  142. INSERT INTO `gossip_menu` () VALUES
  143. ('7211', '8501', '0', '0', '0', '0', '0', '0');
  144.  
  145. -- [16283] - Packmaster Stonebruiser
  146. UPDATE `creature` SET `position_x`='2302.23', `position_y`='-5296.91', `position_z`='82.0796', `orientation`='1.85005', `curhealth`='8883', `curmana`='0' WHERE `id`='16283';
  147. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "7174", `minhealth` = "8883", `maxhealth` = "8883", `armor` = "3431", `npcflag` = "3", `mindmg` = "116", `maxdmg` = "174", `attackpower` = "43", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "36864", `minrangedmg` = "93", `maxrangedmg` = "139", `rangedattackpower` = "34" WHERE entry=16283;
  148. DELETE FROM `gossip_menu` WHERE `entry`='7174';
  149. INSERT INTO `gossip_menu` () VALUES
  150. ('7174', '8452', '0', '0', '0', '0', '0', '0');
  151.  
  152. -- [16284] - Argent Medic
  153. UPDATE `creature` SET `position_x`='2309.51', `position_y`='-5305.87', `position_z`='82.0796', `orientation`='0.122173', `curhealth`='6726', `curmana`='8964' WHERE `id`='16284';
  154. UPDATE creature_template SET `modelid2` = "16107", `modelid3` = "0", `gossip_menu_id` = "7175", `minhealth` = "6726", `maxhealth` = "6937", `armor` = "3345", `faction_A` = "794", `faction_H` = "794", `npcflag` = "1", `mindmg` = "97", `maxdmg` = "145", `attackpower` = "36", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "512", `minrangedmg` = "78", `maxrangedmg` = "116", `rangedattackpower` = "29", `spell1` = "28133", `AIName` = "EventAI", `flags_extra` = "0" WHERE entry=16284;
  155. DELETE FROM `gossip_menu` WHERE `entry`='7175';
  156. INSERT INTO `gossip_menu` () VALUES
  157. ('7175', '8454', '0', '0', '0', '0', '0', '0');
  158.  
  159. -- [16376] - Craftsman Wilhelm
  160. UPDATE `creature` SET `position_x`='2261.17', `position_y`='-5321.3', `position_z`='81.9491', `orientation`='4.86947', `curhealth`='8352', `curmana`='0' WHERE `id`='16376';
  161. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "7219", `minhealth` = "8352", `maxhealth` = "8352", `armor` = "3326", `faction_A` = "1767", `faction_H` = "1767", `speed_walk` = "1", `mindmg` = "68", `maxdmg` = "103", `attackpower` = "26", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "4096", `minrangedmg` = "54", `maxrangedmg` = "82", `rangedattackpower` = "21", `lootid` = "0", `maxgold` = "0" WHERE entry=16376;
  162. DELETE FROM `gossip_menu` WHERE `entry`='7175';
  163. INSERT INTO `gossip_menu` () VALUES
  164. ('7219', '8513', '0', '0', '0', '0', '0', '0');
  165. DELETE FROM `gossip_menu_option` WHERE `menu_id`='7219';
  166. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  167. VALUES
  168. ('7219', '0', '1', 'Show me your wares, Wilhelm.', '3', '128', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  169.  
  170. -- [17072] - Emissary Gormok
  171. UPDATE `creature` SET `position_x`='2317.35', `position_y`='-5283.65', `position_z`='81.8859', `orientation`='3.40339', `curhealth`='2614', `curmana`='0' WHERE `id`='17072';
  172. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "2614", `maxhealth` = "2614", `armor` = "3221", `speed_walk` = "1", `mindmg` = "44", `maxdmg` = "66", `attackpower` = "16", `baseattacktime` = "1000", `rangeattacktime` = "1000", `unit_flags` = "32768", `minrangedmg` = "35", `maxrangedmg` = "53", `rangedattackpower` = "13", `MovementType` = "1" WHERE entry=17072;
  173.  
  174. -- [11034] - Lord Maxwell Tyrosus
  175. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "4370", `maxhealth` = "4370", `armor` = "4348", `speed_walk` = "1", `mindmg` = "114", `maxdmg` = "171", `attackpower` = "43", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "91", `maxrangedmg` = "137", `rangedattackpower` = "34", `mingold` = "0", `maxgold` = "0" WHERE entry=11034;
  176.  
  177. -- [16112] - Korfax, Champion of the Light
  178. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "7099", `minhealth` = "610400", `maxhealth` = "610400", `armor` = "3750", `faction_A` = "1767", `faction_H` = "1767", `mindmg` = "128", `maxdmg` = "192", `attackpower` = "48", `dmg_multiplier` = "3.3", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "36864", `minrangedmg` = "102", `maxrangedmg` = "154", `rangedattackpower` = "38", `spell1` = "13730", `spell2` = "11976", `spell3` = "0", `flags_extra` = "2" WHERE entry=16112;
  179. DELETE FROM `gossip_menu` WHERE `entry`='7099';
  180. INSERT INTO `gossip_menu` () VALUES
  181. ('7099', '8353', '0', '0', '0', '0', '0', '0');
  182. DELETE FROM `gossip_menu_option` WHERE `menu_id`='7099';
  183. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  184. VALUES
  185. ('7099', '1', '0', 'Korfax, where can I find Dark Iron scraps?', '1', '1', '7151', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  186. DELETE FROM `gossip_menu` WHERE `entry`='7151';
  187. INSERT INTO `gossip_menu` () VALUES
  188. ('7151', '8415', '0', '0', '0', '0', '0', '0');
  189.  
  190. -- SOME ADDONS
  191. DELETE FROM `creature_template_addon` WHERE `entry` IN (16134, 16135, 11035, 11063, 11039, 16376, 16283, 11033, 16284, 17072, 16212, 16131, 16132, 16256, 11036);
  192. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_pvp_state`, `emote`, `moveflags`, `auras`)
  193. VALUES
  194. ('11033', '0', '0', '1', '0', '0', '0', ''),
  195. ('11035', '0', '0', '1', '0', '0', '0', ''),
  196. ('11036', '0', '0', '1', '0', '0', '0', ''),
  197. ('11039', '0', '0', '1', '0', '0', '0', ''),
  198. ('11063', '0', '0', '1', '0', '0', '0', ''),
  199. ('16131', '0', '0', '1', '0', '0', '0', ''),
  200. ('16132', '0', '0', '1', '0', '0', '0', ''),
  201. ('16134', '0', '0', '1', '0', '0', '0', ''),
  202. ('16135', '0', '0', '1', '1', '0', '0', ''),
  203. ('16212', '2402', '0', '1', '0', '0', '0', ''),
  204. ('16256', '0', '0', '1', '1', '0', '0', ''),
  205. ('16283', '0', '0', '1', '1', '0', '0', ''),
  206. ('16376', '0', '0', '1', '1', '69', '0', ''),
  207. ('17072', '0', '0', '1', '0', '0', '0', ''),
  208. ('11034', '0', '0', '1', '0', '0', '0', ''),
  209. ('16112', '0', '0', '1', '1', '0', '0', ''),
  210. ('16113', '0', '5', '1', '1', '0', '0', ''),
  211. ('16114', '0', '5', '1', '1', '0', '0', ''),
  212. ('16115', '0', '5', '1', '1', '0', '0', ''),
  213. ('16116', '0', '5', '1', '1', '0', '0', '');
  214.  
  215. -- CAMPFIRE - nélkülözhetetlen :D
  216. INSERT INTO `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
  217. VALUES
  218. ('176277', '0', '1', '1', '2304.18', '-5303.3', '81.9963', '3.14159', '0', '0', '1', '0', '900', '100', '1'),
  219. ('2061', '0', '1', '1', '2258.4', '-5338.74', '86.5647', '3.14159', '0', '0', '1', '0', '900', '100', '1');
  220. UPDATE gameobject_template SET `displayId` = "299", `flags` = "0" WHERE entry=2061;
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!