$sSQL = "SELECT a.*, family_fam.*, cls.lst_OptionName AS sClassName, fmr.lst_OptionName AS sFamRole, b.per_FirstName AS EnteredFirstName,

b.Per_LastName AS EnteredLastName, c.per_FirstName AS EditedFirstName, c.per_LastName AS EditedLastName

FROM person_per a

LEFT JOIN family_fam ON a.per_fam_ID = family_fam.fam_ID

LEFT JOIN list_lst cls ON a.per_cls_ID = cls.lst_OptionID AND cls.lst_ID = 1

LEFT JOIN list_lst fmr ON a.per_fmr_ID = fmr.lst_OptionID AND fmr.lst_ID = 2

LEFT JOIN person_per b ON a.per_EnteredBy = b.per_ID

LEFT JOIN person_per c ON a.per_EditedBy = c.per_ID

WHERE a.per_ID = " . $iPersonID;

$rsPerson = RunQuery($sSQL);

extract(mysql_fetch_array($rsPerson));

// Get the lists of custom person fields

$sSQL = "SELECT person_custom_master.* FROM person_custom_master

WHERE custom_Side = 'left' ORDER BY custom_Order";

$rsLeftCustomFields = RunQuery($sSQL);

$sSQL = "SELECT person_custom_master.* FROM person_custom_master

WHERE custom_Side = 'right' ORDER BY custom_Order";

$rsRightCustomFields = RunQuery($sSQL);

// Get the custom field data for this person.

$sSQL = "SELECT * FROM person_custom WHERE per_ID = " . $iPersonID;

$rsCustomData = RunQuery($sSQL);

$aCustomData = mysql_fetch_array($rsCustomData, MYSQL_BOTH);

// Get the notes for this person

$sSQL = "SELECT nte_Private, nte_ID, nte_Text, nte_DateEntered, nte_EnteredBy, nte_DateLastEdited, nte_EditedBy, a.per_FirstName AS EnteredFirstName, a.Per_LastName AS EnteredLastName, b.per_FirstName AS EditedFirstName, b.per_LastName AS EditedLastName ";

$sSQL .= "FROM note_nte ";

$sSQL .= "LEFT JOIN person_per a ON nte_EnteredBy = a.per_ID ";

$sSQL .= "LEFT JOIN person_per b ON nte_EditedBy = b.per_ID ";

$sSQL .= "WHERE nte_per_ID = " . $iPersonID;

// Admins should see all notes, private or not. Otherwise, only get notes marked non-private or private to the current user.

if (!$_SESSION['bAdmin'])

$sSQL .= " AND (nte_Private = 0 OR nte_Private = " . $_SESSION['iUserID'] . ")";

$rsNotes = RunQuery($sSQL);

echo "<font size=\"4\"><b>";

echo FormatFullName($per_Title, $per_FirstName, $per_MiddleName, $per_LastName, $per_Suffix, 0);

echo "</font></b><br>";

if ($fam_ID != "") {

echo "<font size=\"2\">(";

if ($sFamRole != "") { echo $sFamRole; } else { echo gettext("Member"); }

echo gettext(" of the") . " <a href=\"FamilyView.php?FamilyID=" . $fam_ID . "\">" . $fam_Name . "</a>" . gettext(" family)") . "</font><br><br>";

}

else

echo gettext("(No assigned family)") . "<br><br>";

echo "<div class=\"TinyShadedBox\">";

echo "<font size=\"3\">";

if ($sAddress1 != "") { echo $sAddress1 . "<br>"; }

if ($sAddress2 != "") { echo $sAddress2 . "<br>"; }

if ($sCity != "") { echo $sCity . ", "; }

if ($sState != "") { echo $sState; }

if ($sZip != "") { echo " " . $sZip; }

if ($sCountry != "") {echo "<br>" . $sCountry; }

echo "</font>";

echo "</div>";

// Strip tags in case they were added for family inherited data

$sAddress1 = strip_tags($sAddress1);

$sCity = strip_tags($sCity);

$sState = strip_tags($sState);

$sCountry = strip_tags($sCountry);

// Upload photo

