include "includes/dbConnNew.php"; include_once "includes/loggedOn.php"; import_request_variables("gp", ""); if($theAction == "update" && isset($_SESSION["sessionUserID"])){ $photo_checked = $_POST['Photo']; $photo_count = count($_POST['Photo']); $contact_checked = $_POST['Contact']; $contact_count = count($_POST['Contact']); $grocery_checked = $_POST['Grocery']; $grocery_count = count($_POST['Grocery']); $blog_checked = $_POST['Blog']; $blog_count = count($_POST['Blog']); $cook_checked = $_POST['Cook']; $cook_count = count($_POST['Cook']); $ToDo_checked = $_POST['ToDo']; $ToDo_count = count($_POST['ToDo']); $Profile_checked = $_POST['Profile']; $Profile_count = count($_POST['Profile']); $display = $_POST['display']; if ($display <> "Y"){ $display = "N"; } $sql1 = "update users set meet_people = '$display' where ID='" . $_SESSION["sessionUserID"] . "'"; $result = mysql_query($sql1) or die(mysql_error()); $SQL = "select privacy.*,users.ID,users.First_Name, users.Last_Name from privacy,users where (privacy.deleted = 0) AND ((privacy.friend_id = users.ID) and user_id = '" . $_SESSION["sessionUserID"] . "')"; $result = mysql_query($SQL) or die(mysql_error()); while($myrow=MySQL_fetch_array($result)){ $friend_id = $myrow["friend_id"] ; $grocery = $myrow["grocery"] ; if($photo_checked[$friend_id] > " "){$friend_photo = "Y" ;} else {$friend_photo = "N" ;} if($contact_checked[$friend_id] > " "){$friend_contact = "Y" ;} else {$friend_contact = "N" ;} if($blog_checked[$friend_id] > " "){$friend_blog = "Y" ;} else {$friend_blog = "N" ;} if($cook_checked[$friend_id] > " "){$friend_cook = "Y" ;} else {$friend_cook = "N" ;} if($ToDo_checked[$friend_id] > " "){$friend_ToDo = "Y" ;} else {$friend_ToDo = "N" ;} if($Profile_checked[$friend_id] > " "){$friend_Profile = "Y" ;} else {$friend_Profile = "N" ;} if($grocery_checked[$friend_id] > " " && $grocery == "Y"){$friend_grocery = "Y" ;} if($grocery_checked[$friend_id] > " " && $grocery == "W"){$friend_grocery = "W" ;} if($grocery_checked[$friend_id] > " " && $grocery != "W" && $grocery != "Y"){$friend_grocery = "W" ;} if($grocery_checked[$friend_id] < " " && $grocery == "W"){$friend_grocery = "N" ;} if($grocery_checked[$friend_id] < " "){$friend_grocery = "N" ;} $SQL = "UPDATE privacy SET show_profile_page = '$friend_Profile', photo = '$friend_photo',blog = '$friend_blog' ,cookbook = '$friend_cook' , contacts = '$friend_contact' ,grocery = '$friend_grocery' WHERE friend_id ='$friend_id' and user_id = '" . $_SESSION["sessionUserID"]. "'"; $result1 = mysql_query($SQL); /*, ToDo = '$friend_ToDo'*/ if(($grocery_checked[$friend_id] < " " && $grocery == "Y") || ($grocery_checked[$friend_id] < " " && $grocery == "W")){ $SQL2 = "UPDATE privacy SET grocery = 'N' WHERE user_id ='$friend_id' and friend_id = '" . $_SESSION["sessionUserID"]. "'"; $result1 = mysql_query($SQL2) or die(mysql_error()); $message ="I just removed you from my Grocery List." ; $dateSent=date("Y-m-d") ; $timeSent = date("H:i") ; $msgTitle = "YadaHome Network" ; $sqlInsert = "INSERT INTO messages (From_ID, To_ID, Date_Sent, Time_Sent, Mark_As_Read, The_Text,msg_title)" ; $sqlInsert = $sqlInsert . " VALUES ('" . $_SESSION["sessionUserID"] . "','$friend_id','$dateSent','$timeSent','N','$message','$msgTitle')" ; $result2 = mysql_query($sqlInsert) or die(mysql_error()); $replyID = mysql_insert_id() ; $sqlupdate = "Update messages Set Reply_ID='$replyID' where ID='$replyID'"; $result2 = mysql_query($sqlupdate) or die(mysql_error()); } if($friend_grocery == "W" && $grocery != "W"){ $dateSent=date("Y-m-d") ; $timeSent = date("H:i") ; $sqlInsert = "INSERT INTO messages (From_ID, To_ID, Date_Sent, Time_Sent, Mark_As_Read, The_Text)" ; $sqlInsert = $sqlInsert . " VALUES ('" . $_SESSION["sessionUserID"] . "','$friend_id','$dateSent','$timeSent','N','001')" ; $result2 = mysql_query($sqlInsert) or die(mysql_error()); $lastInsert=mysql_insert_id() ; $msgTitle = "YadaHome Network" ; $message ="I would like to share my Grocery List with you. Please click here to accept or reject this invitation." ; $SQL3 = "UPDATE messages SET msg_title = '$msgTitle', Reply_ID='$lastInsert', The_Text = '$message' WHERE To_ID ='$friend_id' and ID = '$lastInsert' and The_Text='001' and From_ID = '" . $_SESSION["sessionUserID"]. "'"; $result2 = mysql_query($SQL3) or die(mysql_error()); $SQL = "UPDATE privacy SET grocery = 'W' WHERE user_id ='$friend_id' and friend_id= '" . $_SESSION["sessionUserID"]. "'"; $result2 = mysql_query($SQL) or die(mysql_error()); } $msg = "y" ; } } else { $SelectStr = "SELECT meet_people from users where ID='" . $_SESSION["sessionUserID"] . "'"; $result = mysql_query($SelectStr)or die(mysql_error()); if($myrowM=mysql_fetch_array($result)){ $meet_people = $myrowM["meet_people"] ; } } ?>
|
|||||||||||||||
|
|||||||||||||||
|
|||||||||||||||