Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
reporting	[ DIR ]	drwxr-sr-x	2020-01-14 08:25
2010_team.php	23.67 KB	-rw-r--r--	2017-07-03 10:50
approvals.php	3.7 KB	-rw-r--r--	2018-08-20 08:15
approvals_uni.php	3.51 KB	-rw-r--r--	2018-08-20 08:15
areas.php	8.49 KB	-rw-r--r--	2019-08-01 13:22
com_reg.php	6.77 KB	-rw-r--r--	2019-08-01 13:23
con_area.php	2.08 KB	-rw-r--r--	2017-08-02 09:09
con_man.php	8.61 KB	-rw-r--r--	2014-07-04 12:12
countrylist.php	11.91 KB	-rw-r--r--	2014-07-04 12:12
db.php	729 B	-rw-r--r--	2019-08-31 09:37
db.php.bak	323 B	-rw-r--r--	2014-07-04 12:12
entrants.php	2.22 KB	-rw-r--r--	2014-07-04 12:12
error_log	17.92 KB	-rw-r--r--	2014-07-04 12:12
footer.php	137 B	-rw-r--r--	2014-07-04 13:40
generateXML.php	649 B	-rw-r--r--	2014-07-04 12:12
index20130626.php	4.14 KB	-rw-r--r--	2014-07-04 12:12
login.php	1.4 KB	-rw-r--r--	2018-09-03 08:01
mailer.php	1.99 KB	-rw-r--r--	2017-07-03 10:50
menu.php	5.54 KB	-rw-r--r--	2019-06-12 10:15
payments.php	6.37 KB	-rw-r--r--	2018-08-20 08:15
phpinfo.php	24 B	-rw-r--r--	2014-07-04 12:12
reg.php	567 B	-rw-r--r--	2019-08-31 09:46
reports.php	1.81 KB	-rw-r--r--	2014-07-04 12:14
sec.php	650 B	-rw-r--r--	2014-07-04 12:14
social_app.php	4.48 KB	-rw-r--r--	2018-08-20 08:15
team.php	33.2 KB	-rw-r--r--	2019-08-01 13:25
team_mail.php	2.81 KB	-rw-r--r--	2017-07-03 10:50
timing_report.php	1.57 KB	-rw-r--r--	2014-07-04 12:14
timing_report_2012.php	10.96 KB	-rw-r--r--	2015-08-19 08:40
uni_reg.php	5.5 KB	-rw-r--r--	2019-08-01 13:26
uni_team.php	33.04 KB	-rw-r--r--	2019-08-01 13:23

Rename

<br/>
<script type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function validateTeamAdd() {
  var rc = false;
  
  if ( (document.frmadd.teamtype.value == 'Rec') && (document.frmadd.type.value == 5) ) {
    alert('You may not enter a Recreational Volley Ball Team');
    return false;
  }
  if ( (document.frmadd.teamtype.value == 'Rec') && (document.frmadd.type.value == 4) ) {
    alert('You may not enter a Recreational Tug of War Team');
    return false;
  }  
  
  MM_validateForm('name1','','R','type','','R','teamtype','','R');
  rc = document.MM_returnValue;
  
  return rc;

}

//-->
</script>            
            <?php

