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;