aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorOvalord <1Don7H4v3@m41L.com>2016-07-23 18:39:56 +0200
committerShauren <shauren.trinity@gmail.com>2016-07-23 18:39:56 +0200
commit79aafd5865f11b5ecdd2865829562b981652db75 (patch)
tree73b19b280e4b153e8ba10e4f459421d0cc9f6712 /sql/updates
parent3b8cdd434133939cec1c7aaceb24fb7dc98000f9 (diff)
Core/Players: Initial work on demon hunters
* Added starting level and required level config options as well as rbac permission to ignore the requirements * Updated max power values for both demon hunter specs * Fixed a crash during DK and DH creation * Added playercreateinfo data for demon hunters Closes #17651
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/6.x/2016_07_23_01_auth.sql7
-rw-r--r--sql/updates/world/6.x/2016_07_23_00_world.sql21
2 files changed, 28 insertions, 0 deletions
diff --git a/sql/updates/auth/6.x/2016_07_23_01_auth.sql b/sql/updates/auth/6.x/2016_07_23_01_auth.sql
new file mode 100644
index 00000000000..4ac99acee21
--- /dev/null
+++ b/sql/updates/auth/6.x/2016_07_23_01_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `rbac_permissions` WHERE `id`= 12;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(12,'Skip character creation demon hunter min level check');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`= 12;
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(194, 12);
diff --git a/sql/updates/world/6.x/2016_07_23_00_world.sql b/sql/updates/world/6.x/2016_07_23_00_world.sql
new file mode 100644
index 00000000000..1c5917acdb4
--- /dev/null
+++ b/sql/updates/world/6.x/2016_07_23_00_world.sql
@@ -0,0 +1,21 @@
+DELETE FROM `class_expansion_requirement` WHERE `classID`= 12;
+INSERT INTO `class_expansion_requirement` (`classID`, `expansion`) VALUES
+(12, 6);
+
+DELETE FROM `playercreateinfo` WHERE `class`= 12;
+INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
+(4, 12, 1481, 6383, 1180.64, 3284.96, 70.34837, 4.761345),
+(10, 12, 1481, 6383, 1180.64, 3284.96, 70.34837, 4.761345);
+
+DELETE FROM `playercreateinfo_action` WHERE `class`= 12;
+INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES
+(4, 12, 0, 195072, 0),
+(4, 12, 1, 162243, 0),
+(4, 12, 2, 162794, 0),
+(4, 12, 9, 58984, 0),
+(4, 12, 10, 188501, 0),
+(10, 12, 0, 195072, 0),
+(10, 12, 1, 162243, 0),
+(10, 12, 2, 162794, 0),
+(10, 12, 9, 202719, 0),
+(10, 12, 10, 188501, 0);