XOOPS /
XoopsCore25
| @@ 350-361 (lines=12) @@ | ||
| 347 | $sql = 'SELECT b.bid '; |
|
| 348 | } |
|
| 349 | $sql .= 'FROM ' . $db->prefix('newblocks') . ' b LEFT JOIN ' . $db->prefix('group_permission') . " l ON l.gperm_itemid=b.bid WHERE gperm_name = 'block_read' AND gperm_modid = 1"; |
|
| 350 | if (is_array($groupid)) { |
|
| 351 | $sql .= ' AND (l.gperm_groupid=' . $groupid[0] . ''; |
|
| 352 | $size = count($groupid); |
|
| 353 | if ($size > 1) { |
|
| 354 | for ($i = 1; $i < $size; ++$i) { |
|
| 355 | $sql .= ' OR l.gperm_groupid=' . $groupid[$i] . ''; |
|
| 356 | } |
|
| 357 | } |
|
| 358 | $sql .= ')'; |
|
| 359 | } else { |
|
| 360 | $sql .= ' AND l.gperm_groupid=' . $groupid . ''; |
|
| 361 | } |
|
| 362 | $sql .= ' AND b.isactive=' . $isactive; |
|
| 363 | if (isset($side)) { |
|
| 364 | // get both sides in sidebox? (some themes need this) |
|
| @@ 408-419 (lines=12) @@ | ||
| 405 | $sql = 'SELECT b.bid '; |
|
| 406 | } |
|
| 407 | $sql .= 'FROM ' . $db->prefix('newblocks') . ' b LEFT JOIN ' . $db->prefix('group_permission') . " l ON l.gperm_itemid=b.bid WHERE gperm_name = 'block_read' AND gperm_modid = 1"; |
|
| 408 | if (is_array($groupid)) { |
|
| 409 | $sql .= ' AND (l.gperm_groupid=' . $groupid[0] . ''; |
|
| 410 | $size = count($groupid); |
|
| 411 | if ($size > 1) { |
|
| 412 | for ($i = 1; $i < $size; ++$i) { |
|
| 413 | $sql .= ' OR l.gperm_groupid=' . $groupid[$i] . ''; |
|
| 414 | } |
|
| 415 | } |
|
| 416 | $sql .= ')'; |
|
| 417 | } else { |
|
| 418 | $sql .= ' AND l.gperm_groupid=' . $groupid . ''; |
|
| 419 | } |
|
| 420 | $sql .= ' AND b.isactive=' . $isactive; |
|
| 421 | if (isset($side)) { |
|
| 422 | // get both sides in sidebox? (some themes need this) |
|
