diff options
| author | funjoker <funjoker109@gmail.com> | 2021-01-30 12:31:26 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-30 12:31:26 +0100 |
| commit | 08005a7cf937d2abd3bd164c24c80bb87ec3378c (patch) | |
| tree | e143d352745b6ac617bdf98b1c8e4ed3f816747c | |
| parent | f185a118e889895178338e70ed08d6fc840ead33 (diff) | |
DB/Player: Fix player_racestats
| -rw-r--r-- | sql/updates/world/master/2021_01_30_00_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_30_00_world.sql b/sql/updates/world/master/2021_01_30_00_world.sql new file mode 100644 index 00000000000..666b17f6828 --- /dev/null +++ b/sql/updates/world/master/2021_01_30_00_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `player_racestats` WHERE `race` IN (31, 32, 35, 37); +INSERT INTO `player_racestats` (`race`, `str`, `agi`, `sta`, `inte`) VALUES +(31, 1, 2, 0, -3), -- Zandalari +(32, 1, -2, 2, -1), -- Kul Tiran +(35, -3, 3, -1, 1), -- Vulpera +(37, -2, 1, -1, 2); -- Mechagnome + +UPDATE `player_racestats` SET `str`=2, `agi`=-2, `sta`=1, `inte`=-1 WHERE `race`=34; -- DarkIron +UPDATE `player_racestats` SET `str`=3, `agi`=-3, `sta`=1, `inte`=-1 WHERE `race`=36; -- Maghar +UPDATE `player_racestats` SET `str`=-2, `agi`=1, `sta`=-1, `inte`=2 WHERE `race`=27; -- Nightborne +UPDATE `player_racestats` SET `str`=0, `agi`=-1, `sta`=1, `inte`=0 WHERE `race`=30; -- Lightforged |