public List <BossFight> GetHSElligibleBossFightsInRaid(int _UniqueRaidID, WowRealm _Realm, string _GroupName)
{
List <BossFight> hsBossFights = new List <BossFight>();
var groupRC = GetGroupRC(_Realm, _GroupName);
Raid raid;
if (groupRC != null && groupRC.Raids.TryGetValue(_UniqueRaidID, out raid) == true)
{
List <string> bossFightsAdded = new List <string>();
foreach (var bossFight in raid.BossFights)
{
if (bossFightsAdded.Contains(bossFight.BossName))
{
continue;//Do not add duplicates!
}
if (bossFight.IsQualityHigh())
{
bossFightsAdded.Add(bossFight.BossName);
double precision = bossFight.DataDetails.FightPrecision;
if (precision > 0.90)
{
hsBossFights.Add(bossFight);
}
}
}
}
return(hsBossFights);
}
public int GetRealmInspectsForContributor(Contributor _Contributor, WowRealm _Realm)
{
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("SELECT COUNT(*) FROM uploadtable up INNER JOIN playerdatatable pd ON up.id = pd.uploadid INNER JOIN playertable player ON player.id = pd.playerid WHERE up.contributor = :ContributorID AND player.realm = :Realm", conn))
{
cmd.Parameters.Add(new NpgsqlParameter("ContributorID", NpgsqlDbType.Integer)).Value = _Contributor.ContributorID;
cmd.Parameters.Add(new NpgsqlParameter("Realm", NpgsqlDbType.Integer)).Value = (int)_Realm;
using (var reader = cmd.ExecuteReader())
{
if (reader.Read() == true && reader.IsDBNull(0) == false)
{
return(reader.GetInt32(0));
}
}
}
}
finally
{
CloseConnection();
}
return(-1);
}
private static VF_RealmPlayersDatabase.WowInstance GetRealmProgress(VF_RealmPlayersDatabase.WowRealm _Realm)
{
if (_Realm == VF_RealmPlayersDatabase.WowRealm.NostalGeek ||
_Realm == VF_RealmPlayersDatabase.WowRealm.Warsong ||
_Realm == VF_RealmPlayersDatabase.WowRealm.Nostalrius ||
_Realm == VF_RealmPlayersDatabase.WowRealm.Kronos
)
{
return(VF_RealmPlayersDatabase.WowInstance.Naxxramas);
}
else if (_Realm == VF_RealmPlayersDatabase.WowRealm.Nefarian ||
_Realm == VF_RealmPlayersDatabase.WowRealm.Al_Akir ||
_Realm == VF_RealmPlayersDatabase.WowRealm.Emerald_Dream
)
{
return(VF_RealmPlayersDatabase.WowInstance.Temple_Of_Ahn_Qiraj);
}
else if (_Realm == VF_RealmPlayersDatabase.WowRealm.Rebirth ||
_Realm == VF_RealmPlayersDatabase.WowRealm.Elysium2 ||
_Realm == VF_RealmPlayersDatabase.WowRealm.NostalriusPVE
)
{
return(VF_RealmPlayersDatabase.WowInstance.Blackwing_Lair);
}
return(VF_RealmPlayersDatabase.WowInstance.Molten_Core);
}
protected void Page_Init(object sender, EventArgs e)
{
if (IsPostBack == false)
{
string realmStr = Request.QueryString.Get("realm");
if (realmStr == null)
{
realmStr = "All";
HttpCookie realmControlCookie = Request.Cookies["RSRealmControl"];
if (realmControlCookie != null)
{
realmStr = realmControlCookie["Realm"];
}
if (Request.Url.Query == "")
{
Response.Redirect(Request.Url + "?realm=" + realmStr);
}
else
{
Response.Redirect(Request.Url + "&realm=" + realmStr);
}
}
m_Realm = VF_RealmPlayersDatabase.StaticValues.ConvertRealm(realmStr);
if (m_Realm == WowRealm.Unknown)
{
m_Realm = WowRealm.All;
}
rblRealm.Items.FindByValue(GetRealmParam()).Selected = true;
}
Page.PreLoad += Page_PreLoad;
}
public bool GetPlayerID(WowRealm _Realm, string _PlayerName, out SQLPlayerID _ResultPlayerID)
{
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("SELECT id FROM playertable WHERE name=:Name AND realm=:Realm", conn))
{
{
var nameParam = new NpgsqlParameter("Name", NpgsqlDbType.Text);
nameParam.Value = _PlayerName;
cmd.Parameters.Add(nameParam);
}
{
var realmParam = new NpgsqlParameter("Realm", NpgsqlDbType.Integer);
realmParam.Value = (int)_Realm;
cmd.Parameters.Add(realmParam);
}
using (var reader = cmd.ExecuteReader())
{
if (reader.Read() == true)
{
_ResultPlayerID = new SQLPlayerID(reader.GetInt32(0));
return(true);
}
}
}
}
finally
{
CloseConnection();
}
_ResultPlayerID = SQLPlayerID.Invalid();
return(false);
}
public List <Tuple <DateTime, string> > GetItemUsage(WowRealm _Realm, int _ItemID, int _SuffixID)
{
List <Tuple <DateTime, string> > retList = new List <Tuple <DateTime, string> >();
var itemOwners = GetItemSummary(_ItemID, _SuffixID).ItemOwners;
UInt64 bitMask;
UInt64 realmValue;
CalcRealmBits(_Realm, out bitMask, out realmValue);
foreach (var itemOwner in itemOwners)
{
if ((itemOwner.Item1 & bitMask) == realmValue)
{
var player = m_PlayerIDs.First((_Value) => _Value.Value == itemOwner.Item1);
if (player.Key.StartsWith("R"))
{
retList.Add(Tuple.Create(itemOwner.Item2, player.Key.Substring(3)));
}
else
{
retList.Add(Tuple.Create(itemOwner.Item2, player.Key.Substring(1)));
}
}
}
return(retList);
}
public string CreatePVPTable(WowRealm _Realm, int _Count, PlayerColumn[] _Columns, Func <KeyValuePair <string, Player>, double> _SortLambda, Func <Player, bool> _RequirementLambda)
{
int pageIndex = PageUtility.GetQueryInt(Request, "page", 1) - 1;//Change range from 0 to * instead of 1 to *
bool needHistory = false;
if (_Columns.Contains(PlayerColumn.RankChange))
{
needHistory = true;
}
string table = "<table id='characters-table' class='table'>";
table += "<thead>" + PageUtility.CreatePlayerTableHeaderRow(_Columns) + "</thead>";
table += "<tbody>";
var playerArray = DatabaseAccess.GetRealmPlayers(this, _Realm, NotLoadedDecision.RedirectAndWait).OrderByDescending(_SortLambda);
var playersHistoryArray = DatabaseAccess._GetRealmPlayersHistory(this, _Realm, NotLoadedDecision.ReturnNull);
int nr = 0;
foreach (var player in playerArray)
{
if (_RequirementLambda(player.Value) == true)
{
nr++;
if (nr > pageIndex * _Count && nr <= (pageIndex + 1) * _Count)
{
if (needHistory == true)
{
VF_RealmPlayersDatabase.PlayerData.PlayerHistory playerHistory = null;
if (playersHistoryArray != null)
{
if (playersHistoryArray.TryGetValue(player.Key, out playerHistory) == false)
{
playerHistory = null;
}
}
table += PageUtility.CreatePlayerRow(nr, _Realm, player.Value, _Columns, playerHistory);
}
else
{
table += PageUtility.CreatePlayerRow(nr, _Realm, player.Value, _Columns);
}
}
}
if (nr >= (pageIndex + 1) * _Count)
{
break;
}
}
table += "</tbody></table>";
if (nr != 0 && nr <= pageIndex * _Count)
{
pageIndex = (nr - 1) / _Count;
Response.Redirect(PageUtility.CreateUrlWithNewQueryValue(Request, "page", (pageIndex + 1).ToString()));
}
return(table);
}
//public GuildSummary GetGuildSummary(string _GuildName)
//{
// GuildSummary guildSummary = null;
// if(m_Guilds.TryGetValue(_GuildName, out guildSummary) == false)
// return null;
// return guildSummary;
//}
public IEnumerable <KeyValuePair <string, GuildSummary> > GetGuilds(WowRealm _Realm)
{
if (_Realm == WowRealm.All)
{
return(m_Guilds);
}
return(m_Guilds.Where((_Value) => _Value.Value.Realm == _Realm));
}
private void CalcRealmBits(WowRealm _Realm, out UInt64 _BitMask, out UInt64 _RealmValue)
{
_BitMask = 0xFFUL << 56;
_RealmValue = GetRealmBitNR(_Realm) << 56;
if (_RealmValue == 0)
{
_RealmValue = _BitMask;
}
}
private void CalcRealmBits(WowRealm _Realm, out UInt64 _BitMask, out UInt64 _RealmValue)
{
_BitMask = 0xFFUL << 56;
_RealmValue = _BitMask;
switch (_Realm)
{
case WowRealm.Emerald_Dream:
_RealmValue = 1UL << 56;
break;
case WowRealm.Warsong:
_RealmValue = 2UL << 56;
break;
case WowRealm.Al_Akir:
_RealmValue = 3UL << 56;
break;
case WowRealm.Valkyrie:
_RealmValue = 4UL << 56;
break;
case WowRealm.VanillaGaming:
_RealmValue = 5UL << 56;
break;
case WowRealm.Rebirth:
_RealmValue = 6UL << 56;
break;
case WowRealm.Archangel:
_RealmValue = 7UL << 56;
break;
case WowRealm.Nostalrius:
_RealmValue = 8UL << 56;
break;
case WowRealm.Kronos:
_RealmValue = 9UL << 56;
break;
case WowRealm.NostalGeek:
_RealmValue = 10UL << 56;
break;
case WowRealm.Nefarian:
_RealmValue = 11UL << 56;
break;
case WowRealm.NostalriusPVE:
_RealmValue = 12UL << 56;
break;
}
}
public GuildSummary GetGuildSummary(WowRealm _Realm, string _GuildName)
{
GuildSummary retValue = null;
if (m_Guilds.TryGetValue(Utility.GetRealmPreString(_Realm) + _GuildName, out retValue) == false)
{
return(null);
}
return(retValue);
}
public GroupInfo GetGroupInfo(WowRealm _Realm, string _GroupName)
{
GroupInfo retValue = null;
if (m_GroupInfos.TryGetValue(Utility.GetRealmPreString(_Realm) + _GroupName, out retValue) == false)
{
return(null);
}
return(retValue);
}
public GroupRaidCollection GetGroupRC(WowRealm _Realm, string _GroupName)
{
GroupRaidCollection retValue = null;
if (m_GroupRCs.TryGetValue(Utility.GetRealmPreString(_Realm) + _GroupName, out retValue) == false)
{
return(null);
}
return(retValue);
}
public PVPSummary GetPVPSummary(WowRealm _Realm, string _Player)
{
PVPSummary retValue = null;
string realm = VF_RealmPlayersDatabase.Utility.GetRealmPreString(_Realm);
if (m_PVPSummaries.TryGetValue(realm + _Player, out retValue) == false)
{
return(null);
}
return(retValue);
}
public PlayerData.ItemInfo GetLatestItemInfoForPlayer(string _Player, WowRealm _Realm, int _ItemID)
{
PlayerData.ItemInfo latestItemInfo = new PlayerData.ItemInfo();
latestItemInfo.Slot = VF_RealmPlayersDatabase.ItemSlot.Unknown;
latestItemInfo.ItemID = _ItemID;
DateTime latestItemInfoDate = DateTime.MinValue;
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("SELECT DISTINCT ii.enchantid, ii.suffixid, ii.uniqueid, MAX(pdt.updatetime) FROM PlayerTable player"
+ " INNER JOIN PlayerDataTable pdt ON pdt.PlayerID = player.ID"
+ " INNER JOIN PlayerGearTable pgt ON pgt.ID = pdt.gearinfo INNER JOIN IngameItemTable ii"
+ " ON ii.ID = pgt.head OR ii.ID = pgt.neck OR ii.ID = pgt.shoulder OR ii.ID = pgt.shirt"
+ " OR ii.ID = pgt.chest OR ii.ID = pgt.belt OR ii.ID = pgt.legs OR ii.ID = pgt.feet"
+ " OR ii.ID = pgt.wrist OR ii.ID = pgt.gloves OR ii.ID = pgt.finger_1 OR ii.ID = pgt.finger_2"
+ " OR ii.ID = pgt.trinket_1 OR ii.ID = pgt.trinket_2 OR ii.ID = pgt.back"
+ " OR ii.ID = pgt.main_hand OR ii.ID = pgt.off_hand OR ii.ID = pgt.ranged"
+ " OR ii.ID = pgt.tabard WHERE ii.ItemID = :ItemID AND player.name = :PlayerName AND player.realm = :Realm GROUP BY ii.enchantid, ii.suffixid, ii.uniqueid", conn))
{
cmd.Parameters.Add(new NpgsqlParameter("ItemID", NpgsqlDbType.Integer)).Value = _ItemID;
cmd.Parameters.Add(new NpgsqlParameter("PlayerName", NpgsqlDbType.Text)).Value = _Player;
cmd.Parameters.Add(new NpgsqlParameter("Realm", NpgsqlDbType.Integer)).Value = (int)_Realm;
using (var reader = cmd.ExecuteReader())
{
while (reader.Read() == true && reader.IsDBNull(3) == false)
{
DateTime currItemInfoDate = reader.GetTimeStamp(3).DateTime;
if (currItemInfoDate > latestItemInfoDate)
{
latestItemInfoDate = currItemInfoDate;
latestItemInfo.EnchantID = reader.GetInt32(0);
latestItemInfo.SuffixID = reader.GetInt32(1);
latestItemInfo.UniqueID = reader.GetInt32(2);
}
}
}
}
}
finally
{
CloseConnection();
}
if (latestItemInfoDate != DateTime.MinValue)
{
return(latestItemInfo);
}
return(null);
}
private UInt64 GetEntityID(WowRealm _Realm, string _PlayerName)
{
UInt64 entityID = UInt64.MaxValue;
string entityLinkStr = VF_RealmPlayersDatabase.Utility.GetRealmPreString(_Realm) + _PlayerName;
if (m_PlayerIDs.TryGetValue(entityLinkStr, out entityID) == true)
{
return(entityID);
}
entityID = GetRealmBitNR(_Realm) << 56;
//switch (_Realm)
//{
// //case WowRealm.Emerald_Dream: entityID |= m_EntityCounter_Emerald_Dream++; break;
// //case WowRealm.Warsong: entityID |= m_EntityCounter_Warsong++; break;
// //case WowRealm.Al_Akir: entityID |= m_EntityCounter_Al_Akir++; break;
// //case WowRealm.Valkyrie: entityID |= m_EntityCounter_Valkyrie++; break;
// //case WowRealm.VanillaGaming: entityID |= m_EntityCounter_VanillaGaming++; break;
// //case WowRealm.Rebirth: entityID |= m_EntityCounter_Rebirth++; break;
// //case WowRealm.Archangel: entityID |= m_EntityCounter_Archangel++; break;
// //case WowRealm.Nostalrius: entityID |= m_EntityCounter_Nostalrius++; break;
// //case WowRealm.Kronos: entityID |= m_EntityCounter_Kronos++; break;
// //case WowRealm.NostalGeek: entityID |= m_EntityCounter_NostalGeek++; break;
// //case WowRealm.Nefarian: entityID |= m_EntityCounter_Nefarian++;break;
// //case WowRealm.NostalriusPVE: entityID |= m_EntityCounter_NostalriusPVE++; break;
// //case WowRealm.WarsongTBC: entityID |= m_EntityCounter_WarsongTBC++; break;
// //case WowRealm.KronosII: entityID |= m_EntityCounter_KronosII++; break;
// //case WowRealm.Vengeance_Wildhammer: entityID |= m_EntityCounter_Vengeance_Wildhammer++; break;
// //case WowRealm.ExcaliburTBC: entityID |= m_EntityCounter_ExcaliburTBC++; break;
// //case WowRealm.L4G_Hellfire: entityID |= m_EntityCounter_L4G_Hellfire++; break;
// //case WowRealm.Warsong2: entityID |= m_EntityCounter_Warsong2++; break;
// //case WowRealm.Vengeance_Stonetalon: entityID |= m_EntityCounter_Vengeance_Stonetalon++; break;
// //case WowRealm.Elysium: entityID |= m_EntityCounter_Elysium++;break;
// //case WowRealm.Elysium2: entityID |= m_EntityCounter_Elysium2++; break;
// //case WowRealm.Zeth_Kur: entityID |= m_EntityCounter_Zeth_Kur++; break;
// //case WowRealm.Nemesis: entityID |= m_EntityCounter_Nemesis++; break;
// //case WowRealm.HellGround: entityID |= m_EntityCounter_HellGround++; break;
// //case WowRealm.Nostralia: entityID |= m_EntityCounter_Nostralia++; break;
// //case WowRealm.Hellfire2: entityID |= m_EntityCounter_Hellfire2++; break;
// default:
m_EntityCounters_Realm.AddIfKeyNotExist(_Realm, (UInt64)0);
UInt64 currEntityCounterValue = m_EntityCounters_Realm[_Realm];
entityID |= currEntityCounterValue;
m_EntityCounters_Realm[_Realm] = currEntityCounterValue + 1;
// break;
//}
m_PlayerIDs.Add(entityLinkStr, entityID);
return(entityID);
}
//public static RealmDatabase GetRealmDB(System.Web.UI.Page _Page, WowRealm _Realm, string _RedirectSubRealmSection = "")
//{
// var rppDatabase = ApplicationInstance.Instance.GetRPPDatabase(false);
// if (rppDatabase == null)
// {
// PageUtility.RedirectErrorLoading(_Page, StaticValues.ConvertRealmParam(_Realm) + _RedirectSubRealmSection);
// return null;
// }
// return rppDatabase.GetRealm(_Realm);
//}
//public static PlayerData.PlayerHistory GetRealmPlayerHistory(System.Web.UI.Page _Page, WowRealm _Realm, string _Player)
//{
// var realm = GetRealmDB(_Page, _Realm, "-history");
// if (realm.IsPlayersHistoryLoadComplete() == false)
// {
// PageUtility.RedirectErrorLoading(_Page, StaticValues.ConvertRealmParam(_Realm) + "-history");
// return null;
// }
// PlayerData.PlayerHistory playerHistory;
// if (realm.PlayersHistory.TryGetValue(_Player, out playerHistory) == false)
// return null;
// return playerHistory;
//}
//public static PlayerData.Player GetRealmPlayer(System.Web.UI.Page _Page, WowRealm _Realm, string _Player)
//{
// var realm = GetRealmDB(_Page, _Realm, "-latest");
// if (realm.IsPlayersLoadComplete() == false)
// {
// PageUtility.RedirectErrorLoading(_Page, StaticValues.ConvertRealmParam(_Realm) + "-latest");
// return null;
// }
// PlayerData.Player player;
// if (realm.Players.TryGetValue(_Player, out player) == false)
// return null;
// return player;
//}
//public static Dictionary<int, List<Tuple<DateTime, string>>> GetRealmCacheDB_ItemsUsed(System.Web.UI.Page _Page, WowRealm _Realm)
//{
// var realm = GetRealmDB(_Page, _Realm, "-itemsused");
// if (realm.IsLoadComplete() == false)
// {
// PageUtility.RedirectErrorLoading(_Page, StaticValues.ConvertRealmParam(_Realm) + "-itemsused");
// return null;
// }
//}
public static RealmDatabase _FindRealmDB(System.Web.UI.Page _Page, WowRealm _Realm, NotLoadedDecision _Decision = NotLoadedDecision.SpinWait)
{
var rppDatabase = Hidden.ApplicationInstance.Instance._GetRPPDatabase(_Decision == NotLoadedDecision.SpinWait);
if (rppDatabase == null)
{
if (_Decision == NotLoadedDecision.RedirectAndWait)
{
PageUtility.RedirectErrorLoading(_Page, StaticValues.ConvertRealmParam(_Realm));
}
return(null);
}
return(rppDatabase.GetRealm(_Realm));
}
public static string GetRealmPreString(VF_RealmPlayersDatabase.WowRealm _Realm)
{
string realm = "" + (int)_Realm;
if (realm.Length > 1)
{
if ((int)_Realm > 99)
{
throw new Exception("ERROR, REALM WAS INTENDED TO NEVER BE BIGGER THAN VALUE 99");
}
realm = "R" + (int)_Realm;
}
return(realm);
}
public static PlayerData.Player FindRealmPlayer(System.Web.UI.Page _Page, WowRealm _Realm, string _Player, NotLoadedDecision _Decision = NotLoadedDecision.SpinWait)
{
var realmPlayers = GetRealmPlayers(_Page, _Realm, _Decision);
if (realmPlayers == null)
{
return(null);
}
PlayerData.Player player;
if (realmPlayers.TryGetValue(_Player, out player) == false)
{
return(null);
}
return(player);
}
public PlayerSummary GetPlayerSummary(string _Player, WowRealm _Realm)
{
if (m_PlayerSummaries.Count == 0)
{
GeneratePlayerSummaries();
}
PlayerSummary retValue = null;
if (m_PlayerSummaries.TryGetValue(Utility.GetRealmPreString(_Realm) + _Player, out retValue) == false)
{
return(null);
}
return(retValue);
}
public void MigrateToSQL()
{
Dictionary <ulong, VF.SQLPlayerID> playerIDConverter = new Dictionary <ulong, VF.SQLPlayerID>();
using (VF.SQLComm comm = new VF.SQLComm())
{
int totalItemsCount = m_Items.Count;
int itemsProcessedCounter = 0;
DateTime startTime = DateTime.UtcNow;
DateTime prevLogTime = DateTime.UtcNow;
foreach (var itemSummary in m_Items)
{
++itemsProcessedCounter;
foreach (var itemOwner in itemSummary.Value.m_ItemOwners)
{
VF.SQLPlayerID playerID;
if (playerIDConverter.TryGetValue(itemOwner.Item1, out playerID) == false)
{
string playerName = GetPlayerName(itemOwner.Item1);
WowRealm realm = GetPlayerRealm(itemOwner.Item1);
if (comm.GetPlayerID(realm, playerName, out playerID) == true)
{
playerIDConverter.Add(itemOwner.Item1, playerID);
}
else
{
VF_RealmPlayersDatabase.Logger.ConsoleWriteLine("playerID was not valid for player \"" + playerName + "\"", ConsoleColor.Red);
}
}
if (playerID.IsValid() == true)
{
if (comm.UpsertItemOwner(itemSummary.Value.m_ItemID, itemSummary.Value.m_SuffixID, playerID, null, itemOwner.Item2) == false)
{
VF_RealmPlayersDatabase.Logger.ConsoleWriteLine("UpsertItemOwner Failed???", ConsoleColor.Red);
}
}
}
if ((DateTime.UtcNow - prevLogTime).TotalSeconds > 5)
{
VF_RealmPlayersDatabase.Logger.ConsoleWriteLine("Processed " + itemsProcessedCounter + " / " + totalItemsCount + " items");
prevLogTime = DateTime.UtcNow;
}
}
VF_RealmPlayersDatabase.Logger.ConsoleWriteLine("Done with processing " + totalItemsCount + " items, it took " + (DateTime.UtcNow - startTime).ToString());
}
}
protected void Page_PreLoad(object sender, EventArgs e)
{
if (IsPostBack == true)
{
string realmChoice = RealmControl_RadioList.SelectedItem.Value;
m_Realm = VF_RealmPlayersDatabase.StaticValues.ConvertRealm(realmChoice);
HttpCookie cookie = new HttpCookie("RealmControl");
cookie.Expires = DateTime.Now.AddDays(30);
cookie["Realm"] = GetRealmParam();
Response.Cookies.Add(cookie);
if (Request.QueryString.Get("realm") != GetRealmParam())
{
var newQuery = Request.Url.Query.Replace("realm=" + Request.QueryString.Get("realm"), "realm=" + GetRealmParam());
Response.Redirect(Request.Url.AbsolutePath + newQuery);
}
}
}
public int GetItemUsageCount(WowRealm _Realm, int _ItemID, int _SuffixID)
{
int usageCount = 0;
var itemOwners = GetItemSummary(_ItemID, _SuffixID).ItemOwners;
UInt64 bitMask;
UInt64 realmValue;
CalcRealmBits(_Realm, out bitMask, out realmValue);
foreach (var itemOwner in itemOwners)
{
if ((itemOwner.Item1 & bitMask) == realmValue)
{
++usageCount;
}
}
return(usageCount);
}
public PlayerSummary GetPlayerSummary(string _Player, WowRealm _Realm)
{
if (m_PlayerSummaries.Count == 0)
{
DateTime timer = DateTime.Now;
GC.Collect();
GeneratePlayerSummaries();
GC.Collect();
VF_RealmPlayersDatabase.Logger.ConsoleWriteLine("Done with generating PlayerSummary after " + (DateTime.Now - timer));
}
PlayerSummary retValue = null;
if (m_PlayerSummaries.TryGetValue(Utility.GetRealmPreString(_Realm) + _Player, out retValue) == false)
{
return(null);
}
return(retValue);
}
protected void Page_Init(object sender, EventArgs e)
{
if (RealmControl_RadioList.Items.FindByValue("ArA") == null)
{
RealmControl_RadioList.Items.Add(new ListItem("Archangel(TBC)", "ArA"));
}
if (IsPostBack == false)
{
string realmStr = Request.QueryString.Get("realm");
if (realmStr == null)
{
realmStr = "ED";
HttpCookie realmControlCookie = Request.Cookies["RealmControl"];
if (realmControlCookie != null)
{
realmStr = realmControlCookie["Realm"];
}
if (Request.Url.Query == "")
{
Response.Redirect(Request.Url + "?realm=" + realmStr);
}
else
{
Response.Redirect(Request.Url + "&realm=" + realmStr);
}
}
m_Realm = VF_RealmPlayersDatabase.StaticValues.ConvertRealm(realmStr);
if (m_Realm == WowRealm.Unknown)
{
m_Realm = WowRealm.Emerald_Dream;
}
var listItem = RealmControl_RadioList.Items.FindByValue(GetRealmParam());
if (listItem != null)
{
RealmControl_RadioList.Items.FindByValue(GetRealmParam()).Selected = true;
}
}
Page.PreLoad += Page_PreLoad;
}
public int GetRealmInspectsTotal(WowRealm _Realm)
{
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("SELECT COUNT(*) FROM playerdatatable pd INNER JOIN playertable player ON player.id = pd.playerid WHERE player.realm = :Realm", conn))
{
cmd.Parameters.Add(new NpgsqlParameter("Realm", NpgsqlDbType.Integer)).Value = (int)_Realm;
using (var reader = cmd.ExecuteReader())
{
if (reader.Read() == true && reader.IsDBNull(0) == false)
{
return(reader.GetInt32(0));
}
}
}
}
finally
{
CloseConnection();
}
return(-1);
}
public GuildSummary(string _GuildName, WowRealm _Realm)
{
m_GuildName = _GuildName;
m_Realm = _Realm;
}
private void AddPVPSummary(WowRealm _Realm, string _Player, PVPSummary _PVPSummary)
{
m_PVPSummaries.Add(VF_RealmPlayersDatabase.Utility.GetRealmPreString(_Realm) + _Player, _PVPSummary);
}
public static List <Tuple <PlayerData, AverageStats> > GenerateAverageDataSet(List <string> bosses, List <PlayerClass> classLimits, List <PlayerFaction> factionLimits, WowRealm realm, string guildLimit)
{
var summaryDatabase = ApplicationInstance.Instance.GetSummaryDatabase();
if (summaryDatabase == null)
{
return(null);
}
var realmDB = ApplicationInstance.Instance.GetRealmDB(VF_RealmPlayersDatabase.WowRealm.Nostalrius);
var orderedPlayers = summaryDatabase.PlayerSummaries.OrderBy(_Value => _Value.Key); //Order by realm to avoid changing realmDB all the time
List <Tuple <PlayerData, AverageStats> > dataset = new List <Tuple <PlayerData, AverageStats> >();
Func <TotalPlayerBossStats, float> getDPSFunc = (_Value) => _Value.GetAverageDPS(5, 6, 3);
Func <TotalPlayerBossStats, float> getEffectiveHPSFunc = (_Value) => _Value.GetAverageEffectiveHPS(5, 6, 3);
foreach (var playerSummary in orderedPlayers)
{
if (playerSummary.Value.AttendedFights.Count == 0)
{
continue;
}
var currGroup = playerSummary.Value.AttendedFights.Last().CacheRaid.CacheGroup;
if (guildLimit != null && guildLimit != currGroup.GroupName)
{
continue;
}
if (realm != VF_RealmPlayersDatabase.WowRealm.All && realm != currGroup.Realm)
{
continue;
}
if (currGroup.Realm != realmDB.Realm)
{
realmDB = ApplicationInstance.Instance.GetRealmDB(currGroup.Realm);
}
var playerData = realmDB.FindPlayer(playerSummary.Value.Name);
if (playerData != null && (classLimits == null || classLimits.Contains(playerData.Character.Class)) &&
(factionLimits == null || factionLimits.Contains(StaticValues.GetFaction(playerData.Character.Race))))
{
AverageStats averageStats = new AverageStats();
Func <string, bool> includeBossFunc = (_Value) => { return(bosses.Contains(_Value)); };
averageStats.m_DPS = playerSummary.Value.GenerateTotalAverageData(bosses.Count, getDPSFunc, includeBossFunc);
averageStats.m_HPS = playerSummary.Value.GenerateTotalAverageData(bosses.Count, getEffectiveHPSFunc, includeBossFunc);
dataset.Add(Tuple.Create(playerData, averageStats));
}
}
return(dataset);
}
public IEnumerable <KeyValuePair <string, PVPSummary> > GetPVPSummaries(WowRealm _Realm)
{
string realm = VF_RealmPlayersDatabase.Utility.GetRealmPreString(_Realm);
return(m_PVPSummaries.Where((_Value) => _Value.Key.StartsWith(realm)));
}
