5 months ago

18/5/2025 01:12 PM (UTC)

Marisha

8 months ago

1/3/2025 09:20 AM (UTC)

Marisha

Added Royal Titans and Collections Logged

• Also fixed up issue where the tracker wasn't sending a reporting email when new records get added to the hiscores. Should be more responsive to adding the new records next time!

9 months ago

18/1/2025 11:23 AM (UTC)

Marisha

9 months ago

18/1/2025 11:14 AM (UTC)

Marisha

9 months ago

18/1/2025 10:42 AM (UTC)

Marisha

9 months ago

18/1/2025 08:25 AM (UTC)

Marisha

Add missing cache table migration

• I mean I didn't forget the first time, there just happened to be two different ones :( in two different sections of the docs. Bad docs!

9 months ago

18/1/2025 08:23 AM (UTC)

Marisha

Moving cache driver to database temporarily

• Will eventually move to something faster like Redis, but previous driver is not working as expected

9 months ago

18/1/2025 07:35 AM (UTC)

Marisha

Changed fetch interval and implemented unique jobs

• Previously fetch interval was every 2 minutes for all players, but now due to more players in the tracker, as well as performing an additional request for seasonal hiscores for each player, is causing the total fetch time for all players to take longer than the 2 minute interval
• First of all I've changed the fetch interval to every 5 minutes now, so server isn't constantly churning
• Secondly I've tried to re-implement unique jobs, so even if the total fetch time is taking longer than the interval then it shouldn't keep stacking onto the queue. I had issues with this in the past and was why I removed it. I have a feeling it was due to cache issues previously which if I recall I have fixed now since then. I guess let's just see how this goes.

11 months ago

26/11/2024 06:51 PM (UTC)

Marisha

Implemented seasonal hiscores fetch

• Currently only sets league points, but fetching different hiscores types in parallel for each player is setup to be used in the future

1 year ago

27/10/2024 01:14 PM (UTC)

Marisha

Added recent bosses to show in UI

• Amaxliatl, Araxxor, Colosseum Glory, Lunar Chests, Sol Heredit, and The Hueycoatl.
• Previously I updated the tracker to be able to capture data points for newly added bosses, so the data for the new bosses will have been capturing for each player as of the boss release date. It's just that the UI did not know about the new bosses in order to display them.
• Will automate this in a future update, so new bosses will display straight away.

1 year ago

24/9/2024 05:45 AM (UTC)

Marisha

Provide option to hide teams before bingo starts

• Defaults to false so the teams don't accidentally get displayed unintentionally

1 year ago

4/9/2024 06:29 AM (UTC)

Marisha

Fixed issue with long page loads

• Was due to a query being used to determine the first database record, but wasn't using an indexed column. As the data points increased in size then the query became slower.

1 year ago

17/3/2024 06:22 AM (UTC)

Marisha

1 year ago

17/3/2024 06:05 AM (UTC)

Marisha

Refactored logic comparing hiscores data

• The previous logic was picking up on an RS bug, where it is possible for a player's Iron hiscores to have values larger than the normal hiscores, due to previous "new character" skilling events that for some reason bled over to the player's Iron hiscores. This meant the logic would assume it's an Iron account because it would see exp greater than what's in the normal account. Modified this code so it just compares the Overall exp gained instead of each skill individually.

1 year ago

17/2/2024 12:04 PM (UTC)

Marisha

1 year ago

15/2/2024 11:22 PM (UTC)

Marisha

1 year ago

15/2/2024 11:17 PM (UTC)

Marisha

1 year ago

15/2/2024 11:15 PM (UTC)

Marisha

1 year ago

15/2/2024 11:03 PM (UTC)

Marisha

1 year ago

15/2/2024 10:50 PM (UTC)

Marisha

1 year ago

4/2/2024 02:44 PM (UTC)

Marisha

Added bingo related item and exp gains

