Lines 111-117
sub GetShelves {
Link Here
|
111 |
LEFT JOIN virtualshelfshares sh ON sh.shelfnumber=vs.shelfnumber |
111 |
LEFT JOIN virtualshelfshares sh ON sh.shelfnumber=vs.shelfnumber |
112 |
AND sh.borrowernumber=? |
112 |
AND sh.borrowernumber=? |
113 |
WHERE category=1 AND (vs.owner=? OR sh.borrowernumber=?) }; |
113 |
WHERE category=1 AND (vs.owner=? OR sh.borrowernumber=?) }; |
114 |
push @params, ($owner) x 3; |
114 |
unshift @params, ($owner) x 3; |
115 |
} |
115 |
} |
116 |
else { |
116 |
else { |
117 |
$query.= 'WHERE category=2 '; |
117 |
$query.= 'WHERE category=2 '; |
118 |
- |
|
|