diff options
| author | KingPin <none@none> | 2008-10-19 21:08:34 -0500 |
|---|---|---|
| committer | KingPin <none@none> | 2008-10-19 21:08:34 -0500 |
| commit | fcde03a03670caa76b0933dbf3e7a1e95bb2b3be (patch) | |
| tree | d71f1892493c6d9b12aca88a1ceca9c0fc9c981b /sql | |
| parent | 0cb3a7951811140c2619353c0e3c3b4dd727a63c (diff) | |
[svn] * Fixed compile from r78
* Fixed: not apply healling bonus to spell 40972 heal amount. - Source Mangos
* Item 30627 hidden cooldown - Source Mangos
* Fixed Trinityrealm autopatching system - Source Arrai
* Add support for autoconf 2.6.2 and newer - Source Derex
Some decent sized changes, please test before deploying - KP
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/79_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/79_world.sql | 6 |
3 files changed, 9 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index d25e000ebdc..429b4c0508a 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -608,7 +608,7 @@ CREATE TABLE `characters` ( `trans_z` float NOT NULL default '0', `trans_o` float NOT NULL default '0', `transguid` bigint(20) unsigned NOT NULL default '0', - `gmstate` tinyint(3) unsigned NOT NULL default '0', + `extra_flags` tinyint(3) unsigned NOT NULL default '0', `stable_slots` tinyint(1) unsigned NOT NULL default '0', `at_login` int(11) unsigned NOT NULL default '0', `zone` int(11) unsigned NOT NULL default '0', diff --git a/sql/updates/79_characters.sql b/sql/updates/79_characters.sql new file mode 100644 index 00000000000..d2f29d734d6 --- /dev/null +++ b/sql/updates/79_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE characters
+ CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0';
\ No newline at end of file diff --git a/sql/updates/79_world.sql b/sql/updates/79_world.sql new file mode 100644 index 00000000000..2a61c2f6a09 --- /dev/null +++ b/sql/updates/79_world.sql @@ -0,0 +1,6 @@ +DELETE FROM spell_proc_event where entry = 42083;
+INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES
+(42083,0,0,0,0,0x0000000000000000,0x00401000,0,45);
+
+ALTER TABLE characters
+ CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0';
\ No newline at end of file |