Code Duplication    Length = 5-5 lines in 3 locations

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

@@ 3530-3534 (lines=5) @@
3527
                WHERE field_id = $field_id AND tag LIKE '$tag%' ORDER BY tag LIMIT $limit";
3528
        $result = Database::query($sql);
3529
        $return = array();
3530
        if (Database::num_rows($result) > 0) {
3531
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3532
                $return[] = array('id' => $row['tag'], 'text' => $row['tag']);
3533
            }
3534
        }
3535
        if ($return_format === 'json') {
3536
            $return = json_encode($return);
3537
        }
@@ 3597-3601 (lines=5) @@
3594
                ORDER BY tag";
3595
        $result = Database::query($sql);
3596
        $return = array();
3597
        if (Database::num_rows($result) > 0) {
3598
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3599
                $return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']);
3600
            }
3601
        }
3602
3603
        return $return;
3604
    }
@@ 3631-3635 (lines=5) @@
3628
3629
        $result = Database::query($sql);
3630
        $return = array();
3631
        if (Database::num_rows($result) > 0) {
3632
            while ($row = Database::fetch_array($result, 'ASSOC')) {
3633
                $return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']);
3634
            }
3635
        }
3636
        $user_tags = $return;
3637
        $tag_tmp = array();
3638
        foreach ($user_tags as $tag) {