按照数组的形式排序+条件切换切换查询

最新推荐文章于 2024-08-27 23:09:17 发布

最新推荐文章于 2024-08-27 23:09:17 发布 · 79 阅读

本文介绍了一种从游戏战斗记录中提取玩家战绩并按多种指标进行排名的方法。该方法支持按总战斗次数、胜利次数、失败次数、击杀数及死亡数等指标进行排序，并能针对指定时间段内的数据进行筛选。

//TOP50 public static function getTOP50 ($fromTime='',$endTime='',$type='warAllNum' ) { $fromTime = str_replace("-", "", substr($fromTime, 0, 10)); $endTime = str_replace("-", "", substr($endTime, 0, 10)); $data = self::getDayCount($fromTime,$endTime); $type_A = array('warAllNum','warWinNum','warFailNum','killNum','deadNum') ; if(!in_array($type,$type_A)) return false; $result = array_column_sort($data, "$type", $sortDirection = SORT_DESC) ; $result = array_slice($result,0,50); return $result; }

-----------------------------------
按照$type进行排序，$type是array格式， $type_A = array('warAllNum','warWinNum','warFailNum','killNum','deadNum') ; if(!in_array($type,$type_A)) return false; $result = array_column_sort($data, "$type", $sortDirection = SORT_DESC) ;//按照$type排序

==========================================================================================

----------------------------------------------------------------------------

public static function showbattleresult($ifuser = 1, $starttime = 0, $endtime = 0, $ifwin = 1){ $returnarr = array();//提前定义可以提高执行效率 $sqladd= ""; $column = $ifuser ? "userid" : "union_id"; $starttime && $sqladd = " and time >=" . $starttime; $endtime && $sqladd .= " and time <=" . $endtime; $sql = "SELECT $column, activearmy_id, count( * ) as num FROM `tb_log_activearmy` WHERE outcome=" . $ifwin . " " . $sqladd . " GROUP BY $column, `activearmy_id`"; // return $sql; $ret = mysql_query($sql); while($row = mysql_fetch_assoc($ret)){ $returnarr[$row[$column]][$row['activearmy_id']] = $row['num']; $returnarr[$row[$column]]['total'] = isset($returnarr[$row[$column]]['total']) ? $returnarr[$row[$column]]['total'] + $row['num'] : $row['num']; $returnarr[$row[$column]]['id'] = $row[$column]; } return $returnarr; } -------------------------------------------前提：表里面同时有这两个字段，切换用户id，和联盟id:$column = $ifuser ? "userid" : "union_id";三元目运算