SHARE
TWEET

Untitled

a guest Sep 8th, 2011 173 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- SELECT CONCAT( 'UPDATE IGNORE creature_proto SET spell1 = ', `spell1`, ', spell2 = ', `spell2`, ', spell3 = ', `spell3`, ', spell4 = ', `spell4`, ', spell5 = ', `spell5`, ', spell6 = ', `spell6`, ', spell7 = ', `spell7`, ', spell8 = ', `spell8`, ' WHERE entry = ', `entry`, ';' ) FROM `creature_template` WHERE `vehicleid` != '0';
  2. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29144;  
  3. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32633;  
  4. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 25762;  
  5. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 23693;  
  6. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 24083;  
  7. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 24418;  
  8. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 24705;  
  9. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 24750;  
  10. UPDATE IGNORE creature_proto SET spell1 = 50672, spell2 = 45750, spell3 = 50677, spell4 = 47849, spell5 = 47962, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 25334;  
  11. UPDATE IGNORE creature_proto SET spell1 = 45877, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 25596;  
  12. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 25743;  
  13. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 25765;  
  14. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 25881;  
  15. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 25968;  
  16. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26191;  
  17. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26472;  
  18. UPDATE IGNORE creature_proto SET spell1 = 48211, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26523;  
  19. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26525;  
  20. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26572;  
  21. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26585;  
  22. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26590;  
  23. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26777;  
  24. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26778;  
  25. UPDATE IGNORE creature_proto SET spell1 = 63507, spell2 = 47434, spell3 = 47454, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26813;  
  26. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 26893;  
  27. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27131;  
  28. UPDATE IGNORE creature_proto SET spell1 = 48297, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27213;  
  29. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27241;  
  30. UPDATE IGNORE creature_proto SET spell1 = 48363, spell2 = 48397, spell3 = 54170, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27258;  
  31. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27261;  
  32. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27270;  
  33. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27292;  
  34. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27354;  
  35. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27409;  
  36. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27496;  
  37. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27516;  
  38. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27587;  
  39. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27593;  
  40. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27605;  
  41. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27626;  
  42. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27629;  
  43. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27661;  
  44. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27671;  
  45. UPDATE IGNORE creature_proto SET spell1 = 50328, spell2 = 50341, spell3 = 50344, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27692;  
  46. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27714;  
  47. UPDATE IGNORE creature_proto SET spell1 = 49840, spell2 = 49838, spell3 = 49592, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27755;  
  48. UPDATE IGNORE creature_proto SET spell1 = 50232, spell2 = 50248, spell3 = 50240, spell4 = 50253, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27756;  
  49. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27761;  
  50. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27839;  
  51. UPDATE IGNORE creature_proto SET spell1 = 50025, spell2 = 50990, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27881;  
  52. UPDATE IGNORE creature_proto SET spell1 = 49872, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27894;  
  53. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27924;  
  54. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27992;  
  55. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27993;  
  56. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 27996;  
  57. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28009;  
  58. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28018;  
  59. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28054;  
  60. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28061;  
  61. UPDATE IGNORE creature_proto SET spell1 = 50896, spell2 = 50652, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28094;  
  62. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28135;  
  63. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28192;  
  64. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28246;  
  65. UPDATE IGNORE creature_proto SET spell1 = 51678, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28312;  
  66. UPDATE IGNORE creature_proto SET spell1 = 51362, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28319;  
  67. UPDATE IGNORE creature_proto SET spell1 = 51421, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28366;  
  68. UPDATE IGNORE creature_proto SET spell1 = 51660, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28379;  
  69. UPDATE IGNORE creature_proto SET spell1 = 52264, spell2 = 52268, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28605;  
  70. UPDATE IGNORE creature_proto SET spell1 = 52264, spell2 = 52268, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28606;  
  71. UPDATE IGNORE creature_proto SET spell1 = 52264, spell2 = 52268, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28607;  
  72. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28614;  
  73. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28669;  
  74. UPDATE IGNORE creature_proto SET spell1 = 53114, spell2 = 53112, spell3 = 53110, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28670;  
  75. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28710;  
  76. UPDATE IGNORE creature_proto SET spell1 = 52338, spell2 = 60206, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28781;  
  77. UPDATE IGNORE creature_proto SET spell1 = 52362, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28782;  
  78. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28817;  
  79. UPDATE IGNORE creature_proto SET spell1 = 52435, spell2 = 52576, spell3 = 0, spell4 = 0, spell5 = 52588, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28833;  
  80. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28851;  
  81. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 28864;  
  82. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29043;  
  83. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29306;  
  84. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29351;  
  85. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29358;  
  86. UPDATE IGNORE creature_proto SET spell1 = 54420, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29403;  
  87. UPDATE IGNORE creature_proto SET spell1 = 48766, spell2 = 54469, spell3 = 54467, spell4 = 55214, spell5 = 54422, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29414;  
  88. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29433;  
  89. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29460;  
  90. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29500;  
  91. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29555;  
  92. UPDATE IGNORE creature_proto SET spell1 = 54897, spell2 = 54907, spell3 = 54788, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29602;  
  93. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29625;  
  94. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29679;  
  95. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29691;  
  96. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29698;  
  97. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29708;  
  98. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29709;  
  99. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29753;  
  100. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29838;  
  101. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29857;  
  102. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 54459, spell5 = 54458, spell6 = 54460, spell7 = 0, spell8 = 0 WHERE entry = 29918;  
  103. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29929;  
  104. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 29931;  
  105. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30013;  
  106. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30021;  
  107. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30066;  
  108. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30090;  
  109. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30124;  
  110. UPDATE IGNORE creature_proto SET spell1 = 56091, spell2 = 56092, spell3 = 57090, spell4 = 57143, spell5 = 57108, spell6 = 57092, spell7 = 60534, spell8 = 0 WHERE entry = 30161;  
  111. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30174;  
  112. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30204;  
  113. UPDATE IGNORE creature_proto SET spell1 = 56683, spell2 = 56684, spell3 = 56712, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30228;  
  114. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30234;  
  115. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30248;  
  116. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30275;  
  117. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30320;  
  118. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30330;  
  119. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 56570, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30337;  
  120. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30342;  
  121. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30343;  
  122. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30403;  
  123. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30468;  
  124. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30470;  
  125. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30564;  
  126. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30585;  
  127. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30645;  
  128. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 30935;  
  129. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31125;  
  130. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31137;  
  131. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31139;  
  132. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31220;  
  133. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31224;  
  134. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31225;  
  135. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31262;  
  136. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31269;  
  137. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31406;  
  138. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31407;  
  139. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31408;  
  140. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31409;  
  141. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31583;  
  142. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31641;  
  143. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31702;  
  144. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31722;  
  145. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31748;  
  146. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31749;  
  147. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31830;  
  148. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31857;  
  149. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31858;  
  150. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31861;  
  151. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31862;  
  152. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31881;  
  153. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 31884;  
  154. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32189;  
  155. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32212;  
  156. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32213;  
  157. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32225;  
  158. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32227;  
  159. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32286;  
  160. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32323;  
  161. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32344;  
  162. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32490;  
  163. UPDATE IGNORE creature_proto SET spell1 = 56091, spell2 = 56092, spell3 = 57090, spell4 = 57143, spell5 = 57108, spell6 = 57403, spell7 = 0, spell8 = 0 WHERE entry = 32535;  
  164. UPDATE IGNORE creature_proto SET spell1 = 51678, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32627;  
  165. UPDATE IGNORE creature_proto SET spell1 = 51362, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32629;  
  166. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32640;  
  167. UPDATE IGNORE creature_proto SET spell1 = 49872, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32795;  
  168. UPDATE IGNORE creature_proto SET spell1 = 52338, spell2 = 60206, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32796;  
  169. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32930;  
  170. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 32934;  
  171. UPDATE IGNORE creature_proto SET spell1 = 62345, spell2 = 62522, spell3 = 62346, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33060;  
  172. UPDATE IGNORE creature_proto SET spell1 = 62974, spell2 = 62286, spell3 = 62299, spell4 = 64660, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33062;  
  173. UPDATE IGNORE creature_proto SET spell1 = 62358, spell2 = 62359, spell3 = 64677, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33067;  
  174. UPDATE IGNORE creature_proto SET spell1 = 62306, spell2 = 62490, spell3 = 62308, spell4 = 62324, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33109;  
  175. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33113;  
  176. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33114;  
  177. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33118;  
  178. UPDATE IGNORE creature_proto SET spell1 = 62634, spell2 = 64979, spell3 = 62479, spell4 = 62471, spell5 = 0, spell6 = 64414, spell7 = 0, spell8 = 0 WHERE entry = 33167;  
  179. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33214;  
  180. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33217;  
  181. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33288;  
  182. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33293;  
  183. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33316;  
  184. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33317;  
  185. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33318;  
  186. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33319;  
  187. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33320;  
  188. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33321;  
  189. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33322;  
  190. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33323;  
  191. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33324;  
  192. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33357;  
  193. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33513;  
  194. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33519;  
  195. UPDATE IGNORE creature_proto SET spell1 = 64588, spell2 = 64595, spell3 = 62563, spell4 = 62552, spell5 = 64077, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33531;  
  196. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33669;  
  197. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33687;  
  198. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33778;  
  199. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33782;  
  200. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33844;  
  201. UPDATE IGNORE creature_proto SET spell1 = 62544, spell2 = 62575, spell3 = 62960, spell4 = 62552, spell5 = 64077, spell6 = 62863, spell7 = 63034, spell8 = 0 WHERE entry = 33845;  
  202. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 33983;  
  203. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34045;  
  204. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34120;  
  205. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34161;  
  206. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34162;  
  207. UPDATE IGNORE creature_proto SET spell1 = 66218, spell2 = 66296, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 68362 WHERE entry = 34793;  
  208. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36557;  
  209. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36559;  
  210. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35635;  
  211. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35640;  
  212. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35634;  
  213. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35491;  
  214. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35638;  
  215. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35572;  
  216. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35299;  
  217. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35641;  
  218. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35373;  
  219. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34796;  
  220. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34826;  
  221. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35474;  
  222. UPDATE IGNORE creature_proto SET spell1 = 67452, spell2 = 68169, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34944;  
  223. UPDATE IGNORE creature_proto SET spell1 = 66518, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34929;  
  224. UPDATE IGNORE creature_proto SET spell1 = 68825, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34935;  
  225. UPDATE IGNORE creature_proto SET spell1 = 67442, spell2 = 68068, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34775;  
  226. UPDATE IGNORE creature_proto SET spell1 = 67816, spell2 = 69502, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34776;  
  227. UPDATE IGNORE creature_proto SET spell1 = 68827, spell2 = 69515, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35273;  
  228. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35336;  
  229. UPDATE IGNORE creature_proto SET spell1 = 67816, spell2 = 69502, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35069;  
  230. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35819;  
  231. UPDATE IGNORE creature_proto SET spell1 = 68832, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36356;  
  232. UPDATE IGNORE creature_proto SET spell1 = 67462, spell2 = 69505, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36355;  
  233. UPDATE IGNORE creature_proto SET spell1 = 68827, spell2 = 69515, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34802;  
  234. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35335;  
  235. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34703;  
  236. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 34658;  
  237. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35633;  
  238. UPDATE IGNORE creature_proto SET spell1 = 68505, spell2 = 62575, spell3 = 68282, spell4 = 66482, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35644;  
  239. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35768;  
  240. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36558;  
  241. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35636;  
  242. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 35637;  
  243. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36476;  
  244. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36619;  
  245. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36661;  
  246. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36794;  
  247. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36891;  
  248. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36896;  
  249. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 37120;  
  250. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 37187;  
  251. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 37813;  
  252. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38500;  
  253. UPDATE IGNORE creature_proto SET spell1 = 70346, spell2 = 71968, spell3 = 71617, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36678;  
  254. UPDATE IGNORE creature_proto SET spell1 = 70360, spell2 = 70539, spell3 = 70542, spell4 = 0, spell5 = 0, spell6 = 71516, spell7 = 0, spell8 = 0 WHERE entry = 37672;  
  255. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 37968;  
  256. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36838;  
  257. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38711;  
  258. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38712;  
  259. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 37626;  
  260. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38233;  
  261. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38638;  
  262. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38402;  
  263. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38459;  
  264. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38637;  
  265. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38582;  
  266. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38460;  
  267. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38156;  
  268. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38583;  
  269. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 36609;  
  270. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 40725;  
  271. UPDATE IGNORE creature_proto SET spell1 = 70360, spell2 = 70539, spell3 = 70542, spell4 = 0, spell5 = 0, spell6 = 71516, spell7 = 0, spell8 = 0 WHERE entry = 38285;  
  272. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 40081;  
  273. UPDATE IGNORE creature_proto SET spell1 = 72527, spell2 = 72457, spell3 = 70542, spell4 = 0, spell5 = 0, spell6 = 71516, spell7 = 0, spell8 = 0 WHERE entry = 38605;  
  274. UPDATE IGNORE creature_proto SET spell1 = 70360, spell2 = 72875, spell3 = 70542, spell4 = 0, spell5 = 0, spell6 = 71516, spell7 = 0, spell8 = 0 WHERE entry = 38786;  
  275. UPDATE IGNORE creature_proto SET spell1 = 72527, spell2 = 72876, spell3 = 70542, spell4 = 0, spell5 = 0, spell6 = 71516, spell7 = 0, spell8 = 0 WHERE entry = 38787;  
  276. UPDATE IGNORE creature_proto SET spell1 = 72527, spell2 = 72457, spell3 = 70542, spell4 = 0, spell5 = 0, spell6 = 71516, spell7 = 0, spell8 = 0 WHERE entry = 38788;  
  277. UPDATE IGNORE creature_proto SET spell1 = 70360, spell2 = 72875, spell3 = 70542, spell4 = 0, spell5 = 0, spell6 = 71516, spell7 = 0, spell8 = 0 WHERE entry = 38789;  
  278. UPDATE IGNORE creature_proto SET spell1 = 72527, spell2 = 72876, spell3 = 70542, spell4 = 0, spell5 = 0, spell6 = 71516, spell7 = 0, spell8 = 0 WHERE entry = 38790;  
  279. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38970;  
  280. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38971;  
  281. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38972;  
  282. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38973;  
  283. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38974;  
  284. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 38975;  
  285. UPDATE IGNORE creature_proto SET spell1 = 0, spell2 = 0, spell3 = 0, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 39714;  
  286. UPDATE IGNORE creature_proto SET spell1 = 75159, spell2 = 75160, spell3 = 75161, spell4 = 0, spell5 = 0, spell6 = 0, spell7 = 0, spell8 = 0 WHERE entry = 40305;
RAW Paste Data
Want to get better at SQL?
Learn to code SQL in 2017
Pastebin PRO Summer Special!
Get 40% OFF on Pastebin PRO accounts!
Top