101 lines
3.2 KiB
PHP
101 lines
3.2 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");
|
|
|
|
/*
|
|
公会欢乐场补kind
|
|
*/
|
|
/*
|
|
$kinds = [2,6,200,210,430,502,558];
|
|
$info = $db->fetch_all("select * from QPTreasureDB.dbo.GameUnion WHERE UnionGoldOpen='1' order by UnionID desc");
|
|
foreach($info as $k => $v ){
|
|
$u = $db->fetch_all("select KindID from QPTreasureDB.dbo.GameUnionKind WHERE UnionID='".$v['UnionID']."'");
|
|
$ua = array_column($u, 'KindID');
|
|
foreach($kinds as $ka => $va){
|
|
if(!in_array($va,$ua)){
|
|
$db->insert('QPTreasureDB.dbo.GameUnionKind',[
|
|
'UnionID' => $v['UnionID'],
|
|
'KindID' => $va,
|
|
'UnionGoldLimit' => 100,
|
|
'ScoreMultiple' => 1,
|
|
'GameGold' => 3
|
|
]);
|
|
}
|
|
}
|
|
}
|
|
*/
|
|
|
|
/*
|
|
$yue = "2017-06";
|
|
$day = $GG['day'] ? $GG['day'] : 1;
|
|
$max = date('t', strtotime($yue));
|
|
if($day <= $max){
|
|
if($day<10){
|
|
$sj = $yue."-"."0".$day;
|
|
}else{
|
|
$sj = $yue."-".$day;
|
|
}
|
|
$info = $db->fetch_all("select * from CountUserJf WHERE Days='".$sj."' order by CujID desc");
|
|
echo $sj."<br>";
|
|
foreach($info as $k => $v ){
|
|
$u = $db->fetch_one("select * from CountJf WHERE Month='".$yue."' and UserID='".$v['UserID']."'");
|
|
if($u){
|
|
$save = ['Hit'=>($u['Hit']+$v['Hit']),'Jf'=>($u['Jf']+$v['Jf']),'Jfz'=>($u['Jfz']+$v['Jfz']),'Jfs'=>($u['Jfs']+$v['Jfs'])];
|
|
$db->update('CountJf',$save,"Month='".$yue."' and UserID='".$v['UserID']."'");
|
|
echo $v['UserID']."修改<br>";
|
|
}else{
|
|
$save = ['UserID'=>$v['UserID'],'Month'=>$yue,'Hit'=>$v['Hit'],'Jf'=>$v['Jf'],'Jfz'=>$v['Jfz'],'Jfs'=>$v['Jfs']];
|
|
$db->insert('CountJf',$save);
|
|
echo $v['UserID']."添加<br>";
|
|
}
|
|
}
|
|
$day++;
|
|
echo "<script>location.href='?day=".$day."';</script>";
|
|
}else{
|
|
echo "end";
|
|
}*/
|
|
|
|
|
|
|
|
/*
|
|
//校队月积分
|
|
$info = $db->fetch_all("select * from CountUserJf WHERE Days='2017-05-31' order by CujID desc");
|
|
echo "2017-05-31<br>";
|
|
foreach($info as $k => $v ){
|
|
$u = $db->fetch_one("select * from CountJf WHERE Month='2017-05' and UserID='".$v['UserID']."'");
|
|
if($u){
|
|
$save = ['Hit'=>($u['Hit']+$v['Hit']),'Jf'=>($u['Jf']+$v['Jf']),'Jfz'=>($u['Jfz']+$v['Jfz']),'Jfs'=>($u['Jfs']+$v['Jfs'])];
|
|
$db->update('CountJf',$save,"Month='2017-05' and UserID='".$v['UserID']."'");
|
|
echo $v['UserID']."修改<br>";
|
|
}else{
|
|
$save = ['UserID'=>$v['UserID'],'Month'=>'2017-05','Hit'=>$v['Hit'],'Jf'=>$v['Jf'],'Jfz'=>$v['Jfz'],'Jfs'=>$v['Jfs']];
|
|
$db->insert('CountJf',$save);
|
|
echo $v['UserID']."添加<br>";
|
|
}
|
|
}*/
|
|
//$db->deldate("CountJf","Month='2017-05'");
|
|
|
|
|
|
//把经验值转换成元宝
|
|
/*$user = $db->fetch_all("select * from QPTreasureDB.dbo.GameScoreInfo WHERE Grade>30 order by UserID desc");
|
|
foreach($user as $k => $v ){
|
|
$save = ['YuanBao'=>intval($v['Grade']/2)];
|
|
$db->update('QPTreasureDB.dbo.GameScoreInfo',$save,"UserID='".$v['UserID']."'");
|
|
echo $v['UserID']."修改<br>";
|
|
}*/
|
|
|
|
|
|
//清空月记录
|
|
//$db->query("TRUNCATE TABLE CountJf");
|
|
//清空元宝记录
|
|
//$db->query("TRUNCATE TABLE YuanBaoDay");
|
|
//$db->query("TRUNCATE TABLE YuanBaoLog");
|
|
//$db->query("TRUNCATE TABLE ShopLog");
|
|
//清除标记
|
|
//$db->update("CountJf",['YuanBao'=>0],'CjID>0');
|
|
//$db->update("CountUserJf",['YuanBao'=>0],'CujID>0');
|
|
//清除抽奖数据
|
|
//$db->update("QPTreasureDB.dbo.GameScoreInfo",['YuanBao'=>0,'LotteryHit'=>0,'LotteryGame'=>0],"UserID>'1'");
|
|
?>
|