This is a development version of the Stargate Database. Changes made here will not reflect on the live database.

Changelog

There is an open downtime period. Please complete your actions before the deadline.

The deadline for this downtime period is 1 April 2026 17:55.

Bugfix: 18th March 2026

  • Secretary: only show approved characters in event attendance options.
  • Fix downtime view for completed downtimes where an event character had not been selected.
  • Characters will now be assigned to an event after downtime submissions have been saved if they had not previously been selected.

Update: 16th March 2026

  • Sys Ref: implemented rules 2.0 update.
    • Catchup XP changed to be 6 per year. Approved characters under the threshold will be granted the opportunity to add additional training to bring them to the threshold.
    • Basic Skills have had an overhaul and anyone with affected skills has had their sheets modified automatically to match the new rules. If you believe a change to be in error, consult the Plot Co and System Referees.
  • Plot Co: removed NPCs from skills breakdown.
  • Plot Co: removed removed skills from skills breakdown.
  • Added markers to required form inputs.
  • Training benefits from a teacher are now applied to Basic skills before the main skill.
  • Fixed some issues with upkeep skills displaying and being removed.
  • Added notes about when to mark off the Complications table on your character sheets.
  • Implemented auto-discounts for skills. Basic skills will now automatically be applied to the main skill they discount.
  • Fixed skill lockouts to only lock out skills when the locking skill has been completed.

Bugfix: 24th January 2026

  • Fixed an issue with input size validation.
  • Fixed an issue with textareas not re-populating after issues with validation.
  • Minor wording updates.

Update: 23rd January 2026

  • Plot Co/Sys Ref: added skill specialty editing.
  • Plot Co: increased size of downtime action responses.
  • Exposed skill and specialty data to players.
  • Added CSS marker for required input fields.
  • Potentially fixed an issue with textareas not re-populating after issues with validation.
  • CodeRabbit fixes.

Update: 13th January 2026

  • Plot Co: added additional notation to the character view.
  • Plot Co: added additional notation to the downtime checking view.
  • Sys Ref: added rules 1.5 update.
  • Added error messaging regarding a glitch with duplicate actions.

Update: 8th January 2026

  • Plot Co: make research notes easier to notice.

Update: 5th December 2025

  • Added new specialties.
  • Removed levels from skill names of repeating skills with specialties.

Bugfixes: 1st & 2nd December 2025

  • Plot Co: fixed issue with research project creation.
  • Researcher: fixed issue with research project status resetting.
  • Researcher: removed edit buttons for completed research projects.
  • Changed some wording regarding downtime actions.

Update: 27th October 2025

  • Plot Co: added additional edit links for organisation controls.
  • Secretary: added permission to manage memberships.
  • Sys Ref: added rules 1.4 update.
  • Added beginnings of membership verification system.
  • Added membership name to profiles.
  • Character logs now clearly show bonus from attending a training course.
  • Renamed character "type" to "archetype".
  • Removed level from skill names.
  • Made some messages more readable.
  • Updated skill coverage language.
  • Made "Trooper" the default rank for approved characters.
  • Updated guidelines.
  • Added additional logging.
  • Added "Medical Mycology" as a medical specialism.
  • Added pronouns to characters and user profiles.
  • Updated wound token language.
  • CodeRabbit/Copilot fixes.
  • Fixed disappearing ranks.

Bugfix: 7th October 2025

  • Researcher: fixed a bug which prevented new research projects from being created.

Bugfix: 30th September 2025

  • Fixed an issue where using research actions for upkeep caused a bug.

Bugfix: 21st September 2025

  • Plot Co: fixed issue with delete buttons causing saves to error.

Bugfix: 3rd September 2025

  • Fixed research project skill names on downtime submission.

Bugfix: 2nd September 2025

  • Fixed research project info on downtime submission.

