AnonSec Shell
Server IP : 149.202.105.228  /  Your IP : 216.73.216.134
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/admin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     

Current File : /home/a/t/f/atfycaf/www/admin/testLeague.php
<?php
include "globalVars.php";
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>League Results Test</title>
</head>

<body>
<?php
$roundQuery = mysqli_query($conn, "SELECT DISTINCT weekID FROM leagueResults WHERE miniLeagueID = '1' ORDER BY weekID ASC");
while ($rQ = mysqli_fetch_array($roundQuery)) {
	$weekID	= $rQ["weekID"];
	?>
	<h2>Week <?php echo $weekID ?></h2>
	<?php

	$weekResultsQuery = mysqli_query($conn, "SELECT * FROM leagueResults WHERE miniLeagueID = '1' AND (weekID = '$weekID')");
	while ($wRQ = mysqli_fetch_array($weekResultsQuery)) {
		$homeTeam		= $wRQ["homeTeam"];
		$homeScore		= $wRQ["homeScore"];
		$homeRinkPts	= $wRQ["homeRinkPts"];
		$awayTeam		= $wRQ["awayTeam"];
		$awayScore		= $wRQ["awayScore"];
		$awayRinkPts	= $wRQ["awayRinkPts"];
		if ( (trim($homeTeam) == "") || (trim($awayTeam) == "") ) {
			if (trim($homeTeam) == "") {
				$teamToDisplay	= $awayTeam;
			} else {
				$teamToDisplay	= $homeTeam;
			}
			?>
			<p><?php echo $teamToDisplay ?> Bye week</p>
			<?php
		} else {
			if ($homeScore > $awayScore) {
				$homePts	= 2;
				$awayPts	= 0;
			} elseif ($homeScore == $awayScore) {
				$homePts	= 1;
				$awayPts	= 1;
			} else {
				$homePts	= 0;
				$awayPts	= 2;
			}
			?>
			<table width="500" style="border:1px solid #999; border-collapse:collapse; margin-bottom:5px;" cellspacing="0">
				<thead>
					<th style="border:1px solid #999;">Team</th>
					<th style="border:1px solid #999;">Score</th>
					<th style="border:1px solid #999;">Rink Points</th>
					<th style="border:1px solid #999;">Match Total</th>
				</thead>
				<tbody>
					<tr>
						<td style="border:1px solid #999;"><?php echo $homeTeam ?></td>
						<td style="border:1px solid #999;"><?php echo $homeScore ?></td>
						<td style="border:1px solid #999;"><?php echo $homeRinkPts ?></td>
						<td style="border:1px solid #999;"><?php echo $homePts + $homeRinkPts ?></td>
					</tr>
					<tr>
						<td style="border:1px solid #999;"><?php echo $awayTeam ?></td>
						<td style="border:1px solid #999;"><?php echo $awayScore ?></td>
						<td style="border:1px solid #999;"><?php echo $awayRinkPts ?></td>
						<td style="border:1px solid #999;"><?php echo $awayPts + $awayRinkPts ?></td>
					</tr>
				</tbody>
			</table>
			<?php
		}
	}
}
$leagueStandingQuery = "
SELECT 
    team, 
    COUNT(*) AS played, 
    COUNT(CASE WHEN homeScore > awayScore THEN 1 END) AS won, 
    COUNT(CASE WHEN homeScore = awayScore THEN 1 END) AS drawn, 
    COUNT(CASE WHEN awayScore> homeScore THEN 1 END) AS lost, 
    SUM(homeScore) AS shotsFor, 
    SUM(awayScore) AS shotsAgainst, 
    SUM(homeScore) - SUM(awayScore) AS shotsDiff,
    SUM(homeRinkPts) AS rinkPts,
    SUM(
          CASE WHEN homeScore > awayScore THEN 2 ELSE 0 END 
        + CASE WHEN homeScore = awayScore THEN 1 ELSE 0 END
        + homeRinkPts
    ) AS pts 
FROM (
    SELECT homeTeam AS team, homeScore, awayScore, homeRinkPts, awayRinkPts from leagueResults WHERE miniLeagueID = '1' AND ((homeTeam != '') AND (awayTeam != '')) AND ((homeScore >= 0) AND (awayScore >= 0))
  UNION ALL
    SELECT awayTeam AS team, awayScore, homeScore, awayRinkPts, homeRinkPts from leagueResults WHERE miniLeagueID = '1' AND ((homeTeam != '') AND (awayTeam != '')) AND ((homeScore >= 0) AND (awayScore >= 0))
) AS a 
GROUP BY team
ORDER BY pts DESC, shotsDiff DESC;";
?>
			<h1>Final Standings</h1>
			<table width="800" style="border:1px solid #999; border-collapse:collapse; margin-bottom:5px;" cellspacing="0">
				<thead>
					<th style="border:1px solid #999;">&nbsp;</th>
					<th style="border:1px solid #999;">P</th>
					<th style="border:1px solid #999;">W</th>
					<th style="border:1px solid #999;">D</th>
					<th style="border:1px solid #999;">L</th>
					<th style="border:1px solid #999;">F</th>
					<th style="border:1px solid #999;">A</th>
					<th style="border:1px solid #999;">Diff</th>
					<th style="border:1px solid #999;">Rink Pts</th>
					<th style="border:1px solid #999;">Pts</th>
				</thead>
				<tbody>
<?php
$leagueQuery = mysqli_query($conn, $leagueStandingQuery);
while ($lQ = mysqli_fetch_array($leagueQuery)) {
	$team			= $lQ["team"];
	$played			= $lQ["played"];
	$won			= $lQ["won"];
	$drawn			= $lQ["drawn"];
	$lost			= $lQ["lost"];
	$shotsFor		= $lQ["shotsFor"];
	$shotsAgainst	= $lQ["shotsAgainst"];
	$shotsDiff		= $lQ["shotsDiff"];
	$rinkPts		= $lQ["rinkPts"];
	$pts			= $lQ["pts"];
	?>
					<tr style="text-align:center;">
						<td style="border:1px solid #999;"><?php echo $team ?></td>
						<td style="border:1px solid #999;"><?php echo $played ?></td>
						<td style="border:1px solid #999;"><?php echo $won ?></td>
						<td style="border:1px solid #999;"><?php echo $drawn ?></td>
						<td style="border:1px solid #999;"><?php echo $lost ?></td>
						<td style="border:1px solid #999;"><?php echo $shotsFor ?></td>
						<td style="border:1px solid #999;"><?php echo $shotsAgainst ?></td>
						<td style="border:1px solid #999;"><?php echo $shotsDiff ?></td>
						<td style="border:1px solid #999;"><?php echo $rinkPts ?></td>
						<td style="border:1px solid #999;"><?php echo $pts ?></td>
					</tr>
	<?php
}
?>
				</tbody>
			</table>
</body>
</html>

Anon7 - 2022
AnonSec Team