Code Duplication    Length = 7-11 lines in 2 locations

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