From c243bf96d436aaaaf12f4a42cf8e439defe198ea Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sun, 21 Sep 2014 04:18:31 +0200 Subject: DB/Spells: - Added EffectItemType columns to spell_dbc table - Fix "Create Bundle of Bloodthistle" --- sql/updates/world/2014_09_21_00_world_spell_dbc.sql | 5 +++++ src/server/game/DataStores/DBCStructure.h | 2 +- src/server/game/DataStores/DBCfmt.h | 2 +- 3 files changed, 7 insertions(+), 2 deletions(-) create mode 100644 sql/updates/world/2014_09_21_00_world_spell_dbc.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 new file mode 100644 index 00000000000..d762bf92107 --- /dev/null +++ b/sql/updates/world/2014_09_21_00_world_spell_dbc.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/src/server/game/DataStores/DBCStructure.h b/src/server/game/DataStores/DBCStructure.h index 1e1cd6dd9d6..a0d1d77e6ca 100644 --- a/src/server/game/DataStores/DBCStructure.h +++ b/src/server/game/DataStores/DBCStructure.h @@ -1676,7 +1676,7 @@ struct SpellEntry uint32 EffectRadiusIndex[MAX_SPELL_EFFECTS]; // 92-94 m_effectRadiusIndex - spellradius.dbc uint32 EffectApplyAuraName[MAX_SPELL_EFFECTS]; // 95-97 m_effectAura uint32 EffectAmplitude[MAX_SPELL_EFFECTS]; // 98-100 m_effectAuraPeriod - float EffectValueMultiplier[MAX_SPELL_EFFECTS]; // 101-103 + float EffectValueMultiplier[MAX_SPELL_EFFECTS]; // 101-103 uint32 EffectChainTarget[MAX_SPELL_EFFECTS]; // 104-106 m_effectChainTargets uint32 EffectItemType[MAX_SPELL_EFFECTS]; // 107-109 m_effectItemType int32 EffectMiscValue[MAX_SPELL_EFFECTS]; // 110-112 m_effectMiscValue diff --git a/src/server/game/DataStores/DBCfmt.h b/src/server/game/DataStores/DBCfmt.h index a90cc48c5af..b664798bf6f 100644 --- a/src/server/game/DataStores/DBCfmt.h +++ b/src/server/game/DataStores/DBCfmt.h @@ -108,7 +108,7 @@ const std::string CustomSpellDifficultyfmt = "ppppp"; const std::string CustomSpellDifficultyIndex = "id"; char const SpellDurationfmt[] = "niii"; char const SpellEntryfmt[] = "niiiiiiiiiiiixixiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiifxiiiiiiiiiiiiiiiiiiiiiiiiiiiifffiiiiiiiiiiiiiiiiiiiiifffiiiiiiiiiiiiiiifffiiiiiiiiiiiiixssssssssssssssssxssssssssssssssssxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxiiiiiiiiiiixfffxxxiiiiixxfffxx"; -const std::string CustomSpellEntryfmt = "papppppppppppapapaaaaaaaaaaapaaapapppppppaaaaapaapaaaaaaaaaaaaaaaaaappppppppppppppppppppppppppppppppppppaaaaaapppppppppaaapppppppppaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaappppppppapppaaaaappaaaaaaa"; +const std::string CustomSpellEntryfmt = "papppppppppppapapaaaaaaaaaaapaaapapppppppaaaaapaapaaaaaaaaaaaaaaaaaappppppppppppppppppppppppppppppppppppaaappppppppppppaaapppppppppaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaappppppppapppaaaaappaaaaaaa"; const std::string CustomSpellEntryIndex = "Id"; char const SpellFocusObjectfmt[] = "nxxxxxxxxxxxxxxxxx"; char const SpellItemEnchantmentfmt[] = "nxiiiiiixxxiiissssssssssssssssxiiiiiii"; -- cgit v1.2.3