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