diff options
Diffstat (limited to 'sql')
12 files changed, 83 insertions, 26 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 88dc144b418..03d6572bff3 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -562,7 +562,6 @@ INSERT INTO `command` VALUES ('npc move',2,'Syntax: .npc move [#creature_guid]\r\n\r\nMove the targeted creature spawn point to your coordinates.'), ('npc playemote',3,'Syntax: .npc playemote #emoteid\r\n\r\nMake the selected creature emote with an emote of id #emoteid.'), ('npc say',1,'Syntax: .npc say $message\nMake selected creature say specified message.'), -('npc set deathstate',2,'Syntax: .npc set deathstate on/off\r\n\r\nSet default death state (dead/alive) for npc at spawn.'), ('npc set link',2,'Syntax: .npc set link $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.'), ('npc set model',2,'Syntax: .npc set model #displayid\r\n\r\nChange the model id of the selected creature to #displayid.'), ('npc set movetype',2,'Syntax: .npc set movetype [#creature_guid] stay/random/way [NODEL]\r\n\r\nSet for creature pointed by #creature_guid (or selected if #creature_guid not provided) movement type and move it to respawn position (if creature alive). Any existing waypoints for creature will be removed from the database if you do not use NODEL. If the creature is dead then movement type will applied at creature respawn.\r\nMake sure you use NODEL, if you want to keep the waypoints.'), @@ -822,7 +821,6 @@ CREATE TABLE `creature` ( `currentwaypoint` mediumint(8) unsigned NOT NULL DEFAULT '0', `curhealth` int(10) unsigned NOT NULL DEFAULT '1', `curmana` int(10) unsigned NOT NULL DEFAULT '0', - `DeathState` tinyint(3) unsigned NOT NULL DEFAULT '0', `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', `npcflag` int(10) unsigned NOT NULL DEFAULT '0', `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', @@ -27886,30 +27884,6 @@ LOCK TABLES `vehicle_accessory` WRITE; UNLOCK TABLES; -- --- Table structure for table `vehicle_scaling_info` --- - -DROP TABLE IF EXISTS `vehicle_scaling_info`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `vehicle_scaling_info` ( - `entry` mediumint(8) unsigned NOT NULL default '0', - `baseItemLevel` float NOT NULL default '0', - `scalingFactor` float NOT NULL default '0', - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `vehicle_scaling_info` --- - -LOCK TABLES `vehicle_scaling_info` WRITE; -/*!40000 ALTER TABLE `vehicle_scaling_info` DISABLE KEYS */; -/*!40000 ALTER TABLE `vehicle_scaling_info` ENABLE KEYS */; -UNLOCK TABLES; - --- -- Table structure for table `version` -- diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 45c971dd970..90a0522bef4 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1927,6 +1927,7 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`, /* SPELLS */ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -- generic +( 66218, 'spell_gen_launch'), ( 39228, 'spell_gen_absorb0_hitlimit1'), ( 60218, 'spell_gen_absorb0_hitlimit1'), ( 6962, 'spell_gen_pet_summoned'), @@ -1987,6 +1988,12 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 12749, 'spell_gen_allow_cast_from_item_only'), ( 13258, 'spell_gen_allow_cast_from_item_only'), ( 13166, 'spell_gen_allow_cast_from_item_only'), + (65266, 'spell_gen_vehicle_scaling'), + (65635, 'spell_gen_vehicle_scaling'), + (65636, 'spell_gen_vehicle_scaling'), + (66666, 'spell_gen_vehicle_scaling'), + (66667, 'spell_gen_vehicle_scaling'), + (66668, 'spell_gen_vehicle_scaling'), -- instances -- Black Temple ( 41475, 'spell_boss_lady_malande_shield'), diff --git a/sql/updates/world/2011_06_26_07_world_spell_script_names.sql b/sql/updates/world/2011_06_26_07_world_spell_script_names.sql new file mode 100644 index 00000000000..c392a9f5ada --- /dev/null +++ b/sql/updates/world/2011_06_26_07_world_spell_script_names.sql @@ -0,0 +1,2 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=66218; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (66218,'spell_gen_launch');
\ No newline at end of file diff --git a/sql/updates/world/2011_06_27_00_world_sai.sql b/sql/updates/world/2011_06_27_00_world_sai.sql new file mode 100644 index 00000000000..35973836e88 --- /dev/null +++ b/sql/updates/world/2011_06_27_00_world_sai.sql @@ -0,0 +1,13 @@ +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (33354,33355,33430,33431,33525,33526,33527,33528); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (33354,33355,33430,33431,33525,33526,33527,33528) AND `event_type`=6; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) +VALUES +(33354,0,0,0,6,0,100,0,0,0,0,0,34,2,1,0,0,0,0,19,32906,0,0,0,0,0,0,'Corrupted Servitor - on death set instance data for achievement Con-Speed-Atory'), +(33355,0,0,0,6,0,100,0,0,0,0,0,34,2,1,0,0,0,0,19,32906,0,0,0,0,0,0,'Misguided Nymph - on death set instance data for achievement Con-Speed-Atory'), +(33430,0,0,0,6,0,100,0,0,0,0,0,34,2,1,0,0,0,0,19,32906,0,0,0,0,0,0,'Guardian Lasher - on death set instance data for achievement Con-Speed-Atory'), +(33431,0,0,0,6,0,100,0,0,0,0,0,34,2,1,0,0,0,0,19,32906,0,0,0,0,0,0,'Forest Swarmer - on death set instance data for achievement Con-Speed-Atory'), +(33525,0,0,0,6,0,100,0,0,0,0,0,34,2,1,0,0,0,0,19,32906,0,0,0,0,0,0,'Mangrove Ent - on death set instance data for achievement Con-Speed-Atory'), +(33526,0,0,0,6,0,100,0,0,0,0,0,34,2,1,0,0,0,0,19,32906,0,0,0,0,0,0,'Ironroot Lasher - on death set instance data for achievement Con-Speed-Atory'), +(33527,0,0,0,6,0,100,0,0,0,0,0,34,2,1,0,0,0,0,19,32906,0,0,0,0,0,0,'Natures\'s Blade - on death set instance data for achievement Con-Speed-Atory'), +(33528,0,0,0,6,0,100,0,0,0,0,0,34,2,1,0,0,0,0,19,32906,0,0,0,0,0,0,'Guardian of Life - on death set instance data for achievement Con-Speed-Atory'); diff --git a/sql/updates/world/2011_06_27_01_world_spell_script_names.sql b/sql/updates/world/2011_06_27_01_world_spell_script_names.sql new file mode 100644 index 00000000000..9f0f34526c8 --- /dev/null +++ b/sql/updates/world/2011_06_27_01_world_spell_script_names.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN(65266,65635,65636,66666,66667,66668); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(65266,'spell_gen_vehicle_scaling'), +(65635,'spell_gen_vehicle_scaling'), +(65636,'spell_gen_vehicle_scaling'), +(66666,'spell_gen_vehicle_scaling'), +(66667,'spell_gen_vehicle_scaling'), +(66668,'spell_gen_vehicle_scaling'); diff --git a/sql/updates/world/2011_06_27_02_world_vehicle_scaling_info.sql b/sql/updates/world/2011_06_27_02_world_vehicle_scaling_info.sql new file mode 100644 index 00000000000..748b0f7c07d --- /dev/null +++ b/sql/updates/world/2011_06_27_02_world_vehicle_scaling_info.sql @@ -0,0 +1 @@ +DROP TABLE `vehicle_scaling_info`; diff --git a/sql/updates/world/2011_06_27_03_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_27_03_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..58623a56ad1 --- /dev/null +++ b/sql/updates/world/2011_06_27_03_world_achievement_criteria_data.sql @@ -0,0 +1,21 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (10447,10448,10449,10459,10460,10461) AND `type` IN (11,12,18); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) +VALUES +(10447,11,0,0,'achievement_knock_on_wood'), +(10447,12,0,0,''), +(10448,11,0,0,'achievement_knock_knock_on_wood'), +(10448,12,0,0,''), +(10449,11,0,0,'achievement_knock_knock_knock_on_wood'), +(10449,12,0,0,''), +(10459,11,0,0,'achievement_knock_on_wood'), +(10459,12,1,0,''), +(10460,11,0,0,'achievement_knock_knock_on_wood'), +(10460,12,1,0,''), +(10461,11,0,0,'achievement_knock_knock_knock_on_wood'), +(10461,12,1,0,''); + +UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (33354,33355,33430,33431,33525,33526,33527,33528); + + + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (33354,33355,33430,33431,33525,33526,33527,33528); diff --git a/sql/updates/world/2011_06_27_04_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_27_04_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..0b2f5f36218 --- /dev/null +++ b/sql/updates/world/2011_06_27_04_world_achievement_criteria_data.sql @@ -0,0 +1,11 @@ +DELETE FROM `disables` WHERE `entry` IN (10088,10089,10418,10419,10420,10421); + +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (10088,10089,10418,10419,10420,10421) AND `type`=11; +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) +VALUES +(10088,5,58501,0,''), +(10089,5,58501,0,''), +(10418,5,58501,0,''), +(10419,5,58501,0,''), +(10420,5,58501,0,''), +(10421,5,58501,0,''); diff --git a/sql/updates/world/2011_06_27_05_world_areatrigger_teleport.sql b/sql/updates/world/2011_06_27_05_world_areatrigger_teleport.sql new file mode 100644 index 00000000000..01bb958320e --- /dev/null +++ b/sql/updates/world/2011_06_27_05_world_areatrigger_teleport.sql @@ -0,0 +1 @@ +UPDATE `areatrigger_teleport` SET `target_orientation`= 3.30496 WHERE `id`=922; diff --git a/sql/updates/world/2011_06_27_06_world_command.sql b/sql/updates/world/2011_06_27_06_world_command.sql new file mode 100644 index 00000000000..7b3f1e5765f --- /dev/null +++ b/sql/updates/world/2011_06_27_06_world_command.sql @@ -0,0 +1 @@ +DELETE FROM `command` WHERE `name`= 'npc set deathstate'; diff --git a/sql/updates/world/2011_06_27_06_world_creature.sql b/sql/updates/world/2011_06_27_06_world_creature.sql new file mode 100644 index 00000000000..e4e6d3c98ce --- /dev/null +++ b/sql/updates/world/2011_06_27_06_world_creature.sql @@ -0,0 +1,4 @@ +-- Drop DeathState column +ALTER TABLE `creature` DROP COLUMN `DeathState`; +-- Remove spawns for Kologarn (not boss) and Focused Eyebeam (summoned). +DELETE FROM `creature` WHERE `id` IN (34297,33632,33802); diff --git a/sql/updates/world/2011_06_27_07_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_27_07_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..745bf6a8618 --- /dev/null +++ b/sql/updates/world/2011_06_27_07_world_achievement_criteria_data.sql @@ -0,0 +1,14 @@ +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN (7709,7710,7711,7712,7713,7714,7715,7716,7718,7719); + +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (7709,7710,7711,7712,7713,7714,7715,7716,7718,7719); +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(7709,6,4575,0, ''), -- killed player in Wintergrasp Fortress +(7710,6,4612,0, ''), -- killed player in Eastspark Workshop +(7711,6,4539,0, ''), -- killed player in The Broken Temple +(7712,6,4538,0, ''), -- killed player in The Sunken Ring +(7713,6,4611,0, ''), -- killed player in Westspark Workshop +(7714,6,4581,0, ''), -- killed player in Flamewatch Tower +(7715,6,4583,0, ''), -- killed player in Shadowsight Tower +(7716,6,4582,0, ''), -- killed player in Winter's Edge Tower +(7718,6,4584,0, ''), -- killed player in The Cauldron of Flames +(7719,6,4589,0, ''); -- killed player in The Chilled Quagmire |