[svn] * Proper SVN structureinit

--HG--
branch : trunk

1 files changed, 374 insertions, 0 deletions

diff --git a/src/bindings/scripts/sql/old/mangos_old_spells.sql b/src/bindings/scripts/sql/old/mangos_old_spells.sql
new file mode 100644
index 00000000000..8419cacd226
--- /dev/null
+++ b/src/bindings/scripts/sql/old/mangos_old_spells.sql
@@ -0,0 +1,374 @@
+/* Old spell queries from Scriptdev revision 55. Not supported by scriptdev anylonger */
+/* To be used in ordinary database developement. Can be added in any changeset/revision as database developers sees fit */
+
+UPDATE `creature_template` SET `spell1` = 116 WHERE `entry` = 946;
+UPDATE `creature_template` SET `spell1` = 16415 WHERE `entry` = 4063;
+UPDATE `creature_template` SET `spell1` = 205 WHERE `entry` = 1867;
+UPDATE `creature_template` SET `spell1` = 705 WHERE `entry` = 1915;
+UPDATE `creature_template` SET `spell1` = 145, `spell2` = 134 WHERE `entry` = 1914;
+UPDATE `creature_template` SET `spell1` = 837, `spell2` = 122 WHERE `entry` = 1889;
+UPDATE `creature_template` SET `spell1` = 8406, `spell2` = 865 WHERE `entry` = 314;
+UPDATE `creature_template` SET `spell1` = 6041, `spell2` = 6364 WHERE `entry` = 2570;
+UPDATE `creature_template` SET `spell1` = 8407, `spell2` = 12486 WHERE `entry` = 2567;
+UPDATE `creature_template` SET `spell1` = 6041 WHERE `entry` = 697;
+UPDATE `creature_template` SET `spell1` = 8402, `spell2` = 8423 WHERE `entry` = 1653;
+UPDATE `creature_template` SET `spell1` = 8402 WHERE `entry` = 1562;
+UPDATE `creature_template` SET `spell1` = 7641, `spell2` = 11707 WHERE `entry` = 1564;
+UPDATE `creature_template` SET `spell1` = 1106 WHERE `entry` = 3218;
+UPDATE `creature_template` SET `spell1` = 837 WHERE `entry` = 2591;
+UPDATE `creature_template` SET `spell1` = 837 WHERE `entry` = 2255;
+UPDATE `creature_template` SET `spell1` = 205 WHERE `entry` = 1539;
+UPDATE `creature_template` SET `spell1` = 15264, `spell2` = 6060, `spell3` = 988 WHERE `entry` = 4299;
+UPDATE `creature_template` SET `spell1` = 984, `spell2` = 1026 WHERE `entry` = 4296;
+UPDATE `creature_template` SET `spell1` = 8438, `spell2` = 2601 WHERE `entry` = 4300;
+UPDATE `creature_template` SET `spell1` = 1088, `spell2` = 992 WHERE `entry` = 533;
+UPDATE `creature_template` SET `spell1` = 7322 WHERE `entry` = 203;
+UPDATE `creature_template` SET `spell1` = 1106, `spell2` = 2941 WHERE `entry` = 2577;
+UPDATE `creature_template` SET `spell1` = 548, `spell2` = 6535 WHERE `entry` = 3273;
+UPDATE `creature_template` SET `spell1` = 529 WHERE `entry` = 1183;
+UPDATE `creature_template` SET `spell1` = 992, `spell2` = 705 WHERE `entry` = 436;
+UPDATE `creature_template` SET `spell1` = 5177 WHERE `entry` = 7235;
+UPDATE `creature_template` SET `spell1` = 5177 WHERE `entry` = 2012;
+UPDATE `creature_template` SET `spell1` = 403, `spell2` = 770 WHERE `entry` = 1397;
+UPDATE `creature_template` SET `spell1` = 2136 WHERE `entry` = 1174;
+UPDATE `creature_template` SET `spell1` = 143 WHERE `entry` = 2018;
+UPDATE `creature_template` SET `spell1` =  915, `spell2` =  2606 WHERE `entry` =  1399;
+UPDATE `creature_template` SET `spell1` =  915, `spell2` =  8293 WHERE `entry` =  3783;
+UPDATE `creature_template` SET `spell1` =  984 WHERE `entry` =  3732;
+UPDATE `creature_template` SET `spell1` =  13480 WHERE `entry` =  3725;
+UPDATE `creature_template` SET `spell1` =  13480 WHERE `entry` =  3728;
+UPDATE `creature_template` SET `spell1` =  9672, `spell2` =  7101 WHERE `entry` =  3662;
+UPDATE `creature_template` SET `spell1` =  18089 WHERE `entry` =  2207;
+UPDATE `creature_template` SET `spell1` =  8402, `spell2` =  10215 WHERE `entry` =  7026;
+UPDATE `creature_template` SET `spell1` =  11659, `spell2` =  8402 WHERE `entry` =  7028;
+UPDATE `creature_template` SET `spell1` =  7918, `spell2` =  6685 WHERE `entry` =  7038;
+UPDATE `creature_template` SET `spell1` = 676, `spell2` = 53, `spell3` = 0 WHERE `entry` = 6866;
+UPDATE `creature_template` SET `spell1` = 53, `spell2` = 0, `spell3` = 0 WHERE `entry` = 122;
+UPDATE `creature_template` SET `spell1` = 71, `spell2` = 1671 WHERE `entry` = 449;
+UPDATE `creature_template` SET `spell1` = 6554 WHERE `entry` = 121;
+UPDATE `creature_template` SET `spell1` = 53 WHERE `entry` = 590;
+UPDATE `creature_template` SET `spell1` = 12166 WHERE `entry` = 3232;
+UPDATE `creature_template` SET `spell1` = 403 WHERE `entry` = 2953;
+UPDATE `creature_template` SET `spell1` = 3385 WHERE `entry` = 2954;
+UPDATE `creature_template` SET `spell1` = 15657, `spell2` = 17230, `spell3` = 16509, `spell4` = 0 WHERE `entry` = 1707;
+UPDATE `creature_template` SET `spell1` = 6253, `spell2` = 16244, `spell3` = 8242, `spell4` = 16509 WHERE `entry` = 1711;
+UPDATE `creature_template` SET `spell1` = 6547, `spell2` = 2590, `spell3` = 6253 WHERE `entry` = 1708;
+UPDATE `creature_template` SET `spell1` = 11554, `spell2` = 8242, `spell3` = 6253 WHERE `entry` = 1715;
+UPDATE `creature_template` SET `spell1` = 1768, `spell2` = 17230, `spell3` = 16509 WHERE `entry` = 1706;
+UPDATE `creature_template` SET `spell1` = 5115 WHERE `entry` = 1729;
+UPDATE `creature_template` SET `spell1` = 9915 WHERE `entry` = 1732;
+UPDATE `creature_template` SET `spell1` = 143 WHERE `entry` = 1726;
+UPDATE `creature_template` SET `spell1` = 143 WHERE `entry` = 619;
+UPDATE `creature_template` SET `spell1` = 6660 WHERE `entry` = 657;
+UPDATE `creature_template` SET `spell1` = 6660, `spell2` = 6685 WHERE `entry` = 4417;
+UPDATE `creature_template` SET `spell1` = 6685 WHERE `entry` = 598;
+UPDATE `creature_template` SET `spell1` = 6016 WHERE `entry` = 4416;
+UPDATE `creature_template` SET `spell1` = 5115, `spell2` = 6435 WHERE `entry` = 594;
+UPDATE `creature_template` SET `spell1` = 9915 WHERE `entry` = 634;
+UPDATE `creature_template` SET `spell1` = 205 WHERE `entry` = 1725;
+UPDATE `creature_template` SET `spell1` = 133, `spell2` = 205, `spell3` = 113 WHERE `entry` = 4418;
+UPDATE `creature_template` SET `spell1` = 6136, `spell2` = 116 WHERE `entry` = 474;
+UPDATE `creature_template` SET `spell1` = 3140, `spell2` = 12486, `spell3` = 3443 WHERE `entry` = 910;
+UPDATE `creature_template` SET `spell1` = 744, `spell2` = 7992, `spell3` = 2590 WHERE `entry` = 909;
+UPDATE `creature_template` SET `spell1` = 8646 WHERE `entry` = 116;
+UPDATE `creature_template` SET `spell1` = 53 WHERE `entry` = 504;
+UPDATE `creature_template` SET `spell1` = 2764 WHERE `entry` = 95;
+UPDATE `creature_template` SET `spell1` = 53, `spell2` = 133 WHERE `entry` = 94;
+UPDATE `creature_template` SET `spell1` = 168 WHERE `entry` = 589;
+UPDATE `creature_template` SET `spell1` = 8382, `spell2` = 8733 WHERE `entry` = 4819;
+UPDATE `creature_template` SET `spell1` = 6145, `spell2` = 71, `spell3` = 22691 WHERE `entry` = 4818;
+UPDATE `creature_template` SET `spell1` = 14109, `spell2` = 3358, `spell3` = 8733, `spell4` = 12024 WHERE `entry` = 4820;
+UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 4359;
+UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 1024;
+UPDATE `creature_template` SET `spell1` = 1777, `spell2` = 6533 WHERE `entry` = 1028;
+UPDATE `creature_template` SET `spell1` = 10177 WHERE `entry` = 1418;
+UPDATE `creature_template` SET `spell1` = 744, `spell2` = 1707 WHERE `entry` = 1026;
+UPDATE `creature_template` SET `spell1` = 7372, `spell2` = 2457 WHERE `entry` = 1027;
+UPDATE `creature_template` SET `spell1` = 15869 WHERE `entry` = 1029;
+UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 747;
+UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 171;
+UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 544;
+UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 545;
+UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 578;
+UPDATE `creature_template` SET `spell1` = 744, `spell2` = 865 WHERE `entry` = 127;
+UPDATE `creature_template` SET `spell1` = 13519, `spell2` = 6074 WHERE `entry` = 517;
+UPDATE `creature_template` SET `spell1` = 10277 WHERE `entry` = 458;
+UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 126;
+UPDATE `creature_template` SET `spell1` = 205, `spell2` = 331 WHERE `entry` = 548;
+UPDATE `creature_template` SET `spell1` = 2589 WHERE `entry` = 732;
+UPDATE `creature_template` SET `spell1` = 3368 WHERE `entry` = 46;
+UPDATE `creature_template` SET `spell1` = 6268 WHERE `entry` = 1083;
+UPDATE `creature_template` SET `spell1` = 3393 WHERE `entry` = 422;
+UPDATE `creature_template` SET `spell1` = 3288 WHERE `entry` = 1011;
+UPDATE `creature_template` SET `spell1` = 8016 WHERE `entry` = 1008;
+UPDATE `creature_template` SET `spell1` = 8016 WHERE `entry` = 1007;
+UPDATE `creature_template` SET `spell1` = 205 WHERE `entry` = 1009;
+UPDATE `creature_template` SET `spell1` = 547, `spell2` = 548 WHERE `entry` = 1013;
+UPDATE `creature_template` SET `spell1` = 744 WHERE `entry` = 434;
+UPDATE `creature_template` SET `spell1` = 3150 WHERE `entry` = 433;
+UPDATE `creature_template` SET `spell1` = 6205 WHERE `entry` = 432;
+UPDATE `creature_template` SET `spell1` = 705 WHERE `entry` = 429;
+UPDATE `creature_template` SET `spell1` = 71, `spell2` = 8380, `spell3` = 8629 WHERE `entry` = 568;
+UPDATE `creature_template` SET `spell1` = 744 WHERE `entry` = 579;
+UPDATE `creature_template` SET `spell1` = 6730, `spell2` = 6016 WHERE `entry` = 448;
+UPDATE `creature_template` SET `spell1` = 6730, `spell2` = 6016 WHERE `entry` = 500;
+UPDATE `creature_template` SET `spell1` = 8016, `spell2` = 0 WHERE `entry` = 123;
+UPDATE `creature_template` SET `spell1` = 1160 WHERE `entry` = 124;
+UPDATE `creature_template` SET `spell1` = 3368 WHERE `entry` = 501;
+UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1674;
+UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1772;
+UPDATE `creature_template` SET `spell1` = 3237, `spell2` = 695 WHERE `entry` = 1773;
+UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1939;
+UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1940;
+UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1942;
+UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1944;
+UPDATE `creature_template` SET `spell1` = 2480 WHERE `entry` = 3112;
+UPDATE `creature_template` SET `spell1` = 5280 WHERE `entry` = 3111;
+UPDATE `creature_template` SET `spell1` = 3248 WHERE `entry` = 3114;
+UPDATE `creature_template` SET `spell1` = 6950, `spell2` = 774 WHERE `entry` = 3113;
+UPDATE `creature_template` SET `spell1` = 548, `spell2` = 8045, `spell3` = 8052 WHERE `entry` = 3269;
+UPDATE `creature_template` SET `spell1` = 594, `spell2` = 8092, `spell3` = 2052 WHERE `entry` = 3458;
+UPDATE `creature_template` SET `spell1` = 594, `spell2` = 598, `spell3` = 8102, `spell4` = 6074 WHERE `entry` = 3271;
+UPDATE `creature_template` SET `spell1` = 1978, `spell2` = 3044 WHERE `entry` = 3265;
+UPDATE `creature_template` SET `spell1` = 13446, `spell2` = 12323, `spell3` = 13443 WHERE `entry` = 3459;
+UPDATE `creature_template` SET `spell1` = 22356 WHERE `entry` = 3267;
+UPDATE `creature_template` SET `spell1` = 3427 WHERE `entry` = 712;
+UPDATE `creature_template` SET `spell1` = 5164 WHERE `entry` = 446;
+UPDATE `creature_template` SET `spell1` = 331, `spell2` = 548 WHERE `entry` = 430;
+UPDATE `creature_template` SET `spell1` = 7919 WHERE `entry` = 424;
+UPDATE `creature_template` SET `spell1` = 3148 WHERE `entry` = 1115;
+UPDATE `creature_template` SET `spell1` = 5164 WHERE `entry` = 1117;
+UPDATE `creature_template` SET `spell1` = 53 WHERE `entry` = 1116;
+UPDATE `creature_template` SET `spell1` = 5164 WHERE `entry` = 1118;
+UPDATE `creature_template` SET `spell1` = 10277 WHERE `entry` = 1162;
+UPDATE `creature_template` SET `spell1` = 529 WHERE `entry` = 1166;
+UPDATE `creature_template` SET `spell1` = 1776 WHERE `entry` = 1163;
+UPDATE `creature_template` SET `spell1` = 11976 WHERE `entry` = 1164;
+UPDATE `creature_template` SET `spell1` = 331 WHERE `entry` = 1197;
+UPDATE `creature_template` SET `spell1` = 2121 WHERE `entry` = 1165;
+UPDATE `creature_template` SET `spell1` = 7405, `spell2` = 71 WHERE `entry` = 1167;
+UPDATE `creature_template` SET `spell1` = 11660, `spell2` = 17926, `spell3` = 6215, `spell4` = 11672 WHERE `entry` = 1789;
+UPDATE `creature_template` SET `spell1` = 348, `spell2` = 686 WHERE `entry` = 4473;
+UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 15613, `spell3` = 23600, `spell4` = 16406 WHERE `entry` = 10391;
+UPDATE `creature_template` SET `spell1` = 3416 WHERE `entry` = 531;
+UPDATE `creature_template` SET `spell1` = 7369 WHERE `entry` = 1783;
+UPDATE `creature_template` SET `spell1` = 838 WHERE `entry` = 7341;
+UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 15613, `spell3` = 16406 WHERE `entry` = 10390;
+UPDATE `creature_template` SET `spell1` = 9734, `spell2` = 6074 WHERE `entry` = 787;
+UPDATE `creature_template` SET `spell1` = 7322, `spell2` = 12486 WHERE `entry` = 203;
+UPDATE `creature_template` SET `spell1` = 7992 WHERE `entry` = 1110;
+UPDATE `creature_template` SET `spell1` = 17312, `spell2` = 992, `spell3` = 984 WHERE `entry` = 7340;
+UPDATE `creature_template` SET `spell1` = 22940, `spell2` = 1411 WHERE `entry` = 1784;
+UPDATE `creature_template` SET `spell1` = 705, `spell2` = 1014 WHERE `entry` = 7342;
+UPDATE `creature_template` SET `spell1` = 8699 WHERE `entry` = 785;
+UPDATE `creature_template` SET `spell1` = 7373 WHERE `entry` = 48;
+UPDATE `creature_template` SET `spell1` = 19644, `spell2` = 21949, `spell3` = 19642 WHERE `entry` = 6488;
+UPDATE `creature_template` SET `spell1` = 10179, `spell2` = 22645, `spell3` = 13009, `spell4` = 12556 WHERE `entry` = 7358;
+UPDATE `creature_template` SET `spell1` = 10148, `spell2` = 12470 WHERE `entry` = 7357;
+UPDATE `creature_template` SET `spell1` = 12947, `spell2` = 12946 WHERE `entry` = 7356;
+UPDATE `creature_template` SET `spell1` = 12255, `spell2` = 12252, `spell3` = 12254 WHERE `entry` = 7355;
+UPDATE `creature_template` SET `spell1` = 10892, `spell2` = 11659 WHERE `entry` = 7354;
+UPDATE `creature_template` SET `spell1` = 21667, `spell2` = 21331, `spell3` = 21793 WHERE `entry` = 12225;
+UPDATE `creature_template` SET `spell1` = 21080, `spell2` = 8817 WHERE `entry` = 12236;
+UPDATE `creature_template` SET `spell1` = 24375, `spell2` = 15580 WHERE `entry` = 12237;
+UPDATE `creature_template` SET `spell1` = 21909, `spell2` = 21832, `spell3` = 19128, `spell4` = 21869 WHERE `entry` = 12201;
+UPDATE `creature_template` SET `spell1` = 21911, `spell2` = 15584, `spell3` = 21749 WHERE `entry` = 12258;
+UPDATE `creature_template` SET `spell1` = 21833, `spell2` = 22334 WHERE `entry` = 13601;
+UPDATE `creature_template` SET `spell1` = 21687, `spell2` = 21547, `spell3` = 21707 WHERE `entry` = 13282;
+UPDATE `creature_template` SET `spell1` = 9770, `spell2` = 16145, `spell3` = 1604, `spell4` = 9776 WHERE `entry` = 6206;
+UPDATE `creature_template` SET `spell1` = 9770, `spell2` = 1604, `spell3` = 12540 WHERE `entry` = 6208;
+UPDATE `creature_template` SET `spell1` = 10851 WHERE `entry` = 6209;
+UPDATE `creature_template` SET `spell1` = 1604, `spell2` = 6409, `spell3` = 3420 WHERE `entry` = 6215;
+UPDATE `creature_template` SET `spell1` = 9459, `spell2` = 1604, `spell3` = 10341, `spell4` = 11638 WHERE `entry` = 6219;
+UPDATE `creature_template` SET `spell1` = 16169, `spell2` = 5568, `spell3` = 10887 WHERE `entry` = 6229;
+UPDATE `creature_template` SET `spell1` = 3053, `spell2` = 16412 WHERE `entry` = 6228;
+UPDATE `creature_template` SET `spell1` = 11082, `spell2` = 11085, `spell3` = 11084 WHERE `entry` = 6235;
+UPDATE `creature_template` SET `spell1` = 1604 WHERE `entry` = 7361;
+UPDATE `creature_template` SET `spell1` = 6660, `spell2` = 8858 WHERE `entry` = 6407;
+UPDATE `creature_template` SET `spell1` = 8211, `spell2` = 10341, `spell3` = 1604, `spell4` = 9459 WHERE `entry` = 6220;
+UPDATE `creature_template` SET `spell1` = 10341, `spell2` = 1604, `spell3` = 9459 WHERE `entry` = 6218;
+UPDATE `creature_template` SET `spell1` = 1604, `spell2` = 11264, `spell3` = 12024 WHERE `entry` = 7603;
+UPDATE `creature_template` SET `spell1` = 6660, `spell2` = 2643, `spell3` = 5116 WHERE `entry` = 6223;
+UPDATE `creature_template` SET `spell1` = 13398, `spell2` = 1604, `spell3` = 12024 WHERE `entry` = 6222;
+UPDATE `creature_template` SET `spell1` = 11820, `spell2` = 1604 WHERE `entry` = 6234;
+UPDATE `creature_template` SET `spell1` = 1604 WHERE `entry` = 6233;
+UPDATE `creature_template` SET `spell1` = 11306, `spell2` = 10733 WHERE `entry` = 6226;
+UPDATE `creature_template` SET `spell1` = 22519, `spell2` = 11264 WHERE `entry` = 6227;
+UPDATE `creature_template` SET `spell1` = 10346, `spell2` = 1604, `spell3` = 17174 WHERE `entry` = 6225;
+UPDATE `creature_template` SET `spell1` = 6533, `spell2` = 1604, `spell3` = 11820, `spell4` = 11084 WHERE `entry` = 6230;
+UPDATE `creature_template` SET `spell1` = 10341, `spell2` = 9459 WHERE `entry` = 7079;
+UPDATE `creature_template` SET `spell1` = 22689, `spell2` = 22662, `spell3` = 19319 WHERE `entry` = 11492;
+UPDATE `creature_template` SET `spell1` = 15708, `spell2` = 23511 WHERE `entry` = 14325;
+UPDATE `creature_template` SET `spell1` = 10947, `spell2` = 10151 WHERE `entry` = 14324;
+UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 15655, `spell3` = 22572, `spell4` = 20691 WHERE `entry` = 14321;
+UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 15655, `spell3` = 20691 WHERE `entry` = 14326;
+UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 17307, `spell3` = 20691 WHERE `entry` = 14323;
+UPDATE `creature_template` SET `spell1` = 22419, `spell2` = 22420, `spell3` = 22421 WHERE `entry` = 13280;
+UPDATE `creature_template` SET `spell1` = 22422 WHERE `entry` = 14122;
+UPDATE `creature_template` SET `spell1` = 5116, `spell2` = 20904, `spell3` = 14290, `spell4` = 14295 WHERE `entry` = 11488;
+UPDATE `creature_template` SET `spell1` = 16128, `spell2` = 15550, `spell3` = 22899 WHERE `entry` = 11496;
+UPDATE `creature_template` SET `spell1` = 22909 WHERE `entry` = 14396;
+UPDATE `creature_template` SET `spell1` = 15708, `spell2` = 24375 WHERE `entry` = 11501;
+UPDATE `creature_template` SET `spell1` = 11668, `spell2` = 14887 WHERE `entry` = 14327;
+UPDATE `creature_template` SET `spell1` = 10984 WHERE `entry` = 14506;
+UPDATE `creature_template` SET `spell1` = 10894, `spell2` = 10947, `spell3` = 18807 WHERE `entry` = 11487;
+UPDATE `creature_template` SET `spell1` = 20691, `spell2` = 22920 WHERE `entry` = 11486;
+UPDATE `creature_template` SET `spell1` = 22424, `spell2` = 10151, `spell3` = 16144 WHERE `entry` = 14354;
+UPDATE `creature_template` SET `spell1` = 20691, `spell2` = 24375 WHERE `entry` = 11498;
+UPDATE `creature_template` SET `spell1` = 15550, `spell2` = 22924, `spell3` = 22994 WHERE `entry` = 11489;
+UPDATE `creature_template` SET `spell1` = 22478, `spell2` = 22651 WHERE `entry` = 11490;
+UPDATE `creature_template` SET `spell1` = 20832, `spell2` = 16102, `spell3` = 15530, `spell4` = 16170 WHERE `entry` = 11444;
+UPDATE `creature_template` SET `spell1` = 22572, `spell2` = 22916 WHERE `entry` = 11450;
+UPDATE `creature_template` SET `spell1` = 13737, `spell2` = 20677, `spell3` = 24317 WHERE `entry` = 11441;
+UPDATE `creature_template` SET `spell1` = 19474 WHERE `entry` = 11457;
+UPDATE `creature_template` SET `spell1` = 22460, `spell2` = 22272 WHERE `entry` = 13197;
+UPDATE `creature_template` SET `spell1`=512, `spell2`=1010, `spell3`=0, `spell4`=0 WHERE `entry`=10415;
+UPDATE `creature_template` SET `spell1`=1096, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10917;
+UPDATE `creature_template` SET `spell1`=20603, `spell2`=15398, `spell3`=9256, `spell4`=20741 WHERE `entry`=10813;
+UPDATE `creature_template` SET `spell1`=16565, `spell2`=16867, `spell3`=18327, `spell4`=0 WHERE `entry`=10436;
+UPDATE `creature_template` SET `spell1`=16866, `spell2`=1604, `spell3`=0, `spell4`=0 WHERE `entry`=10697;
+UPDATE `creature_template` SET `spell1`=1604, `spell2`=16866, `spell3`=0, `spell4`=0 WHERE `entry`=10416;
+UPDATE `creature_template` SET `spell1`=17439, `spell2`=15584, `spell3`=1604, `spell4`=0 WHERE `entry`=10394;
+UPDATE `creature_template` SET `spell1`=1604, `spell2`=5884, `spell3`=0, `spell4`=0 WHERE `entry`=11121;
+UPDATE `creature_template` SET `spell1`=16140, `spell2`=1604, `spell3`=0, `spell4`=0 WHERE `entry`=10383;
+UPDATE `creature_template` SET `spell1`=1604, `spell2`=3589, `spell3`=0, `spell4`=0 WHERE `entry`=8530;
+UPDATE `creature_template` SET `spell1`=23382, `spell2`=15615, `spell3`=16496, `spell4`=0 WHERE `entry`=10997;
+UPDATE `creature_template` SET `spell1`=13020, `spell2`=23413, `spell3`=0, `spell4`=0 WHERE `entry`=10425;
+UPDATE `creature_template` SET `spell1`=17293, `spell2`=23462, `spell3`=17274, `spell4`=0 WHERE `entry`=10811;
+UPDATE `creature_template` SET `spell1`=1604, `spell2`=15749, `spell3`=11972, `spell4`=13534 WHERE `entry`=13118;
+UPDATE `creature_template` SET `spell1`=11831, `spell2`=23412, `spell3`=1604, `spell4`=0 WHERE `entry`=10419;
+UPDATE `creature_template` SET `spell1`=5101, `spell2`=17143, `spell3`=13005, `spell4`=0 WHERE `entry`=12337;
+UPDATE `creature_template` SET `spell1`=13005, `spell2`=1604, `spell3`=20005, `spell4`=0 WHERE `entry`=10421;
+UPDATE `creature_template` SET `spell1`=36647, `spell2`=17143, `spell3`=1604, `spell4`=0 WHERE `entry`=10424;
+UPDATE `creature_template` SET `spell1`=15749, `spell2`=33871, `spell3`=1604, `spell4`=0 WHERE `entry`=10418;
+UPDATE `creature_template` SET `spell1`=17445, `spell2`=1604, `spell3`=39077, `spell4`=0 WHERE `entry`=11120;
+UPDATE `creature_template` SET `spell1`=17287, `spell2`=1604, `spell3`=22645, `spell4`=0 WHERE `entry`=10420;
+UPDATE `creature_template` SET `spell1`=22645, `spell2`=17165, `spell3`=22947, `spell4`=0 WHERE `entry`=10426;
+UPDATE `creature_template` SET `spell1`=36033, `spell2`=17145, `spell3`=1604, `spell4`=0 WHERE `entry`=11043;
+UPDATE `creature_template` SET `spell1`=36176, `spell2`=36947, `spell3`=1604, `spell4`=0 WHERE `entry`=10423;
+UPDATE `creature_template` SET `spell1`=38094, `spell2`=1604, `spell3`=6788, `spell4`=0 WHERE `entry`=11054;
+UPDATE `creature_template` SET `spell1`=15451, `spell2`=16927, `spell3`=16144, `spell4`=15534 WHERE `entry`=10422;
+UPDATE `creature_template` SET `spell1`=22412, `spell2`=4962, `spell3`=1604, `spell4`=3589 WHERE `entry`=10413;
+UPDATE `creature_template` SET `spell1`=15471, `spell2`=1604, `spell3`=3589, `spell4`=16430 WHERE `entry`=10412;
+UPDATE `creature_template` SET `spell1`=16401, `spell2`=12023, `spell3`=1604, `spell4`=20812 WHERE `entry`=8556;
+UPDATE `creature_template` SET `spell1`=4629, `spell2`=20549, `spell3`=20812, `spell4`=21949 WHERE `entry`=11859;
+UPDATE `creature_template` SET `spell1`=1604, `spell2`=15530, `spell3`=15531, `spell4`=16458 WHERE `entry`=15607;
+UPDATE `creature_template` SET `spell1`=16388, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10557;
+UPDATE `creature_template` SET `spell1`=18200, `spell2`=1604, `spell3`=9791, `spell4`=16458 WHERE `entry`=10407;
+UPDATE `creature_template` SET `spell1`=7964, `spell2`=20712, `spell3`=1604, `spell4`=23511 WHERE `entry`=11058;
+UPDATE `creature_template` SET `spell1`=16249, `spell2`=16143, `spell3`=16449, `spell4`=0 WHERE `entry`=11136;
+UPDATE `creature_template` SET `spell1`=22687, `spell2`=1604, `spell3`=0, `spell4`=0 WHERE `entry`=10385;
+UPDATE `creature_template` SET `spell1`=12538, `spell2`=15608, `spell3`=16172, `spell4`=1604 WHERE `entry`=10406;
+UPDATE `creature_template` SET `spell1`=17286, `spell2`=1604, `spell3`=20830, `spell4`=0 WHERE `entry`=10812;
+UPDATE `creature_template` SET `spell1`=3589, `spell2`=16867, `spell3`=1604, `spell4`=0 WHERE `entry`=8541;
+UPDATE `creature_template` SET `spell1`=17685, `spell2`=18663, `spell3`=19643, `spell4`=20812 WHERE `entry`=16101;
+UPDATE `creature_template` SET `spell1`=16793, `spell2`=10887, `spell3`=14099, `spell4`=1604 WHERE `entry`=10435;
+UPDATE `creature_template` SET `spell1`=15850, `spell2`=16249, `spell3`=20743, `spell4`=16869 WHERE `entry`=10438;
+UPDATE `creature_template` SET `spell1`=12734, `spell2`=16172, `spell3`=1604, `spell4`=6788 WHERE `entry`=11032;
+UPDATE `creature_template` SET `spell1`=16143, `spell2`=1604, `spell3`=15043, `spell4`=0 WHERE `entry`=10382;
+UPDATE `creature_template` SET `spell1`=1604, `spell2`=6788, `spell3`=0, `spell4`=0 WHERE `entry`=11197;
+UPDATE `creature_template` SET `spell1`=1604, `spell2`=6788, `spell3`=0, `spell4`=0 WHERE `entry`=11030;
+UPDATE `creature_template` SET `spell1`=5568, `spell2`=17307, `spell3`=1604, `spell4`=6788 WHERE `entry`=10439;
+UPDATE `creature_template` SET `spell1`=19813, `spell2`=4283, `spell3`=0, `spell4`=0 WHERE `entry`=11658;
+UPDATE `creature_template` SET `spell1`=19393, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11668;
+UPDATE `creature_template` SET `spell1`=25787, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12101;
+UPDATE `creature_template` SET `spell1`=19364, `spell2`=19365, `spell3`=19369, `spell4`=19367 WHERE `entry`=11673;
+UPDATE `creature_template` SET `spell1`=4283, `spell2`=19813, `spell3`=0, `spell4`=0 WHERE `entry`=11659;
+UPDATE `creature_template` SET `spell1`=20228, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12143;
+UPDATE `creature_template` SET `spell1`=20203, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11669;
+UPDATE `creature_template` SET `spell1`=24668, `spell2`=23952, `spell3`=10960, `spell4`=0 WHERE `entry`=11663;
+UPDATE `creature_template` SET `spell1`=23952, `spell2`=20294, `spell3`=0, `spell4`=0 WHERE `entry`=11662;
+UPDATE `creature_template` SET `spell1`=20677, `spell2`=20740, `spell3`=0, `spell4`=0 WHERE `entry`=12119;
+UPDATE `creature_template` SET `spell1`=20623, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11664;
+UPDATE `creature_template` SET `spell1`=19778, `spell2`=19771, `spell3`=0, `spell4`=0 WHERE `entry`=11671;
+UPDATE `creature_template` SET `spell1`=21081, `spell2`=19730, `spell3`=0, `spell4`=0 WHERE `entry`=11661;
+UPDATE `creature_template` SET `spell1`=19626, `spell2`=19630, `spell3`=19631, `spell4`=0 WHERE `entry`=11667;
+UPDATE `creature_template` SET `spell1`=19798, `spell2`=19496, `spell3`=0, `spell4`=0 WHERE `entry`=12806;
+UPDATE `creature_template` SET `spell1`=19635, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11666;
+UPDATE `creature_template` SET `spell1`=19642, `spell2`=19644, `spell3`=0, `spell4`=0 WHERE `entry`=12100;
+UPDATE `creature_template` SET `spell1`=19641, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12076;
+UPDATE `creature_template` SET `spell1`=20294, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12099;
+UPDATE `creature_template` SET `spell1`=18108, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12265;
+UPDATE `creature_template` SET `spell1`=22689, `spell2`=19319, `spell3`=0, `spell4`=0 WHERE `entry`=11672;
+UPDATE `creature_template` SET `spell1`=35178, `spell2`=15749, `spell3`=0, `spell4`=0 WHERE `entry`=10509;
+UPDATE `creature_template` SET `spell1`=35178, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=9819;
+UPDATE `creature_template` SET `spell1`=30688, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10319;
+UPDATE `creature_template` SET `spell1`=20816, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=9817;
+UPDATE `creature_template` SET `spell1`=32192, `spell2`=18108, `spell3`=0, `spell4`=0 WHERE `entry`=9818;
+UPDATE `creature_template` SET `spell1`=23462, `spell2`=23341, `spell3`=17274, `spell4`=0 WHERE `entry`=9816;
+UPDATE `creature_template` SET `spell1`=24317, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10258;
+UPDATE `creature_template` SET `spell1`=145, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10161;
+UPDATE `creature_template` SET `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10683;
+UPDATE `creature_template` SET `spell1`=28725, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10264;
+UPDATE `creature_template` SET `spell1`=12461, `spell2`=22591, `spell3`=16172, `spell4`=24317 WHERE `entry`=10899;
+UPDATE `creature_template` SET `spell1`=12461, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10317;
+UPDATE `creature_template` SET `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10762;
+UPDATE `creature_template` SET `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10742;
+UPDATE `creature_template` SET `spell1`=30014, `spell2`=32370, `spell3`=0, `spell4`=0 WHERE `entry`=10447;
+UPDATE `creature_template` SET `spell1`=22414, `spell2`=23512, `spell3`=0, `spell4`=0 WHERE `entry`=10442;
+UPDATE `creature_template` SET `spell1`=20691, `spell2`=15589, `spell3`=23931, `spell4`=0 WHERE `entry`=10429;
+UPDATE `creature_template` SET `spell1`=20667, `spell2`=20712, `spell3`=18763, `spell4`=0 WHERE `entry`=10339;
+UPDATE `creature_template` SET `spell1`=11286, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10318;
+UPDATE `creature_template` SET `spell1`=23462, `spell2`=25668, `spell3`=0, `spell4`=0 WHERE `entry`=10372;
+UPDATE `creature_template` SET `spell1`=28168, `spell2`=27580, `spell3`=0, `spell4`=0 WHERE `entry`=10371;
+UPDATE `creature_template` SET `spell1`=23462, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10083;
+UPDATE `creature_template` SET `spell1`=20741, `spell2`=24668, `spell3`=0, `spell4`=0 WHERE `entry`=10162;
+UPDATE `creature_template` SET `spell1`=17883, `spell2`=16785, `spell3`=0, `spell4`=0 WHERE `entry`=10430;
+UPDATE `creature_template` SET `spell1`=23462, `spell2`=20691, `spell3`=23023, `spell4`=23931 WHERE `entry`=10363;
+UPDATE `creature_template` SET `spell1`=20276, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10814;
+UPDATE `creature_template` SET `spell1`=13496, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11598;
+UPDATE `creature_template` SET `spell1`=27559, `spell2`=20691, `spell3`=12020, `spell4`=30138 WHERE `entry`=10487;
+UPDATE `creature_template` SET `spell1`=17715, `spell2`=27559, `spell3`=20276, `spell4`=0 WHERE `entry`=10491;
+UPDATE `creature_template` SET `spell1`=11660, `spell2`=18807, `spell3`=0, `spell4`=0 WHERE `entry`=10470;
+UPDATE `creature_template` SET `spell1`=18270, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10481;
+UPDATE `creature_template` SET `spell1`=18116, `spell2`=17695, `spell3`=20741, `spell4`=15584 WHERE `entry`=10433;
+UPDATE `creature_template` SET `spell1`=17472, `spell2`=15584, `spell3`=0, `spell4`=0 WHERE `entry`=10482;
+UPDATE `creature_template` SET `spell1`=18106, `spell2`=18116, `spell3`=15584, `spell4`=0 WHERE `entry`=11261;
+UPDATE `creature_template` SET `spell1`=18116, `spell2`=20741, `spell3`=18144, `spell4`=0 WHERE `entry`=10506;
+UPDATE `creature_template` SET `spell1`=11672, `spell2`=12020, `spell3`=18116, `spell4`=0 WHERE `entry`=10505;
+UPDATE `creature_template` SET `spell1`=16359, `spell2`=3584, `spell3`=18116, `spell4`=0 WHERE `entry`=10901;
+UPDATE `creature_template` SET `spell1`=24375, `spell2`=18813, `spell3`=18116, `spell4`=0 WHERE `entry`=11622;
+UPDATE `creature_template` SET `spell1`=15550, `spell2`=20691, `spell3`=18116, `spell4`=0 WHERE `entry`=10507;
+UPDATE `creature_template` SET `spell1`=11668, `spell2`=11700, `spell3`=18116, `spell4`=0 WHERE `entry`=10504;
+UPDATE `creature_template` SET `spell1`=24673, `spell2`=18270, `spell3`=18116, `spell4`=0 WHERE `entry`=10503;
+UPDATE `creature_template` SET `spell1`=15584, `spell2`=17472, `spell3`=0, `spell4`=0 WHERE `entry`=11439;
+UPDATE `creature_template` SET `spell1`=18116, `spell2`=19460, `spell3`=6215, `spell4`=15487 WHERE `entry`=10502;
+UPDATE `creature_template` SET `spell1`=18702, `spell2`=10212, `spell3`=18116, `spell4`=0 WHERE `entry`=1853;
+UPDATE `creature_template` SET `spell1`=16350, `spell2`=21369, `spell3`=8398, `spell4`=18033 WHERE `entry`=10508;
+UPDATE `creature_template` SET `spell1`=27224, `spell2`=30900, `spell3`=3609, `spell4`=0 WHERE `entry`=14861;
+UPDATE `creature_template` SET `spell1`=18278, `spell2`=29405, `spell3`=12020, `spell4`=0 WHERE `entry`=10498;
+UPDATE `creature_template` SET `spell1`=24063, `spell2`=18270, `spell3`=0, `spell4`=0 WHERE `entry`=10495;
+UPDATE `creature_template` SET `spell1`=12020, `spell2`=18278, `spell3`=25304, `spell4`=0 WHERE `entry`=11263;
+UPDATE `creature_template` SET `spell1`=16469, `spell2`=25349, `spell3`=0, `spell4`=0 WHERE `entry`=11551;
+UPDATE `creature_template` SET `spell1`=25304, `spell2`=11660, `spell3`=12020, `spell4`=0 WHERE `entry`=10477;
+UPDATE `creature_template` SET `spell1`=25304, `spell2`=12020, `spell3`=10161, `spell4`=0 WHERE `entry`=10472;
+UPDATE `creature_template` SET `spell1`=15571, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10475;
+UPDATE `creature_template` SET `spell1`=25304, `spell2`=10161, `spell3`=10473, `spell4`=0 WHERE `entry`=10469;
+UPDATE `creature_template` SET `spell1`=11660, `spell2`=15571, `spell3`=10161, `spell4`=0 WHERE `entry`=11284;
+UPDATE `creature_template` SET `spell1`=17689, `spell2`=15571, `spell3`=18270, `spell4`=0 WHERE `entry`=10480;
+UPDATE `creature_template` SET `spell1`=15571, `spell2`=30138, `spell3`=0, `spell4`=0 WHERE `entry`=10497;
+UPDATE `creature_template` SET `spell1`=15571, `spell2`=30138, `spell3`=0, `spell4`=0 WHERE `entry`=10479;
+UPDATE `creature_template` SET `spell1`=17504, `spell2`=12867, `spell3`=0, `spell4`=0 WHERE `entry`=14513;
+UPDATE `creature_template` SET `spell1`=17504, `spell2`=12867, `spell3`=24673, `spell4`=0 WHERE `entry`=14520;
+UPDATE `creature_template` SET `spell1`=30138, `spell2`=11660, `spell3`=0, `spell4`=0 WHERE `entry`=14521;
+UPDATE `creature_template` SET `spell1`=11556, `spell2`=8140, `spell3`=23262, `spell4`=0 WHERE `entry`=14518;
+UPDATE `creature_template` SET `spell1`=10894, `spell2`=23244, `spell3`=0, `spell4`=0 WHERE `entry`=14519;
+UPDATE `creature_template` SET `spell1`=11556, `spell2`=8140, `spell3`=15571, `spell4`=0 WHERE `entry`=14514;
+UPDATE `creature_template` SET `spell1`=15571, `spell2`=23244, `spell3`=0, `spell4`=0 WHERE `entry`=14512;
+UPDATE `creature_template` SET `spell1`=12292, `spell2`=15571, `spell3`=28168, `spell4`=0 WHERE `entry`=10488;
+UPDATE `creature_template` SET `spell1`=15571, `spell2`=24063, `spell3`=18270, `spell4`=12021 WHERE `entry`=10485;
+UPDATE `creature_template` SET `spell1`=10161, `spell2`=13021, `spell3`=20883, `spell4`=0 WHERE `entry`=11257;
+UPDATE `creature_template` SET `spell1`=15571, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10478;
+UPDATE `creature_template` SET `spell1`=17504, `spell2`=26554, `spell3`=35011, `spell4`=0 WHERE `entry`=10486;
+UPDATE `creature_template` SET `spell1`=19627, `spell2`=18816, `spell3`=13021, `spell4`=0 WHERE `entry`=10432;
+UPDATE `creature_template` SET `spell1`=18807, `spell2`=10876, `spell3`=0, `spell4`=0 WHERE `entry`=10471;
+UPDATE `creature_template` SET `spell1`=10876, `spell2`=25304, `spell3`=18647, `spell4`=0 WHERE `entry`=10500;
+UPDATE `creature_template` SET `spell1`=29684, `spell2`=25051, `spell3`=0, `spell4`=0 WHERE `entry`=10489;
+
+UPDATE `creature_template` SET `spell1` = 24317, `spell2` = 19644 WHERE `entry` =  8890;
+UPDATE `creature_template` SET `spell1` = 30901, `spell2` = 27581, `spell3` = 34510 WHERE `entry` = 8891;
+UPDATE `creature_template` SET `spell1` = 29560, `spell2` = 19644 WHERE `entry` = 8892;
+UPDATE `creature_template` SET `spell1` = 40082, `spell2` = 30901 WHERE `entry` = 8893;
+UPDATE `creature_template` SET `spell1` = 8812,  `spell2` = 10961, `spell3` = 10947 WHERE `entry` = 8894;
+UPDATE `creature_template` SET `spell1` = 25292, `spell2` = 1020 WHERE `entry` = 8895;
+UPDATE `creature_template` SET `spell1` = 17143, `spell2` = 10293, `spell3` = 25292 WHERE `entry` = 8898;