summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorChristian Pointner <equinox@helsinki.at>2014-09-20 01:14:51 (GMT)
committerChristian Pointner <equinox@helsinki.at>2014-09-20 01:14:51 (GMT)
commitf6aef0cbb8cb2464854a23566ccb72526c145f55 (patch)
tree6a491e1c1d76579a72ccf4890e4217a8d23ea44a /lib
parent95ae5cd3a1b3572d48c8eaae8708866de8c235e5 (diff)
also exporting log name of dropboxes
Diffstat (limited to 'lib')
-rwxr-xr-xlib/rddb.pm5
1 files changed, 3 insertions, 2 deletions
diff --git a/lib/rddb.pm b/lib/rddb.pm
index b78f4d1..966b29f 100755
--- a/lib/rddb.pm
+++ b/lib/rddb.pm
@@ -101,7 +101,7 @@ sub get_dropboxes
{
my ($dbh, $username) = @_;
- my $sql = qq{select USER_PERMS.GROUP_NAME,DROPBOXES.PATH,DROPBOXES.TO_CART,DROPBOXES.NORMALIZATION_LEVEL,DROPBOXES.AUTOTRIM_LEVEL,DROPBOXES.SET_USER_DEFINED,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;};
+ 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.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;};
my $sth = $dbh->prepare($sql)
or return (undef, 'ERROR', "Database Error: " . $dbh->errstr);
@@ -110,13 +110,14 @@ sub get_dropboxes
or return (undef, 'ERROR', "Database Error: " . $sth->errstr);
my @allowed_dbs;
- while(my ($group, $type, $showid, $normlevel, $trimlevel, $params, $groupdesc) = $sth->fetchrow_array()) {
+ while(my ($group, $type, $showid, $log, $normlevel, $trimlevel, $params, $groupdesc) = $sth->fetchrow_array()) {
my $entry = {};
$entry->{'GROUP'} = $group;
$entry->{'GROUPDESC'} = $groupdesc;
$entry->{'TYPE'} = $type;
$entry->{'SHOWID'} = -1;
+ $entry->{'LOG'} = $log;
$entry->{'NORMLEVEL'} = $normlevel;
$entry->{'TRIMLEVEL'} = $trimlevel;
$entry->{'PARAM'} = $params;