From ef70382d5bf32732c064134bcc0aa31a8f3c8055 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sun, 21 Sep 2014 12:11:57 +0200 Subject: SQL: Only 3.3.5a --- .../world/2014_09_21_00_world_spell_dbc.sql | 5 - .../world/2014_09_21_00_world_spell_dbc_335.sql | 5 + .../world/2014_09_21_01_world_spell_dbc.sql | 213 --------------------- .../world/2014_09_21_01_world_spell_dbc_335.sql | 213 +++++++++++++++++++++ 4 files changed, 218 insertions(+), 218 deletions(-) delete mode 100644 sql/updates/world/2014_09_21_00_world_spell_dbc.sql create mode 100644 sql/updates/world/2014_09_21_00_world_spell_dbc_335.sql delete mode 100644 sql/updates/world/2014_09_21_01_world_spell_dbc.sql create mode 100644 sql/updates/world/2014_09_21_01_world_spell_dbc_335.sql diff --git a/sql/updates/world/2014_09_21_00_world_spell_dbc.sql b/sql/updates/world/2014_09_21_00_world_spell_dbc.sql deleted file mode 100644 index d762bf92107..00000000000 --- a/sql/updates/world/2014_09_21_00_world_spell_dbc.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE `spell_dbc` ADD `EffectItemType1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectMultipleValue3`; -ALTER TABLE `spell_dbc` ADD `EffectItemType2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectItemType1`; -ALTER TABLE `spell_dbc` ADD `EffectItemType3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectItemType2`; - -UPDATE `spell_dbc` SET `EffectItemType1`=30616 WHERE `Id`=37064; diff --git a/sql/updates/world/2014_09_21_00_world_spell_dbc_335.sql b/sql/updates/world/2014_09_21_00_world_spell_dbc_335.sql new file mode 100644 index 00000000000..d762bf92107 --- /dev/null +++ b/sql/updates/world/2014_09_21_00_world_spell_dbc_335.sql @@ -0,0 +1,5 @@ +ALTER TABLE `spell_dbc` ADD `EffectItemType1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectMultipleValue3`; +ALTER TABLE `spell_dbc` ADD `EffectItemType2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectItemType1`; +ALTER TABLE `spell_dbc` ADD `EffectItemType3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectItemType2`; + +UPDATE `spell_dbc` SET `EffectItemType1`=30616 WHERE `Id`=37064; 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 deleted file mode 100644 index 55b02edfc59..00000000000 --- a/sql/updates/world/2014_09_21_01_world_spell_dbc.sql +++ /dev/null @@ -1,213 +0,0 @@ -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; diff --git a/sql/updates/world/2014_09_21_01_world_spell_dbc_335.sql b/sql/updates/world/2014_09_21_01_world_spell_dbc_335.sql new file mode 100644 index 00000000000..55b02edfc59 --- /dev/null +++ b/sql/updates/world/2014_09_21_01_world_spell_dbc_335.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; -- cgit v1.2.3