Code Duplication    Length = 6-7 lines in 3 locations

index.php 1 location

@@ 86-92 (lines=7) @@
83
                WHERE login_user_id = '".$_user['user_id']."'
84
                ORDER BY login_date DESC LIMIT 1";
85
        $result_last_login = Database::query($sql);
86
        if (!$result_last_login) {
87
            if (Database::num_rows($result_last_login) > 0) {
88
                $user_last_login_datetime = Database::fetch_array($result_last_login);
89
                $user_last_login_datetime = $user_last_login_datetime[0];
90
                Session::write('user_last_login_datetime', $user_last_login_datetime);
91
            }
92
        }
93
    }
94
} else {
95
    // Only if login form was not sent because if the form is sent the user was already on the page.

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

@@ 789-795 (lines=7) @@
786
                $group_table = Database::get_course_table(TABLE_GROUP);
787
                $sql = "SELECT * FROM $group_table WHERE c_id = " . $_course['real_id'] . " AND id = '$group_id'";
788
                $result = Database::query($sql);
789
                if (Database::num_rows($result) > 0) { // This group has recorded status related to this course
790
                    $gpData = Database::fetch_array($result);
791
                    $_gid = $gpData ['id'];
792
                    Session::write('_gid', $_gid);
793
                } else {
794
                    Session::erase('_gid');
795
                }
796
            } elseif (isset($_SESSION['_gid']) or isset($_gid)) { // Keys missing => not anymore in the group - course relation
797
                Session::erase('_gid');
798
            }

main/install/install.lib.php 1 location

@@ 514-519 (lines=6) @@
511
 */
512
function get_config_param_from_db($param = '')
513
{
514
    if (($res = Database::query("SELECT * FROM settings_current WHERE variable = '$param'")) !== false) {
515
        if (Database::num_rows($res) > 0) {
516
            $row = Database::fetch_array($res);
517
            return $row['selected_value'];
518
        }
519
    }
520
    return null;
521
}
522