[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 ($modify_merit_badge_change == "Y" ) {
   8      $sql = mysql_query("update tbl_merit_badge
   9                            set badge_name=\"$mbadge_name\"
  10                            , badge_number=\"$mbadge_number\"
  11                            , required=\"$mrequired\"
  12                            , defunct=\"$mdefunct\"
  13                            , pamphlet=\"$mpamphlet\"
  14                            , revision_date=\"$myear_updated\"
  15                            , print_date=\"$mp_year\"
  16                            where record_key=\"$badge_rowid\";");
  17  }
  18  if ($modify_merit_badge_insert == "Y" ) {
  19      $sql = mysql_query("insert into tbl_merit_badge
  20                            ( badge_name
  21                            , badge_number
  22                            , required
  23                            , defunct
  24                            , pamphlet
  25                            , revision_date
  26                            , print_date
  27                            ) values
  28                            ( \"$mbadge_name\"
  29                            , \"$mbadge_number\"
  30                            , \"$mrequired\"
  31                            , \"$mdefunct\"
  32                            , \"$mpamphlet\"
  33                            , \"$myear_updated\"
  34                            , \"$mp_year\"
  35                            );");
  36  }
  37  
  38  print "<center><h2>Add/Change Merit Badge List</h2></center>";
  39  
  40  print "<table><tr align=center valign=bottom>
  41      <td><b>Badge<br>Number<br><hr align=center size=2 width=100%></td>
  42      <td><b>Badge Name<br><hr align=center size=2 width=100%></td>
  43      <td><b>Required<br><hr align=center size=2 width=100%></td>
  44      <td><b>Year<br>Updated<br><hr align=center size=2 width=100%></td>
  45      <td><b>Pamphlet<br>Year<br><hr align=center size=2 width=100%></td>
  46      <td><b>Pamphlets<br>Available<br><hr align=center size=2 width=100%></td>
  47      <td><b>Defunct<hr align=center size=2 width=100%></td>
  48      <td></td></tr>\n";
  49  
  50  $sql = mysql_query("select * from tbl_merit_badge order by badge_name;");
  51  
  52  $sql = mysql_query("SELECT record_key as badge_key
  53          , badge_number
  54          , badge_name
  55          , required as badge_required
  56          , defunct as badge_defunct
  57          , pamphlet as badge_pamphlet
  58          , image_number as badge_image_number
  59          , revision_date as myear_update
  60          , print_date as mp_year
  61          FROM tbl_merit_badge
  62          order by badge_name;");
  63  
  64  while ($row = mysql_fetch_assoc($sql)) {
  65        extract($row);
  66      print "<tr align=center><td><form method=POST action=./index.php><center><input type=text size=3 maxlength=3 name=mbadge_number value=\"$badge_number\"></td>
  67              <td><input type=text size=30 maxlength=30 name=mbadge_name value=\"$badge_name\"></td>
  68              <td><input type=text size=1 maxlength=1 name=mrequired value=\"$badge_required\"></td>
  69              <td><input type=text size=4 maxlength=4 name=myear_updated value=\"$myear_updated\"></td>
  70              <td><input type=text size=4 maxlength=4 name=mp_year value=\"$mp_year\"></td>
  71              <td><input type=text size=1 maxlength=1 name=mpamphlet value=\"$badge_pamphlet\"></td>
  72              <td><input type=text size=1 maxlength=1 name=mdefunct value=\"$badge_defunct\"></td>
  73              <td><input type=submit value=\"Change Merit Badge\"><input type=hidden name=modify_merit_badge_change value=Y>
  74              <input type=hidden name=modify_merit_badges value=Y><input type=hidden name=badge_rowid value=$badge_key>
  75              </form></tr>\n";
  76  }
  77  mysql_free_result($sql);
  78  
  79  print "<tr align=center><td><form method=POST action=./index.php><center><input type=text size=3 maxlength=3 name=mbadge_number value=\"\"></td>
  80          <td><input type=text size=30 maxlength=30 name=mbadge_name value=\"\"></td>
  81          <td><input type=text size=1 maxlength=1 name=mrequired value=\"\"></td>
  82          <td><input type=text size=1 maxlength=1 name=myear_updated value=\"\"></td>
  83          <td><input type=text size=1 maxlength=1 name=mp_year value=\"\"></td>
  84          <td><input type=text size=1 maxlength=1 name=mpamphlet value=\"\"></td>
  85          <td><input type=text size=1 maxlength=1 name=mdefunct value=\"\"></td>
  86          <td><input type=submit value=\"Add Merit Badge\"><input type=hidden name=modify_merit_badge_insert value=Y>
  87          <input type=hidden name=modify_merit_badges value=Y>
  88          </form></tr>\n";
  89  print "</table>";
  90  
  91  ?>