chamilo / chamilo-lms

    exit;

}

if (api_get_multiple_access_url()) {

    $table_access_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

    $access_url_id = api_get_current_access_url_id();

    $sql = "SELECT s.id, s.name  FROM $tbl_session s INNER JOIN $table_access_url_rel_session u ON s.id = u.session_id $where AND u.access_url_id = $access_url_id ORDER BY name";

} else {

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

}

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

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

?>

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

if (api_is_multiple_url_enabled()) {

    $tbl_access_rel_user= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

    $access_url_id = api_get_current_access_url_id();

    $sql = "SELECT u.user_id,lastname,firstname,username

            FROM $tbl_user u

            LEFT JOIN $tbl_access_rel_user  a

            ON(u.user_id= a.user_id)

            WHERE

                status='1' AND

                active = 1 AND

                access_url_id = $access_url_id ".

            $order_clause;

} else {

    $sql = "SELECT user_id,lastname,firstname,username

            FROM $tbl_user

            WHERE

                status = '1' AND

                active = 1 ".

            $order_clause;

}

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

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

            ";

        // Showing only the courses of the current portal access_url_id.

        if (api_is_multiple_url_enabled()) {

            $url_access_id = api_get_current_access_url_id();

            if ($url_access_id != -1) {

                $tbl_url_rel_course = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

                $sql = "SELECT * FROM $tbl_course as course

                    INNER JOIN $tbl_url_rel_course as url_rel_course

                    ON (url_rel_course.c_id = course.id)

                    WHERE

                        access_url_id = $url_access_id AND

                        course.visibility != '0' AND

                        course.visibility != '4' AND

                        category_code = '$category_code'

                        $searchTerm

                        $without_special_courses

                        $visibilityCondition

                    ";

            }

        }

        return Database::num_rows(Database::query($sql));

    }