[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) == "modify_scout.php" ) {
   4   print "<meta http-equiv=\"refresh\" content=\"0; URL=../index.php\">";
   5   exit;
   6  }
   7  
   8  if ($modify_scout == "Y" && $modify_scout_change == "N") {
   9      $rs = mysql_query("select first_name as first
  10                           ,last_name as last
  11                           ,address
  12                           ,city
  13                           ,state
  14                           ,zip
  15                           ,home_phone as phone
  16                           ,email_addr as email
  17                           ,birthdate
  18                           ,patrol
  19                           ,email_addr_2 as email2
  20                           ,parent_name
  21                           ,scout_email
  22                           from tbl_scout where record_key = $rowid");
  23        print mysql_error();
  24        extract(mysql_fetch_assoc($rs));
  25      print "<center><h3>Modify:<br>$first $last</center></h3>";
  26  } else {
  27      extract ($_POST, EXTR_SKIP);
  28      $scout_delete = $HTTP_POST_VARS["Delete"];
  29      if ( $modify_scout_change == "Y" ) {
  30          print "<center><h3>Verify Scout</center></h3>";
  31      } else {
  32          print "<center><h3>Add new Scout</center></h3>";
  33      }
  34  }
  35  print "<p><center><form action=./index.php method=POST>
  36        <table cellpadding=1 cellspacing=1 border=0 width=90%>
  37        <tr valign=middle><td align=right>First Name:</td>
  38          <td align=left><input type=text name=first size=15 maxlength=15 value=\"$first\"></td>
  39          <td align=right>Last Name:</td>
  40          <td align=left><input type=text name=last size=15 maxlength=25 value=\"$last\"></td></tr>
  41          <tr valign=middle>
  42          <td align=right>Address:</td><td colspan=4><input type=text name=address size=15 maxlength=50 value=\"$address\">
  43          City: <input type=text name=city size=15 maxlength=40 value=\"$city\">
  44          State:<input type=text name=state size=2 maxlength=2 value=\"$state\">
  45          Zip:<input type=text name=zip size=5 maxlength=5 value=\"$zip\"></td></tr>
  46          <tr valign=middle><td align=right>Home Phone:</td>
  47          <td align=left><input type=text name=phone size=15 maxlength=20 value=\"$phone\"></td></tr>
  48          <tr valign=middle><td align=right>Parent(s) Name:</td><td><input type=text name=parent_name size=30 maxlength=45 value=\"$parent_name\"></td>
  49          <td align=right>Parent E-mail Primary:</td>
  50          <td align=left><input type=text name=email size=30 maxlength=50 value=\"$email\"></td>
  51          <td align=right>Parent E-mail Secondary:</td>
  52          <td align=left><input type=text name=email2 size=30 maxlength=50 value=\"$email2\"></td></tr>
  53          <td align=right>Scout email:</td>
  54          <td align=left><input type=text name=scout_email size=30 maxlength=45 value=\"$scout_email\"></td>
  55          <td align=right>Birth Date:</td>
  56          <td align=left><input type=text name=birthdate size=10 maxlength=10 value=\"$birthdate\"
  57                         onChange=\"var box=document.forms[0].birthdate;var d=parseDate(box.value);
  58                           if(d==null){
  59                            alert('Date string not recognizable!');
  60                            box.value='';
  61                            box.focus();
  62                           } else {
  63                            box.value=formatDate(d,'yyyy-MM-dd');
  64                           }\"></td>
  65          <td align=right>Patrol:</td>
  66          <td align=left><select name=patrol><option value=\"$patrol\">$patrol</option>";
  67                          
  68  $patrol_sql = mysql_query("select patrol_name from tbl_patrols order by record_key;");
  69  
  70  while ($row = mysql_fetch_assoc($patrol_sql)) {
  71        extract($row);
  72      print    "<option value=\"$patrol_name\">$patrol_name</option>";
  73  }
  74  mysql_free_result($patrol_sql);
  75  
  76  print    "</select>";
  77  
  78  if ($modify_scout_change == "N") {        
  79      print "</table><input name=Submit value=Submit type=submit><input type=hidden name=rowid value=$rowid>";
  80      print "<input type=hidden name=modify_scout_change value=Y>";
  81      print "<input type=hidden name=modify_scout value=$modify_scout>";
  82      if ($user_group <= "0" && $modify_scout != "A") {
  83      print "<br><input name=Delete value=Delete type=submit><input type=hidden name=rowid value=$rowid>";
  84      }
  85  }
  86  
  87  if    ($modify_scout_change == "Y" && $scout_delete == "") {
  88      print "</table><input name=Submit value=Verify type=submit><input type=hidden name=rowid value=$rowid>";
  89      print "<input type=hidden name=modify_scout_change value=C>";
  90      print "<input type=hidden name=modify_scout value=$modify_scout>";
  91  }
  92  
  93  if ($user_group <= "0" && $scout_delete == "Delete") {
  94      print "</table><center><h2>You will be deleting all records for this scout!</h2>";
  95      print "<input name=Delete value=\"Verify Delete\" type=submit><input type=hidden name=rowid value=$rowid>";
  96      print "<input type=hidden name=modify_scout_change value=C>";
  97      print "<input type=hidden name=modify_scout value=D>";
  98  }
  99  
 100  if ($modify_scout_change == "C" ){
 101      print "</table>";
 102      $birthdate = verifydate($birthdate);
 103      if    ($modify_scout == "Y") {
 104          $sql = mysql_query("update tbl_scout 
 105                  set first_name = \"$first\"
 106                    , last_name = \"$last\"
 107                    , address = \"$address\"
 108                    , city = \"$city\"
 109                    , state = \"$state\"
 110                    , zip = \"$zip\"
 111                    , home_phone = \"$phone\"
 112                    , email_addr = \"$email\"
 113                    , birthdate = \"$birthdate\"
 114                    , patrol = \"$patrol\"
 115                    , email_addr_2 = \"$email2\"
 116                    , parent_name = \"$parent_name\"
 117                    , scout_email = \"$scout_email\"
 118                    where record_key = \"$rowid\";");
 119          print "Modified: $first $last<br>";
 120          
 121      }
 122      if ($modify_scout == "A") {
 123          $sql = mysql_query("insert into tbl_scout
 124                      ( first_name
 125                      , last_name
 126                      , address
 127                        , city
 128                        , state
 129                        , zip
 130                        , home_phone
 131                        , email_addr
 132                        , birthdate
 133                        , patrol
 134                        , email_addr_2
 135                        , parent_name
 136                        , scout_email
 137                        , user
 138                        , password
 139                      ) values
 140                      ( \"$first\"
 141                       , \"$last\"
 142                        , \"$address\"
 143                        , \"$city\"
 144                       , \"$state\"
 145                        , \"$zip\"
 146                        , \"$phone\"
 147                        , \"$email\"
 148                        , \"$birthdate\"
 149                        , \"$patrol\"
 150                        , \"$email2\"
 151                        , \"$parent_name\"
 152                        , \"$scout_email\"
 153                        , \"$first$last\"
 154                        , password(\"$first$last\")
 155                        );");
 156              print "Added: $first $last<br>with user=$first$last and password=$first$last";
 157              
 158              if ($user_group <= "1") {
 159                  print "<p><center><form method=POST action =./index.php>";
 160                  print "<input type=hidden name=modify_scout_change value=N>";
 161                  print "<input type=hidden name=modify_scout value=A>";
 162                  print "<input value=\"Add Another New Scout\" type=submit>";
 163                  print "</form></center>";
 164  }
 165      }
 166      if ($modify_scout == "D") {
 167          $sql = mysql_query("delete from tbl_scout where record_key = \"$rowid\";");
 168          print "<br>Deleted: $first $last from Scout Table";
 169  
 170          $sql = mysql_query("delete from tbl_scout_mb_cmplt where scout_key = \"$rowid\";");
 171          print "<br>Deleted: $first $last from Merit Badge Table";
 172  
 173          $sql = mysql_query("delete from tbl_scout_rank where scout_key = \"$rowid\";");
 174          print "<br>Deleted: $first $last from Rank Table";
 175  
 176          $sql = mysql_query("delete from tbl_misc_requirements where scout_key = \"$rowid\";");
 177          print "<br>Deleted: $first $last from Misc. Requirements Table";
 178  
 179          $sql = mysql_query("delete from tbl_scout_camping where scout_key = \"$rowid\";");
 180          print "<br>Deleted: $first $last from Camping Table";
 181  
 182          $sql = mysql_query("delete from tbl_scout_leadership where scout_key = \"$rowid\";");
 183          print "<br>Deleted: $first $last from Leadership Table";
 184  
 185          $sql = mysql_query("delete from tbl_scout_service where scout_key = \"$rowid\";");
 186          print "<br>Deleted: $first $last from Service Table";
 187  
 188          $sql = mysql_query("delete from tbl_scout_activity where scout_key = \"$rowid\";");
 189          print "<br>Deleted: $first $last from Activity Table";
 190      }
 191      
 192  }
 193  
 194  print "</form>";
 195  
 196  ?>