DB/Spells: Added missing EffectItemType stuff in spell_dbc table

1 files changed, 213 insertions, 0 deletions

diff --git a/sql/updates/world/2014_09_21_01_world_spell_dbc.sql b/sql/updates/world/2014_09_21_01_world_spell_dbc.sql
new file mode 100644
index 00000000000..55b02edfc59
--- /dev/null
+++ b/sql/updates/world/2014_09_21_01_world_spell_dbc.sql
@@ -0,0 +1,213 @@
+UPDATE `spell_dbc` SET `EffectItemType1` = 11522 WHERE `Id` = 13909;
+UPDATE `spell_dbc` SET `EffectItemType1` = 12563 WHERE `Id` = 16548;
+UPDATE `spell_dbc` SET `EffectItemType1` = 16787 WHERE `Id` = 20693;
+UPDATE `spell_dbc` SET `EffectItemType1` = 8051  WHERE `Id` = 22190;
+UPDATE `spell_dbc` SET `EffectItemType1` = 2756  WHERE `Id` = 22208;
+UPDATE `spell_dbc` SET `EffectItemType1` = 2757  WHERE `Id` = 22209;
+UPDATE `spell_dbc` SET `EffectItemType1` = 2758  WHERE `Id` = 22210;
+UPDATE `spell_dbc` SET `EffectItemType1` = 2759  WHERE `Id` = 22211;
+UPDATE `spell_dbc` SET `EffectItemType1` = 7586  WHERE `Id` = 22837;
+UPDATE `spell_dbc` SET `EffectItemType1` = 18513 WHERE `Id` = 22925;
+UPDATE `spell_dbc` SET `EffectItemType1` = 11286 WHERE `Id` = 22941;
+UPDATE `spell_dbc` SET `EffectItemType1` = 15875 WHERE `Id` = 22942;
+UPDATE `spell_dbc` SET `EffectItemType1` = 8432  WHERE `Id` = 22943;
+UPDATE `spell_dbc` SET `EffectItemType1` = 8095  WHERE `Id` = 22944;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19016 WHERE `Id` = 22958;
+UPDATE `spell_dbc` SET `EffectItemType1` = 6265  WHERE `Id` = 23464;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19004 WHERE `Id` = 23518;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19005 WHERE `Id` = 23519;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19642 WHERE `Id` = 23975;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19574 WHERE `Id` = 23998;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19575 WHERE `Id` = 23999;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19576 WHERE `Id` = 24000;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19577 WHERE `Id` = 24001;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19579 WHERE `Id` = 24007;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19585 WHERE `Id` = 24008;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19586 WHERE `Id` = 24009;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19588 WHERE `Id` = 24010;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19591 WHERE `Id` = 24012;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19592 WHERE `Id` = 24013;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19593 WHERE `Id` = 24014;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19594 WHERE `Id` = 24015;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19598 WHERE `Id` = 24038;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19599 WHERE `Id` = 24039;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19600 WHERE `Id` = 24040;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19601 WHERE `Id` = 24041;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19602 WHERE `Id` = 24044;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19603 WHERE `Id` = 24045;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19604 WHERE `Id` = 24046;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19605 WHERE `Id` = 24047;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19610 WHERE `Id` = 24055;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19611 WHERE `Id` = 24056;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19612 WHERE `Id` = 24059;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19613 WHERE `Id` = 24060;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19606 WHERE `Id` = 24067;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19607 WHERE `Id` = 24068;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19608 WHERE `Id` = 24069;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19609 WHERE `Id` = 24070;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19614 WHERE `Id` = 24072;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19615 WHERE `Id` = 24073;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19616 WHERE `Id` = 24074;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19617 WHERE `Id` = 24075;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19618 WHERE `Id` = 24076;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19619 WHERE `Id` = 24077;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19620 WHERE `Id` = 24078;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19621 WHERE `Id` = 24079;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19974 WHERE `Id` = 24304;
+UPDATE `spell_dbc` SET `EffectItemType1` = 20454 WHERE `Id` = 24805;
+UPDATE `spell_dbc` SET `EffectItemType1` = 20455 WHERE `Id` = 24806;
+UPDATE `spell_dbc` SET `EffectItemType1` = 20456 WHERE `Id` = 24807;
+UPDATE `spell_dbc` SET `EffectItemType1` = 20371 WHERE `Id` = 24863;
+UPDATE `spell_dbc` SET `EffectItemType1` = 20949 WHERE `Id` = 25600;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21109 WHERE `Id` = 25763;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21107 WHERE `Id` = 25764;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21106 WHERE `Id` = 25765;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21042 WHERE `Id` = 25784;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21136 WHERE `Id` = 25785;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21206 WHERE `Id` = 25921;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21207 WHERE `Id` = 25922;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21208 WHERE `Id` = 25923;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21209 WHERE `Id` = 25924;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21210 WHERE `Id` = 25925;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21201 WHERE `Id` = 25927;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21202 WHERE `Id` = 25928;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21203 WHERE `Id` = 25929;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21204 WHERE `Id` = 25930;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21205 WHERE `Id` = 25931;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21196 WHERE `Id` = 25932;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21197 WHERE `Id` = 25933;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21198 WHERE `Id` = 25934;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21199 WHERE `Id` = 25935;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21200 WHERE `Id` = 25936;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21816 WHERE `Id` = 26668;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21818 WHERE `Id` = 26670;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21819 WHERE `Id` = 26671;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21821 WHERE `Id` = 26672;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21823 WHERE `Id` = 26673;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21822 WHERE `Id` = 26674;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21820 WHERE `Id` = 26675;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21817 WHERE `Id` = 26676;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22114 WHERE `Id` = 26973;
+UPDATE `spell_dbc` SET `EffectItemType1` = 13583 WHERE `Id` = 26974;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22048 WHERE `Id` = 27537;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22047 WHERE `Id` = 27542;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21984 WHERE `Id` = 27544;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22050 WHERE `Id` = 27558;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22049 WHERE `Id` = 27560;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22052 WHERE `Id` = 27562;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22051 WHERE `Id` = 27563;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22056 WHERE `Id` = 27566;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22822 WHERE `Id` = 28532;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19822 WHERE `Id` = 28885;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19823 WHERE `Id` = 28886;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19824 WHERE `Id` = 28908;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19825 WHERE `Id` = 28909;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19826 WHERE `Id` = 28919;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19827 WHERE `Id` = 28920;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19831 WHERE `Id` = 28921;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19829 WHERE `Id` = 28923;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19830 WHERE `Id` = 28926;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19832 WHERE `Id` = 28929;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19833 WHERE `Id` = 28930;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19834 WHERE `Id` = 28935;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19835 WHERE `Id` = 28937;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19836 WHERE `Id` = 28939;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19838 WHERE `Id` = 28940;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19839 WHERE `Id` = 28941;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19840 WHERE `Id` = 28942;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19841 WHERE `Id` = 28943;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19842 WHERE `Id` = 28945;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19843 WHERE `Id` = 28946;
+UPDATE `spell_dbc` SET `EffectItemType1` = 20034 WHERE `Id` = 28949;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19845 WHERE `Id` = 28951;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19846 WHERE `Id` = 28952;
+UPDATE `spell_dbc` SET `EffectItemType1` = 20033 WHERE `Id` = 28954;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19849 WHERE `Id` = 28956;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19848 WHERE `Id` = 28958;
+UPDATE `spell_dbc` SET `EffectItemType1` = 19828 WHERE `Id` = 28959;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21407 WHERE `Id` = 29009;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21409 WHERE `Id` = 29010;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21408 WHERE `Id` = 29011;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21401 WHERE `Id` = 29012;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21403 WHERE `Id` = 29013;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21402 WHERE `Id` = 29014;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21413 WHERE `Id` = 29015;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21415 WHERE `Id` = 29016;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21414 WHERE `Id` = 29017;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21395 WHERE `Id` = 29018;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21397 WHERE `Id` = 29019;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21396 WHERE `Id` = 29020;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21410 WHERE `Id` = 29021;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21412 WHERE `Id` = 29022;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21411 WHERE `Id` = 29023;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21404 WHERE `Id` = 29024;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21406 WHERE `Id` = 29025;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21405 WHERE `Id` = 29026;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21398 WHERE `Id` = 29027;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21400 WHERE `Id` = 29028;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21399 WHERE `Id` = 29030;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21416 WHERE `Id` = 29031;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21418 WHERE `Id` = 29032;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21417 WHERE `Id` = 29033;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21392 WHERE `Id` = 29034;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21394 WHERE `Id` = 29036;
+UPDATE `spell_dbc` SET `EffectItemType1` = 21393 WHERE `Id` = 29037;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23227 WHERE `Id` = 29156;
+UPDATE `spell_dbc` SET `EffectItemType1` = 13582 WHERE `Id` = 29344;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23442 WHERE `Id` = 29372;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23584 WHERE `Id` = 29827;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23585 WHERE `Id` = 29828;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23586 WHERE `Id` = 29829;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23614 WHERE `Id` = 29867;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23616 WHERE `Id` = 29868;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23705 WHERE `Id` = 30139;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23709 WHERE `Id` = 30182;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23710 WHERE `Id` = 30185;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23712 WHERE `Id` = 30186;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23713 WHERE `Id` = 30188;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23714 WHERE `Id` = 30189;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23716 WHERE `Id` = 30192;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23720 WHERE `Id` = 30193;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22575 WHERE `Id` = 30436;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22576 WHERE `Id` = 30438;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22577 WHERE `Id` = 30439;
+UPDATE `spell_dbc` SET `EffectItemType1` = 23895 WHERE `Id` = 30634;
+UPDATE `spell_dbc` SET `EffectItemType1` = 24184 WHERE `Id` = 31251;
+UPDATE `spell_dbc` SET `EffectItemType1` = 24226 WHERE `Id` = 31314;
+UPDATE `spell_dbc` SET `EffectItemType1` = 24573 WHERE `Id` = 32152;
+UPDATE `spell_dbc` SET `EffectItemType1` = 24538 WHERE `Id` = 32165;
+UPDATE `spell_dbc` SET `EffectItemType1` = 25840 WHERE `Id` = 32673;
+UPDATE `spell_dbc` SET `EffectItemType1` = 25853 WHERE `Id` = 32762;
+UPDATE `spell_dbc` SET `EffectItemType1` = 27317 WHERE `Id` = 33137;
+UPDATE `spell_dbc` SET `EffectItemType1` = 24581 WHERE `Id` = 33766;
+UPDATE `spell_dbc` SET `EffectItemType1` = 24579 WHERE `Id` = 33767;
+UPDATE `spell_dbc` SET `EffectItemType1` = 28132 WHERE `Id` = 33892;
+UPDATE `spell_dbc` SET `EffectItemType1` = 28132 WHERE `Id` = 33893;
+UPDATE `spell_dbc` SET `EffectItemType1` = 28048 WHERE `Id` = 34362;
+UPDATE `spell_dbc` SET `EffectItemType1` = 28784 WHERE `Id` = 34706;
+UPDATE `spell_dbc` SET `EffectItemType1` = 28455 WHERE `Id` = 35378;
+UPDATE `spell_dbc` SET `EffectItemType1` = 28455 WHERE `Id` = 35690;
+UPDATE `spell_dbc` SET `EffectItemType1` = 30309 WHERE `Id` = 36377;
+UPDATE `spell_dbc` SET `EffectItemType1` = 30499 WHERE `Id` = 36799;
+UPDATE `spell_dbc` SET `EffectItemType1` = 30632 WHERE `Id` = 37084;
+UPDATE `spell_dbc` SET `EffectItemType1` = 29024 WHERE `Id` = 37085;
+UPDATE `spell_dbc` SET `EffectItemType1` = 29024 WHERE `Id` = 37086;
+UPDATE `spell_dbc` SET `EffectItemType1` = 30639 WHERE `Id` = 37100;
+UPDATE `spell_dbc` SET `EffectItemType1` = 30658 WHERE `Id` = 37244;
+UPDATE `spell_dbc` SET `EffectItemType1` = 30659 WHERE `Id` = 37245;
+UPDATE `spell_dbc` SET `EffectItemType1` = 30847 WHERE `Id` = 38005;
+UPDATE `spell_dbc` SET `EffectItemType1` = 31108 WHERE `Id` = 38172;
+UPDATE `spell_dbc` SET `EffectItemType1` = 31310 WHERE `Id` = 38251;
+UPDATE `spell_dbc` SET `EffectItemType1` = 30540 WHERE `Id` = 38255;
+UPDATE `spell_dbc` SET `EffectItemType1` = 22781 WHERE `Id` = 38656;
+UPDATE `spell_dbc` SET `EffectItemType1` = 31663 WHERE `Id` = 38786;
+UPDATE `spell_dbc` SET `EffectItemType1` = 24494 WHERE `Id` = 39118;
+UPDATE `spell_dbc` SET `EffectItemType1` = 31763 WHERE `Id` = 39203;
+UPDATE `spell_dbc` SET `EffectItemType1` = 31084 WHERE `Id` = 39336;
+UPDATE `spell_dbc` SET `EffectItemType1` = 32588 WHERE `Id` = 40550;
+UPDATE `spell_dbc` SET `EffectItemType1` = 32566 WHERE `Id` = 40551;
+UPDATE `spell_dbc` SET `EffectItemType1` = 32542 WHERE `Id` = 40552;
+UPDATE `spell_dbc` SET `EffectItemType2` = 24538 WHERE `Id` = 32059;
+UPDATE `spell_dbc` SET `EffectItemType2` = 24538 WHERE `Id` = 32068;
+UPDATE `spell_dbc` SET `EffectItemType2` = 24538 WHERE `Id` = 32075;
+UPDATE `spell_dbc` SET `EffectItemType2` = 24538 WHERE `Id` = 32081;