diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/4159_world.sql | 14 | ||||
| -rw-r--r-- | sql/world.sql | 9 |
2 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/4159_world.sql b/sql/updates/4159_world.sql new file mode 100644 index 00000000000..00778695c76 --- /dev/null +++ b/sql/updates/4159_world.sql @@ -0,0 +1,14 @@ +DELETE FROM `trinity_string` WHERE `entry` BETWEEN 5012 AND 5019; +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +(5012, 'No maps found!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(5013, '[Continent]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(5014, '[Instance]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(5015, '[Battleground]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(5016, '[Arena]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(5017, '[Raid reset time: %u]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(5018, '[Heroic reset time: %u]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(5019, '[Mountable]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); + +DELETE FROM `command` WHERE `name` = 'lookup map'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('lookup map', 3, 'Syntax: .lookup map $namepart\r\n\r\nLooks up a map by $namepart, and returns all matches with their map ID''s.'); diff --git a/sql/world.sql b/sql/world.sql index 5af5d424e8d..5063a6c20f0 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -430,6 +430,7 @@ INSERT INTO `command` VALUES ('lookup faction',3,'Syntax: .lookup faction $name\r\nAttempts to find the ID of the faction with the provided $name.'), ('lookup item',3,'Syntax: .lookup item $itemname\r\n\r\nLooks up an item by $itemname, and returns all matches with their Item ID\'s.'), ('lookup itemset',3,'Syntax: .lookup itemset $itemname\r\n\r\nLooks up an item set by $itemname, and returns all matches with their Item set ID\'s.'), +('lookup map',3,'Syntax: .lookup map $namepart\r\n\r\nLooks up a map by $namepart, and returns all matches with their map ID''s.'), ('lookup object',3,'Syntax: .lookup object $objname\r\n\r\nLooks up an gameobject by $objname, and returns all matches with their Gameobject ID\'s.'), ('lookup player account',2,'Syntax: .lookup player account $account ($limit) \r\n\r\n Searchs players, which account username is $account with optional parametr $limit of results.'), ('lookup player email',2,'Syntax: .lookup player email $email ($limit) \r\n\r\n Searchs players, which account email is $email with optional parametr $limit of results.'), @@ -15404,6 +15405,14 @@ INSERT INTO `trinity_string` VALUES (5009,'Sound %u Played to server',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (5010,'linkGUID: %u, Entry: %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (5011,'You can\'t teleport self to self!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(5012,'No maps found!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(5013,'[Continent]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(5014,'[Instance]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(5015,'[Battleground]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(5016,'[Arena]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(5017,'[Raid reset time: %u]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(5018,'[Heroic reset time: %u]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(5019,'[Mountable]',NULL NULL,NULL,NULL,NULL,NULL,NULL,NULL), (6613,'|cfff00000[GM Announcement]: %s|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (6614,'Notification to GM\'s - ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (6615,'|cffffff00[|c1f40af20GM Announce by|r |cffff0000%s|cffffff00]:|r %s|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), |