Update: 1st September 2025

  • Plot Co: added lowest-training character name to info box.
  • Secretary: added toggle to hide non-booked people from attendance screen.
  • Researcher: allow deletion of pending projects.
  • Altered design philosophy to be closer to holy grail design.
  • Added warning for missing skill specialties.
  • Refactored code for better practices.

Bugfix: 27th August 2025

  • Fixed research project view for non-approved projects.

Bugfix: 26th August 2025

  • Fixed research project ordering and increased per-page limit.

Bugfix: 24th August 2025

  • Plot Co: made division not mandatory.
  • Fixed bug with scaling-cost skills for new characters.
  • Refactored skill cost calculations for better caching.
  • Excluded NPCs from skill coverage.
  • Cleaned up code.

Update: 23rd August 2025

  • Added organisation chart.
  • Added feature for players to see skill coverage across characters.
  • Added missing team view.
  • Fixed bug with events disappearing from indexes on the final day of the event.
  • Refactored controllers and views.
  • Improved class loading.

Update: 5th August 2025

  • Plot Co: changed catch-up XP display.
  • Sys Ref: changed catch-up XP display.
  • Changed catch-up XP to be calculated based on the entirety of training, not just downtime training.

Update: 4th August 2025

  • Plot Co: added management of teams, departments, and divisions.
  • Command: added management of teams, departments, and divisions.
  • Added new role: Command.
  • Reorganised research project view.
  • Added ordered lists to the markdown processor.
  • Added teams, departments, and divisions to characters.

Bugfix: 2nd August 2025

  • Plot Co: fixed issues with downtime processing and response saving.
  • Plot Co: fixed issues with long-text research responses in emails.
  • Fixed bug with scaling-cost skills not scaling in cost once on character sheet.

Update: 1st August 2025

  • Plot Co: increased response box height.
  • Secretary: improved event attendance screen for mobile and desktop.

Update: 29th July 2025

  • Plot Co: updated downtime user count to not include crew without characters.
  • Sys Ref: updated Leadership to apply training benefits to the extra person upgrade.
  • Removed seeder references from migrations. Seeders should be run on-demand to avoid clashes with migrations.
  • Added note about where to add specialties to the add skills form.
  • Fixed Leadership skill to properly count the number of people you can affect.
  • Fixed a repeating skill description in the edit skills form.
  • Bug fixes!

Bugfix: 20th July 2025

  • Fixed issue where two teachers could not benefit from each other's courses.
  • Limited downtime actions notes and responses to 2000 characters.

Bugfix: 16th July 2025

  • Updated log tables.

Update: 13th July 2025

  • Updated research project views for better clarity of skill spread.
  • Show skill checks in downtime view for better clarity.
  • Improve formatting.

Update: 12th July 2025

  • Plot Co: make character archetype editable after approval.
  • Added skill selection to research actions.
  • Hid System skills from list of skills for teaching/researching.
  • Updated error appearance on downtime submissions.
  • Updated notes placeholders.
  • Use base skill name on training course list.

Bugfix: 11th July 2025

  • Plot Co: added view as player option.
  • Fixed skill upkeep processing errors.
  • Made research projects only available for completed skills.
  • Changed view of project researchers.

Bugfix: 7th July 2025

  • Fixed downtime processing errors.
  • Refined downtime processed email.
  • Fixed CodeRabbit nitpicks.

Bugfix: 9th July 2025

  • Added skill specialties to research projects.
  • Made downtime open/closed language better for downtimes in the future.
  • Fixed CodeRabbit nitpicks.

Update: 4th July 2025

  • Sys Ref: rules 1.3.1 update.
  • Sys Ref: added abilities to skill check view.
  • Added explanation to help text about catchup XP calculations.
  • Added per-event trackers for feats.
  • Added percentage time discount note for cards.
  • Added list of abilities to character sheets.
  • Removed unnecessary code.
  • Changed reset code to allow for plot updates to remain after reset.
  • Made changes as per suggestions from AI code review.

