/* Faktury
PAWE? LOREK , Pawel.Lorek@omega.pl
Copyright @2004 Polmat OMEGA.pl (http://www.omega.pl)
*/
//echo "asfd";
ini_set("display_error",false);
ini_set("error_reporting",E_ALL);
require_once "is_logged.php";
require_once "config/db_config.php";
require_once "functions/functions.php";
require_once "Smarty/Smarty.class.php";
$odczytuj=1;
$main_page = new Smarty;
$srodek = new Smarty;
//echo "db_table = $db_table ";
open_connection();
if ($_SERVER["REQUEST_METHOD"] =="POST")
{
if($_POST["action"]=="update")
{
$p_name=$_POST["name"];
$p_surname=$_POST["surname"];
$p_email=$_POST["email"];
$p_email=$_POST["email"];
/*
$p_aff=ereg_replace('"','\"',$_POST["aff"]);
$p_title=ereg_replace('"','\"',$_POST["title"]);
$p_abstract=ereg_replace('"','\"',$_POST["abstract"]);
*/
$p_aff=$_POST["aff"];
$p_title=$_POST["title"];
$p_abstract=$_POST["abstract"];
// echo " p_aff = $p_aff, title = $p_title ";
$p_where_arrival=$_POST["where_arrival"];
$p_where_departure=$_POST["where_departure"];
$p_trip=$_POST["trip"];
if ($p_trip=="") {$p_trip="0";}
$p_abstract = mysql_real_escape_string($p_abstract);
$query = "UPDATE $db_table SET name=\"$p_name\", surname=\"$p_surname\", trip=$p_trip, email=\"$p_email\", affiliation=\"$p_aff\", title=\"$p_title\", abstract=\"$p_abstract\", where_arrival=\"$p_where_arrival\", where_departure=\"$p_where_departure\" WHERE login=\"".$_SESSION["login"]."\"";
//echo " q = $query
";
$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 $db_table 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 $db_table 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 $db_table 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 $db_table 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 $db_table SET taxi=1 WHERE login=\"".$_SESSION["login"]."\"";}
else { $query="UPDATE $db_table 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 $db_table 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 $db_table 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 $db_table 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 $db_table 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 $db_table 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 $db_table 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 $db_table 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 $db_table 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("edit_index.tpl.html"));
$main_page -> assign("is_logged", "yes");
$main_page -> assign("login", $_SESSION["login"]);
$main_page -> display("main.tpl.html");
?>