$movePrep = $myconn->prepare("UPDATE " . db_table_pref . "subscribers SET GID=? WHERE OID=" . set_org_id . " AND ID=?") or die(mysqli_error($myconn));
$moveGrpOwnerPrep = $myconn->prepare("SELECT ID FROM " . db_table_pref . "subscriber_groups WHERE OID=" . set_org_id . " AND ID=? " . (LETHE_AUTH_VIEW_TYPE ? ' AND UID=' . LETHE_AUTH_ID . '' : '') . "") or die(mysqli_error($myconn));
$moveGrpOwnerPrep->bind_param('i', $movGrp);
$moveGrpOwnerPrep->execute();
$moveGrpOwnerPrep->store_result();
if ($moveGrpOwnerPrep->num_rows > 0) {
$movStatus = true;
}
$moveGrpOwnerPrep->close();
$opRemCls = new lethe();
$opRemCls->OID = set_org_id;
foreach ($_POST['sbr'] as $k => $v) {
/* Delete */
if ($_POST['selOpt'] == 'delete') {
$selSubMail = getSubscriber($v, 0);
$opRemCls->removeSubscription($selSubMail);
} else {
if ($_POST['selOpt'] == 'move') {
if ($movStatus) {
$movePrep->bind_param('ii', $movGrp, $v);
$movePrep->execute();
}
}
}
}
$movePrep->close();
}
}
}
?>
@set_time_limit(0);
$dgrp = $myconn->prepare("DELETE FROM " . db_table_pref . "subscriber_groups WHERE OID=" . set_org_id . " AND isUnsubscribe=0 AND ID=? " . (LETHE_AUTH_VIEW_TYPE ? ' AND UID=' . LETHE_AUTH_ID . '' : '') . "") or die(mysqli_error($myconn));
$ugrp = $myconn->prepare("UPDATE " . db_table_pref . "subscriber_groups SET group_name=? WHERE OID=" . set_org_id . " AND ID=? " . (LETHE_AUTH_VIEW_TYPE ? ' AND UID=' . LETHE_AUTH_ID . '' : '') . "") or die(mysqli_error($myconn));
$callLethe = new lethe();
$callLethe->OID = set_org_id;
foreach ($_POST['group_datas'] as $k => $v) {
/* Delete */
if (isset($_POST['del_' . $v]) && $_POST['del_' . $v] == 'YES') {
/* Check System Groups */
if (cntData("SELECT ID FROM " . db_table_pref . "subscriber_groups WHERE OID=" . set_org_id . " AND ID=" . intval($v) . " AND (isUnsubscribe=1 OR isUngroup=1)") == 0) {
$dgrp->bind_param('i', $v);
$dgrp->execute();
# Remove Subscribers
$opSubs = $myconn->query("SELECT * FROM " . db_table_pref . "subscribers WHERE GID=" . intval($v) . "") or die(mysqli_error($myconn));
while ($opSubsRs = $opSubs->fetch_assoc()) {
$callLethe->removeSubscription($opSubsRs['subscriber_mail']);
}
$opSubs->free();
# Remove Campaign Groups
$myconn->query("DELETE FROM " . db_table_pref . "campaign_groups WHERE GID=" . intval($v) . "") or die(mysqli_error($myconn));
# Remove Group
$myconn->query("DELETE FROM " . db_table_pref . "subscriber_groups WHERE ID=" . intval($v) . "") or die(mysqli_error($myconn));
# Remove Forms
$opForms = $myconn->query("SELECT * FROM " . db_table_pref . "subscribe_forms WHERE form_group=" . intval($v) . " AND isSystem=0") or die(mysqli_error($myconn));
while ($opFormsRs = $opForms->fetch_assoc()) {
$myconn->query("DELETE FROM " . db_table_pref . "subscribe_form_fields WHERE FID=" . $opFormsRs['ID'] . "") or die(mysqli_error($myconn));
}
$opForms->free();
$myconn->query("DELETE FROM " . db_table_pref . "subscribe_forms WHERE form_group=" . intval($v) . " AND isSystem=0") or die(mysqli_error($myconn));
} else {
$succText .= '* <strong>' . letheglobal_error . ':</strong> ' . subscribers_system_groups_could_not_be_deleted . '<br>';