SHARE
TWEET

Untitled

a guest May 19th, 2017 50 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DELETE FROM `creature_template` WHERE (`entry`=100084);
  2. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`,`KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questitem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`)
  3. VALUES ('100084', '0', '0', '0', '0', '0', '27015', '0', '27015', '0', 'Tier 9', 'Immortal Sunrise', null, '0', '200', '20000', '20000', '20000', '20000', '20000', '20000', '35', '35', '4224', '1', '1.14286', '1', '0', '13', '17', '0', '42', '1', '2000', '0', '1', '512', '0', '0', '0', '0', '0', '0', '9', '13', '100', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '2', '0', '2', '');
  4. DELETE FROM `npc_vendor` WHERE (`entry`=100084);
  5. replace into `npc_vendor` VALUES
  6. (100084, 47758, 0, 0, 0),
  7. (100084, 47759, 0, 0, 0),
  8. (100084, 47760, 0, 0, 0),
  9. (100084, 47761, 0, 0, 0),
  10. (100084, 47762, 0, 0, 0),
  11. (100084, 47763, 0, 0, 0),
  12. (100084, 47764, 0, 0, 0),
  13. (100084, 47765, 0, 0, 0),
  14. (100084, 47766, 0, 0, 0),
  15. (100084, 47767, 0, 0, 0),
  16. (100084, 47788, 0, 0, 0),
  17. (100084, 47789, 0, 0, 0),
  18. (100084, 47790, 0, 0, 0),
  19. (100084, 47791, 0, 0, 0),
  20. (100084, 47792, 0, 0, 0),
  21. (100084, 47793, 0, 0, 0),
  22. (100084, 47794, 0, 0, 0),
  23. (100084, 47795, 0, 0, 0),
  24. (100084, 47796, 0, 0, 0),
  25. (100084, 47797, 0, 0, 0),
  26. (100084, 48029, 0, 0, 0),
  27. (100084, 48031, 0, 0, 0),
  28. (100084, 48033, 0, 0, 0),
  29. (100084, 48035, 0, 0, 0),
  30. (100084, 48037, 0, 0, 0),
  31. (100084, 48057, 0, 0, 0),
  32. (100084, 48058, 0, 0, 0),
  33. (100084, 48059, 0, 0, 0),
  34. (100084, 48060, 0, 0, 0),
  35. (100084, 48061, 0, 0, 0),
  36. (100084, 48138, 0, 0, 0),
  37. (100084, 48139, 0, 0, 0),
  38. (100084, 48140, 0, 0, 0),
  39. (100084, 48141, 0, 0, 0),
  40. (100084, 48142, 0, 0, 0),
  41. (100084, 48143, 0, 0, 0),
  42. (100084, 48144, 0, 0, 0),
  43. (100084, 48145, 0, 0, 0),
  44. (100084, 48146, 0, 0, 0),
  45. (100084, 48147, 0, 0, 0),
  46. (100084, 48228, 0, 0, 0),
  47. (100084, 48229, 0, 0, 0),
  48. (100084, 48230, 0, 0, 0),
  49. (100084, 48231, 0, 0, 0),
  50. (100084, 48232, 0, 0, 0),
  51. (100084, 48238, 0, 0, 0),
  52. (100084, 48239, 0, 0, 0),
  53. (100084, 48240, 0, 0, 0),
  54. (100084, 48241, 0, 0, 0),
  55. (100084, 48242, 0, 0, 0),
  56. (100084, 48260, 0, 0, 0),
  57. (100084, 48261, 0, 0, 0),
  58. (100084, 48262, 0, 0, 0),
  59. (100084, 48263, 0, 0, 0),
  60. (100084, 48264, 0, 0, 0),
  61. (100084, 48265, 0, 0, 0),
  62. (100084, 48266, 0, 0, 0),
  63. (100084, 48267, 0, 0, 0),
  64. (100084, 48268, 0, 0, 0),
  65. (100084, 48269, 0, 0, 0),
  66. (100084, 48290, 0, 0, 0),
  67. (100084, 48291, 0, 0, 0),
  68. (100084, 48292, 0, 0, 0),
  69. (100084, 48293, 0, 0, 0),
  70. (100084, 48294, 0, 0, 0),
  71. (100084, 48305, 0, 0, 0),
  72. (100084, 48306, 0, 0, 0),
  73. (100084, 48307, 0, 0, 0),
  74. (100084, 48308, 0, 0, 0),
  75. (100084, 48309, 0, 0, 0),
  76. (100084, 48381, 0, 0, 0),
  77. (100084, 48382, 0, 0, 0),
  78. (100084, 48383, 0, 0, 0),
  79. (100084, 48384, 0, 0, 0),
  80. (100084, 48385, 0, 0, 0),
  81. (100084, 48466, 0, 0, 0),
  82. (100084, 48467, 0, 0, 0),
  83. (100084, 48468, 0, 0, 0),
  84. (100084, 48469, 0, 0, 0),
  85. (100084, 48470, 0, 0, 0),
  86. (100084, 48481, 0, 0, 0),
  87. (100084, 48482, 0, 0, 0),
  88. (100084, 48483, 0, 0, 0),
  89. (100084, 48484, 0, 0, 0),
  90. (100084, 48485, 0, 0, 0),
  91. (100084, 48486, 0, 0, 0),
  92. (100084, 48487, 0, 0, 0),
  93. (100084, 48488, 0, 0, 0),
  94. (100084, 48489, 0, 0, 0),
  95. (100084, 48490, 0, 0, 0),
  96. (100084, 48491, 0, 0, 0),
  97. (100084, 48492, 0, 0, 0),
  98. (100084, 48493, 0, 0, 0),
  99. (100084, 48494, 0, 0, 0),
  100. (100084, 48495, 0, 0, 0),
  101. (100084, 48589, 0, 0, 0),
  102. (100084, 48590, 0, 0, 0),
  103. (100084, 48591, 0, 0, 0),
  104. (100084, 48592, 0, 0, 0),
  105. (100084, 48593, 0, 0, 0),
  106. (100084, 48612, 0, 0, 0),
  107. (100084, 48613, 0, 0, 0),
  108. (100084, 48614, 0, 0, 0),
  109. (100084, 48615, 0, 0, 0),
  110. (100084, 48616, 0, 0, 0);
RAW Paste Data
Challenge yourself this year...
Learn something new in 2017
Top