15 if (defined $create) {
17 foreach my $k (keys %ARGS) {
18 if ($k =~ m/^t_(\d{0,7})$/) {
23 die unless defined $textid;
28 if ($ARGS{'create'}) {
29 my $date = `date --iso-8601=minutes`; chomp $date or die;
30 $tx = { desc => "Message created $date",
31 subject => "Away from my email",
35 my $sth = $dbh->prepare("SELECT * FROM texts WHERE textid=?");
36 $sth->execute($textid);
37 $tx = $sth->fetchrow_hashref();#
40 my $usedq = $dbh->prepare(<<END);
43 LEFT JOIN addresses USING (emailaddr)
44 LEFT JOIN texts USING (textid)
49 if (!$tx) { die "no such text $textid"; }
52 <& htmlhead, subpage => "Edit \"$tx->{'desc'}\"" &>
53 <form action="save" method="post">
54 <&| txtable, tx => $tx, inputs => 1 &>
55 <tr><td colspan=2><textarea name="text" cols="79" rows="15"><%
56 $tx->{'text'} |h %></textarea></td></tr>
59 % while (my $row = $usedq->fetchrow_hashref()) {
60 <tr><td>Use for <% $row->{'emailaddr'} |h %></td>
61 <td><input type="checkbox" value="1" name=u_<% hquote($row->{'emailaddr'}) %>
62 % if (!$create && $row->{'textid'} eq $textid) {
63 checked></td><td>(currently using this message)
64 % } elsif (defined $row->{'textid'}) {
65 ></td><td>(currently using another message "<% $row->{'desc'} |h %>")
72 <input type="hidden" name="textid" value="<% $tx->{'textid'} %>">
73 <input type="submit" name="save" value="Save">
74 <input type="submit" name="cancel" value="Cancel edit">