= '2010-02-05 12:32:32') union SELECT user_id, friend_id FROM share_events WHERE (EMAILED_IND = 'N') AND (deleted = 0) and (time >= '2010-02-05 12:32:32') "; $sth = mysql_query($sql) or die(mysql_error()); while($myrow1 = mysql_fetch_array ($sth)) { //now get the name of the person who shared the event/s $SelectStr = "SELECT * from users where ID='" . $myrow1[user_id] . "'"; //echo $SelectStr . "
"; $results = mysql_query($SelectStr) or die(mysql_error()); if($myrow = mysql_fetch_array ($results)){ $sendersName = $myrow[First_Name]; } //end of got person who shared the event //now get the email address of the person who we are sending the email to $SelectStr = "SELECT * from users where ID='" . $myrow1[friend_id] . "'"; //echo $SelectStr . "
"; $results = mysql_query($SelectStr) or die(mysql_error()); if($myrow = mysql_fetch_array ($results)){ $friendsEmail = $myrow[Email]; } //end of got person who shared the event //echo $sendersName; //echo "
" . $friendsEmail . "

---

"; //now get the event/s details of the event being shared $counter=0; $SelectStr = "SELECT user_events.* from share_events, user_events where (share_events.EMAILED_IND = 'N') AND (share_events.deleted = 0) and (share_events.time >= '2010-02-04 10:47:53') and (share_events.user_id = $myrow1[user_id]) and (share_events.friend_id = $myrow1[friend_id] ) and (share_events.event_id = user_events.ID) order by Event_Date, Start_Time, Start_Minute "; $results = mysql_query($SelectStr) or die(mysql_error()); $content = ""; while($myrow = mysql_fetch_array ($results)){ $counter++; $Event_Name = $myrow[Event_Name]; $Event_Date = substr( $myrow[Event_Date],5,2) . "/" . substr( $myrow[Event_Date],8,2) . "/" . substr( $myrow[Event_Date],0,4) ; $content .= "Date: $Event_Date
"; $content .= "Event: $Event_Name
"; if($myrow[Description] > " "){ $content .= "Details: $myrow[Description]
"; } //if($myrow[End_Date] > " "){ // $more .= "End Date: $myrow[End_Date]
"; //} if($myrow[Start_Time] > "0"){ $startTime = date("g:ia",mktime($myrow[Start_Time],$myrow[Start_Minute],0,1,5,2009)); $content .= "Start Time: $startTime
"; //$content .= "Start Time: $myrow[Start_Time]:$myrow[Start_Minute]
"; } if($myrow[End_Time] > "0"){ $endTime = date("g:ia",mktime($myrow[End_Time],$myrow[End_Minute],0,1,5,2009)); $content .= "End Time: $endTime
"; //$content .= "End Time: $myrow[End_Minute]:$myrow[End_Minute]
"; } $content .= "

---

"; } //end of get event details $lookupEmail = $friendsEmail; include "doNotSend.php"; if( $OkToSendEmail == "Y"){ //SEND EMAIL. $to = $friendsEmail; //$toName = ucfirst($invites[First_Name]); $from = "info@YadaHome.com"; $fromName = $sendersName; include "emailTerms.php"; if($counter > 1){ $subject = "YadaHome.com: $counter Events Have Been Added To Your Calendar"; $eventsNumberPhrase = " $counter events "; }else{ $subject = "YadaHome.com: An Event Has Been Added To Your Calendar"; $eventsNumberPhrase = " an event "; } $message = "

$fromName has added $eventsNumberPhrase to your calendar: $content

$emailTerms

"; //end of message $headers = "From: $from <$from>\r\n"; $headers .="Reply-To: $from \r\n"; $headers .= "Content-type: text/html\r\n"; // now lets send the email. mail($to, $subject, $message, $headers); //echo $message; //now mark the share record as being emailed $sql2 = "update share_events set EMAILED_IND = 'Y' where (user_id = $myrow1[user_id]) and (friend_id = $myrow1[friend_id] )"; $result2 = mysql_query($sql2) or die(mysql_error()); } } //echo "done"; ?>