aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <none@none>2010-07-13 23:04:31 +0200
committerShauren <none@none>2010-07-13 23:04:31 +0200
commitfd3e4d5139edf7e6dd036315794e7eba3e8ff91f (patch)
tree854279202261b6e3de5db0e1a4ee2a16e2ec2ddd
parentc783cacbe63023c36e9393d28a574b613ff6b555 (diff)
Add Stances and StancesNot fields to spell_dbc table
--HG-- branch : trunk
-rw-r--r--sql/base/world_database.sql2
-rw-r--r--sql/updates/8890_world_spell_dbc.sql3
-rw-r--r--src/server/game/DataStores/DBCfmt.h2
3 files changed, 6 insertions, 1 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 6bd4a008a8a..7f6dae9f01a 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -5205,6 +5205,8 @@ CREATE TABLE `spell_dbc` (
`AttributesEx3` int(10) unsigned NOT NULL DEFAULT '0',
`AttributesEx4` int(10) unsigned NOT NULL DEFAULT '0',
`AttributesEx5` int(10) unsigned NOT NULL DEFAULT '0',
+ `Stances` int(10) unsigned NOT NULL DEFAULT '0',
+ `StancesNot` int(10) unsigned NOT NULL DEFAULT '0',
`Targets` int(10) unsigned NOT NULL DEFAULT '0',
`CastingTimeIndex` tinyint(3) unsigned NOT NULL DEFAULT '1',
`AuraInterruptFlags` int(10) unsigned NOT NULL DEFAULT '0',
diff --git a/sql/updates/8890_world_spell_dbc.sql b/sql/updates/8890_world_spell_dbc.sql
new file mode 100644
index 00000000000..a5e0927806f
--- /dev/null
+++ b/sql/updates/8890_world_spell_dbc.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `spell_dbc`
+ ADD COLUMN `Stances` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AttributesEx5`,
+ ADD COLUMN `StancesNot` int(10) unsigned NOT NULL DEFAULT '0' AFTER `Stances`;
diff --git a/src/server/game/DataStores/DBCfmt.h b/src/server/game/DataStores/DBCfmt.h
index c951e9fa3c2..80d8791bd01 100644
--- a/src/server/game/DataStores/DBCfmt.h
+++ b/src/server/game/DataStores/DBCfmt.h
@@ -95,7 +95,7 @@ const std::string CustomSpellDifficultyfmt="ppppp";
const std::string CustomSpellDifficultyIndex="id";
const char SpellDurationfmt[]="niii";
const char SpellEntryfmt[]="niiiiiiiiiiiixixiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiifxiiiiiiiiiiiiiiiiiiiiiiiiiiiifffiiiiiiiiiiiiiiiiiiiiifffiiiiiiiiiiiiiiifffiiiiiiiiiiiiixssssssssssssssssxssssssssssssssssxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxiiiiiiiiiiixfffxxxiiiiixxxxxxx";
-const std::string CustomSpellEntryfmt="pappppppppaaaaaapaaaaaaaaaaapaaapapppppppaaaaapaapaaaaaaaaaaaaaaaaaappppppppppppppppppppppppppppppppppppaaaaaapppppppppaaapppppppppaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaappppppppapppaaaaappaaaaaaa";
+const std::string CustomSpellEntryfmt="pappppppppaapapapaaaaaaaaaaapaaapapppppppaaaaapaapaaaaaaaaaaaaaaaaaappppppppppppppppppppppppppppppppppppaaaaaapppppppppaaapppppppppaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaappppppppapppaaaaappaaaaaaa";
const std::string CustomSpellEntryIndex = "Id";
const char SpellFocusObjectfmt[]="nxxxxxxxxxxxxxxxxx";
const char SpellItemEnchantmentfmt[]="nxiiiiiixxxiiissssssssssssssssxiiiiiii";