'Time spent on the game server

I'm trying to calculate the total time spent on the server by a Player.

I have a PHP cron job every 5 minutes that will query the details from the server https://developer.valvesoftware.com/wiki/Server_queries

array (
  'id' => '1',
  'name' => 'Player',
  'score' => '3',
  'time' => '1234',
),
array (
  'id' => '2',
  'name' => 'Player 2',
  'score' => '12',
  'time' => '2453',
) + other 100k players.
// The 'time' is starting from 0 seconds when the player join the server, if she leave and then join again the time is starting from 0 seconds

Just adding the live data to DB from the PHP Query

| id | name     | last_score | total_score | last_time | total_time |
| -- | -------- | ---------- | ----------- | --------- | ---------- |
| 1  | Player   | 3          | 0           | 1234      | 0          |
| 2  | Player 2 | 12         | 0           | 2453      | 0          |

I'm not the owner of the servers where the players are online so i can't instantly LOG when the player leaves.

I'm trying to do something like this https://www.gametracker.com/server_info/109.120.135.78:2302/top_players/



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source