public List <Player> GetPlayersByPosition(int node)
{
var connection = _databaseService.GetConnection();
var players = connection.Query <Player>(
"SELECT * FROM players WHERE node = @node",
new {
node
});
connection.Close();
return(players.Where(x => _socketRepository.IsPlayerOnline(x.Id)).ToList());
}
