";
$res=mysql_query($query) or die ("Wysypał się na $query");
$napis="";
$napis="INFORMATION UPDATED. ";
$p_arrival_day=$_POST["arrival_day"];
$p_arrival_month=$_POST["arrival_month"];
$p_arrival_hour=$_POST["arrival_hour"];
$p_arrival_minute=$_POST["arrival_minute"];
if (is_numeric($p_arrival_day) && is_numeric($p_arrival_month) && $p_arrival_day > 0 && $p_arrival_day<=31 && $p_arrival_month > 0 && $p_arrival_month<=12)
{
$query="UPDATE bedl11_users SET arrival_day=$p_arrival_day, arrival_month=$p_arrival_month WHERE login=\"".$_SESSION["login"]."\"";
// echo "query = $query
";
$res=mysql_query($query) or die ("Wysypał się na $query .");
}
else
{
if ($p_arrival_day!="" || $p_arrival_month!="")
{$arrival_error="Something wrong with date and/or time of arrival";}
}
if (is_numeric($p_arrival_hour) && is_numeric($p_arrival_minute) && $p_arrival_hour!="" && $p_arrival_minute && $p_arrival_hour>=0 && $p_arrival_hour<=24 && $p_arrival_minute>=0 && $p_arrival_minute<60)
{
$query="UPDATE bedl11_users SET arrival_hour=$p_arrival_hour, arrival_minute=$p_arrival_minute WHERE login=\"".$_SESSION["login"]."\"";
//echo "query = $query
";
$res=mysql_query($query) or die ("Wysypał się na $query");
}
else
{
if ($p_arrival_hour!="" || $p_arrival_minute!="")
{$arrival_error="Something wrong with date and/or time of arrival";}
}
$p_dep_day=$_POST["dep_day"];
$p_dep_month=$_POST["dep_month"];
$p_dep_hour=$_POST["dep_hour"];
$p_dep_minute=$_POST["dep_minute"];
if (is_numeric($p_dep_day) && is_numeric($p_dep_month) && $p_dep_day > 0 && $p_dep_day<=31 && $p_dep_month > 0 && $p_dep_month<=12)
{
$query="UPDATE bedl11_users SET dep_day=$p_dep_day, dep_month=$p_dep_month WHERE login=\"".$_SESSION["login"]."\"";
//echo "query = $query
";
$res=mysql_query($query) or die ("Wysypał się na $query");
}
else
{
if ($p_dep_day!="" || $p_dep_month!="")
{$dep_error="Something wrong with date and/or time of departure";}
}
if (is_numeric($p_dep_hour) && is_numeric($p_dep_minute) && $p_dep_hour!="" && $p_dep_minute!="" && $p_dep_hour>=0 && $p_dep_hour<=24 && $p_dep_minute>=0 && $p_dep_minute <60)
{
$query="UPDATE bedl11_users SET dep_hour=$p_dep_hour, dep_minute=$p_dep_minute WHERE login=\"".$_SESSION["login"]."\"";
//echo "query = $query
";
$res=mysql_query($query) or die ("Wysypał się na $query");
}
else
{
if ($p_dep_hour!="" || $p_dep_minute!="")
{$dep_error="Something wrong with date and/or time of departure";}
}
$taxi=$_POST["taxi"];
if($taxi=="yes") { $query="UPDATE bedl11_users SET taxi=1 WHERE login=\"".$_SESSION["login"]."\"";}
else { $query="UPDATE bedl11_users SET taxi=0 WHERE login=\"".$_SESSION["login"]."\"";}
$res=mysql_query($query) or die ("Wysypał się na $query");
$persons=$_POST["persons"];
if(is_numeric($persons))
{
$query="UPDATE bedl11_users SET persons=$persons WHERE login=\"".$_SESSION["login"]."\"";
$res=mysql_query($query) or die ("Wysypał się na $query");
}
else
{
$persons_error="Something wrong with 'persons'";
}
$query = "SELECT affiliation FROM bedl11_users WHERE login=\"".$_SESSION["login"]."\"";
$res=mysql_query($query) or die ("Wysypał się na $query");
$rek=mysql_fetch_array($res);
$aff=$rek["affiliation"];
if($aff=="") {$srodek->assign("aff_error", "Plaese check this box to confirm Your arrival"); }
if(isset($_POST["confirm"]))
{if($_POST["confirm"]=="on")
{
$dzis=date("Y")."-".date("m")."-".date("d");
$query = "UPDATE bedl11_users SET confirm=1, confirm_date=\"$dzis\" WHERE login=\"".$_SESSION["login"]."\"";
//echo " q = $query
";
$res=mysql_query($query) or die ("Wysypał się na $query");
$napis.=" CONFIMATION ACCEPTED.";
//echo "DDDDDDD";
/*
$to = "lorek@math.uni.wroc.pl";
$from = "szekli@math.uni.wroc.pl";
$subject = "Stochastic Networks And Related Topic - Bedlewo 2007: Confirmation";
$message = "Thank You for Your confirmation of arrival to the conference\n\n
Stochastic Networks And Related Topic - Bedlewo 2007.\n\n\n Confirmation date: $dzis\n\n
Conference page: http://www.math.uni.wroc.pl";
$headers = "From: $from\r\n";
$success = mail($to, $subject, $message, $headers);
if ($success)
{echo "The email to $to from $from was successfully sent";}
else
{echo "An error occurred when sending the email to $to from $from";}
*/
}
}
$srodek->assign("napis", $napis);
if(isset($arrival_error)) {$srodek -> assign("arrival_error",$arrival_error);}
if(isset($dep_error)) {$srodek -> assign("dep_error",$dep_error);}
if(isset($persons_error)) {$srodek -> assign("persons_error",$persons_error);}
$query = "SELECT confirm FROM bedl11_users WHERE login=\"".$_SESSION["login"]."\"";
$res=mysql_query($query) or die ("Wysypał się na $query");
$rek=mysql_fetch_array($res);
$conf=$rek["confirm"];
//echo "
CC=$conf";
if($conf!="1") {$srodek->assign("conf_error", "Plaese check this box to confirm Your arrival");}
}
if($_POST["action"]=="chpass")
{
$p_oldpass=strtolower($_POST["oldpass"]);
$p_newpass1=strtolower($_POST["newpass1"]);
$p_newpass2=strtolower($_POST["newpass2"]);
$info_error="";
if($p_newpass1!=$p_newpass2)
{
$info_error="New password end re-typed password differ!";
}
$query = "SELECT pass FROM bedl11_users WHERE login=\"".$_SESSION["login"]."\"";
$res=mysql_query($query) or die ("Wysypał się na $query");
$rek=mysql_fetch_array($res);
$pass_old=$rek["pass"];
$p_oldpass_h=md5($p_oldpass);
$p_newpass=md5($p_newpass1);
if($p_oldpass_h!=$pass_old)
{
$info_error="Old password is wrong!";
}
if(strlen($p_newpass1)<4)
{
$info_error="New password to short (give at least 4 characters)!";
}
if($info_error=="")
{
$query = "UPDATE bedl11_users SET pass=\"$p_newpass\" WHERE login=\"".$_SESSION["login"]."\"";
$res=mysql_query($query) or die ("Wysypał się na $query");
//echo " q = $query
";
$srodek->assign("napis", "OK, password changed");
}
else
{
$srodek->assign("pass_error", "$info_error");
$srodek->assign("napis", "Something WRONG with password: see beneath !!!");
}
}
/* if($_POST["action"]=="confirm")
{
$dzis=date("Y")."-".date("m")."-".date("d");
$query = "UPDATE bedl11_users SET confirm=1, confirm_date=\"$dzis\" WHERE login=\"".$_SESSION["login"]."\"";
echo " q = $query
";
//$res=mysql_query($query) or die ("Wysypał się na $query");
$srodek->assign("napis", "CONFIMATION ACCEPTED");
}
*/
}
$query ="select name, surname, affiliation, email, title,abstract,confirm,confirm_date, arrival_day, arrival_month, arrival_hour, arrival_minute, dep_day, dep_month, dep_hour, dep_minute, persons, trip,where_arrival,where_departure, taxi FROM bedl11_users where login=\"".$_SESSION["login"]."\"; ";
$res=mysql_query($query) or die ("Wysypał się na $query");
$rek=mysql_fetch_array($res);
$name=$rek["name"];
$surname=$rek["surname"];
if($surname=="Lukaszewicz") {$surname="Łukaszewicz";}
$aff=$rek["affiliation"];
$title=$rek["title"];
$abstract=$rek["abstract"];
$email=$rek["email"];
$confirm=$rek["confirm"];
$confirm_date=$rek["confirm_date"];
$arrival_day=$rek["arrival_day"];
$arrival_month=$rek["arrival_month"];
$arrival_hour=$rek["arrival_hour"];
$arrival_minute=$rek["arrival_minute"];
$where_arrival=$rek["where_arrival"];
$where_departure=$rek["where_departure"];
$dep_day=$rek["dep_day"];
$dep_month=$rek["dep_month"];
$dep_hour=$rek["dep_hour"];
$dep_minute=$rek["dep_minute"];
$persons=$rek["persons"];
$trip=$rek["trip"];
$taxi=$rek["taxi"];
if($taxi!=1)
{ $srodek->assign("taxi_no","checked");
}
else
{ $srodek->assign("taxi_yes","checked");
}
if($trip!=1)
{ $srodek->assign("trip_no","checked");
}
else
{ $srodek->assign("trip_yes","checked");
}
if( ($aff=="") || ($title=="") || ($abstract=="") || ($confirm==0))
{
$srodek->assign("fill","yes");
}
$srodek->assign("name", $name);
$srodek->assign("surname", $surname);
$srodek->assign("aff", $aff);
$srodek->assign("title", $title);
$srodek->assign("abstract", $abstract);
$srodek->assign("where_arrival",$where_arrival);
$srodek->assign("where_departure",$where_departure);
$srodek->assign("email", $email);
$srodek->assign("login", $_SESSION["login"]);
$srodek->assign("confirm", $confirm);
$srodek->assign("confirm_date", $confirm_date);
$srodek->assign("arrival_day", $arrival_day);
$srodek->assign("arrival_month", $arrival_month);
$srodek->assign("arrival_hour", $arrival_hour);
$srodek->assign("arrival_minute", $arrival_minute);
$srodek->assign("dep_day", $dep_day);
$srodek->assign("dep_month", $dep_month);
$srodek->assign("dep_hour", $dep_hour);
$srodek->assign("dep_minute", $dep_minute);
$srodek->assign("persons",$persons);
$main_page -> assign("main", $srodek -> fetch("2009_edit_index.tpl.html"));
$main_page -> assign("is_logged", "yes");
$main_page -> assign("login", $_SESSION["login"]);
$main_page -> display("2009_main.tpl.html");
?>