Code Duplication    Length = 17-18 lines in 8 locations

main/newscorm/learnpath.class.php 8 locations

@@ 6917-6933 (lines=17) @@
6914
        $result = Database::query($sql);
6915
        $arrLP = array();
6916
6917
        while ($row = Database :: fetch_array($result)) {
6918
            $arrLP[] = array (
6919
                'id' => $row['id'],
6920
                'item_type' => $row['item_type'],
6921
                'title' => $row['title'],
6922
                'path' => $row['path'],
6923
                'description' => $row['description'],
6924
                'parent_item_id' => $row['parent_item_id'],
6925
                'previous_item_id' => $row['previous_item_id'],
6926
                'next_item_id' => $row['next_item_id'],
6927
                'display_order' => $row['display_order'],
6928
                'max_score' => $row['max_score'],
6929
                'min_score' => $row['min_score'],
6930
                'mastery_score' => $row['mastery_score'],
6931
                'prerequisite' => $row['prerequisite']
6932
            );
6933
        }
6934
6935
        $this->tree_array($arrLP);
6936
        $arrLP = isset($this->arrMenu) ? $this->arrMenu : null;
@@ 6495-6512 (lines=18) @@
6492
6493
        $result = Database::query($sql);
6494
        $arrLP = array ();
6495
        while ($row = Database :: fetch_array($result)) {
6496
            $arrLP[] = array (
6497
                'id' => $row['id'],
6498
                'item_type' => $row['item_type'],
6499
                'title' => $row['title'],
6500
                'path' => $row['path'],
6501
                'description' => $row['description'],
6502
                'parent_item_id' => $row['parent_item_id'],
6503
                'previous_item_id' => $row['previous_item_id'],
6504
                'next_item_id' => $row['next_item_id'],
6505
                'display_order' => $row['display_order'],
6506
                'max_score' => $row['max_score'],
6507
                'min_score' => $row['min_score'],
6508
                'mastery_score' => $row['mastery_score'],
6509
                'prerequisite' => $row['prerequisite'],
6510
                'max_time_allowed' => $row['max_time_allowed']
6511
            );
6512
        }
6513
6514
        $this->tree_array($arrLP);
6515
        $arrLP = isset($this->arrMenu) ? $this->arrMenu : null;
@@ 6741-6758 (lines=18) @@
6738
                WHERE c_id = ".$course_id." AND lp_id = " . $this->lp_id;
6739
        $result = Database::query($sql);
6740
        $arrLP = array ();
6741
        while ($row = Database :: fetch_array($result)) {
6742
            $arrLP[] = array (
6743
                'id' => $row['id'],
6744
                'item_type' => $row['item_type'],
6745
                'title' => $row['title'],
6746
                'path' => $row['path'],
6747
                'description' => $row['description'],
6748
                'parent_item_id' => $row['parent_item_id'],
6749
                'previous_item_id' => $row['previous_item_id'],
6750
                'next_item_id' => $row['next_item_id'],
6751
                'display_order' => $row['display_order'],
6752
                'max_score' => $row['max_score'],
6753
                'min_score' => $row['min_score'],
6754
                'mastery_score' => $row['mastery_score'],
6755
                'prerequisite' => $row['prerequisite'],
6756
                'max_time_allowed' => $row['max_time_allowed']
6757
            );
6758
        }
6759
6760
        $legend = '<legend>';
6761
        if ($action == 'add')
@@ 7117-7133 (lines=17) @@
7114
7115
        $arrLP = array ();
7116
7117
        while ($row = Database :: fetch_array($result)) {
7118
            $arrLP[] = array (
7119
                'id' => $row['id'],
7120
                'item_type' => $row['item_type'],
7121
                'title' => $row['title'],
7122
                'path' => $row['path'],
7123
                'description' => $row['description'],
7124
                'parent_item_id' => $row['parent_item_id'],
7125
                'previous_item_id' => $row['previous_item_id'],
7126
                'next_item_id' => $row['next_item_id'],
7127
                'display_order' => $row['display_order'],
7128
                'max_score' => $row['max_score'],
7129
                'min_score' => $row['min_score'],
7130
                'mastery_score' => $row['mastery_score'],
7131
                'prerequisite' => $row['prerequisite']
7132
            );
7133
        }
