Code Duplication    Length = 5-11 lines in 2 locations

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