aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authortreeston <treeston.mmoc@gmail.com>2016-01-20 23:43:13 +0100
committerjoschiwald <joschiwald.trinity@gmail.com>2016-09-03 13:46:33 +0200
commita92bfb5505e17cc183ec5aa74b01564d566b7677 (patch)
tree874e21eafc1c7bed13881c9119fa4f9fd155253f /sql/updates/auth
parenta140ba4b7598636e1e90ed0243b58878231e4b3b (diff)
Scripts/Commands: Small QoL adjustments
- .debug hostil now shows spawn ID (DBGUID) in addition to current GUID (so you can .go creature to it) - .npc temp now takes an additional argument before the creature entry that determines whether the spawned creature instantly despawns upon death. Default is instant despawn (current behavior). - Add .npc evade command. - Add .pet level command. - .server shutdown and .server restart now fail with an error message if time is below a config var (GM.ForceShutdownThreshold, default 30s) as long as another player is connected. - New commands .server shutdown force and .server restart force bypass this limitation. (cherry picked from commit 0e1eb460d687e545f95caf0f38a16c3feb7132a3)
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/6.x/2016_09_03_00_auth_2016_05_11_00_auth.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/auth/6.x/2016_09_03_00_auth_2016_05_11_00_auth.sql b/sql/updates/auth/6.x/2016_09_03_00_auth_2016_05_11_00_auth.sql
new file mode 100644
index 00000000000..d1a6f3e6023
--- /dev/null
+++ b/sql/updates/auth/6.x/2016_09_03_00_auth_2016_05_11_00_auth.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `rbac_permissions` WHERE `id` IN (837,838,839,840);
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (837,"Command: npc evade"), (838,"Command: pet level"), (839,"Command: server shutdown force"), (840,"Command: server restart force");
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (837,838,839,840);
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES (196,837),(196,838),(196,839),(196,840);