*/ if ($COMMUNITY_ID) { $query = "SELECT * FROM `communities` WHERE `community_id` = " . $db->qstr($COMMUNITY_ID) . " AND `community_active` = '1'"; $community_details = $db->GetRow($query); if ($community_details) { $query = "\n\t\t\t\tSELECT * FROM `community_members`\n\t\t\t\tWHERE `community_id` = " . $db->qstr($COMMUNITY_ID) . "\n\t\t\t\tAND `proxy_id` = " . $db->qstr($ENTRADA_USER->getActiveId()); $result = $db->GetRow($query); if ($result) { if ((int) $result["member_active"]) { switch ($STEP) { case 2: $query = "DELETE FROM `community_members` WHERE `community_id` = " . $db->qstr($COMMUNITY_ID) . " AND `proxy_id` = " . $db->qstr($ENTRADA_USER->getActiveId()) . " AND `member_active` = '1' LIMIT 1"; if ($db->Execute($query)) { if ($MAILING_LISTS["active"]) { $mail_list = new MailingList($COMMUNITY_ID); $mail_list->remove_member($result["proxy_id"]); } if (COMMUNITY_NOTIFICATIONS_ACTIVE) { community_notify($COMMUNITY_ID, $ENTRADA_USER->getActiveId(), "leave", ENTRADA_URL . "/people?id=" . $ENTRADA_USER->getActiveId(), $COMMUNITY_ID); } application_log("success", "Removed proxy_id [" . $ENTRADA_USER->getActiveId() . "] from community_id [" . $COMMUNITY_ID . "]."); } else { application_log("error", "Unable to remove proxy_id [" . $ENTRADA_USER->getActiveId() . "] from community_id [" . $COMMUNITY_ID . "]. Database said: " . $db->ErrorMsg()); } if ($_SESSION['details']['group'] == 'guest') { $query = "SELECT COUNT(*) AS total FROM `community_members`\n\t\t\t\t\t\t\t\t\tWHERE `community_members`.`proxy_id` = {$result['ID']} AND `community_members`.`member_active` = 1"; $community_result = $db->GetRow($query); if (!isset($community_result) || $community_result['total'] == 0) { header("Location: " . ENTRADA_URL . "?action=logout"); } } else {