if (isset($_GET['act']))
  { 
    if ( ($_GET['act']=='add') && ($_SESSION['uid'] > 0) ) {//add
	
      if (isset($_POST['frm_sub'])) {
        $uquery="SELECT COUNT(id) FROM saace_team WHERE status='*' AND paid='*'";
        $ures=mysql_query($uquery);
        if ($ures) {
          $urow=mysql_fetch_assoc($ures);
          if (100>(int)$urow['COUNT(id)']) {
            $uquery="SELECT comp_id FROM saace_user WHERE id='".$_SESSION['uid']."'";
            $ures=mysql_query($uquery);
            if ($ures) {
              $urow=mysql_fetch_assoc($ures);
$insquery="INSERT INTO saace_team (name, comp_id, paid, type, status, team_type) VALUES ('".$_POST['name1']."','".$urow['comp_id']."','0','".$_POST['type']."','1','".$_POST['teamtype']."')";
			            
              mysql_query($insquery);
            }
            $tquery="SELECT * FROM saace_teamtype WHERE id='".$_POST['type']."'";
            $tres=mysql_query($tquery);
            if ($tres) {
              $trow=mysql_fetch_assoc($tres);
            }
            $selquery="SELECT * FROM saace_company WHERE id='".$urow['comp_id']."'";
            $selres=mysql_query($selquery);
            if ($selres) {
              $selrow=mysql_fetch_assoc($selres);
              $mstr="<html><body><p>Dear ".$selrow['contact']."<br/><br/>Thank you for entering ".$_POST['name']." (".$trow['name'].") for the CESA Relay race. <br/><br/> Please note that the cost for registering this team is R".$trow['cost']."<br/><br/>You will be issued with an invoice on which you will find the banking details.<a href='mailto:events@cesa.co.za'>events@cesa.co.za</a><br/><img src='http://www.cesa.co.za/relay/img/eMailLogo.gif' alt=''Logo></p>".$urow['comp_id']."</body></html>";
      //mail client
              $headers = "From: ".$admin_email."\r\n"."Reply-To: ".$admin_email."\r\nMIME-Version: 1.0\r\nContent-type: text/html; charset=iso-8859-1\r\nBcc: events@cesa.co.za\r\nBcc: athromethm@cesa.co.za\r\n";
              mail($selrow['email'],'CESA Team entry recorded',$mstr,$headers);
              $mstr="<html><body><p>".$selrow['contact']." from ".$selrow['name']." has registered a team for the CESA Relay race. <br/><br/>Please login to <a href='http://www.cesa.co.za/relay'>http://www.cesa.co.za/relay</a> to approve the reservations.<br/><br/>CESA Relay Website</p></body></html>";
          //mail client
              $headers = "From: ".$admin_email."\r\n"."Reply-To: ".$admin_email."\r\nMIME-Version: 1.0\r\nContent-type: text/html; charset=iso-8859-1\r\nBcc: events@cesa.co.za \r\n";
			  if($selrow['email']){
              	mail($admin_email."",'CESA Team entry',$mstr,$headers);
			  } else {
				$email='dsargeant@balixton.com';
				mail($email,'CESA Relay registration approved',$mstr,$headers);
			  }
            }
            echo "<h1>Team Added</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
          } else {
            echo "<h1>No new teams can be added</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
          }
        }
          
      } else {
        echo "<form name='frmadd'  method='POST' action='".$pagename."?sec=team&act=add'>\n";
        ?>
          <table width='100%' border='0' cellpadding='0' cellspacing='0'>
          <tr>
            <th colspan='2' align='left'>Add new team</th>
          </tr>
          <tr>
            <td width="13%">Team Name</td>
            <td width="87%"><input type='text' name='name1'> 
            Please enter the name for the team. </td>
          </tr>
          <tr>
            <td>Team Type</td>
            <td>
            <select name="teamtype" id="teamtype">
              <option value="Comp">Competitive</option>
              <option value="Rec">Recreational</option>
            </select>
            </td>
          </tr>          
          <tr>
              <td>Category</td>
              <td>
                <select name='type'>
                  <?php
                  $uquery="SELECT comp_id FROM saace_user WHERE id='".$_SESSION['uid']."'";
                  $ures=mysql_query($uquery);
                  if ($ures) {
                    $urow=mysql_fetch_assoc($ures);
                    $twquery="SELECT * FROM saace_team WHERE comp_id='".$urow['comp_id']."' AND type='4'";  // A company can only have 1 tug of war team
                    $twres=mysql_query($twquery);
                    if (mysql_num_rows($twres)>0) {
                      $twpresent=1;
                    } else {
                      $twpresent=0;
                    }
                    $tquery="SELECT * FROM saace_teamtype" ; // WHERE id = 4 ";
                    $tres=mysql_query($tquery);
                    if ($tres) {
                      while ($trow=mysql_fetch_assoc($tres)) {
                        if (!($trow['id']==4&&$twpresent==1)) {
                          echo "<option value='".$trow['id']."'>".$trow['name'].' (R'.$trow['cost'].')'."</option>\n";
                        }
                      }
                    }
                  }
                   
                  ?>
                </select> 
                Please not that the cost for each team is indicated in ( ) next to the team type. </td>
            </tr>

<tr>
            <td colspan='2'><input type='submit' name='frm_sub' onclick="return validateTeamAdd();" value='Add Team'/></td>
          </tr>
          </table>
</form>
        <?php
      }
    } elseif ( ($_GET['act']=='tmadd') || ($_GET['act']=='war1add') || ($_GET['act']=='war2add') || ($_GET['act']=='war3add') || ($_GET['act']=='voll1add') || ($_GET['act']=='voll2add') ) {
    
      switch ($_GET['act'])
      {
        case 'tmadd': //add member
          $tugcat = 0;
          $vollcat = 0;
          $genderflag = "B";
          $frmstr = "<form name='frmmemadd'  method='POST' onsubmit=\"return validate_form(this)\" action='".$pagename."?sec=team&act=tmadd&tid=".$_GET['tid']."'>\n";
        break;
        
        case 'war1add': //add tug mal
          $tugcat = 1;
          $vollcat = 0;
          $genderflag = "M";
          $frmstr = "<form  method='POST' onsubmit=\"return validate_form(this)\" action='".$pagename."?sec=team&act=war1add&tid=".$_GET['tid']."'>\n";
        break;
        
        case 'war2add': //add tug female
          $tugcat = 2;
          $vollcat = 0;
          $genderflag = "F";
          $frmstr = "<form  method='POST' onsubmit=\"return validate_form(this)\" action='".$pagename."?sec=team&act=war2add&tid=".$_GET['tid']."'>\n";
        break;
        
        case 'war3add': //add tug child
          $tugcat = 3;
          $vollcat = 0;
          $genderflag = "B";
          $frmstr = "<form  method='POST' onsubmit=\"return validate_form(this)\" action='".$pagename."?sec=team&act=war3add&tid=".$_GET['tid']."'>\n";
        break;
        
        case 'voll1add': //add volley male
          $tugcat = 0;
          $vollcat = 1;
          $genderflag = "M";
          $frmstr = "<form  method='POST' onsubmit=\"return validate_form(this)\" action='".$pagename."?sec=team&act=voll1add&tid=".$_GET['tid']."'>\n";
        break;
        
        case 'voll2add': //add volley female
          $tugcat = 0;
          $vollcat = 2;
          $genderflag = "F";
          $frmstr = "<form  method='POST' onsubmit=\"return validate_form(this)\" action='".$pagename."?sec=team&act=voll2add&tid=".$_GET['tid']."'>\n";
        break;
        
        default: // shouldn't get this at all
          $tugcat = 0;
          $vollcat = 0;
      
      }
      if (isset($_POST['frm_sub'])) {
        $insquery="INSERT INTO saace_teammembers (name, surname, team_id, ID_num, tugcat, vollcat, passport, gender, age, country, dobday, dobmonth, dobyear) VALUES ('".$_POST['name']."','".$_POST['surname']."','".$_GET['tid']."','".$_POST['ID_num']."','".$tugcat."','".$vollcat."','".$_POST['passport']."','".$_POST['gender']."','".$_POST['age']."','".$_POST['country']."','".$_POST['dobday']."','".$_POST['dobmonth']."','".$_POST['dobyear']."')";
        mysql_query($insquery);
        echo "<h1>Team Member Added</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
      } else {
        echo $frmstr;
        ?>
          <table width='100%' border='0' cellpadding='0' cellspacing='0'>
          <tr>
            <th colspan='2' align='left'>Add new team member</th>
          </tr>
          <tr>
            <td>Name</td>
            <td><input type='text' name='name'>
            Please enter the team members first name. </td>
          </tr>
          <tr>
            <td>Surname</td>
            <td><input type='text' name='surname'>
            Please enter the team members last name. </td>
          </tr>
          <tr>
            <td>ID Number</td>       
            <td><input type='text' name='ID_num' maxlength='15'>
            Please enter the ID number for the team member. </td>
          </tr>
          <tr>
            <td>Gender:</td> 
            <td>
            <?php
              switch ($genderflag)
              {
                case 'M':
                  echo "
                    <select name='gender'>
                    <option value='Male'>Male</option>
                    </select>";
                break;
                case 'F':
                  echo "
                    <select name='gender'>
                    <option value='Female'>Female</option>
                    </select>";
                break;
                default:
                  echo "
                    <select name='gender'>
                    <option value='Male'>Male</option>
                    <option value='Female'>Female</option>
                    </select>";

}                                
            ?>
            </td>
          </tr>
          <tr>
            <td>Date of Birth:</td>
            <td>
            <select name="dobday">
            <?php 
		for ($i=1; $i<=31; $i++)
                  echo("<option value='$i'>".$i."</option>");
	    ?>
	    </select>
            <select name="dobmonth">
            <?php 
		for ($i=1; $i<=12; $i++)
                  echo("<option value='$i'>".date( 'F', mktime(0, 0, 0, $i) )."</option>");
	    ?>
	    </select>	                
            <select name="dobyear">
            <?php 
		for ($i=1900; $i<=2010; $i++)
                  echo("<option value='$i'>".$i."</option>");
	    ?>
	    </select>
	    </td>
	  </tr>
          <tr>
             <td>Country</td>
             <td>
              <select name="country">
                  <?php
                    $tquery="SELECT * FROM saace_country ORDER BY name ASC";
                    $tres=mysql_query($tquery);
                    if ($tres) {
                      while ($trow=mysql_fetch_assoc($tres)) {
                        if ($trow['name']=='South Africa') {
                          echo "<option value='".$trow['name']."' selected>".$trow['name']."</option>\n";
                        } else {
                          echo "<option value='".$trow['name']."'>".$trow['name']."</option>\n";
                        }
                      }
                    }
                  ?>
              </select>
             </td>
          </tr>

<tr>
            <td colspan='2'><input type='submit' name='frm_sub' onclick="MM_validateForm('name','','R','surname','','R');return document.MM_returnValue" value='Add Team Member' /></td>
          </tr>
          </table>
          </form>
        <?php
      }

} elseif ($_GET['act']=='edi') {//edit
      if (isset($_POST['frm_sub'])) {
        //$updquery="UPDATE saace_team SET name='".$_POST['name']."',type='".$_POST['type']."' WHERE id='".$_GET['id']."'";
        $updquery="UPDATE saace_team SET name='".$_POST['name']."' WHERE id='".$_GET['id']."'";
        mysql_query($updquery);
        echo "<h1>Team Edited</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
      } else {
        $query="SELECT * FROM saace_team WHERE id='".$_GET['id']."'";
        $result=mysql_query($query);
        if ($result) {
          $row=mysql_fetch_assoc($result);
          echo "<form  method='POST' onsubmit=\"return validate_form(this)\" action='".$pagename."?sec=team&act=edi&id=".$_GET['id']."'>\n";
          ?>
            <table width='100%' border='0' cellpadding='0' cellspacing='0'>
            <tr>
              <th colspan='2' align='left'>Edit team</th>
            </tr>
            <tr>
              <td>Team Name</td>
              <td><input type='text' name='name' value='<?php echo $row['name'];?>'></td>
            </tr>
            
            
            <tr>
              <td colspan='2'><input type='submit' name='frm_sub' onclick="MM_validateForm('name','','R');return document.MM_returnValue" value='Save Team' /></td>
            </tr>
            </table>
            </form>
          <?php
        }
      }
    } elseif ($_GET['act']=='tmedi') {//edit member
      	  
	  if (isset($_POST['frm_sub'])) {
        $updquery="UPDATE saace_teammembers SET name='".$_POST['name']."',surname='".$_POST['surname']."', ID_num='".$_POST['ID_num']."', passport='".$_POST['ID_num3']."', gender='".$_POST['gender']."', age='".$_POST['age']."', country='".$_POST['country']."', dobday=".$_POST['dobday'].", dobmonth=".$_POST['dobmonth'].", dobyear=".$_POST['dobyear']." WHERE id='".$_GET['id']."'";
        mysql_query($updquery);
        echo "<h1>Team Member Edited</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
      } else {
		   
        $query="SELECT * FROM saace_teammembers WHERE id='".$_GET['id']."'";
        $result=mysql_query($query);
        if ($result) {
          $row=mysql_fetch_assoc($result);
          echo "<form  method='POST' onsubmit=\"return validate_form(this)\" action='".$pagename."?sec=team&act=tmedi&id=".$_GET['id']."'>\n";
		?>
            <table width='100%' border='0' cellpadding='0' cellspacing='0'>
            <tr>
              <th colspan='2' align='left'>Edit team member</th>
            </tr>
            <tr>
              <td width='100'>Name</td>
              <td><input type='text' name='name' value='<?php echo $row['name'];?>'></td>
            </tr>
            <tr>
              <td width='100'>Surname</td>
              <td><input type='text' name='surname' value='<?php echo $row['surname'];?>'></td>
            </tr>
            <tr>
            <td width='100'>ID Number</td>
            <td><input type='text' name='ID_num' maxlength="15" size="15" value='<?php echo $row['ID_num'];?>'>
          </tr>
          <tr>
            <td>Gender:</td> 
            <td>
            <?php
              if ( ($row['tugcat'] > 0) || ($row['vollcat'] > 0) ){
                echo $row['gender'];
                echo "<input type='hidden' value='".$row['gender']."'>";
              } else {
	        if($row['gender'] == "male"){
                  echo "<select name='gender'>
                  <option value='Male' selected='selected'>Male</option>
                  <option value='Female'>Female</option>
                  </select>";
	        } else {
                  echo "<select name='gender'>
                  <option value='Male'>Male</option>
                  <option value='Female' selected='selected'>Female</option>
                  </select>";
	        }
	      }
	    ?>
            </td>
            </tr>
          <tr>
            <td>Date of Birth:</td>
            <td>
            <select name="dobday">
            <?php 
		for ($i=1; $i<=31; $i++) {
		  if ($row['dobday'] == $i) {
                    echo("<option value='$i' selected>".$i."</option>");
                  } else {
                    echo("<option value='$i'>".$i."</option>");
                  }
                }
	    ?>
	    </select>
            <select name="dobmonth">
            <?php 
		for ($i=1; $i<=12; $i++) {
		  if ($row['dobmonth'] == $i) {
                    echo("<option value='$i' selected>".date( 'F', mktime(0, 0, 0, $i) )."</option>");
                  } else {
                    echo("<option value='$i'>".date( 'F', mktime(0, 0, 0, $i) )."</option>");
                  }
                }
	    ?>
	    </select>	                
            <select name="dobyear">
            <?php 
		for ($i=1900; $i<=2010; $i++) {
		  if ($row['dobyear'] == $i) {
                    echo("<option value='$i' selected>".$i."</option>");
                  } else {
                    echo("<option value='$i'>".$i."</option>");
                  }
                }
	    ?>
	    </select>
	    </td>
	  </tr>
            <tr>
            <td>Country</td>
       	    <td>
              <select name="country">
                  <?php
                    $tquery="SELECT * FROM saace_country ORDER BY name ASC";
                    $tres=mysql_query($tquery);
                    if ($tres) {
                      while ($trow=mysql_fetch_assoc($tres)) {
                        if ($trow['name']==$row['country']) {
                          echo "<option value='".$trow['name']."' selected>".$trow['name']."</option>\n";
                        } else {
                          echo "<option value='".$trow['name']."'>".$trow['name']."</option>\n";
                        }
                      }
                    }
                  ?>
              </select>
            </td>
            </tr>
            <tr>
              <td colspan='2'><input type='submit' name='frm_sub' value='Save Team Member'/></td>
            </tr>
            </table>
            </form>
            <p>
              <?php
        }
      }
    } elseif ($_GET['act']=='del') {//delete
      $delquery="DELETE FROM saace_team WHERE id='".$_GET['id']."'";
      mysql_query($delquery);
      $delquery="DELETE FROM saace_teammembers WHERE team_id='".$_GET['id']."'";
      mysql_query($delquery);
      
      echo "<h1>Team Deleted</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
    } elseif ($_GET['act']=='susp') {//suspend
      $susquery="UPDATE saace_team SET status='0' WHERE id='".$_GET['id']."'";
      mysql_query($susquery);
      echo "<h1>Team Suspended</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
    } elseif ($_GET['act']=='acti') {//restore
      $susquery="UPDATE saace_team SET status='1' WHERE id='".$_GET['id']."'";
      mysql_query($susquery);
      echo "<h1>Team Activated</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
    } elseif ($_GET['act']=='tmdel') {//member delete
      $delquery="DELETE FROM saace_teammembers WHERE id='".$_GET['id']."'";
      mysql_query($delquery);
      echo "<h1>Team Member Deleted</h1><a href='".$pagename."?sec=team'>Go to teams</a>\n";
    }
  } else {//list
    ?>
    
      <?php
        if ($_SESSION['uid'] == "") {
          echo "<h1>You are not logged in. Please login to continue</h1>";
        } else {
          echo "
            <table width='90%' border='0' cellpadding='0' cellspacing='0'>
              <tr>
                <th align='left'>Team Name</th>
                <th align='left'>Team Type</th>
                <th align='left'>Team Members</th>
                <th align='left'>Actions</th>
              </tr>";

$bgcnt=1;
          $uquery="SELECT comp_id FROM saace_user WHERE id='".$_SESSION['uid']."'";
          $ures=mysql_query($uquery);
          if ($ures) {
            $urow=mysql_fetch_assoc($ures);
            $query="SELECT * FROM saace_team WHERE comp_id='".$urow['comp_id']."'ORDER BY name ASC";
            $result=mysql_query($query);
            if ($result) {
              while ($row=mysql_fetch_assoc($result)) {
                if ($bgcnt > 1) {
                  if ($bgcnt%2==0) {
                    echo "<tr class='odd'><td colspan='4'><hr width='60%'></td></tr>";
                  } else {
                    echo "<tr class='even'><td colspan='4'><hr width='60%'></td></tr>";
                  }
                  $bgcnt++;
                }
                echo "<tr";
                if ($bgcnt%2==0) {
                  echo " class='odd'";
                } else {
                  echo " class='even'";
                }
                echo ">\n";
                  echo "<td style='text-decoration:underline'>".$row['name']."</td>\n";
                  $tmp_team_type = "";
                  if ($row['team_type'] == 'Comp') {$tmp_team_type = "**Competitive";}
                  if ($row['team_type'] == 'Rec') {$tmp_team_type = "**Recreational";}
                  $tquery="SELECT * FROM saace_teamtype WHERE id='".$row['type']."'ORDER BY name ASC";
                  $tresult=mysql_query($tquery);
                  if ($tresult) {
                    $trow=mysql_fetch_assoc($tresult);
                    echo "<td style='text-decoration:underline'>".$trow['name']."</td>\n";
                  }
                  echo "<td style='text-decoration:underline'>".$tmp_team_type."</td>\n";
				  
                  echo "<td>\n";
                  echo "  <a href='".$pagename."?sec=team&act=edi&id=".$row['id']."'><img border='0' src='img/edit.gif' alt='Edit'/></a>\n";
                  echo "  <a href='".$pagename."?sec=team&act=del&id=".$row['id']."' onclick='javascript: return confirm(\"Are you sure you want to delete this team - ".$row['name']."?\");'><img border='0' src='img/delete.gif' alt='Delete'/></a>\n";
                  if ($row['paid']=='1') {
                    if ($row['status']=='0') {
                      echo "  <a href='".$pagename."?sec=team&act=acti&id=".$row['id']."'><img border='0' src='img/restore.gif' alt='Activate'/></a>\n";
                    } else {
                      echo "  <a href='".$pagename."?sec=team&act=susp&id=".$row['id']."'><img border='0' src='img/suspend.gif' alt='Suspend'/></a>\n";
                    }
                  }
                  echo "</td>\n";
				  
                echo "</tr>\n";
                
                $bgcnt++;
                $twc1=0;
                $twc2=0;
				$vbc1=0;
                $vbc2=0;
                $twc3=0;
                //team member//
                $tmquery="SELECT * FROM saace_teammembers WHERE team_id='".$row['id']."' ORDER BY id ASC";
                $tmresult=mysql_query($tmquery);
                if ($tmresult) {
                  $tmcnt=0;
                  while ($tmrow=mysql_fetch_assoc($tmresult)) {
                    echo "<tr";
                    if ($bgcnt%2==0) {
                      echo " class='odd'";
                    } else {
                      echo " class='even'";
                    }
                    echo ">\n";
                      echo "<td></td>\n";
                      echo "<td></td>\n";
                      echo "<td>".$tmrow['name']." ".$tmrow['surname']."</td>\n";
                      echo "<td>\n";
                      echo "  <a href='".$pagename."?sec=team&act=tmedi&id=".$tmrow['id']."'><img border='0' src='img/edit.gif' alt='Edit'/></a>\n";
                      echo "  <a href='".$pagename."?sec=team&act=tmdel&id=".$tmrow['id']."' onclick='javascript: return confirm(\"Are you sure you want to delete this team member - ".$tmrow['name']."?\");'><img border='0' src='img/delete.gif' alt='Delete'/></a>\n";
                      echo "</td>\n";
                    echo "</tr>\n";
                    $tmcnt++;
                    $bgcnt++;
                    if ($tmrow['tugcat']=='1') $twc1++;
                    if ($tmrow['tugcat']=='2') $twc2++;
                    if ($tmrow['tugcat']=='3') $twc3++;
		    if ($tmrow['vollcat']=='1') $vbc1++;
                    if ($tmrow['vollcat']=='2') $vbc2++;
                  } //end while
                  if ($row['type']=='4') {
                    $tugquery="SELECT * FROM saace_tugwar WHERE id='1'";
                    $tugresult=mysql_query($tugquery);
                    if ($tugresult) {
                      $tugrow=mysql_fetch_assoc($tugresult);
                      echo "<tr";
                      if ($bgcnt%2==0) {
                        echo " class='odd'";
                      } else {
                        echo " class='even'";
                      }
                      echo ">\n";
                      $bgcnt++;
                      if ($twc1<$tugrow['people']) {
                      echo "<td colspan='4'><a href='".$pagename."?sec=team&act=war1add&tid=".$row['id']."'>Add New Member - ".$tugrow['name']." </a></td></tr>\n";
                      } else {
                        echo "<td colspan='4'>No New ".$tugrow['name']." Members can be added</a></td></tr>\n";
                      }
                    }
                    //women//
                    $tugquery="SELECT * FROM saace_tugwar WHERE id='2'";
                    $tugresult=mysql_query($tugquery);
                    if ($tugresult) {
                      $tugrow=mysql_fetch_assoc($tugresult);
                      echo "<tr";
                      if ($bgcnt%2==0) {
                        echo " class='odd'";
                      } else {
                        echo " class='even'";
                      }
                      echo ">\n";
                      $bgcnt++;
                      if ($twc2<$tugrow['people']) {
                        echo "<td colspan='4'><a href='".$pagename."?sec=team&act=war2add&tid=".$row['id']."'>Add New Member - ".$tugrow['name']." </a></td></tr>\n";
                      } else {
                        echo "<td colspan='4'>No New ".$tugrow['name']." Members can be added</a></td></tr>\n";
                      }
                    }
                    //children//
                    $tugquery="SELECT * FROM saace_tugwar WHERE id='3'";
                    $tugresult=mysql_query($tugquery);
                    if ($tugresult) {
                      $tugrow=mysql_fetch_assoc($tugresult);
                      echo "<tr";
                      if ($bgcnt%2==0) {
                        echo " class='odd'";
                      } else {
                        echo " class='even'";
                      }
                      echo ">\n";
                      $bgcnt++;
                      if ($twc3<$tugrow['people']) {
                       echo "<td colspan='4'><a href='".$pagename."?sec=team&act=war3add&tid=".$row['id']."'>Add New Member - ".$tugrow['name']." </a></td></tr>\n";
                      } else {
                        echo "<td colspan='4'>No New ".$tugrow['name']." Members can be added</a></td></tr>\n";
                      }
                    }
                  } 
				  
				  if ($row['type']=='5') {
					  
					//voll men//  
                    $vollquery="SELECT * FROM saace_volleball WHERE id='1'";
                    $vollresult=mysql_query($vollquery);
                    if ($vollresult) {
                      $vollrow=mysql_fetch_assoc($vollresult);
                      echo "<tr";
                      if ($bgcnt%2==0) {
                        echo " class='odd'";
                      } else {
                        echo " class='even'";
                      }
                      echo ">\n";
                      $bgcnt++;
                      if ($vbc1<$vollrow['people']) {
                      echo "<td colspan='4'><a href='".$pagename."?sec=team&act=voll1add&tid=".$row['id']."'>Add New Member - ".$vollrow['name']." </a></td></tr>\n";
                      } else {
                        echo "<td colspan='4'>No New ".$vollrow['name']." Members can be added</a></td></tr>\n";
                      }
                    }
                    //voll women//
                    $vollquery="SELECT * FROM saace_volleball WHERE id='2'";
                    $vollresult=mysql_query($vollquery);
                    if ($vollresult) {
                      $vollrow=mysql_fetch_assoc($vollresult);
                      echo "<tr";
                      if ($bgcnt%2==0) {
                        echo " class='odd'";
                      } else {
                        echo " class='even'";
                      }
                      echo ">\n";
                      $bgcnt++;
                      if ($vbc2<$vollrow['people']) {
                        echo "<td colspan='4'><a href='".$pagename."?sec=team&act=voll2add&tid=".$row['id']."'>Add New Member - ".$vollrow['name']." </a></td></tr>\n";
                      } else {
                        echo "<td colspan='4'>No New ".$vollrow['name']." Members can be added</a></td></tr>\n";
                      }
                    }
                  } 
                  
                  if ( ($row['type']=='1') || ($row['type']=='2') || ($row['type']=='3') ) {
                    if ($tmcnt<$trow['people']) {
                      echo "<tr";
                      if ($bgcnt%2==0) {
                        echo " class='odd'";
                      } else {
                        echo " class='even'";
                      }
                      echo ">\n";
                      $bgcnt++;
                     echo "<td colspan='4'><a href='".$pagename."?sec=team&act=tmadd&tid=".$row['id']."'>Add New Team Member</a></td></tr>\n";
                    } else {
                      echo "<tr";
                      if ($bgcnt%2==0) {
                        echo " class='odd'";
                      } else {
                        echo " class='even'";
                      }
                      echo ">\n";
                      $bgcnt++;
                      echo "<td colspan='4'>Team is full</td></tr>\n";
                    }
                  }
                } else {
                  echo "<tr><td colspan='4'>No team members have been added yet</td></tr>\n";
                }
				
    //end team member//
              } //end while
              
                  if ($bgcnt%2==0) {
                    echo "<tr class='odd'><td colspan='4'><hr width='80%'></td></tr>";
                  } else {
                    echo "<tr class='even'><td colspan='4'><hr width='80%'></td></tr>";
                  }
                  $bgcnt++;
                              
              echo "<tr";
              if ($bgcnt%2==0) {
                echo " class='odd'";
              } else {
                echo " class='even'";
              }
              echo ">\n";
              $bgcnt++;
              echo "<td colspan='4'> <a href='".$pagename."?sec=team&act=add'>Add New Team</a> </td></tr>\n"  ; } else {
              echo "<tr><td colspan='4'>No teams have been added yet</td></tr>\n";
            }
          }
          
          echo "</table>";
          }
        ?>

<p>
        <?php
  }
?>
      </p>
      <p><?php // conditional show area ?>
        To make changes to a team simply click on 
<img src="img/edit.gif" width="16" height="16" /> icon and make the required changes.<br />
To delete a team simply click on the <img src="img/delete.gif" width="16" height="16" /> icon. </p>