diff options
| author | Ovalord <1Don7H4v3@m41L.com> | 2016-07-23 18:39:56 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-07-23 18:39:56 +0200 |
| commit | 79aafd5865f11b5ecdd2865829562b981652db75 (patch) | |
| tree | 73b19b280e4b153e8ba10e4f459421d0cc9f6712 /sql/updates | |
| parent | 3b8cdd434133939cec1c7aaceb24fb7dc98000f9 (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.sql | 7 | ||||
| -rw-r--r-- | sql/updates/world/6.x/2016_07_23_00_world.sql | 21 |
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); |
