XoopsModules25x / xnewsletter

        $maintenance .= '</table>';

        $GLOBALS['xoopsTpl']->assign('maintenance', $maintenance);

        break;

    case 'del_import':

        if (true === \Xmf\Request::getBool('ok', false, 'POST')) {

            $result = $xoopsDB->queryF("TRUNCATE TABLE `{$xoopsDB->prefix('xnewsletter_import')}`");

            $result = $xoopsDB->queryF("REPAIR TABLE `{$xoopsDB->prefix('xnewsletter_import')}`");

            $result = $xoopsDB->queryF("OPTIMIZE TABLE `{$xoopsDB->prefix('xnewsletter_import')}`");

            $result = $xoopsDB->queryF("ALTER TABLE `{$xoopsDB->prefix('xnewsletter_import')}` AUTO_INCREMENT =1");

            $protocolObj = $helper->getHandler('Protocol')->create();

            $protocolObj->setVar('protocol_letter_id', 0);

            $protocolObj->setVar('protocol_subscriber_id', 0);

            $protocolObj->setVar('protocol_status', '[' . _MI_XNEWSLETTER_ADMENU11 . ' import] ' . _AM_XNEWSLETTER_MAINTENANCE_DELETE_IMPORT_OK);

            $protocolObj->setVar('protocol_success', true);

            $protocolObj->setVar('protocol_submitter', $GLOBALS['xoopsUser']->uid());

            $protocolObj->setVar('protocol_created', time());

            if (!$helper->getHandler('Protocol')->insert($protocolObj)) {

                // IN PROGRESS

            }

            redirect_header($currentFile, 3, _AM_XNEWSLETTER_MAINTENANCE_DELETE_IMPORT_OK);

        } else {

            xoops_confirm(['ok' => true, 'op' => 'del_import'], $currentFile, _AM_XNEWSLETTER_MAINTENANCE_DELETE_IMPORT);

        }

        break;

    case 'del_oldsubscr':

        $time = strtotime($_POST['del_date']);

        if ($time >= time() || 0 == $time) {

            }

        }

        break;

    case 'del_oldprotocol':

        if (true === Request::getBool('ok', false, 'POST')) {

            $result = $xoopsDB->queryF("TRUNCATE TABLE `{$xoopsDB->prefix('xnewsletter_protocol')}`");

            $result = $xoopsDB->queryF("REPAIR TABLE `{$xoopsDB->prefix('xnewsletter_protocol')}`");

            $result = $xoopsDB->queryF("OPTIMIZE TABLE `{$xoopsDB->prefix('xnewsletter_protocol')}`");

            $result = $xoopsDB->queryF("ALTER TABLE `{$xoopsDB->prefix('xnewsletter_protocol')}` AUTO_INCREMENT =1");

            $protocolObj = $helper->getHandler('Protocol')->create();

            $protocolObj->setVar('protocol_letter_id', 0);

            $protocolObj->setVar('protocol_subscriber_id', 0);

            $protocolObj->setVar('protocol_status', '[' . _MI_XNEWSLETTER_ADMENU11 . ' prot] ' . _AM_XNEWSLETTER_MAINTENANCE_DELETEPROTOK);

            $protocolObj->setVar('protocol_success', true);

            $protocolObj->setVar('protocol_submitter', $GLOBALS['xoopsUser']->uid());

            $protocolObj->setVar('protocol_created', time());

            if (!$helper->getHandler('Protocol')->insert($protocolObj)) {

                // IN PROGRESS

            }

            redirect_header($currentFile, 3, _AM_XNEWSLETTER_MAINTENANCE_DELETEPROTOK);

        } else {

            xoops_confirm(['ok' => true, 'op' => 'del_oldprotocol'], $currentFile, _AM_XNEWSLETTER_MAINTENANCE_DELETEPROTOCOL);

        }

        break;

    case 'del_invalid_catsubscr':

        //delete data in table catsubscr, if catsubscr_subscrid is no more existing in table subscr

        if (true === Request::getBool('ok', false, 'POST')) {