*/
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 {
