X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=scripts%2Freset_hosts.pl;h=a86ea3c6eb0959a63a32183984ecc346e7c6c2b0;hb=fe92f95649f91029d18ec050252382332fe0fb96;hp=4932f051fd74e9005ec578047fea4f9633a026b1;hpb=c5970c4e8713892b0960843e66be24c1e6f24e8f;p=ndwebbie.git diff --git a/scripts/reset_hosts.pl b/scripts/reset_hosts.pl index 4932f05..a86ea3c 100755 --- a/scripts/reset_hosts.pl +++ b/scripts/reset_hosts.pl @@ -6,18 +6,12 @@ use DBI; use DBD::Pg qw(:pg_types); use LWP::Simple; +use lib qw{/var/www/ndawn/}; +use ND::DB; -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; - } -} +our $dbh = ND::DB::DB(); -$dbh->trace("0","/tmp/scanstest"); +#$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;