|
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 |
- |
|
|