sxcybot

commit b918f4a7412a0691463e4703c798928cfbfe9a96
parent a34e7856419bb98475a057782f2db128c2b758a8
Author: Wim Dupont <wim@wimdupont.com>
Date:   Wed, 12 Apr 2023 23:21:24 +0200

added new wildy bosses to hiscores

Diffstat:
M
src/main/java/com/wimdupont/sxcybot/client/HiScoreClient.java
 | 
2
+-
A
src/main/resources/db/migration/V1_13__wildy_bosses_hiscore_update.sql
 | 
26
++++++++++++++++++++++++++
M
src/test/java/com/wimdupont/sxcybot/client/HiScoreClientTest.java
 | 
4
++--

3 files changed, 29 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/wimdupont/sxcybot/client/HiScoreClient.java b/src/main/java/com/wimdupont/sxcybot/client/HiScoreClient.java
@@ -31,7 +31,7 @@ public class HiScoreClient {
     private static final int STATS_START = 0;
     private static final int STATS_END = 23;
     private static final int BOSS_START = 38;
-    private static final int BOSS_END = 88;
+    private static final int BOSS_END = 91;
 
     private final OsrsHiscoreBossService osrsHiscoreBossService;
     private final OsrsHiscoreStatService osrsHiscoreStatService;
diff --git a/src/main/resources/db/migration/V1_13__wildy_bosses_hiscore_update.sql b/src/main/resources/db/migration/V1_13__wildy_bosses_hiscore_update.sql
@@ -0,0 +1,26 @@
+UPDATE osrs_hiscore_boss SET order_value = order_value+1 WHERE order_value > 72;
+
+INSERT INTO osrs_hiscore_boss
+VALUES
+(UUID(),"Spindel", 2, 73, 3);
+
+UPDATE osrs_hiscore_boss SET order_value = order_value+1 WHERE order_value > 41;
+
+INSERT INTO osrs_hiscore_boss
+VALUES
+(UUID(),"Cal'varion", 2, 42, 3);
+
+UPDATE osrs_hiscore_boss SET order_value = order_value+1 WHERE order_value > 39;
+
+INSERT INTO osrs_hiscore_boss
+VALUES
+(UUID(),"Artio", 2, 40, 3);
+
+UPDATE osrs_hiscore_boss SET multiplier = 3 WHERE name = 'Callisto';
+UPDATE osrs_hiscore_boss SET multiplier = 3 WHERE name = 'Chaos Elemental';
+UPDATE osrs_hiscore_boss SET multiplier = 3 WHERE name = 'Scorpia';
+UPDATE osrs_hiscore_boss SET multiplier = 3 WHERE name = 'Venenatis';
+UPDATE osrs_hiscore_boss SET multiplier = 3 WHERE name = 'Vet\'ion';
+
+UPDATE osrs_hiscore_boss SET multiplier = 2 WHERE name = 'Chaos Fanatic';
+UPDATE osrs_hiscore_boss SET multiplier = 2 WHERE name = 'Crazy Archaeologist';
diff --git a/src/test/java/com/wimdupont/sxcybot/client/HiScoreClientTest.java b/src/test/java/com/wimdupont/sxcybot/client/HiScoreClientTest.java
@@ -80,11 +80,11 @@ class HiScoreClientTest {
         String playerName = "Zxxy";
         List<OsrsHiscoreBoss> hiscoreBosses = List.of(OsrsHiscoreBoss.Builder.newBuilder()
                         .name("KBD")
-                        .orderValue(60)
+                        .orderValue(62)
                         .build(),
                 OsrsHiscoreBoss.Builder.newBuilder()
                         .name("Wintertodt")
-                        .orderValue(86)
+                        .orderValue(89)
                         .build()
         );