[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  //$db->debug = true;

   8  
   9  $sql = "select first_name,last_name,assignment from tbl_scout where record_key = \"$rowid\";";
  10  $sql_out = $db->Execute($sql);
  11  list ($first, $last, $assignment) = $sql_out->fields;
  12  
  13  print "<center><h3>Modify Rank for $assignment $first $last</h3></center>";
  14  
  15  function changerank() {
  16      global $db, $current_rank, $rowid, $new_rank_number, $new_rank_date;
  17      $sql = "insert into tbl_scout_rank
  18          ( scout_key, rank_key, date )
  19          values ( \"$rowid\", \"$new_rank_number\", \"$new_rank_date\");";
  20      $db->Execute($sql);
  21      $current_rank = $new_rank_number;
  22  }
  23  
  24  $new_rank_number = $HTTP_POST_VARS["new_rank_number"];
  25  $new_rank_date = $HTTP_POST_VARS["rank_date"];
  26  $correct_date = verifydate($new_rank_date);
  27  
  28  if (!$correct_date && $modify_scout_rank == "A") {
  29      print "<center><h3>Invalid Date - $new_rank_date.<br>
  30          Please re-enter.<br></h3></center>";
  31      $modify_scout_rank = "";
  32      $current_rank = $new_rank_number - 1;
  33  } else if ($modify_scout_rank == "A") {
  34      changerank();
  35  } else {
  36      $current_rank = $HTTP_POST_VARS["current_rank"];
  37  }
  38  
  39  $sql = "select rank_name from tbl_rank where record_key = $current_rank;";
  40  $sql_out = $db->Execute($sql);
  41  list ($current_rank_name) = $sql_out->fields;
  42  print "<center>Current Rank: <b>$current_rank_name</b></center>";
  43  if ( $current_rank < 7 ) {
  44      $next_rank = $current_rank + 1;
  45      $sql = "select rank_name from tbl_rank where record_key = $next_rank;";
  46      $sql_out = $db->Execute($sql);
  47      list ($next_rank_name) = $sql_out->fields;
  48      if ($modify_scout_rank == "A") {
  49          print "<center><h2>You just changed the rank for this scout.</h2><br>You may make another change if the scout has earned the next rank</center>";
  50      }
  51      print "<form method=POST action=./index.php>";
  52      print "<p><center>Change Rank to: <b>$next_rank_name</b></center>";
  53      print "<br><center>Date Received: <input type=text size=10 maxlength=10 name=rank_date>(YYYY-MM-DD)";
  54      print "<input type=hidden name=modify_scout_rank value=A><input type=hidden name=new_rank_number value=$next_rank>";
  55      print "<input type=hidden name=rowid value=$rowid>";
  56      print "<br><center><input type=submit value=submit></form>";
  57      } else {
  58      print "<center><h2>Scout is at highest rank of Eagle.</center></h2>";
  59      }
  60  
  61  
  62  ?>