<%perl>
$sth = $dbh->prepare(<<END);
SELECT *
- FROM addresses
- LEFT JOIN config USING (emailaddr)
+ FROM config
+ LEFT JOIN addresses USING (emailaddr)
LEFT JOIN texts USING (textid)
ORDER BY emailaddr
END
$sth->execute();
</%perl>
% while (my $row= $sth->fetchrow_hashref()) {
+<form action="edit" method="get">
<h3>Message "<% $row->{'desc'} |h %>"</h3>
-<table>
-<tr><td>Short name:</td><td><% $row->{'desc'} |h %></td></tr>
-<tr><td>Expires:</td><td><%
- expirestime2show(expires2timet($row->{'expires'}))
- |h %></td></tr>
-<tr><td>Subject:</td>
- <td><code><% $row->{'subject'} |h %></code></td></tr>
-</table>
-<p>
+
+<&| txtable, tx => $row &>
+% $sthi->execute($row->{'textid'});
+% while (my $rowi= $sthi->fetchrow_hashref()) {
+<tr><td>Used for:</td><td><% $rowi->{'emailaddr'} |h %></td></tr>
+% }
+</&>
<pre>
<% $row->{'text'} |h %>
</pre>
+
+<input type="submit" name="t<% $row->{'textid'} %>"
+ value="Edit or configure this message">
% }
+<h3>Add new message</h3>
+<input type="submit" name="create"
+ value="Start adding new message">
+</form>