RANews checklist

System Requirements

Have Jekyll installed. Note: If you're familiar with docker, you don't need to install Jekyll.
Have a way to run a bash script (native on Linux/MacOS, requires some tweaks on Windows).
Have a git client installed.
Optional but suggested: Visual Studio Code (makes git commands easier)

Steps to release a new RANews issue

RANews new issue checklist

make the tables sortable

Being able to sort the table would be specially useful for the Top 300 table. Sorting to see who got more points, who climbed more positions in the ranking ladder, etc...

table columns width should be consistent

Table columns width should be consistent.

RANews Mastery

Interesting idea for the future.

@StingX2:

its called RANEWS Mastery
its something users have been asking for, its a monthly or quarterly update giving the top 25 users by masteries per system

@MrOwnership:

If you wan't data for a different console you would need to change the AND GD.ConsoleID = 4 line so that it has the console ID you want to generate the list for.

SELECT SA.User, 
       Count(SA.User) AS AwardCount 
FROM   SiteAwards AS SA 
       LEFT JOIN GameData AS GD 
              ON SA.AwardData = GD.ID 
       LEFT JOIN UserAccounts AS UA 
              ON SA.User = UA.User 
WHERE  SA.AwardType = 1          -- Only count awards for games 
       AND SA.AwardDataExtra = 1 -- Only count hardcore 
       AND GD.ConsoleID = 4      -- Console ID 
       AND UA.Untracked = 0      -- Exclude untracked users 
GROUP  BY SA.User 
ORDER  BY AwardCount DESC, 
          SA.User 
LIMIT  0, 25;