• Slightly changed the UI for each team on the bingo competition page, to now show items gained, experience gained, and any activities such as boss kills. This should help the admins collate the data a bit easier to work out who checked off a bingo tile or not.
• Up next, provide the moderators and admins a table of items gained, so they can remove and add them if adjustements need to be made.

1 year ago

4/2/2024 03:07 AM (UTC)

Marisha

Added teams to the bingo page

• Competition has already started and I'm lagging behind a bit. Just implemented the UI so moderators and admins can create/edit/delete the bingo teams.
• Up next is to display the team's gains for the bingo competition

1 year ago

3/2/2024 12:23 AM (UTC)

Marisha

1 year ago

2/2/2024 09:57 PM (UTC)

Marisha

Added Scurrius to the list of bosses

• I had previously updated the tracker to ensure it stores the data for newly added hiscores entries, so since release the tracker has been capturing player's hiscores. It just wouldn't show up until I added it to the list of bosses so it can display it.
• Having to do this made me think of an idea for the future, where I should just have it automatically get added to a list, and attempt to scrape the skill/activity icon from the official OSRS hiscores. Save having to make any updates around hiscores updates which would be good.
• Also fixed a bug on the home page where clue scrolls weren't showing in the list of activities.

1 year ago

2/2/2024 09:04 PM (UTC)

Marisha

Started implementing base bingo board

• Added the Teams game type, with the potential to add more different game types later such as free for all for example.
• Started implementation on the bingo competition page, laying out the board and making sure it scales ok with mobile. Hidden for now as there's no additional functionality yet.
• Added points property to the bingo_tile

1 year ago

20/1/2024 08:34 AM (UTC)

Marisha

1 year ago

14/1/2024 04:57 PM (UTC)

Marisha

Upgraded packages

• The Discord API must have changed, so the tracker was failing to send
• vel updates to the #tracker-announcements channel in discord. Simple upgrade of packages fixed the issue without any code changes needed.

1 year ago

14/1/2024 10:21 AM (UTC)

Marisha

Added Bingo Event Automated plugin integration

• Added a couple of API endpoints to handle integration with the 'Bingo Event Automated' plugin in RuneLite
• When there is an active bingo competition in the tracker, clicking into it will show how to configure the RuneLite plugin
• Once configured, if a player receives an item they have not yet obtained during the competition, then it will send a screenshot to the specified Discord channel using the webhook
• Still need to add an admin interface to configure the items to be obtained etc.

2 years ago

23/10/2023 10:36 PM (UTC)

Marisha

Removed unique constraint on Fetch Hiscores job

• For some reason the lock wasn't being released, no idea why. This was preventing any further jobs being added to the queue
• Will need to address this in a future commit, as job uniqueness is ideal to not overwhelm the serverwq

2 years ago

19/10/2023 08:13 PM (UTC)

Marisha

Merge: 5e1add0 4006771

• Merge branch 'master' of github.com:clairemira/OSRSTracker

2 years ago

19/10/2023 08:10 PM (UTC)

Marisha

2 years ago

15/10/2023 04:42 AM (UTC)

Marisha

2 years ago

15/10/2023 03:51 AM (UTC)

Marisha

2 years ago

15/10/2023 03:49 AM (UTC)

Marisha

2 years ago

15/10/2023 03:25 AM (UTC)

Marisha

2 years ago

14/10/2023 02:48 AM (UTC)

Marisha

2 years ago

26/9/2023 07:36 AM (UTC)

Marisha

2 years ago

29/8/2023 12:46 AM (UTC)

Marisha

2 years ago

28/8/2023 11:29 PM (UTC)

Marisha

2 years ago

28/8/2023 10:46 PM (UTC)

Marisha

Now using JSON hiscores

• This means that the tracker won't stop tracking data when a new hiscore entry gets added to the official OSRS hiscores. Instead the new entry will automatically get added into the database and will be included without requiring any tracker updates
• Also took this opportunity to clean up a bunch of code and remove ugly helper functions

2 years ago

23/8/2023 09:13 PM (UTC)

Marisha

2 years ago

26/7/2023 10:01 AM (UTC)

Marisha

