コード例 #1
0
    $retVal = 0;
    $query = 'SELECT round_id FROM round WHERE round_character1_id = :id OR round_character2_id = :id';
    $result = Lib\Db::Query('SELECT COUNT(1) AS total, SUM(CASE WHEN character_id = :id THEN 1 ELSE 0 END) AS character_votes FROM votes WHERE round_id IN (' . $query . ') AND user_id IN (' . implode(',', $users) . ')', [':id' => $char->id]);
    if ($result && $result->count) {
        $row = Lib\Db::Fetch($result);
        $retVal = (int) $row->character_votes / (int) $row->total;
    }
    return $retVal;
}
$projections = [];
// Get the current voting round
$rounds = Api\Round::getCurrentRounds(AI_BRACKET_ID);
foreach ($rounds as $round) {
    // Data gathering
    $char1 = Api\Character::getById($round->character1Id);
    $char2 = Api\Character::getById($round->character2Id);
    $nonLoyalists = getNonLoyalists($char1, $char2);
    $char1->loyalists = getLoyalists($char1, $char2);
    $char2->loyalists = getLoyalists($char2, $char1);
    $char1->sourceStrength = getSourceStrength($char1, $nonLoyalists);
    $char2->sourceStrength = getSourceStrength($char2, $nonLoyalists);
    $char1->percentOfTimesVotedFor = getPercentTimesVotedFor($char1, $nonLoyalists);
    $char2->percentOfTimesVotedFor = getPercentTimesVotedFor($char2, $nonLoyalists);
    // Below is the scientific explanation as penned by Chris Hackmann
    // The percentage of voters who are not loyal to one character or the other
    $nonLoyalistPercentage = 1 - ($char1->loyalists->percent + $char2->loyalists->percent);
    // Determine which character is voted for more often overall
    $bestCharacter = $char1->percentOfTimesVotedFor > $char2->percentOfTimesVotedFor ? $char1 : $char2;
    $worstCharacter = $char1->percentOfTimesVotedFor > $char2->percentOfTimesVotedFor ? $char2 : $char1;
    // The popularity ration represents how many votes the best character gets for each vote for the worst character
    $popularityRatio = $bestCharacter->percentOfTimesVotedFor / $worstCharacter->percentOfTimesVotedFor;
コード例 #2
0
<?php

require 'lib/aal.php';
$db = Lib\Mongo::getDatabase();
$characterRankingInfo = $db->characterRankingInfo;
$result = Lib\Db::Query('SELECT * FROM `character` WHERE bracket_id = 6 AND (SELECT COUNT(1) FROM round WHERE round_tier > 0 AND (round_character1_id = character_id OR round_character2_id = character_id)) > 0');
while ($row = Lib\Db::Fetch($result)) {
    $character = new Api\Character($row);
    echo $character->name, '...';
    $obj = new stdClass();
    $obj->characterId = (int) $character->id;
    $obj->performance = round($character->getAverageRoundPerformance(true) * 100);
    $obj->alsoVotedFor = $character->getCharactersAlsoVotedFor(false, true);
    $obj->sameSourceVotes = $character->getCharactersAlsoVotedFor(true, true);
    // JSON encode/decode the object to strip private keys
    $obj = json_decode(json_encode($obj));
    // Check for this character in the collection so we can update the existing record. This is intentionally
    // done after the JSON bullshit above to make sure the object is correctly represented
    $record = $characterRankingInfo->findOne(['characterId' => $character->id]);
    if ($record) {
        $obj->_id = $record['_id'];
    }
    $characterRankingInfo->save($obj);
    echo 'DONE', PHP_EOL;
}