if ( isset($_POST["UploadPhoto"]) && ($_SESSION['bAddRecords'] || $bOkToEdit) ) {

if ($_FILES['Photo']['name'] == "") {

$PhotoError = gettext("No photo selected for uploading.");

} elseif ($_FILES['Photo']['type'] != "image/pjpeg" && $_FILES['Photo']['type'] != "image/jpeg") {

$PhotoError = gettext("Only jpeg photos can be uploaded.");

} else {

// Create the thumbnail used by PersonView

chmod ($_FILES['Photo']['tmp_name'], 0777);

$srcImage=imagecreatefromjpeg($_FILES['Photo']['tmp_name']);

$src_w=imageSX($srcImage);

$src_h=imageSY($srcImage);

// Calculate thumbnail's height and width (a "maxpect" algorithm)

$dst_max_w = 200;

$dst_max_h = 350;

if ($src_w > $dst_max_w) {

$thumb_w=$dst_max_w;

$thumb_h=$src_h*($dst_max_w/$src_w);

if ($thumb_h > $dst_max_h) {

$thumb_h = $dst_max_h;

$thumb_w = $src_w*($dst_max_h/$src_h);

}

}

elseif ($src_h > $dst_max_h) {

$thumb_h=$dst_max_h;

$thumb_w=$src_w*($dst_max_h/$src_h);

if ($thumb_w > $dst_max_w) {

$thumb_w = $dst_max_w;

$thumb_h = $src_h*($dst_max_w/$src_w);

}

}

else {

if ($src_w > $src_h) {

$thumb_w = $dst_max_w;

$thumb_h = $src_h*($dst_max_w/$src_w);

} elseif ($src_w < $src_h) {

$thumb_h = $dst_max_h;

$thumb_w = $src_w*($dst_max_h/$src_h);

} else {

if ($dst_max_w >= $dst_max_h) {

$thumb_w=$dst_max_h;

$thumb_h=$dst_max_h;

} else {

$thumb_w=$dst_max_w;

$thumb_h=$dst_max_w;

}

}

}

$dstImage=ImageCreateTrueColor($thumb_w,$thumb_h);

imagecopyresampled($dstImage,$srcImage,0,0,0,0,$thumb_w,$thumb_h,$src_w,$src_h);

imagejpeg($dstImage, "Images/Person/thumbnails/" . $iPersonID . ".jpg");

imagedestroy($dstImage);

imagedestroy($srcImage);

move_uploaded_file($_FILES['Photo']['tmp_name'], "Images/Person/" . $iPersonID . ".jpg");

}

} elseif (isset($_POST["DeletePhoto"]) && $_SESSION['bDeleteRecords']) {

unlink("Images/Person/" . $iPersonID . ".jpg");

unlink("Images/Person/thumbnails/" . $iPersonID . ".jpg");

}

// Display photo or upload from file

$photoFile = "Images/Person/thumbnails/" . $iPersonID . ".jpg";

if (file_exists($photoFile))

{

echo '<a target="_blank" href="Images/Person/' . $iPersonID . '.jpg">';

echo '<img border="1" src="'.$photoFile.'"></a>';

/* if ($bOkToEdit) {

echo '

<form method="post"

action="PersonView.php?PersonID=' . $iPersonID . '">

<br>

<input type="submit" class="icTinyButton"

value="' . gettext("Delete Photo") . '" name="DeletePhoto">

</form>';

}

*/

} else {

// Some old / M$ browsers can't handle PNG's correctly.

if ($bDefectiveBrowser)

echo '<img border="0" src="Images/NoPhoto.gif"><br><br><br>';

else

echo '<img border="0" src="Images/NoPhoto.png"><br><br><br>';

/*

if ($bOkToEdit) {

if (isset($PhotoError))

echo '<span style="color: red;">' . $PhotoError . '</span><br>';

echo '

<form method="post"

action="PersonView.php?PersonID=' . $iPersonID . '"

enctype="multipart/form-data">

<input class="icTinyButton" type="file" name="Photo">

<input type="submit" class="icTinyButton"

value="' . gettext("Upload Photo") . '" name="UploadPhoto">

</form>';

}

*/

}