diff options
Diffstat (limited to 'sql/old/3.0.9')
21 files changed, 48 insertions, 48 deletions
diff --git a/sql/old/3.0.9/00000_3.0.9_old.sql b/sql/old/3.0.9/00000_3.0.9_old.sql index fa57faa3778..d1ca5e5ae35 100644 --- a/sql/old/3.0.9/00000_3.0.9_old.sql +++ b/sql/old/3.0.9/00000_3.0.9_old.sql @@ -402,11 +402,11 @@ INSERT INTO `spell_bonus_data` VALUES -- 1135_mangos_7207_01_world_creature ALTER TABLE creature ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `spawnMask`; - + -- 1135_mangos_7207_02_world_gameobject ALTER TABLE gameobject ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `spawnMask`; - + -- 1140_mangos_7209_01_world_spell_bonus_data DELETE FROM `spell_bonus_data` WHERE `entry` IN (53595); INSERT INTO `spell_bonus_data` VALUES @@ -1319,7 +1319,7 @@ INSERT INTO spell_bonus_data VALUES (34913, 0, 0, 0, 'Mage - Molten Armor Triggered Rank 1'), (43043, 0, 0, 0, 'Mage - Molten Armor Triggered Rank 2'), (43044, 0, 0, 0, 'Mage - Molten Armor Triggered Rank 3'); - + -- 1293_mangos_7249_01_world_spell_proc_event DELETE FROM `spell_proc_event` WHERE `entry`='60200'; @@ -2267,7 +2267,7 @@ INSERT INTO `command` VALUES ('npc setdeathstate',2,'Syntax: .npc setdeathstate on/off\r\n\r\nSet default death state (dead/alive) for npc at spawn.'); -- 1426_mangos_7292_01_world_points_of_interest -DROP TABLE IF EXISTS `points_of_interest`; +DROP TABLE IF EXISTS `points_of_interest`; CREATE TABLE `points_of_interest` ( `entry` mediumint(8) unsigned NOT NULL default '0', `x` float NOT NULL default '0', @@ -2280,7 +2280,7 @@ CREATE TABLE `points_of_interest` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- 1426_mangos_7292_02_world_locales_points_of_interest -DROP TABLE IF EXISTS `locales_points_of_interest`; +DROP TABLE IF EXISTS `locales_points_of_interest`; CREATE TABLE `locales_points_of_interest` ( `entry` mediumint(8) unsigned NOT NULL default '0', `icon_name_loc1` text, @@ -2489,16 +2489,16 @@ ALTER TABLE spell_area ALTER TABLE creature_template ADD COLUMN unk16 float NOT NULL default '1' AFTER InhabitType, ADD COLUMN unk17 float NOT NULL default '1' AFTER unk16; - + -- 1693_world -- Update Proc Rate -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ('60442', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), ('57345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), ('61356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), ('54707', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'), ('54808', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'); --- Update Spell Coefficients +-- Update Spell Coefficients DELETE FROM `spell_bonus_data` WHERE `entry` IN ('689', '18790', '172', '42223', '42224', '42225', '42226', '42218', '47817', '47818', '1949', '5857', '11681', '11682', '27214', '47822', '27243', '30108', '17962', '6789', '48181', '29722', '5676', '686', '17877', '30283', '1120', '30294', '44425', '42208', '42209', '42210', '42211', '42212', '42213', '42198', '42937', '42938', '11113', '31661', '120', '19750', '635', '25914', '25913', '25903', '27175', '33074', '48820', '48821', '58597', '31803', '53742', '31893', '32221', '53719', '53718', '20167', '20424', '31804', '53733', '31898', '32220', '53726', '53725', '20267', '20187', '20467', '53600', '596', '2944', '8092', '27813', '27817', '27818', '33619'); INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES ('689', '0', '0.143', '0', 'Warlock - Drain Life'), @@ -2743,7 +2743,7 @@ UPDATE `areatrigger_teleport` SET `access_id` = '52' WHERE `id` IN ('4352','4354 -- 1709_mangos_7393_01_world_game_event ALTER TABLE `game_event` ADD COLUMN `holiday` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Client side holiday id' AFTER `length`; - + -- 1724_mangos_7399_01_world_trinity_string DELETE FROM `trinity_string` WHERE `entry` IN (753, 754, 755); INSERT INTO `trinity_string` VALUES @@ -2998,7 +2998,7 @@ UPDATE `command` SET `name`="ahbotoption" WHERE `name`="ahbotoptions"; DELETE FROM `command` WHERE `name` IN ('reload tickets'); DELETE FROM `command` WHERE `name` LIKE "path%"; DELETE FROM `command` WHERE `name` LIKE "wp%"; -INSERT INTO `command` VALUES +INSERT INTO `command` VALUES ('wp load',2,'Syntax: .path load $pathid\nLoad pathid number for selected creature. Creature must have no waypoint data.'), ('wp event',2,'Syntax: .path event $subcommand\nType .path event to see the list of possible subcommands or .help path event $subcommand to see info on subcommands.'), ('wp event add',2,'Syntax: .path event add $subcommand\nAdd new waypoint action in DB.'), @@ -3110,7 +3110,7 @@ INSERT INTO `command` VALUES UPDATE `command` SET `name`="ahbotoption" WHERE `name`="ahbotoptions"; DELETE FROM `command` WHERE `name` LIKE "path%"; DELETE FROM `command` WHERE `name` LIKE "wp%"; -INSERT INTO `command` VALUES +INSERT INTO `command` VALUES ('wp load',2,'Syntax: .wp load $pathid\nLoad pathid number for selected creature. Creature must have no waypoint data.'), ('wp event',2,'Syntax: .wp event $subcommand\nType .path event to see the list of possible subcommands or .help path event $subcommand to see info on subcommands.'), ('wp unload',2,'Syntax: .wp unload\nUnload path for selected creature.'), @@ -3134,7 +3134,7 @@ INSERT INTO `command` VALUES -- 2276_mangos_7560_01_world_gameobject_template ALTER TABLE gameobject_template ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name; - + -- 2280_mangos_7565_01_world_trinity_string DELETE FROM `trinity_string` WHERE `entry` IN (1010,1011,1012,1013,1014); INSERT INTO `trinity_string` VALUES @@ -3185,7 +3185,7 @@ INSERT INTO `spell_proc_event` VALUES (24905, 0x00, 0, 0x00000000, 0x00000000, 0 -- 2296_world ALTER TABLE creature_template ADD COLUMN `VehicleId` mediumint(8) unsigned NOT NULL default '0' AFTER `PetSpellDataId`; - + -- 2339_world - 2346_world DELETE FROM `command` WHERE `name` LIKE "ahbotoption %"; DELETE FROM `command` WHERE `name` LIKE "ahbotoptions %"; @@ -3338,7 +3338,7 @@ CREATE TABLE `achievement_criteria_data` ( ALTER TABLE `achievement_criteria_data` DROP PRIMARY KEY, ADD PRIMARY KEY (`criteria_id`,`type`); - + -- 2551_world_spell_bonus_data -- Judgement DELETE FROM `spell_bonus_data` WHERE `entry` = 54158; @@ -3785,7 +3785,7 @@ INSERT INTO `spell_proc_event` VALUES -- 2686_world_command DELETE FROM `command` WHERE `name` IN ('go ticket'); -INSERT INTO `command` VALUES +INSERT INTO `command` VALUES ('go ticket','1','Syntax: .go ticket #ticketid\r\nTeleports the user to the location where $ticketid was created.'); -- 2687_world_spell_proc_event @@ -4058,7 +4058,7 @@ INSERT INTO `spell_proc_event` VALUES INSERT INTO trinity_string (entry, content_default)VALUES (6616 , "Pet spells will reset for all players at login. Strongly recommend re-login!"); -- 2907_mangos_7705_01_world_command -DELETE FROM `command` WHERE `name` IN +DELETE FROM `command` WHERE `name` IN ('account lock','account password','chardelete','character customize','character delete','character rename','customize','lockaccount','password','rename'); INSERT INTO `command` VALUES ('account lock',0,'Syntax: .account lock [on|off]\r\n\r\nAllow login from account only from current used IP or remove this requirement.'), @@ -4127,7 +4127,7 @@ INSERT INTO `spell_script_target` () VALUES (46589, 1, 30614); INSERT INTO `spell_script_target` () VALUES (45839, 1, 25653); DELETE FROM `creature_template` WHERE entry in (30598, 30614); -INSERT INTO `creature_template` () VALUES +INSERT INTO `creature_template` () VALUES (30598, 0, 4449, 0, 4449, 0, 'Spike Target', '', '', 70, 70, 1, 1, 0, 0, 0, 14, 14, 0, 1, 1, 0, 0, 0, 0, 0, 2600, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 1, 0, 0, 128, ''), (30614, 0, 4449, 0, 4449, 0, 'Spike Target 2', '', '', 70, 70, 1, 1, 0, 0, 0, 14, 14, 0, 1, 1, 0, 0, 0, 0, 0, 2600, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 1, 0, 0, 128, ''); diff --git a/sql/old/3.0.9/01426_mangos_7292_01_world_points_of_interest.sql b/sql/old/3.0.9/01426_mangos_7292_01_world_points_of_interest.sql index 0dcd481bafe..4048df0f99c 100644 --- a/sql/old/3.0.9/01426_mangos_7292_01_world_points_of_interest.sql +++ b/sql/old/3.0.9/01426_mangos_7292_01_world_points_of_interest.sql @@ -1,6 +1,6 @@ /*ALTER TABLE db_version CHANGE COLUMN required_7290_01_mangos_command required_7292_01_mangos_points_of_interest bit;*/ -DROP TABLE IF EXISTS `points_of_interest`; +DROP TABLE IF EXISTS `points_of_interest`; CREATE TABLE `points_of_interest` ( `entry` mediumint(8) unsigned NOT NULL default '0', `x` float NOT NULL default '0', diff --git a/sql/old/3.0.9/01426_mangos_7292_02_world_locales_points_of_interest.sql b/sql/old/3.0.9/01426_mangos_7292_02_world_locales_points_of_interest.sql index 2a1989ef0be..4240df090f8 100644 --- a/sql/old/3.0.9/01426_mangos_7292_02_world_locales_points_of_interest.sql +++ b/sql/old/3.0.9/01426_mangos_7292_02_world_locales_points_of_interest.sql @@ -1,6 +1,6 @@ /*ALTER TABLE db_version CHANGE COLUMN required_7292_01_mangos_points_of_interest required_7292_02_mangos_locales_points_of_interest bit;*/ -DROP TABLE IF EXISTS `locales_points_of_interest`; +DROP TABLE IF EXISTS `locales_points_of_interest`; CREATE TABLE `locales_points_of_interest` ( `entry` mediumint(8) unsigned NOT NULL default '0', `icon_name_loc1` text, diff --git a/sql/old/3.0.9/01693_world.sql b/sql/old/3.0.9/01693_world.sql index d3b167561dd..3366e1e7a60 100644 --- a/sql/old/3.0.9/01693_world.sql +++ b/sql/old/3.0.9/01693_world.sql @@ -1,12 +1,12 @@ -- Update Proc Rate -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ('60442', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), ('57345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), ('61356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), ('54707', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'), ('54808', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'); --- Update Spell Coefficients +-- Update Spell Coefficients DELETE FROM `spell_bonus_data` WHERE `entry` IN ('689', '18790', '172', '42223', '42224', '42225', '42226', '42218', '47817', '47818', '1949', '5857', '11681', '11682', '27214', '47822', '27243', '30108', '17962', '6789', '48181', '29722', '5676', '686', '17877', '30283', '1120', '30294', '44425', '42208', '42209', '42210', '42211', '42212', '42213', '42198', '42937', '42938', '11113', '31661', '120', '19750', '635', '25914', '25913', '25903', '27175', '33074', '48820', '48821', '58597', '31803', '53742', '31893', '32221', '53719', '53718', '20167', '20424', '31804', '53733', '31898', '32220', '53726', '53725', '20267', '20187', '20467', '53600', '596', '2944', '8092', '27813', '27817', '27818', '33619'); INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES ('689', '0', '0.143', '0', 'Warlock - Drain Life'), diff --git a/sql/old/3.0.9/02131_world.sql b/sql/old/3.0.9/02131_world.sql index 60b56178bdd..fdf14b88bf4 100644 --- a/sql/old/3.0.9/02131_world.sql +++ b/sql/old/3.0.9/02131_world.sql @@ -6,7 +6,7 @@ UPDATE `command` SET `name`="ahbotoption" WHERE `name`="ahbotoptions"; DELETE FROM `command` WHERE `name` IN ('reload tickets'); DELETE FROM `command` WHERE `name` LIKE "path%"; DELETE FROM `command` WHERE `name` LIKE "wp%"; -INSERT INTO `command` VALUES +INSERT INTO `command` VALUES ('wp load',2,'Syntax: .wp load $pathid\nLoad pathid number for selected creature. Creature must have no waypoint data.'), ('wp event',2,'Syntax: .wp event $subcommand\nType .path event to see the list of possible subcommands or .help path event $subcommand to see info on subcommands.'), ('wp event add',2,'Syntax: .wp event add $subcommand\nAdd new waypoint action in DB.'), diff --git a/sql/old/3.0.9/02254_world.sql b/sql/old/3.0.9/02254_world.sql index fef5b79a9f6..b7708ebd12f 100644 --- a/sql/old/3.0.9/02254_world.sql +++ b/sql/old/3.0.9/02254_world.sql @@ -5,7 +5,7 @@ INSERT INTO `command` VALUES UPDATE `command` SET `name`="ahbotoption" WHERE `name`="ahbotoptions"; DELETE FROM `command` WHERE `name` LIKE "path%"; DELETE FROM `command` WHERE `name` LIKE "wp%"; -INSERT INTO `command` VALUES +INSERT INTO `command` VALUES ('wp load',2,'Syntax: .wp load $pathid\nLoad pathid number for selected creature. Creature must have no waypoint data.'), ('wp event',2,'Syntax: .wp event $subcommand\nType .path event to see the list of possible subcommands or .help path event $subcommand to see info on subcommands.'), ('wp unload',2,'Syntax: .wp unload\nUnload path for selected creature.'), diff --git a/sql/old/3.0.9/02339_world.sql b/sql/old/3.0.9/02339_world.sql index 106de7326fb..28efdf33ed7 100644 --- a/sql/old/3.0.9/02339_world.sql +++ b/sql/old/3.0.9/02339_world.sql @@ -1,5 +1,5 @@ DELETE FROM `command` WHERE `name` LIKE "ahbotoption %"; -INSERT INTO `command`(`name`,`security`,`help`) VALUES +INSERT INTO `command`(`name`,`security`,`help`) VALUES ('ahbotoption ahexpire', '3', '.Syntax: .ahbotoption ahexpire $ahMapID Expire all auctions started by AHbot.'), ('ahbotoption minitems', '3', '.Syntax: .ahbotoption minitems $ahMapID $parameter Set minimum number of items to be sold in the auctionhouse. If value is 0 then minitems=maxitems. If minitems>maxitems then it will be set equal to maxitems.'), ('ahbotoption maxitems', '3', '.Syntax: .ahbotoption maxitems $ahMapID $parameter Set maximum number of items to be sold in the auctionhouse.'), diff --git a/sql/old/3.0.9/02343_world.sql b/sql/old/3.0.9/02343_world.sql index 4b2b5e68953..7f92fc27bd1 100644 --- a/sql/old/3.0.9/02343_world.sql +++ b/sql/old/3.0.9/02343_world.sql @@ -1,6 +1,6 @@ DELETE FROM `command` WHERE `name` LIKE "ahbotoption %"; DELETE FROM `command` WHERE `name` LIKE "ahbotoptions %"; -INSERT INTO `command`(`name`,`security`,`help`) VALUES +INSERT INTO `command`(`name`,`security`,`help`) VALUES ('ahbotoptions ahexpire', '3', '.Syntax: .ahbotoptions ahexpire $ahMapID Expire all auctions started by AHbot.'), ('ahbotoptions minitems', '3', '.Syntax: .ahbotoptions minitems $ahMapID $parameter Set minimum number of items to be sold in the auctionhouse. If value is 0 then minitems=maxitems. If minitems>maxitems then it will be set equal to maxitems.'), ('ahbotoptions maxitems', '3', '.Syntax: .ahbotoptions maxitems $ahMapID $parameter Set maximum number of items to be sold in the auctionhouse.'), diff --git a/sql/old/3.0.9/02686_world_command.sql b/sql/old/3.0.9/02686_world_command.sql index 4abdd7becf3..c306e4cb548 100644 --- a/sql/old/3.0.9/02686_world_command.sql +++ b/sql/old/3.0.9/02686_world_command.sql @@ -1,3 +1,3 @@ DELETE FROM `command` WHERE `name` IN ('go ticket'); -INSERT INTO `command` VALUES +INSERT INTO `command` VALUES ('go ticket','1','Syntax: .go ticket #ticketid\r\nTeleports the user to the location where $ticketid was created.'); diff --git a/sql/old/3.0.9/02907_mangos_7705_01_world_command.sql b/sql/old/3.0.9/02907_mangos_7705_01_world_command.sql index d1b40e1ba4c..0e34b95d183 100644 --- a/sql/old/3.0.9/02907_mangos_7705_01_world_command.sql +++ b/sql/old/3.0.9/02907_mangos_7705_01_world_command.sql @@ -1,6 +1,6 @@ /*ALTER TABLE db_version CHANGE COLUMN required_7662_02_mangos_spell_bonus_data required_7705_01_mangos_command bit;*/ -DELETE FROM `command` WHERE `name` IN +DELETE FROM `command` WHERE `name` IN ('account lock','account password','chardelete','character customize','character delete','character rename','customize','lockaccount','password','rename'); INSERT INTO `command` VALUES diff --git a/sql/old/3.0.9/02986_TC1_world.sql b/sql/old/3.0.9/02986_TC1_world.sql index fd0d6b310ae..8f96656168c 100644 --- a/sql/old/3.0.9/02986_TC1_world.sql +++ b/sql/old/3.0.9/02986_TC1_world.sql @@ -6,7 +6,7 @@ INSERT INTO `spell_script_target` () VALUES (46589, 1, 30614); INSERT INTO `spell_script_target` () VALUES (45839, 1, 25653); DELETE FROM `creature_template` WHERE entry in (30598, 30614); -INSERT INTO `creature_template` () VALUES +INSERT INTO `creature_template` () VALUES (30598, 0, 4449, 0, 4449, 0, 'Spike Target', '', '', 70, 70, 1, 1, 0, 0, 0, 14, 14, 0, 1, 1, 0, 0, 0, 0, 0, 2600, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 1, 0, 0, 128, ''), (30614, 0, 4449, 0, 4449, 0, 'Spike Target 2', '', '', 70, 70, 1, 1, 0, 0, 0, 14, 14, 0, 1, 1, 0, 0, 0, 0, 0, 2600, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 1, 0, 0, 128, ''); diff --git a/sql/old/3.0.9/03070_world_spell_proc_event.sql b/sql/old/3.0.9/03070_world_spell_proc_event.sql index c382b00429c..c3f88cbba0b 100644 --- a/sql/old/3.0.9/03070_world_spell_proc_event.sql +++ b/sql/old/3.0.9/03070_world_spell_proc_event.sql @@ -1,7 +1,7 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (20166, 32385, 32392, 32387, 32393, 32394, 13046, 13045, 12317, 13048, 13047, -- Enrage 29724, 29725, 29723); -- Sudden Death - + -- Seal of wisdom INSERT INTO `spell_proc_event` VALUES (20166, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 12.000000, 0.000000, 0); diff --git a/sql/old/3.0.9/03257_world_waypoint_data_converter.sql b/sql/old/3.0.9/03257_world_waypoint_data_converter.sql index 7da23dcd962..9a2b099f453 100644 --- a/sql/old/3.0.9/03257_world_waypoint_data_converter.sql +++ b/sql/old/3.0.9/03257_world_waypoint_data_converter.sql @@ -1,6 +1,6 @@ ALTER TABLE creature_addon ADD INDEX ( `path_id` ); ALTER TABLE waypoint_data ADD INDEX ( `id` ); - + ALTER TABLE waypoint_data ADD COLUMN id_old int(10) unsigned NOT NULL default '0' COMMENT 'Creature GUID' AFTER wpguid; UPDATE waypoint_data SET id_old=id; diff --git a/sql/old/3.0.9/03320_worldspell_enchant_proc_data.sql b/sql/old/3.0.9/03320_worldspell_enchant_proc_data.sql index 7f5df5edf14..01598fde244 100644 --- a/sql/old/3.0.9/03320_worldspell_enchant_proc_data.sql +++ b/sql/old/3.0.9/03320_worldspell_enchant_proc_data.sql @@ -1,7 +1,7 @@ CREATE TABLE `spell_enchant_proc_data` ( `entry` INT(10) UNSIGNED NOT NULL, `customChance` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `PPMChance` FLOAT UNSIGNED NOT NULL DEFAULT '0', + `PPMChance` FLOAT UNSIGNED NOT NULL DEFAULT '0', `procEx` FLOAT UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MYISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data'; diff --git a/sql/old/3.0.9/03392_world_spell_proc_event.sql b/sql/old/3.0.9/03392_world_spell_proc_event.sql index d0965c1a7ab..4227cdd9a06 100644 --- a/sql/old/3.0.9/03392_world_spell_proc_event.sql +++ b/sql/old/3.0.9/03392_world_spell_proc_event.sql @@ -1,6 +1,6 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN +DELETE FROM `spell_proc_event` WHERE `entry` IN (27521, 55381, 62459, 60176, 60529, 60717, 62147, 57907, 51528, 51529, 51530, 51531, 51532); -INSERT INTO `spell_proc_event` +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -- malestorm weapon diff --git a/sql/old/3.0.9/03609_mangos_7902_01_world_pool_creature.sql b/sql/old/3.0.9/03609_mangos_7902_01_world_pool_creature.sql index ec1d63a48b0..db680c23985 100644 --- a/sql/old/3.0.9/03609_mangos_7902_01_world_pool_creature.sql +++ b/sql/old/3.0.9/03609_mangos_7902_01_world_pool_creature.sql @@ -1,4 +1,4 @@ /*ALTER TABLE db_version CHANGE COLUMN required_7896_01_mangos_creature_template required_7902_01_mangos_pool_creature bit;*/ -ALTER TABLE `pool_creature` +ALTER TABLE `pool_creature` ADD INDEX `idx_guid`(`guid`); diff --git a/sql/old/3.0.9/03609_mangos_7902_02_world_pool_gameobject.sql b/sql/old/3.0.9/03609_mangos_7902_02_world_pool_gameobject.sql index 3935a14bc23..265000f8dae 100644 --- a/sql/old/3.0.9/03609_mangos_7902_02_world_pool_gameobject.sql +++ b/sql/old/3.0.9/03609_mangos_7902_02_world_pool_gameobject.sql @@ -1,4 +1,4 @@ /*ALTER TABLE db_version CHANGE COLUMN required_7902_01_mangos_pool_creature required_7902_02_mangos_pool_gameobject bit;*/ -ALTER TABLE `pool_gameobject` +ALTER TABLE `pool_gameobject` ADD INDEX `idx_guid`(`guid`); diff --git a/sql/old/3.0.9/03810_world_spell_bonus_data.sql b/sql/old/3.0.9/03810_world_spell_bonus_data.sql index 1803687d6a4..3fd41e02223 100644 --- a/sql/old/3.0.9/03810_world_spell_bonus_data.sql +++ b/sql/old/3.0.9/03810_world_spell_bonus_data.sql @@ -29,14 +29,14 @@ UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=27214; UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=47822; UPDATE `spell_bonus_data` SET `dot_bonus` = '0.0949' WHERE `entry`=1949; UPDATE `spell_bonus_data` SET `ap_bonus` = '0.025' WHERE `entry`=31803; -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42208; -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42209; -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42210; -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42211; -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42212; -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42213; -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42198; -UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42937; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42208; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42209; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42210; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42211; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42212; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42213; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42198; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42937; UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42938; UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2861' WHERE `entry` =49821; UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2861' WHERE `entry` =53022; @@ -56,7 +56,7 @@ UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=33074; UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=48821; UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `entry`=33763; DELETE FROM `spell_bonus_data` WHERE `entry` IN (53742,61391,47897,50796,50590,58597,974,47757,52986,52987,52988); -INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES ('53742', '0.013', '0', '0.025', 'Paladin - Blood Corruption'), ('61391', '0.193', '0', '0', 'Druid - Typhoon'), ('47897', '0.1064', '0.0667', '0', 'Warlock - Shadowflame'), @@ -80,7 +80,7 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` -- by nesocip DELETE FROM `spell_bonus_data` WHERE `entry` IN (48721, 55078, 52212, 47632, 55095, 49184, 45477, 50536, 51373, 51374, 51375); -INSERT INTO spell_bonus_data( entry, ap_bonus, comments ) VALUES +INSERT INTO spell_bonus_data( entry, ap_bonus, comments ) VALUES ('48721', '0.04', 'DK - Blood Boil'), ('55078', '0.055', 'DK - Blood Plague'), ('52212', '0.0475', 'DK - Death and Decay'), diff --git a/sql/old/3.0.9/03851_world_spell.sql b/sql/old/3.0.9/03851_world_spell.sql index ed10e84808c..2b843c5bdd4 100644 --- a/sql/old/3.0.9/03851_world_spell.sql +++ b/sql/old/3.0.9/03851_world_spell.sql @@ -1,6 +1,6 @@ UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `entry`=33763; DELETE FROM `spell_script_target` WHERE `entry` IN (48714,57806); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES ('48714', '2', '27237'), ('48714', '2', '27235'), ('48714', '2', '27234'), diff --git a/sql/old/3.0.9/03877_world_spell_script_target.sql b/sql/old/3.0.9/03877_world_spell_script_target.sql index 57392c547d3..343d9475cf9 100644 --- a/sql/old/3.0.9/03877_world_spell_script_target.sql +++ b/sql/old/3.0.9/03877_world_spell_script_target.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_script_target` WHERE `entry` IN (48743); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES ('48743', '1', '26125'); diff --git a/sql/old/3.0.9/03886_world_script_nexus.sql b/sql/old/3.0.9/03886_world_script_nexus.sql index eba67418eef..a2413fc0116 100644 --- a/sql/old/3.0.9/03886_world_script_nexus.sql +++ b/sql/old/3.0.9/03886_world_script_nexus.sql @@ -18,7 +18,7 @@ UPDATE `instance_template` SET `script`='instance_nexus' WHERE `map`=576; UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE entry IN (26796, 26798, 26929, 26928, 26930); DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (26796, 26798, 26929, 26928, 26930); -INSERT INTO `creature_ai_scripts` VALUES +INSERT INTO `creature_ai_scripts` VALUES -- Commander Stoutbeard ( 2679600, 26796, 4, 0, 100, 4, 0, 0, 0, 0, 28, 0, 47543, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - crystal prison remove'), ( 2679601, 26796, 4, 0, 100, 4, 0, 0, 0, 0, 11, 31403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Commander Stoutbeard - cast battle shout'), |