| Server IP : 149.202.105.228 / Your IP : 216.73.216.118 Web Server : Apache System : Linux webm129.cluster030.gra.hosting.ovh.net 5.15.167-ovh-vps-grsec-zfs-classid #1 SMP Tue Sep 17 08:14:20 UTC 2024 x86_64 User : atfycaf ( 116275) PHP Version : 7.4.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/a/t/f/atfycaf/www/pdf/ |
Upload File : |
<?php
if (!isset($_GET["leagueID"])) {
header("Location: /");
}
include "../globalVars.php";
$leagueID = $_GET["leagueID"];
$leagueQuery = mysqli_query($conn, "SELECT * FROM leagueConfig WHERE id = '$leagueID'");
while ($lQ = mysqli_fetch_array($leagueQuery)) {
$leagueType = $lQ["leagueType"];
$hasMiniLeagues = $lQ["hasMiniLeagues"];
$homeAndAway = $lQ["homeAndAway"];
$hasPlayoff = $lQ["hasPlayoff"];
$startDate = $lQ["startDate"];
$tStartMonth = date("F", strtotime($startDate));
$tStartYear = date("Y", strtotime($startDate));
$startDisplay = date("jS F, Y", strtotime($startDate));
$pointsWin = $lQ["pointsWin"];
$pointsDraw = $lQ["pointsDraw"];
$pointsRink = $lQ["pointsRink"];
}
$leagueGroupQuery = mysqli_query($conn, "SELECT groupTitle FROM leagueGroups WHERE id = '$leagueType'");
while ($lGQ = mysqli_fetch_array($leagueGroupQuery)) {
$leagueGroup = $lGQ["groupTitle"];
}
$leagueTitle = "$leagueGroup $tStartMonth $tStartYear";
$miniLeaguesArray = array();
$miniLeaguesQuery = mysqli_query($conn, "SELECT * FROM leagueMiniLeagues WHERE leagueID = '$leagueID' ORDER BY id ASC");
while ($mLQ = mysqli_fetch_array($miniLeaguesQuery)) {
$miniLeaguesArray[] = $mLQ["id"];
}
$roundTitles = array(9999 => "Final", 9998 => "Semi-Final", 9997 => "Quarter-Final", 99999 => "Final", 99998 => "Semi-Final", 99997 => "Quarter-Final");
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title><?php echo $leagueTitle ?> | <?php echo $companyName ?></title>
<meta name="author" content="www.modsnetwebsitedesign.com"/>
<meta name="DC.Title" content="<?php echo $leagueTitle ?> | <?php echo $companyName ?>"/>
<meta name="DC.Creator" content="https://www.modsnetwebsitedesign.com"/>
<meta name="og:title" content="<?php echo $leagueTitle ?> | <?php echo $companyName ?>">
<meta name="og:description" content="<?php echo $leagueTitle ?> <?php echo $companyName ?>">
<meta name="og:image" content="<?php echo $Iurl ?>og-image.jpg">
<meta name="og:image:secure_url" content="<?php echo $Iurl ?>og-image.jpg">
<meta property="og:updated_time" content="1651497389" />
<meta name="viewport" content="initial-scale=1.0, maximum-scale=1.0, user-scalable=no, width=device-width" />
<link rel="shortcut icon" type="image/x-icon" href="<?php echo $ENurl ?>favicon.ico"/>
<link rel="icon" type="image/ico" href="<?php echo $Iurl ?>favicon.png" />
<link rel="apple-touch-icon" href="<?php echo $Iurl ?>favicon-60.png">
<link rel="apple-touch-icon" sizes="76x76" href="<?php echo $Iurl ?>favicon-76.png">
<link rel="apple-touch-icon" sizes="120x120" href="<?php echo $Iurl ?>favicon-120.png">
<link rel="apple-touch-icon" sizes="152x152" href="<?php echo $Iurl ?>favicon-152.png">
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Arimo:wght@700&family=Open+Sans:wght@400;600;700&family=Roboto:wght@700&display=swap" rel="stylesheet">
<link type="text/css" href="<?php echo $url ?>pdf/stylesheet-fixtures.css" rel="stylesheet" media="all" />
</head>
<body>
<div class="pdfFPage">
<div class="header">
<div class="logo">
<a href="<?php echo $url ?>"><img src="<?php echo $Iurl ?>logo.png" width="69" height="98"alt="<?php echo $leagueTitle ?> | <?php echo $companyName ?>" title="<?php echo $leagueTitle ?> | <?php echo $companyName ?>"></a>
<div class="logoTitle">
<div class="logoTitleT">
<a href="<?php echo $url ?>">
<span class="logoTitleInt">Federación Andaluza de Bolos</span>
<span class="logoTitleAl">AlmerÃa</span>
</a>
</div>
</div>
</div>
<div class="fixturesHeader">
<div class="fixturesHeaderT">
<p><?php echo $leagueTitle ?></p>
</div>
</div>
</div>
<div class="main">
<h1>Playoff Fixtures</h1>
<?php
$m = 0;
$s = 0;
$hasPlayoffFixturesQuery = mysqli_query($conn, "SELECT id from leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (weekID > 1000) ORDER BY weekID ASC");
if (mysqli_num_rows($hasPlayoffFixturesQuery) > 0) {
$playoffFixturesQuery = mysqli_query($conn, "SELECT id from leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (weekID > 10000) ORDER BY weekID ASC");
if (mysqli_num_rows($playoffFixturesQuery) > 0) {
$noRoundsQuery = mysqli_query($conn, "SELECT DISTINCT(weekID) FROM leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (weekID BETWEEN 10000 AND 100000) ORDER BY weekID ASC LIMIT 0,1");
while ($nRQ = mysqli_fetch_array($noRoundsQuery)) {
$lowestWeek = $nRQ["weekID"];
}
for ($thisRound = $lowestWeek; $thisRound <= 99999; $thisRound++) {
if ($thisRound == 99999) {
$roundTitle = "Final";
} elseif ($thisRound == 99998) {
$roundTitle = "Semi-Final";
} elseif ($thisRound == 99997) {
$roundTitle = "Quarter-Final";
} else {
$thisRound = ($weekID - $lowestWeek) + 1;
$roundTitle = "Round $thisRound";
}
$fixtureDateQuery = mysqli_query($conn, "SELECT id, miniLeagueID, fixtureDate FROM leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (weekID = '$thisRound') ORDER BY id ASC LIMIT 0,1");
while ($fDQ = mysqli_fetch_array($fixtureDateQuery)) {
$fixtureID = $fDQ["id"];
$fixtureMLid = $fDQ["miniLeagueID"];
$fixtureDateSQL = $fDQ["fixtureDate"];
$fixtureDate = date("jS F, Y", strtotime($fixtureDateSQL));
}
$drawnTeamsArray = array();
$playoffsSetTeamsQuery = mysqli_query($conn, "SELECT homeTeam, awayTeam FROM leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (weekID = '$thisRound') ORDER BY id ASC");
while ($pSTQ = mysqli_fetch_array($playoffsSetTeamsQuery)) {
if (trim($pSTQ["homeTeam"])) {
$drawnTeamsArray[] = $pSTQ["homeTeam"];
}
if (trim($pSTQ["awayTeam"])) {
$drawnTeamsArray[] = $pSTQ["awayTeam"];
}
}
?>
<div class="fixturesWeek">
<div class="weekHeader"><?php echo $fixtureDate ?></div>
<?php
$noFixturesQuery = mysqli_query($conn, "SELECT * FROM leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (fixtureDate = '$fixtureDateSQL')");
if (mysqli_num_rows($noFixturesQuery) > 1) {
while ($nFQ = mysqli_fetch_array($noFixturesQuery)) {
$homeTeam = $nFQ["homeTeam"];
$homeScore = $nFQ["homeScore"];
$homeRinkPts = $nFQ["homeRinkPts"];
$awayTeam = $nFQ["awayTeam"];
$awayScore = $nFQ["awayScore"];
$awayRinkPts = $nFQ["awayRinkPts"];
$firstLegID = $nFQ["firstLegID"];
if ($homeScore == -1) {
$homeScore = "";
$homeRinkPts = "";
}
if ($awayScore == -1) {
$awayScore = "";
$awayRinkPts = "";
}
if ($m == 0) {
if ($hasPlayoff == 1 || $hasPlayoff == 3) {
if ($firstLegID == 0) {
$miniLeagueTitle .= " 1st Leg";
} else {
$miniLeagueTitle .= " 2nd Leg";
}
}
} else {
$miniLeagueTitle = " ";
}
?>
<div class="fixturesGroup">
<div class="mlHeader"><?php echo $roundTitle ?></div>
<?php
if ($m == 0 || $m == 1) {
?>
<div class="fixturesLegend">
<div class="homeTeam">
<div class="teamName"> </div>
<div class="teamRink">Rink Pts</div>
<div class="teamScore">Score</div>
</div>
<div class="fixturesVersus"> </div>
<div class="awayTeam">
<div class="teamScore">Score</div>
<div class="teamRink">Rink Pts</div>
<div class="teamName"> </div>
</div>
</div>
<?php
}
?>
<div class="fixturesMatch">
<div class="homeTeam">
<div class="teamName"><?php echo $homeTeam ?></div>
<div class="teamRink"><?php echo $homeRinkPts ?></div>
<div class="teamScore"><?php echo $homeScore ?></div>
</div>
<div class="fixturesVersus">Vs</div>
<div class="awayTeam">
<div class="teamScore"><?php echo $awayScore ?></div>
<div class="teamRink"><?php echo $awayRinkPts ?></div>
<div class="teamName"><?php echo $awayTeam ?></div>
</div>
</div>
</div>
<?php
$m++;
}
} else {
while ($nFQ = mysqli_fetch_array($noFixturesQuery)) {
$homeTeam = $nFQ["homeTeam"];
$homeScore = $nFQ["homeScore"];
$homeRinkPts = $nFQ["homeRinkPts"];
$awayTeam = $nFQ["awayTeam"];
$awayScore = $nFQ["awayScore"];
$awayRinkPts = $nFQ["awayRinkPts"];
$firstLegID = $nFQ["firstLegID"];
if ($homeScore == -1) {
$homeScore = "";
$homeRinkPts = "";
}
if ($awayScore == -1) {
$awayScore = "";
$awayRinkPts = "";
}
if ($hasPlayoff == 1 || $hasPlayoff == 3) {
if ($firstLegID == 0) {
$miniLeagueTitle .= " 1st Leg";
} else {
$miniLeagueTitle .= " 2nd Leg";
}
}
?>
<div class="fixturesSingle">
<div class="mlHeader"><?php echo $miniLeagueTitle ?></div>
<?php
if ($s == 0) {
?>
<div class="fixturesLegend">
<div class="homeTeam">
<div class="teamName"> </div>
<div class="teamRink">Rink Pts</div>
<div class="teamScore">Score</div>
</div>
<div class="fixturesVersus"> </div>
<div class="awayTeam">
<div class="teamScore">Score</div>
<div class="teamRink">Rink Pts</div>
<div class="teamName"> </div>
</div>
</div>
<?php
}
?>
<div class="fixturesMatch">
<div class="homeTeam">
<div class="teamName"><?php echo $homeTeam ?></div>
<div class="teamRink"><?php echo $homeRinkPts ?></div>
<div class="teamScore"><?php echo $homeScore ?></div>
</div>
<div class="fixturesVersus">Vs</div>
<div class="awayTeam">
<div class="teamScore"><?php echo $awayScore ?></div>
<div class="teamRink"><?php echo $awayRinkPts ?></div>
<div class="teamName"><?php echo $awayTeam ?></div>
</div>
</div>
</div>
<?php
$s++;
}
}
?>
</div>
<?php
}
} else {
$playoffDatesQuery = mysqli_query($conn, "SELECT DISTINCT fixtureDate FROM leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (weekID > '1000') ORDER BY weekID ASC, fixtureDate ASC");
while ($pDQ = mysqli_fetch_array($playoffDatesQuery)) {
$fixtureDateSQL = $pDQ["fixtureDate"];
$fixtureDate = date("jS F, Y", strtotime($fixtureDateSQL));
?>
<div class="fixturesWeek">
<div class="weekHeader"><?php echo $fixtureDate ?></div>
<?php
$noRoundsQuery = mysqli_query($conn, "SELECT DISTINCT(weekID) FROM leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (weekID BETWEEN 10000 AND 100000) ORDER BY weekID ASC LIMIT 0,1");
while ($nRQ = mysqli_fetch_array($noRoundsQuery)) {
$lowestWeek = $nRQ["weekID"];
}
$roundTitleQuery = mysqli_query($conn, "SELECT weekID FROM leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (fixtureDate = '$fixtureDateSQL')");
while ($rTQ = mysqli_fetch_array($roundTitleQuery)) {
$roundTitle = $rTQ["weekID"];
}
if (array_key_exists($roundTitle, $roundTitles)) {
$miniLeagueTitle = $roundTitles[$roundTitle];
} else {
$miniLeagueTitle = "test";
}
?>
<?php
$noFixturesQuery = mysqli_query($conn, "SELECT * FROM leagueResults WHERE miniLeagueID IN('". implode("', '", $miniLeaguesArray) ."') AND (fixtureDate = '$fixtureDateSQL')");
if (mysqli_num_rows($noFixturesQuery) > 1) {
while ($nFQ = mysqli_fetch_array($noFixturesQuery)) {
$homeTeam = $nFQ["homeTeam"];
$homeScore = $nFQ["homeScore"];
$homeRinkPts = $nFQ["homeRinkPts"];
$awayTeam = $nFQ["awayTeam"];
$awayScore = $nFQ["awayScore"];
$awayRinkPts = $nFQ["awayRinkPts"];
$firstLegID = $nFQ["firstLegID"];
if ($homeScore == -1) {
$homeScore = "";
$homeRinkPts = "";
}
if ($awayScore == -1) {
$awayScore = "";
$awayRinkPts = "";
}
if ($m == 0) {
if ($hasPlayoff == 1 || $hasPlayoff == 3) {
if ($firstLegID == 0) {
$miniLeagueTitle .= " 1st Leg";
} else {
$miniLeagueTitle .= " 2nd Leg";
}
}
} else {
$miniLeagueTitle = " ";
}
?>
<div class="fixturesGroup">
<div class="mlHeader"><?php echo $miniLeagueTitle ?></div>
<?php
if ($m == 0 || $m == 1) {
?>
<div class="fixturesLegend">
<div class="homeTeam">
<div class="teamName"> </div>
<div class="teamRink">Rink Pts</div>
<div class="teamScore">Score</div>
</div>
<div class="fixturesVersus"> </div>
<div class="awayTeam">
<div class="teamScore">Score</div>
<div class="teamRink">Rink Pts</div>
<div class="teamName"> </div>
</div>
</div>
<?php
}
?>
<div class="fixturesMatch">
<div class="homeTeam">
<div class="teamName"><?php echo $homeTeam ?></div>
<div class="teamRink"><?php echo $homeRinkPts ?></div>
<div class="teamScore"><?php echo $homeScore ?></div>
</div>
<div class="fixturesVersus">Vs</div>
<div class="awayTeam">
<div class="teamScore"><?php echo $awayScore ?></div>
<div class="teamRink"><?php echo $awayRinkPts ?></div>
<div class="teamName"><?php echo $awayTeam ?></div>
</div>
</div>
</div>
<?php
$m++;
}
} else {
while ($nFQ = mysqli_fetch_array($noFixturesQuery)) {
$homeTeam = $nFQ["homeTeam"];
$homeScore = $nFQ["homeScore"];
$homeRinkPts = $nFQ["homeRinkPts"];
$awayTeam = $nFQ["awayTeam"];
$awayScore = $nFQ["awayScore"];
$awayRinkPts = $nFQ["awayRinkPts"];
$firstLegID = $nFQ["firstLegID"];
if ($homeScore == -1) {
$homeScore = "";
$homeRinkPts = "";
}
if ($awayScore == -1) {
$awayScore = "";
$awayRinkPts = "";
}
if ($hasPlayoff == 1 || $hasPlayoff == 3) {
if ($firstLegID == 0) {
$miniLeagueTitle .= " 1st Leg";
} else {
$miniLeagueTitle .= " 2nd Leg";
}
}
?>
<div class="fixturesSingle">
<div class="mlHeader"><?php echo $miniLeagueTitle ?></div>
<?php
if ($s == 0) {
?>
<div class="fixturesLegend">
<div class="homeTeam">
<div class="teamName"> </div>
<div class="teamRink">Rink Pts</div>
<div class="teamScore">Score</div>
</div>
<div class="fixturesVersus"> </div>
<div class="awayTeam">
<div class="teamScore">Score</div>
<div class="teamRink">Rink Pts</div>
<div class="teamName"> </div>
</div>
</div>
<?php
}
?>
<div class="fixturesMatch">
<div class="homeTeam">
<div class="teamName"><?php echo $homeTeam ?></div>
<div class="teamRink"><?php echo $homeRinkPts ?></div>
<div class="teamScore"><?php echo $homeScore ?></div>
</div>
<div class="fixturesVersus">Vs</div>
<div class="awayTeam">
<div class="teamScore"><?php echo $awayScore ?></div>
<div class="teamRink"><?php echo $awayRinkPts ?></div>
<div class="teamName"><?php echo $awayTeam ?></div>
</div>
</div>
</div>
<?php
$s++;
}
}
?>
</div>
<?php
}
}
}
?>
</div>
</div>