Updates

Yeah I'm being lazy and just displaying my git commits

Date Author Update Notes

3 months ago

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

Marisha

 Fixed variable name mismatch

3 months 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.

4 months ago

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

Marisha

 Added validation on period query parameter

4 months ago

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

Marisha

 Fixed id name conflict

4 months ago

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

Marisha

 Fixed collapse id

4 months ago

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

Marisha

 Collapse item list by default on bingo page

4 months ago

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

Marisha

 Added warning when bot detected

4 months ago

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

Marisha

 Added some dumb bot prevention

4 months 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.

4 months 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

4 months ago

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

Marisha

 Added lowercase item name checking

4 months 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.

4 months 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

5 months ago

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

Marisha

 Added the Moderator role

5 months 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.

5 months 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.

8 months 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

8 months ago

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

Marisha

Merge: 5e1add0 4006771

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

8 months ago

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

Marisha

 Fixed Activity page and missing Player delete btn

8 months ago

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

Marisha

 Fix references

8 months ago

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

Marisha

 Changing log type to debug to reduce log spam

8 months ago

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

Marisha

 Fixed cache file permissions

8 months ago

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

Marisha

 Jobs are now unique as to not build up too large

8 months ago

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

Marisha

 Fixed bad query load causing significant slowness

9 months ago

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

Marisha

 Fixed change player name issue

10 months ago

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

Marisha

 Fixed chart data on competitions page

10 months ago

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

Marisha

 Added default icon for new hiscores entries

10 months 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

10 months ago

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

Marisha

 Added Deadman Points to hiscores

11 months ago

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

Marisha

 Added desert treasure bosses to hiscores

11 months ago

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

Marisha

 Fixed some migrations and added Docker config

1 year 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!

1 year ago

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

Marisha

 Exposed API to fetch gains for a period

1 year 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

1 year ago

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

Marisha

 Fixed query attempt #2

1 year 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

1 year ago

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

Marisha

 Changed overall_experience column to use big int

1 year 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 :)

1 year ago

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

Marisha

 Added pagination to Competitions

1 year 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

1 year 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

1 year 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

1 year ago

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

Marisha

 Tracker will now send Discord notifications when competition starts and ends

1 year ago

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

Marisha

 Fixed issue that wasn't using cached Discord Channel ID

1 year 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

1 year 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

1 year 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

1 year ago

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

Marisha

 Preparing the database for the new Taming skill

1 year ago

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

Marisha

 Removed a couple instances of accidental text left on the page

1 year ago

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

Marisha

 Making Updates page visible as it's now working correctly

1 year ago

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

Marisha

 Making Update page available for testing

1 year 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

1 year ago

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

Marisha

 Hiding Updates page for now until fixed

1 year 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

1 year 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

1 year 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

1 year ago

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

Marisha

 Fixed issue when loading app without table being created

1 year 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

1 year ago

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

Marisha

 Added reporting email when hiscores api has changed

1 year ago

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

Marisha

 Added warning if selecting too far back in time

1 year ago

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

Marisha

 Emails now sending on queue

1 year ago

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

Marisha

 Upgraded to Laravel 9.0

1 year ago

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

Marisha

 Updated player page to show gains

1 year ago

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

Marisha

 Using binary equality for case sensitive search when changing player name

1 year 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

1 year ago

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

Marisha

 Added phanton muspah to hiscores

1 year ago

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

Marisha

 Fixed update player name to do more complex checks

1 year ago

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

Marisha

 Added combat level back after refactoring to new db calls

1 year 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

1 year ago

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

Marisha

 Fixed username sensitive search

1 year ago

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

Marisha

 Optimised DB queries, big refactor

1 year ago

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

Marisha

 Added jquery tablesorter

1 year ago

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

Marisha

 Adding table sorter

1 year ago

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

Marisha

Revert "Table sorting"

  • This reverts commit 8cce18332ff10ba18ae9f5205de76b4344a26ec4.

1 year ago

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

Marisha

 Table sorting

1 year ago

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

Marisha

 Removed unwanted bracket

1 year ago

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

Marisha

 Added unique check on email on create acc

1 year ago

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

Marisha

 Fixed up getter from config

1 year ago

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

Marisha

 Adding restart queue to deploy script

1 year ago

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

Marisha

 Behemoth commit adding emails and complete auth system

1 year ago

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

Marisha

 Adding current nginx config

1 year ago

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

Marisha

 Fixed bug not setting correct start and finish times

1 year ago

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

Marisha

 Added admin middleware and full crud on competitions and player

1 year 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

