aboutsummaryrefslogtreecommitdiff
path: root/util/tools/db_manual_batch_insert.pl
blob: 5b65a13962e4d9a658e9ed34acb9fdc4388ad521 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
#!/usr/bin/perl

################################################################################
## Manual use to insert one or a batch of IP-addresses/ports into the pending
## list, rather than manually adding them with psql.
## 
## Use with care!
################################################################################

use strict;
use warnings;
use Encode;
use DBI;
$|++;

our %S;
require "../../data/supportedgames.pl";
require "r_secure.pl";
require "r_database.pl";
require "r_functions.pl";
require "r_lists.pl";

# open db
our $dbh;

# import list of ip:ports
my @ips = qw(


);

$dbh->begin_work;
foreach my $l (@ips) {

  # break ip:port into $a (ip) and $q (query port)
  if ($l =~ /:/) {
    my ($a,$p) = valid_address($l);
    db_add_server(ip => $a, port => $p);
  }
}
$dbh->commit;

# close db
$dbh->disconnect();