107 lines
3.5 KiB
PHP
107 lines
3.5 KiB
PHP
|
<?php
|
|||
|
|
include_once("../../../inc/admin.inc.php");
|
|||
|
|
include_once("../../../inc/admin.config.php");
|
|||
|
|
include_once("../../../inc/class.php");
|
|||
|
|
include_once("../../../inc/admin.smarty.php");
|
|||
|
|
include_once("../../../inc/admin.power.php");
|
|||
|
|
include_once("../../../inc/ip.php");
|
|||
|
|
include_once("../../../inc/virtual.php");
|
|||
|
|
$GG=$db->getpost($GG,"id|num,sy|num,yx|num,jy|num");
|
|||
|
|
if($GG['submit']){
|
|||
|
|
if($GG['pass']==$CONFIG['ADMIN']['pass']){
|
|||
|
|
if($GG['title'] && $GG['time'] && $GG['prize']){
|
|||
|
|
$save = [
|
|||
|
|
"Htitle"=>$GG['title'],
|
|||
|
|
"Hshow"=>$GG['show'],
|
|||
|
|
"HPrize"=>$GG['prize'],
|
|||
|
|
"Htime"=>$GG['time'],
|
|||
|
|
"Hdef"=>$GG['def'] ? 1 : 0,
|
|||
|
|
"Hclose"=>$GG['close'] ? 1 : 0,
|
|||
|
|
];
|
|||
|
|
if($GG['id']){
|
|||
|
|
$db->update('HuoDong',$save,"Hdid='".$GG['id']."'");
|
|||
|
|
}else{
|
|||
|
|
$db->insert("HuoDong",$save);
|
|||
|
|
}
|
|||
|
|
$ppxq -> assign('Edit_Ok',"<EFBFBD>ijɹ<EFBFBD><EFBFBD><EFBFBD>");
|
|||
|
|
}else{
|
|||
|
|
$ppxq -> assign('Edit_Error',"<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
|
|||
|
|
}
|
|||
|
|
}else{
|
|||
|
|
$ppxq -> assign('Edit_Error',"<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if($GG['ok']){
|
|||
|
|
$ppxq -> assign('Edit_Ok',"<EFBFBD><EFBFBD>ֵ<EFBFBD>ɹ<EFBFBD><EFBFBD><EFBFBD>");
|
|||
|
|
}
|
|||
|
|
$nr = $db->fetch_one("select * from HuoDong where Hdid='".$GG['id']."'");
|
|||
|
|
if($nr){
|
|||
|
|
$jp_arr = explode(",",$nr['HPrize']);
|
|||
|
|
$hdy_arr = explode(",",$nr['Htime']);
|
|||
|
|
foreach($hdy_arr as $k => $v){
|
|||
|
|
$where .= $where ? " or month='".$v."'" : " month='".$v."'";
|
|||
|
|
$use = $db->fetch_all("select top 500 *,(Hit-(Niu-Niu/4)) as Pm from CountJf where month='".$v."' order by Pm desc");
|
|||
|
|
foreach($use as $ka => $va){
|
|||
|
|
$user_pp[$va['UserID']] += $va['Pm'];
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if($user_pp){
|
|||
|
|
arsort($user_pp);
|
|||
|
|
$i = 1;
|
|||
|
|
foreach($user_pp as $ka => $va){
|
|||
|
|
if($i <=count($jp_arr)){
|
|||
|
|
$user[$ka]=$va;
|
|||
|
|
}
|
|||
|
|
$i++;
|
|||
|
|
}
|
|||
|
|
$info = $db->fetch_all("select a.UserID,a.GameID,a.NickName,a.Gender,b.HeadHttp,c.Grade from AccountsInfo as a LEFT JOIN IndividualDatum as b ON(a.UserID=b.UserID) LEFT JOIN QPTreasureDB.dbo.GameScoreInfo AS c ON(a.UserID=c.UserID) where a.UserID in (".implode(',',array_keys($user)).") ");
|
|||
|
|
foreach($info as $kb => $vb){
|
|||
|
|
$info[$kb]['Pm'] = $user[$vb['UserID']];
|
|||
|
|
$info[$kb]['HeadHttp'] = $info[$kb]['HeadHttp'];
|
|||
|
|
}
|
|||
|
|
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <20><><EFBFBD><EFBFBD>
|
|||
|
|
foreach($vdata as $k => $v){
|
|||
|
|
$xnjs = 0;
|
|||
|
|
foreach($hdy_arr as $ka => $va){
|
|||
|
|
$xnjs_ar = vmdate($vdata[$k],$va);
|
|||
|
|
$xnjs += ($xnjs_ar['data']['Mj']+$xnjs_ar['data']['Ddz']+$xnjs_ar['data']['Dz']+intval($xnjs_ar['data']['Niu']/4));
|
|||
|
|
}
|
|||
|
|
$xninfo[]=[
|
|||
|
|
'NickName' => $v['name'],
|
|||
|
|
'Gender' => $v['sex'],
|
|||
|
|
'Grade' => vmdata($vdata[$k]),
|
|||
|
|
'Pm' => $xnjs,
|
|||
|
|
'HeadHttp' => $v['tx']
|
|||
|
|
];
|
|||
|
|
}
|
|||
|
|
$uss = array_merge($xninfo,$info);
|
|||
|
|
$data = arraySequence($uss,'Pm');
|
|||
|
|
}else{
|
|||
|
|
$info = $db->fetch_all("select top 30 a.UserID,c.GameID,c.NickName,c.Gender,b.HeadHttp,a.ConsumeScore,a.InsureScore,a.PlayCount,a.Grade from QPTreasureDB.dbo.GameScoreInfo as a LEFT JOIN IndividualDatum as b ON(a.UserID=b.UserID) LEFT JOIN AccountsInfo AS c ON(a.UserID=c.UserID) where a.Grade>50 order by Grade desc");
|
|||
|
|
foreach($info as $kb => $vb){
|
|||
|
|
$info[$kb]['Pm'] = 0;
|
|||
|
|
$info[$kb]['HeadHttp'] = $info[$kb]['HeadHttp'];
|
|||
|
|
}
|
|||
|
|
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
foreach($vdata as $k => $v){
|
|||
|
|
$xninfo[]=[
|
|||
|
|
'NickName' => $v['name'],
|
|||
|
|
'Gender' => $v['sex'],
|
|||
|
|
'Pm' => 0,
|
|||
|
|
'Grade' => vmdata($vdata[$k]),
|
|||
|
|
'HeadHttp' => $v['tx']."??"
|
|||
|
|
];
|
|||
|
|
}
|
|||
|
|
$uss = array_merge($xninfo,$info);
|
|||
|
|
$data = $db->array_sort($uss,'Grade','desc');
|
|||
|
|
}
|
|||
|
|
$ppxq -> assign('hdy_arr',$hdy_arr);
|
|||
|
|
$ppxq -> assign('jpin',$jp_arr);
|
|||
|
|
$ppxq -> assign('data',$data);
|
|||
|
|
}
|
|||
|
|
$ppxq -> assign('info',$nr);
|
|||
|
|
$ppxq -> assign('GG',$GG);
|
|||
|
|
$ppxq -> display('user/huodong_add.tpl');
|
|||
|
|
$db->close();
|
|||
|
|
unset($GG,$ppxq,$db);
|
|||
|
|
?>
|