Update: 1st July 2025

  • Plot Co: added editing and approval capacity for research projects.
  • Plot Co: added facility for personal responses to downtimes.
  • Plot Co: added character traits.
  • Plot Co: added general response field to downtimes.
  • Plot Co: track changes to character traits.
  • Researcher: added editing capacity for research projects.
  • Added research projects.
  • Added research subject action.
  • Added research projects to downtime submissions.
  • Added research projects to downtime email.
  • Added personal action responses to downtime email.
  • Cleaned up code to combine view routes.
  • Fixed bugs with database duplication.
  • Cleaned up button displays.
  • Paginated log displays.
  • Made changes as per suggestions from AI code review.

Tested by Kath, Debi, James, and others

Bugfix: 29th June 2025

  • Plot Co: allow for hidden log notes.

Update: 23rd June 2025

  • Admin: tidied manage roles screen.
  • Secretary: updated attendance lists to show event roles.
  • Plot Co: updated training/catchup XP display.
  • Plot Co: fixed bug in viewing downtime actions.
  • Sys Ref: updated catchup XP calculations to be based solely on downtime training, ignoring characters who have not submitted a downtime.
  • Sys Ref: added catchup XP numbers to Skill Check screen.
  • Sys Ref: rules 1.3 update.
  • Event Runner: removed dedicated role.
  • Event runners now have access to the skill breakdown based on their attendance role for future events.
  • Updated feat display to be clearer regarding uses per day/event and Vigor costs.
  • Added a banner to make it clear when on a test site.
  • Changed "miscellaneous actions" to "personal actions" in downtime and added explanatory text.
  • Fixed bug which blocked character deletions.
  • Made changes as per suggestions from AI code review.

Bugfix: 16th June 2025

  • Secretary: fixed bug with access to executive screen.
  • Added roles page to show the different available roles.

Update: 19th May 2025

  • Plot Co: allow change of user on characters to allow for NPCs to be assigned to plot co user.
  • Plot Co: organise user lists by type.
  • Plot Co: allow direct creation and editing of character logs.
  • Plot Co: removed ability to add completed skills to characters without creating a log.
  • Plot Co: added section for "other abilities" to characters.
  • Track ID of user making changes to characters.
  • Add plot coordinator user for system use.
  • Changed Endurance Training additions from E1 to be permanent Body changes instead.
  • Changed attendance tracking to remove temporary Body/Vigor.
  • Refactored inline scripts to be shared files.
  • Had CodeRabbit do a code review and fixed some bugs as a result.
  • Corrected the parameters for when skill upkeep is required.

Bugfix: 30th April 2025

  • Fixed bug with skill completion during downtime processing.
  • Fixed display bug in downtime processing emails.

Bugfix: 28th April 2025

  • Plot Co: added count of submitted downtimes.
  • Plot Co: added button for editing downtime submissions.
  • Fixed bug with setting played status.

Bugfix: 22nd April 2025

  • Plot Co: added ability to delete downtime actions before processing.
  • Plot Co: show misc actions in downtime view.
  • Secretary: added labels for accessibility.
  • Fixed bug which allowed anyone to submit downtime actions regardless of event attendance.
  • Replaced wording about submitting downtime actions with additional notes.

Update: 20th April 2025

  • Plot Co: add downtime reminder email.
  • Plot Co: fixed bug with printing characters.
  • Remove attendance feature from characters.
  • Fixed Botch Job showing up erroneously on bulk prints.
  • Changed formatting of print skills.

Bugfix: 17th April 2025

  • Plot Co: fixed event skill breakdown.

Minor updates: 15th April 2025

  • Plot Co: now has event editing permission.
  • Added CTA to downtime announcements.
  • Teachers now get the number of trainees when checking their downtime submission.
  • Empty miscellaneous actions are now removed.
  • Fixed some issues with training course information display.
  • Aligned language on preprocess downtime view.
  • Limited emails when testing to prevent upsetting Mailtrap.
  • Expert Knowledge skills no longer trained by main skill.
  • Fixed potential exploit where a character could double their training from a single course.

