Roster Page - modified

[tarmer]

Ok.. Got that working simple enough.... Where does it store (and how) the different rosters ?

[JPDeni]

Everything is stored in the database. Roughly in the same place as your forum posts, except in a different table.

To access a given roster, you need to add "team" and the number of the team to the URL.

So, let's say your page is page 8 and the first team you entered is "The Roughnecks". The URL to access the roster for The Roughnecks would be

http://www.yourdomain.com/index.php?page=8;team=1

If you don't have a team number in the URL, you just get the dropdown list of all the teams that have been entered into the database and people can choose from there. That dropdown is at the bottom of every page so that people can go from one roster to the other easily.

I can make you a block that has links to all the teams if you want. I'll just need to know which page number your article has.

[barpoet]

sorry... posted in the wrong section..... 

[maldave]

Hi JPDeni,

Really nice work with this custom roster.

Any chance you can modify this code so that one can use it for managing an MMO guild isntead ?

I have edited your code a bit and this is what I got ;

http://www.skyline-mmo.eu/index.php?page=7&team=1&go=Show+Me

The part of your code that I changed was;

Code Select Expand

$positions = array('Bard','Beastmaster','Black Mage','Blue Mage','Corsair','Dancer','Dark Knight','Dragoon','Monk','Ninja','Paladin','Puppetmaster','Ranger','Red Mage','Samurai','Scholar','Summoner','Thief','Warrior','White Mage');

Now since this is a MMO game we dont need "teams" function anymore so that can be removed.
We also don't need to the award system, that can be removed as well. The only thing that would be needed is "Choose player to edit"  "Add a player". I would like to call it "Member" instead of player though. That member should then pop under either of those classes in the array 'Bard','Beastmaster' etc.. depending on what was added when the "member" got registered.

Also instead of this code;

`playerFName` TINYTEXT NOT NULL ,
`playerLName` TINYTEXT NOT NULL ,
`playerPosition` TINYTEXT NOT NULL ,
`playerNationality` TINYTEXT NOT NULL ,
`playerSalary` TINYTEXT NOT NULL ,
`playerGoals` INT( 3 ) NOT NULL DEFAULT '0',
`playerAssists` INT( 3 ) NOT NULL DEFAULT '0',
`playerCleanSheets` INT( 3 ) NOT NULL DEFAULT '0',

I want to have

memberName ( No need for F and L )
memberClass = correspons to the $positions = array('Bard','etc...
memberNation = 3 to choose from San d'Oria, Windurst, Bastok
memberRank = Member, Officer, LS Leader

Is this doable ?

[JPDeni]

Most everything is doable. The only way you can know is to give it a try. At this point, you are much more familiar with this code than I am. It's been so long since I looked at it, I would have to start over from the beginning.

[maldave]

Most everything is doable. The only way you can know is to give it a try. At this point, you are much more familiar with this code than I am. It's been so long since I looked at it, I would have to start over from the beginning.

I can wait np ^^ I have 0 skill in php or sql coding, so I don't really understand what I need to change

[maldave]

Ok so I changed the code and removed what was not needed;

The original part;

Code Select Expand

global $db_prefix, $scripturl, $user_info, $settings;

$positions = array('Goalkeeper','Defender','Midfielder','Forward');

//Add more countries here. Don't worry about them being in alphabetical order.
//For abbreviations see http://www.checkdomain.com/list.html or the install.xml file in the "Country Flags" mod
$countries = array (
                    'ar' => 'Argentina',
                    'es' => 'Spain',
                    'uk' => 'England',
                   );

//Use the .png flag images from the "Country Flags" mod -- http://custom.simplemachines.org/mods/index.php?mod=417
//The flag images should go into /Themes/default/images/flags/ -- If you put them somewhere else, enter the URL to the folder here
$flag_dir = $settings['default_theme_url'] . '/images/flags/';

// Create database tables
// You can delete this next bit after you run it once
//////////////////////////////////////////////////////
//////////////////////////////////////////////////////
db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}jpd_fanteams (
`team_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`teamOwner` TINYTEXT NOT NULL ,
`teamOwnerID` INT( 11 ) NOT NULL DEFAULT '0',
`teamName` TINYTEXT NOT NULL ,
`teamStadium` TINYTEXT NOT NULL ,
PRIMARY KEY ( `team_id` )
) ENGINE = MYISAM", __FILE__, __LINE__);

db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}jpd_fanplayers (
`player_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`team_id` INT( 11 ) NOT NULL DEFAULT '0',
`playerFName` TINYTEXT NOT NULL ,
`playerLName` TINYTEXT NOT NULL ,
`playerPosition` TINYTEXT NOT NULL ,
`playerNationality` TINYTEXT NOT NULL ,
`playerSalary` TINYTEXT NOT NULL ,
`playerGoals` INT( 3 ) NOT NULL DEFAULT '0',
`playerAssists` INT( 3 ) NOT NULL DEFAULT '0',
`playerCleanSheets` INT( 3 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `player_id` )
) ENGINE = MYISAM", __FILE__, __LINE__);

