if ($row = $result->next()) { $ninetyDayKillID = (int) $row['killID']; } else { $then += 1; } if ($then > $now) { exit; } } while ($ninetyDayKillID === null); $information = $mdb->getCollection("statistics"); Util::out("recent time ranks - first iteration"); $iter = $information->find(); while ($row = $iter->next()) { $type = $row['type']; $id = $row['id']; $killID = getLatestKillID($type, $id, $ninetyDayKillID); if ($killID < $ninetyDayKillID) { continue; } $key = "tq:ranks:recent:{$type}"; $recentKills = getRecent($row['type'], $row['id'], true, $ninetyDayKillID); $recentLosses = getRecent($row['type'], $row['id'], false, $ninetyDayKillID); $update['recentShipsDestroyed'] = (int) $recentKills['killIDCount']; $redis->zAdd("{$key}:shipsDestroyed", (int) $recentKills['killIDCount'], $id); $update['recentPointsDestroyed'] = (int) $recentKills['zkb_pointsSum']; $redis->zAdd("{$key}:pointsDestroyed", (int) $recentKills['zkb_pointsSum'], $id); $update['recentIskDestroyed'] = (int) $recentKills['zkb_totalValueSum']; $redis->zAdd("{$key}:iskDestroyed", (int) $recentKills['zkb_totalValueSum'], $id); $update['recentShipsLost'] = (int) $recentLosses['killIDCount']; $redis->zAdd("{$key}:shipsLost", (int) $recentLosses['killIDCount'], $id); $update['recentPointsLost'] = (int) $recentLosses['zkb_pointsSum'];
$statTypes = ['Destroyed', 'Lost']; $minKillID = $mdb->findField("oneWeek", "killID", [], ['killID' => 1]); $statistics = $mdb->getCollection("statistics"); Util::out("weekly time ranks - first iteration"); $types = []; $iter = $statistics->find(); foreach ($iter as $row) { $type = $row['type']; $id = $row['id']; if ($type == 'corporationID' && $id <= 1999999) { continue; } if ($type == 'shipTypeID' && Info::getGroupID($id) == 29) { continue; } $killID = getLatestKillID($type, $id, $minKillID); if ($killID < $minKillID) { continue; } $types[$type] = true; $key = "tq:ranks:weekly:{$type}:{$today}"; $weeklyKills = getWeekly($row['type'], $row['id'], false, $minKillID); if ($weeklyKills['killIDCount'] == 0) { continue; } $weeklyLosses = getWeekly($row['type'], $row['id'], true, $minKillID); $multi = $redis->multi(); zAdd($multi, "{$key}:shipsDestroyed", $weeklyKills['killIDCount'], $id); zAdd($multi, "{$key}:pointsDestroyed", $weeklyKills['zkb_pointsSum'], $id); zAdd($multi, "{$key}:iskDestroyed", $weeklyKills['zkb_totalValueSum'], $id); zAdd($multi, "{$key}:shipsLost", $weeklyLosses['killIDCount'], $id);