summaryrefslogtreecommitdiff
path: root/rhimport-zfw
diff options
context:
space:
mode:
Diffstat (limited to 'rhimport-zfw')
-rwxr-xr-xrhimport-zfw20
1 files changed, 9 insertions, 11 deletions
diff --git a/rhimport-zfw b/rhimport-zfw
index f6ea83c..4bffb61 100755
--- a/rhimport-zfw
+++ b/rhimport-zfw
@@ -22,7 +22,6 @@
#
use strict;
-use DBI;
use Date::Calc;
use Time::localtime;
use XML::Feed;
@@ -37,11 +36,6 @@ use HTML::Entities;
use lib '/usr/local/share/rhimport/';
use rhimport;
-my $DBHOST = "airplay";
-my $DBUSER = "rivendell";
-my $DBPW = "lldriven";
-my $DB = "rivendell";
-
my $STAT_FILE = $ENV{'HOME'} . "/rhimport-zfw.stat";
my $RSS_URL = "http://cba.fro.at/seriesrss/263764?c=Kfs2IoV2Wmd";
$XML::Feed::MULTIPLE_ENCLOSURES=1;
@@ -59,12 +53,16 @@ my $user = `/usr/bin/id -un`;
$user =~ s/\n//;
my $group = "zipfmwla";
-my $dbh = DBI->connect("DBI:mysql:$DB:$DBHOST","$DBUSER","$DBPW") or die "Database Error: $DBI::errstr";
+my ($dbh, $errorstring) = rhimport::opendb();
+if(!defined $dbh) {
+ print "$errorstring\n";
+ exit 1;
+}
my @allowed_dbs = rhimport::get_dropboxes($dbh, $user, $group);
if(scalar(@allowed_dbs) != 1) {
print "found no or more than one Dropboxes for this group?!\n";
- $dbh->disconnect();
+ rhimport::closedb($dbh);
exit 1;
}
my $dropbox = $allowed_dbs[0]->{'PATH'};
@@ -122,13 +120,13 @@ for my $entry ($feed->entries) {
my ($current_id, $current_file) = $current_stat =~ m/^(.*)\n(.*)/;
if($current_id eq $id && $current_file eq $ff->output_file) {
print "Already downloaded file of today\n";
- $dbh->disconnect();
+ rhimport::closedb($dbh);
exit 0;
}
$out_file = $ff->output_file;
if(!rhimport::check_file_extension($out_file)) {
print "\n\nThe extension of the matching file '". $out_file . "' seems to be wrong - manual import necessary!!!\n";
- $dbh->disconnect();
+ rhimport::closedb($dbh);
exit 1;
}
@@ -174,7 +172,7 @@ my $import_log;
($ret, $import_log) = rhimport::import_single($file, $dropbox, $user, 0, $error_cb);
$log .= $import_log;
-$dbh->disconnect();
+rhimport::closedb($dbh);
unlink $file;