Glicko DB

User Interface Help

See the route and integration notes and the English README. You can also open this guide from the ? button in the top navigation or at /help?lang=en.

Table of contents

Public interface

No account is required for /, /rankings, /players, /player/view?id=<player_id>, /matches, /tournaments, /tournaments/<tournament_id>, /reports, /category, and /sgf-library. These pages provide rankings, player profiles, match history, public tournaments, standings, rating information, reports, and SGF viewing or downloads.

Public home page

The public home page provides navigation, language and theme controls, rankings, statistics, and links to public content.

Player directory

The player directory is used to browse profiles and filter the public player list.

Pages accept ?lang=es, ?lang=en, or ?lang=pt; use YYYY-MM-DD in date filters and fields.

Rankings and player directory

Public rankings table

Official rankings sorted by Glicko-2 rating with category indicators and recent form.

Public profile for Acuña, Carlos

Public profile with current rating, category, and activity summary for the selected player.

Matches and SGF viewer

Public match list

Global match list with filters, SGF library link, and viewing actions.

SGF viewer for a match

Linked match SGF viewer with playback controls, theme switch, and download action.

Public tournaments

Public tournaments

List of public tournaments showing status, system, and round count.

Public tournament details

Tournament details with round selector, board pairings, results, and standings.

Period reports and export

Reports and statistics

Period reports with date and player filters plus CSV and PDF download options.

Category converter

The /category page converts a Glicko rating to a Dan/Kyu category and displays the formula, configured constants, and complete scale.

Public category converter

Rating-to-category converter with input field and calculation button.

Public news

The /news/<article_id> page displays a published article and turns player, tournament, and match tags into related links.

Public news article

Published article with related links to players, tournaments, and matches.

SGF library

The public library (/sgf-library) indexes all SGF game records uploaded to the platform: - Validates file size, UTF-8 character encoding, and syntactic SGF structure. - Automatically synchronizes root SGF properties (White/Black players, ranks, event, date, and result) with the linked database match. - If an SGF file is deleted from the server filesystem, stale database links are cleaned automatically to prevent broken URLs. - Unlinking a record or deleting its match retains the file in the library; only administrators can permanently delete physical files.

Public SGF library

SGF library with metadata, linked matches, and viewer links.

SGF library record

An SGF record opened from the library, with metadata and viewer controls.

Member interface

Community players can register a personal account to manage preferences and submit results for organized tournaments and club games.

Account registration and login

  1. Open /admin/register to create an account with username, email, and password (minimum 8 characters). The form is protected by Google reCAPTCHA v3.
  2. New accounts are automatically assigned the member role.
  3. Ask an administrator or operator to link your user account to your player record at /admin/users.
  4. Sign in at /admin/login.

Administrator login

Administrator login form with registration and password-recovery links.

Member account registration

Member account registration form with email and password confirmation.

Profile management

From /admin/profile, authenticated users can: - Update their notification and recovery email address. - Select their preferred UI language (Español, English, Português). - Toggle between Light and Dark application themes. - Choose their IANA timezone with current UTC offset (e.g., America/Bogota [UTC-05:00], America/New_York, Europe/London). - Change password by providing their current password and confirming the new one.

Member profile

User profile settings for language, theme, timezone, and password management.

Password recovery

  1. If you forget your password, click Forgot password? on /admin/login or navigate to /admin/forgot-password.
  2. Enter your registered email address. If found, the system dispatches a single-use cryptographically hashed reset link.
  3. Reset links expire according to PASSWORD_RESET_TTL_SECONDS (default: 3600 seconds / 1 hour).
  4. Open /admin/reset-password/<token> to choose a new password. For security, responses never reveal whether an email address exists.

Password recovery request

Request for a recovery link using the registered email address.

Password reset form

Form for setting a new password from a reset token.

Reporting results

Members can submit match results at /admin/report-results:

  1. Mandatory prerequisite: the user account must be linked to an active player record by an administrator.
  2. Submission form:
    • Opponent: select the rival player from active players.
    • Color: select whether you played as White or Black.
    • Result: indicate White wins (1-0), Black wins (0-1), or Draw (1/2-1/2).
    • Date: match date (YYYY-MM-DD).
    • Event & Location: tournament or club event name and venue.
    • Round: round number if applicable.
    • Handicap stones: handicap stones (0 to 9) given to Black.
    • SGF file (optional): upload the .sgf game record.
  3. Queue & moderation: submitted matches enter the Pending moderation queue (/admin/result-submissions). They do not affect rankings, ratings, or reports until reviewed and approved by tournament staff.

Member result submission

The member result screen shows the linked-player requirement and pending-submission area.

Administrator panel

