chamilo / chamilo-lms

     * Count sessions

     * @return int Number of sessions counted

     */

    public static function countSessions()

    {

        $session_table = Database :: get_main_table(TABLE_MAIN_SESSION);

        $access_url_rel_session_table= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

        if (api_is_multiple_url_enabled()) {

            $current_url_id = api_get_current_access_url_id();

            $sql = "SELECT COUNT(id) AS number

                    FROM ".$session_table." as s, ".$access_url_rel_session_table." as u

                    WHERE u.session_id=s.id AND access_url_id='".$current_url_id."'";

        } else {

            $sql = "SELECT COUNT(id) AS number

                    FROM ".$session_table." ";

        }

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

        $obj = Database::fetch_object($res);

        return $obj->number;

    }

    /**

     * Count activities from track_e_default_table

     * @param    int        Session id (optional)

     * @return    int        count of visited links

     */

    public static function count_student_visited_links($student_id, $courseId, $session_id = 0)

    {

        $student_id  = intval($student_id);

        $courseId = intval($courseId);

        $session_id  = intval($session_id);

        // table definition

        $table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_LINKS);

        $sql = 'SELECT 1

                FROM '.$table.'

                WHERE

                    links_user_id= '.$student_id.' AND

                    c_id = "'.$courseId.'" AND

                    links_session_id = '.$session_id.' ';

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

        return Database::num_rows($rs);

    }

    /**

     * Get count student downloaded documents

     * @param    int        Session id (optional)

     * @return    int        Count downloaded documents

     */

    public static function count_student_downloaded_documents($student_id, $courseId, $session_id = 0)

    {

        $student_id  = intval($student_id);

        $courseId = intval($courseId);

        $session_id  = intval($session_id);

        // table definition

        $table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);

        $sql = 'SELECT 1

                FROM ' . $table . '

                WHERE down_user_id = '.$student_id.'

                AND c_id  = "'.$courseId.'"

                AND down_session_id = '.$session_id.' ';

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

        return Database::num_rows($rs);

    }

    /**

     * Get course list inside a session from a student