Bugfix: 13th April 2025

  • Fixed bug with skill training seeding.
  • Fixed timezone display and saving.
  • Fixed bug with skill training costs on downtime submission.
  • Fixed bug with Research Action display.
  • Fixed bug with Misc Action saving and display.
  • Added better notes around teaching and training.
  • Fixed a broken icon.
  • Fixed the email header to use the logo.
  • Improved display of downtime indexes.
  • Adapted downtime processing to handle over-training a skill.

Release: 12th April 2025

  • Executive: combined menu options.
  • Plot Co: added downtime system.
  • Plot Co: added handling of plot changes to characters.
  • Secretary: added event editing system.
  • Secretary: added event attendance system.
  • Secretary: added paid downtimes.
  • Event Runner: added access to skills breakdown view.
  • Sys Ref: added skill description to skill check view.
  • Added Secretary and Event Runner roles.
  • Changed attendance tracking to be attached to users, not characters.
  • Added support for paid downtimes.
  • Added system to track which basic skills can be trained by full skill teaching.
  • Added downtime submission system.
  • Played characters can no longer be deleted.
  • Background skills are now added to trained skills list.
  • Unified layouts to allow for global notices.
  • Added global notice when downtime is open.
  • Added success messaging.
  • Added success and info states for global notices.
  • Customised emails with Stargate branding.
  • Added inactive state for characters.
  • Improved skill description display universally.
  • Added handling of resuscitation.
  • Reorganised character actions.
  • Aligned gap styling on character pages.
  • Fixed timezone issues.
  • Updated rules in line with the 1.2 update.
    • Updated skill and feat descriptions.
    • Character creation months are now adjusted in line with lowest trained months.
    • Added Self-Defense skill.
    • Added Primitive Weapons as alternate prerequisite for Accuracy Training.
    • Updated printed character sheet with new information on Critical/bleeding.

Tested by Ben B, Fraser, Kat, and Orev

Update: 10th March 2025

  • Added facility to let players edit their characters after approval.
  • Bug fixes related to short names.
  • Added extra text around purpose of short names.
  • Fixed confirm dialogs.

Tested by Orev

Update: 24th February 2025

  • Applied new SEF logo made by Charlie based on the initial design by Mark.

Update: 8th February 2025

  • Updated character links to be include character name (old links will still work).
  • Fixed issue with scaling-costs display for approved characters.
  • Added random name generator to character create/edit screen at request.
  • Fixed some validation and made minor wording changes.
  • Plot Co: enabled editing of ranks.
  • Plot Co: add character links to skills breakdown.
  • Hide former ranks from display if new rank assigned.
  • Add short name editing and display.
  • Implemented soft-deletion of users.
  • Add wounded and bleeding state notes to character sheet.
  • Change buttons to use a combined icon/text appearance and unify appearance across site.

Tested by Debi

Bugfix: 13th January 2025

  • Plot Co: Fixed skills breakdown to only have one row per character and include background skills.
  • Updated privacy policy to include contact email address.

Update: 11th January 2025

  • Added changelog
  • Added mobile improvements
  • Added expandable descriptions for skills and feats to character view
  • Updated text field validation to match lengths
  • Added primary/secondary typing to characters
  • Added hero/scoundrel typing to characters
  • Added notice if your name is not unique
  • Admin: Added ability to manage roles
  • Plot Co: Added per-event breakdown to skills breakdown view
  • Plot Co: Added notification for characters becoming ready for approval
  • Plot Co: Added note to show who a character belongs to
  • Add player name to print sheet
  • Add print skills/feats view to characters
  • Improve mobile navigation and styling
  • Add favicon
  • Bug fixes

Tested by Gregg

Release: 5th January 2025

  • Initial release
  • Emergency bug fixes
  • Correcting Point Man cost

Tested by Kat and Topper; feat text entered by Ki