mayi_cms/mayicms/infomanage.php

<?php
//decode by http://dezend.qiling.org  QQ 2859470

define('CURSCRIPT', 'infomanage');
define('IN_AJAX', true);
require_once dirname(__FILE__) . '/global.php';
require_once MYMPS_INC . '/db.class.php';
if (!submit_check(CURSCRIPT . '_submit') && $action != 'viewresult') {
    chk_admin_purview('purview_批量管理');
    $here = '批量管理';
    include mymps_tpl(CURSCRIPT);
} else {
    if ($step != 'submit' && !$catid && !$userid && !$areaid && !$starttime && !$endtime && !$ip && !$keywords && !$ismember && !istimed) {
        write_msg('您没有指定任何搜索条件，无法完成此次操作！');
    }
    $where = ' WHERE 1';
    $where .= $catid ? ' AND ' . get_children($catid, 'catid') : '';
    $where .= $areaid ? ' AND ' . get_area_children($areaid, 'areaid') : '';
    $where .= $tel ? ' AND tel LIKE \'%' . $tel . '%\'' : '';
    if (in_array($istimed, array('yes', 'no'))) {
        $where .= $istimed == 'yes' ? ' AND endtime < \'' . $timestamp . '\' AND endtime != \'0\'' : ' AND (endtime > \'' . $timestamp . '\' OR endtime = \'0\')';
    }
    if (in_array($ismember, array('yes', 'no'))) {
        $where .= $ismember == 'yes' ? ' AND ismember = \'1\'' : '';
    }
    if (trim($userid)) {
        $where .= ' AND userid IN (\'' . str_replace(',', '\',\'', str_replace(' ', '', $userid)) . '\')';
    }
    $starttime = $starttime ? strtotime($starttime) : 0;
    $where .= $starttime ? ' AND begintime >= \'' . $starttime . '\'' : '';
    $where .= $info_level != '' ? ' AND info_level = \'' . $info_level . '\'' : '';
    $endtime = $endtime ? strtotime($endtime) : 0;
    $where .= $endtime ? ' AND begintime <= \'' . $endtime . '\'' : '';
    if ($keywords != '') {
        $keyword = $keywords;
        $sqlkeywords = '';
        $or = '';
        $keywords = explode(',', str_replace(' ', '', $keywords));
        for ($i = 0; $i < count($keywords); $i++) {
            if (preg_match('/\\{(\\d+)\\}/', $keywords[$i])) {
                $keywords[$i] = preg_replace('/\\\\{(\\d+)\\\\}/', '.{0,\\1}', preg_quote($keywords[$i], '/'));
                $sqlkeywords .= ' ' . $or . ' title REGEXP \'' . $keywords[$i] . '\' OR content REGEXP \'' . $keywords[$i] . '\'';
            } else {
                $sqlkeywords .= ' ' . $or . ' title LIKE \'%' . $keywords[$i] . '%\' OR content LIKE \'%' . $keywords[$i] . '%\'';
            }
            $or = 'OR';
        }
        $where .= ' AND (' . $sqlkeywords . ')';
        $keywords = $keyword;
    }
    $where .= $ip != '' ? ' AND ip LIKE \'' . str_replace('*', '%', $ip) . '\'' : '';
    if ($lengthlimit != '') {
        $lengthlimit = intval($lengthlimit);
        $sql .= ' AND LENGTH(content) < ' . $lengthlimit;
    }
    if ($action == 'viewresult' && $detail == 'yes') {
        require_once MYMPS_DATA . '/info.level.inc.php';
        $here = '批量主题管理';
        $starttime = $starttime ? date('Y-m-d', $starttime) : '';
        $endtime = $endtime ? date('Y-m-d', $endtime) : '';
        $rows_num = mymps_count('information', $where);
        $param = setParam(array('part', 'detail', 'action', 'istimed', 'ismember', 'userid', 'starttime', 'endtime', 'catid', 'areaid', 'ip', 'keywords', 'lengthlimit', 'info_level', 'tel'));
        $information = page1('SELECT * FROM `' . $db_mymps . 'information` ' . $where . ' ORDER BY id DESC', 10);
        include mymps_tpl(CURSCRIPT);
    } else {
        if (empty($part)) {
            write_msg('您没有选择要进行的操作，无法完成此次操作！');
        }
        if (is_array($optionids) && $step == 'submit') {
            $count = count($optionids);
            empty($count) && write_msg('您没有选中需要执行操作的信息记录！');
            foreach ($optionids as $key => $val) {
                $ids .= $val . ',';
            }
            $selectedids = substr($ids, 0, -1);
        } else {
            if (!is_array($optionids) && $step != 'submit') {
                $count = $db->getOne('SELECT count(id) FROM `' . $db_mymps . 'information` AS a ' . $where);
                $query = $db->query('SELECT a.id FROM `' . $db_mymps . 'information` AS a ' . $where);
                while ($post = $db->fetchRow($query)) {
                    $ids .= $post['id'] . ',';
                }
                $selectedids = substr($ids, 0, -1);
            } else {
                write_msg('您没有选择要进行操作的信息记录！');
            }
        }
        $starttime = $starttime ? date('Y-m-d', $starttime) : '';
        $endtime = $endtime ? date('Y-m-d', $endtime) : '';
        if (empty($selectedids) || $selectedids == ',') {
            write_msg('没有找到符合搜索条件的相关分类信息主题！');
        }
        switch ($part) {
            case 'delinfo':
                $query = $db->query('SELECT * FROM `' . $db_mymps . 'information` WHERE id IN (' . $selectedids . ')');
                while ($row = $db->fetchRow($query)) {
                    1 < $row[modid] && mymps_delete('information_' . $row[modid], 'WHERE id = \'' . $row['id'] . '\'');
                }
                mymps_delete('information', 'WHERE id IN(' . $selectedids . ')');
                $query = $db->query('SELECT * FROM `' . $db_mymps . 'info_img` WHERE infoid IN (' . $selectedids . ')');
                while ($row = $db->fetchRow($query)) {
                    @unlink(MYMPS_ROOT . $row['imgpath']);
                    @unlink(MYMPS_ROOT . $row['pre_imgpath']);
                }
                mymps_delete('info_img', 'WHERE infoid IN (' . $selectedids . ')');
                mymps_delete('comment', 'WHERE typeid IN (' . $selectedids . ') AND type = \'information\'');
                $act = '删除信息';
                break;
            case 'delcomment':
                $count = mymps_count('info_comment', 'WHERE infoid IN (' . $selectedids . ')');
                mymps_delete('info_comment', 'WHERE infoid IN (' . $selectedids . ')');
                $act = '删除信息评论';
                break;
            case 'delattach':
                $query = $db->query('SELECT * FROM `' . $db_mymps . 'info_img` WHERE infoid IN (' . $selectedids . ')');
                $count = 0;
                while ($row = $db->fetchRow($query)) {
                    @unlink(MYMPS_ROOT . $row['imgpath']);
                    @unlink(MYMPS_ROOT . $row['pre_imgpath']);
                    $count++;
                }
                mymps_delete('info_img', 'WHERE infoid IN (' . $selectedids . ')');
                $db->query('UPDATE `' . $db_mymps . 'information` SET img_path = \'\' WHERE id IN (' . $selectedids . ')');
                $act = '删除信息图片';
                break;
            case 'delhtml':
                $query = $db->query('SELECT * FROM `' . $db_mymps . 'information` WHERE id IN (' . $selectedids . ')');
                $count = 0;
                while ($row = $db->fetchRow($query)) {
                    @unlink(MYMPS_ROOT . $row['html_path']);
                    $count++;
                }
                $act = '删除信息HTML文件';
                break;
            case 'refresh':
                foreach (explode(',', $selectedids) as $kids => $vids) {
                    $activetime = $db->getOne('SELECT activetime FROM `' . $db_mymps . 'information` WHERE id = \'' . $vids . '\'');
                    $endtime = $activetime == 0 ? 0 : $activetime * 3600 * 24 + $timestamp;
                    $db->query('UPDATE `' . $db_mymps . 'information` SET begintime = \'' . $timestamp . '\',endtime=\'' . $endtime . '\' WHERE id = \'' . $vids . '\'');
                }
                $act = '刷新信息';
                break;
            case 'level0':
                $db->query('UPDATE `' . $db_mymps . 'information` SET info_level = \'0\' WHERE id IN (' . $selectedids . ')');
                $act = '设为待审信息';
                break;
            case 'level1':
                $db->query('UPDATE `' . $db_mymps . 'information` SET info_level = \'1\' WHERE id IN (' . $selectedids . ')');
                $act = '设为正常信息';
                break;
            case 'level2':
                $db->query('UPDATE `' . $db_mymps . 'information` SET info_level = \'2\' WHERE id IN (' . $selectedids . ')');
                $act = '设置推荐信息';
                break;
            case 'ifred':
                $db->query('UPDATE `' . $db_mymps . 'information` SET ifred = \'1\' WHERE id IN (' . $selectedids . ')');
                $act = '信息标题套红';
                break;
            case 'ifbold':
                $db->query('UPDATE `' . $db_mymps . 'information` SET ifbold = \'1\' WHERE id IN (' . $selectedids . ')');
                $act = '信息标题加粗';
                break;
        }
    }
    !empty($act) && write_msg('共 ' . $act . ' ' . $count . ' 条', $return_url, 'write_record');
}
is_object($db) && $db->Close();
$db = $mymps_global = $part = $action = $here = $where = $selectedids = $step = NULL;