From 7f61a203869c8ae2d436a86a963fae34e8eee8d9 Mon Sep 17 00:00:00 2001
From: Christian Pointner <equinox@helsinki.at>
Date: Sat, 20 Sep 2014 02:54:46 +0000
Subject: including low and high cart for group @ listdropboxes


diff --git a/lib/rddb.pm b/lib/rddb.pm
index 966b29f..e4f7972 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.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 $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 $sth = $dbh->prepare($sql)
     or return (undef, 'ERROR', "Database Error: " . $dbh->errstr);
@@ -110,11 +110,13 @@ sub get_dropboxes
     or return (undef, 'ERROR', "Database Error: " . $sth->errstr);
 
   my @allowed_dbs;
-  while(my ($group, $type, $showid, $log, $normlevel, $trimlevel, $params, $groupdesc) = $sth->fetchrow_array()) {
+  while(my ($group, $type, $showid, $log, $normlevel, $trimlevel, $params, $lowcart, $highcart, $groupdesc) = $sth->fetchrow_array()) {
 
     my $entry = {};
     $entry->{'GROUP'} = $group;
     $entry->{'GROUPDESC'} = $groupdesc;
+    $entry->{'GROUPLOWCART'} = $lowcart;
+    $entry->{'GROUPHIGHCART'} = $highcart;
     $entry->{'TYPE'} = $type;
     $entry->{'SHOWID'} = -1;
     $entry->{'LOG'} = $log;
diff --git a/listdropboxes.cgi b/listdropboxes.cgi
index 0bc0dbd..0d50928 100755
--- a/listdropboxes.cgi
+++ b/listdropboxes.cgi
@@ -48,6 +48,8 @@ if($responsecode != 200) {
     print "  <dropbox>\n";
     print "    <group>" . $href->{'GROUP'} . "</group>\n";
     print "    <group-description>" . $href->{'GROUPDESC'} . "</group-description>\n";
+    print "    <group-low-cart>" . $href->{'GROUPLOWCART'} . "</group-low-cart>\n";
+    print "    <group-high-cart>" . $href->{'GROUPHIGHCART'} . "</group-high-cart>\n";
     print "    <type>" . $href->{'TYPE'} . "</type>\n";
     print "    <showid>" . $href->{'SHOWID'} . "</showid>\n";
     print "    <log>" . $href->{'LOG'} . "</log>\n";
-- 
cgit v0.10.2