aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2015_06_14_00_world.sql2
-rw-r--r--sql/updates/world/2015_06_21_00_world.sql37
-rw-r--r--sql/updates/world/2015_06_23_00_world_335.sql176
-rw-r--r--sql/updates/world/2015_06_23_01_world.sql3
-rw-r--r--sql/updates/world/2015_06_23_02_world.sql3
5 files changed, 221 insertions, 0 deletions
diff --git a/sql/updates/world/2015_06_14_00_world.sql b/sql/updates/world/2015_06_14_00_world.sql
new file mode 100644
index 00000000000..07a6dd72f35
--- /dev/null
+++ b/sql/updates/world/2015_06_14_00_world.sql
@@ -0,0 +1,2 @@
+--
+UPDATE `quest_template` SET `RequestItemsText`="Return to me after you have helped capture each fort!" WHERE `Id`=13411;
diff --git a/sql/updates/world/2015_06_21_00_world.sql b/sql/updates/world/2015_06_21_00_world.sql
new file mode 100644
index 00000000000..709f78fca92
--- /dev/null
+++ b/sql/updates/world/2015_06_21_00_world.sql
@@ -0,0 +1,37 @@
+DELETE FROM `creature_formations` WHERE `leaderGUID`=203571;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(203571, 203571, 0, 0, 1),
+(203571, 203559, 2, 90, 2);
+
+-- Pathing for Gundrak Savage Entry: 29235 'TDB FORMAT'
+SET @NPC := 203571;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6332.113,`position_y`=-4009.055,`position_z`=457.2701 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,6332.113,-4009.055,457.2701,0,0,0,0,100,0), -- 13:57:18
+(@PATH,2,6354.536,-4030.933,457.2702,0,0,0,0,100,0), -- 13:57:30
+(@PATH,3,6372.311,-4048.536,457.2703,0,0,0,0,100,0), -- 13:57:40
+(@PATH,4,6386.682,-4062.151,457.2303,0,0,0,0,100,0), -- 13:57:49
+(@PATH,5,6406.021,-4081.781,457.2282,0,0,0,0,100,0), -- 13:57:59
+(@PATH,6,6414.187,-4095.374,457.6551,0,0,0,0,100,0), -- 13:58:06
+(@PATH,7,6400.186,-4088.764,457.0648,0,0,0,0,100,0), -- 13:58:12
+(@PATH,8,6383.09,-4071.84,457.2628,0,0,0,0,100,0), -- 13:58:21
+(@PATH,9,6371.94,-4060.654,457.0837,0,0,0,0,100,0), -- 13:58:29
+(@PATH,10,6361.409,-4050.251,457.4023,0,0,0,0,100,0), -- 13:58:35
+(@PATH,11,6346.225,-4035.04,457.3448,0,0,0,0,100,0), -- 13:58:43
+(@PATH,12,6325.968,-4014.103,457.2808,0,0,0,0,100,0), -- 13:58:54
+(@PATH,13,6306.042,-3994.58,457.2701,0,0,0,0,100,0), -- 13:59:05
+(@PATH,14,6264.928,-3950.012,457.2701,0,0,0,0,100,0), -- 13:59:22
+(@PATH,15,6262.15,-3946.607,457.2701,0,0,0,0,100,0), -- 13:59:32
+(@PATH,16,6241.434,-3927.12,457.2723,0,0,0,0,100,0), -- 13:59:44
+(@PATH,17,6216.531,-3899.659,458.7351,0,0,0,0,100,0), -- 13:59:54
+(@PATH,18,6221.433,-3900.517,457.7585,0,0,0,0,100,0), -- 14:00:00
+(@PATH,19,6228.114,-3903.022,457.1964,0,0,0,0,100,0), -- 14:00:05
+(@PATH,20,6245.55,-3922.648,457.2741,0,0,0,0,100,0), -- 14:00:16
+(@PATH,21,6265.786,-3942.583,457.2701,0,0,0,0,100,0), -- 14:00:26
+(@PATH,22,6283.895,-3961.789,457.2701,0,0,0,0,100,0), -- 14:00:37
+(@PATH,23,6311.935,-3990.581,457.2701,0,0,0,0,100,0); -- 14:00:53
+-- 0x1C393047601C8CC000000D000079A937 .go 6332.113 -4009.055 457.2701
diff --git a/sql/updates/world/2015_06_23_00_world_335.sql b/sql/updates/world/2015_06_23_00_world_335.sql
new file mode 100644
index 00000000000..fd7132491b0
--- /dev/null
+++ b/sql/updates/world/2015_06_23_00_world_335.sql
@@ -0,0 +1,176 @@
+-- areatrigger_teleport
+ALTER TABLE `areatrigger_teleport`
+CHANGE `id` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `name` `Name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
+
+-- battleground_template
+ALTER TABLE `battleground_template`
+CHANGE `id` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';
+
+-- creature_equip_template
+ALTER TABLE `creature_equip_template`
+CHANGE `entry` `CreatureID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `id` `ID` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
+CHANGE `itemEntry1` `ItemID1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `itemEntry2` `ItemID2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `itemEntry3` `ItemID3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';
+
+-- creature_formations
+ALTER TABLE `creature_formations`
+CHANGE `leaderGUID` `leaderGUID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `memberGUID` `memberGUID` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+
+-- creature_model_info
+ALTER TABLE `creature_model_info`
+CHANGE `modelid` `DisplayID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `bounding_radius` `BoundingRadius` FLOAT NOT NULL DEFAULT '0',
+CHANGE `combat_reach` `CombatReach` FLOAT NOT NULL DEFAULT '0',
+CHANGE `gender` `Gender` TINYINT(3) UNSIGNED NOT NULL DEFAULT '2',
+CHANGE `modelid_other_gender` `DisplayID_Other_Gender` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';
+
+-- gameobject_template
+ALTER TABLE `gameobject_template`
+CHANGE `data0` `Data0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data1` `Data1` INT(11) NOT NULL DEFAULT '0',
+CHANGE `data2` `Data2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data3` `Data3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data4` `Data4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data5` `Data5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data6` `Data6` INT(11) NOT NULL DEFAULT '0',
+CHANGE `data7` `Data7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data8` `Data8` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data9` `Data9` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data10` `Data10` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data11` `Data11` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data12` `Data12` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data13` `Data13` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data14` `Data14` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data15` `Data15` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data16` `Data16` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data17` `Data17` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data18` `Data18` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data19` `Data19` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data20` `Data20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data21` `Data21` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data22` `Data22` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data23` `Data23` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+
+-- lfg_entrances -> lfg_dungeon_template
+RENAME TABLE `lfg_entrances` TO `lfg_dungeon_template`;
+
+-- npc_text
+ALTER TABLE `npc_text`
+CHANGE `prob0` `Probability0` FLOAT NOT NULL DEFAULT '0',
+CHANGE `prob1` `Probability1` FLOAT NOT NULL DEFAULT '0',
+CHANGE `prob2` `Probability2` FLOAT NOT NULL DEFAULT '0',
+CHANGE `prob3` `Probability3` FLOAT NOT NULL DEFAULT '0',
+CHANGE `prob4` `Probability4` FLOAT NOT NULL DEFAULT '0',
+CHANGE `prob5` `Probability5` FLOAT NOT NULL DEFAULT '0',
+CHANGE `prob6` `Probability6` FLOAT NOT NULL DEFAULT '0',
+CHANGE `prob7` `Probability7` FLOAT NOT NULL DEFAULT '0';
+
+-- npc_trainer
+ALTER TABLE `npc_trainer`
+CHANGE `entry` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `spell` `SpellID` MEDIUMINT(8) NOT NULL DEFAULT '0',
+CHANGE `spellcost` `MoneyCost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `reqskill` `ReqSkillLine` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `reqskillvalue` `ReqSkillRank` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `reqlevel` `ReqLevel` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
+
+-- page_text
+ALTER TABLE `page_text`
+CHANGE `entry` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `text` `Text` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
+CHANGE `next_page` `NextPageID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `VerifiedBuild` `VerifiedBuild` SMALLINT(5) NULL DEFAULT '0';
+
+-- player_xp_for_level
+ALTER TABLE `player_xp_for_level`
+CHANGE `lvl` `Level` TINYINT(3) UNSIGNED NOT NULL,
+CHANGE `xp_for_next_level` `Experience` INT(10) UNSIGNED NOT NULL;
+
+-- points_of_interest
+ALTER TABLE `points_of_interest`
+CHANGE `entry` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `x` `PositionX` FLOAT NOT NULL DEFAULT '0',
+CHANGE `y` `PositionY` FLOAT NOT NULL DEFAULT '0',
+CHANGE `icon` `Icon` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `flags` `Flags` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `data` `Data` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `icon_name` `Name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
+
+-- quest_poi
+ALTER TABLE `quest_poi`
+CHANGE `questId` `QuestID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `objIndex` `ObjectiveIndex` INT(11) NOT NULL DEFAULT '0',
+CHANGE `mapid` `MapID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `FloorId` `Floor` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `unk3` `Priority` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `unk4` `Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+
+-- quest_poi_points
+ALTER TABLE `quest_poi_points`
+CHANGE `questId` `QuestID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `id` `Idx1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `idx` `Idx2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `x` `X` INT(11) NOT NULL DEFAULT '0',
+CHANGE `y` `Y` INT(11) NOT NULL DEFAULT '0';
+
+-- quest_template
+ALTER TABLE `quest_template`
+CHANGE `Id` `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `Level` `QuestLevel` smallint(3) NOT NULL DEFAULT '1',
+CHANGE `ZoneOrSort` `QuestSortID` smallint(6) NOT NULL DEFAULT '0',
+CHANGE `Type` `QuestType` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `SuggestedPlayers` `SuggestedGroupNum` tinyint(3) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardTitleId` `RewardTitle` tinyint(3) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardItemId1` `RewardItem1` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardItemId2` `RewardItem2` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardItemId3` `RewardItem3` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardItemId4` `RewardItem4` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardItemCount1` `RewardAmount1` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardItemCount2` `RewardAmount2` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardItemCount3` `RewardAmount3` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardItemCount4` `RewardAmount4` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemId1` `RewardChoiceItemID1` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemId2` `RewardChoiceItemID2` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemId3` `RewardChoiceItemID3` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemId4` `RewardChoiceItemID4` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemId5` `RewardChoiceItemID5` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemId6` `RewardChoiceItemID6` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemCount1` `RewardChoiceItemQuantity1` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemCount2` `RewardChoiceItemQuantity2` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemCount3` `RewardChoiceItemQuantity3` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemCount4` `RewardChoiceItemQuantity4` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemCount5` `RewardChoiceItemQuantity5` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardChoiceItemCount6` `RewardChoiceItemQuantity6` smallint(5) unsigned NOT NULL DEFAULT '0',
+CHANGE `RewardFactionId1` `RewardFactionID1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
+CHANGE `RewardFactionId2` `RewardFactionID2` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
+CHANGE `RewardFactionId3` `RewardFactionID3` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
+CHANGE `RewardFactionId4` `RewardFactionID4` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
+CHANGE `RewardFactionId5` `RewardFactionID5` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
+CHANGE `RewardFactionValueId1` `RewardFactionValue1` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueId2` `RewardFactionValue2` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueId3` `RewardFactionValue3` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueId4` `RewardFactionValue4` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueId5` `RewardFactionValue5` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueIdOverride1` `RewardFactionOverride1` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueIdOverride2` `RewardFactionOverride2` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueIdOverride3` `RewardFactionOverride3` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueIdOverride4` `RewardFactionOverride4` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `RewardFactionValueIdOverride5` `RewardFactionOverride5` mediumint(8) NOT NULL DEFAULT '0',
+CHANGE `Title` `LogTitle` text,
+CHANGE `Objectives` `LogDescription` text,
+CHANGE `Details` `QuestDescription` text,
+CHANGE `CompletedText` `QuestCompletionLog` text;
+
+-- spell_target_position
+ALTER TABLE `spell_target_position`
+CHANGE `id` `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Identifier',
+CHANGE `effIndex` `EffectIndex` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `target_map` `MapID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `target_position_x` `PositionX` FLOAT NOT NULL DEFAULT '0',
+CHANGE `target_position_y` `PositionY` FLOAT NOT NULL DEFAULT '0',
+CHANGE `target_position_z` `PositionZ` FLOAT NOT NULL DEFAULT '0',
+CHANGE `target_orientation` `Orientation` FLOAT NOT NULL DEFAULT '0';
diff --git a/sql/updates/world/2015_06_23_01_world.sql b/sql/updates/world/2015_06_23_01_world.sql
new file mode 100644
index 00000000000..2e42d16cd7b
--- /dev/null
+++ b/sql/updates/world/2015_06_23_01_world.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=45724;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(45724, 'spell_midsummer_braziers_hit');
diff --git a/sql/updates/world/2015_06_23_02_world.sql b/sql/updates/world/2015_06_23_02_world.sql
new file mode 100644
index 00000000000..adcbb40f7d1
--- /dev/null
+++ b/sql/updates/world/2015_06_23_02_world.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `quest_template` SET `RequiredRaces`=1101 WHERE `ID`=11580;
+UPDATE `quest_template` SET `RequiredRaces`=690 WHERE `ID`=11581;