Exemplo n.º 1
0
    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'];
Exemplo n.º 2
0
$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);