function DeletePerson($iPersonID)
{
// Remove person from all groups they belonged to
$sSQL = "SELECT p2g2r_grp_ID FROM person2group2role_p2g2r WHERE p2g2r_per_ID = " . $iPersonID;
$rsAssignedGroups = RunQuery($sSQL);
while ($aRow = mysql_fetch_array($rsAssignedGroups)) {
extract($aRow);
RemoveFromGroup($iPersonID, $p2g2r_grp_ID);
}
// Remove custom field data
$sSQL = "DELETE FROM person_custom WHERE per_ID = " . $iPersonID;
RunQuery($sSQL);
// Remove note data
$sSQL = "DELETE FROM note_nte WHERE nte_per_ID = " . $iPersonID;
RunQuery($sSQL);
// Delete the Person record
$sSQL = "DELETE FROM person_per WHERE per_ID = " . $iPersonID;
RunQuery($sSQL);
// Remove person property data
$sSQL = "SELECT pro_ID FROM property_pro WHERE pro_Class='p'";
$rsProps = RunQuery($sSQL);
while ($aRow = mysql_fetch_row($rsProps)) {
$sSQL = "DELETE FROM record2property_r2p WHERE r2p_pro_ID = " . $aRow[0] . " AND r2p_record_ID = " . $iPersonID;
RunQuery($sSQL);
}
// Delete any User record
// $sSQL = "DELETE FROM user_usr WHERE usr_per_ID = " . $iPersonID;
// RunQuery($sSQL);
// Make sure person was not in the cart
RemoveFromPeopleCart($iPersonID);
}
$bPrintView = FilterInput($_GET["PrintView"], 'int');
}
if (!empty($_GET["ShowGSP"])) {
$bShowGSP = FilterInput($_GET["ShowGSP"], 'int');
} else {
$bShowGSP = 0;
}
if (isset($_GET["Number"])) {
$_SESSION['SearchLimit'] = FilterInput($_GET["Number"], 'int');
$uSQL = "UPDATE user_usr SET usr_SearchLimit = " . $_SESSION['SearchLimit'] . " WHERE usr_per_ID = " . $_SESSION['iUserID'];
$rsUser = RunQuery($uSQL);
}
//Are we removing someone?
if (isset($_GET["PersonToRemove"]) && $_SESSION['bManageGroups']) {
$iRemovedPerson = FilterInput($_GET["PersonToRemove"], 'int');
RemoveFromGroup($iRemovedPerson, $iGroupID);
Redirect("PersonView.php?PersonID=" . $iRemovedPerson);
}
// Get the group's role list ID
$sSQL = "SELECT grp_RoleListID,grp_hasSpecialProps FROM group_grp WHERE grp_ID =" . $iGroupID;
$aTemp = mysql_fetch_array(RunQuery($sSQL));
$iRoleListID = $aTemp[0];
$bHasSpecialProps = $aTemp[1] == "true";
// Get the roles
$sSQL = "SELECT * FROM list_lst WHERE lst_ID = " . $iRoleListID . " ORDER BY lst_OptionSequence";
$rsRoles = RunQuery($sSQL);
$numRoles = mysql_num_rows($rsRoles);
//Set Page Break
$iPerPage = $_SESSION['SearchLimit'];
// Main select query
$sSQL = "SELECT per_ID, per_FirstName, per_MiddleName, per_LastName, per_Title, per_Suffix, per_Address1, per_Address2, per_City, per_State, per_Zip, per_HomePhone, per_Country, per_Email, fam_Address1, fam_Address2, fam_City, fam_State, fam_Zip, fam_Country, fam_HomePhone, fam_Email, lst_OptionName\n\t\t\tFROM person_per\n\t\t\tLEFT JOIN person2group2role_p2g2r ON per_ID = p2g2r_per_ID\n\t\t\tLEFT JOIN list_lst ON p2g2r_rle_ID = lst_OptionID AND lst_ID = {$iRoleListID}\n\t\t\tLEFT JOIN group_grp ON grp_ID = p2g2r_grp_ID\n\t\t\tLEFT JOIN family_fam ON per_fam_ID = family_fam.fam_ID\n\t\tWHERE p2g2r_grp_ID = " . $iGroupID;
