include_once "includes/dbConnNew.php"; //see if a cookie exists wit username and password if( !$_SESSION['loggedIn'] ){ if ( ( $_COOKIE['cookieEmail'] > " ") && ( $_COOKIE['cookiePassword'] > " ") ){ header("location: signInToFridge.php"); exit; } } include_once "includes/loggedOnFridge.php"; //$_SESSION["sessionPremInd"] = "Y"; if( $_REQUEST["slider"] == "noshow"){ $_SESSION["stillShowInviteGlide "] = "n"; } if( $_REQUEST["slider"] == "notagain"){ $_SESSION["stillShowInviteGlide "] = "n"; $SQLSlider = "UPDATE users SET show_invite_slider = 'N' WHERE ID = '" . $_SESSION["sessionUserID"]. "'"; $resultSlider = mysql_query($SQLSlider) or die(mysql_error()); } //override to disable the slider //$_SESSION["stillShowInviteGlide "] = "n"; if( $_REQUEST['meet']){ $SQL2 = "UPDATE users SET meet_people = '" . $_REQUEST['meet'] . "' WHERE ID = '" . $_SESSION["sessionUserID"]. "'"; $result2 = mysql_query($SQL2) or die(mysql_error()); $_SESSION["meet_people"] = $_REQUEST['meet']; if( $_REQUEST['meet'] == "Y"){ $SQL1 = "UPDATE privacy SET show_profile_page = 'Y' WHERE user_id = '" . $_SESSION["sessionUserID"]. "'"; $result1 = mysql_query($SQL1) or die(mysql_error()); } } //update the users pet if( $_REQUEST['Addpet'] > " " ){ $SQL2p = "UPDATE users SET Pet = '" . $_REQUEST['Addpet'] . "' WHERE ID = '" . $_SESSION["sessionUserID"]. "'"; $result2p = mysql_query($SQL2p) or die(mysql_error()); } $pet="dog"; //$pet="kitten"; //$pet="fish"; //$pet="rabbit"; // get avatar and pet $SQLUser = "SELECT Photo, Pet from users where (ID = '" . $_SESSION["sessionUserID"] . "')"; $resultUser = mysql_query($SQLUser) or die(mysql_error()); if($User=mysql_fetch_array($resultUser)){ if($User["Photo"] > " "){ $UserAvatar = $User["Photo"]; } else { $UserAvatar = "add-avatar.jpg"; } if($User["Pet"] > " "){ $pet = $User["Pet"]; } list($width, $height, $type, $attr) = getimagesize("userPhotos/thumbnails/$UserAvatar"); } //get number of messages $msgCount = 0; $SQL = "SELECT distinct (Reply_ID),Mark_As_Read from messages where (To_ID = '" . $_SESSION["sessionUserID"] . "') and (messages.Shpw_Msg != 'N') GROUP BY Reply_ID"; $resultMsg = mysql_query($SQL) or die(mysql_error()); while($myrowMsg=mysql_fetch_array($resultMsg)){ $Mark_As_Read = $myrowMsg["Mark_As_Read"]; if($Mark_As_Read <> "Y"){ $msgCount = $msgCount + 1 ; } } $compCount = 0; $SQL = "SELECT count(*) as thecount from compliments where (To_User_ID = '" . $_SESSION["sessionUserID"] . "')"; $resultCom = mysql_query($SQL) or die(mysql_error()); if($myrowCom=MySQL_fetch_array($resultCom)){ $compCount = $myrowCom["thecount"]; } //end of get messages //now determine how many flowers the user sees on their fridge //they get a min of 1 and a max of 12 //they get a flower for every person that accepted an invitation to join Yadahome $numFlowers = 1; $SelectStrFF = "select * from invitations WHERE (USER_ID = '" . $_SESSION["sessionUserID"] . "' ) AND (Accepted = 'Y') AND (is_Member <> 'Y') "; $resultFF = mysql_query($SelectStrFF) or die(mysql_error()); $numFlowers = mysql_num_rows($resultFF); if($numFlowers < 1){ $numFlowers = 1; } if($numFlowers > 12){ $numFlowers = 12; } //end of get number of friends $bgPic1 = "images/addPhotos2.jpg"; $bgPic2 = "images/addPhotos1.jpg"; $bgPic3 = "images/addPhotos1.jpg"; $bgPic4 = "images/addPhotos2.jpg"; //get tiny pics for myphotos $SelectStr = "SELECT * from photos where User_ID = '" . $_SESSION["sessionUserID"] . "' ORDER BY RAND() limit 4 "; $result = mysql_query($SelectStr) or die(mysql_error()); $counter = 0; while($myrow=MySQL_fetch_array($result)){ $counter++; if($counter==1){$bgPic1 = "userPhotos/tiny/" . $myrow["Image"]; } if($counter==2){$bgPic2 = "userPhotos/tiny/" . $myrow["Image"]; } if($counter==3){$bgPic3 = "userPhotos/tiny/" . $myrow["Image"]; } if($counter==4){$bgPic4 = "userPhotos/tiny/" . $myrow["Image"]; } } //Calendar $date = date("Y-m-d") ; $thisday = date("d",mktime((date("h")+3), 0, 0, date("m"), date("d"), date("Y"))); //$thisday = date('d'); $thismonth = date('m'); $thisyear = date('Y'); $lastDay = strftime("%d", mktime(0, 0, 0, ($thismonth + 1), 0, $thisyear)); $day=date("d", mktime(0, 0, 0, 04, $lastDay, 2008)); $firstDayWeek=date("D", mktime(0, 0, 0, $thismonth, 01, $thisyear)); $lastDayWeek=date("D", mktime(0, 0, 0, $thismonth, $lastDay, $thisyear)); $toMonth =date('F'); $today = $thisday ; if($today == 01) {$today="1";} if($today == 02) {$today="2";} if($today == 03) {$today="3";} if($today == 04) {$today="4";} if($today == 05) {$today="5";} if($today == 06) {$today="6";} if($today == 07) {$today="7";} if($today == 08) {$today="8";} if($today == 09) {$today="9";} if($firstDayWeek == "Sun"){ for ($i=1; $i<=$lastDay; $i++) { $D[$i]= $i ; } } if($firstDayWeek == "Mon"){ for ($i=1; $i<=$lastDay+1; $i++) { $D[$i+1]= $i; } $k = 1 ; } if($firstDayWeek == "Tue"){ for ($i=1; $i<=$lastDay; $i++) { $D[$i+2]= $i; } $k = 2 ; } if($firstDayWeek == "Wed"){ for ($i=1; $i<=$lastDay; $i++) { $D[$i+3]= $i; } $k = 3 ; } if($firstDayWeek == "Thu"){ for ($i=1; $i<=$lastDay; $i++) { $D[$i+4]= $i; } $k = 4 ; } if($firstDayWeek == "Fri"){ for ($i=1; $i<=$lastDay; $i++) { $D[$i+5]= $i; } $k = 5 ; } if($firstDayWeek == "Sat"){ for ($i=1; $i<=$lastDay; $i++) { $D[$i+6]= $i; } $k = 6 ; } $sql = "select MONTH(Event_Date) as cmonth, user_events.* from user_events where (user_events.deleted = 0) AND (User_ID = '" . $_SESSION["sessionUserID"] . "' and MONTH(Event_Date)='$thismonth')"; $result1 = mysql_query($sql) or die(mysql_error()); while($myrow1=MySQL_fetch_array($result1)){ $event=$myrow1["Event_Date"] ; $eventDays =date("d",strtotime($event)); if($eventDays == 01) {$eventDays="1";} if($eventDays == 02) {$eventDays="2";} if($eventDays == 03) {$eventDays="3";} if($eventDays == 04) {$eventDays="4";} if($eventDays == 05) {$eventDays="5";} if($eventDays == 06) {$eventDays="6";} if($eventDays == 07) {$eventDays="7";} if($eventDays == 08) {$eventDays="8";} if($eventDays == 09) {$eventDays="9";} $eventDay=$eventDays + $k ; $E[$eventDay]= $eventDays; } ?>
![]() |