function fetch_game_info($event_id, $game_type)
{
$fetch_event = mysql_query("SELECT * FROM `web_events` WHERE id='{$event_id}' LIMIT 1") or die(mysql_error());
$eventRow = mysql_fetch_assoc($fetch_event);
$event_title = $eventRow[title];
$center = return_center($eventRow[center]);
if ($game_type == "pre") {
$game_pack_sets = $eventRow[prelim_sets];
$game_format = $eventRow[prelim_format];
$game_title = "Prelim";
} elseif ($game_type == "pla") {
$game_pack_sets = $eventRow[playoff_sets];
$game_format = $eventRow[playoff_format];
$game_title = "Playoff";
} elseif ($game_type == "con") {
$game_pack_sets = $eventRow[console_sets];
$game_format = $eventRow[console_format];
$game_title = "Consoles";
} elseif ($game_type == "fin") {
$game_pack_sets = $eventRow[final_sets];
$game_format = $eventRow[final_format];
$game_title = "Finals";
}
if ($game_format == "tq") {
$format_num = 3;
} elseif ($game_format == "dq") {
$format_num = 2;
} elseif ($game_format == "none") {
$format_num = 1;
}
$return_array = array('title' => $event_title, 'game_pack_sets' => $game_pack_sets, 'game_format' => $game_format, 'game_title' => $game_title, 'format_num' => $format_num, 'center' => $center);
return $return_array;
}
</tr>
<tr height="18" bgcolor="#ebebeb">
<td width="110" class="small"> <b>Player Name</b></td>
<td width="140" class="small"> <b>Alias</b></td>
<td width="130" class="small" align="center"><b>Home Center</b></td>
<td width="50" align="center" class="small"><b>Options</b></td>
</tr>
<?php
$fetch_players = mysql_query("SELECT * FROM `web_players` WHERE player_teams LIKE '%[{$team_id}]%'");
if (mysql_num_rows($fetch_players) == "0") {
print " <tr bgcolor=\"#ffffff\">\n <td colspan=\"4\" align=\"center\">No players found</td>\n </tr>\n";
}
while ($playerRow = mysql_fetch_assoc($fetch_players)) {
$player_id = $playerRow[player_id];
$player_codename = $playerRow[player_codename];
$player_center = return_center($playerRow[player_center]);
print " <tr bgcolor=\"#ffffff\">\n";
print " <td width=\"90\">{$player_codename}</td>\n";
print " <td width=\"110\" align=\"center\"><form method=\"post\" action=\"./teams.php\"><input type=\"hidden\" name=\"do\" value=\"add_alias\"><input type=\"hidden\" name=\"eventId\" value=\"{$eventId}\"><input type=\"hidden\" name=\"team_id\" value=\"{$team_id}\"><input type=\"hidden\" name=\"player_id\" value=\"{$player_id}\">";
$check_alias = mysql_query("SELECT * FROM `web_alias` WHERE player_id='{$player_id}' AND alias_team='{$team_id}'");
if (mysql_num_rows($check_alias) == "0") {
print "[<input class=\"clear\" type=\"text\" name=\"alias_name\" size=\"9\" maxlength=\"10\">]";
} else {
$alias_row = mysql_fetch_assoc($check_alias);
print "[<input class=\"clear\" type=\"text\" name=\"alias_name\" value=\"{$alias_row['alias_name']}\" size=\"9\" maxlengt]h=\"10\">]";
}
print " <input class=\"clear\" type=\"submit\" name=\"submit\" value=\"Go\"></form></td>\n";
print " <td width=\"130\" align=\"center\">{$player_center}</td>\n";
print " <td width=\"60\" align=\"center\"><a href=\"./teams.php?do=delete_player&eventId={$eventId}&team_id={$team_id}&player_id={$player_id}\" onClick=\"return confirm('Are you sure you want to delete this player?')\">Delete</a></td>\n";
print " </tr>\n";
}
<td align="center" width="30"><b>Ft</b></td>
<td align="center" width="30"><b>Bk</b></td>
<td align="center" width="30"><b>Lr</b></td>
<td align="center" width="30"><b>Sh</b></td>
<td align="center" width="50"><b>Image</b></td>
</tr>
<?php
}
$fetch_player = mysql_query("SELECT * FROM `web_players` WHERE player_id='{$playerId}'");
if (mysql_num_rows($fetch_player) == "0") {
print_header("Error", 0);
show_error("Unable to find this player");
} else {
//score_id score_player score_game score_scanned_image
$player_row = mysql_fetch_assoc($fetch_player);
$display_center = return_center($player_row[player_center]);
print_header("Player Profile", "{$player_row['player_codename']} ({$display_center})");
foreach ($game_type_array as $key => $game_type) {
$row_count = 1;
$color1 = "#ffffff";
$color2 = "#f3f3f3";
$fetch_scores = mysql_query("SELECT * FROM `web_scores` WHERE score_player='{$playerId}' AND score_game_type='{$game_type}' ORDER BY `score_event` ASC");
if (mysql_num_rows($fetch_scores) != "0") {
print_table_header($game_type);
}
while ($scoreRow = mysql_fetch_assoc($fetch_scores)) {
$row_color = $row_count % 2 ? $color1 : $color2;
print " <tr bgcolor=\"{$row_color}\">\n";
print " <td align=\"center\">";
event_title($scoreRow[score_event]);
print "</td>\n";
?>
</table>
<?php
} elseif ($_GET["playerId"] != "" && is_numeric($_GET["playerId"])) {
$playerId = $_GET["playerId"];
$graphLabels = $_GET["graphLabels"];
print_header("Player Stats", "Overall Averages");
$fetch_player_info = mysql_query("SELECT * FROM `web_players` WHERE `player_id` = '{$playerId}'");
if (mysql_num_rows($fetch_player_info) == "0") {
$player_codename = "-";
$player_center = "-";
$player_name = "-";
} else {
$player_data = mysql_fetch_assoc($fetch_player_info);
$player_codename = $player_data[player_codename];
$player_center = return_center($player_data[player_center]);
if ($player_data[player_fname] == "") {
$player_name = "-";
} else {
$player_name = $player_data[player_fname] . " " . $player_data[player_lname];
}
}
if ($graphLabels == "off") {
$graph_link = "./stats_playerGraph.php?getPlayer={$playerId}&graphLabels=off";
$graph_label_option_link = "./stats_player.php?playerId={$playerId}";
$graph_label_option_title = "Turn Labels On";
} else {
$graph_link = "./stats_playerGraph.php?getPlayer={$playerId}";
$graph_label_option_link = "./stats_player.php?playerId={$playerId}&graphLabels=off";
$graph_label_option_title = "Turn Labels Off";
}
