ffnh/start_creation.php at main · ccbaumga/ffnh · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
<?php
function start($nflteam, $instance) {
	$error = "";
	$pdo = db_connect();
	$statement = $pdo->prepare('select nflteam, league, instancenumber, owner, status from nflteaminstances
	where nflteam = ? and instancenumber = ? and league = ?');
	$statement->execute([$nflteam, $instance, $_SESSION['leagueid']]);
	$row = $statement->fetch();
	if ($row == false){
		    $error = $error . "No such instance (" . $instance . ") of this team (" . $nflteam . ") in this league (" . $_SESSION['leagueid'] . "). <br>";
		}
	if ($error) {
		return $error;
	}
    if ($row['owner'] <> $_SESSION['teamid']){
		$error = $error . "This instance (" . $instance . ") of this team (" . $nflteam . ") in this league (" . $_SESSION['leagueid'] . ") is not yours (" . $_SESSION['teamid'] . "). <br>";
	}
	if ($row['status'] == "starting"){
		$error = $error . "This instance (" . $instance . ") of this team (" . $nflteam . ") is already starting. <br>";
	}
	if ($error) {
		return $error;
	}
	$statement = $pdo->prepare('update nflteaminstances
	set status = "starting"
	where nflteam = ? and instancenumber = ? and league = ?');
    $statement->execute([$nflteam, $instance, $_SESSION['leagueid']]);
	redirect("team.php");

}
function startbench($nflteam, $instance, $benchteam) {
	$error = "";
	$instancebench = strtok($benchteam, " ");
	$nflteambench = strtok(" ");
	$pdo = db_connect();
	$statement = $pdo->prepare('select nflteam, league, instancenumber, owner, status from nflteaminstances
	where nflteam = ? and instancenumber = ? and league = ?');
	$statement->execute([$nflteam, $instance, $_SESSION['leagueid']]);
	$row = $statement->fetch();
	if ($row == false){
		    $error = $error . "No such instance (" . $instance . ") of this team (" . $nflteam . ") in this league (" . $_SESSION['leagueid'] . "). Attempted to start from startbench. <br>";
		}
	if ($error) {
		return $error;
	}
    if ($row['owner'] <> $_SESSION['teamid']){
		$error = $error . "This instance (" . $instance . ") of this team (" . $nflteam . ") in this league (" . $_SESSION['leagueid'] . ") is not yours (" . $_SESSION['teamid'] . "). startbench <br>";
	}
	if ($row['status'] == "starting"){
		$error = $error . "This instance (" . $instance . ") of this team (" . $nflteam . ") is already starting. startbench <br>";
	}
	if ($error) {
		return $error;
	}
	$statement = $pdo->prepare('select nflteam, league, instancenumber, owner, status from nflteaminstances
	where nflteam = ? and instancenumber = ? and league = ?');
	$statement->execute([$nflteambench, $instancebench, $_SESSION['leagueid']]);
	$row = $statement->fetch();
	if ($row == false){
		    $error = $error . "No such instance (" . $instancedrop . ") of this team (" . $nflteamdrop . ") in this league (" . $_SESSION['leagueid'] . "). Attempted to bench from startbench. <br>";
		}
	if ($error) {
		return $error;
	}
	if ($row['owner'] <> $_SESSION['teamid']){
		$error = $error . "This instance (" . $instance . ") of this team (" . $nflteam . ") is not owned by this team (" . $_SESSION['leagueid'] . "). Attempted to bench from startbench. <br>";
	}
	if ($row['status'] <> "starting"){
		$error = $error . "This instance (" . $instance . ") of this team (" . $nflteam . ") is not in the starting lineup. Attempted to bench from startbench. <br>";
	}
	if ($error) {
		return $error;
	}
	$statement = $pdo->prepare('update nflteaminstances
	set status = "bench"
	where nflteam = ? and instancenumber = ? and league = ?');
    $statement->execute([$nflteambench, $instancebench, $_SESSION['leagueid']]);
	$statement = $pdo->prepare('update nflteaminstances
	set status = "starting"
	where nflteam = ? and instancenumber = ? and league = ?');
    $statement->execute([$nflteam, $instance, $_SESSION['leagueid']]);
	redirect("team.php");

}

function checkStartingLineupFull() {
	$error = "";
	$pdo = db_connect();
	$statement = $pdo->prepare('select leagueid, maxstart from leagues
	where leagueid = ?');
	$statement->execute([$_SESSION['leagueid']]);
	$row = $statement->fetch();
	if ($row == false){
		    $error = $error . "No such league (" . $_SESSION['leagueid'] . "). <br>";
		}
	if ($error) {
		return $error;
	}
	if (is_null($row['maxstart'])) {
		return false;
	}
	if($row['maxstart'] < 0){
		$error = $error . "The league (" . $_SESSION['leagueid'] . ") has negative maxstart. <br>";
	}
	if ($error) {
		return $error;
	}
	$startmax = $row['maxstart'];
	$statement = $pdo->prepare('select count(*) as curstart from nflteaminstances
	where league = ? and owner = ? and status = "starting"');
	$statement->execute([$_SESSION['leagueid'], $_SESSION['teamid']]);
	$row = $statement->fetch();
	$startcur = $row['curstart'];
	if($startcur >= $startmax){
		return $startcur;
	} else {
		return false;
	}
}

function bench($nflteam, $instance) {
	$error = "";
	$pdo = db_connect();
	$statement = $pdo->prepare('select nflteam, league, instancenumber, owner, status from nflteaminstances
	where nflteam = ? and instancenumber = ? and league = ?');
	$statement->execute([$nflteam, $instance, $_SESSION['leagueid']]);
	$row = $statement->fetch();
	if ($row == false){
		    $error = $error . "No such instance (" . $instance . ") of this team (" . $nflteam . ") in this league (" . $_SESSION['leagueid'] . "). <br>";
		}
	if ($error) {
		return $error;
	}
	if ($row['owner'] <> $_SESSION['teamid']){
		$error = $error . "This instance (" . $instance . ") of this team (" . $nflteam . ") is not owned by this team (" . $_SESSION['teamid'] . "). <br>";
	}
	if ($row['bench'] == "bench"){
		$error = $error . "This instance (" . $instance . ") of this team (" . $nflteam . ") is already on the bench. <br>";
	}
	if ($error) {
		return $error;
	}
	$statement = $pdo->prepare('update nflteaminstances
	set status = "bench"
	where nflteam = ? and instancenumber = ? and league = ?');
    $statement->execute([$nflteam, $instance, $_SESSION['leagueid']]);
	redirect("team.php");
}
?>