aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorCarbenium <carbenium@outlook.com>2015-04-19 23:37:29 +0200
committerCarbenium <carbenium@outlook.com>2015-04-21 00:52:21 +0200
commitbba6eb8d3dfe73a02063a7cefe6f465dae69334b (patch)
tree16dbbcaab1bca43b281828fd20b12f2ce6441540 /sql/updates/auth
parent4208c0d8396e10dc806939e1d17885d16ff7b84e (diff)
Core/Player: Added character templates
* Characters with predefined levels can be created * Avaiable factions and classes can be configured * Valid values for `factionGroup` in table `character_template_class` are 3 (Alliance) or 5 (Horde) * Added new permission RBAC_PERM_USE_CHARACTER_TEMPLATES - has to be set, to allow the usage of the templates Closes #13952
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/2015_04_21_00_auth.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/auth/2015_04_21_00_auth.sql b/sql/updates/auth/2015_04_21_00_auth.sql
new file mode 100644
index 00000000000..1a9ac877fbd
--- /dev/null
+++ b/sql/updates/auth/2015_04_21_00_auth.sql
@@ -0,0 +1,9 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (10, 662);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(10, 'Use character templates'),
+(662, 'Command: reload character_template');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (10, 662);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, 10),
+(196, 662);