API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
52
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.33 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO `` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) VALUES (900002, 49623, 49623, 49623);
  2. INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) VALUES (900005, 18876, 18876, 18876);
  3. INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) VALUES (900003, 50070, 50070, 50070);
  4. INSERT INTO `creature` VALUES (207078, 900002, 1, 1, 1, 0, 10136, 1506.46, -4414.28, 20.4401, 6.26099, 300, 0, 0, 117548112, 0, 0, 0);
  5. INSERT INTO `creature` VALUES (207757, 900002, 0, 1, 1, 0, 10136, -8882.58, 577.858, 92.9952, 0.612171, 300, 0, 0, 117548112, 0, 0, 0);
  6. INSERT INTO `creature` VALUES (206141, 900003, 1, 1, 1, 0, 99994, 1533.78, -4412.62, 11.867, 3.18945, 300, 0, 0, 4646400, 0, 0, 0);
  7. INSERT INTO `creature` VALUES (207759, 900005, 0, 1, 1, 0, 0, -8859.82, 595.471, 92.0729, 3.80492, 300, 0, 0, 4646400, 0, 0, 0);
  8. INSERT INTO `creature` VALUES (208694, 900007, 0, 1, 1, 0, 0, -8828.81, 646.509, 94.5438, 5.10318, 300, 0, 0, 2414584, 0, 0, 0);
  9. INSERT INTO `creature` VALUES (209045, 900007, 1, 1, 1, 0, 0, 1610.76, -4389.66, 10.4693, 3.66226, 300, 0, 0, 2414584, 0, 0, 0);
  10. INSERT INTO `creature_template` VALUES (900003, 0, 0, 0, 0, 0, 4527, 0, 0, 0, 'Thrall', 'Warchief', NULL, 0, 83, 83, 0, 85, 85, 0, 1, 1.14286, 2, 3, 8400, 15200, 0, 200, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 800, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 99994, 617299967, 0, '', 1);
  11. INSERT INTO `creature_template` VALUES (900005, 0, 0, 0, 0, 0, 28127, 0, 0, 0, 'King Varian Wrynn', 'King of Stormwind', NULL, 0, 83, 83, 0, 11, 11, 0, 1, 1.14286, 2, 3, 8400, 15200, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 800, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 900005, 617299967, 0, '', 1);
  12. INSERT INTO `creature_template` VALUES (900007, 0, 0, 0, 0, 0, 22209, 0, 0, 0, 'Highlord Tirion Fordring', NULL, NULL, 0, 80, 80, 0, 35, 35, 2, 1, 1.14286, 1, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 452, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 1);
  13. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (900002, 0, 0, 0, 0, 0, 30869, 30869, 30869, 0, 'Scourge Commander Redlight', 'The Soulreaver', NULL, 0, 83, 83, 0, 14, 14, 0, 2, 1.14286, 3, 3, 509, 683, 0, 805, 75, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 11239, 156, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 10136, 617299967, 0, '', 1);
  14. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (900006, 0, 0, 0, 0, 0, 25297, 0, 0, 0, 'Shambling Horror', 'Redlight\'s Minion', NULL, 0, 83, 83, 0, 14, 14, 0, 1, 1.14286, 1, 3, 503, 683, 0, 805, 75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 258, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299967, 0, '', 1);
  15. INSERT INTO `game_event` VALUES (999, '0000-0-0 00:00:00', '0000-0-0 00:00:00', 5184000, 30, 0, 'Invader of Darkness (Alliance)', 0);
  16. INSERT INTO `game_event_creature` VALUES (207757, 999);
  17. INSERT INTO `game_event_creature` VALUES (207759, 999);
  18. INSERT INTO `game_event_creature` VALUES (208694, 999);
  19. INSERT INTO `game_event_creature` VALUES (207078, 998);
  20. INSERT INTO `game_event_creature` VALUES (206141, 998);
  21. INSERT INTO `game_event_creature` VALUES (209045, 998);
  22. INSERT INTO `game_event` VALUES (998, '0000-0-0 00:00:00', '0000-0-0 00:00:00', 0, 30, 0, 'Invader of Darkness (Horde)', 0);
  23. INSERT INTO `game_event_gameobject` VALUES (1478877, 999);
  24. INSERT INTO `game_event_gameobject` VALUES (1478850, 998);
  25. INSERT INTO `game_event_gameobject` VALUES (1478853, 998);
  26. INSERT INTO `creature` VALUES (1478850, 90004, 1, 1, 1, 1480.03, -4417.49, 25.4626, 3.31397, 0, 0, 0.996288, -0.0860829, 300, 0, 1);
  27. INSERT INTO `creature` VALUES (1478853, 90004, 1, 1, 1, 1729.65, -4403.47, 35.1392, 5.36544, 0, 0, 0.442937, -0.896553, 300, 0, 1);
  28. INSERT INTO `creature` VALUES (1478877, 90004, 0, 1, 1, -8890.4, 571.822, 92.5043, 3.80167, 0, 0, 0.946029, -0.324082, 300, 0, 1);
  29. INSERT INTO `gameobject_template` VALUES (90004, 0, 9239, 'Geißeltor', '', '', '', 0, 4, 1, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1);
  30. DELETE FROM creature_ai_scripts WHERE creature_id IN (900002, 900003, 900005, 900006);
  31. INSERT INTO creature_ai_scripts
  32. (id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4,
  33. action1_type, action1_param1, action1_param2, action1_param3,
  34. action2_type, action2_param1, action2_param2, action2_param3,
  35. action3_type, action3_param1, action3_param2, action3_param3,
  36. comment)
  37. VALUES
  38. (9000021, 900002, 0, 0, 100, 7, 6000, 7000, 6000, 7000,
  39. 11, 40827, 1, 0,
  40. 0, 0, 0, 0,
  41. 0, 0, 0, 0,
  42. 'Scourge Commander Redlight - Cast Sinful Beam'),
  43. (9000022, 900002, 0, 0, 100, 7, 15000, 15000, 15000, 15000,
  44. 11, 59352, 4, 0,
  45. 1, -20004, 0, 0,
  46. 0, 0, 0, 0,
  47. 'Scourge Commander Redlight - Cast Mark of Darkness'),
  48. (9000023, 900002, 0, 0, 100, 7, 25000, 25000, 30000, 30000,
  49. 11, 31306, 1, 0,
  50. 0, 0, 0, 0,
  51. 0, 0, 0, 0,
  52. 'Scourge Commander Redlight - Cast Carrion Swarm'),
  53. (9000024, 900002, 0, 0, 100, 7, 30000, 30000, 30000, 30000,
  54. 11, 71022, 0, 0,
  55. 0, 0, 0, 0,
  56. 0, 0, 0, 0,
  57. 'Scourge Commander Redlight - Cast Disrupting Shout'),
  58. (9000025, 900002, 0, 0, 100, 7, 62000, 62000, 62000, 62000,
  59. 12, 900006, 5, 0,
  60. 0, 0, 0, 0,
  61. 0, 0, 0, 0,
  62. 'Scourge Commander Redlight - Summon Add'),
  63. (9000026, 900002, 0, 0, 100, 7, 120000, 120000, 120000, 120000,
  64. 1, -20005, 0, 0,
  65. 0, 0, 0, 0,
  66. 0, 0, 0, 0,
  67. 'Scourge Commander Redlight - Yell'),
  68. (9000061, 900006, 0, 0, 100, 7, 120000, 120000, 120000, 120000,
  69. 11, 58841, 0, 0,
  70. 0, 0, 0, 0,
  71. 0, 0, 0, 0,
  72. 'Scourge Commander Add - Cast Frenzy'),
  73. (9000062, 900006, 0, 0, 100, 7, 15000, 16000, 15000, 16000,
  74. 11, 75418, 1, 0,
  75. 0, 0, 0, 0,
  76. 0, 0, 0, 0,
  77. 'Scourge Commander Add - Cast Shockwave'),
  78. (9000031, 900003, 0, 0, 100, 7, 60000, 60000, 60000, 60000,
  79. 1, -20007, 0, 0,
  80. 0, 0, 0, 0,
  81. 0, 0, 0, 0,
  82. 'Event Thrall - Yell'),
  83. (9000051, 900005, 0, 0, 100, 7, 60000, 60000, 60000, 60000,
  84. 1, -20008, 0, 0,
  85. 0, 0, 0, 0,
  86. 0, 0, 0, 0,
  87. 'Event King Varian Wrynn - Yell');
  88.  
  89. DELETE FROM creature_ai_texts WHERE entry BETWEEN -20008 AND -20004;
  90. INSERT INTO creature_ai_texts
  91. (entry, content_default, content_loc3, type, comment)
  92. VALUES
  93. (-20004, 'You are marked for death!', '', 1, 'Event Boss Yell'),
  94. (-20005, 'Soon you will join your friends, mortals!', '', 1, 'Event Boss Yell'),
  95. (-20006, 'Enough! Feel my blood-red Scythe! I will deprive your Souls!', '', 1, 'Event Boss Yell'),
  96. (-20007, 'You don\'t know what it takes to face the Horde, Redlight!', '', 1, 'Event Boss Yell'),
  97. (-20008, 'Never underestimate the might of the Alliance, Redlight!', '', 1, 'Event Boss Yell');
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!