58 lines
1.4 KiB
PHP
58 lines
1.4 KiB
PHP
<?php
|
|
include("include/config.inc.php");
|
|
|
|
$conn = $GLOBALS["conn"];//定义公共的数据库连接
|
|
$myredis = $GLOBALS['myredis'];////连接redis
|
|
|
|
|
|
//清除redis
|
|
//$myredis->flushdb();//清空当前表
|
|
$clear_reids = $myredis->flushall();//清空所有表
|
|
if($clear_reids){
|
|
echo "clear <font color='#56B501'>redis</font> succ.";
|
|
}else{
|
|
echo "clear <font color='#f00'>redis</font> fail.";
|
|
}
|
|
|
|
//清空数据库
|
|
$tables_arr = array(
|
|
'game_member_friends',
|
|
'game_member',
|
|
'game_member_third',
|
|
'game_member_prop',
|
|
'game_global_gold_log',
|
|
'game_global_order',
|
|
'game_member_login_log',
|
|
'game_member_banned',
|
|
'game_global_lottery_log',
|
|
'game_member_goods',
|
|
'game_member_store',
|
|
'game_member_share_log',
|
|
'game_flower_field',
|
|
'game_member_grade_log',
|
|
'game_member_flower_field_log',
|
|
'game_member_flower_water_log',
|
|
'game_member_flower_ferti_log',
|
|
'game_member_flower_plant_log',
|
|
'game_member_exp_log',
|
|
'game_member_flower_reward_log',
|
|
'game_num',
|
|
'game_member_factory',
|
|
'game_member_goods_log',
|
|
'game_member_factory_upgrade_log',
|
|
'game_member_factory_output_log',
|
|
'game_member_factory_reward_log'
|
|
);
|
|
|
|
foreach($tables_arr as $k=>$v){
|
|
echo "<br />";
|
|
$sql = "truncate table ".get_table($v);
|
|
$query = $conn->Query($sql);
|
|
if($query){
|
|
echo "clear table <font color='#56B501'>".$v."</font> succ.";
|
|
}else{
|
|
echo "clear table <font color='#f00'>".$v."</font> fail.";
|
|
}
|
|
}
|
|
|