Code Duplication    Length = 5-5 lines in 3 locations

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

@@ 3129-3133 (lines=5) @@
3126
                WHERE field_id = $field_id AND tag LIKE '$tag%' ORDER BY tag LIMIT $limit";
3127
        $result = Database::query($sql);
3128
        $return = array();
3129
        if (Database::num_rows($result) > 0) {
3130
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3131
                $return[] = array('caption' => $row['tag'], 'value' => $row['tag']);
3132
            }
3133
        }
3134
        if ($return_format == 'json') {
3135
            $return = json_encode($return);
3136
        }
@@ 3193-3197 (lines=5) @@
3190
                ORDER BY tag";
3191
        $result = Database::query($sql);
3192
        $return = array();
3193
        if (Database::num_rows($result) > 0) {
3194
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3195
                $return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']);
3196
            }
3197
        }
3198
3199
        return $return;
3200
    }
@@ 3226-3230 (lines=5) @@
3223
3224
        $result = Database::query($sql);
3225
        $return = array();
3226
        if (Database::num_rows($result) > 0) {
3227
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3228
                $return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']);
3229
            }
3230
        }
3231
        $user_tags = $return;
3232
        $tag_tmp = array();
3233
        foreach ($user_tags as $tag) {