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();
|