| @@ 1542-1552 (lines=11) @@ | ||
| 1539 | ip.lastedit_user_id = '".$user_id."' OR ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.") |
|
| 1540 | )"; |
|
| 1541 | } |
|
| 1542 | } else { |
|
| 1543 | if ($group_id == 0) { |
|
| 1544 | $cond_user_id = " AND ( |
|
| 1545 | ip.to_user_id = $user_id AND (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) |
|
| 1546 | ) "; |
|
| 1547 | } else { |
|
| 1548 | $cond_user_id = " AND ( |
|
| 1549 | ip.to_user_id = $user_id AND (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.")) |
|
| 1550 | )"; |
|
| 1551 | } |
|
| 1552 | } |
|
| 1553 | ||
| 1554 | $sql = "SELECT $select |
|
| 1555 | FROM $tbl_announcement announcement, |
|
| @@ 1490-1496 (lines=7) @@ | ||
| 1487 | if (api_is_allowed_to_edit()) { |
|
| 1488 | if (!empty($groupId)) { |
|
| 1489 | $where_condition = "( ip.to_group_id IN (".implode(", ", $group_memberships).") ) "; |
|
| 1490 | } else { |
|
| 1491 | if (!empty($user_id)) { |
|
| 1492 | $where_condition = "( ip.to_user_id = $user_id OR ip.to_user_id IS NULL OR (ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) ) "; |
|
| 1493 | } else { |
|
| 1494 | $where_condition = "( ip.to_group_id IN (0, ".implode(", ", $group_memberships).") ) "; |
|
| 1495 | } |
|
| 1496 | } |
|
| 1497 | } else { |
|
| 1498 | $where_condition = "( ip.to_user_id = $user_id OR ip.to_user_id IS NULL OR (ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) ) "; |
|
| 1499 | } |
|