include_once "includes/dbConnNew.php";
include_once "includes/loggedOn.php";
import_request_variables("gp", "");
$event_id = $_REQUEST["eve"];
$message_id = $_REQUEST["mid"];
$conf = $_REQUEST["conf"];
if($_REQUEST["mid"] > "0" && $_SESSION["sessionUserID"]){
$SQL = "select * from messages WHERE (ID ='$message_id') and (To_ID = '". $_SESSION["sessionUserID"] . "')";
$result = mysql_query($SQL) or die(mysql_error());
$num_rows = mysql_num_rows($result);
if($num_rows > "0"){
$SQL = "select DATE_FORMAT(Event_Date, '%b/%d/%Y') as evendDate,user_events.* from user_events where (user_events.deleted = 0) AND ((ID ='$event_id'))";
$result = mysql_query($SQL) or die(mysql_error());
if($myrow=MySQL_fetch_array($result)){
$Event_Name = $myrow["Event_Name"] ;
$evendDate = $myrow["evendDate"] ;
$Start_Time=$myrow["Start_Time"] ;
$End_Time=$myrow["End_Time"] ;
if($Start_Time > 12){
$Start_Time = ($Start_Time - 12);
$startPm = " pm" ;
} else if($Start_Time == 12){
$startPm = " pm" ;
} else {
if($Start_Time == "0"){$Start_Time = "12";}
$startPm = " am" ;
}
if($End_Time > 12){
$End_Time = $End_Time - 12;
$endPm = " pm" ;
} else if($End_Time == 12){
$endPm = " pm" ;
} else {
if($End_Time == "0"){$End_Time = "12";}
$endPm = " am" ;
}
}else {
$msg ="deleted" ;
}
if($conf == "y"){
$sqlInsert = " INSERT INTO user_events (Start_Minute,End_Minute,Event_Name, Start_Time ,End_Time ,Description, User_ID, Event_Date)";
$sqlInsert = $sqlInsert . "VALUES ('$_REQUEST[startMinute]', '$_REQUEST[endMinute]','$Event_Name','$_REQUEST[Start_Time]','$_REQUEST[End_Time]','$Description','". $_SESSION["sessionUserID"] . "','$Event_Date')" ;
$result = mysql_query($sqlInsert) or die(mysql_error());
$sqlupdate3 = "delete from messages WHERE (ID ='$message_id')";
$result3 = mysql_query($sqlupdate3) or die(mysql_error());
$msg ="y" ;
}
if($conf == "n" && $eve > " "){
$msg ="n" ;
}
} else {
header("Location: calendar.php");
exit ;
}
}
?>
yada home
include 'beforeEndHead.php'; ?>
include "googAna.php"; ?>