} else {
echo "<td class=edit ALIGN=LEFT><input type=text size=20 name=\"player_name\"></TD>";
echo "<td class=edit class=edit><SELECT NAME=positions_id>\n";
$q_pot = 'SELECT t_positions_ID, t_positions_title FROM t_positions WHERE t_race_ID = ' . $race_id;
$r_pot = get_sqlresult($q_pot, "Get positions");
while ($n_pot = mysql_fetch_array($r_pot)) {
echo "<option value=" . $n_pot[0] . ">" . $n_pot[1] . "</option>\n";
}
// while
echo "</SELECT>" . "</TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>" . "<td class=edit class=edit> </TD>";
}
// submit main player form
echo "<td class=edit class=edit><input type=submit name=sav_player value=\"Save\"><input type=submit name=del_player value=\"Delete\"></form></td></TR>\n";
}
$q_player = 'SELECT sum(t_positions_price) price, sum(t_player_priceadd) priceadd FROM t_player pl, t_positions po WHERE t_team_ID = ' . $team . ' AND pl.t_positions_ID = po.t_positions_ID' . ' GROUP BY t_team_ID LIMIT 0, 30';
$r_player = get_sqlresult($q_player, "Summing player values");
$n_player = mysql_fetch_array($r_player);
$team_price = $n_player['price'] + $n_player['priceadd'] + $n_team_d['t_race_rerollprice'] * $n_team_d['t_team_rerolls'] + $n_team_d['t_team_fanfactor'] * 10000 + $n_team_d['t_team_assistant_coaches'] * 10000 + $n_team_d['t_team_cheerleaders'] * 10000 + $n_team_d['t_team_apothecary'] * 50000;
$team_rating = $team_price / 10000;
echo "<TR ALIGN=CENTER><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>";
echo "<form method=post action=" . $_SERVER['PHP_SELF'] . ">";
echo "<input type=hidden name=\"team\" value=" . $team . ">";
echo "<input type=hidden name=\"teamid\" value=" . $team . ">";
echo "Team Name:</TD><td class=edit COLSPAN=5><input type=text size=20 name=\"team_name\" value=\"" . $n_team_d['t_team_name'] . "\"></TD><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Re-Rolls:</TD><td class=edit COLSPAN=2><input type=text size=5 name=\"reroll\" value=\"" . $n_team_d['t_team_rerolls'] . "\"</TD><td class=edit BGCOLOR=\"#D0D0A0\" COLSPAN=4>x \$" . $n_team_d['t_race_rerollprice'] / 1000 . "k =</TD><td class=edit ALIGN=RIGHT>" . $n_team_d['t_race_rerollprice'] * $n_team_d['t_team_rerolls'] . "</TD>";
echo "<td rowspan=7 class=edit>";
echo 1 == $_SESSION['userschema'] ? '<input type="Submit" name="del_team" value="Delete team"><BR>' : ' ';
echo "<input type=\"Submit\" name=\"save_team\" value=\"Save team\"></TD></TR>";
echo "<TR ALIGN=CENTER><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Race:</TD><td class=edit COLSPAN=5>" . ucwords(strtolower($n_team_d['t_race_name'])) . "</TD><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Fan Factor:</TD><td class=edit COLSPAN=2><input type=text size=5 name=\"fanfac\" value=\"" . $n_team_d['t_team_fanfactor'] . "\"</TD><td class=edit BGCOLOR=\"#D0D0A0\" COLSPAN=4>x \$10k =</TD><td class=edit ALIGN=RIGHT>" . $n_team_d['t_team_fanfactor'] * 10000 . "</TD></TR>";
echo "<TR ALIGN=CENTER><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Team Rating:</TD><td class=edit COLSPAN=5>" . $team_rating . "</TD><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Assistant Coaches:</TD><td class=edit COLSPAN=2><input type=text size=5 name=\"assist\" value=\"" . $n_team_d['t_team_assistant_coaches'] . "\"</TD><td class=edit BGCOLOR=\"#D0D0A0\" COLSPAN=4>x \$10k =</TD><td class=edit ALIGN=RIGHT>" . $n_team_d['t_team_assistant_coaches'] * 10000 . "</TD></TR>";
echo "<TR ALIGN=CENTER><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Treasury:</TD><td class=edit COLSPAN=5><input type=text size=20 name=\"treas\" value=\"" . $n_team_d['t_team_treasury'] . "\"></TD><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Cheerleaders:</TD><td class=edit COLSPAN=2><input type=text size=5 name=\"cheer\" value=\"" . $n_team_d['t_team_cheerleaders'] . "\"</TD><td class=edit BGCOLOR=\"#D0D0A0\" COLSPAN=4>x \$10k =</TD><td class=edit ALIGN=RIGHT>" . $n_team_d['t_team_cheerleaders'] * 10000 . "</TD></TR>";
echo "<TR ALIGN=CENTER><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Coach:</TD><td class=edit COLSPAN=5>" . $n_team_d['t_team_coach'] . "</TD><td class=edit ALIGN=RIGHT BGCOLOR=\"#D0D0A0\" COLSPAN=2>Apothecary:</TD><td class=edit COLSPAN=2><input type=text size=5 name=\"apoth\" value=\"" . $n_team_d['t_team_apothecary'] . "\"</TD><td class=edit BGCOLOR=\"#D0D0A0\" COLSPAN=4>x \$50k =</TD><td class=edit ALIGN=RIGHT>" . $n_team_d['t_team_apothecary'] * 50000 . "</TD></TR>";
// Clear the table of previously saved data. The game is not dropped, it must still be possible to enter results.
$sql = "UPDATE t_game SET " . " t_game_played = NULL" . ", t_game_status = 1" . ", t_game_h_td = NULL" . ", t_game_a_td = NULL" . ", t_game_h_cas = NULL" . ", t_game_a_cas = NULL" . ", t_game_gate = NULL" . ", t_game_h_win = NULL" . ", t_game_a_win = NULL" . " WHERE t_game_ID = " . $_SESSION['game']['gameid'];
$c_game = get_sqlresult($sql, "Clear saved game data.");
// Unset session variables to clear the cache of data.
unset($_SESSION['game']['home']);
unset($_SESSION['game']['gate']);
// Remove from t_team_mod
// Remove from t_player_action
}
if (isset($_POST['gameid'])) {
unset($_SESSION['game']);
unset($xml);
$_SESSION['game']['gameid'] = $_POST['gameid'];
$_SESSION['game']['fixtureid'] = $_SESSION['fixtureID'];
$sql = "SELECT t_game_ID, th.t_user_ID t_h_user_ID, th.t_team_name t_h_team_name, th.t_team_ID t_h_team_ID, ta.t_user_ID t_a_user_ID, ta.t_team_name t_a_team_name, ta.t_team_ID t_a_team_ID, t_game_scheduled, t_game_status" . " FROM t_game g, t_team th, t_team ta" . " WHERE g.t_h_team_ID = th.t_team_ID" . " AND g.t_a_team_ID = ta.t_team_ID" . " AND t_game_ID = " . $_POST['gameid'];
$game = get_sqlresult($sql, "Get game");
$n_game = mysql_fetch_array($game);
$_SESSION['game']['scheduled'] = $n_game['t_game_scheduled'];
$_SESSION['game']['homename'] = $n_game['t_h_team_name'];
$_SESSION['game']['homeid'] = $n_game['t_h_team_ID'];
$_SESSION['game']['homeuserid'] = $n_game['t_h_user_ID'];
$_SESSION['game']['homeff'] = 0;
$_SESSION['game']['awayname'] = $n_game['t_a_team_name'];
$_SESSION['game']['awayid'] = $n_game['t_a_team_ID'];
$_SESSION['game']['awayuserid'] = $n_game['t_a_user_ID'];
$_SESSION['game']['awayff'] = 0;
}
if (isset($_POST['readfile'])) {
$xml = simplexml_load_file($_FILES['results']['tmp_name']);
if ($xml->result[0]['team'] == $_SESSION['game']['homename'] || $xml->result[0]['team'] == $_SESSION['game']['awayname']) {
//$_SESSION['game']['xmlver'] = $xml['version'];
echo "Not played</td><td><input type=submit name=del_game value=Delete></td>";
break;
case "2":
echo "Played, not approved<td> </td>";
break;
case "3":
echo "Played and approved<td> </td>";
break;
}
echo "</td>\n";
echo "</form>";
echo "</tr>\n";
}
}
$sql = "SELECT t.t_team_ID, t_team_name FROM t_team t, t_team_fixture f" . " WHERE t.t_team_ID = f.t_team_ID" . " AND f.t_division_ID = " . $_SESSION['fixtureID'];
$team = get_sqlresult($sql, "Get teams");
if (0 < mysql_num_rows($team)) {
echo "<tr><td>\n";
echo "<form name=s_datecontrol method=post action=" . $_SERVER['PHP_SELF'] . ">\n";
echo "<input type=text value=\"" . date("Y-m-d") . "\" name=s_date size=11>";
//Calendar control does not work... Argh...
//echo "<input type=\"button\" value=\"...\" onClick=\"newWindow('s_date')\" id=button1 name=button1>";
echo "</td>\n";
echo "<td><select name=h_teamid>\n";
while ($n_team = mysql_fetch_array($team)) {
echo "<option value=" . $n_team['t_team_ID'] . ">" . $n_team['t_team_name'] . "</option>\n";
}
echo "</select>\n";
echo "</td><td> - </td>\n";
$nspool = mysql_data_seek($team, 0);
echo "<td><select name=a_teamid>\n";
while ($pos = mysql_fetch_array($r_pos)) {
if (isset($_POST['raceid'])) {
$n_pos = $n_pos + 1;
$_SESSION['team'][$pos['t_positions_ID']] = array("qty" => $pos['t_positions_qty'], "used" => 0);
}
echo "<tr>\n";
echo "<td align=center width=40>0-" . $pos['t_positions_qty'] . "</td>";
echo "<td>" . $pos['t_positions_title'] . "</td>";
echo "<td align=right>" . number_format($pos['t_positions_price']) . "</td>";
echo "<td align=center>" . $pos['t_positions_MA'] . "</td>";
echo "<td align=center>" . $pos['t_positions_ST'] . "</td>";
echo "<td align=center>" . $pos['t_positions_AG'] . "</td>";
echo "<td align=center>" . $pos['t_positions_AV'] . "</td>";
// get skills
$q_skill = 'SELECT p.t_skill_ID, t_skill_name, t_skill_desc, t_skill_type FROM `t_positions_skill` p, `t_skill` s' . ' WHERE p.t_skill_ID = s.t_skill_ID' . ' AND p.t_positions_ID = ' . $pos['t_positions_ID'] . ';';
$r_skill = get_sqlresult($q_skill, "Get skills");
// for each skill do
echo "<td>";
$p_skill = "";
while ($skill = mysql_fetch_array($r_skill)) {
$p_skill = $p_skill . "<a href=\"javascript:void(0);\" onmouseover=\"Tip('" . addslashes(htmlspecialchars_decode($skill['t_skill_desc'], ENT_QUOTES)) . "', PADDING, 5, WIDTH, 600)\" class=nolink>" . $skill['t_skill_name'] . "</a>, ";
}
// end
if ($p_skill == "") {
echo " ";
} else {
echo substr($p_skill, 0, strlen($p_skill) - 2);
}
echo "</td>";
// get skill types
$q_skill = 'SELECT t_skill_type, t_skill_type_d FROM t_positions_skill_type WHERE t_position_ID= ' . $pos['t_positions_ID'] . ' ORDER BY t_skill_type_d, t_skill_type';
echo "</table>\n</td>";
echo "<td>\n";
echo "<table border=1 cellspacing=0 cellpadding=0 width=200>";
echo "<tr><td align=center>";
echo "<a href=a_users.php><B>USERS</B></a>";
echo "</td></tr>";
echo "</table>\n</td>";
echo "</tr>";
// Actual page starts here
echo "<tr><td colspan=4 align=center>";
if (isset($_SESSION['fixtureID'])) {
$sql = "SELECT te.t_team_ID, te.t_team_name, tr.t_race_name, tu.t_user_name, te.t_team_status FROM t_team te, t_race tr, t_team_fixture tf, t_user tu" . " WHERE te.t_race_ID = tr.t_race_ID" . " AND te.t_team_ID = tf.t_team_ID" . " AND tu.t_user_id = te.t_user_ID" . (1 == $_SESSION['userschema'] ? '' : ' AND t_user_ID = ' . $_SESSION['userID']) . " AND t_division_ID = " . $_SESSION['fixtureID'] . " GROUP BY te.t_team_name";
} else {
$sql = "SELECT te.t_team_ID, te.t_team_name, tr.t_race_name, tu.t_user_name, te.t_team_status FROM t_team te, t_race tr, t_user tu" . " WHERE te.t_race_ID = tr.t_race_ID" . " AND tu.t_user_id = te.t_user_ID" . (1 == $_SESSION['userschema'] ? '' : ' AND tu.t_user_ID = ' . $_SESSION['userID']) . " GROUP BY te.t_team_name";
}
$teams = get_sqlresult($sql, "Get your teams");
echo "<table>\n";
echo "<tr><th>Status</th><th>Team</th></tr>\n";
while ($n_teams = mysql_fetch_array($teams)) {
echo "<tr>\n<td>";
echo 1 == $n_teams['t_team_status'] ? 'Not approved' : 'Approved';
echo "</td>\n<td>";
echo "<a href=team_preview.php?team=" . $n_teams['t_team_ID'] . "&jbb=0 target=\"_blank\">" . $n_teams['t_team_name'] . ", " . ucwords(strtolower($n_teams['t_race_name'])) . " (" . $n_teams['t_user_name'] . ")</a>";
echo "</td>\n<td><form method=post action=edit_team.php>";
echo "<input type=hidden name=teamid value=" . $n_teams['t_team_ID'] . "><input type=submit name=edit_team value=\"Edit team\">";
echo "</form></td>\n<td>";
echo "<form method=post action=" . $_SERVER['PHP_SELF'] . ">";
echo "<input type=hidden name=teamid value=" . $n_teams['t_team_ID'] . ">";
echo 1 == $n_teams['t_team_status'] ? 1 == $_SESSION['userschema'] ? '<input type=submit name=approve_team value="Approve">' : '' : '';
echo "</form>";
echo "</td>\n</tr>\n";
function view_fix($fixID)
{
if (isset($fixID)) {
$q_division = 'SELECT t_league_name, l.t_league_ID, t_season_name, s.t_season_ID, t_division_name, d.t_division_ID' . ' FROM t_division d , t_season s , t_league l ' . ' WHERE d.t_division_ID = ' . $fixID . ' AND d.t_season_ID = s.t_season_ID ' . ' AND s.t_league_ID = l.t_league_ID ';
$r_division = mysql_query($q_division) or die("Division query failed");
$n_division = mysql_fetch_array($r_division);
// Display the selected league, season and division*/
echo "<form method=post action=\"" . $_SERVER['PHP_SELF'] . "\">\n";
echo "<b><i>" . $n_division['t_league_name'] . " / " . $n_division['t_season_name'] . " / \n";
$q_fix = 'SELECT t_division_ID, t_division_name FROM t_division WHERE t_season_ID = ' . $n_division['t_season_ID'];
$r_fix = get_sqlresult($q_fix, "Get fixture options");
echo "<select name=fixid onchange=\"this.form.submit()\">\n";
while ($n_fix = mysql_fetch_array($r_fix)) {
echo "<option value=" . $n_fix['t_division_ID'] . ($n_division['t_division_ID'] == $n_fix['t_division_ID'] ? " selected" : "") . ">" . $n_fix['t_division_name'] . "</option>\n";
}
echo "</select>";
//echo $n_division['t_division_name'] . "</i></b>";
echo " <input type=hidden name=\"changeFix\" value=\"1\"><input type=submit name=submit value=\"Change fixture\"></form>";
} else {
echo "<form method=post action=" . $_SERVER['PHP_SELF'] . ">";
if (!$_POST['league']) {
// :If no league are selected:
// View the select league dropdown
$q_league = 'SELECT * FROM t_league';
$r_league = mysql_query($q_league) or die("League query failed");
echo "League: <select name=league onchange=\"this.form.submit()\">\n";
echo "<option value=0 selected>Choose</option>";
while ($n_league = mysql_fetch_array($r_league)) {
echo "<option value=" . $n_league['t_league_ID'] . ">" . $n_league['t_league_name'] . "</option>\n";
}
} elseif (!$_POST['season']) {
// ::if no season are selected::
// Display the selected league
$q_league = 'SELECT t_league_name FROM t_league WHERE t_league_ID = ' . $_POST['league'];
$r_league = mysql_query($q_league) or die("League query failed");
$n_league = mysql_fetch_array($r_league);
$league_name = $n_league['t_league_name'];
echo "<input type=hidden name=\"league\" value=\"" . $_POST['league'] . "\">";
echo "<input type=hidden name=\"league_name\" value=\"" . $league_name . "\">";
echo "<b><i>" . $league_name . " / </i></b>";
// View the select season dropdown
$q_season = 'SELECT * FROM t_season WHERE t_league_ID = ' . $_POST['league'] . ' ORDER BY t_season_start DESC';
$r_season = mysql_query($q_season) or die("Season query failed");
echo "Season: <select name=season onchange=\"this.form.submit()\">\n";
echo "<option value=0 selected>Choose</option>";
while ($n_season = mysql_fetch_array($r_season)) {
echo "<option value=" . $n_season['t_season_ID'] . ">" . $n_season['t_season_name'] . "</option>\n";
}
} elseif (!$_POST['division']) {
// if no division are selected::
// Display the selected league and season
$q_league = 'SELECT t_league_name FROM t_league WHERE t_league_ID = ' . $_POST['league'];
$r_league = mysql_query($q_league) or die("League query failed");
$n_league = mysql_fetch_array($r_league);
$league_name = $n_league['t_league_name'];
$q_season = 'SELECT t_season_name FROM t_season WHERE t_season_ID = ' . $_POST['season'];
$r_season = mysql_query($q_season) or die("Season query failed");
$n_season = mysql_fetch_array($r_season);
$season_name = $n_season['t_season_name'];
echo "<input type=hidden name=\"league\" value=\"" . $_POST['league'] . "\">";
echo "<input type=hidden name=\"league_name\" value=\"" . $_POST['league_name'] . "\">";
echo "<input type=hidden name=\"season\" value=\"" . $_POST['season'] . "\">";
echo "<input type=hidden name=\"season_name\" value=\"" . $season_name . "\">";
echo "<b><i>" . $league_name . " / " . $season_name . " / </i></b>";
// Display the select division dropdown
$q_division = 'SELECT * FROM t_division WHERE t_season_ID = ' . $_POST['season'];
$r_division = mysql_query($q_division) or die("fixture query failed");
echo "Fixture: <select name=division onchange=\"this.form.submit()\">\n";
echo "<option value=0 selected>Choose</option>";
while ($n_division = mysql_fetch_array($r_division)) {
echo "<option value=" . $n_division['t_division_ID'] . ">" . $n_division['t_division_name'] . "</option>\n";
}
}
echo "</select>\n</form>\n";
}
}
