$data1 = $connect->query("SELECT * FROM `players` ORDER BY `last_char_update` ASC LIMIT 100");
while($data = $data1->fetch_array()){
$id = $data['id'];
$players = $data['id'];
$frags_all = 0;
$q = $connect->query("SELECT players.name AS player_name, player_deaths.player_id AS killed_id, player_killers.kill_id AS kill_id, players.deleted AS player_exists
FROM killers LEFT JOIN player_killers ON killers.id = player_killers.kill_id LEFT JOIN players ON players.id = player_killers.player_id
LEFT JOIN player_deaths ON killers.death_id = player_deaths.id
WHERE player_killers.player_id = ".(int) $id." GROUP BY player_deaths.player_id");
while($t = $q->fetch_array())
$frags_all++;
$connect->query("UPDATE `players` SET `last_char_update` = ". (int) time().", `addons` = ". (int) $addons .", `huntered` = ". (int) $huntered .", `frags_all` = " . (int) $frags_all. " WHERE `id` = ". (int) $id . "");
}
$data1->close();