$VERSION = 1.00;
@ISA = qw(Exporter);
@EXPORT = qw(db_connect db_commit
- expires2timet expirestime2show
$dbh);
%EXPORT_TAGS = ( );
@EXPORT_OK = qw();
}
}
-sub expires2timet ($) {
- my ($str) = @_;
- if ($str eq '' or $str =~ m/never/i) {
- return undef;
- }
- open F, "-|", qw(date -d),'$str',qw(+%s) or die $!;
- my $dtime = <F>;
- $?=0; $!=0; close F or die "$? $!";
- $dtime =~ m/^\d+$/ or die "$dtime ?";
- return $dtime+0;
-}
-
-sub expirestime2show ($) {
- my ($tt) = @_;
- if (!defined $tt) {
- return 'never';
- } else {
- return strftime("%Y-%m-%d %H:%M");
- }
-}
-
sub db_commit () {
nooutput("SELECT * FROM addresses LEFT JOIN config".
" USING (emailaddr) WHERE forwardfile IS NULL");
<td>Address</td>
<td>Status</td>
<td>Which message?</td>
-<td>Expiry date</td>
</tr><tr>
% while (my $row= $sth->fetchrow_hashref()) {
<tr>
<td><% $row->{'emailaddr'} |h %></td>
% if (defined $row->{'textid'}) {
-% my $expires = expires2timet($row->{'expires'});
-% if (defined($expires) && $expires < time) {
-<td>expired</td>
-% } else {
-<td>active</td>
-% }
<td><% $row->{'desc'} |h %></td>
-<td><% expirestime2show($expires) |h %></td>
% } else {
<td>inactive</td>
<td></td>