Code Duplication    Length = 5-6 lines in 6 locations

main/exercise/exercise.class.php 1 location

@@ 603-607 (lines=5) @@
600
601
            $limitCondition = null;
602
603
            if (isset($start) && isset($limit)) {
604
                $start = intval($start);
605
                $limit = intval($limit);
606
                $limitCondition = " LIMIT $start, $limit";
607
            }
608
            $sql .= $limitCondition;
609
            $result = Database::query($sql);
610
            $questions = array();

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

@@ 1921-1925 (lines=5) @@
1918
        }
1919
1920
        $limit_text = '';
1921
        if (isset($from) && isset($limit)) {
1922
            $from = intval($from);
1923
            $limit = intval($limit);
1924
            $limit_text = "LIMIT $from, $limit";
1925
        }
1926
1927
        if (count($relation_type) == 0) {
1928
            $where_relation_condition = '';

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

@@ 5881-5886 (lines=6) @@
5878
5879
        $sql .= $order;
5880
5881
        if (isset($start) && isset($maxPerPage)) {
5882
            $start = intval($start);
5883
            $maxPerPage = intval($maxPerPage);
5884
            $limitCondition = " LIMIT $start, $maxPerPage";
5885
            $sql .= $limitCondition;
5886
        }
5887
5888
        $result = Database::query($sql);
5889
        $sessionsCategories = array();

main/inc/lib/course.lib.php 2 locations

@@ 3302-3306 (lines=5) @@
3299
                    $whereConditions
3300
                $orderBy
3301
                ";
3302
        if (isset($from) && isset($limit)) {
3303
            $from = intval($from);
3304
            $limit = intval($limit);
3305
            $sql .= " LIMIT $from, $limit";
3306
        }
3307
3308
        $result = Database::query($sql);
3309
@@ 6197-6202 (lines=6) @@
6194
6195
        $sql .= $order;
6196
6197
        if (isset($start) && isset($maxPerPage)) {
6198
            $start = intval($start);
6199
            $maxPerPage = intval($maxPerPage);
6200
            $limitCondition = " LIMIT $start, $maxPerPage";
6201
            $sql .= $limitCondition;
6202
        }
6203
6204
        if ($getCount) {
6205
            $result = Database::query($sql);

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

@@ 3515-3519 (lines=5) @@
3512
            return $row['count'];
3513
        }
3514
3515
        if (isset($from) && isset($limit)) {
3516
            $from = intval($from);
3517
            $limit = intval($limit);
3518
            $sql .= " LIMIT $from, $limit";
3519
        }
3520
3521
        $result = Database::query($sql);
3522
        $num_rows = Database::num_rows($result);