aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2024-08-02 13:25:25 +0200
committerOvahlord <dreadkiller@gmx.de>2024-08-02 13:25:25 +0200
commit89bd2d77201229a835eca41b78a731110c8e427d (patch)
treed12f9306976af412d122dfa656da0c7258da112f /sql
parent7a9d27639a6fe7eaba55360a6b803b658f79cd6c (diff)
DB/Player: updated player_racestats for Cataclysm
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/cata_classic/2024_08_02_00_world.sql14
1 files changed, 14 insertions, 0 deletions
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