$GG['maxpage']){
echo "ok";
exit;
}
$rdate = '2019-11-10';
$rtime = strtotime($rdate);
echo $rtime."
";
/*
$db->deldate("QPTreasureDB.dbo.GameUnionGold","InsertTime<'2019-05-01'");
/*
$db->deldate("QPTreasureDB.dbo.GameUnionDay","UnionDay<'".$rdate."'");
$db->deldate("QPTreasureDB.dbo.GameUnionMonth","UnionMonth<'2019-11'");
$db->deldate("QPTreasureDB.dbo.GameUnionCard","InsertTime<'".$rdate."'");
$db->deldate("QPTreasureDB.dbo.GameUnionConsumer","InsertTime<'".$rdate."'");
*/
/*
$db->deldate("ShopLog","ShopLogTime<'".$rdate."'");
$db->deldate("SystemStreamInfo","CollectDate<'".$rdate."'");
*/
/*
$db->deldate("YuanBaoDay","Day<'".$rdate."'");
$db->deldate("YuanBaoLog","LoTime<'".$rdate."'");
*/
/*
$db->deldate("CountJf","Month<'2019-11'");
*/
/*6
$db->deldate("CountUserJf","Days<'".$rdate."'");
*/
/*5
$db->deldate("QPTreasureDB.dbo.RecordUserInout","convert(varchar(10),EnterTime,120)<'".$rdate."'");
*/
/*4
$db->deldate("QPTreasureDB.dbo.GameScoreLog","convert(varchar(10),CostTime,120)<'".$rdate."'");
*/
/*3
$db->deldate("QPTreasureDB.dbo.PayToPlayerLog","convert(varchar(10),InsertTime,120)<'".$rdate."'");
*/
/*2
$db->deldate("AgentRecharge","convert(varchar(10),AddDate,120)<'".$rdate."'");
*/
/*1
$all = $db->page([
"sql"=>"select *,convert(char,RegisterDate,120) as RDate,convert(char,LastLogonDate,120) as Date from QPTreasureDB.dbo.GameScoreInfo order by UserID asc",
"count"=>"select count(*) from QPTreasureDB.dbo.GameScoreInfo",
"key"=>"UserID",
"table"=>"QPTreasureDB.dbo.GameScoreInfo",
"order"=>"UserID asc",
"page" =>$GG['page'],
"pageSize"=>100
]);
foreach ($all['data'] as $k => $v){
if($v['UserID']){
$save = [];
echo $v['UserID']."
";
echo strtotime($v['RDate']) ."<". $rtime."
";
if(strtotime($v['RDate']) < $rtime){
$r_date = explode(" ",$v['RDate']);
$n_date = $rdate." ".$r_date[1];
$save['RegisterDate'] = $n_date;
echo "OK"."
";
}
echo strtotime($v['Date']) ."<". $rtime."
";
if(strtotime($v['Date']) < $rtime){
$d_date = explode(" ",$v['Date']);
$m_date = $rdate." ".$d_date[1];
$save['LastLogonDate'] = $m_date;
echo "OK"."
";
}
//print_r($save);
if($save){
$db->update('AccountsInfo',$save,"UserID='".$v['UserID']."'");
$db->update('QPTreasureDB.dbo.GameScoreInfo',$save,"UserID='".$v['UserID']."'");
}
}
}
*/
//$page = $all['page']['page']+1;
//echo $GG['page'].'/'.$all['page']['maxPage'];
//echo '';
$db->close();
unset($GG,$ppxq,$db);
?>