| Server IP : 149.202.105.228 / Your IP : 216.73.216.18 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/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"];
$noTeams = $lQ["noTeams"];
$homeAndAway = $lQ["homeAndAway"];
$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";
if ($hasMiniLeagues > 1) {
$miniLeagueIDQuery = mysqli_query($conn, "SELECT (SELECT COUNT(leagueMiniLeaguesTeams.id) FROM leagueMiniLeaguesTeams WHERE leagueMiniLeaguesTeams.miniLeagueID = leagueMiniLeagues.id) AS teamCount FROM leagueMiniLeagues WHERE leagueMiniLeagues.leagueID = '$leagueID' ORDER BY teamCount DESC LIMIT 0,1");
while ($mLQ = mysqli_fetch_array($miniLeagueIDQuery)) {
$noTeams = $mLQ["teamCount"];
}
}
if ($noTeams % 2 == 0) {
$noWeeks = $noTeams - 1;
} else {
$noWeeks = $noTeams;
}
$homeWeeks = $noWeeks;
if ($homeAndAway == 0) {
$noWeeks = $noWeeks * 2;
}
$miniLeagueBasicQuery = mysqli_query($conn, "SELECT id FROM leagueMiniLeagues WHERE leagueID = '$leagueID' ORDER BY id ASC LIMIT 0,1");
while ($mLBQ = mysqli_fetch_array($miniLeagueBasicQuery)) {
$basicMiniLeagueID = $mLBQ["id"];
}
?>
<!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>Fixtures</h1>
<?php
for ($w = 1; $w <= $noWeeks; $w++) {
$fixtureDateQuery = mysqli_query($conn, "SELECT fixtureDate FROM leagueResults WHERE miniLeagueID = '$basicMiniLeagueID' AND (weekID = '$w') ORDER BY id ASC");
while ($fDQ = mysqli_fetch_array($fixtureDateQuery)) {
$fixtureDate = date("jS F, Y", strtotime($fDQ["fixtureDate"]));
}
?>
<div class="fixturesWeek<?php if ($hasMiniLeagues == 1) {?> fixturesWeekC<?php } ?>">
<div class="weekHeader">Week <?php echo $w ?> - <?php echo $fixtureDate ?></div>
<?php
$miniLeagueQuery = mysqli_query($conn, "SELECT * FROM leagueMiniLeagues WHERE leagueID = '$leagueID' ORDER BY id ASC");
while ($mLQ = mysqli_fetch_array($miniLeagueQuery)) {
$miniLeagueID = $mLQ["id"];
$miniLeagueTitle = $mLQ["miniLeagueTitle"];
if (trim($miniLeagueTitle) != "") {
?>
<div class="fixturesGroup">
<div class="mlHeader"><?php echo $miniLeagueTitle ?></div>
<?php
}
if ( ($w == 1) || (($hasMiniLeagues == 1) && ($w == 2)) ) {
?>
<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
}
$fixturesQuery = mysqli_query($conn, "SELECT * FROM leagueResults WHERE miniLeagueID = '$miniLeagueID' AND (weekID = '$w') ORDER BY id ASC");
while ($fQ = mysqli_fetch_array($fixturesQuery)) {
$homeTeam = $fQ["homeTeam"];
$homeScore = $fQ["homeScore"];
$homeRinkPts = $fQ["homeRinkPts"];
$awayTeam = $fQ["awayTeam"];
$awayScore = $fQ["awayScore"];
$awayRinkPts = $fQ["awayRinkPts"];
if ($homeScore == -1) {
$homeScore = "";
$homeRinkPts = "";
}
if ($awayScore == -1) {
$awayScore = "";
$awayRinkPts = "";
}
?>
<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>
<?php
}
if (trim($miniLeagueTitle) != "") {
?>
</div>
<?php
}
}
/* if ($hasMiniLeagues == 1) {
?>
</div>
<?php
}
*/ ?>
</div>
<?php
}
?>
</div>
</div>