[Summary view] [Print] [Text view]

   1  <?php
   2  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) != "index.php" ) {
   3   print "<meta http-equiv=\"refresh\" content=\"0; URL=../index.php\">";
   4   exit;
   5  }
   6  
   7  print "<center><h2>List of current Scouts</center></h2>";
   8  
   9  print "<center><table><tr><td><b>Patrols:</b></td>\n";
  10  print "<td><a href='./index.php'>ALL</a></td>";
  11  
  12  $patrol_sql = "select patrol_name from tbl_patrols order by record_key;";
  13  $patrol_sql_out = mysql_query($patrol_sql);
  14  
  15  while ($patrol_row = mysql_fetch_assoc($patrol_sql_out)) { 
  16      extract($patrol_row);
  17      print "<td><a href='./index.php?View_Patrol=$patrol_name'>$patrol_name</a></td>";
  18  }
  19  mysql_free_result($patrol_sql_out);
  20  
  21  print "</tr></table>";
  22  
  23  print '<table cellpadding="2" cellspacing="0" border="1" class=white>';
  24  if ($order == "") {
  25      $order = "birthdate, last_name, first_name";
  26  } else {
  27      print "<center><a href=./index.php>Default Sort</a></center>";
  28  }
  29  
  30  print '<tr valign=middle align=center>';
  31  print "<td><b><a href=./index.php?order=first_name>First Name</a></b></td>";
  32  print "<td><b><a href=./index.php?order=last_name>Last Name</a><br></td>";
  33  print "<td><b>Home Phone</b></td>";
  34  print "<td><b>Assignment</b></td>";
  35  print "<td><b>Rank</b><br></td>";
  36  if ($include_birth_date == 'Y') {
  37      print "<td><a href=./index.php?order=><b>Birth Date</b></a></td>";
  38  }
  39  if ($user_group < 2) {
  40      print "<td><b>Count</b></td>";
  41  }
  42  
  43  print "</tr></b>\n";
  44  
  45  $rs_sql = "select * from tbl_scout";
  46  
  47  if ($View_Patrol != "") {
  48      $rs_sql = $rs_sql . " where patrol = '$View_Patrol'";
  49  }
  50  if ($order !="")  {
  51     $rs_sql = $rs_sql . " ORDER BY $order;";
  52  }
  53  
  54  $rs = mysql_query($rs_sql);
  55  
  56  while ($rs_row = mysql_fetch_assoc($rs)) {
  57     extract($rs_row);
  58  
  59     if ($home_phone == "" ) $home_phone = "&nbsp";
  60     $position = "";
  61     $sql_assignment = mysql_query("select position from tbl_scout_leadership where scout_key = $record_key and enddate='0000-00-00'");
  62     while ($sql_assignment_row = mysql_fetch_assoc($sql_assignment)) { extract($sql_assignment_row); }
  63     mysql_free_result($sql_assignment);
  64  
  65  
  66     print "<tr>";
  67     print "<td ><a href=./index.php?bs_info=Y&rowid=$record_key&show_print=Y&print_ins=bs_info=Y&show_modify_scout=Y>$first_name</a></td>";
  68     print "<td ><a href=./index.php?bs_info=Y&rowid=$record_key&show_print=Y&print_ins=bs_info=Y&show_modify_scout=Y>$last_name</a></td>";
  69     print "<td align=center>$home_phone</td>";
  70  
  71     $rank_key = "";
  72     $rank_rs = mysql_query("select max(rank_key) as rank_key1 from tbl_scout_rank where scout_key = $record_key and req_num=\"0\";");
  73     if ($rank_rs) {
  74      while ($rank_row = mysql_fetch_assoc($rank_rs)) { $rank_key = $rank_row["rank_key1"]; }
  75     }
  76     mysql_free_result($rank_rs);
  77  
  78     $rank = "";
  79     $rank_rs = mysql_query("select rank_name from tbl_rank where record_key = $rank_key;");
  80     if ($rank_rs) {
  81      while ($rank_row = mysql_fetch_assoc($rank_rs)) { $rank = $rank_row["rank_name"]; }
  82      mysql_free_result($rank_rs);
  83     }
  84     
  85  
  86     if ($rank == "" ) $rank = "&nbsp";
  87  
  88     print "<td align=center>$position</td>";
  89     print "<td align=center>$rank</td>";
  90  
  91     if ($include_birth_date == 'Y') {
  92      $birthdate = date('M j, Y',strtotime($birthdate));
  93      print "<td align=center>$birthdate</td>";
  94     }
  95     if ($user_group < 2) {
  96      print "<td align=center>$usage_cnt</td>";
  97     }
  98  
  99     print "</tr>\n";
 100  }
 101  print "</table>";
 102  
 103  ?>