API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 27th, 2017
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.54 KB | None | 0 0
raw download clone embed print report
  1.  -- Icecrown Citadel
  2. -- 37955 Кровавая королева Лана'тель
  3. Update  `creature_template` set `lootid`=37955 where `entry`=37955;
  4. Update  `creature_template` set `lootid`=10073 where `entry`=10073;
  5. Update  `creature_template` set `lootid`=10074 where `entry`=10074;
  6. Update  `creature_template` set `lootid`=10075 where `entry`=10075;
  7. -- 37813 Deathbringer Saurfang
  8. Update  `creature_template` set `lootid`=37813 where `entry`=37813;
  9. Update  `creature_template` set `lootid`=13106 where `entry`=13106;
  10. Update  `creature_template` set `lootid`=13107 where `entry`=13107;
  11. Update  `creature_template` set `lootid`=13108 where `entry`=13108;
  12. DELETE FROM `creature_loot_template` WHERE (`entry`=13106);
  13. INSERT INTO `creature_loot_template` VALUES
  14. (13106, 51902, 0, 1, 1, 1, 1, 0, 0, 0),
  15. (13106, 51903, 0, 1, 1, 1, 1, 0, 0, 0),
  16. (13106, 51904, 0, 1, 1, 1, 1, 0, 0, 0),
  17. (13106, 51901, 0, 1, 1, 1, 1, 0, 0, 0),
  18. (13106, 51900, 0, 1, 1, 1, 1, 0, 0, 0),
  19. (13106, 51895, 0, 1, 1, 1, 1, 0, 0, 0),
  20. (13106, 52025, 0, 1, 1, 1, 1, 0, 0, 0),
  21. (13106, 51896, 0, 1, 1, 1, 1, 0, 0, 0),
  22. (13106, 52027, 0, 1, 1, 1, 1, 0, 0, 0),
  23. (13106, 52026, 0, 1, 1, 1, 1, 0, 0, 0),
  24. (13106, 49908, 0, 1, 1, 1, 1, 0, 0, 0),
  25. (13106, 51899, 0, 1, 1, 1, 1, 0, 0, 0),
  26. (13106, 51898, 0, 1, 1, 1, 1, 0, 0, 0),
  27. (13106, 51905, 0, 1, 1, 1, 1, 0, 0, 0),
  28. (13106, 51897, 0, 1, 1, 1, 1, 0, 0, 0),
  29. (13106, 51894, 0, 1, 1, 1, 1, 0, 0, 0);
  30. DELETE FROM `creature_loot_template` WHERE (`entry`=13107);
  31. INSERT INTO `creature_loot_template` VALUES
  32. (13107, 52025, 0, 1, 1, 1, 1, 0, 0, 0),
  33. (13107, 52027, 0, 1, 1, 1, 1, 0, 0, 0),
  34. (13107, 52026, 0, 1, 1, 1, 1, 0, 0, 0),
  35. (13107, 50362, 0, 1, 1, 1, 1, 0, 0, 0),
  36. (13107, 49908, 0, 1, 1, 1, 1, 0, 0, 0),
  37. (13107, 50014, 0, 1, 1, 1, 1, 0, 0, 0),
  38. (13107, 50333, 0, 1, 1, 1, 1, 0, 0, 0),
  39. (13107, 50412, 0, 1, 1, 1, 1, 0, 0, 0),
  40. (13107, 50015, 0, 1, 1, 1, 1, 0, 0, 0),
  41. (13107, 50274, 0, 1, 1, 1, 1, 0, 0, 0);
  42. DELETE FROM `creature_loot_template` WHERE (`entry`=13108);
  43. INSERT INTO `creature_loot_template` VALUES
  44. (13108, 52025, 0, 1, 1, 1, 1, 0, 0, 0),
  45. (13108, 52027, 0, 1, 1, 1, 1, 0, 0, 0),
  46. (13108, 52026, 0, 1, 1, 1, 1, 0, 0, 0),
  47. (13108, 52028, 0, 1, 1, 1, 1, 0, 0, 0),
  48. (13108, 49908, 0, 1, 1, 1, 1, 0, 0, 0),
  49. (13108, 52030, 0, 1, 1, 1, 1, 0, 0, 0),
  50. (13108, 52029, 0, 1, 1, 1, 1, 0, 0, 0),
  51. (13108, 50363, 0, 1, 1, 1, 1, 0, 0, 0),
  52. (13108, 50670, 0, 1, 1, 1, 1, 0, 0, 0),
  53. (13108, 50668, 0, 1, 1, 1, 1, 0, 0, 0),
  54. (13108, 50671, 0, 1, 1, 1, 1, 0, 0, 0),
  55. (13108, 50274, 0, 1, 1, 1, 1, 0, 0, 0),
  56. (13108, 50672, 0, 1, 1, 1, 1, 0, 0, 0);
  57. -- 36626 Festergut
  58. Update  `creature_template` set `lootid`=36626 where `entry`=36626;
  59. Update  `creature_template` set `lootid`=13109 where `entry`=13109;
  60. Update  `creature_template` set `lootid`=13110 where `entry`=13110;
  61. Update  `creature_template` set `lootid`=13111 where `entry`=13111;
  62. -- 37970 Prince Valanar
  63. Update  `creature_template` set `lootid`=37970 where `entry`=37970;
  64. Update  `creature_template` set `lootid`=10035 where `entry`=10035;
  65. Update  `creature_template` set `lootid`=10039 where `entry`=10039;
  66. Update  `creature_template` set `lootid`=10064 where `entry`=10064;
  67. -- 37972 Prince Keleseth
  68. Update  `creature_template` set `lootid`=37970 where `entry`=37972;
  69. Update  `creature_template` set `lootid`=10035 where `entry`=10029;
  70. Update  `creature_template` set `lootid`=10039 where `entry`=10030;
  71. Update  `creature_template` set `lootid`=10064 where `entry`=10031;
  72. -- 37973 Prince Taldaram
  73. Update  `creature_template` set `lootid`=37970 where `entry`=37973;
  74. Update  `creature_template` set `lootid`=10035 where `entry`=10032;
  75. Update  `creature_template` set `lootid`=10039 where `entry`=10033;
  76. Update  `creature_template` set `lootid`=10064 where `entry`=10034;
  77. -- 36678 Professor Putricide
  78. Update  `creature_template` set `lootid`=36678 where `entry`=36678;
  79. Update  `creature_template` set `lootid`=13119 where `entry`=13119;
  80. Update  `creature_template` set `lootid`=13120 where `entry`=13120;
  81. Update  `creature_template` set `lootid`=13121 where `entry`=13121;
  82. -- 36627 Rotface
  83. Update  `creature_template` set `lootid`=36627 where `entry`=36627;
  84. Update  `creature_template` set `lootid`=13112 where `entry`=13112;
  85. Update  `creature_template` set `lootid`=13113 where `entry`=13113;
  86. Update  `creature_template` set `lootid`=13114 where `entry`=13114;
  87. -- 36853 Sindragosa <Queen of the Frostbrood>
  88. Update  `creature_template` set `lootid`=36853 where `entry`=36853;
  89. Update  `creature_template` set `lootid`=10070 where `entry`=10070;
  90. Update  `creature_template` set `lootid`=10071 where `entry`=10071;
  91. Update  `creature_template` set `lootid`=10072 where `entry`=10072;
  92. -- 36597 The Lich King
  93. Update  `creature_template` set `lootid`=36597 where `entry`=36597;
  94. Update  `creature_template` set `lootid`=10093 where `entry`=10093;
  95. Update  `creature_template` set `lootid`=10094 where `entry`=10094;
  96. Update  `creature_template` set `lootid`=10095 where `entry`=10095;
  97. DELETE FROM `creature_loot_template` WHERE (`entry`=10094);
  98. INSERT INTO `creature_loot_template` VALUES
  99. (10094, 52026, 0, 1, 0, 1, 1, 0, 0, 0),
  100. (10094, 52027, 0, 1, 1, 1, 1, 0, 0, 0),
  101. (10094, 50274, 0, 1, 2, 1, 1, 0, 0, 0),
  102. (10094, 49981, 0, 1, 1, 1, 1, 0, 0, 0),
  103. (10094, 50070, 0, 1, 1, 1, 1, 0, 0, 0),
  104. (10094, 50428, 0, 1, 0, 1, 1, 0, 0, 0),
  105. (10094, 50429, 0, 1, 2, 1, 1, 0, 0, 0),
  106. (10094, 49908, 0, 1, 1, 1, 1, 0, 0, 0),
  107. (10094, 50012, 0, 1, 2, 1, 1, 0, 0, 0),
  108. (10094, 50425, 0, 1, 2, 1, 1, 0, 0, 0),
  109. (10094, 50427, 0, 1, 2, 1, 1, 0, 0, 0),
  110. (10094, 49997, 0, 1, 2, 1, 1, 0, 0, 0),
  111. (10094, 50426, 0, 1, 2, 1, 1, 0, 0, 0),
  112. (10094, 50818, 0.1, 1, 2, 1, 1, 0, 0, 0),
  113. (10094, 51315, 0, 1, 2, 1, 1, 0, 0, 0),
  114. (10094, 49426,100,1,0,2,2,0,0,0),
  115. (10094, 52025, 100, 1, 0, -52025, 2, 0, 0, 0);
  116. DELETE FROM `creature_loot_template` WHERE (`entry`=10095);
  117. INSERT INTO `creature_loot_template` VALUES
  118. (10095, 52025, 0, 1, 0, 1, 1, 0, 0, 0),
  119. (10095, 52026, 0, 1, 1, 1, 1, 0, 0, 0),
  120. (10095, 52027, 0, 1, 2, 1, 1, 0, 0, 0),
  121. (10095, 50274, 0, 1, 1, 1, 1, 0, 0, 0),
  122. (10095, 49908, 0, 1, 1, 1, 1, 0, 0, 0),
  123. (10095, 50818, 0.1, 1, 0, 1, 1, 0, 0, 0),
  124. (10095, 52030, 0, 1, 2, 1, 1, 0, 0, 0),
  125. (10095, 50731, 0, 1, 1, 1, 1, 0, 0, 0),
  126. (10095, 50732, 0, 1, 2, 1, 1, 0, 0, 0),
  127. (10095, 50733, 0, 1, 2, 1, 1, 0, 0, 0),
  128. (10095, 50730, 0, 1, 2, 1, 1, 0, 0, 0),
  129. (10095, 50737, 0, 1, 2, 1, 1, 0, 0, 0),
  130. (10095, 50736, 0, 1, 2, 1, 1, 0, 0, 0),
  131. (10095, 50738, 0, 1, 2, 1, 1, 0, 0, 0),
  132. (10095, 50735, 0, 1, 2, 1, 1, 0, 0, 0),
  133. (10095, 52029, 0, 1, 2, 1, 1, 0, 0, 0),
  134. (10095, 50734, 0, 1, 2, 1, 1, 0, 0, 0),
  135. (10095, 52028, 0, 1, 2, 1, 1, 0, 0, 0),
  136. (10095, 49426,100,1,0,2,2,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!