From 89bd2d77201229a835eca41b78a731110c8e427d Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Fri, 2 Aug 2024 13:25:25 +0200 Subject: DB/Player: updated player_racestats for Cataclysm --- sql/updates/world/cata_classic/2024_08_02_00_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/cata_classic/2024_08_02_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/cata_classic/2024_08_02_00_world.sql b/sql/updates/world/cata_classic/2024_08_02_00_world.sql new file mode 100644 index 00000000000..3b0421cec3b --- /dev/null +++ b/sql/updates/world/cata_classic/2024_08_02_00_world.sql @@ -0,0 +1,14 @@ +DELETE FROM `player_racestats`; +INSERT INTO `player_racestats` (`race`, `agi`, `str`, `inte`, `spi`, `sta`) VALUES +(1, 0, 0, 0, 0, 0), -- Human +(2, -3, 3, -3, 2, 1), -- Orc +(3, -4, 5, -1, -1, 1), -- Dwarf +(4, 4, 4, -1, -1, 1), -- Night Elf +(5, -2, -1, -2, 5, 0), -- Undead +(6, -4, 5, -4, 3, 1), -- Tauren +(7, 2, -5, 3, 0, 0), -- Gnome +(8, 2, 1, -4, 1, 0), -- Troll +(10, 2, -3, 3, -2, 0), -- Blood Elf +(11, -3, 1, 0, 2, 0), -- Draenei +(9, 2, -3, 3, -2, 0), -- Goblin +(22, 2, 3, -4, -1, 0); -- Worgen -- cgit v1.2.3