chamilo /
chamilo-lms
| @@ 1717-1723 (lines=7) @@ | ||
| 1714 | ", ", |
|
| 1715 | $group_memberships |
|
| 1716 | ).") ) "; |
|
| 1717 | } else { |
|
| 1718 | if (!empty($user_id)) { |
|
| 1719 | $where_condition = "( ip.to_user_id = $user_id OR ip.to_user_id IS NULL OR (ip.to_group_id IN (0, ".implode( |
|
| 1720 | ", ", |
|
| 1721 | $group_memberships |
|
| 1722 | ).")) ) "; |
|
| 1723 | } else { |
|
| 1724 | $where_condition = "( ip.to_group_id IN (0, ".implode( |
|
| 1725 | ", ", |
|
| 1726 | $group_memberships |
|
| @@ 1487-1497 (lines=11) @@ | ||
| 1484 | ip.lastedit_user_id = '".$user_id."' OR ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.") |
|
| 1485 | )"; |
|
| 1486 | } |
|
| 1487 | } else { |
|
| 1488 | if ($group_id == 0) { |
|
| 1489 | $cond_user_id = " AND ( |
|
| 1490 | ip.to_user_id = $user_id AND (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) |
|
| 1491 | ) "; |
|
| 1492 | } else { |
|
| 1493 | $cond_user_id = " AND ( |
|
| 1494 | ip.to_user_id = $user_id AND (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.")) |
|
| 1495 | )"; |
|
| 1496 | } |
|
| 1497 | } |
|
| 1498 | ||
| 1499 | $sql = "SELECT $select |
|
| 1500 | FROM $tbl_announcement announcement INNER JOIN |
|
