Event Timeline
Comment Actions
Pre-maintenance changes
- Add functions for mass Discord rank changes (and nicknames)
- Update normal rank change and username change functions for new groups
Maintenance mode changes
- Update ranks table with new ranks
- Run query to determine correct rank for all (active) users and apply it to their current rank
- Check for any code using rank IDs (above 21) in code and database
Post mode changes
- Update public facing rank views with new SOP and links to positional rank info
- Check it is applied to all inactive members too
- Run discord update scripts
- MYCOC promotions view
- Remove all teamspeak rank groups (inc snco etc)
- Re-add all new teamspeak rank groups
- Apply unitaf mod rank patches to DB tables
Bugs
- Visible to for COC Reports
- Tier Update Cron not working for PFC and under
Query to update members_rank
UPDATE members_rank SET RankId = 32 WHERE RankId = 30 UPDATE members_rank SET RankId = 31 WHERE RankId = 29 UPDATE members_rank SET RankId = 30 WHERE RankId = 28 UPDATE members_rank SET RankId = 29 WHERE RankId = 27 UPDATE members_rank SET RankId = 28 WHERE RankId = 26 UPDATE members_rank SET RankId = 27 WHERE RankId = 25 UPDATE members_rank SET RankId = 26 WHERE RankId = 22 UPDATE members_rank SET RankId = 19 WHERE RankId = 20 UPDATE members_rank SET RankId = 18 WHERE RankId = 19 UPDATE members_rank SET RankId = 17 WHERE RankId = 18