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."
";
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']."修改
";
}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']."添加
";
}
}
$day++;
echo "";
}else{
echo "end";
}*/
/*
//校队月积分
$info = $db->fetch_all("select * from CountUserJf WHERE Days='2017-05-31' order by CujID desc");
echo "2017-05-31
";
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']."修改
";
}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']."添加
";
}
}*/
//$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']."修改
";
}*/
//清空月记录
//$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'");
?>