One Hat Cyber Team

View File Name : update.php3

<?
if($reply=="Cancel"){
include("kats2000.html");
}
else{
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=koi8-r">
<TITLE></TITLE>
</HEAD>

<BODY BGCOLOR="#FFFFFF" TEXT="#000000">

<table BORDER WIDTH="100%" bgcolor="#38354D">
<tr VALIGN=TOP>
<td ALIGN=LEFT VALIGN=CENTER WIDTH="70%"><a href="kats2000.html">
<img SRC="Koshkas1.jpg" ALT="logo" BORDER=0 height=100 width=145 align=CENTER>
</a><b><font face="Arial"><font size=+2><font color="#66FFFF">&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;R e g i s t r a t i o n&nbsp;&nbsp;&nbsp;
R e s u l t s</font></font></b></td>
</tr>
</table>

<table BORDER WIDTH="100%" >
 <tr VALIGN=TOP>
   <td WIDTH="100%" BACKGROUND="oblbeg.jpg">.</td>
 </tr>
</table>

<b>RESPONSE FROM SERVER</b>
<p>
<?
$uploaddir="/home/vo/uploads/";
//authenticate first
include("auth.php3");
mysql_connect("",$user,$password);
$result=mysql_db_query("conference",
            "select * from kats2000pw where pw='$pw'");
if(mysql_num_rows($result)==0){
mysql_free_result($result);
include("noaccess.html");
}
else{
// getting id
  $arr=mysql_fetch_array($result);
  mysql_free_result($result);
  $id=$arr["id"];
//preparing data
  if(!$filesubmitted){$filesubmitted="0";}
  $needkiev = $needticket.$airtrain.$needhotel;
  $needsim=$kiev.$gomyself.$simarrive.$arriveby;
  $hotel=$hotelcode.$double.$single.$share;
  if(!$areacode){$areacode="0";}
  if(!$payment){$payment="0";}
  if(!$accomp){$accomp="0";}
  if($last_1){$accomp="1";}
  if($last_2){$accomp="2";}
  if($last_3){$accomp="3";}
//writing uploaded file
if(!($abstractfile=="none")){
 $ok=system("cp $abstractfile $uploaddir$id.'tex'");
 echo "Uploaded $abstractfile_size bytes of abstractfile<BR>";
 $filesubmitted="1";
}
//updating database
  $result=mysql_db_query("conference",
   "update kats2000 set
   lastname='$lastname',  
   firstname='$firstname', 
   institution='$institution',
   faculty='$faculty',
   street='$street',
   city='$city',
   country='$country',
   phone='$phone',
   fax='$fax',
   talk='$talk',
   abstract='$abstract',
   filesubmitted='$filesubmitted',
   email='$email',
   needletter='$needletter',
   pass='$pass',
   pass_issued='$pass_issued',
   pass_date='$pass_date',
   pass_exp='$pass_exp',
   dob='$dob',
   pob='$pob',
   needkiev='$needkiev',
   kievdetails='$kievdetails',
   needsim='$needsim',
   sim_time='$sim_time',
   party='$party',
   banquet='$banquet',
   arrive='$arrive',
   depart='$depart',
   hotel='$hotel',
   neib='$neib',
   hotel_comment='$hotel_comment',   
   accomp='$accomp',
   payment='$payment'
   where id='$id'");
   if($result){echo "Participant's data updated<br>";}
   else{echo "Error updatig database!<BR>";}
// managing accompanies
  $result=mysql_db_query("conference",
             "select * from kats2000acc where parent='$id'");
  $oldaccomp=mysql_num_rows($result);
  mysql_free_result($result);
  if($oldaccomp >3){
    // kill'em all
    $oldaccomp=0;
    mysql_db_query("conference","delete from kats2000acc where parent='$id'");
  }
if($accomp){
  if($id1){
    //update first
    $result = mysql_db_query("conference",
               "update kats2000acc
               set
               lastname='$last_1',
               firstname='$first_1',
               pass='$pass_a1',
               pass_issued='$pass_issued_a1',
               pass_date='$pass_date_a1',
               pass_exp='$pass_exp_a1',
               dob='$dob_a1',
               pob='$pob_a1'                
               where id='$id1'");
  }
  else{
    //create first
    $result = mysql_db_query("conference",
     "insert into kats2000acc
     (parent,lastname,firstname,pass,pass_issued,pass_date,pass_exp,dob,pob)
     values 
     ('$id','$last_1','$first_1','$pass_a1','$pass_issued_a1','$pass_date_a1','$pass_exp_a1','$dob_a1','$pob_a1')");
  }
  if($accomp>1){
    if($id2){
      //update second
    $result = mysql_db_query("conference",
               "update kats2000acc
               set
               lastname='$last_2',
               firstname='$first_2',
               pass='$pass_a2',
               pass_issued='$pass_issued_a2',
               pass_date='$pass_date_a2',
               pass_exp='$pass_exp_a2',
               dob='$dob_a2',
               pob='$pob_a2'                
               where id='$id2'");
    }
    else{
      //create second
    $result = mysql_db_query("conference",
     "insert into kats2000acc
     (parent,lastname,firstname,pass,pass_issued,pass_date,pass_exp,dob,pob)
     values 
     ('$id','$last_2','$first_2','$pass_a2','$pass_issued_a2','$pass_date_a2','$pass_exp_a2','$dob_a2','$pob_a2')");
    }
  }
  else{
    if($id2){
      //delete second
      mysql_db_query("conference","delete from kats2000acc where id='$id2'");
    }
  }
  if($accomp>2){
    if($id3){
      //update third
    $result = mysql_db_query("conference",
               "update kats2000acc
               set
               lastname='$last_3',
               firstname='$first_3',
               pass='$pass_a3',
               pass_issued='$pass_issued_a3',
               pass_date='$pass_date_a3',
               pass_exp='$pass_exp_a3',
               dob='$dob_a3',
               pob='$pob_a1'                
               where id='$id3'");
    }
    else{
      //create third
    $result = mysql_db_query("conference",
     "insert into kats2000acc
     (parent,lastname,firstname,pass,pass_issued,pass_date,pass_exp,dob,pob)
     values 
     ('$id','$last_3','$first_3','$pass_a3','$pass_issued_a3','$pass_date_a3','$pass_exp_a3','$dob_a3','$pob_a3')");
    }
  }
  else{
    if($id2){
      //delete third
      mysql_db_query("conference","delete from kats2000acc where id='$id3'");
    }
  }
}
else{
  // deleting all accomps
  if($oldaccomp){
    mysql_db_query("conference","delete from kats2000acc where parent='$id'");
  } 
}

if($result){echo "Acommpanies' data updated<br>";}
else{echo "Error updatig database!<BR>";}

//mail to database administrator
$email="kats2000@imath.kiev.ua";
$subj="database updates";
$headers="From: Katsiveli Conference <kats2000@imath.kiev.ua>";
$message="Dear database manager;
Please, notice that the registration info was updated for \n
$firstname $lastname (id=$id).\n
Have a nice day!\n
   Yours Database";
$ok=mail($email,$subj,$message,$headers);
if($ok){echo "Notification message sent successfully<BR>";}
else{echo "Error sending notification<BR>";}
}            
?>
<p>
<a href="kats2000.html">Conference homepage</a>
</BODY>
</HTML>
<?
}
?>