diff options
Diffstat (limited to 'sql')
15 files changed, 234 insertions, 23 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 599c05ce4cf..b3430b2b5ac 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -221,12 +221,12 @@ DROP TABLE IF EXISTS `banned_addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `banned_addons` ( - `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(255) NOT NULL, `Version` varchar(255) NOT NULL DEFAULT '', `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), - UNIQUE KEY `idx_name_ver` (`Name`, `Version`) + UNIQUE KEY `idx_name_ver` (`Name`,`Version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1746,7 +1746,7 @@ CREATE TABLE `guild` ( `BorderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT '0', `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT '0', - `info` VARCHAR(500) NOT NULL DEFAULT '', + `info` varchar(500) NOT NULL DEFAULT '', `motd` varchar(128) NOT NULL DEFAULT '', `createdate` int(10) unsigned NOT NULL DEFAULT '0', `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0', @@ -2683,4 +2683,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2013-02-04 16:22:06 +-- Dump completed on 2014-01-26 14:39:20 diff --git a/sql/updates/auth/2013_08_30_00_auth_misc.sql b/sql/updates/auth/2013_08_30_00_auth_misc.sql index 1e790ce7e28..d433c479c63 100644 --- a/sql/updates/auth/2013_08_30_00_auth_misc.sql +++ b/sql/updates/auth/2013_08_30_00_auth_misc.sql @@ -1,23 +1,23 @@ -- Add new permissions DELETE FROM `rbac_permissions` WHERE `id` BETWEEN 200 AND 216; INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(200, 'Command: .rbac'), -(201, 'Command: .rbac account'), -(202, 'Command: .rbac account group'), -(203, 'Command: .rbac account group add'), -(204, 'Command: .rbac account group remove'), -(205, 'Command: .rbac account role'), -(206, 'Command: .rbac account role grant'), -(207, 'Command: .rbac account role deny'), -(208, 'Command: .rbac account role revoke'), -(209, 'Command: .rbac account permission'), -(210, 'Command: .rbac account permission grant'), -(211, 'Command: .rbac account permission deny'), -(212, 'Command: .rbac account permission revoke'), -(213, 'Command: .rbac list'), -(214, 'Command: .rbac list groups'), -(215, 'Command: .rbac list roles'), -(216, 'Command: .rbac list permissions'); +(200, 'Command: rbac'), +(201, 'Command: rbac account'), +(202, 'Command: rbac account group'), +(203, 'Command: rbac account group add'), +(204, 'Command: rbac account group remove'), +(205, 'Command: rbac account role'), +(206, 'Command: rbac account role grant'), +(207, 'Command: rbac account role deny'), +(208, 'Command: rbac account role revoke'), +(209, 'Command: rbac account permission'), +(210, 'Command: rbac account permission grant'), +(211, 'Command: rbac account permission deny'), +(212, 'Command: rbac account permission revoke'), +(213, 'Command: rbac list'), +(214, 'Command: rbac list groups'), +(215, 'Command: rbac list roles'), +(216, 'Command: rbac list permissions'); -- Add Permissions to "Administrator Commands Role" DELETE FROM `rbac_role_permissions` WHERE `roleId` = 4 AND `permissionId` BETWEEN 200 AND 216; diff --git a/sql/updates/auth/2013_11_11_00_auth_logs.sql b/sql/updates/auth/2013_11_11_00_auth_logs.sql index 4e4daa10e4b..dddda0d6743 100644 --- a/sql/updates/auth/2013_11_11_00_auth_logs.sql +++ b/sql/updates/auth/2013_11_11_00_auth_logs.sql @@ -1,2 +1 @@ -ALTER TABLE `logs` CHANGE `type` `type` varchar(250); - +ALTER TABLE `logs` CHANGE `type` `type` varchar(250) NOT NULL; diff --git a/sql/updates/world/2014_01_27_18_world_creature_template.sql b/sql/updates/world/2014_01_27_18_world_creature_template.sql new file mode 100644 index 00000000000..faad0b4ac7b --- /dev/null +++ b/sql/updates/world/2014_01_27_18_world_creature_template.sql @@ -0,0 +1,6 @@ +-- +UPDATE `creature_template` SET `faction_A` = 1214, `faction_H` = 1214 WHERE `entry` IN (13079,22683,32026); +UPDATE `creature_template` SET `faction_A` = 1215, `faction_H` = 1215 WHERE `entry` IN (37481); +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80, `faction_A`=84, `faction_H`=84 WHERE `entry`=35401; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81, `faction_A`=84, `faction_H`=84 WHERE `entry`=35403; +UPDATE `creature_template` SET `faction_A` = 84, `faction_H` = 84 WHERE `entry` IN (37236); diff --git a/sql/updates/world/2014_01_27_19_world_creature_template.sql b/sql/updates/world/2014_01_27_19_world_creature_template.sql new file mode 100644 index 00000000000..a0127c48db8 --- /dev/null +++ b/sql/updates/world/2014_01_27_19_world_creature_template.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature_template` SET `unit_class` = 4 WHERE `entry` IN (34777,35436,36357); +UPDATE `creature_template` SET `difficulty_entry_1`=34114 WHERE `entry`=33855; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=35405; diff --git a/sql/updates/world/2014_01_27_20_world_creature_template.sql b/sql/updates/world/2014_01_27_20_world_creature_template.sql new file mode 100644 index 00000000000..f28773dc0ec --- /dev/null +++ b/sql/updates/world/2014_01_27_20_world_creature_template.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_template` SET `faction_A` = 1216, `faction_H` = 1216 WHERE `entry` IN (13331,13422,22588,22608,31932,32125); +UPDATE `creature_template` SET `faction_A` = 1214, `faction_H` = 1214 WHERE `entry` IN (13088,13316,22684,22733,31950,32043,13332,22589,32126); diff --git a/sql/updates/world/2014_01_28_00_world_creature_template.sql b/sql/updates/world/2014_01_28_00_world_creature_template.sql new file mode 100644 index 00000000000..adb67b75ac5 --- /dev/null +++ b/sql/updates/world/2014_01_28_00_world_creature_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `faction_A` = 1216, `faction_H` = 1216 WHERE `entry` IN (13086,13317,22670,22732,31918,31949,37267); diff --git a/sql/updates/world/2014_01_28_01_world_creature_template.sql b/sql/updates/world/2014_01_28_01_world_creature_template.sql new file mode 100644 index 00000000000..725feaa6a3e --- /dev/null +++ b/sql/updates/world/2014_01_28_01_world_creature_template.sql @@ -0,0 +1,4 @@ +-- TDB 3.3.5a have faction 1214 for mob 37384, TDB 4.3.4 have the same faction for mob 13328 this makes the fix generic for both TDB. +UPDATE `creature_template` SET `faction_A` = 1214, `faction_H` = 1214 WHERE `entry` IN (13328,22715,32063,37384); +UPDATE `creature_template` SET `faction_A`=1693, `faction_H`=1693 WHERE `entry` IN (29062,31589,29096,31590,29098,31602,31590); +UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14 WHERE `entry` IN (31588,31600); diff --git a/sql/updates/world/2014_01_28_02_world_creature_template.sql b/sql/updates/world/2014_01_28_02_world_creature_template.sql new file mode 100644 index 00000000000..81ec9d30f76 --- /dev/null +++ b/sql/updates/world/2014_01_28_02_world_creature_template.sql @@ -0,0 +1,5 @@ +-- +UPDATE `creature_template` SET `faction_A` = 190, `faction_H` = 190 WHERE `entry` = 30794; +UPDATE `creature_template` SET `difficulty_entry_1`=0 WHERE `entry`=30023; +UPDATE `creature_template` SET `difficulty_entry_1`=22643, `difficulty_entry_2`=32027, `difficulty_entry_3`=37347 WHERE `entry`=12159; +UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14 WHERE `entry` IN (32027,37347); diff --git a/sql/updates/world/2014_01_28_03_world_creature_template.sql b/sql/updates/world/2014_01_28_03_world_creature_template.sql new file mode 100644 index 00000000000..eaf09f891e7 --- /dev/null +++ b/sql/updates/world/2014_01_28_03_world_creature_template.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14 WHERE `entry` IN (22643,28924,28925); +UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16 WHERE `entry` = 34114; diff --git a/sql/updates/world/2014_01_28_04_world_creature_template.sql b/sql/updates/world/2014_01_28_04_world_creature_template.sql new file mode 100644 index 00000000000..ed8f6f0d5d3 --- /dev/null +++ b/sql/updates/world/2014_01_28_04_world_creature_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `faction_A`=1214, `faction_H`=1214 WHERE `entry` IN (13421,22609,31933); diff --git a/sql/updates/world/2014_01_28_05_world_creature_template.sql b/sql/updates/world/2014_01_28_05_world_creature_template.sql new file mode 100644 index 00000000000..c6b6ccc7252 --- /dev/null +++ b/sql/updates/world/2014_01_28_05_world_creature_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `VehicleId`=0 WHERE `entry` IN (38156,38637,38638); diff --git a/sql/updates/world/2014_01_29_00_world_spell_script_names.sql b/sql/updates/world/2014_01_29_00_world_spell_script_names.sql new file mode 100644 index 00000000000..6e37da1abcc --- /dev/null +++ b/sql/updates/world/2014_01_29_00_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=46584; +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(46584,'spell_dk_raise_dead'); diff --git a/sql/updates/world/2014_01_31_00_world_spell_custom_attr.sql b/sql/updates/world/2014_01_31_00_world_spell_custom_attr.sql new file mode 100644 index 00000000000..488b09dc54e --- /dev/null +++ b/sql/updates/world/2014_01_31_00_world_spell_custom_attr.sql @@ -0,0 +1,167 @@ +DROP TABLE IF EXISTS `spell_custom_attr`; +CREATE TABLE IF NOT EXISTS `spell_custom_attr` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'spell id', + `attributes` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCustomAttributes', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='SpellInfo custom attributes'; + +SET @SPELL_ATTR0_CU_ENCHANT_PROC = 1, + @SPELL_ATTR0_CU_CONE_BACK = 2, + @SPELL_ATTR0_CU_CONE_LINE = 4, + @SPELL_ATTR0_CU_SHARE_DAMAGE = 8, + @SPELL_ATTR0_CU_NO_INITIAL_THREAT = 16, + @SPELL_ATTR0_CU_AURA_CC = 64, + @SPELL_ATTR0_CU_DIRECT_DAMAGE = 256, + @SPELL_ATTR0_CU_CHARGE = 512, + @SPELL_ATTR0_CU_PICKPOCKET = 1024, + @SPELL_ATTR0_CU_NEGATIVE_EFF0 = 4096, + @SPELL_ATTR0_CU_NEGATIVE_EFF1 = 8192, + @SPELL_ATTR0_CU_NEGATIVE_EFF2 = 16384, + @SPELL_ATTR0_CU_IGNORE_ARMOR = 32768, + @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER = 65536, + @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET = 131072; + +INSERT INTO `spell_custom_attr` (`entry`, `attributes`) VALUES +(1776, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(1777, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(8629, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(11285, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(11286, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(12540, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(13579, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(24698, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(28456, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(29425, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(34940, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(36862, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(38764, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(38863, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(52743, @SPELL_ATTR0_CU_REQ_TARGET_FACING_CASTER), +(53, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(2589, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(2590, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(2591, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(7159, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8627, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8721, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(11279, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(11280, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(11281, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(15582, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(15657, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(22416, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(25300, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(26863, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(37685, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48656, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48657, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(703, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8631, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8632, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8633, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(11289, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(11290, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(26839, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(26884, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48675, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48676, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(5221, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(6800, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8992, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(9829, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(9830, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(27001, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(27002, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48571, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48572, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8676, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8724, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(8725, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(11267, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(11268, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(11269, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(27441, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48689, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48690, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48691, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(6785, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(6787, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(9866, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(9867, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(27005, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48578, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(48579, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(21987, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(23959, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(24825, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(58563, @SPELL_ATTR0_CU_REQ_CASTER_BEHIND_TARGET), +(26029, @SPELL_ATTR0_CU_CONE_LINE), +(37433, @SPELL_ATTR0_CU_CONE_LINE), +(43140, @SPELL_ATTR0_CU_CONE_LINE), +(43215, @SPELL_ATTR0_CU_CONE_LINE), +(70461, @SPELL_ATTR0_CU_CONE_LINE), +(72133, @SPELL_ATTR0_CU_CONE_LINE), +(73788, @SPELL_ATTR0_CU_CONE_LINE), +(73789, @SPELL_ATTR0_CU_CONE_LINE), +(73790, @SPELL_ATTR0_CU_CONE_LINE), +(24340, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(26558, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(28884, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(36837, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(38903, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(41276, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(57467, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(26789, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(31436, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(35181, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(40810, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(43267, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(43268, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(42384, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(45150, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(64688, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(72373, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(71904, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(70492, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(72505, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(72624, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(72625, @SPELL_ATTR0_CU_SHARE_DAMAGE), +(18500, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(33086, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(49749, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(52890, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(53454, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(59446, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(62383, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(64777, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(65239, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(65919, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(67858, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(67859, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(67860, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(69293, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(74439, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(63278, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(62544, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(64588, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(66479, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(68505, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(62709, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(62626, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(64590, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(64342, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(64686, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(65147, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(68504, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(62874, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(68498, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(64591, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(63003, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(63010, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(68321, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(72255, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(72444, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(72445, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(72446, @SPELL_ATTR0_CU_IGNORE_ARMOR), +(64422, @SPELL_ATTR0_CU_SHARE_DAMAGE | @SPELL_ATTR0_CU_IGNORE_ARMOR), +(72293, @SPELL_ATTR0_CU_NEGATIVE_EFF0); diff --git a/sql/updates/world/2014_01_31_01_world_item_template.sql b/sql/updates/world/2014_01_31_01_world_item_template.sql new file mode 100644 index 00000000000..f47e96cf403 --- /dev/null +++ b/sql/updates/world/2014_01_31_01_world_item_template.sql @@ -0,0 +1,11 @@ +UPDATE `item_template` SET `spellcharges_1`=0 WHERE `spellcharges_1` IS NULL; +UPDATE `item_template` SET `spellcharges_2`=0 WHERE `spellcharges_2` IS NULL; +UPDATE `item_template` SET `spellcharges_3`=0 WHERE `spellcharges_3` IS NULL; +UPDATE `item_template` SET `spellcharges_4`=0 WHERE `spellcharges_4` IS NULL; +UPDATE `item_template` SET `spellcharges_5`=0 WHERE `spellcharges_5` IS NULL; + +ALTER TABLE `item_template` CHANGE `spellcharges_1` `spellcharges_1` SMALLINT( 6 ) NOT NULL DEFAULT '0', + CHANGE `spellcharges_2` `spellcharges_2` SMALLINT( 6 ) NOT NULL DEFAULT '0', + CHANGE `spellcharges_3` `spellcharges_3` SMALLINT( 6 ) NOT NULL DEFAULT '0', + CHANGE `spellcharges_4` `spellcharges_4` SMALLINT( 6 ) NOT NULL DEFAULT '0', + CHANGE `spellcharges_5` `spellcharges_5` SMALLINT( 6 ) NOT NULL DEFAULT '0'; |