Website LastKills nao atualiza com horário certo!

[eduardobarbosa 0]

The Forgotten Server 1.3, 12.20

 

Olá, estou com um problema no site do servidor, aparentemente as últimas mortes estão todas atualizando para o mesmo horário e eu nao consigo resolver.

 

 

lastkills.php

Spoiler

<?php
/**
 * Last kills
 *
 * @package   MyAAC
 * @author    Gesior <[email protected]>
 * @author    Slawkens <[email protected]>
 * @copyright 2019 MyAAC
 * @link     https://my-aac.org
 */
defined('MYAAC') or die('Direct access not allowed!');
$title = 'Last Kills';

$last_kills = array();
$players_deaths_count = 0;

$tmp = null;
if($cache->enabled() && $cache->fetch('last_kills', $tmp)) {
    $last_kills = unserialize($tmp);
}
else {
    if($db->hasTable('player_killers')) // tfs 0.3
    {
        $players_deaths = $db->query('SELECT `player_deaths`.`id`, `player_deaths`.`date`, `player_deaths`.`level`, `players`.`name`' . ($db->hasColumn('players', 'world_id') ? ', `players`.`world_id`' : '') . ' FROM `player_deaths` LEFT JOIN `players` ON `player_deaths`.`player_id` = `players`.`id` ORDER BY `date` DESC LIMIT 0, ' . $config['last_kills_limit']);

        if(!empty($players_deaths)) {
            foreach($players_deaths as $death) {
                $players_deaths_count++;
                $killers_string = getPlayerLink($death['name']) . ' ';
                $killer_name = '';

                $killers = $db->query("SELECT environment_killers.name AS monster_name, players.name AS player_name, players.deleted AS player_exists FROM killers LEFT JOIN environment_killers ON killers.id = environment_killers.kill_id LEFT JOIN player_killers ON killers.id = player_killers.kill_id LEFT JOIN players ON players.id = player_killers.player_id WHERE killers.death_id = '" . $death['id'] . "' ORDER BY killers.final_hit DESC, killers.id ASC")->fetchAll();

                $i = 0;
                $count = count($killers);
                foreach($killers as $killer) {
                    $i++;
                    if($killer['player_name'] != "") {
                        if($i == 1) {
                            if($count <= 4)
                                $killers_string .= 'killed';
                            else if($count > 4 and $count < 10)
                                $killers_string .= 'slain';
                            else if($count > 9 and $count < 15)
                                $killers_string .= 'crushed';
                            else if($count > 14 and $count < 20)
                                $killers_string .= 'eliminated';
                            else if($count > 19)
                                $killers_string .= 'annihilated';
                            $killers_string .= ' at level <b>' . $death['level'] . '</b> ';
                        } else if($i == $count)
                            $killers_string .= ' and';
                        else
                            $killers_string .= ',';

                        $killers_string .= ' by ';
                        if($killer['monster_name'] != '')
                            $killers_string .= $killer['monster_name'] . ' summoned by ';

                        if($killer['player_exists'] == 0)
                            $killers_string .= getPlayerLink($killer['player_name']);
                    } else {
                        if($i == 1)
                            $killers_string .= 'died at level <b>' . $death['level'] . '</b>';
                        else if($i == $count)
                            $killers_string .= ' and';
                        else
                            $killers_string .= ',';

                        $killers_string .= ' by ' . $killer['monster_name'];
                    }
                }

                $killers_string .= '.';

                $last_kills[] = array(
                    'id' => $players_deaths_count,
                    'date' => $death['date'],
                    'killers_string' => $killers_string,
                    'world_id' => isset($config['worlds'][(int)$death['world_id']]) ? $config['worlds'][(int)$death['world_id']] : null,
                );
            }
        }
    } else {
        //$players_deaths = $db->query("SELECT `p`.`name` AS `victim`, `player_deaths`.`killed_by` as `killed_by`, `player_deaths`.`time` as `time`, `player_deaths`.`is_player` as `is_player`, `player_deaths`.`level` as `level` FROM `player_deaths`, `players` as `d` INNER JOIN `players` as `p` ON player_deaths.player_id = p.id WHERE player_deaths.`is_player`='1' ORDER BY `time` DESC LIMIT " . $config['last_kills_limit'] . ";");

        $players_deaths = $db->query("SELECT `p`.`name` AS `victim`, `d`.`killed_by` as `killed_by`, `d`.`time` as `time`, `d`.`level`, `d`.`is_player` FROM `player_deaths` as `d` INNER JOIN `players` as `p` ON d.player_id = p.id ORDER BY `time` DESC LIMIT " . $config['last_kills_limit'] . ";");
        if(!empty($players_deaths)) {
            foreach($players_deaths as $death) {
                $killers_string .= getPlayerLink($death['victim']) . ' died at level ' . $death['level'] . ' by ';
                if($death['is_player'] == '1')
                    $killers_string .= getPlayerLink($death['killed_by']);
                else
                    $killers_string .= $death['killed_by'];

                $killers_string .= '.';

                $last_kills[] = array(
                    'id' => $players_deaths_count,
                    'date' => $death['date'],
                    'killers_string' => $killers_string,
                );
            }
        }
    }

    if($cache->enabled()) {
        $cache->set('last_kills', serialize($last_kills), 120);
    }
}

$twig->display('lastkills.html.twig', array(
    'lastkills' => $last_kills
));

 

Imagem do bug:

Spoiler

 

 

 

Editado 2 Dezembro, 2019 por eduardobarbosa

[Majesty 1755]

Resolvido em:

https://github.com/slawkens/myaac/commit/be9ce34dc8fa0108395fac4bb1e425480eb2ce23