Thank you for using E*Reminders!","black"); // Yes, this exit in the middle is not optimal, but it works. echo ""; exit; } /* if password matches, do the database add */ if ($ckpasswd==$epasswd) { /* Rewrite the passwd data to update edate and eip */ @mysql_query(" UPDATE passwd SET edate='$edate' WHERE email='$email'"); /* ...maybe this can be shortened to just one query? */ @mysql_query(" UPDATE passwd SET eip='$REMOTE_ADDR' WHERE email='$email'"); /* Construct Database Query , also check for 12 pm/am idiosyncracy */ if ($ampm == "pm") {$hour=$hour+12;} if ($hour == "12") {$hour=0;} if ($hour == "24") {$hour=12;} $query=$year.$month.$cal_day.$hour.$minute."00"; $id=uniqid(""); $shortcomment=$comment; /* Show the time THEY set the event for, in THEIR timezone */ if ($adv_notice == "yes"){ $comment=$month."-".$cal_day."-".$year." at ".$hour.":".$minute." GMT".$localzone."...\n\n".$comment; } @mysql_query(" INSERT INTO notify (date_field,email,comment,recur_num, recur_val,adv_notice,notify_num,notify_val, recurring,id,subject) VALUES ('$query','$email','$comment','$recur_num', '$recur_val','$adv_notice', '$notify_num','$notify_val','$recurring','$id','$subject') "); /* if advanced notice was checked calculate actual notify date and update. this is kind of messy. we really could be using the newer mysql support for this. Maybe we'll find time to do it one day */ if ($adv_notice=="yes") { $result=mysql_query(" SELECT * FROM notify WHERE id='$id'"); $row=mysql_fetch_array($result); $interval=$row['notify_num']; switch ($row['notify_val']) { case "day" : $interval=$interval*86400; break; case "minute" : $interval=$interval*60; break; case "hour" : $interval=$interval*3600; break; case "month" : $interval=$interval*2592000; break; case "year" : $interval=$interval*31536000; break; } $result=mysql_query(" SELECT unix_timestamp(date_field) FROM notify WHERE id='$id' "); $row=mysql_fetch_array($result); $new_time=$row['unix_timestamp(date_field)']-$interval; @mysql_query(" UPDATE notify SET date_field=FROM_UNIXTIME($new_time) WHERE id='$id'"); } /* Adjust event date to compensate for Timezone user selected */ $result=mysql_query(" SELECT unix_timestamp(date_field) FROM notify WHERE id='$id' "); $row=mysql_fetch_array($result); $new_time=$row['unix_timestamp(date_field)']-(($dbtzcorrect+$localzone)*3600); @mysql_query(" UPDATE notify SET date_field=FROM_UNIXTIME($new_time) WHERE id='$id'"); ?>

Reminder Submission
For the following date and time: $month/$cal_day/$year $hour:$minute:00 GMT$localzone Event: $subject Content of message: $shortcomment
	Help/About Account Options Home