main/inc/lib/agenda.lib.php 1 location
|
@@ 1686-1690 (lines=5) @@
|
| 1683 |
|
$tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY); |
| 1684 |
|
|
| 1685 |
|
if (!empty($groupId)) { |
| 1686 |
|
if (empty($user_id)) { |
| 1687 |
|
$where_condition = "( ip.to_group_id IN (0, ".implode(", ", $group_memberships).") ) "; |
| 1688 |
|
} else { |
| 1689 |
|
$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).")) ) "; |
| 1690 |
|
} |
| 1691 |
|
|
| 1692 |
|
if (empty($session_id)) { |
| 1693 |
|
$sessionCondition = " |
main/inc/lib/AnnouncementManager.php 1 location
|
@@ 1497-1507 (lines=11) @@
|
| 1494 |
|
ip.lastedit_user_id = '".$user_id."' OR ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.") |
| 1495 |
|
)"; |
| 1496 |
|
} |
| 1497 |
|
} else { |
| 1498 |
|
if ($group_id == 0) { |
| 1499 |
|
$cond_user_id = " AND ( |
| 1500 |
|
(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).")) |
| 1501 |
|
) "; |
| 1502 |
|
} else { |
| 1503 |
|
$cond_user_id = " AND ( |
| 1504 |
|
(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.")) |
| 1505 |
|
)"; |
| 1506 |
|
} |
| 1507 |
|
} |
| 1508 |
|
|
| 1509 |
|
$sql = "SELECT $select |
| 1510 |
|
FROM $tbl_announcement announcement INNER JOIN |