query("TRUNCATE TABLE Error"); echo ""; exit; } if($GG['jc'] == 'fk'){ $where = " where a.Fk!='0'"; }elseif($GG['jc'] == 'yb'){ $where = " where a.Yb!='0'"; } $sql = "select a.*,convert(char,a.DateTime,120) as Date,c.GameID,c.NickName,y.UnionID,y.UnionName,d.HeadHttp from Error as a LEFT JOIN AccountsInfo as c ON(a.UserID=c.UserID) LEFT JOIN IndividualDatum as d ON(a.UserID=d.UserID) LEFT JOIN QPTreasureDB.dbo.GameScoreInfo AS x ON(a.UserID=x.UserID) LEFT JOIN QPTreasureDB.dbo.GameUnion As y ON(x.UnionID=y.UnionID) ".$where." order by Eid desc"; $data = $db->page([ "sql"=>$sql, "count"=>"select count(*) from Error ".str_ireplace("a.","",$where), "key"=>"Eid", "table"=>"Error", "where"=>str_ireplace("a.","",$where), "order"=>"Eid desc", "page"=>$GG['page'], "pageSize"=>$GG['pagelist'] ? $GG['pagelist'] : 100 ]); if($data['data']){ foreach($data['data'] as $k => $v){ $info[$k] = $v; $info[$k]['data'] = json_decode($v['Error'],true); $info[$k]['Date'] = strtotime($info[$k]['Date']); } } $ppxq -> register_function('timename','timename'); $ppxq -> assign('data',$info); $ppxq -> assign('Pagenum',pages()); $ppxq -> assign('Link',"pagelist=".$GG['pagelist']."&kid=".$GG['kid']."&key=".$GG['key']."&order=".$GG['order']); $ppxq -> assign('Pages',$data['page']); $ppxq -> assign('GG',$GG); $ppxq -> display('user/jc.tpl'); $db->close(); unset($GG,$ppxq,$db); ?>