main/inc/lib/agenda.lib.php 1 location
|
@@ 1712-1718 (lines=7) @@
|
| 1709 |
|
", ", |
| 1710 |
|
$group_memberships |
| 1711 |
|
).") ) "; |
| 1712 |
|
} else { |
| 1713 |
|
if (!empty($user_id)) { |
| 1714 |
|
$where_condition = "( ip.to_user_id = $user_id OR ip.to_user_id IS NULL OR (ip.to_group_id IN (0, ".implode( |
| 1715 |
|
", ", |
| 1716 |
|
$group_memberships |
| 1717 |
|
).")) ) "; |
| 1718 |
|
} else { |
| 1719 |
|
$where_condition = "( ip.to_group_id IN (0, ".implode( |
| 1720 |
|
", ", |
| 1721 |
|
$group_memberships |
main/inc/lib/AnnouncementManager.php 1 location
|
@@ 1491-1501 (lines=11) @@
|
| 1488 |
|
ip.lastedit_user_id = '".$user_id."' OR ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.") |
| 1489 |
|
)"; |
| 1490 |
|
} |
| 1491 |
|
} else { |
| 1492 |
|
if ($group_id == 0) { |
| 1493 |
|
$cond_user_id = " AND ( |
| 1494 |
|
(ip.to_user_id='$user_id' OR ip.to_user_id IS NULL) AND (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) |
| 1495 |
|
) "; |
| 1496 |
|
} else { |
| 1497 |
|
$cond_user_id = " AND ( |
| 1498 |
|
(ip.to_user_id='$user_id' OR ip.to_user_id IS NULL) AND (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.")) |
| 1499 |
|
)"; |
| 1500 |
|
} |
| 1501 |
|
} |
| 1502 |
|
|
| 1503 |
|
$sql = "SELECT $select |
| 1504 |
|
FROM $tbl_announcement announcement INNER JOIN |