sxcybot

Discord bot for OSRS based channels
git clone git://git.wimdupont.com/sxcybot.git
Log | Files | Refs | README | LICENSE

commit c910c8644ad33f8e6ea6b2fc19d304bb9b103dfe
parent 396e83e842a66a03c9ba532aee68e36b8854018c
Author: Wim Dupont <wim@wimdupont.com>
Date:   Thu, 27 Jul 2023 08:57:36 +0200

added dt2 bosses to hiscores

Diffstat:
Msrc/main/java/com/wimdupont/sxcybot/client/HiScoreClient.java | 2+-
Asrc/main/resources/db/migration/V1_15__DT2_hiscore_bosses.sql | 23+++++++++++++++++++++++
Msrc/test/java/com/wimdupont/sxcybot/client/HiScoreClientTest.java | 4++--
3 files changed, 26 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 = 40; - private static final int BOSS_END = 93; + private static final int BOSS_END = 97; private final OsrsHiscoreBossService osrsHiscoreBossService; private final OsrsHiscoreStatService osrsHiscoreStatService; diff --git a/src/main/resources/db/migration/V1_15__DT2_hiscore_bosses.sql b/src/main/resources/db/migration/V1_15__DT2_hiscore_bosses.sql @@ -0,0 +1,23 @@ +UPDATE osrs_hiscore_boss SET order_value = order_value+1 WHERE order_value > 87; + +INSERT INTO osrs_hiscore_boss +VALUES +(UUID(),"Vardorvis", 1, 88, 1); + +UPDATE osrs_hiscore_boss SET order_value = order_value+1 WHERE order_value > 80; + +INSERT INTO osrs_hiscore_boss +VALUES +(UUID(),"The Whisperer", 1, 81, 1); + +UPDATE osrs_hiscore_boss SET order_value = order_value+1 WHERE order_value > 80; + +INSERT INTO osrs_hiscore_boss +VALUES +(UUID(),"The Leviathan", 1, 81, 1); + +UPDATE osrs_hiscore_boss SET order_value = order_value+1 WHERE order_value > 58; + +INSERT INTO osrs_hiscore_boss +VALUES +(UUID(),"Duke Sucellus", 1, 59, 1); 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(64) + .orderValue(65) .build(), OsrsHiscoreBoss.Builder.newBuilder() .name("Wintertodt") - .orderValue(91) + .orderValue(95) .build() );