<?
include_once "includes/dbConnNoSession.php"; 

//if($_REQUEST[theact] == "sendEmail"){
	//echo "hi";
  $today = date("Y-m-d");
  $thisHour = date("H");
  $thisMinute = date("i");
  $searchDate = date("Y-m-d",mktime(0, 0, 0, date("m"), (date("d")+1), date("Y")));
//  $thisTime = date("H:i");
//  $thisTime5Min = date("Y-m-d H:i",mktime(date('H'), (date('i')+5), 0, date("m"), date("d"), date("Y")));
//  $thisTime10Min = date("Y-m-d H:i",mktime(date('H'), (date('i')+10), 0, date("m"), date("d"), date("Y")));
//  $thisTime15Min = date("Y-m-d H:i",mktime(date('H'), (date('i')+15), 0, date("m"), date("d"), date("Y")));
//  $thisTime30Min = date("Y-m-d H:i",mktime(date('H'), (date('i')+30), 0, date("m"), date("d"), date("Y")));
//  $thisTime1Hour = date("Y-m-d H:i",mktime((date('H')+1), date('i'), 0, date("m"), date("d"), date("Y")));
//  $thisTime2Hour = date("Y-m-d H:i",mktime((date('H')+2), date('i'), 0, date("m"), date("d"), date("Y")));
//  $thisTime3Hour = date("Y-m-d H:i",mktime((date('H')+3), date('i'), 0, date("m"), date("d"), date("Y")));
//  $thisTime5Hour = date("Y-m-d H:i",mktime((date('H')+5), date('i'), 0, date("m"), date("d"), date("Y")));
//  
//  $thisTime5MinT = date("H:i",mktime(date('H'), (date('i')+5), 0, date("m"), date("d"), date("Y")));
//  $thisTime10MinT = date("H:i",mktime(date('H'), (date('i')+10), 0, date("m"), date("d"), date("Y")));
//  $thisTime15MinT = date("H:i",mktime(date('H'), (date('i')+15), 0, date("m"), date("d"), date("Y")));
//  $thisTime30MinT = date("H:i",mktime(date('H'), (date('i')+30), 0, date("m"), date("d"), date("Y")));
//  $thisTime1HourT = date("H:i",mktime((date('H')+1), date('i'), 0, date("m"), date("d"), date("Y")));
//  $thisTime2HourT = date("H:i",mktime((date('H')+2), date('i'), 0, date("m"), date("d"), date("Y")));
//  $thisTime3HourT = date("H:i",mktime((date('H')+3), date('i'), 0, date("m"), date("d"), date("Y")));
//  $thisTime5HourT = date("H:i",mktime((date('H')+5), date('i'), 0, date("m"), date("d"), date("Y")));
  
  // convert time zone
  include_once "TimeZone.php";
  
  
  // function for tasks notifications
  function checkAlerts($AlertInd,$TaskStart,$timezoneid,$gmt_offset,$dst_offset,$timezone_code){
	
//	global $thisTime, $thisTime5MinT,$thisTime10MinT, $thisTime15MinT, $thisTime30MinT, $thisTime1HourT, $thisTime2HourT, $thisTime3HourT, $thisTime5HourT     ;
//	global $searchDate, $thisTime5Min,$thisTime10Min, $thisTime15Min, $thisTime30Min, $thisTime1Hour, $thisTime2Hour, $thisTime3Hour, $thisTime5Hour     ;
	  
	switch ($AlertInd) {
		
		// 1 day
		case "D":
		  $thisTime = GetTomorrow($timezoneid,$gmt_offset,$dst_offset, $timezone_code) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
	 
		break;
		
		// 5 min
		case "5M":
		  $thisTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,5) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
		break;
		
		// 10 min
		case "10M":
		  $thisTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,10) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
		break;
		
		// 15 min
		case "15M":
		  $thisTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,15) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
		break;
		
		// 30 min
		case "30M":
		  $thisTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,30) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
		break;
		
		// 1 h
		case "1H":
		  $thisTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,60) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
		break;
		
		// 2 h
		case "2H":
		  $thisTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,120) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
		break;
  
		// 3 h
		case "3H":
		  $thisTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,180) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
		break;
		
		// 5 h
		case "5H":
		  $thisTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,300) ;
		  $showTimeTask = date("H:i",strtotime($thisTime));
		  if($TaskStart == $showTimeTask){
			$taskPassed = $thisTime ;
			return $taskPassed ;
		  }
		break;
	}
}
  
  

  // events
  $sqlEvent = "SELECT * FROM user_events 
		  WHERE (Event_Date = '$searchDate' or Event_Date = '$today') 
		  and (Alert_Send != 'Y')
		  and (Alert_IND != 'N')
		  and (Alert_IND > ' ')
		  and (Start_Time > ' ')
		  order by User_ID";  
  $resultEvent = mysql_query($sqlEvent) or die(mysql_error());
  while($Events=mysql_fetch_array($resultEvent)){
	  
	// get time zone
	if($Events[User_ID] != $timeZoneUser){  
	  $sqlZone = "SELECT timezone.* FROM timezone,users WHERE (timezone.timezoneid = users.Time_Zone) and (users.ID = '$Events[User_ID]')";  
	  $resultZone = mysql_query($sqlZone) or die(mysql_error());
	  if($Zone=mysql_fetch_array($resultZone)){
		  $timezoneid = $Zone[timezoneid] ;
		  $gmt_offset = $Zone[gmt_offset] ;
		  $dst_offset = $Zone[dst_offset] ; 
		  $timezone_code = $Zone[timezone_code] ;
	  } else {
		  // set to eastern
		  $timezoneid = "14" ;
		  $gmt_offset = "-5" ;
		  $dst_offset = "1" ; 
		  $timezone_code = "E" ;
	  }
	  $timeZoneUser = $Events[User_ID] ;
	}
	
	//$UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,$MinOffset) ;
	//list($UserDate,$UserTime) = explode(" ", $UserDateTime);
	
	  
	list($thisYear,$thisMonth,$thisDay) = explode("-", $Events[Event_Date]);
	$showDate = date("l M d, Y",mktime(0, 0, 0, $thisMonth,$thisDay,$thisYear));
	  
	switch ($Events[Alert_IND]) {
		// daily
		case "D":
		  $Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
		  $UserDateTime = GetTomorrow($timezoneid,$gmt_offset,$dst_offset, $timezone_code,'0') ;
		  
		  if($Start == $UserDateTime){
			  
			$displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			$sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			
			if($Events["End_Time"] > " "){
			  $displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			} else {
			  $displayEnd = " ";
			}
			
			$Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			$taskID[$Events[User_ID]][]= $Events[ID];
		  }
		  //also put in 1 hour before
		    $Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
			$UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,'60') ;
			
			if($Start == $UserDateTime){
			  $displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			  $sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		  
			  if($Events["End_Time"] > " "){
				$displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			  } else {
				$displayEnd = " ";
			  }
								   
			  $Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			  $taskID[$Events[User_ID]][]= $Events[ID];
			}
		break;
		
		// 5 min
		case "5M":
		  $Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
		  $UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,'5') ;
		  
		  if($Start == $UserDateTime){
			$displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			$sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		
			if($Events["End_Time"] > " "){
			  $displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			} else {
			  $displayEnd = " ";
			}
								 
			$Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			$taskID[$Events[User_ID]][]= $Events[ID];
		  }
		break;
		
		// 10 min
		case "10M":
			$Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
		  $UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,10) ;
		  //echo "<br>".$Start .", ".$UserDateTime." , ".$Events[User_ID]." ,".gmdate("H") ;
		  if($Start == $UserDateTime){
			  $displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			  $sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		  
			  if($Events["End_Time"] > " "){
				$displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			  } else {
				$displayEnd = " ";
			  }
								   
			  $Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			  $taskID[$Events[User_ID]][]= $Events[ID];
			}
		break;
		
		// 15 min
		case "15M":
			$Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
			$UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,15) ;
			
			if($Start == $UserDateTime){
			  $displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			  $sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		  
			  if($Events["End_Time"] > " "){
				$displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			  } else {
				$displayEnd = " ";
			  }
								   
			  $Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			  $taskID[$Events[User_ID]][]= $Events[ID];
			}
		break;
		
		// 30 min
		case "30M":
			$Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
			$UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,'30') ;
			
			if($Start == $UserDateTime){
			  $displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			  $sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		  
			  if($Events["End_Time"] > " "){
				$displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			  } else {
				$displayEnd = " ";
			  }
								   
			  $Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			  $taskID[$Events[User_ID]][]= $Events[ID];
			}
		break;
		
		// 1 hour
		case "1H":
			$Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
			$UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,'60') ;
			
			if($Start == $UserDateTime){
			  $displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			  $sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		  
			  if($Events["End_Time"] > " "){
				$displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			  } else {
				$displayEnd = " ";
			  }
								   
			  $Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			  $taskID[$Events[User_ID]][]= $Events[ID];
			}
		break;
		
		// 2 hour
		case "2H":
			$Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
			$UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,'120') ;
			
			if($Start == $UserDateTime){
			  $displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			  $sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		  
			  if($Events["End_Time"] > " "){
				$displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			  } else {
				$displayEnd = " ";
			  }
								   
			  $Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			  $taskID[$Events[User_ID]][]= $Events[ID];
			}
		break;
		
		// 3 hour
		case "3H":
			$Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
			$UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,'180') ;
			
			if($Start == $UserDateTime){
			  $displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			  $sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		  
			  if($Events["End_Time"] > " "){
				$displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			  } else {
				$displayEnd = " ";
			  }
								   
			  $Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			  $taskID[$Events[User_ID]][]= $Events[ID];
			}
		break;
		
		// 5 hour
		case "5H":
			$Start = date("Y-m-d H:i",mktime($Events[Start_Time], $Events[Start_Minute], 0, $thisMonth,$thisDay,$thisYear));
			$UserDateTime = GetTime($timezoneid,$gmt_offset,$dst_offset, $timezone_code,'300') ;
			
			if($Start == $UserDateTime){
			  $displayStart = date("g:ia",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
			  $sortStart = date("H:i:s",mktime($Events[Start_Time], $Events[Start_Minute], 0, 1,5,2009));
		  
			  if($Events["End_Time"] > " "){
				$displayEnd = date("g:ia",mktime($Events[End_Time], $Events[End_Minute], 0, 1,5,2009));
			  } else {
				$displayEnd = " ";
			  }
								   
			  $Display[$Events[User_ID]][] = $displayStart." - ".$displayEnd." Event: ".$Events[Event_Name]." on ".$showDate."<br>";
			  $taskID[$Events[User_ID]][]= $Events[ID];
			}
		break;
	}
	
  }
  
  
  // tasks
  $sqlTasks = "SELECT HOUR(Start_Time) as 'taskHour', MINUTE(Start_Time) as 'taskMin',todo_list.* FROM todo_list
		  WHERE (Due_Date > '0000-00-00') 
		  and (Start_Time > '00:00:00')
		  and Email_Notif != 'N'
		  and Email_Notif > ' '
		  and (Completed != 'Y')
		  order by User_ID";  
  $resultTasks = mysql_query($sqlTasks) or die(mysql_error());
  while($Tasks=mysql_fetch_array($resultTasks)){
	  
	  if($Tasks[Assign_To] > "0"){
		$userID = $Tasks[Assign_To] ;
	  } else {
		$userID = $Tasks[User_ID] ;
	  }
	
	  if($Tasks["Start_Time"] > "00:00:00"){
		$displayStartTasks = date("g:ia",strtotime($Tasks[Start_Time]));
	  } else {
		$displayStartTasks = " ";
	  }
	  if($Tasks["End_Time"] > "00:00:00"){
		$displayEndTasks = date("g:ia",strtotime($Tasks[End_Time]));
	  } else {
		$displayEndTasks = " ";
	  }
	  
	// get time zone
	if($userID != $timeZoneUser){  
	  $sqlZone = "SELECT timezone.* FROM timezone,users WHERE (timezone.timezoneid = users.Time_Zone) and (users.ID = '$userID')";  
	  $resultZone = mysql_query($sqlZone) or die(mysql_error());
	  if($Zone=mysql_fetch_array($resultZone)){
		  $timezoneid = $Zone[timezoneid] ;
		  $gmt_offset = $Zone[gmt_offset] ;
		  $dst_offset = $Zone[dst_offset] ; 
		  $timezone_code = $Zone[timezone_code] ;
	  } else {
		  // set to eastern
		  $timezoneid = "14" ;
		  $gmt_offset = "-5" ;
		  $dst_offset = "1" ; 
		  $timezone_code = "E" ;
	  }
	  $timeZoneUser = $userID ;
	}
	
	  
	$searchDate = date("Y-m-d",strtotime(GetTomorrow($timezoneid,$gmt_offset,$dst_offset, $timezone_code)));
	$showDateTask = date("l M d, Y",strtotime($searchDate));
	
	switch ($Tasks[Repeat_Ind]) {
		// daily
		case "1":
		  if(($Tasks[Due_Date] <= $searchDate) && ($Tasks[End_Date] >= $searchDate) && (checkAlerts($Tasks[Email_Notif],date("H:i",strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset,$timezone_code) > " ")){
			$showDateTask = date("l M d, Y",strtotime((checkAlerts($Tasks[Email_Notif],date('H:i',strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset,$timezone_code))));
			$Display[$userID][] = $displayStartTasks." - ".$displayEndTasks." To Do: ". $Tasks[Title]."<br>";
			$taskTime[$userID][] = $Tasks[Start_Time] ;
			$taskID[$userID][]= $Tasks[ID];
		  }
		break;
		// weekdays	
		case "2":
		  $weekdays = array(1,2,3,4,5);
		  $dayOfWeek =date("N",strtotime($searchDate));
  
		  if(($Tasks[Due_Date] <= $searchDate) && ($Tasks[End_Date] >= $searchDate) && (in_array($dayOfWeek, $weekdays)) && (checkAlerts($Tasks[Email_Notif],date("H:i",strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset, $timezone_code) > " ")){
			$showDateTask = date("l M d, Y",strtotime((checkAlerts($Tasks[Email_Notif],date('H:i',strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset,$timezone_code))));
			$Display[$userID][] = $displayStartTasks." - ".$displayEndTasks." To Do: ". $Tasks[Title]."<br>";
			$taskTime[$userID][] = $Tasks[Start_Time] ;
			$taskID[$userID][]= $Tasks[ID];
		  }
		break;
		// Weekends
		case "3":
		  $weekdays = array(6,7);
		  $dayOfWeek =date("N",strtotime($searchDate));
  
		  if(($Tasks[Due_Date] <= $searchDate) && ($Tasks[End_Date] >= $searchDate) && (in_array($dayOfWeek, $weekdays)) && (checkAlerts($Tasks[Email_Notif],date("H:i",strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset, $timezone_code) > " ")){
			$showDateTask = date("l M d, Y",strtotime((checkAlerts($Tasks[Email_Notif],date('H:i',strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset,$timezone_code))));
			$Display[$userID][] = $displayStartTasks." - ".$displayEndTasks." To Do: ". $Tasks[Title]."<br>";
			$taskTime[$userID][] = $Tasks[Start_Time] ;
			$taskID[$userID][]= $Tasks[ID];
		  }
		break;
		//Weekly
		case "4":
		  $dayOfWeek =date("N",strtotime($searchDate));
		  $taskDay =date("N",strtotime($Tasks[Due_Date]));
  
		  if(($Tasks[Due_Date] <= $searchDate) && ($Tasks[End_Date] >= $searchDate) && ($taskDay == $dayOfWeek) && (checkAlerts($Tasks[Email_Notif],date("H:i",strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset, $timezone_code) > " ")){
			$showDateTask = date("l M d, Y",strtotime((checkAlerts($Tasks[Email_Notif],date('H:i',strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset,$timezone_code))));
			$Display[$userID][] = $displayStartTasks." - ".$displayEndTasks." To Do: ". $Tasks[Title]."<br>";
			$taskTime[$userID][] = $Tasks[Start_Time] ;
			$taskID[$userID][]= $Tasks[ID];
		  }
		break;
		//Monthly
		case "5":
		  $dayOfMonth =date("j",strtotime($searchDate));
		  $taskDay =date("j",strtotime($Tasks[Due_Date]));
  
		  if(($Tasks[Due_Date] <= $searchDate) && ($Tasks[End_Date] >= $searchDate) && ($taskDay == $dayOfMonth) && (checkAlerts($Tasks[Email_Notif],date("H:i",strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset, $timezone_code) > " ")){
			$showDateTask = date("l M d, Y",strtotime((checkAlerts($Tasks[Email_Notif],date('H:i',strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset,$timezone_code))));
			$Display[$userID][] = $displayStartTasks." - ".$displayEndTasks." To Do: ". $Tasks[Title]."<br>";
			$taskTime[$userID][] = $Tasks[Start_Time] ;
			$taskID[$userID][]= $Tasks[ID];
		  }
		break;
		//Quarterly
		case "6":
		  $dayOfMonth = strtotime($searchDate) ;
		  $orgDate = strtotime($Tasks[Due_Date]) ;
		  
		  list($taskYear,$taskMonth,$taskDay) = explode("-", $Tasks[Due_Date]);
		  
		  $numMonth = floor(($dayOfMonth-$orgDate)/2628000)+1 ;
		  if($numMonth%3 == "0"){
			$nextQ = mktime(0,0,0,($taskMonth+$numMonth),$taskDay,$taskYear) ;
		  }
  
		  if(($Tasks[Due_Date] <= $searchDate) && ($Tasks[End_Date] >= $searchDate) && ($nextQ == $dayOfMonth) && (checkAlerts($Tasks[Email_Notif],date("H:i",strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset, $timezone_code) > " ")){
			$showDateTask = date("l M d, Y",strtotime((checkAlerts($Tasks[Email_Notif],date('H:i',strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset,$timezone_code))));
			$Display[$userID][] = $displayStartTasks." - ".$displayEndTasks." To Do: ". $Tasks[Title]."<br>";
			$taskTime[$userID][] = $Tasks[Start_Time] ;
			$taskID[$userID][]= $Tasks[ID];
		  }
		break;
		// Yearly
		case "7":
		  $dayOfYear = strtotime($searchDate) ;
		  $orgDate = strtotime($Tasks[Due_Date]) ;
		  
		  list($taskYear,$taskMonth,$taskDay) = explode("-", $Tasks[Due_Date]);
		  
		  $numYear = floor(($dayOfYear-$orgDate)/31536000) ;
		  $nextY = mktime(0,0,0,($taskMonth+1),$taskDay,($taskYear+$numYear)) ;
  
		  if(($Tasks[Due_Date] <= $searchDate) && ($Tasks[End_Date] >= $searchDate) && ($nextY == $dayOfYear) && (checkAlerts($Tasks[Email_Notif],date("H:i",strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset, $timezone_code) > " ")){
			$showDateTask = date("l M d, Y",strtotime((checkAlerts($Tasks[Email_Notif],date('H:i',strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset,$timezone_code))));
			$Display[$userID][] = $displayStartTasks." - ".$displayEndTasks." To Do: ". $Tasks[Title]."<br>";
			$taskTime[$userID][] = $Tasks[Start_Time] ;
			$taskID[$userID][]= $Tasks[ID];
		  }
		break;
		
		default:
		  if(($Tasks[Due_Date] == $searchDate) && (checkAlerts($Tasks[Email_Notif],date("H:i",strtotime($Tasks[Start_Time])),$timezoneid,$gmt_offset,$dst_offset, $timezone_code) == "1")){
			$Display[$userID][] = $displayStartTasks." - ".$displayEndTasks." To Do: ". $Tasks[Title]."<br>";
			$taskTime[$userID][] = $Tasks[Start_Time] ;
			$taskID[$userID][]= $Tasks[ID];
		  }
		break;
	 }
  }
  
  
  //print_r($Display);
  if(!empty($Display)){
	foreach ($Display as $userID => $dEvents){
		
	  // get user info
	  $sql = "SELECT Email,First_Name,Last_Name FROM users WHERE ID = '$userID'" ;  
	  $sth = mysql_query($sql) or die(mysql_error());
	  $UserInfo = mysql_fetch_array ($sth) ;
	  
	  $to = $UserInfo[Email];
	  $from = "info@yadahome.com";
	  $toName = $UserInfo[First_Name];
	  include "emailTerms.php"; 
	  $subject = "YadaHome Reminder!"; 
	  
	  //begin  HTML message 
	  $message = "
	  <html> 
	  <body><center><table width='700' ><tr><td align=left><a href='http://yadahome.com/'><img src='http://yadahome.com/images/EmailLogo.jpg' border='0'></a><br><br>
	  <Table width='100%'><Tr><td bgcolor='#350200'></td><font size='1'>&nbsp;</font></tr></table>  
	  <br>
	  <div style='padding: 10px'><font size=2 face=arial>
	  YadaHome Reminder!<br><br>
	  <br><br>";
	  
	  foreach ($dEvents as $key => $dTasks){
		//echo " id=".$taskID[$userID][$key]." eid=".$eventID[$userID][$key]." key= ".$key." ".	$dTasks ;
		
		if(preg_match("/To Do:/",$dTasks)){ 
		  $sqlUp = "Update todo_list Set Alert_Send = 'Y' Where ID = '".$taskID[$userID][$key]."' limit 1";
		  $resultUp = mysql_query($sqlUp) or die(mysql_error());
	   }
		if(preg_match("/Event:/",$dTasks)){ 
		  $sqlUp = "Update user_events Set Alert_Send = 'Y' Where ID = '".$taskID[$userID][$key]."' limit 1";
		  $resultUp = mysql_query($sqlUp) or die(mysql_error());
	   }
	  $message .= "$dTasks"; 
	  //echo $dTasks;  
	  }
	  
	  $message .= "<br><br>Thanks! <br>
	  YadaHome.com, LLC <br>
	  </font>
	  <br><img src='http://yadahome.com/images/emailBar.jpg'> 
	  ";
	  
	  
	  $message .= "$emailTerms
	  </div>	  
	  </td></tr><table></center>
	  </body> 
	  </html> 
	  ";
	  //end of message 
	  $headers  = "From: $from\r\n"; 
	  $headers .= "Content-type: text/html\r\n"; 
	  
	  
	  //check if opted out
	  $lookupEmail = $to;
	  include "doNotSend.php";
	  if( $OkToSendEmail == "Y"){
	     mail($to, $subject, $message, $headers); 
		 
		// $to = "jeff@emaginewc.com";
//		 mail($to, $subject, $message, $headers); 
	  }
	}
  }
  
    

//}
	
	
	
	
	
	
	  
?>