include_once "includes/dbConnNew.php";
include_once "includes/loggedOn.php";
//error_reporting(1);
import_request_variables("gp", "");
if($_REQUEST["theAction"] == "postMsg"){
$dateSent=date("Y-m-d") ;
$timeSent = date("H:i") ;
$yada = ereg_replace("'", "´",$_REQUEST["yada"]);
$sqlInsert = "INSERT INTO yadayada (From_ID, To_ID, Date_Sent, Time_Sent, The_Text)" ;
$sqlInsert = $sqlInsert . " VALUES ('" . $_SESSION["sessionUserID"] . "','" . $_SESSION["sessionUserID"] . "','$dateSent','$timeSent','$yada')" ;
$result2 = mysql_query($sqlInsert) or die(mysql_error());
$sent = "y" ;
}
if($id > " " && $del == "y"){
$sqlupdate = " Delete from yadayada where ID='$id' and To_ID ='" . $_SESSION["sessionUserID"] . "'";
$result2 = mysql_query($sqlupdate) or die(mysql_error());
$delete = "y" ;
}
if($_REQUEST["theAction"] != "update"){
$SelectStr = "SELECT DATE_FORMAT(Last_Logon, '%M %d, %Y') as lastLog, DATE_FORMAT(Anniversary, '%M %d, %Y') as Anniv, users.* from users where ID='" . $_SESSION["sessionUserID"] . "'";
$result = mysql_query($SelectStr)or die(mysql_error());
if($myrow=MySQL_fetch_array($result)){
$Anniversary = $myrow["Anniv"] ;
$dob = $myrow["Birth_Date"];
//calculate age
if($dob <> "0000-00-00"){
list($BirthYear,$BirthMonth,$BirthDay) = explode("-", $dob);
$YearDiff = date("Y") - $BirthYear;
$MonthDiff = date("m") - $BirthMonth;
$DayDiff = date("d") - $BirthDay;
if ($MonthDiff < "0"){
$YearDiff --;
} else if ($BirthMonth == date("m") && $DayDiff < "0"){
$YearDiff --;
}
$age = $YearDiff ;
} else {
$age = " " ;
}
if($myrow["meet_people"] == "Y"){
$displayDir = "Yes" ;
} else {
$displayDir = "No" ;
}
if($myrow["Gender"] == "m"){
$sex = "Male" ;
}
if($myrow["Gender"] == "f"){
$sex = "Female" ;
}
if($myrow[Time_Zone] > "0"){
$SelectStr2 = "SELECT * from timezone where timezoneid ='$myrow[Time_Zone]'";
$result2 = mysql_query($SelectStr2)or die(mysql_error());
$TimeZone=mysql_fetch_array($result2) ;
$zone = $TimeZone[Zone_Name] ;
} else {
$zone = "Not Set" ;
}
}
}
?>
YadaHome | Sharing Center
include 'beforeEndHead.php'; ?>
 |
 |
 |
 |
include "topSignIn.php"; ?> |
 |
include "nav-new.php" ;?>
 |
 |
| |
|
| |
|
|
$userid = $_SESSION["sessionUserID"] ;
$filename = "userPhotos/thumbnails/profile-$userid.jpg" ;
if ($myrow["Photo"] > " ") {
?>
" alt="=$myrow["First_Name"]?> =$myrow["Last_Name"]?>" class="profileImage" />
} else {?>
}?>
|
| |
| Age: |
=$age?> |
| Gender: |
=$sex?> |
| Location: |
= ucfirst($myrow["City"]) ?>, =strtoupper($myrow["State_Reside"])?> |
| Relationship: |
=ucfirst($myrow["Marital_Status"])?> |
| Anniversary: |
=$Anniversary?> |
| Occupation: |
=$myrow["Occupation"]?> |
| My Photo: |
$userid = $_SESSION["sessionUserID"] ;
$filename = "userPhotos/tiny/profile-$userid.jpg" ;
if ($myrow["Photo"] > " ") {
?>
" class="profileImage"/>
} else {?>
}?> |
| Edit |
| |
| Email: |
" class="profileLinks3">=$myrow["Email"]?> |
| Family User Name: |
=$myrow["FAMILY_USER_NAME"]?> |
| Family Password: |
•••••••• |
| Address: |
=$myrow["address"]?>
= ucfirst($myrow["City"]) ?>, =strtoupper($myrow["State_Reside"])?> =$myrow["Zip"]?> |
| Phone: |
=$myrow["phone"]?> |
| Site: |
" target="_blank" class="profileLinks3">=$myrow["webSite"]?> |
| Time Zone: |
=$zone?> |
| Hide my contact information: |
=$myrow["keep_private"]?> |
| Edit |
| |
| Schools: |
=$myrow["school1"]?>
=$myrow["school2"]?> |
| Interests: |
$i = 0 ;
$SelectStr2 = "SELECT * FROM interests where (User_ID = '" . $_SESSION["sessionUserID"] . "') order by Interest";
$result2 = mysql_query($SelectStr2) or die(mysql_error());
while($myrow2=MySQL_fetch_array($result2)){
if($i == "0"){
$interests = ucfirst($myrow2["Interest"]);
} else {
$interests = $interests . ", ". ucfirst($myrow2["Interest"]);
}
$i ++ ;
}
?>
=$interests?> |
| Moto: |
=$myrow["Bio"]?> |
| Kids: |
=$myrow["Number_Of_Children"]?> |
| Pets: |
=$myrow["num_pets"]?> |
| |
Edit |
| |
| =nl2br($myrow["about_me"])?> |
| Edit |
|
|
$SQL = "SELECT DATE_FORMAT(Date_Sent, '%c/%e/%y') as newDate,TIME_FORMAT(Time_Sent, '%l:%i %p') as newTime, yadayada.ID as MID,yadayada.* from yadayada where (To_ID = '" . $_SESSION["sessionUserID"] . "') ORDER BY yadayada.ID DESC";
$resultMsg = mysql_query($SQL) or die(mysql_error());
$msg_rows = mysql_num_rows($resultMsg);
while($myrowMsg=MySQL_fetch_array($resultMsg)){
$MID =$myrowMsg["MID"];
$The_Text =$myrowMsg["The_Text"];
$Date_Sent =$myrowMsg["newDate"];
$Time_Sent =$myrowMsg["newTime"];
$Mark_As_Read =$myrowMsg["Mark_As_Read"];
if($myrowMsg[From_ID] > "0"){
$SQL1 = "SELECT Last_Name,First_Name,ID from users where (ID = $myrowMsg[From_ID] )";
$result1= mysql_query($SQL1) or die(mysql_error());
$User=mysql_fetch_array($result1);
$First_Name =ucfirst($User["First_Name"]);
$Last_Name =substr(ucfirst($User["Last_Name"]),0,1);
$sender = $First_Name." ". $Last_Name .". says" ;
} else {
if($myrowMsg[admin_title] > " "){
$sender = $myrowMsg[admin_title] ;
} else {
$sender = "Tip of the week" ;
}
}
?>
| =$sender?> |
=$Date_Sent?> =$Time_Sent?> |
| =nl2br($The_Text)?> |
| Delete |
}?>
if($msg_rows == "0"){?>
| no Yada Yada messages |
}?>
|
|
|
 |
|
|
 |
| include "bottomLocalSearch.php"; ?> |
|
|
include('savingsCenter.php') ?>
include "googAna.php"; ?>