diff options
| author | Christian Pointner <equinox@helsinki.at> | 2014-09-21 02:07:05 (GMT) |
|---|---|---|
| committer | Christian Pointner <equinox@helsinki.at> | 2014-09-21 02:07:05 (GMT) |
| commit | f4059249c81e3c88b750aad69e834d1ad8e96b41 (patch) | |
| tree | 85b7c32ff4ae4dc08b28907f4190c61f60420ae7 /lib | |
| parent | 82ec71611d389b1a604bd89fc6da3326da54a4a6 (diff) | |
only list dropboxes of special station import-drobbox
Diffstat (limited to 'lib')
| -rwxr-xr-x | lib/rddb.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/rddb.pm b/lib/rddb.pm index 79db125..6b7b40f 100755 --- a/lib/rddb.pm +++ b/lib/rddb.pm @@ -101,12 +101,12 @@ 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;}; + 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 $sth = $dbh->prepare($sql) or return (undef, 'ERROR', "Database Error: " . $dbh->errstr); - $sth->execute($username) + $sth->execute($username, 'import-dropbox') # TODO: hardcoded value or return (undef, 'ERROR', "Database Error: " . $sth->errstr); my @allowed_dbs; |