@@ 194-203 (lines=10) @@ | ||
191 | $qb->andWhere($eb->eq('l.gperm_groupid', $qb->createNamedParameter($groupid, \PDO::PARAM_INT))); |
|
192 | } |
|
193 | $qb->andWhere($eb->eq('b.isactive', $qb->createNamedParameter($isactive, \PDO::PARAM_INT))); |
|
194 | if (isset($side)) { |
|
195 | // get both sides in sidebox? (some themes need this) |
|
196 | if ($side == XOOPS_SIDEBLOCK_BOTH) { |
|
197 | $qb->andWhere($eb->in('b.side', array(0,1))); |
|
198 | } elseif ($side == XOOPS_CENTERBLOCK_ALL) { |
|
199 | $qb->andWhere($eb->in('b.side', array(3,4,5,7,8,9))); |
|
200 | } else { |
|
201 | $qb->andWhere($eb->eq('b.side', $qb->createNamedParameter($side, \PDO::PARAM_INT))); |
|
202 | } |
|
203 | } |
|
204 | if (isset($visible)) { |
|
205 | $qb->andWhere($eb->eq('b.visible', $qb->createNamedParameter($visible, \PDO::PARAM_INT))); |
|
206 | } |
|
@@ 247-256 (lines=10) @@ | ||
244 | ||
245 | $qb ->fromPrefix('system_block', null) |
|
246 | ->where($eb->eq('isactive', $qb->createNamedParameter($isactive, \PDO::PARAM_INT))); |
|
247 | if (isset($side)) { |
|
248 | // get both sides in sidebox? (some themes need this) |
|
249 | if ($side == XOOPS_SIDEBLOCK_BOTH) { |
|
250 | $qb->andWhere($eb->in('side', array(0,1))); |
|
251 | } elseif ($side == XOOPS_CENTERBLOCK_ALL) { |
|
252 | $qb->andWhere($eb->in('side', array(3,4,5,7,8,9))); |
|
253 | } else { |
|
254 | $qb->andWhere($eb->eq('side', $qb->createNamedParameter($side, \PDO::PARAM_INT))); |
|
255 | } |
|
256 | } |
|
257 | if (isset($visible)) { |
|
258 | $qb->andWhere($eb->eq('visible', $qb->createNamedParameter($visible, \PDO::PARAM_INT))); |
|
259 | } |