db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}jpd_fanawards (
`award_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`team_id` INT( 11 ) NOT NULL DEFAULT '0',
`awardType` TINYTEXT NOT NULL ,
`awardYear` INT( 4 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `award_id` )
) ENGINE = MYISAM", __FILE__, __LINE__);
//////////////////////////////////////////////////////
//////////////////////////////////////////////////////

Changed into;

Code Select Expand

global $db_prefix, $scripturl, $user_info, $settings;

$positions = array('Bard','Beastmaster','Black Mage','Blue Mage','Corsair','Dancer','Dark Knight','Dragoon','Monk','Ninja','Paladin','Puppetmaster','Ranger','Red Mage','Samurai','Scholar','Summoner','Thief','Warrior','White Mage');

//Add more countries here. Don't worry about them being in alphabetical order.
//For abbreviations see http://www.checkdomain.com/list.html or the install.xml file in the "Country Flags" mod
$countries = array (
                    'sa' => 'San d'Oria',
                    'wi' => 'Windurst',
                    'ba' => 'Bastok',
                   );

//Use the .png flag images from the "Country Flags" mod -- http://custom.simplemachines.org/mods/index.php?mod=417
//The flag images should go into /Themes/default/images/flags/ -- If you put them somewhere else, enter the URL to the folder here
$flag_dir = $settings['default_theme_url'] . '/images/flags/';

// Create database tables
// You can delete this next bit after you run it once
//////////////////////////////////////////////////////
//////////////////////////////////////////////////////

db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}jpd_members (
`member_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`memberName` TINYTEXT NOT NULL ,
`memberClass` TINYTEXT NOT NULL ,
`memberNation` TINYTEXT NOT NULL ,
`memberRank` TINYTEXT NOT NULL ,
`memberLevel` TINYTEXT NOT NULL ,
PRIMARY KEY ( `member_id` )
) ENGINE = MYISAM", __FILE__, __LINE__);

//////////////////////////////////////////////////////
//////////////////////////////////////////////////////

Then this code follows;

Code Select Expand


