chamilo / chamilo-lms

            ORDER BY login_course_date DESC LIMIT 1";

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

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

            $courseAccessId = Database::result($result, 0, 0);

            $sql = "UPDATE $tableCourseAccess

                SET logout_course_date = '$currentDate', counter = counter+1

                WHERE course_access_id = $courseAccessId";

            Database::query($sql);

        } else {

            $ip = api_get_real_ip();

            $sql = "INSERT INTO $tableCourseAccess 

                      (c_id, user_ip, user_id, login_course_date, logout_course_date, counter, session_id)

                    VALUES 

                      ($courseId, '$ip', $userId, '$currentDate', '$currentDate', 1, $sessionId)";

            Database::query($sql);

        }

    }

}

            $count_row_lp = Database::num_rows($res_row_lp);

            // calculates time

            if ($count_row_lp > 0) {

                while ($row_lp = Database::fetch_array($res_row_lp)) {

                    $lp_id = intval($row_lp['id']);

                    $sql = "SELECT SUM(total_time)

                            FROM $t_lpiv AS item_view

                            INNER JOIN $t_lpv AS view

                            ON (

                                item_view.lp_view_id = view.id AND

                                item_view.c_id = view.c_id

                            )

                            WHERE

                                item_view.c_id = $course_id AND

                                view.c_id = $course_id AND

                                view.lp_id = $lp_id AND

                                view.user_id = $student_id AND

                                session_id = $session_id";

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

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

                        $total_time += Database::result($rs, 0, 0);

                    }

                }

            }

        }

        return $total_time;