mambax7 / newbb

admin/admin_forum_prune.php

<?php declare(strict_types=1);
//
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System                      //
// Copyright (c) 2000-2020 XOOPS.org                           //
// <https://xoops.org>                             //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify     //
// it under the terms of the GNU General Public License as published by     //
// the Free Software Foundation; either version 2 of the License, or        //
// (at your option) any later version.                                      //
// //
// You may not change or alter any portion of this comment or credits       //
// of supporting developers from this source code or any supporting         //
// source code which is considered copyrighted (c) material of the          //
// original comment or credit authors.                                      //
// //
// This program is distributed in the hope that it will be useful,          //
// but WITHOUT ANY WARRANTY; without even the implied warranty of           //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            //
// GNU General Public License for more details.                             //
// //
// You should have received a copy of the GNU General Public License        //
// along with this program; if not, write to the Free Software              //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA //
// ------------------------------------------------------------------------ //

use Xmf\Module\Admin;
use Xmf\Request;
use XoopsModules\Newbb\{
    Helper,
    ForumHandler
};

/** @var Admin $adminObject */
require_once __DIR__ . '/admin_header.php';
require_once $GLOBALS['xoops']->path('class/xoopsformloader.php');

xoops_cp_header();
$adminObject->displayNavigation(basename(__FILE__));

//if (!$newXoopsModuleGui) loadModuleAdminMenu(5, _AM_NEWBB_PRUNE_TITLE);
//    else $adminObject->displayNavigation(basename(__FILE__));

echo "<table class='outer' style='border-collapse: separate; border-spacing: 1px; width: 100%;'>" . "<tr><td class='odd'>";

