Code Duplication    Length = 5-6 lines in 6 locations

main/exercise/exercise.class.php 1 location

@@ 615-619 (lines=5) @@
612
613
            $sql .= $orderCondition;
614
            $limitCondition = null;
615
            if (isset($start) && isset($limit)) {
616
                $start = intval($start);
617
                $limit = intval($limit);
618
                $limitCondition = " LIMIT $start, $limit";
619
            }
620
            $sql .= $limitCondition;
621
            $result = Database::query($sql);
622
            $questions = array();

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

@@ 3383-3387 (lines=5) @@
3380
                    $whereConditions
3381
                $orderBy
3382
                ";
3383
        if (isset($from) && isset($limit)) {
3384
            $from = intval($from);
3385
            $limit = intval($limit);
3386
            $sql .= " LIMIT $from, $limit";
3387
        }
3388
3389
        $result = Database::query($sql);
3390
@@ 6447-6452 (lines=6) @@
6444
6445
        $sql .= $order;
6446
6447
        if (isset($start) && isset($maxPerPage)) {
6448
            $start = intval($start);
6449
            $maxPerPage = intval($maxPerPage);
6450
            $limitCondition = " LIMIT $start, $maxPerPage";
6451
            $sql .= $limitCondition;
6452
        }
6453
6454
        if ($getCount) {
6455
            $result = Database::query($sql);

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

@@ 3697-3701 (lines=5) @@
3694
            return $row['count'];
3695
        }
3696
3697
        if (isset($from) && isset($limit)) {
3698
            $from = intval($from);
3699
            $limit = intval($limit);
3700
            $sql .= " LIMIT $from, $limit";
3701
        }
3702
3703
        $result = Database::query($sql);
3704
        $num_rows = Database::num_rows($result);

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

@@ 1949-1953 (lines=5) @@
1946
        }
1947
1948
        $limit_text = '';
1949
        if (isset($from) && isset($limit)) {
1950
            $from = intval($from);
1951
            $limit = intval($limit);
1952
            $limit_text = "LIMIT $from, $limit";
1953
        }
1954
1955
        if (count($relation_type) == 0) {
1956
            $where_relation_condition = '';

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

@@ 5638-5643 (lines=6) @@
5635
5636
        $sql .= $order;
5637
5638
        if (isset($start) && isset($maxPerPage)) {
5639
            $start = intval($start);
5640
            $maxPerPage = intval($maxPerPage);
5641
            $limitCondition = " LIMIT $start, $maxPerPage";
5642
            $sql .= $limitCondition;
5643
        }
5644
5645
        $result = Database::query($sql);
5646
        $sessionsCategories = array();