diff options
| -rw-r--r-- | sql/base/world_database.sql | 12 | ||||
| -rw-r--r-- | sql/updates/8915_world_trinity_string.sql | 3 | ||||
| -rw-r--r-- | sql/updates/8920_world_spell_dbc.sql | 4 | ||||
| -rw-r--r-- | sql/updates/8920_world_spell_linked_spell.sql | 4 |
4 files changed, 19 insertions, 4 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index a0c566f550c..dcb731259a3 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -712,6 +712,9 @@ UNLOCK TABLES; -- Table structure for `conditions` -- +DROP TABLE IF EXISTS `conditions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `conditions` ( `SourceTypeOrReferenceId` mediumint(8) NOT NULL DEFAULT '0', `SourceGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -725,9 +728,10 @@ CREATE TABLE `conditions` ( `Comment` varchar(255) DEFAULT NULL, PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Condition System'; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Dumping data for table `creature` +-- Dumping data for table `conditions` -- LOCK TABLES `conditions` WRITE; @@ -5340,7 +5344,8 @@ INSERT INTO `spell_dbc` (`Id`,`Dispel`,`Mechanic`,`Attributes`,`AttributesEx`,`A (25359, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1, 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, 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, 'Item 21293 spellid_2 serverside spell'), (40145, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1, 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, 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, 'Quest 11000 RewSpellCast serverside spell'), (45767, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1, 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, 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, 'Quest 11670 RewSpellCast serverside spell'), -(71098, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1, 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, 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, 'Quest 24451 RewSpellCast serverside spell'); +(71098, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1, 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, 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, 'Quest 24451 RewSpellCast serverside spell'), +(70878, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1, 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, 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, 'Creature 40160 creature_addon serverside spell'); /*!40000 ALTER TABLE `spell_dbc` ENABLE KEYS */; UNLOCK TABLES; @@ -6194,7 +6199,8 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment -- Item ( 69381, 72588, 1, 'Drums of the Wild'), ( 69378, 72586, 1, 'Drums of the Forgotten Kings'), -( 69377, 72590, 1, 'Runescroll of Fortitude'); +( 69377, 72590, 1, 'Runescroll of Fortitude'), +( 50141, 50001, 0, 'Blood Oath to Blood Oath Aura'); /*!40000 ALTER TABLE `spell_linked_spell` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/8915_world_trinity_string.sql b/sql/updates/8915_world_trinity_string.sql index 49676b0870a..3c882c98895 100644 --- a/sql/updates/8915_world_trinity_string.sql +++ b/sql/updates/8915_world_trinity_string.sql @@ -1,4 +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 -INSERT INTO `trinity_string` VALUES (62, 'One on more parameters have incorrect values', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); +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 new file mode 100644 index 00000000000..a400139824a --- /dev/null +++ b/sql/updates/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/8920_world_spell_linked_spell.sql b/sql/updates/8920_world_spell_linked_spell.sql new file mode 100644 index 00000000000..2b6a4bcf9ed --- /dev/null +++ b/sql/updates/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'); |
