aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2023_01_24_00_world.sql27
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_01_24_00_world.sql b/sql/updates/world/master/2023_01_24_00_world.sql
new file mode 100644
index 00000000000..daa72389734
--- /dev/null
+++ b/sql/updates/world/master/2023_01_24_00_world.sql
@@ -0,0 +1,27 @@
+UPDATE `skill_tiers` SET `Value13`=0, `Value14`=0, `Value15`=0, `Value16`=0 WHERE `ID` IN (41, 62, 161);
+UPDATE `skill_tiers` SET `Value12`=0 WHERE `ID`=224;
+UPDATE `skill_tiers` SET `Value4`=0, `Value5`=0, `Value6`=0, `Value7`=0, `Value8`=0, `Value9`=0, `Value10`=0, `Value11`=0, `Value12`=0 WHERE `ID`=295;
+
+DELETE FROM `skill_tiers` WHERE `ID` BETWEEN 451 AND 463;
+DELETE FROM `skill_tiers` WHERE `ID` IN (472, 473, 474, 478, 480, 481, 482);
+INSERT INTO `skill_tiers` (`ID`,`Value1`,`Value2`,`Value3`,`Value4`,`Value5`,`Value6`,`Value7`,`Value8`,`Value9`,`Value10`,`Value11`,`Value12`,`Value13`,`Value14`,`Value15`,`Value16`) VALUES
+(451,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(452,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(453,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(454,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(455,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(456,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(457,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(458,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(459,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(460,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(461,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(462,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(463,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(472,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(473,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(474,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(478,150,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(480,115,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(481,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
+(482,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);