111 lines
2.9 KiB
PHP
111 lines
2.9 KiB
PHP
<?php
|
|
include_once("../../../inc/admin.inc.php");
|
|
include_once("../../../inc/class.php");
|
|
include_once("../../../inc/admin.smarty.php");
|
|
include_once("../../../inc/admin.power.php");
|
|
|
|
$GG['page'] = $GG['page'] ? $GG['page'] : 1;
|
|
$GG['maxpage'] = $GG['maxpage'] ? $GG['maxpage'] : 2;
|
|
if($GG['page'] > $GG['maxpage']){
|
|
echo "ok";
|
|
exit;
|
|
}
|
|
$rdate = '2019-11-10';
|
|
$rtime = strtotime($rdate);
|
|
echo $rtime."<br>";
|
|
|
|
/*
|
|
$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']."<br>";
|
|
echo strtotime($v['RDate']) ."<". $rtime."<br>";
|
|
if(strtotime($v['RDate']) < $rtime){
|
|
$r_date = explode(" ",$v['RDate']);
|
|
$n_date = $rdate." ".$r_date[1];
|
|
$save['RegisterDate'] = $n_date;
|
|
echo "OK"."<br>";
|
|
}
|
|
echo strtotime($v['Date']) ."<". $rtime."<br>";
|
|
if(strtotime($v['Date']) < $rtime){
|
|
$d_date = explode(" ",$v['Date']);
|
|
$m_date = $rdate." ".$d_date[1];
|
|
$save['LastLogonDate'] = $m_date;
|
|
echo "OK"."<br>";
|
|
}
|
|
//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 '<script>location.href="?page='.$page.'&maxpage='.$all['page']['maxPage'].'&time='.time().'";</script>';
|
|
$db->close();
|
|
unset($GG,$ppxq,$db);
|
|
?>
|