2 years ago

18/7/2023 09:59 AM (UTC)

Marisha

2 years ago

25/5/2023 08:16 PM (UTC)

Marisha

Added Legacy Bounty Hunter activities to the tracker

• Todo: The last time the tracker broke with the wilderness bosses I noticed that RuneLite didn't break at all. So I had a look at RuneLite's code and found out there's a RuneScape API endpoint I can fetch from that returns a JSON object instead of a blob of text with all the hiscores in a specific order. So upcoming I will be able to modify the hiscores fetching to use the JSON endpoint instead which means I can map the known entries accordingly, and when the hiscores gets updated it won't break anything it just means the newly added skill or activity to the hiscores won't be tracked until I add that in. But this is definitely the ideal way of going about it so I will update the tracker soon to be able to handle this!

2 years ago

7/5/2023 03:13 PM (UTC)

Marisha

2 years ago

7/5/2023 04:43 AM (UTC)

Marisha

Better validation message when creating or updating competition

• The validation message when attempting to create a competition without a skill, activity or boss wasn't very clear. Saying there are "missing items". Changed the text to better reflect exactly what's missing

2 years ago

7/5/2023 04:23 AM (UTC)

Marisha

2 years ago

7/5/2023 04:03 AM (UTC)

Marisha

Fixed invalid query syntax causing 500 error

• Not too sure how this popped up, everything was working since the last update. Doesn't make much sense for this to pop up randomly like this when it seems it should happen every time including when testing after the last update

2 years ago

25/4/2023 06:03 AM (UTC)

Marisha

2 years ago

25/4/2023 04:33 AM (UTC)

Marisha

Added validation to disallow any links when submitting Contact form

• Can't believe how much I'm getting spammed on the contact form. Added some URL detection validation to basically tell them to F off :)

2 years ago

25/4/2023 04:02 AM (UTC)

Marisha

2 years ago

25/4/2023 02:32 AM (UTC)

Marisha

Refactored competitions to support multiple skills, bosses and activities

• Previously you could only have one hiscore item for a competition, so you couldn't have a competition involving multiple bosses for example. You would have had to create individual competitions, one for each boss, and then add the totals up at the end and it would get messy
• Refactored existing logic so now it can handle multiple hiscores items per competition. And allows the admins to rank the competition either by experience or level/activity/boss, such as in the case of a competition having both skills and bosses but only the experience would be tracked

2 years ago

12/4/2023 12:10 PM (UTC)

Marisha

Updated hiscores with most recent wilderness bosses

• Added Artio, Cal'varion and Spindel as the OSRS hiscores now provide the kill counts for them
• Also removed a previous database migration to handle the Taming
• ill as Jagex tricked me by putting it in the in-game hiscores panel for some reason

2 years ago

9/4/2023 12:42 AM (UTC)

Marisha

Added Admin Settings page to customise Discord channels

• Added a way for admins of the tracker to customise the channels that the Discord messages get sent to, as well as being able to specify which milestone levels the tracker should report

2 years ago

2/4/2023 01:25 AM (UTC)

Marisha

2 years ago

1/4/2023 11:11 PM (UTC)

Marisha

2 years ago

1/4/2023 12:41 AM (UTC)

Marisha

Added command to send manual Discored message notification

• This will be used by the system owner for testing to ensure the Discord bot integration is setup correctly and can send messages to the configured channel

2 years ago

1/4/2023 12:22 AM (UTC)

Marisha

Added Discord bot integration

• This way the tracker will be able to send notification messages to any channel that the bot has been granted permissions for
• Currently it is capable of sending level milestone notifications to a channel which is defined in the backend config
• Next up I will create an admin page for admins of the tracker to be able to customise what levels the milestone notifications should get sent for as well as which Discord channel they go to

2 years ago

31/3/2023 08:45 PM (UTC)

Marisha

Updating packages to address a security vulnerability

• The package in question was `symfony/http-kernel` and the vulnerability was related to HTTP caching of cookies
• This shouldn't have affected the tracker in any way, but worth updating to the latest version to be safe

