chamilo / chamilo-lms

					ORDER BY lastname,firstname";

		$filename = 'export_users_'.$course_code.'_'.api_get_local_time();

	} else {

		if (api_is_multiple_url_enabled()) {

			$tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

			$access_url_id = api_get_current_access_url_id();

			if ($access_url_id != -1) {

			$sql.= " FROM $user_table u

					INNER JOIN $tbl_user_rel_access_url as user_rel_url

				ON (u.user_id= user_rel_url.user_id)

				WHERE access_url_id = $access_url_id

				ORDER BY lastname,firstname";

			}

		} else {

			$sql .= " FROM $user_table u ORDER BY lastname,firstname";

		}

		$filename = 'export_users_'.api_get_local_time();

	}

	$data = array();

        FROM $tbl_user

        WHERE status='1'".$order_clause;

if (api_is_multiple_url_enabled()) {

	$table_access_url_rel_user= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

	$access_url_id = api_get_current_access_url_id();

	if ($access_url_id != -1) {

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

		        FROM $tbl_user u

                INNER JOIN $table_access_url_rel_user url_rel_user

                ON (url_rel_user.user_id = u.user_id)

			    WHERE status='1' AND access_url_id = '$access_url_id' $order_clause";

	}

}

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

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

                        WHERE status = '1' ".

                        $orderClause;

                if (api_is_multiple_url_enabled()) {

                    $userRelAccessUrlTable = Database::get_main_table(

                        TABLE_MAIN_ACCESS_URL_REL_USER

                    );

                    $accessUrlId = api_get_current_access_url_id();

                    if ($accessUrlId != -1) {

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

                        FROM $tbl_user user

                        INNER JOIN $userRelAccessUrlTable url_user

                        ON (url_user.user_id = user.user_id)

                        WHERE

                            access_url_id = $accessUrlId AND

                            status = 1 "

                            .$orderClause;

                    }

                }

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

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