} 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"; } }