chamilo / chamilo-lms

		header('Location: '.Security::remove_XSS($_GET['page']).'?id_session='.$id_session);

		exit();

	}

} else {

	$sql = "SELECT user_id

	        FROM $tbl_session_rel_course_rel_user

	        WHERE

                session_id = '$id_session' AND

                c_id = '".$courseId."' AND

                status = 2 ";

	$rs = Database::query($sql);

	if (Database::num_rows($rs) > 0) {

		while ($infos = Database::fetch_array($rs)) {

			$arr_infos[] = $infos['user_id'];

		}

	}

}

$order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';

                LIMIT 0,1";

        $q_last_connection = Database::query($sql);

        if (Database::num_rows($q_last_connection) > 0) {

            $current_time = api_get_utc_datetime();

            $row = Database::fetch_array($q_last_connection);

            $i_id_last_connection = $row['login_id'];

            $sql = "UPDATE $tbl_track_login

                    SET logout_date='".$current_time."'

                    WHERE login_id = $i_id_last_connection";

            Database::query($sql);

        }

    }

    if ($myLP->get_type() == 2) {

$course_id = api_get_course_int_id();

if ($learnpath_id == 0) {

    $is_new = true;

    $sql        = "SELECT id FROM " . $tbl_lp . " WHERE c_id = $course_id ORDER BY id DESC LIMIT 0, 1";

    $result     = Database::query($sql);

    $row        = Database::fetch_array($result);

    $learnpath_id = $row['id'];

}

$sql_query = "SELECT * FROM $tbl_lp WHERE c_id = $course_id AND id = $learnpath_id";