rendered paste body<?php// This assumes we are "adding" a match and will start the match array sessionif (!isset($_SESSION['match_array'])) { if ($act == "edit") { $act = "edit"; } else { $act = "add"; } $_SESSION['match_array'] = array ( "act" => $act, "match_id" => $id, "match_date" => "", "division_id" => $_POST['division_id'], "league_id" => "", "opponent_id" => "", "map_id" => "", "jcp_score" => "", "opp_score" => "" );}?><script language="JavaScript"><!--function checkForm(form) { if (document.form.did.value == "") { alert ('Please select a division'); document.form.did.focus(); return false; } if (document.form.title.value == "") { alert ('Please enter a title'); document.form.title.focus(); return false; } if (document.form.date.value == "") { alert ('Please select a date'); document.form.date.focus(); return false; } if (document.form.news.value == "") { alert ('Please enter the news'); document.form.news.focus(); return false; } return true;}//--></script><?phpif ($act == "edit") { $result = mysql_query ("SELECT * FROM `$module_table_name` WHERE `match_id`='" . $_SESSION['match_array']['match_id'] . "'"); if (!$result) { echo("error performing query: " . mysql_error() . ""); exit(); } $row = mysql_fetch_assoc($result); // Make sure session variables are up to date $_SESSION['match_array']['match_date'] = $row['match_date']; $_SESSION['match_array']['division_id'] = $row['division_id']; $_SESSION['match_array']['league_id'] = $row['league_id']; $_SESSION['match_array']['opponent_id'] = $row['opponent_id']; $_SESSION['match_array']['map_id'] = $row['map_id']; $_SESSION['match_array']['jcp_score'] = $row['jcp_score']; $_SESSION['match_array']['opp_score'] = $row['opp_score']; // Get match roster array for editing $resultRost = mysql_query ("SELECT * FROM `jcp_match_rosters` WHERE `match_id` = '" . $_SESSION['match_array']['match_id'] . "'"); if (!$resultRost) { echo("error performing query: " . mysql_error() . ""); exit(); } if (mysql_num_rows ($resultRost)) { while($rowRost = mysql_fetch_assoc ($resultRost)) { $resultUN = mysql_query ("SELECT `username` FROM `phpbb_users` WHERE `user_id`='$rowRost[user_id]'"); if (!$resultUN) { echo("error performing query: " . mysql_error() . ""); exit(); } $rowUN = mysql_fetch_assoc($resultUN); $username = $rowUN['username']; $_SESSION['match_roster_array']["$rowRost[user_id]"] = array( "user_id" => $rowRost['user_id'], "username" => $username, "weapon" => $rowRost['weapon'], "kills" => $rowRost['kills'], "deaths" => $rowRost['deaths'] ); } }}if (isset ($_POST['Add'])) { // Make sure session variables are up to date $_SESSION['match_array']['match_date'] = $_POST['match_date']; $_SESSION['match_array']['league_id'] = $_POST['league_id']; $_SESSION['match_array']['opponent_id'] = $_POST['opponent_id']; $_SESSION['match_array']['map_id'] = $_POST['map_id']; $_SESSION['match_array']['jcp_score'] = $_POST['jcp_score']; $_SESSION['match_array']['opp_score'] = $_POST['opp_score']; $user_id = $_POST['user_id']; // Get username for the match_roster_array variable $resultUN = mysql_query ("SELECT `username` FROM `phpbb_users` WHERE `user_id`='$user_id'"); if (!$resultUN) { echo("error performing query: " . mysql_error() . ""); exit(); } $rowUN = mysql_fetch_assoc($resultUN); $username = $rowUN['username']; // Update match_roster_array with new member $_SESSION['match_roster_array']["$user_id"] = array( "user_id" => $user_id, "username" => $username, "weapon" => $_POST['weapon'], "kills" => $_POST['kills'], "deaths" => $_POST['deaths'] ); $act = "edit"; } else if (isset ($_GET['delete'])) { $delete = $_GET['delete']; unset ($_SESSION['match_roster_array']["$delete"]); $act = "edit";}$row = $_SESSION['match_array'];// Get division information$resultDiv = mysql_query ("SELECT * FROM `jcp_divisions` WHERE `division_id` = '" . $_SESSION['match_array']['division_id'] . "'");if (!$resultDiv) { echo("error performing query: " . mysql_error() . ""); exit(); }$rowDiv = mysql_fetch_assoc($resultDiv);$division_name = $rowDiv['division_name'];$division_icon = $rowDiv['icon'];?><form method="post" action="index.php" name="form"><input type="hidden" name="p" value="admin"><input type="hidden" name="a" value="<?php echo $module_a; ?>"><input type="hidden" name="step" value="3"><input type="hidden" name="act" value="<?php echo $_SESSION['match_array']['act']; ?>"><input type="hidden" name="match_id" value="<?php echo $_SESSION['match_array']['match_id']; ?>"><input type="hidden" name="division_id" value="<?php echo $_SESSION['match_array']['division_id']; ?>"> <table width="100%" border="0" cellspacing="1" cellpadding="2"> <tr> <td colspan="2">Add/Edit <?php echo $module_message_name; ?></td> </tr> <tr> <td colspan="2"><hr size="1" noshade></td> </tr> <tr> <td width="200">Match Date <span class="required">*</span></td> <td width="1007"><input name="match_date" type="text" class="form" id="match_date" size="12" maxlength="10" <?php if ($act == "edit") { echo "value=\"$row[match_date]\""; } else { echo "value=\"".date('Y-m-d')."\""; } ?>> <a href="javascript:cal1.popup();"><img src="images/calendar.gif" width="16" height="16" border="0" align="top"></a> <span>(yyyy-mm-dd)</span></td> </tr> <tr> <td>Division</td> <td><img src="images/upload_divisions/<?php echo $division_icon; ?>" width="16" height="16" alt="<?php echo $division_name; ?>" align="absmiddle" /> <?php echo $division_name; ?></td> </tr> <tr> <td width="200">League <span class="required">*</span></td> <td> <select name="league_id" id="league_id" class="form"> <option value="" selected></option> <?php $resultLeagues = mysql_query ("SELECT * FROM `jcp_leagues` WHERE `division_id` = '" . $_SESSION['match_array']['division_id'] . "' ORDER BY `league_name` ASC"); if (!$resultLeagues) { echo("error performing query: " . mysql_error() . ""); exit(); } if (mysql_num_rows ($resultLeagues)) { while($rowLeagues = mysql_fetch_assoc ($resultLeagues)) { if ($act == "edit" && $row['league_id'] == $rowLeagues['league_id']) { $selected = "selected"; } else { $selected = ""; } echo "<option value=\"$rowLeagues[league_id]\" $selected>$rowLeagues[league_name]</option>\n"; } } ?> </select> </td> </tr> <tr> <td>Opponent <span class="required">*</span></td> <td><select name="opponent_id" id="opponent_id" class="form"> <option value="" selected="selected"></option> <?php $resultOpp = mysql_query ("SELECT * FROM `jcp_opponents` ORDER BY `opponent_name` ASC"); if (!$resultOpp) { echo("error performing query: " . mysql_error() . ""); exit(); } if (mysql_num_rows ($resultOpp)) { while($rowOpp = mysql_fetch_assoc ($resultOpp)) { if ($act == "edit" && $row['opponent_id'] == $rowOpp['opponent_id']) { $selected = "selected"; } else { $selected = ""; } echo "<option value=\"$rowOpp[opponent_id]\" $selected>$rowOpp[opponent_name] ($rowOpp[tag])</option>\n"; } } ?> </select></td> </tr> <tr> <td>Map * </td> <td><select name="map_id" id="select" class="form"> <option value="" selected="selected"></option> <?php $resultMaps = mysql_query ("SELECT * FROM `jcp_maps` WHERE `division_id` = '" . $_SESSION['match_array']['division_id'] . "' ORDER BY `map_name` ASC"); if (!$resultMaps) { echo("error performing query: " . mysql_error() . ""); exit(); } if (mysql_num_rows ($resultMaps)) { while($rowMaps = mysql_fetch_assoc ($resultMaps)) { if ($act == "edit" && $row['map_id'] == $rowMaps['map_id']) { $selected = "selected"; } else { $selected = ""; } echo "<option value=\"$rowMaps[map_id]\" $selected>$rowMaps[map_name]</option>\n"; } } ?> </select></td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td>jCp Score </td> <td><input name="jcp_score" type="text" class="form" id="jcp_score" size="4" maxlength="4" <?php if ($act == "edit") { echo "value=\"$row[jcp_score]\""; } ?> /></td> </tr> <tr> <td>Opponent Score </td> <td><input name="opp_score" type="text" class="form" id="opp_score" size="4" maxlength="4" <?php if ($act == "edit") { echo "value=\"$row[opp_score]\""; } ?> /></td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td width="200"><strong>Match Roster</strong></td> <td> </td></tr> <tr> <td colspan="2"> <table width="100%" border="0" cellspacing="2" cellpadding="2" class="border_full"> <tr> <td bgcolor="#F1F1F1"><strong>Name</strong></td> <td bgcolor="#F1F1F1"><strong>Weapon</strong></td> <td bgcolor="#F1F1F1"><strong>Kills</strong></td> <td bgcolor="#F1F1F1"><strong>Deaths</strong></td> <td bgcolor="#F1F1F1" width="16"> </td> </tr> <?php if (!empty($_SESSION['match_roster_array'])) { foreach ($_SESSION['match_roster_array'] as $match_roster_array) { echo "<tr>"; echo "<td>$match_roster_array[username]</td>"; echo "<td>$match_roster_array[weapon]</td>"; echo "<td>$match_roster_array[kills]</td>"; echo "<td>$match_roster_array[deaths]</td>"; echo "<td width=\"16\" align=\"right\">"; echo "<a href=\"index.php?p=admin&a=$module_a&step=2&delete=$match_roster_array[user_id]\">"; echo "<img src=\"images/admin/delete.gif\" border=\"0\" alt=\"Delete\">"; echo "</a>"; echo "</td>"; echo "</tr>"; } } else { echo '<tr>'; echo '<td colspan="5">Roster is currently empty</td>'; echo '</tr>'; } ?> <tr> <td colspan="5"><hr size="1" noshade="noshade" /></td> </tr> <tr> <?php $division_id = $_SESSION['match_array']['division_id']; $sql = "SELECT * FROM phpbb_users LEFT JOIN jcp_user_divisions ON phpbb_users.user_id = jcp_user_divisions.user_id WHERE jcp_user_divisions.division_id = '$division_id' ORDER BY `username` "; $resultUsers = mysql_query ($sql); if (!$resultUsers) { echo("error performing query: " . mysql_error() . ""); exit(); } if (mysql_num_rows ($resultUsers)) { echo '<td>'; echo '<select name="user_id" id="user_id" class="form">'; echo '<option value="" selected></option>'; while($rowUsers = mysql_fetch_assoc ($resultUsers)) { $user_id = $rowUsers['user_id']; if (empty($_SESSION['match_roster_array']) || (!in_array("$user_id", $_SESSION['match_roster_array']["$user_id"]))) { echo "<option value=\"$rowUsers[user_id]\" $selected>$rowUsers[username]</option>\n"; } } echo '</select></td>'; echo '<td><input name="weapon" type="text" class="form" id="weapon" size="30" maxlength="30" /></td>'; echo '<td><input name="kills" type="text" class="form" id="kills" size="4" maxlength="4" /></td>'; echo '<td><input name="deaths" type="text" class="form" id="deaths" size="4" maxlength="4" /></td>'; echo '<td width="16"><input name="Add" type="submit" class="form" id="Add" value="Add" /></td>'; echo ''; echo ''; } else { echo '<td colspan="5">No players in this division</td>'; } ?> </tr> </table> </td> </tr> <tr> <td colspan="2"><hr size="1" noshade></td> </tr> <tr> <td width="200"> </td> <td><input type="submit" name="Submit" value="Submit" class="form" /></td> </tr></table></form><script language="JavaScript"><!-- var cal1 = new calendar1(document.forms['form'].elements['match_date']); cal1.year_scroll = false; cal1.time_comp = false;//--></script>