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 team_t WHERE team_id='$team'");
if($result != 0){
$team_id = mysql_result($result,0,"team_id");
$club_id = mysql_result($result,0,"club_id");
$country_id = mysql_result($result,0,"country_id");
$name = mysql_result($result,0,"name");
$team_name = mysql_result($result,0,"name");
$established = mysql_result($result,0,"established");
$use_pa = mysql_result($result,0,"use_pa");
$postal_address = mysql_result($result,0,"postal_address");
$use_fax = mysql_result($result,0,"use_fax");
$fax = mysql_result($result,0,"fax");
$use_tel = mysql_result($result,0,"use_tel");
$telephone = mysql_result($result,0,"telephone");
$use_email = mysql_result($result,0,"use_email");
$email = mysql_result($result,0,"email");
$use_cp = mysql_result($result,0,"use_cp");
$contact_person = mysql_result($result,0,"contact_person");
$gender = mysql_result($result,0,"gender");
$use_logo = mysql_result($result,0,"use_logo");
$logo = mysql_result($result,0,"logo");
$publish = mysql_result($result,0,"publish");
$league_id = mysql_result($result,0,"league_id");
$contact_phone_home = mysql_result($result,0,"contact_phone_home");
$contact_phone_work = mysql_result($result,0,"contact_phone_work");
$use_cp_home = mysql_result($result,0,"use_cp_home");
$use_cp_work = mysql_result($result,0,"use_cp_work");
if ($publish != 1) { header("Location: http://$SERVER_NAME/error.php"); exit; }
$country = $country_id;
$club_info = mysql_query( "SELECT name, postal_address, fax, telephone, email, contact_person, contact_phone_home, contact_phone_work from club_t where team_id='$club'");
if ($use_pa == 1) {
$postal_address = mysql_result($club_info,0,"postal_address");
}
if ($use_fax == 1) {
$fax = mysql_result($club_info,0,"fax");
}
if ($use_tel == 1) {
$telephone = mysql_result($club_info,0,"telephone");
}
if ($use_email == 1) {
$email = mysql_result($club_info,0,"email");
}
if ($use_cp == 1) {
$contact_person = mysql_result($club_info,0,"contact_person");
}
if($use_cp_home == 1) {
$contact_phone_home = mysql_result($club_info,0,"contact_phone_home");
}
if($use_cp_work == 1) {
$contact_phone_work = mysql_result($club_info,0,"contact_phone_work");
}
$club_name = mysql_result($club_info,0,"name");
//-----Logo-----
if ($use_logo == '0') {
$resultMainLogo = mysql_query ("SELECT logo_id, team_id, filename
FROM logo_t
WHERE logo_id = '$logo'
");
if ($row = mysql_fetch_array($resultMainLogo)) {
$MainLogoID = mysql_result($resultMainLogo,0,"logo_id");
$MainLogoName = mysql_result($resultMainLogo,0,"filename");
}
} else {
$resultMainLogo = mysql_query ("SELECT logo_id, team_id, logo_main, filename
FROM logo_t
WHERE team_id = '$club_id'
AND logo_main = 1
");
if ($row = mysql_fetch_array($resultMainLogo)) {
$MainLogoID = mysql_result($resultMainLogo,0,"logo_id");
$MainLogoName = mysql_result($resultMainLogo,0,"filename");
}
}
//-----League-----
$resultLeague = mysql_query ("SELECT league_id, leaguename, league_level, publish, country_id FROM league_t WHERE league_id = $league_id AND publish='1'");
if ($row = mysql_fetch_array($resultLeague)) {
$LeagueID = mysql_result($resultLeague,0,"league_id");
$LeagueName = mysql_result($resultLeague,0,"leaguename");
$LeagueLevel = mysql_result($resultLeague,0,"league_level");
$LeagueCountry = mysql_result($resultLeague,0,"country_id");
}
//-----Ground-----
$resultCurrentGround = mysql_query ("SELECT ground_t.ground_id, ground_team_t.team_id, ground_team_t.ground_id, ground_t.g_name, ground_team_t.date_to
FROM ground_t, ground_team_t
WHERE ground_team_t.team_id='$team_id'
AND g_publish = 1
AND ground_t.ground_id=ground_team_t.ground_id
AND (ground_team_t.date_to = ''
OR ground_team_t.date_to IS NULL)");
//-----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 ($team != "") {
$pagetitle = "WFD - $name";
} else {
$pagetitle = "World Football Organization";
$disp_teamname = $e_Unable;
}
$metawords = "$countryname, $name";
// --------------------------------------------------------------------------------------
include "includes/head-body.php";
include "includes/haus-adal.php";
include "includes/menu-wff.php";
include "includes/menu-database.php";
$c2 = "arrow.gif";
//$t5 = "arrow.gif";
include "includes/main-left-country.php";
// --------------------------------------------------------------------------------------
// --------------------------------------------------------------------------------------
echo "
";
echo "
"; echo "$team_name"; echo " |
echo $m_Club; ?>: | echo "$club_name"; ?> |
echo $m_League ?>: | echo "$LeagueName"; echo " [$m_Level: $LeagueLevel]"; //Fáni ef annað land if ($LeagueCountry != $country) { $new_query = mysql_query("SELECT country_id, $lang from country_t where country_id='$LeagueCountry'"); $thatname = mysql_result($new_query,0,$lang); echo " "; } ?> |
echo $m_Ground ?>: |
do {
print ("");
print $row["g_name"];
print (" \n"); } while($row = mysql_fetch_array($resultCurrentGround)); ?> |
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 $h_ContactInformation ?> |
if ($postal_address !="") { ?>
echo $m_PostalAddress ?>: echo "$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: "; $ShowFaxs = str_replace ("//", " ", "$fax"); echo "$ShowFaxs "; } if ($email != "") { echo "$m_Email: "; echo "$email "; } ?> |