[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>Merit Badge List</h2></center>
   8         <p><center><b>You must follow the requirements in the pamphlets.</b>
   9         <br>The Badge Number will link to another website that provides the Merit Badge Requirements.
  10         <br>The pamphlet requirements will be used when passing off the merit badge.
  11         <p>The requirements sheets online are correct, but to be sure,<br>reference the pamphlet <b>BEFORE</b> passing off the merit badge.
  12         <p>The Worksheets are for your convenience only.<br>They are not required and may ask you to do slightly more than is required.
  13         <br>You will need <a href=http://www.adobe.com/products/acrobat/readermain.html target=\"_blank\"><img src=http://www.adobe.com/images/getacro.gif width=5% length=5%></a> to use the worksheets.</p>
  14         </p>";
  15  
  16  if ($HTTP_GET_VARS["order"] == "" ) {
  17      $order = "required desc, badge_number";
  18  } else {
  19      $order = $HTTP_GET_VARS["order"];
  20      print "<center><a href=./index.php?list_merit_badges=Y>Default Sort</a>";
  21  }
  22  
  23  print "<table><tr align=center valign=bottom>
  24      <td><a href=./index.php?list_merit_badges=Y&order=badge_number>Badge Number</a><br><hr align=center size=2 width=100%></td>
  25      <td><a href=./index.php?list_merit_badges=Y&order=badge_name>Badge Name</a><br><hr align=center size=2 width=100%></td>
  26      <td><a href=./index.php?list_merit_badges=Y&order=required%20desc,%20badge_number>Required</a><br><hr align=center size=2 width=100%></td>
  27      <td><a href=./index.php?list_merit_badges=Y&order=pamphlet%20desc,%20badge_name>Pamphlets Available</a><br><hr align=center size=2 width=100%></td>
  28      <td>Year<br>Updated<br><hr align=center size=2 width=100%></td>
  29      <td>Pamphlet<br>Year<br><hr align=center size=2 width=100%></td>
  30      <td>Worksheet<br><hr align=center size=2 width=100%></td>";
  31  if ($user_group < 3) {
  32   print"        <td>Counselor<br><hr align=center size=2 width=100%></td>";
  33  }
  34  print"</tr><tr>";
  35  
  36  $sql = mysql_query("select record_key as badge_key
  37                      ,badge_number
  38                      ,badge_name
  39                      ,required as badge_required
  40                      ,defunct as badge_defunct
  41                      ,pamphlet as badge_pamphlet
  42                      ,image_number as badge_image_number
  43                      ,revision_date as badge_revision_date
  44                      ,print_date as badge_print_date
  45                      from tbl_merit_badge order by $order;");
  46  
  47  
  48  while ($row = mysql_fetch_assoc($sql)) {
  49      extract($row);
  50      $badge_name_pdf = "$badge_name.pdf";
  51      $badge_name_pdf = str_replace(' ','',$badge_name_pdf);
  52      $badge_name_pdf = str_replace('&','and',$badge_name_pdf);
  53      if ($badge_defunct =="N") {
  54      print "<tr align=center><td><a href=http://meritbadge.com/mb/$badge_number.htm target=\"_blank\">$badge_number</td>
  55             <td align=left>";
  56      if ( $badge_required == "Y" ) {
  57          print "<b>";
  58      }
  59      $badge_name_2 = str_replace(array(" "), array("%20"), $badge_name);
  60      if ($badge_print_date == '0000') {
  61          $badge_print_date = '&nbsp';
  62      }
  63      if ($badge_print_date < $badge_revision_date && $badge_print_date != '&nbsp') {
  64          $badge_print_date = '<b>OLD</b>';
  65      }
  66      print "$badge_name</td><td>$badge_required</td>
  67      <td>$badge_pamphlet</td>
  68      <td>$badge_revision_date</td>
  69      <td>$badge_print_date</td>
  70      <td><a href=http://meritbadge.com/files/mb-pdfs/$badge_name_pdf><image src=http://www.adobe.com/images/pdficon.gif width=20% length=20%></a></td>";
  71          if ($user_group < 3) {
  72           print "<td><a href=./index.php?counselor=Y&mb=$badge_number>MBC</a></td>";
  73          }
  74          print "</tr>";
  75  
  76      }
  77  }
  78  mysql_free_result($sql);
  79  print "</table>";
  80  
  81  ?>