From 79e1918e4db29d6c201e8c7d532149ed3d86b012 Mon Sep 17 00:00:00 2001 From: teacher Date: Fri, 23 Jul 2010 14:00:25 +0200 Subject: Moved old sql files to /3.3.35a_old subdir. --HG-- branch : trunk --- sql/updates/3.3.5a_old/8890_world_spell_dbc.sql | 3 +++ sql/updates/3.3.5a_old/8891_world_spell_dbc.sql | 2 ++ sql/updates/3.3.5a_old/8897_world_npc_vendor.sql | 5 ++++ .../3.3.5a_old/8897_world_trinity_string.sql | 2 ++ .../3.3.5a_old/8905_world_spell_proc_event.sql | 3 +++ .../3.3.5a_old/8906_world_spell_proc_event.sql | 7 ++++++ .../3.3.5a_old/8915_world_trinity_string.sql | 5 ++++ sql/updates/3.3.5a_old/8920_world_spell_dbc.sql | 4 ++++ .../3.3.5a_old/8920_world_spell_linked_spell.sql | 4 ++++ sql/updates/3.3.5a_old/8921_world_spell_dbc.sql | 1 + sql/updates/3.3.5a_old/8925_world_spell_group.sql | 6 +++++ sql/updates/3.3.5a_old/8957_world_command.sql | 3 +++ sql/updates/3.3.5a_old/8957_world_disables.sql | 28 ++++++++++++++++++++++ .../3.3.5a_old/8957_world_trinity_string.sql | 2 ++ .../3.3.5a_old/8971_characters_characters.sql | 4 ++++ sql/updates/3.3.5a_old/8971_world_command.sql | 7 ++++++ .../3.3.5a_old/8971_world_trinity_string.sql | 13 ++++++++++ sql/updates/3.3.5a_old/8975_world_spell_dbc.sql | 4 ++++ .../3.3.5a_old/8986_characters_worldstates.sql | 2 ++ .../3.3.5a_old/8987_world_playercreateinfo.sql | 2 ++ .../3.3.5a_old/8988_world_playercreateinfo.sql | 6 +++++ sql/updates/8890_world_spell_dbc.sql | 3 --- sql/updates/8891_world_spell_dbc.sql | 2 -- sql/updates/8897_world_npc_vendor.sql | 5 ---- sql/updates/8897_world_trinity_string.sql | 2 -- sql/updates/8905_world_spell_proc_event.sql | 3 --- sql/updates/8906_world_spell_proc_event.sql | 7 ------ sql/updates/8915_world_trinity_string.sql | 5 ---- sql/updates/8920_world_spell_dbc.sql | 4 ---- sql/updates/8920_world_spell_linked_spell.sql | 4 ---- sql/updates/8921_world_spell_dbc.sql | 1 - sql/updates/8925_world_spell_group.sql | 6 ----- sql/updates/8957_world_command.sql | 3 --- sql/updates/8957_world_disables.sql | 28 ---------------------- sql/updates/8957_world_trinity_string.sql | 2 -- sql/updates/8971_characters_characters.sql | 4 ---- sql/updates/8971_world_command.sql | 7 ------ sql/updates/8971_world_trinity_string.sql | 13 ---------- sql/updates/8975_world_spell_dbc.sql | 4 ---- sql/updates/8986_characters_worldstates.sql | 3 --- sql/updates/8987_world_playercreateinfo.sql | 3 --- sql/updates/8988_world_playercreateinfo.sql | 7 ------ 42 files changed, 113 insertions(+), 116 deletions(-) create mode 100644 sql/updates/3.3.5a_old/8890_world_spell_dbc.sql create mode 100644 sql/updates/3.3.5a_old/8891_world_spell_dbc.sql create mode 100644 sql/updates/3.3.5a_old/8897_world_npc_vendor.sql create mode 100644 sql/updates/3.3.5a_old/8897_world_trinity_string.sql create mode 100644 sql/updates/3.3.5a_old/8905_world_spell_proc_event.sql create mode 100644 sql/updates/3.3.5a_old/8906_world_spell_proc_event.sql create mode 100644 sql/updates/3.3.5a_old/8915_world_trinity_string.sql create mode 100644 sql/updates/3.3.5a_old/8920_world_spell_dbc.sql create mode 100644 sql/updates/3.3.5a_old/8920_world_spell_linked_spell.sql create mode 100644 sql/updates/3.3.5a_old/8921_world_spell_dbc.sql create mode 100644 sql/updates/3.3.5a_old/8925_world_spell_group.sql create mode 100644 sql/updates/3.3.5a_old/8957_world_command.sql create mode 100644 sql/updates/3.3.5a_old/8957_world_disables.sql create mode 100644 sql/updates/3.3.5a_old/8957_world_trinity_string.sql create mode 100644 sql/updates/3.3.5a_old/8971_characters_characters.sql create mode 100644 sql/updates/3.3.5a_old/8971_world_command.sql create mode 100644 sql/updates/3.3.5a_old/8971_world_trinity_string.sql create mode 100644 sql/updates/3.3.5a_old/8975_world_spell_dbc.sql create mode 100644 sql/updates/3.3.5a_old/8986_characters_worldstates.sql create mode 100644 sql/updates/3.3.5a_old/8987_world_playercreateinfo.sql create mode 100644 sql/updates/3.3.5a_old/8988_world_playercreateinfo.sql delete mode 100644 sql/updates/8890_world_spell_dbc.sql delete mode 100644 sql/updates/8891_world_spell_dbc.sql delete mode 100644 sql/updates/8897_world_npc_vendor.sql delete mode 100644 sql/updates/8897_world_trinity_string.sql delete mode 100644 sql/updates/8905_world_spell_proc_event.sql delete mode 100644 sql/updates/8906_world_spell_proc_event.sql delete mode 100644 sql/updates/8915_world_trinity_string.sql delete mode 100644 sql/updates/8920_world_spell_dbc.sql delete mode 100644 sql/updates/8920_world_spell_linked_spell.sql delete mode 100644 sql/updates/8921_world_spell_dbc.sql delete mode 100644 sql/updates/8925_world_spell_group.sql delete mode 100644 sql/updates/8957_world_command.sql delete mode 100644 sql/updates/8957_world_disables.sql delete mode 100644 sql/updates/8957_world_trinity_string.sql delete mode 100644 sql/updates/8971_characters_characters.sql delete mode 100644 sql/updates/8971_world_command.sql delete mode 100644 sql/updates/8971_world_trinity_string.sql delete mode 100644 sql/updates/8975_world_spell_dbc.sql delete mode 100644 sql/updates/8986_characters_worldstates.sql delete mode 100644 sql/updates/8987_world_playercreateinfo.sql delete mode 100644 sql/updates/8988_world_playercreateinfo.sql (limited to 'sql') diff --git a/sql/updates/3.3.5a_old/8890_world_spell_dbc.sql b/sql/updates/3.3.5a_old/8890_world_spell_dbc.sql new file mode 100644 index 00000000000..a5e0927806f --- /dev/null +++ b/sql/updates/3.3.5a_old/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/sql/updates/3.3.5a_old/8891_world_spell_dbc.sql b/sql/updates/3.3.5a_old/8891_world_spell_dbc.sql new file mode 100644 index 00000000000..6adb4e5fd28 --- /dev/null +++ b/sql/updates/3.3.5a_old/8891_world_spell_dbc.sql @@ -0,0 +1,2 @@ +UPDATE `spell_dbc` SET `Stances`=0x90 WHERE `Id`=24899; +UPDATE `spell_dbc` SET `Stances`=0x1 WHERE `Id`=24900; diff --git a/sql/updates/3.3.5a_old/8897_world_npc_vendor.sql b/sql/updates/3.3.5a_old/8897_world_npc_vendor.sql new file mode 100644 index 00000000000..0e1c793863d --- /dev/null +++ b/sql/updates/3.3.5a_old/8897_world_npc_vendor.sql @@ -0,0 +1,5 @@ +-- Restore negative ExtendedCost, we now use FlagsExtra value instead +UPDATE `npc_vendor` SET `ExtendedCost`=-`ExtendedCost` WHERE `ExtendedCost`<0; + +-- Set field type to unsigned +ALTER TABLE npc_vendor CHANGE COLUMN `ExtendedCost` `ExtendedCost` mediumint(8) UNSIGNED NOT NULL default '0' COMMENT ''; diff --git a/sql/updates/3.3.5a_old/8897_world_trinity_string.sql b/sql/updates/3.3.5a_old/8897_world_trinity_string.sql new file mode 100644 index 00000000000..691b0723a5b --- /dev/null +++ b/sql/updates/3.3.5a_old/8897_world_trinity_string.sql @@ -0,0 +1,2 @@ +-- UPDATE so we don't kill customized locale strings if user has any +UPDATE `trinity_string` SET `content_default`='Item ''%u'' (with extended cost %u) already in vendor list.' WHERE `entry`=210; diff --git a/sql/updates/3.3.5a_old/8905_world_spell_proc_event.sql b/sql/updates/3.3.5a_old/8905_world_spell_proc_event.sql new file mode 100644 index 00000000000..7429a6a06b4 --- /dev/null +++ b/sql/updates/3.3.5a_old/8905_world_spell_proc_event.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN(67758); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(67758,0,0,0,0,0,0,2,0,0,2); diff --git a/sql/updates/3.3.5a_old/8906_world_spell_proc_event.sql b/sql/updates/3.3.5a_old/8906_world_spell_proc_event.sql new file mode 100644 index 00000000000..2d5c35c02a5 --- /dev/null +++ b/sql/updates/3.3.5a_old/8906_world_spell_proc_event.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (47201,47202,47203,47204,47205); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(47201,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0), +(47202,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0), +(47203,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0), +(47204,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0), +(47205,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0); \ No newline at end of file diff --git a/sql/updates/3.3.5a_old/8915_world_trinity_string.sql b/sql/updates/3.3.5a_old/8915_world_trinity_string.sql new file mode 100644 index 00000000000..3c882c98895 --- /dev/null +++ b/sql/updates/3.3.5a_old/8915_world_trinity_string.sql @@ -0,0 +1,5 @@ +-- UPDATE so we don't kill customized locale strings if user has any +UPDATE `trinity_string` SET `content_default`='The old password is wrong' WHERE `entry`=27; +-- INSERT as this string has not been used before +DELETE FROM `trinity_string` WHERE `entry`=62; +INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`) VALUES (62, 'One on more parameters have incorrect values', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff --git a/sql/updates/3.3.5a_old/8920_world_spell_dbc.sql b/sql/updates/3.3.5a_old/8920_world_spell_dbc.sql new file mode 100644 index 00000000000..a400139824a --- /dev/null +++ b/sql/updates/3.3.5a_old/8920_world_spell_dbc.sql @@ -0,0 +1,4 @@ +-- Add serverside spells place holders for future development +DELETE FROM `spell_dbc` WHERE `Id` IN (70878); +INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES +(70878, 'Creature 40160 creature_addon serverside spell'); diff --git a/sql/updates/3.3.5a_old/8920_world_spell_linked_spell.sql b/sql/updates/3.3.5a_old/8920_world_spell_linked_spell.sql new file mode 100644 index 00000000000..2b6a4bcf9ed --- /dev/null +++ b/sql/updates/3.3.5a_old/8920_world_spell_linked_spell.sql @@ -0,0 +1,4 @@ +-- For quest: Truce? +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=50141; +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(50141,50001,0, 'Blood Oath to Blood Oath Aura'); diff --git a/sql/updates/3.3.5a_old/8921_world_spell_dbc.sql b/sql/updates/3.3.5a_old/8921_world_spell_dbc.sql new file mode 100644 index 00000000000..7e53fc4bbf2 --- /dev/null +++ b/sql/updates/3.3.5a_old/8921_world_spell_dbc.sql @@ -0,0 +1 @@ +UPDATE `spell_dbc` SET `Effect1`=6,`EffectApplyAuraName1`=4 WHERE `Id` IN (70878); diff --git a/sql/updates/3.3.5a_old/8925_world_spell_group.sql b/sql/updates/3.3.5a_old/8925_world_spell_group.sql new file mode 100644 index 00000000000..0e7d2cf894e --- /dev/null +++ b/sql/updates/3.3.5a_old/8925_world_spell_group.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_group` WHERE `id` = 1103; +-- Cast Speed Slow +INSERT INTO `spell_group` (`id`,`spell_id`) VALUES +(1103,-1100), +(1103,-1101), +(1103,-1102); diff --git a/sql/updates/3.3.5a_old/8957_world_command.sql b/sql/updates/3.3.5a_old/8957_world_command.sql new file mode 100644 index 00000000000..a1aafb56a62 --- /dev/null +++ b/sql/updates/3.3.5a_old/8957_world_command.sql @@ -0,0 +1,3 @@ +DELETE FROM `command` WHERE `name` IN ('reload disables','reload spell_disabled','instance open','instance close'); +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('reload disables',3,'Syntax: .reload disables\r\nReload disables table.'); diff --git a/sql/updates/3.3.5a_old/8957_world_disables.sql b/sql/updates/3.3.5a_old/8957_world_disables.sql new file mode 100644 index 00000000000..3e6990e4997 --- /dev/null +++ b/sql/updates/3.3.5a_old/8957_world_disables.sql @@ -0,0 +1,28 @@ +-- Step 1: prepare table +DROP TABLE IF EXISTS `disables`; +CREATE TABLE `disables` ( + `sourceType` int(10) unsigned NOT NULL, + `entry` int(10) unsigned NOT NULL, + `flags` tinyint(3) unsigned NOT NULL default '0', + `comment` varchar(255) character set utf8 NOT NULL default '', + PRIMARY KEY (`sourceType`,`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- Step 2: pull data +-- a) spells +INSERT INTO `disables` SELECT 0,`entry`,`disable_mask`,`comment` FROM `spell_disabled`; + +-- b) maps (areatriggers) +-- don't convert + +-- c) battlegrounds +INSERT INTO `disables` SELECT 3,`id`,0,'' FROM `battleground_template` WHERE `disable`=1; + +-- d) achievement criteria data +INSERT INTO `disables` SELECT 4,`criteria_id`,0,'' FROM `achievement_criteria_data` WHERE `type`=11; + +-- Step 3: drop old fields/tables/data +DROP TABLE IF EXISTS `spell_disabled`; +ALTER TABLE `access_requirement` DROP `status`; +ALTER TABLE `battleground_template` DROP `disable`; +DELETE FROM `achievement_criteria_data` WHERE `type`=11; diff --git a/sql/updates/3.3.5a_old/8957_world_trinity_string.sql b/sql/updates/3.3.5a_old/8957_world_trinity_string.sql new file mode 100644 index 00000000000..4919f044ca0 --- /dev/null +++ b/sql/updates/3.3.5a_old/8957_world_trinity_string.sql @@ -0,0 +1,2 @@ +-- Fix engrish in strings +UPDATE `trinity_string` SET `content_default`='This Battleground has been disabled. You can''t join the queue.' WHERE `entry`=747; diff --git a/sql/updates/3.3.5a_old/8971_characters_characters.sql b/sql/updates/3.3.5a_old/8971_characters_characters.sql new file mode 100644 index 00000000000..278c018c045 --- /dev/null +++ b/sql/updates/3.3.5a_old/8971_characters_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `characters` + ADD COLUMN `deleteInfos_Account` int(11) UNSIGNED default NULL AFTER actionBars, + ADD COLUMN `deleteInfos_Name` varchar(12) default NULL AFTER deleteInfos_Account, + ADD COLUMN `deleteDate` bigint(20) default NULL AFTER deleteInfos_Name; diff --git a/sql/updates/3.3.5a_old/8971_world_command.sql b/sql/updates/3.3.5a_old/8971_world_command.sql new file mode 100644 index 00000000000..ff5efd867f5 --- /dev/null +++ b/sql/updates/3.3.5a_old/8971_world_command.sql @@ -0,0 +1,7 @@ +DELETE FROM command WHERE name IN ('character delete', 'character deleted list', 'character deleted restore', 'character deleted delete', 'character deleted old', 'character erase'); +INSERT INTO command (name, security, help) VALUES +('character erase',4,'Syntax: .character erase $name\r\n\r\nDelete character $name. Character finally deleted in case any deleting options.'), +('character deleted delete', 4, 'Syntax: .character deleted delete #guid|$name\r\n\r\nCompletely deletes the selected characters.\r\nIf $name is supplied, only characters with that string in their name will be deleted, if #guid is supplied, only the character with that GUID will be deleted.'), +('character deleted list', 3, 'Syntax: .character deleted list [#guid|$name]\r\n\r\nShows a list with all deleted characters.\r\nIf $name is supplied, only characters with that string in their name will be selected, if #guid is supplied, only the character with that GUID will be selected.'), +('character deleted old', 4, 'Syntax: .character deleted old [#keepDays]\r\n\r\nCompletely deletes all characters with deleted time longer #keepDays. If #keepDays not provided the used value from mangosd.conf option ''CharDelete.KeepDays''. If referenced config option disabled (use 0 value) then command can''t be used without #keepDays.'), +('character deleted restore', 3, 'Syntax: .character deleted restore #guid|$name [$newname] [#new account]\r\n\r\nRestores deleted characters.\r\nIf $name is supplied, only characters with that string in their name will be restored, if $guid is supplied, only the character with that GUID will be restored.\r\nIf $newname is set, the character will be restored with that name instead of the original one. If #newaccount is set, the character will be restored to specific account character list. This works only with one character!'); diff --git a/sql/updates/3.3.5a_old/8971_world_trinity_string.sql b/sql/updates/3.3.5a_old/8971_world_trinity_string.sql new file mode 100644 index 00000000000..c2b93cf7f85 --- /dev/null +++ b/sql/updates/3.3.5a_old/8971_world_trinity_string.sql @@ -0,0 +1,13 @@ +DELETE FROM trinity_string WHERE entry IN (1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026); +INSERT INTO trinity_string VALUES +(1016, '| GUID | Name | Account | Delete Date |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1017, '| %10u | %20s | %15s (%10u) | %19s |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1018, '==========================================================================================', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1019, 'No characters found.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1020, 'Restoring the following characters:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1021, 'Deleting the following characters:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1022, 'ERROR: You can only assign a new name if you have only selected a single character!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1023, 'Character ''%s'' (GUID: %u Account %u) can''t be restored: account not exist!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1024, 'Character ''%s'' (GUID: %u Account %u) can''t be restored: account character list full!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1025, 'Character ''%s'' (GUID: %u Account %u) can''t be restored: new name already used!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(1026, 'GUID: %u Name: %s Account: %s (%u) Date: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff --git a/sql/updates/3.3.5a_old/8975_world_spell_dbc.sql b/sql/updates/3.3.5a_old/8975_world_spell_dbc.sql new file mode 100644 index 00000000000..52a20b8a14d --- /dev/null +++ b/sql/updates/3.3.5a_old/8975_world_spell_dbc.sql @@ -0,0 +1,4 @@ +-- Add serverside spells place holders for future development +DELETE FROM `spell_dbc` WHERE `Id` IN (38406); +INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES +(38406, 'Quest 10721 RewSpellCast serverside spell'); diff --git a/sql/updates/3.3.5a_old/8986_characters_worldstates.sql b/sql/updates/3.3.5a_old/8986_characters_worldstates.sql new file mode 100644 index 00000000000..6ebdd8e6d37 --- /dev/null +++ b/sql/updates/3.3.5a_old/8986_characters_worldstates.sql @@ -0,0 +1,2 @@ +DELETE FROM `worldstates` WHERE `entry`=20004; +INSERT INTO `worldstates` (`entry`,`value`,`comment`) VALUES (20004,0, 'cleaning_flags'); diff --git a/sql/updates/3.3.5a_old/8987_world_playercreateinfo.sql b/sql/updates/3.3.5a_old/8987_world_playercreateinfo.sql new file mode 100644 index 00000000000..ac407e16d67 --- /dev/null +++ b/sql/updates/3.3.5a_old/8987_world_playercreateinfo.sql @@ -0,0 +1,2 @@ +ALTER TABLE `playercreateinfo` + ADD COLUMN `orientation` float NOT NULL DEFAULT 0 AFTER `position_z`; diff --git a/sql/updates/3.3.5a_old/8988_world_playercreateinfo.sql b/sql/updates/3.3.5a_old/8988_world_playercreateinfo.sql new file mode 100644 index 00000000000..227dc4256f3 --- /dev/null +++ b/sql/updates/3.3.5a_old/8988_world_playercreateinfo.sql @@ -0,0 +1,6 @@ +UPDATE `playercreateinfo` SET `orientation`=5.696318 WHERE `race`=4 AND `class`<>6; +UPDATE `playercreateinfo` SET `orientation`=6.177156 WHERE `race`=3 AND `class`<>6; +UPDATE `playercreateinfo` SET `orientation`=2.70526 WHERE `race`=5 AND `class`<>6; +UPDATE `playercreateinfo` SET `orientation`=5.316046 WHERE `race`=10 AND `class`<>6; +UPDATE `playercreateinfo` SET `orientation`=2.083644 WHERE `race`=11 AND `class`<>6; +UPDATE `playercreateinfo` SET `orientation`=3.659973 WHERE `class`=6; diff --git a/sql/updates/8890_world_spell_dbc.sql b/sql/updates/8890_world_spell_dbc.sql deleted file mode 100644 index a5e0927806f..00000000000 --- a/sql/updates/8890_world_spell_dbc.sql +++ /dev/null @@ -1,3 +0,0 @@ -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/sql/updates/8891_world_spell_dbc.sql b/sql/updates/8891_world_spell_dbc.sql deleted file mode 100644 index 6adb4e5fd28..00000000000 --- a/sql/updates/8891_world_spell_dbc.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `spell_dbc` SET `Stances`=0x90 WHERE `Id`=24899; -UPDATE `spell_dbc` SET `Stances`=0x1 WHERE `Id`=24900; diff --git a/sql/updates/8897_world_npc_vendor.sql b/sql/updates/8897_world_npc_vendor.sql deleted file mode 100644 index 0e1c793863d..00000000000 --- a/sql/updates/8897_world_npc_vendor.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Restore negative ExtendedCost, we now use FlagsExtra value instead -UPDATE `npc_vendor` SET `ExtendedCost`=-`ExtendedCost` WHERE `ExtendedCost`<0; - --- Set field type to unsigned -ALTER TABLE npc_vendor CHANGE COLUMN `ExtendedCost` `ExtendedCost` mediumint(8) UNSIGNED NOT NULL default '0' COMMENT ''; diff --git a/sql/updates/8897_world_trinity_string.sql b/sql/updates/8897_world_trinity_string.sql deleted file mode 100644 index 691b0723a5b..00000000000 --- a/sql/updates/8897_world_trinity_string.sql +++ /dev/null @@ -1,2 +0,0 @@ --- UPDATE so we don't kill customized locale strings if user has any -UPDATE `trinity_string` SET `content_default`='Item ''%u'' (with extended cost %u) already in vendor list.' WHERE `entry`=210; diff --git a/sql/updates/8905_world_spell_proc_event.sql b/sql/updates/8905_world_spell_proc_event.sql deleted file mode 100644 index 7429a6a06b4..00000000000 --- a/sql/updates/8905_world_spell_proc_event.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN(67758); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(67758,0,0,0,0,0,0,2,0,0,2); diff --git a/sql/updates/8906_world_spell_proc_event.sql b/sql/updates/8906_world_spell_proc_event.sql deleted file mode 100644 index 2d5c35c02a5..00000000000 --- a/sql/updates/8906_world_spell_proc_event.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (47201,47202,47203,47204,47205); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -(47201,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0), -(47202,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0), -(47203,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0), -(47204,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0), -(47205,0,5,0x00004009,0x00040000,0x00000000,0x00000000,0x0000000,0,0,0); \ No newline at end of file diff --git a/sql/updates/8915_world_trinity_string.sql b/sql/updates/8915_world_trinity_string.sql deleted file mode 100644 index 3c882c98895..00000000000 --- a/sql/updates/8915_world_trinity_string.sql +++ /dev/null @@ -1,5 +0,0 @@ --- UPDATE so we don't kill customized locale strings if user has any -UPDATE `trinity_string` SET `content_default`='The old password is wrong' WHERE `entry`=27; --- INSERT as this string has not been used before -DELETE FROM `trinity_string` WHERE `entry`=62; -INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`) VALUES (62, 'One on more parameters have incorrect values', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff --git a/sql/updates/8920_world_spell_dbc.sql b/sql/updates/8920_world_spell_dbc.sql deleted file mode 100644 index a400139824a..00000000000 --- a/sql/updates/8920_world_spell_dbc.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Add serverside spells place holders for future development -DELETE FROM `spell_dbc` WHERE `Id` IN (70878); -INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES -(70878, 'Creature 40160 creature_addon serverside spell'); diff --git a/sql/updates/8920_world_spell_linked_spell.sql b/sql/updates/8920_world_spell_linked_spell.sql deleted file mode 100644 index 2b6a4bcf9ed..00000000000 --- a/sql/updates/8920_world_spell_linked_spell.sql +++ /dev/null @@ -1,4 +0,0 @@ --- For quest: Truce? -DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=50141; -INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES -(50141,50001,0, 'Blood Oath to Blood Oath Aura'); diff --git a/sql/updates/8921_world_spell_dbc.sql b/sql/updates/8921_world_spell_dbc.sql deleted file mode 100644 index 7e53fc4bbf2..00000000000 --- a/sql/updates/8921_world_spell_dbc.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `spell_dbc` SET `Effect1`=6,`EffectApplyAuraName1`=4 WHERE `Id` IN (70878); diff --git a/sql/updates/8925_world_spell_group.sql b/sql/updates/8925_world_spell_group.sql deleted file mode 100644 index 0e7d2cf894e..00000000000 --- a/sql/updates/8925_world_spell_group.sql +++ /dev/null @@ -1,6 +0,0 @@ -DELETE FROM `spell_group` WHERE `id` = 1103; --- Cast Speed Slow -INSERT INTO `spell_group` (`id`,`spell_id`) VALUES -(1103,-1100), -(1103,-1101), -(1103,-1102); diff --git a/sql/updates/8957_world_command.sql b/sql/updates/8957_world_command.sql deleted file mode 100644 index a1aafb56a62..00000000000 --- a/sql/updates/8957_world_command.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `command` WHERE `name` IN ('reload disables','reload spell_disabled','instance open','instance close'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES -('reload disables',3,'Syntax: .reload disables\r\nReload disables table.'); diff --git a/sql/updates/8957_world_disables.sql b/sql/updates/8957_world_disables.sql deleted file mode 100644 index 3e6990e4997..00000000000 --- a/sql/updates/8957_world_disables.sql +++ /dev/null @@ -1,28 +0,0 @@ --- Step 1: prepare table -DROP TABLE IF EXISTS `disables`; -CREATE TABLE `disables` ( - `sourceType` int(10) unsigned NOT NULL, - `entry` int(10) unsigned NOT NULL, - `flags` tinyint(3) unsigned NOT NULL default '0', - `comment` varchar(255) character set utf8 NOT NULL default '', - PRIMARY KEY (`sourceType`,`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- Step 2: pull data --- a) spells -INSERT INTO `disables` SELECT 0,`entry`,`disable_mask`,`comment` FROM `spell_disabled`; - --- b) maps (areatriggers) --- don't convert - --- c) battlegrounds -INSERT INTO `disables` SELECT 3,`id`,0,'' FROM `battleground_template` WHERE `disable`=1; - --- d) achievement criteria data -INSERT INTO `disables` SELECT 4,`criteria_id`,0,'' FROM `achievement_criteria_data` WHERE `type`=11; - --- Step 3: drop old fields/tables/data -DROP TABLE IF EXISTS `spell_disabled`; -ALTER TABLE `access_requirement` DROP `status`; -ALTER TABLE `battleground_template` DROP `disable`; -DELETE FROM `achievement_criteria_data` WHERE `type`=11; diff --git a/sql/updates/8957_world_trinity_string.sql b/sql/updates/8957_world_trinity_string.sql deleted file mode 100644 index 4919f044ca0..00000000000 --- a/sql/updates/8957_world_trinity_string.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Fix engrish in strings -UPDATE `trinity_string` SET `content_default`='This Battleground has been disabled. You can''t join the queue.' WHERE `entry`=747; diff --git a/sql/updates/8971_characters_characters.sql b/sql/updates/8971_characters_characters.sql deleted file mode 100644 index 278c018c045..00000000000 --- a/sql/updates/8971_characters_characters.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE `characters` - ADD COLUMN `deleteInfos_Account` int(11) UNSIGNED default NULL AFTER actionBars, - ADD COLUMN `deleteInfos_Name` varchar(12) default NULL AFTER deleteInfos_Account, - ADD COLUMN `deleteDate` bigint(20) default NULL AFTER deleteInfos_Name; diff --git a/sql/updates/8971_world_command.sql b/sql/updates/8971_world_command.sql deleted file mode 100644 index ff5efd867f5..00000000000 --- a/sql/updates/8971_world_command.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM command WHERE name IN ('character delete', 'character deleted list', 'character deleted restore', 'character deleted delete', 'character deleted old', 'character erase'); -INSERT INTO command (name, security, help) VALUES -('character erase',4,'Syntax: .character erase $name\r\n\r\nDelete character $name. Character finally deleted in case any deleting options.'), -('character deleted delete', 4, 'Syntax: .character deleted delete #guid|$name\r\n\r\nCompletely deletes the selected characters.\r\nIf $name is supplied, only characters with that string in their name will be deleted, if #guid is supplied, only the character with that GUID will be deleted.'), -('character deleted list', 3, 'Syntax: .character deleted list [#guid|$name]\r\n\r\nShows a list with all deleted characters.\r\nIf $name is supplied, only characters with that string in their name will be selected, if #guid is supplied, only the character with that GUID will be selected.'), -('character deleted old', 4, 'Syntax: .character deleted old [#keepDays]\r\n\r\nCompletely deletes all characters with deleted time longer #keepDays. If #keepDays not provided the used value from mangosd.conf option ''CharDelete.KeepDays''. If referenced config option disabled (use 0 value) then command can''t be used without #keepDays.'), -('character deleted restore', 3, 'Syntax: .character deleted restore #guid|$name [$newname] [#new account]\r\n\r\nRestores deleted characters.\r\nIf $name is supplied, only characters with that string in their name will be restored, if $guid is supplied, only the character with that GUID will be restored.\r\nIf $newname is set, the character will be restored with that name instead of the original one. If #newaccount is set, the character will be restored to specific account character list. This works only with one character!'); diff --git a/sql/updates/8971_world_trinity_string.sql b/sql/updates/8971_world_trinity_string.sql deleted file mode 100644 index c2b93cf7f85..00000000000 --- a/sql/updates/8971_world_trinity_string.sql +++ /dev/null @@ -1,13 +0,0 @@ -DELETE FROM trinity_string WHERE entry IN (1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026); -INSERT INTO trinity_string VALUES -(1016, '| GUID | Name | Account | Delete Date |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1017, '| %10u | %20s | %15s (%10u) | %19s |', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1018, '==========================================================================================', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1019, 'No characters found.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1020, 'Restoring the following characters:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1021, 'Deleting the following characters:', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1022, 'ERROR: You can only assign a new name if you have only selected a single character!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1023, 'Character ''%s'' (GUID: %u Account %u) can''t be restored: account not exist!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1024, 'Character ''%s'' (GUID: %u Account %u) can''t be restored: account character list full!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1025, 'Character ''%s'' (GUID: %u Account %u) can''t be restored: new name already used!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(1026, 'GUID: %u Name: %s Account: %s (%u) Date: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff --git a/sql/updates/8975_world_spell_dbc.sql b/sql/updates/8975_world_spell_dbc.sql deleted file mode 100644 index 52a20b8a14d..00000000000 --- a/sql/updates/8975_world_spell_dbc.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Add serverside spells place holders for future development -DELETE FROM `spell_dbc` WHERE `Id` IN (38406); -INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES -(38406, 'Quest 10721 RewSpellCast serverside spell'); diff --git a/sql/updates/8986_characters_worldstates.sql b/sql/updates/8986_characters_worldstates.sql deleted file mode 100644 index 78234428a37..00000000000 --- a/sql/updates/8986_characters_worldstates.sql +++ /dev/null @@ -1,3 +0,0 @@ - -DELETE FROM `worldstates` WHERE `entry`=20004; -INSERT INTO `worldstates` (`entry`,`value`,`comment`) VALUES (20004,0, 'cleaning_flags'); diff --git a/sql/updates/8987_world_playercreateinfo.sql b/sql/updates/8987_world_playercreateinfo.sql deleted file mode 100644 index 040ec9cc2fd..00000000000 --- a/sql/updates/8987_world_playercreateinfo.sql +++ /dev/null @@ -1,3 +0,0 @@ - -ALTER TABLE `playercreateinfo` - ADD COLUMN `orientation` float NOT NULL DEFAULT 0 AFTER `position_z`; diff --git a/sql/updates/8988_world_playercreateinfo.sql b/sql/updates/8988_world_playercreateinfo.sql deleted file mode 100644 index 81b4cfb1f33..00000000000 --- a/sql/updates/8988_world_playercreateinfo.sql +++ /dev/null @@ -1,7 +0,0 @@ - -UPDATE `playercreateinfo` SET `orientation`=5.696318 WHERE `race`=4 AND `class`<>6; -UPDATE `playercreateinfo` SET `orientation`=6.177156 WHERE `race`=3 AND `class`<>6; -UPDATE `playercreateinfo` SET `orientation`=2.70526 WHERE `race`=5 AND `class`<>6; -UPDATE `playercreateinfo` SET `orientation`=5.316046 WHERE `race`=10 AND `class`<>6; -UPDATE `playercreateinfo` SET `orientation`=2.083644 WHERE `race`=11 AND `class`<>6; -UPDATE `playercreateinfo` SET `orientation`=3.659973 WHERE `class`=6; -- cgit v1.2.3