Sign in at /admin/login with an administrative account. Available navigation adapts to the assigned account role: - member: profile settings and match reporting for linked player. - tournament_director: complete tournament management (participants, pairings, rounds, results, and exports). - operator: all tournament functions plus match management, data imports, SGF library, news, and result moderation. - administrator: full system control including players, rating/category configurations, database backups, user accounts, audit review, and settings.

Administrator dashboard

The dashboard groups controls into tournament operations, data management, and administration and access. Select Abrir on a card to open that area.

Tournament management

1. Creating and configuring tournaments (/admin/tournaments)

Tournament administration

The tournament page provides controls for creating tournaments, selecting the pairing system, and opening tournament operations.

Advanced tournament settings

Tournament settings with dates, rounds, BYE/absence points, handicap, and acceleration options.

2. Managing participants

Tournament participant management

Participant management with the current list, existing-player selector, and pending-player creation.

3. Pairings, rounds, and entering results

Tournament round and pairings

Tournament round control panel: board pairings, result selector, handicap stones, and standings.

4. Round processing and rating updates

Data management

1. Import assistant with preview (/admin/import)

Import historical workbooks, match spreadsheets, or OpenGotha files: - Accepted formats: - Excel workbook (.xlsx or .xls): replaces the active dataset with full players and matches. - OpenGotha XML (.xml): imports tournament metadata, participants, pairings, and handicap stones. - Match CSV (.csv): columns date, white, black, result, and optional handicap (0-9). - Create a backup before importing a workbook that replaces the active data. - Explicit player reconciliation: - Previews classify rows as Exact match, Fuzzy suggestion, New player, or Duplicate. - Operators choose to link to existing players, create new players, or reject rows. - Metadata can be reviewed and edited before committing. - CSV validation errors abort the import cleanly without partial database commits.

Import controls

The import screen uses the file picker to select an Excel, CSV, or OpenGotha file, then Importar to start preview and reconciliation.

Import preview and reconciliation

OpenGotha preview with editable metadata, match summary, and per-player decisions.

2. Player administration (/admin/players)

Administrative player list

Administrative player list with filters, Glicko range, status, and edit actions.

Editing Acuña, Carlos

Player editor with name, initial rating, club, country, and active-status fields.

3. Match administration (/admin/matches)

Add match form

New-match form with players, result, date, round, handicap, and optional SGF upload.

Edit match form

Pre-filled edit form for correcting an existing match.

Match administration

Match administration table with date/player filters and edit, delete, and SGF management tools.

4. Rating and category configuration (/admin/ratings and /admin/categories)

Administrative rating configuration

Rating panel with Glicko-2 parameters, history counts, and recalculation actions.

Administrative category configuration

Dan/Kyu formula configuration with a preview of category changes.

5. Result moderation queue (/admin/result-submissions)

Administrative result queue

Moderation queue with status filter, match details, and approve/reject actions.

Operational and security tasks

1. Backups and restore (/admin/backups)

Backup management

Backup list with create, restore, and delete actions.

2. User account management (/admin/users)

User account list

Account list showing role, linked player, timezone, status, and actions.

Create user account

Form for creating an account and assigning its role, linked player, and timezone.

Editing docs_admin linked to Acuña, Carlos

Editing docs_admin, showing the Acuña, Carlos player link and account permissions.

3. News publishing (/admin/news)

Administrative news list

News list with publication status, update date, and actions.

New news article

New-article form with immediate publication and smart-link fields.

Edit news article

Pre-filled form for editing an article body, status, and related links.

4. Audit review (/admin/audit)

Audit review

Administrative audit log with filtering by user, action category, and date range.

5. Application security settings (/admin/settings)

Security settings

Administrative parameters for login attempts, rate-limit window, and recovery-link TTL.

Troubleshooting guide

  1. Access Forbidden (403): verify that your account has the required role (tournament_director, operator, or administrator) for the requested section.
  2. Cannot submit results as member: confirm in /admin/users that your user account is linked to an active player record.
  3. Import failures: - Ensure CSV files use UTF-8 encoding and contain required headers date, white, black, result. - Verify date format is YYYY-MM-DD and results are 1-0, 0-1, or 1/2-1/2. - Ensure handicap stones are within the valid 0-9 range.
  4. Missing SGF records: if an SGF file is deleted from disk, the system clears the link automatically. Re-upload the file from /admin/matches or the SGF library.
  5. Database restoration: after restoring a backup, allow schema migrations and FTS5 indexing to complete before serving requests.
  6. Production security: store secrets (APP_SECRET_KEY, ADMIN_PASSWORD, SMTP credentials, reCAPTCHA keys) in server environment variables, never in source control.
^