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

Changelog

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