// Make them displayable
$position = 1;
foreach($w_milestones_temp_array as $i) {
$player = mysql_fetch_assoc(mysql_query("SELECT fname, lname, teamid FROM players WHERE id = " . $i[0]));
$team = mysql_fetch_assoc(mysql_query("SELECT name FROM teams WHERE id = " . $player['teamid']));
$w_milestones_array[] = array($position, ($i[1] == $i[5] ? "* - " : "") . $player['fname'] . " " . $player['lname'], $team['name'], $i[1], $i[2], $i[3], $i[4], $i[5] . " Wins");
$position ++;
}
$position = 1;
foreach($mp_milestones_temp_array as $i) {
$player = mysql_fetch_assoc(mysql_query("SELECT fname, lname, teamid FROM players WHERE id = " . $i[0]));
$team = mysql_fetch_assoc(mysql_query("SELECT name FROM teams WHERE id = " . $player['teamid']));
$mp_milestones_array[] = array($position, ($i[3] == $i[5] ? "* - " : "") . $player['fname'] . " " . $player['lname'], $team['name'], $i[1], $i[2], $i[3], $i[4], $i[5] . " Minutes Played");
$position ++;
}
$position = 1;
foreach($so_milestones_temp_array as $i) {
$player = mysql_fetch_assoc(mysql_query("SELECT fname, lname, teamid FROM players WHERE id = " . $i[0]));
$team = mysql_fetch_assoc(mysql_query("SELECT name FROM teams WHERE id = " . $player['teamid']));
$so_milestones_array[] = array($position, ($i[2] == $i[5] ? "* - " : "") . $player['fname'] . " " . $player['lname'], $team['name'], $i[1], $i[2], $i[3], $i[4], $i[5] . " Shutouts");
$position ++;
}
$position = 1;
foreach($gp_milestones_temp_array as $i) {
$player = mysql_fetch_assoc(mysql_query("SELECT fname, lname, teamid FROM players WHERE id = " . $i[0]));
$team = mysql_fetch_assoc(mysql_query("SELECT name FROM teams WHERE id = " . $player['teamid']));
$gp_milestones_array[] = array($position, ($i[3] == $i[5] ? "* - " : "") . $player['fname'] . " " . $player['lname'], $team['name'], $i[1], $i[2], $i[3], $i[4], $i[5] . " Played");
$position ++;
}
$position = 1;
foreach($goals_milestones_temp_array as $i) {
$player = mysql_fetch_assoc(mysql_query("SELECT fname, lname, teamid FROM players WHERE id = " . $i[0]));
$team = mysql_fetch_assoc(mysql_query("SELECT name FROM teams WHERE id = " . $player['teamid']));
$goals_milestones_array[] = array($position, ($i[1] == $i[2] ? "* - " : "") . $player['fname'] . " " . $player['lname'], $team['name'], $i[4], $i[1], $i[3], $i[2], $i[5] . " Goals");
$position ++;
}
$position = 1;
foreach($points_milestones_temp_array as $i) {
$player = mysql_fetch_assoc(mysql_query("SELECT fname, lname, teamid FROM players WHERE id = " . $i[0]));
$team = mysql_fetch_assoc(mysql_query("SELECT name FROM teams WHERE id = " . $player['teamid']));
$points_milestones_array[] = array($position, ($i[2] == $i[5] ? "* - " : "") . $player['fname'] . " " . $player['lname'], $team['name'], $i[4], $i[1], $i[3], $i[2], $i[5] . " Points");
$position ++;
}
$position = 1;
foreach($assists_milestones_temp_array as $i) {
$player = mysql_fetch_assoc(mysql_query("SELECT fname, lname, teamid FROM players WHERE id = " . $i[0]));
$team = mysql_fetch_assoc(mysql_query("SELECT name FROM teams WHERE id = " . $player['teamid']));
$assists_milestones_array[] = array($position, ($i[3] == $i[5] ? "* - " : "") . $player['fname'] . " " . $player['lname'], $team['name'], $i[4], $i[1], $i[3], $i[2], $i[5] . " Assists");
$position ++;
}
$position = 1;
foreach($played_milestones_temp_array as $i) {
$player = mysql_fetch_assoc(mysql_query("SELECT fname, lname, teamid FROM players WHERE id = " . $i[0]));
$team = mysql_fetch_assoc(mysql_query("SELECT name FROM teams WHERE id = " . $player['teamid']));
$played_milestones_array[] = array($position, ($i[4] == $i[5] ? "* - " : "") . $player['fname'] . " " . $player['lname'], $team['name'], $i[4], $i[1], $i[3], $i[2], $i[5] . " Played");
$position ++;
}
//Display in table
if(count($w_milestones_array) > 0) {
$w_milestones = draw_table(array(
'title' => 'WINS - <em>* denotes reached milestone</em>',
'bold' => 3,
'highlight' => 3,
'headers' => array("Position", "Name", "Team", "Wins", "Minutes Played", "Shut Outs", "Played", "Milestone"),
'fields' => $w_milestones_array,
'bgtitle' => '#EFEFEF',
'bgheaders' => '#DFDFDF',
'bgcolors' => array('#FFFFFF', '#EFEFEF')
));
}
if(count($mp_milestones_array) > 0) {
$mp_milestones = draw_table(array(
'title' => 'MINUTES PLAYED - <em>* denotes reached milestone</em>',
'bold' => 3,
'highlight' => 4,
'headers' => array("Position", "Name", "Team", "Wins", "Minutes Played", "Shut Outs", "Played", "Milestone"),
'fields' => $mp_milestones_array,
'bgtitle' => '#EFEFEF',
'bgheaders' => '#DFDFDF',
'bgcolors' => array('#FFFFFF', '#EFEFEF')
));
}
if(count($so_milestones_array) > 0) {
$so_milestones = draw_table(array(
'title' => 'SHUTOUTS - <em>* denotes reached milestone</em>',
'bold' => 3,
'highlight' => 5,
'headers' => array("Position", "Name", "Team", "Wins", "Minutes Played", "Shut Outs", "Played", "Milestone"),
'fields' => $so_milestones_array,
'bgtitle' => '#EFEFEF',
'bgheaders' => '#DFDFDF',
'bgcolors' => array('#FFFFFF', '#EFEFEF')
));
}
if(count($gp_milestones_array) > 0) {
$gp_milestones = draw_table(array(
'title' => 'GAMES PLAYED - <em>* denotes reached milestone</em>',
'bold' => 3,
'highlight' => 6,
'headers' => array("Position", "Name", "Team", "Wins", "Minutes Played", "Shut Outs", "Played", "Milestone"),
'fields' => $gp_milestones_array,
'bgtitle' => '#EFEFEF',
'bgheaders' => '#DFDFDF',
'bgcolors' => array('#FFFFFF', '#EFEFEF')
));
}
if(count($points_milestones_array) > 0) {
$points_milestones = draw_table(array(
'title' => 'POINTS - <em>* denotes reached milestone</em>',
'bold' => 3,
'highlight' => 6,
'headers' => array("Position", "Name", "Team", "GP", "Goals", "Assists", "Points", "Milestone"),
'fields' => $points_milestones_array,
'bgtitle' => '#EFEFEF',
'bgheaders' => '#DFDFDF',
'bgcolors' => array('#FFFFFF', '#EFEFEF')
));
}
if(count($goals_milestones_array) > 0) {
$goals_milestones = draw_table(array(
'title' => 'GOALS - <em>* denotes reached milestone</em>',
'bold' => 3,
'highlight' => 4,
'headers' => array("Position", "Name", "Team", "GP", "Goals", "Assists", "Points", "Milestone"),
'fields' => $goals_milestones_array,
'bgtitle' => '#EFEFEF',
'bgheaders' => '#DFDFDF',
'bgcolors' => array('#FFFFFF', '#EFEFEF')
));
}
if(count($assists_milestones_array) > 0) {
$assists_milestones = draw_table(array(
'title' => 'ASSISTS - <em>* denotes reached milestone</em>',
'bold' => 3,
'highlight' => 5,
'headers' => array("Position", "Name", "Team", "GP", "Goals", "Assists", "Points", "Milestone"),
'fields' => $assists_milestones_array,
'bgtitle' => '#EFEFEF',
'bgheaders' => '#DFDFDF',
'bgcolors' => array('#FFFFFF', '#EFEFEF')
));
}
if(count($played_milestones_array) > 0) {
$played_milestones = draw_table(array(
'title' => 'GAMES PLAYED - <em>* denotes reached milestone</em>',
'bold' => 3,
'highlight' => 3,
'headers' => array("Position", "Name", "Team", "GP", "Goals", "Assists", "Points", "Milestone"),
'fields' => $played_milestones_array,
'bgtitle' => '#EFEFEF',
'bgheaders' => '#DFDFDF',
'rowfield' => $o['headers'][6],
'bgcolors' => array('#FFFFFF', '#EFEFEF')
));
}