Use local::lib properly

[ndwebbie.git] / scripts / reset_hosts.pl

diff --git a/scripts/reset_hosts.pl b/scripts/reset_hosts.pl
index 4932f051fd74e9005ec578047fea4f9633a026b1..53f82a0d2ff789fdf59b31dae69781b29ac6cfba 100755 (executable)
--- a/scripts/reset_hosts.pl
+++ b/scripts/reset_hosts.pl
@@ -2,22 +2,20 @@
 
 use strict;
 use warnings;
+use local::lib;
 use DBI;
 use DBD::Pg qw(:pg_types);
 
 use LWP::Simple;
 
-our $dbh;
-for my $file ("/home/whale/db.pl")
-{
-       unless (my $return = do $file){
-               warn "couldn't parse $file: $@" if $@;
-               warn "couldn't do $file: $!"    unless defined $return;
-               warn "couldn't run $file"       unless $return;
-       }
-}
+use FindBin;
+use lib "$FindBin::Bin/../lib";
 
-$dbh->trace("0","/tmp/scanstest");
+use ND::DB;
+
+our $dbh = ND::DB::DB();
+
+#$dbh->trace("0","/tmp/scanstest");
 my $update = $dbh->prepare("UPDATE users SET hostmask = pnick || '.users.netgamers.org' where hostmask ilike '%.%' AND NOT hostmask ilike pnick || '.users.netgamers.org'");
 $update->execute();
 $dbh->disconnect;