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); }
function RemoveGroupFromPeopleCart($iGroupID) { //Get all the members of this group $sSQL = "SELECT p2g2r_per_ID FROM person2group2role_p2g2r " . "WHERE p2g2r_grp_ID = " . $iGroupID; $rsGroupMembers = RunQuery($sSQL); //Loop through the recordset while ($aRow = mysql_fetch_array($rsGroupMembers)) { extract($aRow); //remove each person from the cart RemoveFromPeopleCart($p2g2r_per_ID); } }
// If Magic Quotes is turned off, do the same thing manually.. if (!$_SESSION['bHasMagicQuotes']) { foreach ($_REQUEST as $key => $value) { $value = addslashes($value); } } // Constants $aPropTypes = array(1 => gettext("True / False"), 2 => gettext("Date"), 3 => gettext("Text Field (50 char)"), 4 => gettext("Text Field (100 char)"), 5 => gettext("Text Field (long)"), 6 => gettext("Year"), 7 => gettext("Season"), 8 => gettext("Number"), 9 => gettext("Person from Group"), 10 => gettext("Money"), 11 => gettext("Phone Number"), 12 => gettext("Custom Drop-Down List")); // Are they adding anything to the People Cart? if (isset($_GET["AddToPeopleCart"])) { AddToPeopleCart(FilterInput($_GET["AddToPeopleCart"], 'int')); $sGlobalMessage = gettext("Selected record successfully added to the Cart."); } // Are they removing anything from the People Cart? if (isset($_GET["RemoveFromPeopleCart"])) { RemoveFromPeopleCart(FilterInput($_GET["RemoveFromPeopleCart"], 'int')); $sGlobalMessage = gettext("Selected record successfully removed from the Cart."); } // Are they emptying their cart? if ($_GET["Action"] == "EmptyCart") { unset($_SESSION['aPeopleCart']); $sGlobalMessage = gettext("Your cart has been successfully emptied."); } if (isset($_POST["BulkAddToCart"])) { $aItemsToProcess = explode(",", $_POST["BulkAddToCart"]); if (isset($_POST["AndToCartSubmit"])) { if (isset($_SESSION['aPeopleCart'])) { $_SESSION['aPeopleCart'] = array_intersect($_SESSION['aPeopleCart'], $aItemsToProcess); } } elseif (isset($_POST["NotToCartSubmit"])) { if (isset($_SESSION['aPeopleCart'])) {