ob_start();
include('includes/class.gzip_encode.php');
include "includes/connect.php";
include "includes/functions.php";
include "includes/language.php";
// --------------------------------------------------------------------------------------
if ($ground == ""){
$ground = '%';
}
if ($lang == "" || !$lang) {
$lang = "ENG";
}
$result = mysql_query ("SELECT * FROM ground_t
WHERE ground_id=$ground
");
$LocationID = mysql_result($result,0,"location_id");
$country_id = mysql_result($result,0,"country_id");
$g_name = mysql_result($result,0,"g_name");
$built = mysql_result($result,0,"built");
$capacity = mysql_result($result,0,"capacity");
$scapacity = mysql_result($result,0,"scapacity");
$postal_address = mysql_result($result,0,"postal_address");
$g_website = mysql_result($result,0,"g_website");
$g_telephone = mysql_result($result,0,"g_telephone");
$g_fax = mysql_result($result,0,"g_fax");
$g_width = mysql_result($result,0,"g_width");
$g_length = mysql_result($result,0,"g_length");
if ($ground != "") {
$resultname = mysql_query("SELECT ground_id, g_name FROM ground_t WHERE ground_id='$ground'");
$disp_groundname = mysql_result($resultname,0,"g_name");
$pagetitle = "WFD - $disp_groundname";
} else {
$pagetitle = "World Football Organization";
$disp_groundname = $e_Unable;
}
if ($country != "") {
} else {
$getcountry = mysql_query("SELECT ground_id, country_id FROM ground_t WHERE ground_id='$ground'");
$country = mysql_result($getcountry,0,"country_id");
}
//-----Location-----
$resultLocation = mysql_query ("SELECT location_t.location_id, ground_t.ground_id, location_t.country_id, location_t.l_name, location_t.district
FROM ground_t, location_t
WHERE ground_t.location_id = location_t.location_id
AND ground_t.ground_id = '$ground'
");
if ($row = mysql_fetch_array($resultLocation)) {
$LocationID = mysql_result($resultLocation,0,"location_id");
$LocationName = mysql_result($resultLocation,0,"l_name");
$LocationDistrict = mysql_result($resultLocation,0,"district");
}
//-----Region of location-----
$resultRegion = mysql_query ("SELECT district_id, d_name
FROM location_district_t
WHERE district_id = '$LocationDistrict'
");
if ($row = mysql_fetch_array($resultRegion)) {
$RegionName = mysql_result($resultRegion,0,"d_name");
}
//-----Country name check-----
$getcountry = mysql_query("SELECT country_id, $lang FROM country_t WHERE country_id='$country'");
$country = mysql_result($getcountry,0,"country_id");
$countryname = mysql_result($getcountry,0,$lang);
$metawords = "$countryname, $g_name, $LocationName";
include "includes/head-body.php";
include "includes/haus-adal.php";
include "includes/menu-wff.php";
include "includes/menu-database.php";
$c3 = "arrow.gif";
include "includes/main-left-country.php";
?>
echo "
";
echo "
"; echo "$g_name"; echo " |
$m_Name: | "; echo "$g_name | $m_Built: | "; echo "$built | \n"; } if ($capacity != "") { echo "$m_Capacity: | "; echo ""; echo number_format ($capacity, 0, ',', '.'); echo " | \n"; } if ($scapacity != "") { echo "$m_Seating: | "; echo ""; echo number_format ($scapacity, 0, ',', '.'); echo " | \n"; } if ($g_length != "" && $g_width != "") { echo "$m_PitchSize: | "; echo "$g_length x $g_width $m_meters | \n"; } if ($g_website != "") { echo "$m_Website: | "; echo "$g_website | \n"; } if ($LocationID != "") { echo "$m_Location: | "; echo "$LocationName"; if ($RegionName != "") { echo " ($RegionName)"; } echo " | \n"; } ?>
echo $h_ContactInformation ?> |
if ($postal_address !="") { ?>
echo $m_PostalAddress ?>: echo "$g_name "; $ShowAddress = str_replace ("//", " ", "$postal_address"); echo "$ShowAddress "; if ($country == "ENG" || $country == "WAL" || $country == "NIR" || $country == "SCO") { echo "$Postal_UK "; } else { echo "$countryname "; } } ?> |
if ($g_telephone != "") {
echo "$m_PhoneNumber: "; echo "$g_telephone "; } if ($g_fax != "") { echo "$m_FaxNumber: "; echo "$g_fax "; } ?> |
echo $h_UsingGround ?> |