chamilo / chamilo-lms

                            scu.user_id = u.id AND scu.status=2 AND login_user_id=u.id

                        GROUP BY user_id ";

        if (api_is_multiple_url_enabled()) {

            $tbl_session_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $sqlCoachs = "SELECT DISTINCT

                                    scu.user_id as id_coach,

                                    u.id as user_id,

                                    lastname,

                                    firstname,

                                    MAX(login_date) as login_date

                                FROM $tbl_user u,

                                $tbl_session_course_user scu,

                                $tbl_track_login ,

                                $tbl_session_rel_access_url session_rel_url

                                WHERE

                                    scu.user_id = u.id AND

                                    scu.status = 2 AND

                                    login_user_id = u.id AND

                                    access_url_id = $access_url_id AND

                                    session_rel_url.session_id = scu.session_id

                                GROUP BY u.id";

            }

        }

        if (!empty($order[$tracking_column])) {

            $sqlCoachs .= " ORDER BY ".$order[$tracking_column]." ".$tracking_direction;

        }

				ON $tbl_user.user_id = s.id_coach

				ORDER BY id";

		if (api_is_multiple_url_enabled()) {

			$tbl_session_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

			$access_url_id = api_get_current_access_url_id();

			if ($access_url_id != -1){

			$sql = "SELECT s.id, name,id_coach,username,access_start_date,access_end_date,visibility,session_category_id

					FROM $tbl_session s

					INNER JOIN $tbl_session_rel_access_url as session_rel_url

					ON (s.id= session_rel_url.session_id)

					INNER JOIN $tbl_user u ON (u.user_id = s.id_coach)

					WHERE access_url_id = $access_url_id

					ORDER BY id";

			}

		}

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

	} else {

//select of sessions

$sql = "SELECT id, name FROM $tbl_session ORDER BY name";

if (api_is_multiple_url_enabled()) {

	$tbl_session_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

	$access_url_id = api_get_current_access_url_id();

	if ($access_url_id != -1){

	$sql = "SELECT s.id, name FROM $tbl_session s

			INNER JOIN $tbl_session_rel_access_url as session_rel_url

			ON (s.id = session_rel_url.session_id)

			WHERE access_url_id = $access_url_id

			ORDER BY name";

	}

}

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

$Sessions = Database::store_result($result);

        //we filter the courses from the URL

        $join_access_url = $where_access_url = '';

        if (api_get_multiple_access_url()) {

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $tbl_url_course = Database:: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

                $join_access_url = "LEFT JOIN $tbl_url_course url_rel_course

                                    ON url_rel_course.c_id = tcfv.item_id ";

                $where_access_url = " AND access_url_id = $access_url_id ";

            }

        }

        $extraFieldType = EntityExtraField::COURSE_FIELD_TYPE;

        //we filter the courses from the URL

        $joinAccessUrl = '';

        $whereAccessUrl = '';

        if (api_get_multiple_access_url()) {

            $accessUrlId = api_get_current_access_url_id();

            if ($accessUrlId != -1) {

                $tblUrlCourse = Database:: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

                $joinAccessUrl = "LEFT JOIN $tblUrlCourse url_rel_course

                                    ON url_rel_course.c_id = c.id ";

                $whereAccessUrl = " AND access_url_id = $accessUrlId ";

            }

        }

        // get course list auto-register

        $sql = "SELECT DISTINCT(c.code)

        // We filter the courses from the URL

        $join_access_url = $where_access_url = '';

        if (api_get_multiple_access_url()) {

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $tbl_url_course = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

                $join_access_url = "LEFT JOIN $tbl_url_course url_rel_course ON url_rel_course.c_id = course.id";

                $where_access_url = " AND access_url_id = $access_url_id ";

            }

        }

        // Courses in which we subscribed out of any session

        $tbl_user_course_category = Database :: get_main_table(TABLE_USER_COURSE_CATEGORY);