10 |
sub getUnits() { |
sub getUnits() { |
11 |
my @ret = (); |
my @ret = (); |
12 |
my $tmp; |
my $tmp; |
13 |
my $dbh = DBI->connect( "dbi:SQLite:dbname=$Conf{SearchDB}", |
my $dbh = DBI->connect( "dbi:SQLite:dbname=${TopDir}/$Conf{SearchDB}", |
14 |
"", "", { RaiseError => 1, AutoCommit => 1 } ); |
"", "", { RaiseError => 1, AutoCommit => 1 } ); |
15 |
my $st = |
my $st = |
16 |
$dbh->prepare( |
$dbh->prepare( |
121 |
{ |
{ |
122 |
my ($where) = @_; |
my ($where) = @_; |
123 |
|
|
124 |
my $dbh = DBI->connect( "dbi:SQLite:dbname=$Conf{SearchDB}", |
my $dbh = DBI->connect( "dbi:SQLite:dbname=${TopDir}/$Conf{SearchDB}", |
125 |
"", "", { RaiseError => 1, AutoCommit => 1 } ); |
"", "", { RaiseError => 1, AutoCommit => 1 } ); |
126 |
my $sql = |
my $sql = |
127 |
q{ |
q{ |
188 |
|
|
189 |
sub getBackupsNotBurned() |
sub getBackupsNotBurned() |
190 |
{ |
{ |
191 |
my $dbh = DBI->connect( "dbi:SQLite:dbname=$Conf{SearchDB}", |
my $dbh = DBI->connect( "dbi:SQLite:dbname=${TopDir}/$Conf{SearchDB}", |
192 |
"", "", { RaiseError => 1, AutoCommit => 1 } ); |
"", "", { RaiseError => 1, AutoCommit => 1 } ); |
193 |
my $sql = q{ |
my $sql = q{ |
194 |
SELECT |
SELECT |