2 years ago

31/3/2023 08:35 PM (UTC)

Marisha

2 years ago

27/1/2023 08:02 AM (UTC)

Marisha

2 years ago

26/1/2023 12:01 AM (UTC)

Marisha

2 years ago

25/1/2023 11:36 PM (UTC)

Marisha

2 years ago

25/1/2023 11:18 PM (UTC)

Marisha

Added a Contact page and also fixed an issue when determining the player type

• Added a Contact page so that anyone can get in touch regarding the tracker
• The contact form only allows submissions once every 5 minutes to prevent malicious behaviour
• The tracker automatically tracks the player type which is needed in case a player changes their account (e.g. an Ultimate Ironman to an Ironman), however there was a bug in the logic where if an Ultimate Ironman changed account type to a Normie account then it wouldn't pick up on this
• rticular change. I completely re-wrote this checking player type logic so that it's cleaner and the above issue has been fixed

2 years ago

20/1/2023 01:53 PM (UTC)

Marisha

2 years ago

20/1/2023 01:39 PM (UTC)

Marisha

Changed way git was being called to show updates

• Was using an unsafe call and it wasn't displayong on the production server
• Attempting to use another safer call to see if it will work

2 years ago

20/1/2023 12:05 PM (UTC)

Marisha

Added About and Updates pages

• Thought of a clever-dumb way of providing update notes with practically zero effort required by simply displaying my git commit messages which is what you're seeing here
• Also added an About page which I think might be useful as it explains how the tracker works in a bit more detail

2 years ago

20/1/2023 07:02 AM (UTC)

Marisha

Tracker now stops deleting unknown players as they might be known later

• I originally coded the tracker to check the hiscores immediately after when a new player is added, and if the player didn't exist on the hiscores then I just assumed it wasn't a valid player so I then delete the player from the database
• The issue with the above is that sometimes a player can technically exist but just doesn't have a hiscores record yet. So I've decided to remove the code that was previously deleting a player if they didn't exist and now it will keep them in the tracker. When they eventually get a hiscores entry it will get stored and displayed on the tracker accordingly
• If any players get added with the incorrect name by mistake then any admin can go and delete the player from the tracker

2 years ago

20/1/2023 06:38 AM (UTC)

Marisha

2 years ago

20/1/2023 06:15 AM (UTC)

Marisha

Added warning when RuneScape hiscores gets updated with new skill or activity

• Previously the tracker would silently stop collecting data, and the system owner wouldn't be alerted either
• With this update it involves sending an email alert to the system owner as well as producing a warning banner on each page to let the viewer know data collection has been paused momentarily and will be fixed ASAP

2 years ago

19/1/2023 10:46 PM (UTC)

Marisha

2 years ago

19/1/2023 10:26 AM (UTC)

Marisha

2 years ago

19/1/2023 09:08 AM (UTC)

Marisha

2 years ago

18/1/2023 08:23 AM (UTC)

Marisha

2 years ago

13/1/2023 11:22 PM (UTC)

Marisha

2 years ago

13/1/2023 07:40 AM (UTC)

Marisha

2 years ago

12/1/2023 08:19 AM (UTC)

Marisha

Change Player Name now removes new instance of player before saving

• I didn't witness it, but previously the change player name logic didn't check for an exsting player with the current_name being set. So assuming the change was to proceed then it would have returned an SQL unique constraint error.
• Fixed this to first delete the already existing new player before updating the previous player to the new name

2 years ago

11/1/2023 06:41 PM (UTC)

Marisha

2 years ago

11/1/2023 08:01 AM (UTC)

Marisha

2 years ago

4/1/2023 06:12 PM (UTC)

Marisha

2 years ago

3/1/2023 06:44 AM (UTC)

Marisha

Added functionality to update player name

• Some annoying logic; attempt to update data points from the previous player name to the current player name, and if any hiscores table rows were updated then we attempt to create a new player and delete the old one. Note we attempt to create a new player because the previous player may not even exist but the data points could exist. So this way we ensure a new player is created in that case, then if the old player exists we delete that too
• Added an email send to get notified when an admin changes a player name, as important log

