summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
Diffstat (limited to 'lib')
-rwxr-xr-xlib/rddb.pm56
1 files changed, 32 insertions, 24 deletions
diff --git a/lib/rddb.pm b/lib/rddb.pm
index 6b7b40f..34321d2 100755
--- a/lib/rddb.pm
+++ b/lib/rddb.pm
@@ -77,31 +77,40 @@ sub check_token
return (0, 'ERROR', "wrong password");
}
-sub get_showtitle
+sub get_showtitle_and_log
{
my ($dbh, $showid) = @_;
- my $sql = qq{select TITLE from CART where NUMBER = ?;};
+ my $sql = qq{select TITLE,MACROS from CART where NUMBER = ?;};
my $sth = $dbh->prepare($sql)
- or return (undef, 'ERROR', "Database Error: " . $dbh->errstr);
+ or return (undef, undef, 'ERROR', "Database Error: " . $dbh->errstr);
$sth->execute($showid)
- or return (undef, 'ERROR', "Database Error: " . $sth->errstr);
+ or return (undef, undef, 'ERROR', "Database Error: " . $sth->errstr);
- my ($title) = $sth->fetchrow_array;
+ my ($title, $macros) = $sth->fetchrow_array;
$sth->finish();
unless(defined $title) {
- return (undef, 'ERROR', "Show wid ID=" . $showid . " not found!")
+ return (undef, undef, 'ERROR', "Show with ID=" . $showid . " not found!")
+ }
+ unless(defined $macros) {
+ return (undef, undef, 'ERROR', "Show with ID=" . $showid . " has no macro!");
+ }
+
+ unless($macros =~ /^LL 1 ([^ ]+) 0\!$/) {
+ return (undef, undef, 'ERROR', "Show with ID=" . $showid . " has invalid macro: '" . $macros . "'");
}
- return ($title, 'OK', 'success');
+ my $log = $1;
+
+ return ($title, $log, 'OK', 'success');
}
sub get_dropboxes
{
my ($dbh, $username) = @_;
- my $sql = qq{select USER_PERMS.GROUP_NAME,DROPBOXES.PATH,DROPBOXES.TO_CART,DROPBOXES.LOG_PATH,DROPBOXES.NORMALIZATION_LEVEL,DROPBOXES.AUTOTRIM_LEVEL,DROPBOXES.SET_USER_DEFINED,GROUPS.DEFAULT_LOW_CART,GROUPS.DEFAULT_HIGH_CART,GROUPS.DESCRIPTION from USER_PERMS, DROPBOXES, GROUPS where USER_PERMS.USER_NAME=? and DROPBOXES.GROUP_NAME=USER_PERMS.GROUP_NAME and DROPBOXES.GROUP_NAME=GROUPS.NAME and DROPBOXES.STATION_NAME=?;};
+ my $sql = qq{select USER_PERMS.GROUP_NAME,DROPBOXES.TO_CART,DROPBOXES.NORMALIZATION_LEVEL,DROPBOXES.AUTOTRIM_LEVEL,DROPBOXES.SET_USER_DEFINED,GROUPS.DEFAULT_LOW_CART,GROUPS.DEFAULT_HIGH_CART,GROUPS.DESCRIPTION from USER_PERMS, DROPBOXES, GROUPS where USER_PERMS.USER_NAME=? and DROPBOXES.GROUP_NAME=USER_PERMS.GROUP_NAME and DROPBOXES.GROUP_NAME=GROUPS.NAME and DROPBOXES.STATION_NAME=?;};
my $sth = $dbh->prepare($sql)
or return (undef, 'ERROR', "Database Error: " . $dbh->errstr);
@@ -110,35 +119,34 @@ sub get_dropboxes
or return (undef, 'ERROR', "Database Error: " . $sth->errstr);
my @allowed_dbs;
- while(my ($group, $type, $showid, $log, $normlevel, $trimlevel, $params, $lowcart, $highcart, $groupdesc) = $sth->fetchrow_array()) {
+ while(my ($group, $to_cart, $normlevel, $trimlevel, $params, $lowcart, $highcart, $groupdesc) = $sth->fetchrow_array()) {
+ my @p = split(';', $params);
my $entry = {};
$entry->{'GROUP'} = $group;
$entry->{'GROUPDESC'} = $groupdesc;
$entry->{'GROUPLOWCART'} = $lowcart;
$entry->{'GROUPHIGHCART'} = $highcart;
- $entry->{'TYPE'} = $type;
- $entry->{'SHOWID'} = -1;
- $entry->{'LOG'} = $log;
$entry->{'NORMLEVEL'} = $normlevel;
$entry->{'TRIMLEVEL'} = $trimlevel;
$entry->{'PARAM'} = $params;
- if($type eq "show") {
- $entry->{'SHOWID'} = $showid;
+ if($p[0] eq "S") {
+ $entry->{'TYPE'} = 'show';
+ $entry->{'SHOWID'} = $to_cart;
- my ($title, $status, $errorstring) = get_showtitle($dbh, $showid);
- unless (defined $title) {
+ my ($title, $log, $status, $errorstring) = get_showtitle_and_log($dbh, $to_cart);
+ unless (defined $title && defined $log) {
return (undef, $status, $errorstring);
}
$entry->{'SHOWTITLE'} = $title;
-
- if($params =~ /^([01]{4})-([1-7])-([0-9]{2})([0-9]{2})-([0-9]{3})$/) {
- $entry->{'RHYTHM'} = $1;
- $entry->{'DOW'} = int $2;
- $entry->{'DOW'} = 0 unless $entry->{'DOW'} < 7;
- $entry->{'STARTTIME'} = "$3:$4";
- $entry->{'LENGTH'} = int $5;
- }
+ $entry->{'SHOWLOG'} = $log;
+
+ $entry->{'SHOWRHYTHM'} = $p[1];
+ $entry->{'SHOWDOW'} = int $p[2];
+ $entry->{'SHOWDOW'} = 0 unless $entry->{'SHOWDOW'} < 7;
+ substr($p[3], 2, 0) = ':';
+ $entry->{'SHOWSTARTTIME'} = $p[3];
+ $entry->{'SHOWLEN'} = int $p[4];
}
push @allowed_dbs, $entry;