18 if (defined $create) {
20 foreach my $k (keys %ARGS) {
21 if ($k =~ m/^t_(\d{0,7})$/) {
26 die unless defined $textid;
31 if ($ARGS{'create'}) {
32 my $date = `date --iso-8601=minutes`; chomp $date or die;
33 $tx = { desc => "Message created $date",
34 subject => "Away from my email",
38 my $sth = $dbh->prepare("SELECT * FROM texts WHERE textid=?");
39 $sth->execute($textid);
40 $tx = $sth->fetchrow_hashref();#
43 my $usedq = $dbh->prepare(<<END);
46 LEFT JOIN addresses USING (emailaddr)
47 LEFT JOIN texts USING (textid)
52 if (!$tx) { die "no such text $textid"; }
55 <& htmlhead, subpage => "Edit \"$tx->{'desc'}\"" &>
56 <form action="save" method="post">
57 <% $ar->secret_hidden_html() %>
58 <&| txtable, tx => $tx, inputs => 1 &>
59 <tr><td colspan=2><textarea name="text" cols="79" rows="15"><%
60 $tx->{'text'} |h %></textarea></td></tr>
63 % while (my $row = $usedq->fetchrow_hashref()) {
64 <tr><td>Use for <% $row->{'emailaddr'} |h %></td>
65 <td><input type="checkbox" value="1" name=u_<% hquote($row->{'emailaddr'}) %>
66 % if (!$create && $row->{'textid'} eq $textid) {
67 checked></td><td>(currently using this message)
68 % } elsif (defined $row->{'textid'}) {
69 ></td><td>(currently using another message "<% $row->{'desc'} |h %>")
76 <input type="hidden" name="textid" value="<% $tx->{'textid'} %>">
77 <input type="submit" name="save" value="Save">
78 <input type="submit" name="cancel" value="Cancel edit">