2 years ago

22/12/2022 10:40 AM (UTC)

Marisha

2 years ago

22/12/2022 10:33 AM (UTC)

Marisha

3 years ago

27/10/2022 03:07 PM (UTC)

Marisha

3 years ago

27/10/2022 03:04 PM (UTC)

Marisha

3 years ago

27/10/2022 03:01 PM (UTC)

Marisha

Revert "Table sorting"

• This reverts commit 8cce18332ff10ba18ae9f5205de76b4344a26ec4.

3 years ago

27/10/2022 02:59 PM (UTC)

Marisha

3 years ago

20/10/2022 02:53 PM (UTC)

Marisha

3 years ago

12/10/2022 05:17 PM (UTC)

Marisha

3 years ago

12/10/2022 05:12 PM (UTC)

Marisha

3 years ago

12/10/2022 05:10 PM (UTC)

Marisha

3 years ago

12/10/2022 04:49 PM (UTC)

Marisha

3 years ago

12/10/2022 07:47 AM (UTC)

Marisha

3 years ago

9/10/2022 09:55 AM (UTC)

Marisha

3 years ago

9/10/2022 08:06 AM (UTC)

Marisha

3 years ago

9/10/2022 01:36 AM (UTC)

Marisha

Added new job for when competition is nearing end

• Purpose is for this job to generate a list of players ordered by how much experience they've gained within the competition, then create high priority FetchHiscores jobs for these players to trigger roughly with 10 seconds remaining. This should at least pick up on any changes for the most important players directly before the competition ends (current time takes about 15 seconds to fetch hiscores for all players, with 3 procs)
• Also added another thing, when getting the results for the competition I've added 20 seconds to the finish time so that we pick up on any late logouts, however this information will show on the chart so we will know if anyone cheated or not

3 years ago

8/10/2022 11:11 AM (UTC)

Marisha

3 years ago

8/10/2022 11:03 AM (UTC)

Marisha

3 years ago

8/10/2022 10:03 AM (UTC)

Marisha

3 years ago

8/10/2022 09:49 AM (UTC)

Marisha

3 years ago

8/10/2022 09:40 AM (UTC)

Marisha

3 years ago

8/10/2022 09:29 AM (UTC)

Marisha

3 years ago

8/10/2022 09:26 AM (UTC)

Marisha

3 years ago

8/10/2022 09:15 AM (UTC)

Marisha

3 years ago

8/10/2022 09:10 AM (UTC)

Marisha

3 years ago

8/10/2022 09:05 AM (UTC)

Marisha

3 years ago

8/10/2022 09:01 AM (UTC)

Marisha

3 years ago

8/10/2022 08:42 AM (UTC)

Marisha

3 years ago

8/10/2022 08:21 AM (UTC)

Marisha

3 years ago

8/10/2022 08:16 AM (UTC)

Marisha

3 years ago

8/10/2022 08:10 AM (UTC)

Marisha

3 years ago

8/10/2022 08:03 AM (UTC)

Marisha

3 years ago

8/10/2022 07:59 AM (UTC)

Marisha

3 years ago

8/10/2022 02:31 AM (UTC)

Marisha

3 years ago

7/10/2022 04:29 PM (UTC)

Marisha

3 years ago

7/10/2022 02:45 PM (UTC)

Marisha

3 years ago

7/12/2021 08:35 AM (UTC)

Marisha

4 years ago

6/10/2021 10:54 AM (UTC)

Marisha

4 years ago

5/10/2021 10:24 AM (UTC)

Marisha

4 years ago

5/10/2021 05:35 AM (UTC)

Marisha

4 years ago

2/10/2021 01:28 AM (UTC)

Marisha

4 years ago

2/10/2021 12:41 AM (UTC)

Marisha

4 years ago

2/10/2021 12:14 AM (UTC)

Marisha

4 years ago

