diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/cata_classic/2024_08_05_08_world.sql | 88 |
1 files changed, 88 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_08_05_08_world.sql b/sql/updates/world/cata_classic/2024_08_05_08_world.sql new file mode 100644 index 00000000000..0b4f44a32ed --- /dev/null +++ b/sql/updates/world/cata_classic/2024_08_05_08_world.sql @@ -0,0 +1,88 @@ +SET @CLASS := 11; -- CLASS_DRUID +DELETE FROM `player_classlevelstats` WHERE `class`= @CLASS; +INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES +(@CLASS, 1, 21, 20, 20, 22, 22), +(@CLASS, 2, 22, 20, 21, 23, 23), +(@CLASS, 3, 22, 21, 21, 24, 24), +(@CLASS, 4, 23, 21, 22, 25, 25), +(@CLASS, 5, 23, 22, 22, 26, 26), +(@CLASS, 6, 24, 22, 23, 27, 27), +(@CLASS, 7, 24, 23, 24, 28, 28), +(@CLASS, 8, 25, 23, 24, 28, 29), +(@CLASS, 9, 25, 24, 25, 29, 30), +(@CLASS, 10, 26, 24, 25, 30, 31), +(@CLASS, 11, 26, 25, 26, 31, 33), +(@CLASS, 12, 27, 25, 27, 32, 34), +(@CLASS, 13, 27, 26, 27, 33, 35), +(@CLASS, 14, 28, 26, 28, 34, 36), +(@CLASS, 15, 29, 27, 29, 36, 37), +(@CLASS, 16, 29, 27, 29, 37, 38), +(@CLASS, 17, 30, 28, 30, 38, 40), +(@CLASS, 18, 30, 29, 31, 39, 41), +(@CLASS, 19, 31, 29, 31, 40, 42), +(@CLASS, 20, 32, 30, 32, 41, 43), +(@CLASS, 21, 32, 30, 33, 42, 45), +(@CLASS, 22, 33, 31, 34, 43, 46), +(@CLASS, 23, 34, 32, 34, 44, 47), +(@CLASS, 24, 34, 32, 35, 46, 49), +(@CLASS, 25, 35, 33, 36, 47, 50), +(@CLASS, 26, 36, 33, 37, 48, 51), +(@CLASS, 27, 36, 34, 37, 49, 53), +(@CLASS, 28, 37, 35, 38, 50, 54), +(@CLASS, 29, 38, 35, 39, 52, 56), +(@CLASS, 30, 38, 36, 40, 53, 57), +(@CLASS, 31, 39, 37, 41, 54, 58), +(@CLASS, 32, 40, 37, 42, 56, 60), +(@CLASS, 33, 41, 38, 42, 57, 61), +(@CLASS, 34, 41, 39, 43, 58, 63), +(@CLASS, 35, 42, 39, 44, 60, 64), +(@CLASS, 36, 43, 40, 45, 61, 66), +(@CLASS, 37, 44, 41, 46, 62, 68), +(@CLASS, 38, 45, 41, 47, 64, 69), +(@CLASS, 39, 45, 42, 48, 65, 71), +(@CLASS, 40, 46, 43, 49, 67, 72), +(@CLASS, 41, 47, 44, 50, 68, 74), +(@CLASS, 42, 48, 44, 51, 70, 76), +(@CLASS, 43, 49, 45, 52, 71, 77), +(@CLASS, 44, 50, 46, 52, 73, 79), +(@CLASS, 45, 50, 47, 53, 74, 81), +(@CLASS, 46, 51, 48, 54, 76, 83), +(@CLASS, 47, 52, 48, 56, 77, 84), +(@CLASS, 48, 53, 49, 57, 79, 86), +(@CLASS, 49, 54, 50, 58, 81, 88), +(@CLASS, 50, 55, 51, 59, 82, 90), +(@CLASS, 51, 56, 52, 60, 84, 92), +(@CLASS, 52, 57, 53, 61, 86, 94), +(@CLASS, 53, 58, 54, 62, 87, 96), +(@CLASS, 54, 59, 54, 63, 89, 98), +(@CLASS, 55, 60, 55, 64, 91, 100), +(@CLASS, 56, 61, 56, 65, 93, 102), +(@CLASS, 57, 62, 57, 66, 94, 104), +(@CLASS, 58, 63, 58, 68, 96, 106), +(@CLASS, 59, 64, 59, 69, 98, 108), +(@CLASS, 60, 65, 60, 70, 100, 110), +(@CLASS, 61, 66, 61, 71, 102, 112), +(@CLASS, 62, 67, 62, 72, 104, 114), +(@CLASS, 63, 68, 63, 74, 106, 117), +(@CLASS, 64, 69, 64, 75, 108, 119), +(@CLASS, 65, 71, 65, 76, 110, 121), +(@CLASS, 66, 72, 66, 78, 112, 123), +(@CLASS, 67, 73, 67, 79, 114, 126), +(@CLASS, 68, 74, 68, 80, 116, 128), +(@CLASS, 69, 75, 69, 82, 118, 130), +(@CLASS, 70, 76, 70, 83, 120, 133), +(@CLASS, 71, 78, 71, 84, 122, 135), +(@CLASS, 72, 79, 73, 86, 125, 138), +(@CLASS, 73, 80, 74, 87, 127, 140), +(@CLASS, 74, 81, 75, 89, 129, 143), +(@CLASS, 75, 83, 76, 90, 131, 145), +(@CLASS, 76, 84, 77, 92, 134, 148), +(@CLASS, 77, 85, 78, 93, 136, 151), +(@CLASS, 78, 87, 80, 95, 138, 153), +(@CLASS, 79, 88, 81, 96, 141, 156), +(@CLASS, 80, 89, 82, 98, 143, 159), +(@CLASS, 81, 91, 83, 99, 146, 161), +(@CLASS, 82, 92, 85, 101, 148, 164), +(@CLASS, 83, 94, 86, 102, 151, 167), +(@CLASS, 84, 95, 87, 104, 153, 170), +(@CLASS, 85, 96, 89, 106, 156, 173); |