7134
7135
        $this->tree_array($arrLP);
7136
        $arrLP = isset($this->arrMenu) ? $this->arrMenu : null;
@@ 7342-7358 (lines=17) @@
7339
        $result = Database::query($sql);
7340
        $arrLP = array ();
7341
7342
        while ($row = Database :: fetch_array($result)) {
7343
            $arrLP[] = array(
7344
                'id' => $row['id'],
7345
                'item_type' => $row['item_type'],
7346
                'title' => $row['title'],
7347
                'path' => $row['path'],
7348
                'description' => $row['description'],
7349
                'parent_item_id' => $row['parent_item_id'],
7350
                'previous_item_id' => $row['previous_item_id'],
7351
                'next_item_id' => $row['next_item_id'],
7352
                'max_score' => $row['max_score'],
7353
                'min_score' => $row['min_score'],
7354
                'mastery_score' => $row['mastery_score'],
7355
                'prerequisite' => $row['prerequisite'],
7356
                'display_order' => $row['display_order']
7357
            );
7358
        }
7359
7360
        $this->tree_array($arrLP);
7361
@@ 7586-7602 (lines=17) @@
7583
7584
        $result = Database::query($sql);
7585
        $arrLP = array ();
7586
        while ($row = Database :: fetch_array($result)) {
7587
            $arrLP[] = array(
7588
                'id' => $row['id'],
7589
                'item_type' => $row['item_type'],
7590
                'title' => $row['title'],
7591
                'path' => $row['path'],
7592
                'description' => $row['description'],
7593
                'parent_item_id' => $row['parent_item_id'],
7594
                'previous_item_id' => $row['previous_item_id'],
7595
                'next_item_id' => $row['next_item_id'],
7596
                'display_order' => $row['display_order'],
7597
                'max_score' => $row['max_score'],
7598
                'min_score' => $row['min_score'],
7599
                'mastery_score' => $row['mastery_score'],
7600
                'prerequisite' => $row['prerequisite']
7601
            );
7602
        }
7603
7604
        $this->tree_array($arrLP);
7605
        $arrLP = isset($this->arrMenu) ? $this->arrMenu : null;
@@ 7879-7895 (lines=17) @@
7876
        $result = Database::query($sql);
7877
        $arrLP = array();
7878
7879
        while ($row = Database :: fetch_array($result)) {
7880
            $arrLP[] = array(
7881
                'id' => $row['id'],
7882
                'item_type' => $row['item_type'],
7883
                'title' => $row['title'],
7884
                'path' => $row['path'],
7885
                'description' => $row['description'],
7886
                'parent_item_id' => $row['parent_item_id'],
7887
                'previous_item_id' => $row['previous_item_id'],
7888
                'next_item_id' => $row['next_item_id'],
7889
                'display_order' => $row['display_order'],
7890
                'max_score' => $row['max_score'],
7891
                'min_score' => $row['min_score'],
7892
                'mastery_score' => $row['mastery_score'],
7893
                'prerequisite' => $row['prerequisite']
7894
            );
7895
        }
7896
7897
        $this->tree_array($arrLP);
7898
        $arrLP = isset($this->arrMenu) ? $this->arrMenu : null;
@@ 8088-8104 (lines=17) @@
8085
8086
        $result = Database::query($sql);
8087
        $arrLP = array();
8088
        while ($row = Database :: fetch_array($result)) {
8089
            $arrLP[] = array (
8090
                'id' => $row['id'],
8091
                'item_type' => $row['item_type'],
8092
                'title' => $row['title'],
8093
                'path' => $row['path'],
8094
                'description' => $row['description'],
8095
                'parent_item_id' => $row['parent_item_id'],
8096
                'previous_item_id' => $row['previous_item_id'],
8097
                'next_item_id' => $row['next_item_id'],
8098
                'display_order' => $row['display_order'],
8099
                'max_score' => $row['max_score'],
8100
                'min_score' => $row['min_score'],
8101
                'mastery_score' => $row['mastery_score'],
8102
                'prerequisite' => $row['prerequisite']
8103
            );
8104
        }
8105
8106
        $this->tree_array($arrLP);
8107
        $arrLP = isset($this->arrMenu) ? $this->arrMenu : null;