1/10/2021 10:09 PM (UTC)

Marisha

4 years ago

2/10/2021 07:12 AM (UTC)

Marisha

Merge: f686497 0ae619a

• Merge pull request #5 from clairemira/dev Added chart to comp page

4 years ago

1/10/2021 09:11 PM (UTC)

Marisha

4 years ago

30/9/2021 10:57 PM (UTC)

Marisha

4 years ago

30/9/2021 12:17 PM (UTC)

Marisha

4 years ago

29/9/2021 11:20 AM (UTC)

Marisha

4 years ago

28/9/2021 10:35 PM (UTC)

Marisha

4 years ago

28/9/2021 10:18 PM (UTC)

Marisha

4 years ago

28/9/2021 08:55 PM (UTC)

Marisha

4 years ago

27/9/2021 07:44 PM (UTC)

Marisha

4 years ago

27/9/2021 07:41 PM (UTC)

Marisha

4 years ago

27/9/2021 07:34 PM (UTC)

Marisha

4 years ago

27/9/2021 06:32 PM (UTC)

Marisha

4 years ago

27/9/2021 04:16 AM (UTC)

Marisha

4 years ago

26/9/2021 09:11 AM (UTC)

Marisha

Merge: bebbff5 8ccf23b

• Merge pull request #4 from clairemira/dev First implementation of competitions

4 years ago

25/9/2021 11:08 PM (UTC)

Marisha

4 years ago

23/9/2021 01:25 AM (UTC)

Marisha

4 years ago

23/9/2021 01:24 AM (UTC)

Marisha

4 years ago

23/9/2021 01:14 AM (UTC)

Marisha

4 years ago

23/9/2021 01:06 AM (UTC)

Marisha

4 years ago

23/9/2021 11:02 AM (UTC)

Marisha

Merge: c644b3f 9a8852e

• Merge pull request #3 from clairemira/dev Added player page

4 years ago

23/9/2021 01:01 AM (UTC)

Marisha

4 years ago

22/9/2021 07:34 AM (UTC)

Marisha

4 years ago

22/9/2021 07:32 AM (UTC)

Marisha

4 years ago

20/9/2021 04:13 PM (UTC)

Marisha

4 years ago

20/9/2021 04:03 PM (UTC)

Marisha

4 years ago

20/9/2021 03:56 PM (UTC)

Marisha

4 years ago

16/9/2021 07:17 AM (UTC)

Marisha

4 years ago

15/9/2021 12:39 PM (UTC)

Marisha

4 years ago

14/9/2021 10:52 PM (UTC)

Marisha

4 years ago

14/9/2021 10:45 PM (UTC)

Marisha

4 years ago

14/9/2021 12:07 AM (UTC)

Marisha

4 years ago

14/9/2021 12:06 AM (UTC)

Marisha

4 years ago

13/9/2021 03:34 PM (UTC)

Marisha

4 years ago

13/9/2021 03:30 PM (UTC)

Marisha

4 years ago

13/9/2021 02:55 PM (UTC)

Marisha

4 years ago

13/9/2021 01:39 PM (UTC)

Marisha

4 years ago

13/9/2021 12:33 PM (UTC)

Marisha

4 years ago

13/9/2021 10:14 PM (UTC)

Marisha

Merge: 377f371 51cd3d4

• Merge pull request #2 from clairemira/dev Restructured summary view and changed theme color

4 years ago

13/9/2021 12:13 PM (UTC)

Marisha

4 years ago

13/9/2021 10:50 AM (UTC)

Marisha

Merge: d4eb097 1198f99

• Merge pull request #1 from clairemira/dev Added black dash theme and rs icons

4 years ago

13/9/2021 12:48 AM (UTC)

Marisha

4 years ago

12/9/2021 02:11 PM (UTC)

Marisha

4 years ago

12/9/2021 02:11 PM (UTC)

Marisha

4 years ago

12/9/2021 10:11 PM (UTC)

Marisha

4 years ago

12/9/2021 08:52 AM (UTC)

Marisha