public bool IsSame(ArenaPlayerData _ArenaPlayerData) { if (TeamName != _ArenaPlayerData.TeamName) { return(false); } if (TeamRating != _ArenaPlayerData.TeamRating) { return(false); } if (GamesPlayed != _ArenaPlayerData.GamesPlayed) { return(false); } if (GamesWon != _ArenaPlayerData.GamesWon) { return(false); } if (PlayerPlayed != _ArenaPlayerData.PlayerPlayed) { return(false); } if (PlayerRating != _ArenaPlayerData.PlayerRating) { return(false); } return(true); }
private void InitData(string _ArenaDataString) { try { if (_ArenaDataString == "") { return; } string[] arenaDatas = _ArenaDataString.Split(new char[] { ',' }); foreach (string arenaData in arenaDatas) { string[] arenaPlayerData = arenaData.Split(new char[] { ':' }); int teamSize = int.Parse(arenaPlayerData[1]); ArenaPlayerData newData = new ArenaPlayerData(); newData.TeamName = arenaPlayerData[0]; newData.TeamRating = int.Parse(arenaPlayerData[2]); newData.GamesPlayed = int.Parse(arenaPlayerData[3]); newData.GamesWon = int.Parse(arenaPlayerData[4]); newData.PlayerPlayed = int.Parse(arenaPlayerData[5]); newData.PlayerRating = int.Parse(arenaPlayerData[6]); if (teamSize == 2) { Team2v2 = newData; } else if (teamSize == 3) { Team3v3 = newData; } else if (teamSize == 5) { Team5v5 = newData; } else { throw new Exception("Unknown Arena Team Size: \"" + teamSize + "\""); } } } catch (Exception) { } }
public bool GetPlayerArenaData(SQLArenaInfo _ArenaInfo, out PlayerData.ArenaData _ResultArenaData) { _ResultArenaData = null; if (_ArenaInfo.IsNull() == true) { return(false); } int[] teamIDs = new int[3]; int teamIDsCounter = 0; if (_ArenaInfo.Team2v2 != 0) { teamIDs[teamIDsCounter++] = _ArenaInfo.Team2v2; } if (_ArenaInfo.Team3v3 != 0) { teamIDs[teamIDsCounter++] = _ArenaInfo.Team3v3; } if (_ArenaInfo.Team5v5 != 0) { teamIDs[teamIDsCounter++] = _ArenaInfo.Team5v5; } if (teamIDs.Length > teamIDsCounter) { int[] oldTeamIDs = teamIDs; teamIDs = new int[teamIDsCounter]; for (int i = 0; i < teamIDsCounter; ++i) { teamIDs[i] = oldTeamIDs[i]; } } var conn = OpenConnection(); try { const int ID_COLUMN = 0; const int TEAMNAME_COLUMN = 1; const int TEAMRATING_COLUMN = 2; const int GAMESPLAYED_COLUMN = 3; const int GAMESWON_COLUMN = 4; const int PLAYERGAMESPLAYED_COLUMN = 5; const int PLAYERRATING_COLUMN = 6; using (var cmd = new NpgsqlCommand("SELECT id, teamname, teamrating, gamesplayed, gameswon, playergamesplayed, playerrating FROM PlayerArenaDataTable WHERE id = ANY(:IDs)", conn)) { { var idsParam = new NpgsqlParameter("IDs", NpgsqlDbType.Array | NpgsqlDbType.Integer); idsParam.Value = teamIDs; cmd.Parameters.Add(idsParam); } using (var reader = cmd.ExecuteReader()) { if (reader.HasRows == true) { _ResultArenaData = new PlayerData.ArenaData(); while (reader.Read() == true) { var arenaTeamData = new PlayerData.ArenaPlayerData(); int id = reader.GetInt32(ID_COLUMN); arenaTeamData.TeamName = reader.GetString(TEAMNAME_COLUMN); arenaTeamData.TeamRating = reader.GetInt32(TEAMRATING_COLUMN); arenaTeamData.GamesPlayed = reader.GetInt32(GAMESPLAYED_COLUMN); arenaTeamData.GamesWon = reader.GetInt32(GAMESWON_COLUMN); arenaTeamData.PlayerPlayed = reader.GetInt32(PLAYERGAMESPLAYED_COLUMN); arenaTeamData.PlayerRating = reader.GetInt32(PLAYERRATING_COLUMN); if (id == _ArenaInfo.Team2v2) { _ResultArenaData.Team2v2 = arenaTeamData; } if (id == _ArenaInfo.Team3v3) { _ResultArenaData.Team3v3 = arenaTeamData; } if (id == _ArenaInfo.Team5v5) { _ResultArenaData.Team5v5 = arenaTeamData; } } return(true); } } } } finally { CloseConnection(); } return(false); }