From da5d0da724ad4b8013e17cc8aef8040a0a9cff20 Mon Sep 17 00:00:00 2001 From: Kinzcool Date: Fri, 21 Nov 2014 17:29:08 -0500 Subject: Core/Spells: Made the loading of the orientation of SPELL_DEST_DB from SpellEffect.dbc --- sql/updates/world/2014_11_20_02_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2014_11_20_02_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_11_20_02_world.sql b/sql/updates/world/2014_11_20_02_world.sql new file mode 100644 index 00000000000..1e0048e1943 --- /dev/null +++ b/sql/updates/world/2014_11_20_02_world.sql @@ -0,0 +1,7 @@ +ALTER TABLE `spell_target_position` CHANGE `id` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `spell_target_position` CHANGE `effIndex` `EffectIndex` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `spell_target_position` CHANGE `target_map` `MapID` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `spell_target_position` CHANGE `target_position_x` `PositionX` FLOAT NOT NULL DEFAULT '0'; +ALTER TABLE `spell_target_position` CHANGE `target_position_y` `PositionY` FLOAT NOT NULL DEFAULT '0'; +ALTER TABLE `spell_target_position` CHANGE `target_position_z` `PositionZ` FLOAT NOT NULL DEFAULT '0'; +ALTER TABLE `spell_target_position` DROP COLUMN `target_orientation`; -- cgit v1.2.3