Code Duplication    Length = 5-5 lines in 3 locations

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

@@ 3135-3139 (lines=5) @@
3132
                WHERE field_id = $field_id AND tag LIKE '$tag%' ORDER BY tag LIMIT $limit";
3133
        $result = Database::query($sql);
3134
        $return = array();
3135
        if (Database::num_rows($result) > 0) {
3136
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3137
                $return[] = array('caption' => $row['tag'], 'value' => $row['tag']);
3138
            }
3139
        }
3140
        if ($return_format == 'json') {
3141
            $return = json_encode($return);
3142
        }
@@ 3199-3203 (lines=5) @@
3196
                ORDER BY tag";
3197
        $result = Database::query($sql);
3198
        $return = array();
3199
        if (Database::num_rows($result) > 0) {
3200
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3201
                $return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']);
3202
            }
3203
        }
3204
3205
        return $return;
3206
    }
@@ 3232-3236 (lines=5) @@
3229
3230
        $result = Database::query($sql);
3231
        $return = array();
3232
        if (Database::num_rows($result) > 0) {
3233
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3234
                $return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']);
3235
            }
3236
        }
3237
        $user_tags = $return;
3238
        $tag_tmp = array();
3239
        foreach ($user_tags as $tag) {