diff options
| -rw-r--r-- | sql/updates/2057_world.sql | 4 | ||||
| -rw-r--r-- | sql/updates/2064_world.sql | 8 | ||||
| -rw-r--r-- | sql/updates/2080_mangos_7503_01_world_command.sql (renamed from sql/updates/7503_01_mangos_command.sql) | 10 |
3 files changed, 9 insertions, 13 deletions
diff --git a/sql/updates/2057_world.sql b/sql/updates/2057_world.sql index 8c7cc4cd3f0..0be46a18121 100644 --- a/sql/updates/2057_world.sql +++ b/sql/updates/2057_world.sql @@ -1,5 +1,5 @@ -delete from spell_bonus_data where entry in (15290, 39373, 33778, 379, 38395, 40972, 22845, 33504, 34299); -insert into spell_bonus_data () VALUES +DELETE FROM `spell_bonus_data` WHERE `entry` IN (15290, 39373, 33778, 379, 38395, 40972, 22845, 33504, 34299); +INSERT INTO `spell_bonus_data` VALUES (15290, 0, 0, 0, 'Vampiric Embrace'), (39373, 0, 0, 0, 'Shadowmend'), (33778, 0, 0, 0, 'Lifebloom'), diff --git a/sql/updates/2064_world.sql b/sql/updates/2064_world.sql index f75ab6d6a9e..f1d3c8a9eb3 100644 --- a/sql/updates/2064_world.sql +++ b/sql/updates/2064_world.sql @@ -1,7 +1,7 @@ -DELETE FROM trinity_string WHERE entry IN(7523,7524); -INSERT INTO trinity_string VALUES +DELETE FROM `trinity_string` WHERE `entry` IN (7523,7524); +INSERT INTO `trinity_string` VALUES (7523,'WORLD: Denying connections.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (7524,'WORLD: Accepting connections.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -DELETE FROM command WHERE name IN('server set closed'); -INSERT INTO command VALUES ('server set closed', 3, 'Syntax: server set closed on/off\r\n\r\nSets whether the world accepts new client connectsions.'); +DELETE FROM `command` WHERE `name` IN ('server set closed'); +INSERT INTO `command` VALUES ('server set closed', 3, 'Syntax: server set closed on/off\r\n\r\nSets whether the world accepts new client connectsions.');
\ No newline at end of file diff --git a/sql/updates/7503_01_mangos_command.sql b/sql/updates/2080_mangos_7503_01_world_command.sql index 88e01d83b3c..36627860a7f 100644 --- a/sql/updates/7503_01_mangos_command.sql +++ b/sql/updates/2080_mangos_7503_01_world_command.sql @@ -1,10 +1,6 @@ -ALTER TABLE db_version CHANGE COLUMN required_7495_01_mangos_mangos_string required_7503_01_mangos_command bit; - -DELETE FROM `command` WHERE `name` IN ( - 'addmove','allowmove','debug Mod32Value','debug standstate','go creature','go graveyard','go trigger', - 'gobject phase','gobject setphase','Mod32Value','modify arena', - 'modify standstate','npc addmove','npc allowmove','npc textemote','npc phase','npc setphase','showhonor'); +/*ALTER TABLE db_version CHANGE COLUMN required_7495_01_mangos_mangos_string required_7503_01_mangos_command bit;*/ +DELETE FROM `command` WHERE `name` IN ('addmove','allowmove','debug Mod32Value','debug standstate','go creature','go graveyard','go trigger','gobject phase','gobject setphase','Mod32Value','modify arena','modify standstate','npc addmove','npc allowmove','npc textemote','npc phase','npc setphase','showhonor'); INSERT INTO `command` VALUES ('debug Mod32Value',3,'Syntax: .debug Mod32Value #field #value\r\n\r\nAdd #value to field #field of your character.'), ('go creature',1,'Syntax: .go creature #creature_guid\r\nTeleport your character to creature with guid #creature_guid.\r\n.gocreature #creature_name\r\nTeleport your character to creature with this name.\r\n.gocreature id #creature_id\r\nTeleport your character to a creature that was spawned from the template with this entry.\r\n*If* more than one creature is found, then you are teleported to the first that is found inside the database.'), @@ -16,4 +12,4 @@ INSERT INTO `command` VALUES ('npc addmove',2,'Syntax: .npc addmove #creature_guid [#waittime]\r\n\r\nAdd your current location as a waypoint for creature with guid #creature_guid. And optional add wait time.'), ('npc allowmove',3,'Syntax: .npc allowmove\r\n\r\nEnable or disable movement creatures in world. Not implemented.'), ('npc setphase',2,'Syntax: .npc setphase #phasemask\r\n\r\nSelected unit or pet phasemask changed to #phasemask with related world vision update for players. In creature case state saved to DB and persistent. In pet case change active until in game phase changed for owner, owner re-login, or GM-mode enable/disable..'), -('npc textemote',1,'Syntax: .npc textemote #emoteid\r\n\r\nMake the selected creature to do textemote with an emote of id #emoteid.'); +('npc textemote',1,'Syntax: .npc textemote #emoteid\r\n\r\nMake the selected creature to do textemote with an emote of id #emoteid.');
\ No newline at end of file |