if (Request::hasVar('submit', 'POST')) {
    $post_list       = null;
    $topic_list      = null;
    $topics_number   = 0;
    $posts_number    = 0;
    $selected_forums = '';
    // irmtfan fix if it is array
    $temp = Request::getArray('forums', null, 'POST');
    if (!$temp || !$temp[0]) {

The expression $temp of type array is implicitly converted to a boolean; are you sure this is intended? If so, consider using empty($expr) instead to make it clear that you intend to check for an array without elements.

        redirect_header('admin_forum_prune.php', 1, _AM_NEWBB_PRUNE_FORUMSELERROR);
    } elseif (is_array(Request::getArray('forums', '', 'POST'))) {

The condition is_array(Xmf\Request::getArray('forums', '', 'POST')) is always true.

        $selected_forums = implode(',', Request::getArray('forums', null, 'POST'));
    } else {
        $selected_forums = Request::getArray('forums', null, 'POST');
    }

    $prune_days  = Request::getInt('days', 0, 'POST');
    $prune_ddays = time() - $prune_days;
    $archive     = Request::getInt('archive', 0, 'POST');
    $sticky      = Request::getInt('sticky', 0, 'POST');
    $digest      = Request::getInt('digest', 0, 'POST');
    $lock        = Request::getInt('lock', 0, 'POST');
    $hot         = Request::getInt('hot', 0, 'POST');
    $store       = Request::getInt('store', 0, 'POST');

    $sql = 'SELECT t.topic_id FROM ' . $GLOBALS['xoopsDB']->prefix('newbb_topics') . ' t, ' . $GLOBALS['xoopsDB']->prefix('newbb_posts') . '  p
                    WHERE t.forum_id IN (' . $selected_forums . ')
                    AND p.post_id =t.topic_last_post_id ';

    if ($sticky) {
        $sql .= ' AND t.topic_sticky <> 1 ';
    }
    if ($digest) {
        $sql .= ' AND t.topic_digest <> 1 ';
    }
    if ($lock) {
        $sql .= ' AND t.topic_status <> 1 ';
    }
    if (0 !== $hot) {
        $sql .= ' AND t.topic_replies < ' . $hot . ' ';
    }

    $sql .= ' AND p.post_time<= ' . $prune_ddays . ' ';
    // Ok now we have the sql query completed, go for topic_id's and posts_id's
    $topics = [];
    $result = $GLOBALS['xoopsDB']->query($sql);
    if (!$GLOBALS['xoopsDB']->isResultSet($result)) {
        //        return _MD_NEWBB_ERROR;
        \trigger_error("Query Failed! SQL: $sql- Error: " . $GLOBALS['xoopsDB']->error(), E_USER_ERROR);
    }
    // Dave_L code
    while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {
        $topics[] = $row['topic_id'];
    }
    $topics_number = count($topics);
    $topic_list    = implode(',', $topics);
    $post_list     = '';

    if ('' !== $topic_list) {
        $sql = 'SELECT post_id FROM ' . $GLOBALS['xoopsDB']->prefix('newbb_posts') . ' WHERE topic_id IN (' . $topic_list . ')';
        $posts = [];
        $result = $GLOBALS['xoopsDB']->query($sql);
        if (!$GLOBALS['xoopsDB']->isResultSet($result)) {
            //        return _MD_NEWBB_ERROR;
            \trigger_error("Query Failed! SQL: $sql- Error: " . $GLOBALS['xoopsDB']->error(), E_USER_ERROR);
        }

        // Dave_L code
        while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {
            $posts[] = $row['post_id'];
        }
        $posts_number = count($posts);
        $post_list    = implode(',', $posts);
    }
    // OKZ Now we have al posts id and topics id
    if ('' !== $post_list) {
        // COPY POSTS TO OTHER FORUM
        if (0 < $store) {
            $sql = 'UPDATE ' . $GLOBALS['xoopsDB']->prefix('newbb_posts') . " SET forum_id=$store WHERE topic_id IN ($topic_list)";
            if (!$result = $GLOBALS['xoopsDB']->query($sql)) {
                return _MD_NEWBB_ERROR;
            }

            $sql = 'UPDATE ' . $GLOBALS['xoopsDB']->prefix('newbb_topics') . " SET forum_id=$store WHERE topic_id IN ($topic_list)";
            if (!$result = $GLOBALS['xoopsDB']->query($sql)) {
                return _MD_NEWBB_ERROR;
            }
        } else {
            // ARCHIVING POSTS
            if (1 == $archive) {
                $sql = 'SELECT p.topic_id, p.post_id, t.post_text FROM ' . $GLOBALS['xoopsDB']->prefix('newbb_posts') . ' p, ' . $GLOBALS['xoopsDB']->prefix('newbb_posts_text') . " t WHERE p.post_id IN ($post_list) AND p.post_id=t.post_id";
                $result = $GLOBALS['xoopsDB']->query($sql);
                if ($GLOBALS['xoopsDB']->isResultSet($result)) {
                    while ([$topic_id, $post_id, $post_text] = $GLOBALS['xoopsDB']->fetchRow($result)) {
                        $sql = $GLOBALS['xoopsDB']->query('INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('newbb_archive') . " (topic_id, post_id, post_text) VALUES ($topic_id, $post_id, $post_text)");
                    }
                }
            }
            // DELETE POSTS
            $sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('newbb_posts') . " WHERE topic_id IN ($topic_list)";
            $result = $GLOBALS['xoopsDB']->query($sql);
            if (!$result) {
                return _MD_NEWBB_ERROR;
            }
            // DELETE TOPICS
            $sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('newbb_topics') . " WHERE topic_id IN ($topic_list)";
            $result = $GLOBALS['xoopsDB']->query($sql);
            if (!$result) {
                return _MD_NEWBB_ERROR;
            }
            // DELETE POSTS_TEXT
            $sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('newbb_posts_text') . " WHERE post_id IN ($post_list)";
            $result = $GLOBALS['xoopsDB']->query($sql);
            if (!$result) {
                return _MD_NEWBB_ERROR;
            }
            // SYNC FORUMS AFTER DELETE
            // /** @var ForumHandler $forumHandler */
            //  $forumHandler = Helper::getInstance()->getHandler('Forum');
            $forumHandler->synchronization();
            // I THINK POSTS AND TOPICS HAVE BEEN DESTROYED :LOL:
        }
    }

    $tform = new \XoopsThemeForm(_AM_NEWBB_PRUNE_RESULTS_TITLE, 'prune_results', xoops_getenv('SCRIPT_NAME'));
    $tform->addElement(new \XoopsFormLabel(_AM_NEWBB_PRUNE_RESULTS_FORUMS, $selected_forums));
    $tform->addElement(new \XoopsFormLabel(_AM_NEWBB_PRUNE_RESULTS_TOPICS, (string)$topics_number));
    $tform->addElement(new \XoopsFormLabel(_AM_NEWBB_PRUNE_RESULTS_POSTS, (string)$posts_number));
    $tform->display();
} else {
    $sform = new \XoopsThemeForm(_AM_NEWBB_PRUNE_TITLE, 'prune', xoops_getenv('SCRIPT_NAME'));
    $sform->setExtra('enctype="multipart/form-data"');

    /* Let User select the number of days
    $sform->addElement( new \XoopsFormText(_AM_NEWBB_PRUNE_DAYS , 'days', 5, 10,100 ), true );
    */
    // $sql="SELECT p.topic_id, p.post_id t.post_text FROM ".$GLOBALS['xoopsDB']->prefix("newbb_posts")." p, ".$GLOBALS['xoopsDB']->prefix("newbb_posts_text")." t WHERE p.post_id IN ($post_list) AND p.post_id=t.post_id";
    // $result = $GLOBALS['xoopsDB']->query();
    // Days selected by selbox (better error control :lol:)
    $days = new \XoopsFormSelect(_AM_NEWBB_PRUNE_DAYS, 'days', null, 1, false);
    $days->addOptionArray(
        [
            604800   => _AM_NEWBB_PRUNE_WEEK,
            1_209_600  => _AM_NEWBB_PRUNE_2WEEKS,

The constant 1_209_600 was not found. Maybe you did not declare it correctly or list all dependencies?

            2_592_000  => _AM_NEWBB_PRUNE_MONTH,

The constant 2_592_000 was not found. Maybe you did not declare it correctly or list all dependencies?

            5_184_000  => _AM_NEWBB_PRUNE_2MONTH,

The constant 5_184_000 was not found. Maybe you did not declare it correctly or list all dependencies?

            10_368_000 => _AM_NEWBB_PRUNE_4MONTH,

The constant 10_368_000 was not found. Maybe you did not declare it correctly or list all dependencies?

            31_536_000 => _AM_NEWBB_PRUNE_YEAR,

The constant 31_536_000 was not found. Maybe you did not declare it correctly or list all dependencies?

            63_072_000 => _AM_NEWBB_PRUNE_2YEARS,

The constant 63_072_000 was not found. Maybe you did not declare it correctly or list all dependencies?

        ]
    );
    $sform->addElement($days);
    // START irmtfan remove hardcode db access
    require_once $GLOBALS['xoops']->path('modules/' . $xoopsModule->getVar('dirname') . '/footer.php'); // to include js files
    require_once \dirname(__DIR__) . '/include/functions.forum.php';
    $forumSelMulti  = "<select name=\"forums[]\" multiple=\"multiple\" onfocus = \"validate('forums[]','select', false,true)\">"; // disable all categories
    $forumSelSingle = "<select name=\"store\" onfocus = \"validate('store','select', false,true)\">"; // disable all categories
    $forumSelBox    = '<option value = 0 >-- ' . _AM_NEWBB_PERM_FORUMS . ' --</option>';
    $forumSelBox    .= newbbForumSelectBox(null, 'access', false); //$accessForums = nothing, $permission = "access", $delimitorCategory = false
    $forumSelBox    .= '</select>';
    $forumEle       = new \XoopsFormLabel(_AM_NEWBB_PRUNE_FORUMS, $forumSelMulti . $forumSelBox);
    $storeEle       = new \XoopsFormLabel(_AM_NEWBB_PRUNE_STORE, $forumSelSingle . $forumSelBox);
    /* irmtfan remove hardcode
    $checkbox = new \XoopsFormCheckBox(_AM_NEWBB_PRUNE_FORUMS, 'forums');
    $radiobox = new \XoopsFormRadio(_AM_NEWBB_PRUNE_STORE, 'store');
    // PUAJJ I HATE IT, please tidy up
    $sql = "SELECT forum_name, forum_id FROM " . $GLOBALS['xoopsDB']->prefix("newbb_forums") . " ORDER BY forum_id";
    if ($result = $GLOBALS['xoopsDB']->query($sql)) {
        if ($myrow = $GLOBALS['xoopsDB']->fetchArray($result)) {
            do {
                $checkbox->addOption($myrow['forum_id'], $myrow['forum_name']);
                $radiobox->addOption($myrow['forum_id'], $myrow['forum_name']);
            } while (false !== ($myrow = $GLOBALS['xoopsDB']->fetchArray($result)));
        } else {
            echo "NO FORUMS";
        }
    } else {
        echo "DB ERROR";
    }
    */
    // END irmtfan remove hardcode db access

    $sform->addElement(/*$checkbox*/ $forumEle); // irmtfan

    $sticky_confirmation = new \XoopsFormRadio(_AM_NEWBB_PRUNE_STICKY, 'sticky', '1');
    $sticky_confirmation->addOption('1', _AM_NEWBB_PRUNE_YES);
    $sticky_confirmation->addOption('0', _AM_NEWBB_PRUNE_NO);
    $sform->addElement($sticky_confirmation);

    $digest_confirmation = new \XoopsFormRadio(_AM_NEWBB_PRUNE_DIGEST, 'digest', '1');
    $digest_confirmation->addOption('1', _AM_NEWBB_PRUNE_YES);
    $digest_confirmation->addOption('0', _AM_NEWBB_PRUNE_NO);
    $sform->addElement($digest_confirmation);

    $lock_confirmation = new \XoopsFormRadio(_AM_NEWBB_PRUNE_LOCK, 'lock', '0');
    $lock_confirmation->addOption('1', _AM_NEWBB_PRUNE_YES);
    $lock_confirmation->addOption('0', _AM_NEWBB_PRUNE_NO);
    $sform->addElement($lock_confirmation);

    $hot_confirmation = new \XoopsFormSelect(_AM_NEWBB_PRUNE_HOT, 'hot', null, 1, false);
    $hot_confirmation->addOptionArray(
        [
            '0'  => 0,
            '5'  => 5,
            '10' => 10,
            '15' => 15,
            '20' => 20,
            '25' => 25,
            '30' => 30,
        ]
    );
    $sform->addElement($hot_confirmation);

    $sform->addElement(/*$radiobox*/ $storeEle); // irmtfan

    $archive_confirmation = new \XoopsFormRadio(_AM_NEWBB_PRUNE_ARCHIVE, 'archive', '1');
    $archive_confirmation->addOption('1', _AM_NEWBB_PRUNE_YES);
    $archive_confirmation->addOption('0', _AM_NEWBB_PRUNE_NO);
    $sform->addElement($archive_confirmation);

    $buttonTray = new \XoopsFormElementTray('', '');
    $buttonTray->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit'));
    $buttonTray->addElement(new \XoopsFormButton('', 'reset', _AM_NEWBB_PRUNE_RESET, 'reset'));
    $sform->addElement($buttonTray);

    $sform->display();
}

echo '</td></tr></table>';
echo '<fieldset>';
echo '<legend>&nbsp;' . _MI_NEWBB_ADMENU_PRUNE . '&nbsp;</legend>';
echo _AM_NEWBB_HELP_PRUNE_TAB;
echo '</fieldset>';
require_once __DIR__ . '/admin_footer.php';