ecshop清除体验数据插件
2015-04-10 08:45作者：zhao
您可以通过此功能将安装系统时所安装的体验数据全部删除，清除的数据包括用户、商品、订单、文章相关数据。
注意：您最新添加的数据也会一起删除，请慎重使用此功能，建议先做好数据备份！
一、/admin/clear_demo.php
<?php
/**
* ECSHOP 清除体验数据插件
* ----------------------------------------------------------------------------
* http://down.admin5.com
* A5源码 致力于php技术
* ----------------------------------------------------------------------------
* 作者: A5技术
* 邮箱: 439854744#qq.com
*/
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
/*------------------------------------------------------ */
//-- 载入界面
/*------------------------------------------------------ */
if($_REQUEST['act'] == 'start')
{
$smarty->assign('ur_here', $_LANG['clear_demo']);
$smarty->display('clear_demo.htm');
}
/*------------------------------------------------------ */
//-- 清除数据
/*------------------------------------------------------ */
elseif($_REQUEST['act'] == 'clear')
{
$_POST['username'] = isset($_POST['username']) ? trim($_POST['username']) : '';
$_POST['password'] = isset($_POST['password']) ? trim($_POST['password']) : '';
$sql="SELECT `ec_salt` FROM ". $ecs->table('admin_user') ."WHERE user_name = '" . $_POST['username']."'";
$ec_salt =$db->getOne($sql);
if(!empty($ec_salt))
{
/* 检查密码是否正确 */
$sql = "SELECT user_id, user_name, password, last_login, action_list, last_login,suppliers_id,ec_salt".
" FROM " . $ecs->table('admin_user') .
" WHERE user_name = '" . $_POST['username']. "' AND password = '" . md5(md5($_POST['password']).$ec_salt) . "'";
}
else
{
/* 检查密码是否正确 */
$sql = "SELECT user_id, user_name, password, last_login, action_list, last_login,suppliers_id,ec_salt".
" FROM " . $ecs->table('admin_user') .
" WHERE user_name = '" . $_POST['username']. "' AND password = '" . md5($_POST['password']) . "'";
}
$row = $db->getRow($sql);
if($row)
{
$sql="SELECT `action_list` FROM ". $ecs->table('admin_user') ."WHERE user_name = '" . $_POST['username']."'";
$action_list =$db->getOne($sql);
if($action_list == 'all')
{
$tables = array(
'account_log', 'admin_log', 'admin_message', 'article', 'article_cat', 'attribute', 'auction_log',
'back_order', 'bonus_type', 'booking_goods', 'brand',
'card', 'category', 'cat_recommend', 'comment',
'delivery_goods', 'delivery_order',
'exchange_goods',
'favourable_activity', 'feedback', 'friend_link',
'goods', 'goods_activity', 'goods_article', 'goods_attr', 'goods_cat', 'goods_gallery', 'goods_type', 'group_goods',
'keywords',
'link_goods',
'member_price',
'order_action', 'order_goods', 'order_info',
'pack', 'package_goods', 'payment', 'pay_log', 'products',
'shipping', 'shipping_area', 'snatch_log', 'stats', 'suppliers',
'tag', 'topic',
'users', 'user_address', 'user_bonus', 'user_rank',
'virtual_card', 'volume_price', 'vote', 'vote_option',
'wholesale'
);
foreach ($tables AS $table)
{
$sql = "TRUNCATE `{$prefix}$table`";
$db->query($sql);
}
clear_cache_files();
sys_msg($_LANG['clear_success'], 0);
}
else
{
sys_msg($_LANG['not_permitted'], 1);
}
}
else
{
sys_msg($_LANG['password_incorrect'], 1);
}
}
?>
二、/languages/zh_cn/admin/clear_demo.php
<?php
/**
* ECSHOP 清除体验数据插件 语言文件
* ----------------------------------------------------------------------------
* http://down.admin5.com
* A5源码 致力于php技术
* ----------------------------------------------------------------------------
* 作者: A5技术
* 邮箱: 439854744#qq.com
*/
$_LANG['warning'] = '您可以通过此功能将安装系统时所安装的体验数据全部删除，清除的数据包括用户、商品、订单、文章相关数据。
<br/><br/>注意：您最新添加的数据也会一起删除，请慎重使用此功能，建议先做好数据备份！';
$_LANG['clear'] = '清除';
$_LANG['username'] = '请输入管理员用户名：';
$_LANG['password'] = '请输入管理员密码：';
$_LANG['clear_success'] = '清理成功！';
$_LANG['not_permitted'] = '您输入的不是超级管理员用户名，没有执行此项操作的权限！';
$_LANG['password_incorrect'] = '用户名密码不匹配！';
$_LANG['js_languages']['username_empty'] = '请输入管理员用户名！';
$_LANG['js_languages']['password_empty'] = '请输入管理员密码！';
?>
三、/admin/templates/clear_demo.htm
{include file="pageheader.htm"}
{insert_scripts files="validator.js"}
<div class="main-div">
<ul id="lilist" style="padding:0; margin: 0; list-style-type:none; color: #CC0000;">
<li class="Start315">
{$lang.warning}
</li>
</ul>
<form method="post" action="clear_demo.php" name='theForm' onsubmit="return validate()">
<table width="100%">
<tr>
<td class="label" style="width:15%;">{$lang.username}</td>
<td>
<input type="text" name="username" size="30" /></td>
</tr>
<tr>
<td class="label" style="width:15%;">{$lang.password}</td>
<td>
<input type="password" name="password" size="30" />
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="{$lang.clear}" class="button" />
<input type="hidden" name="act" value="clear" />
</td>
</tr>
</table>
</form>
</div>
<script type="text/javascript">
document.forms['theForm'].elements['username'].focus();
/**
* 检查表单输入的数据
*/
function validate()
{
validator = new Validator("theForm");
validator.required("username", username_empty);
validator.required("password", password_empty);
return validator.passed();
}
</script>
{include file="pagefooter.htm"}
四、编辑/admin/includes/inc_menu.php，添加
$modules['13_backup']['clear_demo'] = 'clear_demo.php?act=start';
五、编辑/languages/zh_cn/admin/common.php，添加
$_LANG['clear_demo'] = '清除体验数据';