aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorleak <leakzx@googlemail.com>2011-08-13 13:00:38 +0200
committerleak <leakzx@googlemail.com>2011-08-13 13:00:38 +0200
commit91a3bfe42a611519c1df2f9901acaa1aa600dc31 (patch)
treef099e91ccb2e9d132efe8f306be87e707187b422 /sql
parentbac78de2034d0bfd0da7f7e9c00e833ef44eb5e8 (diff)
Core/Commands: .pinfo improvements
- Allow .pinfo <guid> - Add map/zone/subzone/phase to output
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_08_13_00_world_trinity_string.sql6
-rw-r--r--sql/updates/world/2011_08_13_01_world_command.sql2
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2011_08_13_00_world_trinity_string.sql b/sql/updates/world/2011_08_13_00_world_trinity_string.sql
new file mode 100644
index 00000000000..7d6f8f465ad
--- /dev/null
+++ b/sql/updates/world/2011_08_13_00_world_trinity_string.sql
@@ -0,0 +1,6 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (453, 550, 714, 716);
+INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES
+(453,'Ban time remaining: %s, Banned by: %s, Reason: %s'),
+(550,'Mute time remaining: %s'),
+(716,'Map: %s, Area: %s'),
+(714,'Map: %s, Area: %s, Zone: %s, Phase: %u');
diff --git a/sql/updates/world/2011_08_13_01_world_command.sql b/sql/updates/world/2011_08_13_01_world_command.sql
new file mode 100644
index 00000000000..850ccb335d4
--- /dev/null
+++ b/sql/updates/world/2011_08_13_01_world_command.sql
@@ -0,0 +1,2 @@
+DELETE FROM `command` WHERE `name` = 'pinfo';
+INSERT INTO `command` (`name`, `security`, `help`) VALUES ('pinfo','2','Syntax: .pinfo [$player_name/#GUID]\r\n\r\nOutput account information for selected player or player find by $player_name or #GUID.');