ComputerTech312
cd27cc8ad9
- Switch to single Gunicorn worker to eliminate SQLite database locking issues - Remove Flask-Limiter and all rate limiting complexity - Remove Cloudflare proxy setup and dependencies - Simplify configuration and remove unnecessary features - Update all templates and static files for streamlined operation - Clean up old files and documentation - Restore stable database from backup - System now runs fast and reliably without database locks
233 lines
11 KiB
HTML
233 lines
11 KiB
HTML
<!DOCTYPE html>
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>ircquotes: Admin Panel</title>
|
|
<link rel="stylesheet" href="{{ url_for('static', filename='styles.css') }}" />
|
|
<script>
|
|
// Prevent flash of white content by applying theme immediately
|
|
(function() {
|
|
const savedTheme = localStorage.getItem('theme');
|
|
const prefersDark = window.matchMedia && window.matchMedia('(prefers-color-scheme: dark)').matches;
|
|
if (savedTheme === 'dark' || (!savedTheme && prefersDark)) {
|
|
document.documentElement.className = 'dark-theme';
|
|
}
|
|
})();
|
|
</script>
|
|
<script src="{{ url_for('static', filename='theme.js') }}"></script>
|
|
<script src="{{ url_for('static', filename='modapp.js') }}"></script>
|
|
</head>
|
|
<body bgcolor="#ffffff" text="#000000" link="#c08000" vlink="#c08000" alink="#c08000">
|
|
|
|
<!-- Navigation -->
|
|
<center>
|
|
<table cellpadding="2" cellspacing="0" width="80%" border="0">
|
|
<tr>
|
|
<td bgcolor="#c08000" align="left">
|
|
<font size="+1"><b><i>ircquotes</i></b></font>
|
|
</td>
|
|
<td bgcolor="#c08000" align="right">
|
|
<font face="arial" size="+1"><b>Admin Panel</b></font>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<table cellpadding="2" cellspacing="0" width="80%" border="0">
|
|
<tr>
|
|
<td class="footertext" align="left" bgcolor="#f0f0f0"></td>
|
|
<td align="right" bgcolor="#f0f0f0" class="toplinks" colspan="2">
|
|
<a href="/">Home</a> /
|
|
<a href="/random">Random</a> /
|
|
<a href="/submit">Submit</a> /
|
|
<a href="/browse">Browse</a> /
|
|
<a href="/modapp">Modapp</a>
|
|
<button id="theme-toggle" onclick="toggleDarkMode()" title="Toggle dark/light mode">🌙</button>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</center>
|
|
|
|
<!-- Main Content: All Quotes for Moderation -->
|
|
<center>
|
|
<h2>All Quotes for Moderation</h2>
|
|
|
|
<!-- Filter Options -->
|
|
<form method="GET" action="/modapp">
|
|
<label for="filter">Filter by:</label>
|
|
<select name="filter" id="filter">
|
|
<option value="pending" {% if filter_status == 'pending' %}selected{% endif %}>Pending</option>
|
|
<option value="approved" {% if filter_status == 'approved' %}selected{% endif %}>Approved</option>
|
|
<option value="rejected" {% if filter_status == 'rejected' %}selected{% endif %}>Rejected</option>
|
|
<option value="flagged" {% if filter_status == 'flagged' %}selected{% endif %}>Flagged</option>
|
|
</select>
|
|
<input type="submit" value="Apply Filter">
|
|
</form>
|
|
|
|
{% if quotes.items %}
|
|
<!-- Bulk Actions Form -->
|
|
<form id="bulk-action-form" method="POST" action="/modapp/bulk">
|
|
<input type="hidden" name="csrf_token" value="{{ csrf_token() }}"/>
|
|
<div style="margin: 10px 0; padding: 10px; background-color: #f0f0f0; border: 1px solid #ccc;">
|
|
<b>Bulk Actions:</b>
|
|
<input type="checkbox" id="select-all" onchange="toggleAllCheckboxes(this)"> <label for="select-all">Select All</label>
|
|
|
|
<button type="submit" name="action" value="approve" class="qa" onclick="return confirmBulkAction('approve')">Bulk Approve</button>
|
|
<button type="submit" name="action" value="reject" class="qa" onclick="return confirmBulkAction('reject')">Bulk Reject</button>
|
|
<button type="submit" name="action" value="delete" class="qa" onclick="return confirmBulkAction('delete')">Bulk Delete</button>
|
|
<button type="submit" name="action" value="clear_flags" class="qa" onclick="return confirmBulkAction('clear flags')">Clear All Flags</button>
|
|
</div>
|
|
|
|
<!-- Table for Quotes -->
|
|
<div class="modapp-table-container">
|
|
<table border="1" cellpadding="5" cellspacing="0" width="100%">
|
|
<tr>
|
|
<th>Select</th>
|
|
<th>Quote ID</th>
|
|
<th>Quote</th>
|
|
<th>Status</th>
|
|
<th>Flags</th>
|
|
<th class="mobile-hide">Submitted At</th>
|
|
<th class="mobile-hide">IP Address</th>
|
|
<th class="mobile-hide">User Agent</th>
|
|
<th>Actions</th>
|
|
</tr>
|
|
<!-- Loop through quotes -->
|
|
{% for quote in quotes.items %}
|
|
<tr style="background-color:
|
|
{% if quote.flag_count > 5 %} #ffcccc {% elif quote.flag_count > 2 %} #ffe6cc {% elif quote.status == 1 %} #d4edda {% elif quote.status == 2 %} #f8d7da {% else %} #fff {% endif %}">
|
|
<td><input type="checkbox" name="quote_ids" value="{{ quote.id }}" class="quote-checkbox"></td>
|
|
<td>#{{ quote.id }}</td>
|
|
<td>{{ quote.text|e }}</td>
|
|
<td>
|
|
{% if filter_status == 'flagged' %}
|
|
<!-- Prominent status display for flagged quotes -->
|
|
{% if quote.status == 0 %}
|
|
<span style="background-color: #fff3cd; padding: 2px 6px; border-radius: 3px; font-weight: bold;">⚠️ PENDING + FLAGGED</span>
|
|
{% elif quote.status == 1 %}
|
|
<span style="background-color: #d4edda; padding: 2px 6px; border-radius: 3px; font-weight: bold;">✅ APPROVED + FLAGGED</span>
|
|
{% else %}
|
|
<span style="background-color: #f8d7da; padding: 2px 6px; border-radius: 3px; font-weight: bold;">❌ REJECTED + FLAGGED</span>
|
|
{% endif %}
|
|
{% else %}
|
|
<!-- Normal status display -->
|
|
{% if quote.status == 0 %}
|
|
Pending
|
|
{% elif quote.status == 1 %}
|
|
Approved
|
|
{% else %}
|
|
Rejected
|
|
{% endif %}
|
|
{% endif %}
|
|
</td>
|
|
<td>
|
|
{% if quote.flag_count > 0 %}
|
|
<span style="color: red; font-weight: bold;">{{ quote.flag_count }}</span>
|
|
{% else %}
|
|
0
|
|
{% endif %}
|
|
</td>
|
|
<td class="mobile-hide">
|
|
{% if quote.submitted_at %}
|
|
{{ quote.submitted_at.strftime('%d/%m/%y %H:%M:%S') }}
|
|
{% elif quote.date %}
|
|
{{ quote.date.strftime('%d/%m/%y') }} (legacy)
|
|
{% else %}
|
|
No date
|
|
{% endif %}
|
|
</td>
|
|
<td class="mobile-hide">{{ quote.ip_address|e }}</td>
|
|
<td class="mobile-hide">{{ quote.user_agent|e|truncate(50) }}</td>
|
|
<td>
|
|
{% if filter_status == 'flagged' %}
|
|
<!-- Special actions for flagged quotes -->
|
|
{% if quote.status == 1 %}
|
|
<!-- Already approved but flagged -->
|
|
<a href="/clear_flags/{{ quote.id }}" style="color: blue;">Clear Flags</a> |
|
|
<a href="/reject/{{ quote.id }}" style="color: orange;">Reject</a> |
|
|
<a href="/delete/{{ quote.id }}" style="color: red;">Delete</a>
|
|
{% elif quote.status == 0 %}
|
|
<!-- Pending and flagged -->
|
|
<a href="/approve/{{ quote.id }}" style="color: green;">Approve</a> |
|
|
<a href="/clear_flags/{{ quote.id }}" style="color: blue;">Clear Flags</a> |
|
|
<a href="/reject/{{ quote.id }}" style="color: orange;">Reject</a> |
|
|
<a href="/delete/{{ quote.id }}" style="color: red;">Delete</a>
|
|
{% else %}
|
|
<!-- Rejected and flagged -->
|
|
<a href="/clear_flags/{{ quote.id }}" style="color: blue;">Clear Flags</a> |
|
|
<a href="/delete/{{ quote.id }}" style="color: red;">Delete</a>
|
|
{% endif %}
|
|
{% else %}
|
|
<!-- Standard actions for non-flagged quotes -->
|
|
<a href="/approve/{{ quote.id }}">Approve</a> |
|
|
<a href="/reject/{{ quote.id }}">Reject</a> |
|
|
<a href="/delete/{{ quote.id }}">Delete</a>
|
|
{% endif %}
|
|
</td>
|
|
</tr>
|
|
{% endfor %}
|
|
</table>
|
|
</div>
|
|
</form>
|
|
|
|
<!-- Bulk Actions JavaScript -->
|
|
<script>
|
|
function toggleAllCheckboxes(selectAllCheckbox) {
|
|
const checkboxes = document.querySelectorAll('.quote-checkbox');
|
|
checkboxes.forEach(checkbox => {
|
|
checkbox.checked = selectAllCheckbox.checked;
|
|
});
|
|
}
|
|
|
|
function confirmBulkAction(action) {
|
|
const selectedCheckboxes = document.querySelectorAll('.quote-checkbox:checked');
|
|
if (selectedCheckboxes.length === 0) {
|
|
alert('Please select at least one quote.');
|
|
return false;
|
|
}
|
|
|
|
const count = selectedCheckboxes.length;
|
|
const message = `Are you sure you want to ${action} ${count} selected quote(s)?`;
|
|
return confirm(message);
|
|
}
|
|
</script>
|
|
|
|
<!-- Pagination Links -->
|
|
<div id="pagination">
|
|
{% if quotes.has_prev %}
|
|
<a href="{{ url_for('modapp', page=quotes.prev_num, filter=filter_status) }}">« Previous</a>
|
|
{% endif %}
|
|
<span>Page {{ quotes.page }} of {{ quotes.pages }}</span>
|
|
{% if quotes.has_next %}
|
|
<a href="{{ url_for('modapp', page=quotes.next_num, filter=filter_status) }}">Next »</a>
|
|
{% endif %}
|
|
</div>
|
|
|
|
{% else %}
|
|
<p>No quotes available for moderation.</p>
|
|
{% endif %}
|
|
</center>
|
|
|
|
<!-- Footer -->
|
|
<center>
|
|
<table border="0" cellpadding="2" cellspacing="0" width="80%" bgcolor="#c08000">
|
|
<tr>
|
|
<td bgcolor="#f0f0f0" class="toplinks" colspan="2">
|
|
<a href="/">Home</a> /
|
|
<a href="/random">Random</a> /
|
|
<a href="/submit">Submit</a> /
|
|
<a href="/browse">Browse</a> /
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="footertext" align="left"> </td>
|
|
<td class="footertext" align="right">
|
|
{{ approved_count }} quotes approved; {{ pending_count }} quotes pending; {{ rejected_count }} quotes rejected;
|
|
<span style="color: red; font-weight: bold;">{{ flagged_count }} quotes flagged</span>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</center>
|
|
|
|
</body>
|
|
</html>
|