Code Duplication    Length = 8-9 lines in 3 locations

main/inc/lib/message.lib.php 1 location

@@ 796-803 (lines=8) @@
793
        $rs = Database::query($sql);
794
        $data = array();
795
        $parents = array();
796
        if (Database::num_rows($rs) > 0) {
797
            while ($row = Database::fetch_array($rs, 'ASSOC')) {
798
                if ($message_id == $row['parent_id'] || in_array($row['parent_id'], $parents)) {
799
                    $parents[] = $row['id'];
800
                    $data[] = $row;
801
                }
802
            }
803
        }
804
805
        return $data;
806
    }

main/inc/lib/usermanager.lib.php 2 locations

@@ 3046-3054 (lines=9) @@
3043
        $courses = array();
3044
3045
        $result = Database::query($sql);
3046
        if (Database::num_rows($result) > 0) {
3047
            while ($result_row = Database::fetch_array($result, 'ASSOC')) {
3048
                $result_row['status'] = 5;
3049
                if (!in_array($result_row['real_id'], $courses)) {
3050
                    $personal_course_list[] = $result_row;
3051
                    $courses[] = $result_row['real_id'];
3052
                }
3053
            }
3054
        }
3055
3056
        if (api_is_allowed_to_create_course()) {
3057
            $sql = "SELECT DISTINCT
@@ 3079-3087 (lines=9) @@
3076
                    ORDER BY sc.position ASC";
3077
            $result = Database::query($sql);
3078
3079
            if (Database::num_rows($result) > 0) {
3080
                while ($result_row = Database::fetch_array($result, 'ASSOC')) {
3081
                    $result_row['status'] = 2;
3082
                    if (!in_array($result_row['real_id'], $courses)) {
3083
                        $personal_course_list[] = $result_row;
3084
                        $courses[] = $result_row['real_id'];
3085
                    }
3086
                }
3087
            }
3088
        }
3089
3090
        if (api_is_drh()) {