diff options
| author | teacher <none@none> | 2010-06-05 18:21:47 +0200 |
|---|---|---|
| committer | teacher <none@none> | 2010-06-05 18:21:47 +0200 |
| commit | 207dccc13de332674a53af5088daaa0ad58c3a3a (patch) | |
| tree | 130dc2a4ace1f4ecda8f4dd32e444e08274cc59a | |
| parent | 095914eb59ee6756b582fe07b1e332b1b354f243 (diff) | |
Added conditions table to world.sql.
Minor sql cleanup.
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/8374_world_spell_proc_event.sql | 1 | ||||
| -rw-r--r-- | sql/updates/8397_world_command.sql | 7 | ||||
| -rw-r--r-- | sql/world.sql | 27 |
3 files changed, 31 insertions, 4 deletions
diff --git a/sql/updates/8374_world_spell_proc_event.sql b/sql/updates/8374_world_spell_proc_event.sql index 5882a028546..2ee60a1b9af 100644 --- a/sql/updates/8374_world_spell_proc_event.sql +++ b/sql/updates/8374_world_spell_proc_event.sql @@ -1,4 +1,3 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (67667); INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 67667, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 45); -- Item - Coliseum Healer Trinket 5men - diff --git a/sql/updates/8397_world_command.sql b/sql/updates/8397_world_command.sql index 873ccd0e883..f90f37e7eab 100644 --- a/sql/updates/8397_world_command.sql +++ b/sql/updates/8397_world_command.sql @@ -1,3 +1,4 @@ -INSERT INTO `command` (name, security, help) VALUES ('instance open', 3, 'Syntax: .instance open mapid [normal|heroic|10normal|10heroic|25normal|25heroic]'); -INSERT INTO `command` (name, security, help) VALUES ('instance close', 3, 'Syntax: .instance close mapid [normal|heroic|10normal|10heroic|25normal|25heroic]'); - +DELETE FROM `command` WHERE `name` IN ('instance open','instance close'); +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('instance open', 3, 'Syntax: .instance open mapid [normal|heroic|10normal|10heroic|25normal|25heroic]'), +('instance close', 3, 'Syntax: .instance close mapid [normal|heroic|10normal|10heroic|25normal|25heroic]'); diff --git a/sql/world.sql b/sql/world.sql index 06fd5fa0111..692927a2fdf 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -705,6 +705,33 @@ INSERT INTO `command` VALUES /*!40000 ALTER TABLE `command` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for `conditions` +-- + +CREATE TABLE `conditions` ( + `SourceTypeOrReferenceId` mediumint(8) NOT NULL DEFAULT '0', + `SourceGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', + `SourceEntry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ElseGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ConditionTypeOrReference` mediumint(8) NOT NULL DEFAULT '0', + `ConditionValue1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ConditionValue2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ConditionValue3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ErrorTextId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Condition System'; + +-- +-- Dumping data for table `creature` +-- + +LOCK TABLES `conditions` WRITE; +/*!40000 ALTER TABLE `conditions` DISABLE KEYS */; +/*!40000 ALTER TABLE `conditions` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `creature` -- |