{% include 'admin/partials/header.html' %}{% include 'admin/partials/sidebar.html' %}
<div class="acp-page-head"><div><span class="eyebrow">System diagnostics</span><h1>Developer Tools</h1><p>Inspect runtime performance, execute controlled SQL, and maintain development caches.</p></div><form method="post" action="{{ $baseUrl }}/admin/debug/clear-cache"><input type="hidden" name="_token" value="{{ $csrfToken }}"><button class="acp-secondary" type="submit">Clear template cache</button></form></div>
<div class="debug-warning"><b>Administrator-only area</b><span>SQL can permanently alter the board. Create a database backup before running write statements.</span></div>
<section class="debug-metric-grid"><article><strong>{{ $runtime['load_ms'] }} ms</strong><span>Current request</span></article><article><strong>{{ $runtime['queries'] }}</strong><span>Database queries</span></article><article><strong>{{ $runtime['query_ms'] }} ms</strong><span>Query time</span></article><article><strong>{{ $runtime['memory_mb'] }} MB</strong><span>Peak memory</span></article><article><strong>PHP {{ $runtime['php'] }}</strong><span>{{ $serverSoftware }}</span></article><article><strong>{{ $runtime['driver'] }}</strong><span>Database driver</span></article></section>
<div class="debug-layout"><section class="dash-card debug-console"><div class="dash-card-head"><div><h2>SQL console</h2><p>Read-only statements run immediately. Writes require an explicit confirmation.</p></div></div><form method="post" action="{{ $baseUrl }}/admin/debug/sql"><input type="hidden" name="_token" value="{{ $csrfToken }}"><textarea name="sql" rows="10" spellcheck="false" placeholder="SELECT * FROM members ORDER BY id DESC LIMIT 25;"></textarea><div class="debug-console-options"><label><input type="checkbox" name="allow_write" value="1" data-sql-write-toggle> Allow INSERT, UPDATE, DELETE, ALTER, CREATE, or DROP TABLE</label><label data-sql-confirm hidden>Type <b>RUN SQL</b><input name="confirmation" autocomplete="off" placeholder="RUN SQL"></label></div><footer><small>One statement per execution. Results are limited to 200 displayed rows.</small><button class="acp-primary" type="submit">Execute SQL</button></footer></form></section>
<section class="dash-card debug-environment"><div class="dash-card-head"><div><h2>Environment</h2><p>Runtime and storage overview.</p></div></div><dl><div><dt>PHP version</dt><dd>{{ $runtime['php'] }}</dd></div><div><dt>Server</dt><dd>{{ $serverSoftware }}</dd></div><div><dt>Database</dt><dd>{{ $runtime['driver'] }}</dd></div><div><dt>Loaded extensions</dt><dd>{{ count($phpExtensions) }}</dd></div><div><dt>Known tables</dt><dd>{{ count($tables) }}</dd></div></dl><details><summary>PHP extensions</summary><div class="debug-chip-list">{% foreach $phpExtensions as $extension %}<span>{{ $extension }}</span>{% endforeach %}</div></details><details><summary>Database tables</summary><div class="debug-chip-list">{% foreach $tables as $table %}<span>{{ implode(', ', $table) }}</span>{% endforeach %}</div></details></section></div>
{% if $sqlResult %}<section class="dash-card debug-results"><div class="dash-card-head"><div><h2>SQL result</h2><p>{{ $sqlResult['verb'] }} · {{ $sqlResult['affected'] }} affected row(s)</p></div></div>{% if $sqlResult['rows'] %}<div class="debug-result-scroll"><table><thead><tr>{% foreach $sqlResult['columns'] as $column %}<th>{{ $column }}</th>{% endforeach %}</tr></thead><tbody>{% foreach $sqlResult['rows'] as $row %}<tr>{% foreach $row as $value %}<td>{{ is_scalar($value)?$value:json_encode($value) }}</td>{% endforeach %}</tr>{% endforeach %}</tbody></table></div>{% else %}<div class="empty-admin-state">The statement completed without a result set.</div>{% endif %}</section>{% endif %}
<section class="dash-card debug-history"><div class="dash-card-head"><div><h2>Recent SQL activity</h2><p>All console executions are retained for accountability.</p></div></div><div class="debug-history-list">{% foreach $history as $entry %}<article><span class="status-pill {{ $entry['success']?'resolved':'open' }}">{{ $entry['success']?'Success':'Failed' }}</span><div><b>{{ $entry['statement_type'] }} by {{ $entry['username'] }}</b><code>{{ $entry['sql_text'] }}</code><small>{{ $entry['created_at'] }} · {{ $entry['execution_ms'] }} ms · {{ $entry['affected_rows'] }} affected</small>{% if $entry['error_message'] %}<em>{{ $entry['error_message'] }}</em>{% endif %}</div></article>{% endforeach %}</div></section>
{% include 'admin/partials/footer.html' %}