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

@@ 5834-5839 (lines=6) @@
5831
5832
        $sql .= $order;
5833
5834
        if (isset($start) && isset($maxPerPage)) {
5835
            $start = intval($start);
5836
            $maxPerPage = intval($maxPerPage);
5837
            $limitCondition = " LIMIT $start, $maxPerPage";
5838
            $sql .= $limitCondition;
5839
        }
5840
5841
        $result = Database::query($sql);
5842
        $sessionsCategories = array();

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

@@ 3480-3484 (lines=5) @@
3477
            return $row['count'];
3478
        }
3479
3480
        if (isset($from) && isset($limit)) {
3481
            $from = intval($from);
3482
            $limit = intval($limit);
3483
            $sql .= " LIMIT $from, $limit";
3484
        }
3485
3486
        $result = Database::query($sql);
3487
        $num_rows = Database::num_rows($result);

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

@@ 3331-3335 (lines=5) @@
3328
                    $whereConditions
3329
                $orderBy
3330
                ";
3331
        if (isset($from) && isset($limit)) {
3332
            $from = intval($from);
3333
            $limit = intval($limit);
3334
            $sql .= " LIMIT $from, $limit";
3335
        }
3336
3337
        $result = Database::query($sql);
3338
@@ 6248-6253 (lines=6) @@
6245
6246
        $sql .= $order;
6247
6248
        if (isset($start) && isset($maxPerPage)) {
6249
            $start = intval($start);
6250
            $maxPerPage = intval($maxPerPage);
6251
            $limitCondition = " LIMIT $start, $maxPerPage";
6252
            $sql .= $limitCondition;
6253
        }
6254
6255
        if ($getCount) {
6256
            $result = Database::query($sql);