$teams = array();
$query =  db_query(
          "SELECT team_id,teamName
           FROM {$db_prefix}jpd_fanteams
           ORDER BY teamName", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($query))
  $teams[$row['team_id']] = $row['teamName'];
$page = $_GET['page'];
$printed = 0;

I didnt really know how to change this code, or if I need to add/remove   

After that:

Code Select Expand

//**Add/Edit team form
if ((isset($_GET['addteam']) || isset($_GET['editteam'])) && $user_info['is_admin']) {
  if (isset($_GET['addteam'])) {
    $teamowner = "";
    $teamname = "";
    $teamstadium = "";
    $submit = "Add Team";
    $hidden = "addteam";
    $teamid = "";
  }
  else {
    $team = $_GET['team'];
    $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_fanteams
           WHERE team_id LIKE $team", __FILE__, __LINE__);
    $row = mysql_fetch_assoc($query);
    $teamowner = $row['teamOwner'];
    $teamname = $row['teamName'];
    $teamstadium = $row['teamStadium'];
    $teamid = $row['team_id'];
    $submit = "Edit Team";
    $hidden = "editteam";
  }
  echo '<form action="' . $scripturl . '?page=' . $page . '" method="POST">';
  echo '<center><table>
          <input type="hidden" name="' . $hidden . '" value="2">
          <input type="hidden" name="teamid" value="' . $teamid . '">
          <tr><td align="right">Team Owner:</td>
              <td align="left"><input type="text" name="teamOwner" value="' . $teamowner . '"></td></tr>
          <tr><td align="right">Team Name:</td>
              <td align="left"><input type="text" name="teamName" value="' . $teamname . '"></td></tr>
          <tr><td align="right">Team Stadium:</td>
              <td align="left"><input type="text" name="teamStadium" value="' . $teamstadium . '"></td></tr>
          <tr><td colspan="2" align="center"><INPUT type="submit" name="team" value="' . $submit . '"></td></tr>';
  echo '</table></center></form>';
  $printed = 1;
}
// Add team to database
elseif (isset($_POST['addteam']) && $_POST['addteam'] == 2 && $user_info['is_admin']) {
  $teamOwner = $_POST['teamOwner'];
  $teamName = $_POST['teamName'];
  $teamStadium = $_POST['teamStadium'];
  $query =  db_query(
          "SELECT ID_MEMBER
           FROM {$db_prefix}members
           WHERE realName LIKE '$teamOwner'
           LIMIT 1", __FILE__, __LINE__);
  $row = mysql_fetch_assoc($query);
  $teamOwnerID = $row['ID_MEMBER'];
  db_query("INSERT INTO `{$db_prefix}jpd_fanteams`
          (team_id,teamOwner,teamOwnerID,teamName,teamStadium)
           VALUES (NULL, '$teamOwner', '$teamOwnerID', '$teamName', '$teamStadium')", __FILE__, __LINE__);
}
//**Update team in database
elseif (isset($_POST['editteam']) && $_POST['editteam'] == 2 && $user_info['is_admin']) {
  $teamOwner = $_POST['teamOwner'];
  $teamName = $_POST['teamName'];
  $teamStadium = $_POST['teamStadium'];
  $team_id = $_POST['teamid'];
  $query =  db_query(
          "SELECT ID_MEMBER
           FROM {$db_prefix}members
           WHERE realName LIKE '$teamOwner'
           LIMIT 1", __FILE__, __LINE__);
  $row = mysql_fetch_assoc($query);
  $teamOwnerID = $row['ID_MEMBER'];
  db_query("UPDATE `{$db_prefix}jpd_fanteams`
            SET `teamOwner` = '$teamOwner' , `teamOwnerID` = '$teamOwnerID',
                `teamName` = '$teamName', `teamStadium` = '$teamStadium'
            WHERE `team_id` =$team_id", __FILE__, __LINE__);
}

//**Add/Edit award form
if ((isset($_GET['addaward']) || isset($_GET['editaward'])) && $user_info['is_admin']) {
  if (isset($_GET['addaward'])) {
    $team_id = '';
    $awardType = '';
    $awardYear = '';
    $award_id = '';
    $submit = "Add award";
    $hidden = "addaward";
  }
  else {
    $award_id = $_GET['award'];
    $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_fanawards
           WHERE award_id LIKE $award_id", __FILE__, __LINE__);
    $row = mysql_fetch_assoc($query);
    $team_id = $row['team_id'];
    $awardType = $row['awardType'];
    $awardYear = $row['awardYear'];
    $submit = "Edit award";
    $hidden = "editaward";
  }
  echo '<form action="' . $scripturl . '?page=' . $page . '" method="POST">';
  echo '<center><table>
          <input type="hidden" name="' . $hidden . '" value="2">
          <input type="hidden" name="award_id" value="' . $award_id . '">
          <tr><td align="right">Team:</td>
              <td align="left"><select name="team_id">
              <option value=""> </option>';
    foreach ($teams as $key => $team) {
      echo '<option value="' . $key . '"';
      if ($team_id == $key)
        echo ' SELECTED ';
      echo '>' . $team . '</option>';
    }
    echo '</select>';
           echo '</td></tr>
          <tr><td align="right">Award Type:</td>
              <td align="left"><input type="text" name="awardType" value="' . $awardType . '"></td></tr>
          <tr><td align="right">Year:</td>
              <td align="left"><input type="text" name="awardYear" value="' . $awardYear . '" size="4"></td></tr>
          <tr><td colspan="2" align="center"><INPUT type="submit" name="award" value="' . $submit . '"></td></tr>';
  echo '</table></center></form>'; 
  $printed = 1;
}

// Add award to database
elseif (isset($_POST['addaward']) && $_POST['addaward'] == 2 && $user_info['is_admin']) {
  $team_id = $_POST['team_id'];
  $awardType = $_POST['awardType'];
  $awardYear = $_POST['awardYear'];
  db_query("INSERT INTO `{$db_prefix}jpd_fanawards`
          (award_id,team_id,awardType,awardYear)
           VALUES (NULL, '$team_id', '$awardType', '$awardYear')", __FILE__, __LINE__);
}
//**Update an award in the database
elseif (isset($_POST['editaward']) && $_POST['editaward'] == 2 && $user_info['is_admin']) {
    $award_id = $_POST['award_id'];
    $team_id = $_POST['team_id'];
    $awardType = $_POST['awardType'];
    $awardYear = $_POST['awardYear'];
  db_query("UPDATE `{$db_prefix}jpd_fanawards`
            SET `award_id` = '$award_id', `team_id` = '$team_id', `awardType` = '$awardType',  `awardYear` = '$awardYear'
            WHERE `award_id` =$award_id", __FILE__, __LINE__);
}

I removed all this since we don't need teams or awards.

Next in line;

Code Select Expand

//**Add/Edit player form
if ((isset($_GET['addplayer']) || isset($_GET['editplayer'])) && $user_info['is_admin']) {
  if (isset($_GET['addplayer'])) {
    $player_id = "";
    $team_id = "";
    $playerFName = "";
    $playerLName = "";
    $playerPosition = "";
    $playerNationality = "";
    $playerSalary = "";
    $playerGoals = "";
    $playerAssists = "";
    $playerCleanSheets = "";
    $submit = "Add Player";
    $hidden = "addplayer";
  }
  else {
    $player_id = $_GET['player'];
    $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_fanplayers
           WHERE player_id LIKE $player_id", __FILE__, __LINE__);
    $row = mysql_fetch_assoc($query);
    $team_id = $row['team_id'];
    $playerFName = $row['playerFName'];
    $playerLName = $row['playerLName'];
    $playerPosition = $row['playerPosition'];
    $playerNationality = $row['playerNationality'];
    $playerSalary = $row['playerSalary'];
    $playerGoals = $row['playerGoals'];
    $playerAssists = $row['playerAssists'];
    $playerCleanSheets = $row['playerCleanSheets'];
    $submit = "Edit Player";
    $hidden = "editplayer";
  }

I changed into;

Code Select Expand

//**Add/Edit member form
if ((isset($_GET['addmember']) || isset($_GET['editmember'])) && $user_info['is_admin']) {
  if (isset($_GET['addmember'])) {
    $member_id = "";
    $memberName = "";
    $memberClass = "";
    $memberNation = "";
    $memberRank = "";
    $memberLevel = "";
    $submit = "Add Member";
    $hidden = "addmember";
  }
  else {
    $member_id = $_GET['member'];
    $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_members
           WHERE member_id LIKE $member_id", __FILE__, __LINE__);
    $row = mysql_fetch_assoc($query);
    $memberName = $row['memberName'];
    $memberClass = $row['memberClass'];
    $memberNation = $row['memberNation'];
    $memberRank = $row['memberRank'];
    $memberLevel = $row['memberLevel'];
    $submit = "Edit Member";
    $hidden = "editmember";
  }

Next to change was;

Code Select Expand

  echo '<form action="' . $scripturl . '?page=' . $page . '" method="POST">';
  echo '<center><table>
          <input type="hidden" name="' . $hidden . '" value="2">
          <input type="hidden" name="player_id" value="' . $player_id . '">
          <tr><td align="right">Player Name:</td>
              <td align="left"><input type="text" name="playerFName" value="' . $playerFName . '"> <input type="text" name="playerLName" value="' . $playerLName . '"></td></tr>
          <tr><td align="right">Team:</td>
              <td align="left"><select name="team_id">
              <option value=""> </option>';
    foreach ($teams as $key => $team) {
      echo '<option value="' . $key . '"';
      if ($team_id == $key)
        echo ' SELECTED ';
      echo '>' . $team . '</option>';
    }
    echo '</select>';
           echo '</td></tr>
          <tr><td align="right">Position:</td>
              <td align="left"><select name="playerPosition">';
    foreach ($positions as $position) {
      echo '<option';
      if ($playerPosition == $position)
        echo ' SELECTED ';
      echo '>' . $position . '</option>';
    }
    echo '</select>';
           echo '</td></tr>
          <tr><td align="right">Nationality:</td>
              <td align="left"><select name="playerNationality">';
    asort($countries);
    foreach ($countries as $key => $country) {
      echo '<option value="' . $key . '"';
      if ($playerNationality == $key)
        echo ' SELECTED ';
      echo '>' . $country . '</option>';
    }
    echo '</select>';
           echo '</td></tr>
          <tr><td align="right">Salary:</td>
              <td align="left">$<input type="text" name="playerSalary" value="' . $playerSalary . '"></td></tr>
          <tr><td align="right">Career Number of Goals:</td>
              <td align="left"><input type="text" name="playerGoals" value="' . $playerGoals . '" size="3"></td></tr>
          <tr><td align="right">Career Number of Assists:</td>
              <td align="left"><input type="text" name="playerAssists" value="' . $playerAssists . '" size="3"></td></tr>
          <tr><td align="right">Career Number of Clean Sheets:</td>
              <td align="left"><input type="text" name="playerCleanSheets" value="' . $playerCleanSheets . '" size="3"></td></tr>
          <tr><td colspan="2" align="center"><INPUT type="submit" name="team" value="' . $submit . '"></td></tr>';
  echo '</table></center></form>';
  $printed = 1;
}

I didn't change anything here since I couldn't understad much of it  :laugh:

And to to the next part;

Code Select Expand

// Add player to database
elseif (isset($_POST['addplayer']) && $_POST['addplayer'] == 2 && $user_info['is_admin']) {
  $team_id = $_POST['team_id'];
  $playerName = $_POST['playerName'];
  $playerPosition = $_POST['playerPosition'];
  $playerNationality = $_POST['playerNationality'];
  $playerSalary = $_POST['playerSalary'];
  $playerGoals = $_POST['playerGoals'];
  $playerAssists = $_POST['playerAssists'];
  $playerCleanSheets = $_POST['playerCleanSheets'];
  db_query("INSERT INTO `{$db_prefix}jpd_fanplayers`
          (player_id,team_id,playerFName,playerLName,playerPosition,playerNationality,playerSalary,playerGoals,playerAssists,playerCleanSheets)
           VALUES (NULL, '$team_id', '$playerFName', '$playerLName', '$playerPosition', '$playerNationality', '$playerSalary', '$playerGoals', '$playerAssists', '$playerCleanSheets')", __FILE__, __LINE__);
}

//**Update player in database

elseif (isset($_POST['editplayer']) && $_POST['editplayer'] == 2 && $user_info['is_admin']) {
  $player_id = $_POST['player_id'];
  $team_id = $_POST['team_id'];
  $playerFName = $_POST['playerFName'];
  $playerLName = $_POST['playerLName'];
  $playerPosition = $_POST['playerPosition'];
  $playerNationality = $_POST['playerNationality'];
  $playerSalary = $_POST['playerSalary'];
  $playerGoals = $_POST['playerGoals'];
  $playerAssists = $_POST['playerAssists'];
  $playerCleanSheets = $_POST['playerCleanSheets'];
  db_query("UPDATE `{$db_prefix}jpd_fanplayers`
            SET `player_id` = '$player_id', `team_id` = '$team_id', `playerFName` = '$playerFName',  `playerLName` = '$playerLName',`playerPosition` = '$playerPosition',
                `playerNationality` = '$playerNationality', `playerSalary` = '$playerSalary', `playerGoals` = '$playerGoals',
                `playerAssists` = '$playerAssists', `playerCleanSheets` = '$playerCleanSheets'
            WHERE `player_id` =$player_id", __FILE__, __LINE__);
}

I changed to;

Code Select Expand

// Add member to database
elseif (isset($_POST['addmember']) && $_POST['addmember'] == 2 && $user_info['is_admin']) {
  $memberName = $_POST['memberName'];
  $memberClass = $_POST['memberClass'];
  $memberNation = $_POST['memberNation'];
  $memberRank = $_POST['memberRank'];
  $memberLevel = $_POST['memberLevel'];
  db_query("INSERT INTO `{$db_prefix}jpd_members`
          (member_id,memberName,memberClass,memberNation,memberRank,memberLevel)
           VALUES (NULL, '$memberName', '$memberClass', '$memberNation', '$memberRank', '$memberLevel')", __FILE__, __LINE__);
}

//**Update player in database

elseif (isset($_POST['editmember']) && $_POST['editmember'] == 2 && $user_info['is_admin']) {
  $member_id = $_POST['member_id'];
  $memberName = $_POST['memberName'];
  $memberClass = $_POST['memberClass'];
  $memberNation = $_POST['memberNation'];
  $memberRank = $_POST['memberRank'];
  $memberLevel = $_POST['memberLevel'];
  db_query("UPDATE `{$db_prefix}jpd_jpd_members`
            SET `member_id` = '$member_id', `memberName` = '$memberName', `memberClass` = '$memberClass',  `memberNation` = '$memberNation',`memberRank` = '$memberRank',
                `memberLevel` = '$memberLevel'
            WHERE `member_id` =$member_id", __FILE__, __LINE__);
}

And then this final part of the code;

Code Select Expand

//**Display a team's roster
elseif (isset($_GET['team']) && !isset($_GET['editteam'])) {
  $team = $_GET['team'];
  $awards = array();
  $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_fanteams
           WHERE team_id LIKE '$team'", __FILE__, __LINE__);
  $row = mysql_fetch_assoc($query);
  $teamowner = '<a href="' . $scripturl . '?action=profile;u=' . $row['teamOwnerID'] . '">' . $row['teamOwner'] . '</a>';
  $teamstadium = $row['teamStadium'];
  $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_fanplayers
           WHERE team_id LIKE '$team'
           ORDER BY playerLName", __FILE__, __LINE__);
  while ($row = mysql_fetch_assoc($query)) {
    $roster[$row['playerPosition']][$row['player_id']]['name'] = $row['playerFName'] . ' ' . $row['playerLName'];
    $roster[$row['playerPosition']][$row['player_id']]['nationality'] = '<img src="' . $flag_dir . $row['playerNationality'] . '.png" alt="' . $countries[$row['playerNationality']] . '" />';
    $roster[$row['playerPosition']][$row['player_id']]['salary'] = $row['playerSalary'];
    $roster[$row['playerPosition']][$row['player_id']]['goals'] = $row['playerGoals'];
    $roster[$row['playerPosition']][$row['player_id']]['assists'] = $row['playerAssists'];
    $roster[$row['playerPosition']][$row['player_id']]['cleansheets'] = $row['playerCleanSheets'];
  }
  $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_fanawards
           WHERE team_id LIKE '$team'
           ORDER BY awardYear,awardType", __FILE__, __LINE__);
  while ($row = mysql_fetch_assoc($query))
    $awards[] = '<tr><td>' . $row['awardYear'] . '</td><td align="left">' . $row['awardType'] . '</td></tr>';
  echo '<table width="100%">
          <tr><td colspan="6" align="center" class="catbg" style="font-size: 120%;">' . $teams[$team];
  echo '<table><tr><td width="17%" align="right">Owner:</td><td width="16%" align="left">'. $teamowner . '</td><td width="34%">';
  echo '<table>';
  foreach ($awards as $award)
    echo $award;
  echo '</table>';
  echo '</td><td width="17%" align="right">Stadium:</td><td width="16%" align="left">'. $teamstadium . '</td></tr></table>';
  echo '</td></tr>';
  foreach ($positions as $position) {
    echo '<tr><td colspan="6" align="left" class="titlebg">' . $position . '</td></tr>';
    echo '<tr class="windowbg"><td align="center">Name</td>
              <td align="center">Nationality</td>
              <td align="center">Salary</td>
              <td align="center">Career Goals</td>
              <td align="center">Career Assists</td>
              <td align="center">Career Clean Sheets</td></tr>';
    if (isset($roster[$position])) {
      foreach ($roster[$position] as $player) {
        echo '<tr class="windowbg2">';
        echo '<td align="center">' . $player['name'] . '</td>';
        echo '<td align="center">' . $player['nationality'] . '</td>';
        echo '<td align="center">$' . $player['salary'] . '</td>';
        echo '<td align="center">' . $player['goals'] . '</td>';
        echo '<td align="center">' . $player['assists'] . '</td>';
        echo '<td align="center">' . $player['cleansheets'] . '</td>';
        echo '</tr>';
      }
    }
  }
  echo '<tr><td colspan="6" align="center" class="catbg">&nb' . 'sp;</td></tr>';
  echo '</table>';
  $printed = 1;
}

if ($printed == 1) { echo '<hr />'; }

echo '<form action="' . $scripturl . '" method="GET">';
echo '<center><table>
        <input type="hidden" name="page" value="' . $page . '">
        <tr><td align="right">Which team' . "'" . 's roster<br />do you want to see?</td>
            <td align="left"><select name="team">
            <option value=""> </option>';
  foreach ($teams as $key => $team)
    echo '<option value="' . $key . '">' . $team . '</option>';
  echo '</select>';
         echo '</td></tr>
        <tr><td colspan="2" align="center"><INPUT type="submit" name="go" value="Show Me"></td></tr>';
echo '</table></center></form>';


if ($user_info['is_admin']) {
  echo '<table>';

// Add or edit team
  echo '<form action="' . $scripturl . '" method="GET">
          <input type="hidden" name="page" value="' . $page . '">
          <tr><td align="right">Choose team to edit</td>
              <td align="left"><select name="team">
              <option value=""> </option>';
    foreach ($teams as $key => $team)
      echo '<option value="' . $key . '">' . $team . '</option>';
    echo '</select>';
           echo ' <INPUT type="submit" name="editteam" value="Edit"></td>
            <td><INPUT type="submit" name="addteam" value="Add new team"></td></tr>';
  echo '</form>';

//Add or edit player
  echo '<form action="' . $scripturl . '" method="GET">';
  echo '<input type="hidden" name="page" value="' . $page . '">
          <tr><td align="right">Choose player to edit</td>
              <td align="left"><select name="player">
              <option value=""> </option>';
    $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_fanplayers
           ORDER BY playerLName", __FILE__, __LINE__);
    while ($row = mysql_fetch_assoc($query))
      echo '<option value="' . $row['player_id'] . '">' . $row['playerFName'] . ' ' . $row['playerLName'] . '</option>';
    echo '</select>';
           echo ' <INPUT type="submit" name="editplayer" value="Edit"></td>
           <td><INPUT type="submit" name="addplayer" value="Add new player"></td></tr>';
  echo '</form>';

//Add or edit award
  echo '<form action="' . $scripturl . '" method="GET">';
  echo '<input type="hidden" name="page" value="' . $page . '">
          <tr><td align="right">Choose award to edit</td>
              <td align="left"><select name="award">
              <option value=""> </option>';
    $query =  db_query(
          "SELECT *
           FROM {$db_prefix}jpd_fanawards
           ORDER BY awardYear,awardType", __FILE__, __LINE__);
    while ($row = mysql_fetch_assoc($query))
      echo '<option value="' . $row['award_id'] . '">' . $row['awardYear'] . ' ' . $row['awardType'] . '</option>';
    echo '</select>';
           echo ' <INPUT type="submit" name="editaward" value="Edit"></td>
           <td><INPUT type="submit" name="addaward" value="Add new award"></td></tr>';
  echo '</form>';

  echo '</table>';
}

I didn't touch this code at all ^^. So, at this point I'm wondering if I have done anything right yet or the parts that I changed have been to no vain ?  This is way over my head  but I still wanted to try 

[JPDeni]

Did it work? That's how I test things. I plug them into a php article and start tracking down the bugs. You'll need a text editor that tells you what the line numbers are so you can find things more easily.

[maldave]

Did it work? That's how I test things. I plug them into a php article and start tracking down the bugs. You'll need a text editor that tells you what the line numbers are so you can find things more easily.

No, I doesn't work, only getting a blank screen ^^. I have not change a lot of the code since I didn't really know what to change.

[JPDeni]

It will take several days for me to get to this and give it a really good look.