Code Duplication    Length = 5-5 lines in 3 locations

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

@@ 3147-3151 (lines=5) @@
3144
                WHERE field_id = $field_id AND tag LIKE '$tag%' ORDER BY tag LIMIT $limit";
3145
        $result = Database::query($sql);
3146
        $return = array();
3147
        if (Database::num_rows($result) > 0) {
3148
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3149
                $return[] = array('caption' => $row['tag'], 'value' => $row['tag']);
3150
            }
3151
        }
3152
        if ($return_format == 'json') {
3153
            $return = json_encode($return);
3154
        }
@@ 3211-3215 (lines=5) @@
3208
                ORDER BY tag";
3209
        $result = Database::query($sql);
3210
        $return = array();
3211
        if (Database::num_rows($result) > 0) {
3212
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3213
                $return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']);
3214
            }
3215
        }
3216
3217
        return $return;
3218
    }
@@ 3244-3248 (lines=5) @@
3241
3242
        $result = Database::query($sql);
3243
        $return = array();
3244
        if (Database::num_rows($result) > 0) {
3245
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3246
                $return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']);
3247
            }
3248
        }
3249
        $user_tags = $return;
3250
        $tag_tmp = array();
3251
        foreach ($user_tags as $tag) {