Code Duplication    Length = 3-5 lines in 4 locations

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

@@ 89-91 (lines=3) @@
86
					blogs_rel_user.blog_id = '" . (int)$blog_id."'";
87
		$result = Database::query($sql);
88
		$blog_members = array ();
89
		while($user = Database::fetch_array($result)) {
90
			$blog_members[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']);
91
		}
92
93
		return $blog_members;
94
	}
@@ 1728-1730 (lines=3) @@
1725
		$result = Database::query($sql);
1726
1727
		$options = array();
1728
		while ($user = Database::fetch_array($result)) {
1729
			$options[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']);
1730
		}
1731
1732
		// Get tasks in this blog / make select list of it
1733
		$sql = "

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

@@ 1928-1932 (lines=5) @@
1925
        $rs = Database::query($sql);
1926
1927
        if (Database::num_rows($rs) > 0) {
1928
            while ($row = Database::fetch_array($rs)) {
1929
                $completeName = api_get_person_name($row['firstname'], $row['lastname']);
1930
1931
                $coaches[] = $row + ['full_name' => $completeName];
1932
            }
1933
1934
            return $coaches;
1935
        } else {
@@ 2638-2641 (lines=4) @@
2635
        while ($list_users = Database::fetch_array($res)) {
2636
            $result = Database::query("SELECT * FROM " . Database::get_main_table(TABLE_MAIN_USER) . "
2637
                    WHERE user_id=" . $list_users['user_id']);
2638
            while ($row_user = Database::fetch_array($result)) {
2639
                $name_teacher = api_get_person_name($row_user['firstname'], $row_user['lastname']);
2640
                $list[] = array($row_user['email'] => $name_teacher);
2641
            }
2642
        }
2643
        return $list;
2644
    }