<?php

class Positivus_Html_Sidebar_Game_Status {

  public static function getServers(){
    $output = [];

    $db = XenForo_Application::getDb();
    $servers = $db->fetchAssoc('SELECT name, reachable, last_online, player_count FROM pos_game_servers');

    foreach($servers as $server){
      $item = [];
      $item['name'] = $server['name'];
      $item['online'] = (bool)$server['reachable'];
      $item['last_online'] = $server['last_online'];
      $item['players'] = $server['player_count'] ? ($server['player_count'] == 1 ? '1 Player' : $server['player_count'].' Players') : 'Empty';
      $output[] = $item;
    }

    return $output;
  }

}