Code Duplication    Length = 6-7 lines in 3 locations

main/inc/lib/thematic.lib.php 1 location

@@ 577-583 (lines=7) @@
574
        }
575
576
        $res = Database::query($sql);
577
        if (Database::num_rows($res) > 0) {
578
            while ($row = Database::fetch_array($res, 'ASSOC')) {
579
                if (in_array($row['id'], $elements)) {
580
                    $data[] = $row;
581
                }
582
            }
583
        }
584
585
        return $data;
586
    }

main/inc/lib/usergroup.lib.php 1 location

@@ 2186-2192 (lines=7) @@
2183
        $sql .= " LIMIT $from,$number_of_items";
2184
2185
        $res = Database::query($sql);
2186
        if (Database::num_rows($res) > 0) {
2187
            while ($row = Database::fetch_array($res, 'ASSOC')) {
2188
                if (!in_array($row['id'], $return)) {
2189
                    $return[$row['id']] = $row;
2190
                }
2191
            }
2192
        }
2193
        return $return;
2194
    }
2195

main/work/work.lib.php 1 location

@@ 3213-3218 (lines=6) @@
3210
            LIMIT 1
3211
            ";
3212
    $result = Database::query($sql);
3213
    if (Database::num_rows($result)) {
3214
        $work = Database::fetch_array($result, 'ASSOC');
3215
        $work['qualification_rounded'] = formatWorkScore($work['qualification'], $parentInfo['qualification']);
3216
3217
        return $work;
3218
    }
3219
3220
    return array();
3221
}