our ($VERSION, @ISA, @EXPORT, @EXPORT_OK, %EXPORT_TAGS);
$VERSION = 1.00;
@ISA = qw(Exporter);
- @EXPORT = qw(db_connect db_commit expires2timet
+ @EXPORT = qw(db_connect db_commit
$dbh);
%EXPORT_TAGS = ( );
@EXPORT_OK = qw();
}
}
-sub expires2timet ($) {
- my ($str) = @_;
- if ($str eq '') {
- 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 db_commit () {
nooutput("SELECT * FROM addresses LEFT JOIN config".
" USING (emailaddr) WHERE forwardfile IS NULL");
nooutput("SELECT * FROM addresses LEFT JOIN texts".
- " USING (textid) WHERE name IS NULL");
+ " USING (textid) WHERE desc IS NULL");
$dbh->do("COMMIT");
}