$rsPropList = RunQuery($sSQL);
$sSQL = "SELECT * FROM groupprop_" . $iGroupID . " WHERE per_ID = " . $per_ID;
$rsPersonProps = RunQuery($sSQL);
$aPersonProps = mysql_fetch_array($rsPersonProps, MYSQL_BOTH);
while ($aProps = mysql_fetch_array($rsPropList)) {
extract($aProps);
$currentData = trim($aPersonProps[$prop_Field]);
if (strlen($currentData) > 0) {
// only create the properties table if it's actually going to be used
if ($firstRow) {
echo "<tr><td colspan=\"3\"><table width=\"100%\"><tr><td width=\"15%\"></td><td><table width=\"90%\" cellspacing=\"0\">";
echo "<tr class=\"TinyTableHeader\"><td>" . gettext("Property") . "</td><td>" . gettext("Value") . "</td></tr>";
$firstRow = false;
}
$sRowClass = AlternateRowStyle($sRowClass);
if ($type_ID == 11) {
$prop_Special = $sCountry;
}
echo "<tr class=\"{$sRowClass}\"><td>" . $prop_Name . "</td><td>" . displayCustomField($type_ID, $currentData, $prop_Special) . "</td></tr>";
}
}
if (!$firstRow) {
echo "</table></td></tr></table></td></tr>";
}
}
}
?>
</table>
</body>
</html>
}
if (isset($_POST['CellPhoneEnable']) && strlen($sCellPhone)) {
$TempStr = ExpandPhoneNumber($sCellPhone, $sDefaultCountry, $bWierd);
$OutStr .= " " . gettext("Cell") . ": " . $TempStr . "\n";
}
if (isset($_POST['EmailEnable']) && strlen($sEmail)) {
$OutStr .= " " . gettext("Email") . ": " . $sEmail . "\n";
}
if (isset($_POST['OtherEmailEnable']) && strlen($aRow['per_WorkEmail'])) {
$OutStr .= " " . gettext("Other Email") . ": " . ($aRow['per_WorkEmail'] .= "\n");
}
if ($bHasProps) {
while ($aPropRow = mysql_fetch_array($rsProps)) {
if (isset($_POST[$aPropRow['prop_Field'] . 'enable'])) {
$currentData = trim($aRow[$aPropRow['prop_Field']]);
$OutStr .= $aPropRow['prop_Name'] . ": " . displayCustomField($aPropRow['type_ID'], $currentData, $aPropRow['prop_Special']) . "\n";
}
}
mysql_data_seek($rsProps, 0);
}
// Count the number of lines in the output string
$numlines = 1;
$offset = 0;
while ($result = strpos($OutStr, "\n", $offset)) {
$offset = $result + 1;
$numlines++;
}
//if ($numlines > 1)
//{
/* if (strtoupper($sLastLetter) != strtoupper(substr($pdf->sFamily,0,1)))
{
</td>
</tr>
<?php
}
?>
<?php
// Display the right-side custom fields
while ($Row = mysql_fetch_array($rsRightFamCustomFields)) {
extract($Row);
if ($aSecurityType[$fam_custom_FieldSec] == 'bAll' or $_SESSION[$aSecurityType[$fam_custom_FieldSec]]) {
$currentData = trim($aFamCustomData[$fam_custom_Field]);
if ($type_ID == 11) {
$fam_custom_Special = $sPhoneCountry;
}
echo "<tr><td class=\"TinyLabelColumn\">" . $fam_custom_Name . "</td>";
echo "<td class=\"TinyTextColumn\">" . displayCustomField($type_ID, $currentData, $fam_custom_Special) . "</td></tr>";
}
}
?>
</table>
</td>
</tr>
</table>
</div>
<BR>
<b><?php
echo gettext("Assigned Properties:");
?>
</b>
<?php
$sAssignedProperties = ",";
function sGetCustomString($rsCustomFields, $aRow)
{
$numCustomFields = mysql_num_rows($rsCustomFields);
if ($numCustomFields > 0) {
extract($aRow);
$sSQL = "SELECT * FROM person_custom WHERE per_ID = " . $per_ID;
$rsCustomData = RunQuery($sSQL);
$aCustomData = mysql_fetch_array($rsCustomData, MYSQL_BOTH);
$numCustomData = mysql_num_rows($rsCustomData);
mysql_data_seek($rsCustomFields, 0);
$OutStr = "";
while ($rowCustomField = mysql_fetch_array($rsCustomFields, MYSQL_BOTH)) {
extract($rowCustomField);
$sCustom = "bCustom" . $custom_Order;
if ($this->_Custom[$custom_Order]) {
$currentFieldData = displayCustomField($type_ID, $aCustomData[$custom_Field], $custom_Special);
// $currentFieldData = trim($aCustomData[$custom_Field]);
if ($currentFieldData != "") {
$OutStr .= " " . $custom_Name . ": " . ($currentFieldData .= "\n");
}
}
}
return $OutStr;
} else {
return "";
}
}
<span><?php
echo $mailchimp->isEmailInMailChimp($fam_Email);
?>
</span></a></li>
<?php
}
}
// Display the left-side custom fields
while ($Row = mysql_fetch_array($rsFamCustomFields)) {
extract($Row);
if ($aSecurityType[$fam_custom_FieldSec] == 'bAll' or $_SESSION[$aSecurityType[$fam_custom_FieldSec]]) {
$currentData = trim($aFamCustomData[$fam_custom_Field]);
if ($type_ID == 11) {
$fam_custom_Special = $sPhoneCountry;
}
echo "<li><i class=\"fa-li glyphicon glyphicon-tag\"></i>" . $fam_custom_Name . ": <span>" . displayCustomField($type_ID, $currentData, $fam_custom_Special) . "</span></li>";
}
}
?>
</ul>
</div>
</div>
</div>
<div class="col-lg-9 col-md-8 col-sm-8">
<div class="row">
<div class="col-lg-12 col-md-8 col-sm-8">
<div class="box box-solid">
<div class="box-body clearfix">
<table width="100%">
<tr>
<td width="50%">
}
}
if ($bUsedCustomFields && $sFormat == "rollup") {
$sSQLFamCustom = "SELECT * FROM family_custom WHERE fam_ID = " . $per_fam_ID;
$rsFamCustomData = RunQuery($sSQLFamCustom);
$aFamCustomData = mysql_fetch_array($rsFamCustomData);
if (@mysql_num_rows($rsFamCustomData) > 0) {
// Write custom field data
mysql_data_seek($rsFamCustomFields, 0);
while ($aFamCustomField = mysql_fetch_array($rsFamCustomFields)) {
$fam_custom_Field = "";
$fam_custom_Special = "";
$type_ID = "";
extract($aFamCustomField);
if (isset($_POST["{$fam_custom_Field}"])) {
if ($type_ID == 11) {
$fam_custom_Special = $sCountry;
}
$sString .= "\",\"" . displayCustomField($type_ID, trim($aFamCustomData[$fam_custom_Field]), $fam_custom_Special);
}
}
}
}
$sString .= "\"\n";
echo $sString;
}
}
}
}
// Turn OFF output buffering
ob_end_flush();
// Get the special properties for this group
$sSQL = "SELECT groupprop_master.* FROM groupprop_master WHERE grp_ID = " . $grp_ID . " AND prop_PersonDisplay = 'true' ORDER BY prop_ID";
$rsPropList = RunQuery($sSQL);
$sSQL = "SELECT * FROM groupprop_" . $grp_ID . " WHERE per_ID = " . $iPersonID;
$rsPersonProps = RunQuery($sSQL);
$aPersonProps = mysql_fetch_array($rsPersonProps, MYSQL_BOTH);
echo "<div class=\"box-body\">";
while ($aProps = mysql_fetch_array($rsPropList)) {
extract($aProps);
$currentData = trim($aPersonProps[$prop_Field]);
if (strlen($currentData) > 0) {
$sRowClass = AlternateRowStyle($sRowClass);
if ($type_ID == 11) {
$prop_Special = $sPhoneCountry;
}
echo "<strong>" . $prop_Name . "</strong>: " . displayCustomField($type_ID, $currentData, $prop_Special) . "<br/>";
}
}
echo "</div><!-- /.box-body -->";
}
?>
<div class="box-footer">
<code>
<?php
if ($_SESSION['bManageGroups']) {
?>
<a href="GroupView.php?GroupID=<?php
echo $grp_ID;
?>
" class="btn btn-default" role="button"><i class="glyphicon glyphicon-list"></i></a>
<div class="btn-group">