1 year ago

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

Marisha

 Print the skill details after selectionw

1 year ago

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

Marisha

 Fixed manual hiscores entry command

1 year ago

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

Marisha

 Removed crazy logs

1 year ago

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

Marisha

 Added serious logging

1 year ago

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

Marisha

 added more debug logging

1 year ago

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

Marisha

 Using raw encoding for percent chars

1 year ago

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

Marisha

 No longer logging 404 html response

1 year ago

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

Marisha

 using encoding properly

1 year ago

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

Marisha

 Url encoding

1 year ago

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

Marisha

 Added curl errno to error response

1 year ago

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

Marisha

 Reworked curl fetch

1 year ago

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

Marisha

 Added log on fetch

1 year ago

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

Marisha

 Added body res to error

1 year ago

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

Marisha

 Better error info on curl error

1 year ago

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

Marisha

 Fixed warn log

1 year ago

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

Marisha

 Fixed Log statement

1 year ago

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

Marisha

 Fixed account type checking using jobs

1 year ago

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

Marisha

 Added supervisor conf

1 year ago

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

Marisha

 Using job queues to concurrently fetch hiscores

1 year ago

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

Marisha

 Fixed to use db columns

2 years ago

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

Marisha

 Added command to delete player leaving data points

2 years ago

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

Marisha

 Changed exp gained to sort in desc order

2 years ago

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

Marisha

 Added command to change player name

2 years ago

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

Marisha

 Add command to remove player

2 years ago

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

Marisha

 Added command to create manual hiscores entry

2 years ago

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

Marisha

 Added favicons and fixed font color of title

2 years ago

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

Marisha

 Fixed display of chart on comp page

2 years ago

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

Marisha

 increased size of point radius for chart

2 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

2 years ago

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

Marisha

 Added chart to comp page

2 years ago

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

Marisha

 Fixed list display in competition show

2 years ago

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

Marisha

 Changed summary page to show top 5 comp players

2 years ago

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

Marisha

 fixed add new player issue

2 years ago

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

Marisha

 added last updated to summary page

2 years ago

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

Marisha

 Removed carbon fixed type from gains

2 years ago

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

Marisha

 Added updated at to gains object

2 years ago

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

Marisha

 added skill icon to comp on summary page

2 years ago

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

Marisha

 Added ending time to comp on summary page

2 years ago

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

Marisha

 Added competitions to summary page

2 years ago

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

Marisha

 Changed way of determining account types

2 years ago

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

Marisha

 Fixed mobile issue

2 years ago

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

Marisha

Merge: bebbff5 8ccf23b

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

2 years ago

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

Marisha

 First implementation of competitions

2 years ago

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

Marisha

 Added new icons

2 years ago

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

Marisha

 Fixed icons not displaying

2 years ago

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

Marisha

 Fixed activities section on player page

2 years ago

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

Marisha

 Fixed link on summary page

2 years ago

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

Marisha

Merge: c644b3f 9a8852e

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

2 years ago

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

Marisha

 Added player page

2 years ago

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

Marisha

 Fixed another floor in combat calc

2 years ago

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

Marisha

 Fixed floor in combat calculation

2 years ago

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

Marisha

 Fixed icon titles for ironman icons

2 years ago

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

Marisha

 Fixed exp gained scroll to top on mobile

2 years ago

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

Marisha

 Fixed icon name for kril_tsutsaroth

2 years ago

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

Marisha

 Added sw zeal, lms, bh icons

2 years ago

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

Marisha

 Added experience dropdown and added title to summary

2 years ago

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

Marisha

 Added time period for activity page

2 years ago

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

Marisha

 Added activity page

2 years ago

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

Marisha

 Fixed display accident

2 years ago

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

Marisha

 Fixed issue where diff was including -1 from no hiscores

2 years ago

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

Marisha

 Added number format to summary page

2 years ago

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

Marisha

 Added combat skill

2 years ago

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

Marisha

 added phosanis nightmare to hiscores

2 years ago

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

Marisha

 Added time period switcher and added more info to player page

2 years ago

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

Marisha

 Fixed clue scroll icons and display of activities

2 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

2 years ago

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

Marisha

 Restructured summary view and changed theme color

2 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

2 years ago

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

Marisha

 Added black dash theme and rs icons

2 years ago

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

Marisha

 Fixed import

2 years ago

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

Marisha

 Added scheduling and fixed mariadb string length

2 years ago

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

Marisha

 Using correct account type

2 years ago

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

Marisha

 Basic fetch and store, and transform stored data into hiscores object