ob_start();
include('includes/class.gzip_encode.php');
include "includes/connect.php";
include "includes/functions.php";
include "includes/language.php";
// --------------------------------------------------------------------------------------
//-----Team details-----
$result = mysql_query("SELECT * FROM club_t WHERE team_id='$club'");
if($result != 0){
$team_id = mysql_result($result,0,"team_id");
$country_id = mysql_result($result,0,"country_id");
$name = mysql_result($result,0,"name");
$full_name = mysql_result($result,0,"full_name");
$founded = mysql_result($result,0,"founded");
$postal_address = mysql_result($result,0,"postal_address");
$location_id = mysql_result($result,0,"location_id");
$fax = mysql_result($result,0,"fax");
$telephone = mysql_result($result,0,"telephone");
$email = mysql_result($result,0,"email");
$contact_person = mysql_result($result,0,"contact_person");
$publish = mysql_result($result,0,"publish");
$founded_year = mysql_result($result,0,"founded_year");
$contact_phone_home = mysql_result($result,0,"contact_phone_home");
$contact_phone_work = mysql_result($result,0,"contact_phone_work");
$country = $country_id;
//-----Location-----
$resultLocation = mysql_query ("SELECT location_t.location_id, club_t.team_id, location_t.country_id, location_t.l_name, location_t.district
FROM club_t, location_t
WHERE club_t.location_id = location_t.location_id
AND club_t.team_id = '$club'
");
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");
$RegionID = mysql_result($resultRegion,0,"district_id");
}
//-----Logo-----
$resultMainLogo = mysql_query ("SELECT logo_id, team_id, logo_main, filename
FROM logo_t
WHERE team_id = '$club'
AND logo_main = 1
");
if ($row = mysql_fetch_array($resultMainLogo)) {
$MainLogoID = mysql_result($resultMainLogo,0,"logo_id");
$MainLogoName = mysql_result($resultMainLogo,0,"filename");
}
//-----GET TEAMS----
$resultTeams = mysql_query ("SELECT team_id, club_id, name, gender, publish, league_id FROM team_t WHERE club_id='$club' AND publish=1");
//-----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);
//-----Pagetitle & META-----
if ($club != "") {
$pagetitle = "WFD - $name";
} else {
$pagetitle = "World Football Organization";
$disp_clubname2 = $e_Unable;
}
$metawords = "$countryname, $name, $full_name, $LeagueName, $LocationName";
// --------------------------------------------------------------------------------------
include "includes/head-body.php";
include "includes/haus-adal.php";
include "includes/menu-wff.php";
include "includes/menu-database.php";
$c2 = "arrow.gif";
$t1 = "arrow.gif";
include "includes/main-left-country.php";
// --------------------------------------------------------------------------------------
// --------------------------------------------------------------------------------------
echo "
";
echo "
"; echo "$name"; echo " |
echo $m_FullName; ?>: | echo $full_name ?> |
echo $m_Founded ?>: | echo $date ?> |
echo $m_Location ?>: | echo "$LocationName"; if ($RegionName != "") { echo " ($RegionName)"; } ?> |
echo "$m_Contact"; ?>: | echo "$contact_person"; ?> if ($contact_phone_home != "" || $contact_phone_work != "") { echo " (".$m_PhoneNumber.": "; if ($contact_phone_home != "") { echo $contact_phone_home; } if ($contact_phone_home != "" && $contact_phone_work != "") { echo " / "; } if ($contact_phone_work != "") { echo $contact_phone_work; } echo ")"; } ?> |
echo $m_Teams; ?> |
echo $m_Name; ?> | echo $m_League; ?> | |
"; $gender = $row["gender"]; if ($gender == 0) { echo ""; } else { echo ""; } echo " | "); print $row["name"]; print (" | ");
/* $resultTeamLeague = mysql_query ("SELECT * FROM league_t WHERE league_id = $thisleague");
if ($row = mysql_fetch_array($resultTeamLeague)) {
$LeagueID = mysql_result($resultTeamLeague,0,"league_id");
*/
$resultThisLeague = mysql_query ("SELECT league_id, leaguename, country_id, league_level, publish from league_t where league_id='$thisteamleague' AND publish='1'");
if ($row = mysql_fetch_array($resultThisLeague)) {
$LeagueName = $row["leaguename"];
$thisleague = $row["league_id"];
$thisleaguecountry = $row["country_id"];
$thisleaguelevel = $row["league_level"];
echo "";
echo str_replace("//", " ", $LeagueName); echo ""; echo " [$m_Level: $thisleaguelevel]"; } // } print (" |
echo $h_ContactInformation ?> |
if ($postal_address !="") { ?>
echo $m_PostalAddress ?>: echo "$full_name "; if ($contact_person != "") { echo "$contact_person "; } $ShowAddress = str_replace ("//", " ", "$postal_address"); echo "$ShowAddress "; if ($country == "ENG" || $country == "WAL" || $country == "NIR" || $country == "SCO") { echo "$Postal_UK "; } else { echo "$countryname "; } } ?> |
if ($telephone != "") {
echo "$m_PhoneNumber: "; $ShowPhones = str_replace ("//", " ", "$telephone"); echo "$ShowPhones "; } if ($fax != "") { echo "$m_FaxNumber: "; echo "$fax "; } if ($email != "") { echo "$m_Email: "; echo "$email "; } ?> |