com web/bugs: List responses. Some are outdated (e.g., trysnapshot54) so this will show that. Next, add interface to edit these. IMHO they should be
stored in source code and not in a DB.: www/admin/index.php

Commit: 1ac04b11a3bab4fcfb1b2a02e531d12c208b1743 Author: philip <philip@roshambo.org> Tue, 24 May 2016 10:55:55 -0700 Parents: 3e8bec9f8d9a0b218978a08ddf5713cc200be163 Branches: master Link: http://git.php.net/?p=web/bugs.git;a=commitdiff;h=1ac04b11a3bab4fcfb1b2a02e531d12c208b1743 Log: List responses. Some are outdated (e.g., trysnapshot54) so this will show that. Next, add interface to edit these. IMHO they should be stored in source code and not in a DB. Changed paths: M www/admin/index.php Diff: diff --git a/www/admin/index.php b/www/admin/index.php index e240d4c..cec071a 100644 --- a/www/admin/index.php +++ b/www/admin/index.php @@ -12,7 +12,7 @@ if (!$logged_in) { exit; } -$actions = array('list_lists', 'phpinfo'); +$actions = array('list_lists', 'list_responses', 'phpinfo'); $action = !empty($_GET['action']) && in_array($_GET['action'], $actions) ? $_GET['action'] : 'list_lists'; if ($action === 'phpinfo') { @@ -39,4 +39,27 @@ if ($action === 'list_lists') { echo "</dl>\n"; } +if ($action === 'list_responses') { + + $res = $dbh->query(" + SELECT id name, status, title, message, project, package_name, webonly + FROM bug_resolves + ORDER BY name + "); + + echo "<h3>List Responses</h3>"; + echo "<dl>\n"; + while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) { + echo "<dt>", $row['name'], " (", $row['id'], "): </dt>\n"; + echo "<dd>", $row['title'], "</dd>\n"; + echo "<dd>", $row['status'], "</dd>\n"; + echo "<dd>", $row['project'], "</dd>\n"; + echo "<dd>", $row['package_name'], "</dd>\n"; + echo "<dd>", $row['webonly'], "</dd>\n"; + echo "<dd>", $row['message'], "</dd>\n"; + } + echo "</dl>\n"; + +} + response_footer();