chamilo / chamilo-lms

$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);

    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);

?>

                    $visibilityCondition

                ";

        // 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'

                        $searchFilter

                        $without_special_courses

                        $visibilityCondition

                    ";

            }

        }

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

    }

				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 {

        $query = "$select FROM $tbl_session s $inject_joins $where $inject_where";

        if (api_is_multiple_url_enabled()) {

            $table_access_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $where.= " AND ar.access_url_id = $access_url_id ";

                $query = "$select

                        FROM $tbl_session s $inject_joins

                        INNER JOIN $table_access_url_rel_session ar

                        ON (ar.session_id = s.id) $where";

            }

        }

        $query .= $order;

        $query .= $limit;

                       ON c.id = scu.c_id

                       $where ";

        if (api_is_multiple_url_enabled()) {

            $table_access_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $where.= " AND ar.access_url_id = $access_url_id ";

                $query_rows = "SELECT count(*) as total_rows

                               FROM $tbl_session s

                               LEFT JOIN  $tbl_session_category sc

                               ON s.session_category_id = sc.id

                               INNER JOIN $tbl_user u

                               ON s.id_coach = u.user_id

                               INNER JOIN $table_access_url_rel_session ar

                               ON ar.session_id = s.id $where ";

            }

        }

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

        $num = 0;

                    course_rel_user.status='1'

        ";

        if (api_get_multiple_access_url()) {

            $tbl_course_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $sql = "

                    SELECT

                        course.code,

                        course.title,

                        course.id,

                        course.id as real_id

                    FROM $tbl_course_user as course_rel_user

                    INNER JOIN $tbl_course as course

                    ON course.id = course_rel_user.c_id

                    INNER JOIN $tbl_course_rel_access_url course_rel_url

                    ON (course_rel_url.c_id = course.id)

                    WHERE

                        access_url_id = $access_url_id  AND

                        course_rel_user.user_id = '$user_id' AND

                        course_rel_user.status = '1'

                ";

            }

        }

        if (!empty($startsWith)) {

            $startsWith = Database::escape_string($startsWith);