From 08005a7cf937d2abd3bd164c24c80bb87ec3378c Mon Sep 17 00:00:00 2001 From: funjoker Date: Sat, 30 Jan 2021 12:31:26 +0100 Subject: DB/Player: Fix player_racestats --- sql/updates/world/master/2021_01_30_00_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/master/2021_01_30_00_world.sql (limited to 'sql') 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 -- cgit v1.2.3