use warnings;
use DBI;
+use Data::Dumper;
BEGIN {
use Exporter ();
our ($VERSION, @ISA, @EXPORT, @EXPORT_OK, %EXPORT_TAGS);
$VERSION = 1.00;
@ISA = qw(Exporter);
- @EXPORT = qw(&db_connect &db_commit $dbh);
+ @EXPORT = qw(db_connect db_commit
+ $dbh);
%EXPORT_TAGS = ( );
@EXPORT_OK = qw();
}
}
}
-
sub db_commit () {
- nooutput("SELECT * FROM addresses LEFT JOIN config USING (emailaddr)");
- nooutput("SELECT * FROM addresses LEFT JOIN texts USING (textid)");
+ nooutput("SELECT * FROM addresses LEFT JOIN config".
+ " USING (emailaddr) WHERE forwardfile IS NULL");
+ nooutput("SELECT * FROM addresses LEFT JOIN texts".
+ " USING (textid) WHERE desc IS NULL");
$dbh->do("COMMIT");
}