Admin Settings

{% with messages = get_flashed_messages(with_categories=true) %} {% if messages %}
{% for category, message in messages %}

{{ message }}

{% endfor %}
{% endif %} {% endwith %}

Database Health

{% if health.ok %}

✅ {{ health.message }}

{% else %}

❌ {{ health.message }}

{% if health.missing_columns %}

Missing columns: {{ health.missing_columns | join(', ') }}

{% endif %} {% endif %}

Database Statistics

Total requests: {{ total_records }}

Database size: {{ db_size }}

Uploaded MP3s: {{ upload_file_count }} files in {{ upload_dir_count }} request folders

Uploads total size: {{ upload_size }}

{% if status_counts %}

Status breakdown:

    {% for status, count in status_counts.items() %}
  • {{ status }}: {{ count }}
  • {% endfor %}
{% endif %}

Database path:
{{ db_path }}

Uploads path:
{{ upload_path }}

Revision Limit

Set to 0 to disable customer-submitted revisions. Operators can still upload new versions manually.

MP3 Metadata Tags

These values are written into every uploaded MP3 file. The song title from the prompt is written to the Title tag automatically. Blank fields are skipped.

Artist
Album
Year
Genre
Comment

⚠️ Reset System

Use this only at the start of a new event. It will delete every request and every uploaded MP3 file. This cannot be undone.