mayi_cms/mayicms/record.php

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

define('CURSCRIPT', 'record');
require_once dirname(__FILE__) . '/global.php';
require_once MYMPS_INC . '/db.class.php';
require_once MYMPS_DATA . '/config.inc.php';
!in_array($do, array('member', 'admin')) && ($do = 'admin');
!in_array($part, array('login', 'money', 'action')) && ($part = 'login');
if ($result == 'false') {
    $_result = 0;
} else {
    if ($result == 'true') {
        $_result = 1;
    } else {
        $_result = '';
    }
}
if ($action == 'delrecord') {
    $total_count = mymps_count($do . '_record_' . $part);
    if ($total_count < $mymps_mymps['cfg_record_save']) {
        write_msg('操作失败！相关记录不满 ' . $mymps_mymps['cfg_record_save'] . ' 条！');
    }
    $delrecord = $db->getAll('SELECT id FROM `' . $db_mymps . $do . '_record_' . $part . '` ORDER BY ID DESC LIMIT 1,' . $mymps_mymps['cfg_record_save']);
    foreach ($delrecord as $k => $value) {
        $id .= $value[id] . ',';
    }
    $id = substr($id, 0, -1);
    mymps_delete($do . '_record_' . $part, 'WHERE id NOT IN (' . $id . ')');
    write_msg('成功删除操作记录！', $url, 'MyMPS');
    exit;
} else {
    if ($action == 'doexcel') {
        $data[] = array('用户名', 'IP', '端口', '地理位置', '浏览器', '操作系统', '上线时间', '下线时间');
        $query = $db->query('SELECT * FROM `' . $db_mymps . 'member_record_login` ORDER BY pubdate DESC');
        while ($row = $db->fetchRow($query)) {
            $data[$row['id']][] = $row['userid'];
            $data[$row['id']][] = $row['ip'];
            $data[$row['id']][] = $row['port'];
            $data[$row['id']][] = $row['ip2area'];
            $data[$row['id']][] = $row['browser'];
            $data[$row['id']][] = $row['os'];
            $data[$row['id']][] = GetTime($row['pubdate']);
            $data[$row['id']][] = GetTime($row['outdate'] ? $row['outdate'] : $row['pubdate'] + 3627);
        }
        require MYMPS_INC . '/php-excel.class.php';
        $xls = new Excel_XML('gb2312', false, 'MemberRecordSheet');
        $xls->addArray($data);
        $xls->generateXML(date('Y-m-d-His', $timestamp));
        unset($xls);
        exit;
    } else {
        if ($action == 'savemonth') {
            $monthdate = strtotime('-2 month');
            $db->query('DELETE FROM `' . $db_mymps . 'member_record_login` WHERE pubdate < \'' . $monthdate . '\'');
            write_msg('已成功删除两个月前的登录记录！', 'record.php?do=member&part=login', 'Mymps');
            exit;
        }
    }
}
switch ($do) {
    case 'admin':
        if ($part == 'login') {
            chk_admin_purview('purview_管理记录');
            $here = '管理员后台管理登陆记录';
            $where = 'WHERE result like \'%' . $_result . '%\' AND (id like \'%' . $keywords . '%\' OR adminid like \'%' . $keywords . '%\' OR adminpwd like \'%' . $keywords . '%\' OR pubdate like \'%' . $keywords . '%\' OR ip like \'%' . $keywords . '%\')';
            $sql = 'SELECT * FROM ' . $db_mymps . 'admin_record_login ' . $where . ' ORDER BY id desc';
            $rows_num = $db->getOne('SELECT COUNT(*) FROM `' . $db_mymps . 'admin_record_login` ' . $where);
            $param = setParam(array('do', 'part', 'result', 'keywords'));
            $record = array();
            foreach (page1($sql) as $k => $row) {
                $arr['id'] = $row['id'];
                $arr['adminid'] = $row['adminid'];
                $arr['adminpwd'] = $row['adminpwd'];
                $arr['pubdate'] = GetTime($row['pubdate']);
                $arr['ip'] = $row['ip'];
                $arr['result'] = $row['result'];
                $record[] = $arr;
            }
            include mymps_tpl('record_login');
        } else {
            if ($part == 'action') {
                chk_admin_purview('purview_管理记录');
                $here = '管理员后台管理操作记录';
                $where = 'WHERE a.id like \'%' . $keywords . '%\' OR a.adminid like \'%' . $keywords . '%\' OR a.action like \'%' . $keywords . '%\' OR a.pubdate like \'%' . $keywords . '%\' OR a.ip like \'%' . $keywords . '%\' ORDER BY a.id desc';
                $sql = 'SELECT a.id,a.adminid,a.action,a.pubdate,a.ip,b.typeid,c.typename FROM ' . $db_mymps . 'admin_record_action AS a LEFT JOIN ' . $db_mymps . 'admin AS b ON a.adminid = b.userid  LEFT JOIN ' . $db_mymps . 'admin_type AS c ON b.typeid = c.id ' . $where;
                $rows_num = $db->getOne('SELECT COUNT(*) FROM `' . $db_mymps . 'admin_record_action` AS a ' . $where . ' ');
                $param = setParam(array('do', 'part', 'result', 'keywords'));
                $record = array();
                foreach (page1($sql) as $k => $row) {
                    $arr['id'] = $row['id'];
                    $arr['adminid'] = $row['adminid'];
                    $arr['typename'] = $row['typename'];
                    $arr['action'] = $row['action'];
                    $arr['pubdate'] = GetTime($row['pubdate']);
                    $arr['ip'] = $row['ip'];
                    $record[] = $arr;
                }
                include mymps_tpl('record_action');
            }
        }
        break;
    case 'member':
        if ($part == 'login') {
            chk_admin_purview('purview_会员登录记录');
            if (trim($action) == 'delall') {
                write_msg('删除普通会员操作日志 ' . mymps_del_all('member_record_' . $part, $id) . ' 成功', $url, 'mymps');
            }
            $here = '普通会员登陆记录';
            $where = ' WHERE userid like \'%' . $keywords . '%\' ';
            $sql = 'SELECT * FROM ' . $db_mymps . 'member_record_login ' . $where . ' ORDER BY id DESC';
            $rows_num = mymps_count('member_record_login', $where);
            $param = setParam(array('do', 'part'));
            $record = array();
            foreach (page1($sql) as $k => $row) {
                $arr['id'] = $row['id'];
                $arr['userid'] = $row['userid'];
                $arr['userpwd'] = $row['userpwd'];
                $arr['pubdate'] = GetTime($row['pubdate']);
                $arr['outdate'] = GetTime($row['outdate'] ? $row['outdate'] : $row['pubdate'] + 3627);
                $arr['ip'] = $row['ip'];
                $arr['ip2area'] = $row['ip2area'];
                $arr['browser'] = $row['browser'];
                $arr['port'] = $row['port'];
                $arr['os'] = $row['os'];
                $arr['result'] = $row['result'];
                $record[] = $arr;
            }
            include mymps_tpl('record_login_member');
        } else {
            if ($part == 'money') {
                chk_admin_purview('purview_会员消费记录');
                $here = '会员消费记录';
                if (trim($action) == 'delall') {
                    write_msg('删除 <b>' . $here . '</b> ' . mymps_del_all('member_record_use', $id) . ' 成功', $url, 'mymps');
                    exit;
                }
                $sql = 'SELECT * FROM `' . $db_mymps . 'member_record_use` ORDER BY pubtime DESC';
                $rows_num = mymps_count('member_record_use', $where);
                $param = setParam(array('do', 'part'));
                $get = array();
                foreach (page1($sql) as $k => $row) {
                    $arr['id'] = $row['id'];
                    $arr['userid'] = $row['userid'];
                    $arr['subject'] = $row['subject'];
                    $arr['paycost'] = $row['paycost'];
                    $arr['pubtime'] = GetTime($row['pubtime']);
                    $get[] = $arr;
                }
                include mymps_tpl('record_bank');
            }
        }
        break;
}
is_object($db) && $db->Close();
$mymps_global = $db = $db_mymps = $part = NULL;