[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  if ($user_group <= "1" ) {
   8      $new_mb_date = $HTTP_POST_VARS["mb_date_complete"];
   9      $new_mb_key = $HTTP_POST_VARS["badge_key"];
  10      $new_mb_date = verifydate($new_mb_date);
  11  
  12      if ($new_mb_date == '0000-00-00' && $HTTP_POST_VARS["merit_badge_change"] == "Y") {
  13      print "<center><h3>Invalid Date - $new_mb_date.<br>
  14          Please re-enter.<br></h3></center>";
  15      } else if ($HTTP_POST_VARS["merit_badge_change"] == "Y") {
  16      $sql = mysql_query("insert into tbl_scout_mb_cmplt (scout_key, mb_key, date) values (\"$rowid\", \"$new_mb_key\", \"$new_mb_date\" ) ");
  17      print "<center>Added Merit Badge Number $new_mb_key</center>";
  18      }
  19      if ($merit_badge_delete == 'Y') {
  20          $sql_out = mysql_query("DELETE from tbl_scout_mb_cmplt where scout_key=$rowid and mb_key=$mb_key");
  21          print "<p><h3>Deleted $mb_name<br>If this was a rank requirement, please correct it on the rank table as well.</h3></p>";
  22          unset($mb_key);
  23          unset($mb_name);
  24      }
  25  }
  26  
  27  $sql = mysql_query("select first_name as first, last_name as last from tbl_scout where record_key =$rowid;");
  28  extract(mysql_fetch_assoc($sql));
  29  mysql_free_result($sql);
  30  $sql = mysql_query("select position from tbl_scout_leadership where scout_key=$rowid and enddate='0000-00-00'");
  31  extract(mysql_fetch_assoc($sql));
  32  mysql_free_result($sql);
  33  
  34  print "<center><h3>Merit Badge Listing for<br>$position $first $last</h3></center>\n";
  35  
  36  print "<table align=center><tr>";
  37  
  38  $sql = mysql_query("select mb_key,date from tbl_scout_mb_cmplt where scout_key = \"$rowid\" order by date,record_key;");
  39  
  40  while ($row = mysql_fetch_assoc($sql)) {
  41      $mb_key[$i] = $row['mb_key'];
  42      $mb_date[$i] = $row['date'];
  43      $sql2 = mysql_query("select badge_name,badge_number from tbl_merit_badge where record_key = \"$mb_key[$i]\";");
  44      $row2 = mysql_fetch_assoc($sql2);
  45      mysql_free_result($sql2);
  46      $badge_name[$i] = $row2['badge_name'];
  47      $badge_number[$i] = $row2['badge_number'];
  48      print "<td align=right><b>$badge_name[$i]</b><br />$mb_date[$i]</td><td width=50><img src=http://usscouts.org/mb/patch/mb$badge_number[$i]c.gif>";
  49      if ($user_group <="1") {
  50          print"<form method=POST action=./index.php>
  51              <input type=hidden name=rowid value=$rowid>
  52              <input type=hidden name=merit_badge_delete value=Y>
  53              <input type=hidden name=modify_scout_mb value=Y>
  54              <input type=hidden name=mb_key value=$mb_key[$i]>
  55              <input type=hidden name=mb_name value='$badge_name[$i]'>
  56              <input type=submit value=Delete>
  57              </form>
  58             </td>";
  59      }
  60      $i++;
  61      $j++;
  62      if ( $j > 2 && !$sql_out->EOF) {
  63        $j = 0;
  64        print "</tr><tr>";
  65      }
  66  }
  67  mysql_free_result($sql);
  68  print "</tr></table>";
  69  if ($user_group <= "1" ) {
  70      print "<br><hr>";
  71      print "<center><h2>Add Completed Merit Badge</h2>\n";
  72  
  73      $sql = mysql_query("select mb_key from tbl_scout_mb_cmplt where scout_key=$rowid");
  74  
  75      $scout_badge_key_cnt = 0;
  76      while ($row = mysql_fetch_assoc($sql)) {
  77      $scout_badge_key_cnt++;
  78          $scout_badge_key[$scout_badge_key_cnt] = $row['mb_key'];
  79      }
  80      mysql_free_result($sql);
  81  
  82      $sql = mysql_query("select record_key, badge_number, badge_name from tbl_merit_badge order by badge_name;");
  83  
  84      $merit_badge_key_cnt = 0;
  85      while ($row = mysql_fetch_assoc($sql)) {
  86      $merit_badge_key_cnt++;
  87         $addbadge_key[$merit_badge_key_cnt] = $row['record_key'];
  88         $badge_number[$merit_badge_key_cnt] = $row['badge_number'];
  89         $badge_name[$merit_badge_key_cnt] = $row['badge_name'];
  90      }
  91      mysql_free_result($sql);
  92  
  93      print "<form name=addmb method=POST action=./index.php>";
  94  
  95      print "<input type=hidden name=rowid value=$rowid>";
  96      print "<input type=hidden name=merit_badge_change value=Y><input type=hidden name=modify_scout_mb value=Y>";
  97      print "<select name=badge_key><option value=\"\" selected=\"\">Add Merit Badge</option>\n";
  98      $tmp_cnt = 0;
  99      while ($tmp_cnt < $merit_badge_key_cnt) {
 100      $tmp_cnt++;
 101        $tmp_2_cnt = 0;
 102      $badge_complete[$tmp_cnt] = "N";
 103        while ($tmp_2_cnt < $scout_badge_key_cnt && $badge_complete[$tmp_cnt] == "N") {
 104          $tmp_2_cnt++;
 105          if ($addbadge_key[$tmp_cnt] == $scout_badge_key[$tmp_2_cnt]) {
 106          $badge_complete[$tmp_cnt] = "Y";
 107          } else {
 108          $badge_complete[$tmp_cnt] = "N";
 109          }
 110      }
 111      if ($badge_complete[$tmp_cnt] == "N") {
 112          print "<option value=$addbadge_key[$tmp_cnt]>$badge_name[$tmp_cnt]</option>\n";
 113      }
 114      }
 115      print "</select>";
 116      print " Date: <input type=text name=mb_date_complete size=10 maxlength=10
 117             onChange=\"var box=document.addmb.elements.mb_date_complete;var d=parseDate(box.value);
 118                           if(d==null){
 119                            alert('Date string not recognizable!');
 120                            box.value='';
 121                            box.focus();
 122                           } else {
 123                            box.value=formatDate(d,'yyyy-MM-dd');
 124                           }\"><input type=submit name=submit value=Submit></form>";
 125  }
 126  ?>