protected void Page_Load(object sender, EventArgs e)
{
int pageNr = PageUtility.GetQueryInt(Request, "page", 1);
int pageIndex = pageNr - 1;//Change range from 0 to * instead of 1 to *
int count = PageUtility.GetQueryInt(Request, "count", 100);
if (count > 500)
{
count = 500;
}
var realm = RealmControl.Realm;
if (realm == VF_RealmPlayersDatabase.WowRealm.Unknown)
{
return;
}
var wowVersion = StaticValues.GetWowVersion(realm);
int itemID = PageUtility.GetQueryInt(Request, "item", 19364);
int suffixID = PageUtility.GetQueryInt(Request, "suffix", 0);
this.Title = "\"" + itemID + "\" ItemUsage @ " + StaticValues.ConvertRealmParam(realm) + " | RealmPlayers";
m_BreadCrumbHTML = new MvcHtmlString(PageUtility.BreadCrumb_AddHome()
+ PageUtility.BreadCrumb_AddFinish("ItemUsage"));
var itemSummaryDB = Hidden.ApplicationInstance.Instance.GetItemSummaryDatabase();
using (VF.SQLComm comm = new VF.SQLComm())
{
List <Tuple <DateTime, string> > players = null;
players = itemSummaryDB.GetItemUsage(realm, itemID, suffixID);//, out players) == true)
{
string currentItemDatabase = DatabaseAccess.GetCurrentItemDatabaseAddress();
var itemInfo = DatabaseAccess.GetItemInfo(itemID, wowVersion);
m_ItemUsageInfoHTML = new MvcHtmlString("<div style='overflow: hidden; display: table;'><div style='display: table-cell;'><h1>Players with <h1></div>"
+ "<div class='inventory' style='background: none; width: 58px; height: 58px; display: table-cell;'><div>"
+ "<img class='itempic' src='" + "http://realmplayers.com/" + itemInfo.GetIconImageAddress() + "'/>"
+ "<div class='quality' id='" + CharacterViewer.ItemQualityConversion[itemInfo.ItemQuality] + "'></div>"
+ "<img class='itemframe' src='assets/img/icons/ItemNormalFrame.png'/>"
+ CharacterViewer.GenerateItemLink(currentItemDatabase, itemID, suffixID, wowVersion)
+ "</div></div>"
+ "<span class='badge badge-inverse'>" + players.Count + " Players</span></div>" + "<p>Sorted by date \"aquired\"</p>");
Dictionary <PlayerColumn, string[]> extraColumns = new Dictionary <PlayerColumn, string[]>();
PlayerColumn ItemAndAquiredDateAfterColumn = PlayerColumn.Number;
extraColumns.Add(ItemAndAquiredDateAfterColumn, new string[] { "Item", "Date Aquired" });
m_TableHeadHTML = new MvcHtmlString(PageUtility.CreatePlayerTableHeaderRow(Table_Columns, extraColumns));
string tableBody = "";
int nr = 0;
Func <Tuple <DateTime, string>, DateTime> lambdaComparison = (_Tuple) => { return(_Tuple.Item1); };
players = players.OrderBy(lambdaComparison).ToList();
foreach (var playerDateAndName in players)
{
Player player = DatabaseAccess.FindRealmPlayer(this, realm, playerDateAndName.Item2);
if (player != null)
{
++nr;
// style='position: absolute; margin: auto; width:58px; height:58px;'
if (nr > pageIndex * count && nr <= (pageIndex + 1) * count)
{
//string itemLink = "";
VF_RealmPlayersDatabase.PlayerData.ItemInfo playerItemData = null;
try
{
playerItemData = player.Gear.Items.First((_Item) => { return(_Item.Value.ItemID == itemID); }).Value;
}
catch (Exception)
{
playerItemData = null;
}
if (playerItemData != null)
{
//Data fanns i gearen som playern använder för tillfället!
//itemLink = currentItemDatabase + "?item=" + playerItemData.ItemID + "' rel='rand=" + playerItemData.SuffixID + ";ench=" + playerItemData.EnchantID;
}
else
{
//Måste titta igenom history!
#if NO_SQL
PlayerHistory playerHistory = DatabaseAccess.FindRealmPlayerHistory(this, realm, playerDateAndName.Item2);
if (playerHistory != null)
{
for (int i = playerHistory.GearHistory.Count - 1; i >= 0; --i)
{
try
{
playerItemData = playerHistory.GearHistory[i].Data.Items.First((_Item) => { return(_Item.Value.ItemID == itemID); }).Value;
}
catch (Exception)
{
playerItemData = null;
}
if (playerItemData != null)
{
//Data fanns i gearen som playern använder för tillfället!
//itemLink = currentItemDatabase + "?item=" + playerItemData.ItemID + "' rel='rand=" + playerItemData.SuffixID + ";ench=" + playerItemData.EnchantID;
break;
}
}
}
#else
/*Disable this for now. it is too slow...*/
//playerItemData = comm.GetLatestItemInfoForPlayer(playerDateAndName.Item2, realm, itemID);
#endif
}
if (playerItemData == null)
{
playerItemData = new VF_RealmPlayersDatabase.PlayerData.ItemInfo {
Slot = VF_RealmPlayersDatabase.ItemSlot.Unknown, ItemID = itemID, SuffixID = 0, EnchantID = 0, UniqueID = 0, GemIDs = null
};
}
extraColumns[ItemAndAquiredDateAfterColumn] = new string[] {
"<div class='inventory' style='background: none; width: 58px; height: 58px;'><div>"
+ "<img class='itempic' src='" + "http://realmplayers.com/" + itemInfo.GetIconImageAddress() + "'/>"
+ "<div class='quality' id='" + CharacterViewer.ItemQualityConversion[itemInfo.ItemQuality] + "'></div>"
+ "<img class='itemframe' src='assets/img/icons/ItemNormalFrame.png'/>"
+ CharacterViewer.GenerateItemLink(currentItemDatabase, playerItemData, wowVersion)
+ "</div></div>"
, playerDateAndName.Item1.ToString("yyyy-MM-dd")
};
tableBody += PageUtility.CreatePlayerRow(nr, realm, player, Table_Columns, null, extraColumns);
}
if (nr >= (pageIndex + 1) * count)
{
break;
}
}
}
if (nr != 0 && nr <= pageIndex * count)
{
pageIndex = (nr - 1) / count;
Response.Redirect(PageUtility.CreateUrlWithNewQueryValue(Request, "page", (pageIndex + 1).ToString()));
}
m_TableBodyHTML = new MvcHtmlString(tableBody);
int maxPageNr = 1000000 / count;
m_PaginationHTML = new MvcHtmlString(PageUtility.CreatePagination(Request, pageNr, ((players.Count - 1) / count) + 1));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string pageView = RealmPlayersServer.PageUtility.GetQueryString(Request, "view", "players");
var realm = PageUtility.GetQueryRealm(Request);
if (realm == WowRealm.Unknown)
{
return;
}
var wowVersion = StaticValues.GetWowVersion(realm);
string guildStr = PageUtility.GetQueryString(Request, "guild");
var realmDB = DatabaseAccess.GetRealmPlayers(this, realm);
var guildSummaryDB = Hidden.ApplicationInstance.Instance.GetGuildSummaryDatabase();
var guild = guildSummaryDB.GetGuildSummary(realm, guildStr);// DatabaseAccess.GetRealmGuild(this, realm, guildStr, NotLoadedDecision.RedirectAndWait);
if (guild == null)
{
return;
}
guild.GenerateCache(realmDB);
this.Title = guildStr + " @ " + StaticValues.ConvertRealmParam(realm) + " | RealmPlayers";
m_ProgressInfoHTML = new MvcHtmlString("<div id='" + guild.GuildName.Replace(' ', '_') + "-Progress'></div>");
var membersArray = guild.GetMembers();
var orderedPlayersArray = membersArray.OrderBy((player) => { return(player.Item2.History.Last().GuildRankNr); });
int progressComparisonValue = 0;
string guildProgressData = GuildList.CreateProgressStr(this, guild, realm, out progressComparisonValue);
m_GuildScriptData = new MvcHtmlString("<script>var guildProgress = new Array();" + guildProgressData + "</script>");
if (pageView == "players")
{
m_BreadCrumbHTML = new MvcHtmlString(PageUtility.BreadCrumb_AddHome()
+ PageUtility.BreadCrumb_AddRealm(realm)
+ PageUtility.BreadCrumb_AddGuilds(realm)
+ PageUtility.BreadCrumb_AddFinish(guild.GuildName));
m_GuildInfoHTML = new MvcHtmlString("<h1><img src='assets/img/icons/ui-pvp-"
+ StaticValues.GetFactionCSSName(guild.Faction) + ".png'/><span class='"
+ StaticValues.GetFactionCSSName(guild.Faction) + "-color'>" + guild.GuildName
+ "</span><span class='badge badge-inverse'>" + membersArray.Count + " Members</span></h1>"
+ "<p>Guild on the server " + StaticValues.ConvertRealmViewing(realm) + "</p>"
+ "<p><a href='/GuildViewer.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + guildStr + "&view=latestevents'>View Latest Events</a></p>"
+ "<p><a href='/RaidStats/RaidList.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + guildStr + "'>View recorded raids on RaidStats</a></p>");
string page = "";
foreach (var player in orderedPlayersArray)
{
page += PageUtility.CreatePlayerRow(0, realm, player.Item1, Table_Columns);
}
m_CharactersTableHeadHTML = new MvcHtmlString(PageUtility.CreatePlayerTableHeaderRow(Table_Columns));
m_CharactersTableBodyHTML = new MvcHtmlString(page);
}
else if (pageView == "latestmembers")
{
m_BreadCrumbHTML = new MvcHtmlString(PageUtility.BreadCrumb_AddHome()
+ PageUtility.BreadCrumb_AddRealm(realm)
+ PageUtility.BreadCrumb_AddGuilds(realm)
+ PageUtility.BreadCrumb_AddGuild(realm, guild.GuildName)
+ PageUtility.BreadCrumb_AddFinish("Latest Members"));
m_GuildInfoHTML = new MvcHtmlString("<h1><img src='assets/img/icons/ui-pvp-"
+ StaticValues.GetFactionCSSName(guild.Faction) + ".png'/><span class='"
+ StaticValues.GetFactionCSSName(guild.Faction) + "-color'>" + guild.GuildName
+ "</span><span class='badge badge-inverse'>" + membersArray.Count + " Members</span></h1>"
+ "<p>Guild on the server " + StaticValues.ConvertRealmViewing(realm) + "</p>"
+ "<p><a href='/GuildViewer.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + guildStr + "'>View Members</a></p>"
+ "<p><a href='/RaidStats/RaidList.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + guildStr + "'>View recorded raids on RaidStats</a></p>");
}
else if (pageView == "latestitems")
{
m_BreadCrumbHTML = new MvcHtmlString(PageUtility.BreadCrumb_AddHome()
+ PageUtility.BreadCrumb_AddRealm(realm)
+ PageUtility.BreadCrumb_AddGuilds(realm)
+ PageUtility.BreadCrumb_AddGuild(realm, guild.GuildName)
+ PageUtility.BreadCrumb_AddFinish("Latest Items"));
m_GuildInfoHTML = new MvcHtmlString("<h1><img src='assets/img/icons/ui-pvp-"
+ StaticValues.GetFactionCSSName(guild.Faction) + ".png'/><span class='"
+ StaticValues.GetFactionCSSName(guild.Faction) + "-color'>" + guild.GuildName
+ "</span><span class='badge badge-inverse'>" + membersArray.Count + " Members</span></h1>"
+ "<p>Guild on the server " + StaticValues.ConvertRealmViewing(realm) + "</p>"
+ "<p><a href='/GuildViewer.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + guildStr + "'>View Members</a></p>"
+ "<p><a href='/RaidStats/RaidList.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + guildStr + "'>View recorded raids on RaidStats</a></p>");
}
else if (pageView == "latestevents")
{
m_BreadCrumbHTML = new MvcHtmlString(PageUtility.BreadCrumb_AddHome()
+ PageUtility.BreadCrumb_AddRealm(realm)
+ PageUtility.BreadCrumb_AddGuilds(realm)
+ PageUtility.BreadCrumb_AddGuild(realm, guild.GuildName)
+ PageUtility.BreadCrumb_AddFinish("Latest Events"));
m_GuildInfoHTML = new MvcHtmlString("<h1><img src='assets/img/icons/ui-pvp-"
+ StaticValues.GetFactionCSSName(guild.Faction) + ".png'/><span class='"
+ StaticValues.GetFactionCSSName(guild.Faction) + "-color'>" + guild.GuildName
+ "</span><span class='badge badge-inverse'>" + membersArray.Count + " Members</span></h1>"
+ "<p>Guild on the server " + StaticValues.ConvertRealmViewing(realm) + "</p>"
+ "<p><a href='/GuildViewer.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + guildStr + "'>View Members</a></p>"
+ "<p><a href='/RaidStats/RaidList.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + guildStr + "'>View recorded raids on RaidStats</a></p>");
}
if (pageView == "latestmembers" || pageView == "latestevents")
{
var guildSummary = Hidden.ApplicationInstance.Instance.GetGuildSummary(realm, guildStr);
if (guildSummary == null)
{
return;
}
var statusChanges = guildSummary.GenerateLatestStatusChanges(DateTime.UtcNow.AddDays(-14));
string latestmembersStr = "";
statusChanges.Reverse();
foreach (var sChange in statusChanges)
{
if (realmDB.ContainsKey(sChange.Player))
{
var playerData = realmDB[sChange.Player];
string statusChangeDescription = "";
if (sChange.FromStatus == null || sChange.FromStatus.IsInGuild == false)
{
if (sChange.ToStatus.IsInGuild == true)
{
statusChangeDescription = "Added to the Guild as Rank \"" + sChange.ToStatus.GuildRank + "\"";
}
else
{
continue;
}
}
else if (sChange.ToStatus.IsInGuild == false)
{
statusChangeDescription = "Removed from the Guild";
}
else
{
statusChangeDescription = "Changed Rank From \"" + sChange.FromStatus.GuildRank + "\" to \"" + sChange.ToStatus.GuildRank + "\"";
}
latestmembersStr += PageUtility.CreateTableRow(""
, PageUtility.CreateTableColumn(PageUtility.CreateColorCodedPlayerLink(realm, playerData))
+ PageUtility.CreateTableColumn("<div style='overflow: hidden;white-space: nowrap;'>" + statusChangeDescription + "</div>")
+ PageUtility.CreateTableColumn("<div style='overflow: hidden;white-space: nowrap;'>" + sChange.ToStatus.DateTime.ToLocalTime().ToString("yyyy-MM-dd") + "</div>"));
}
}
m_LatestMembersHTML = new MvcHtmlString(latestmembersStr);
}
if (pageView == "latestitems" || pageView == "latestevents")
{
List <Tuple <DateTime, Player, List <Tuple <PlayerItemInfo, ItemInfo> > > > latestItems = new List <Tuple <DateTime, Player, List <Tuple <PlayerItemInfo, ItemInfo> > > >();
var realmHistory = DatabaseAccess._GetRealmPlayersHistory(this, realm, NotLoadedDecision.SpinWait);
foreach (var data in orderedPlayersArray)
{
Player player = data.Item1;
PlayerHistory playerHistory = null;
if (realmHistory.TryGetValue(player.Name, out playerHistory) == true)
{
var recvItems = HistoryGenerator.GenerateLatestReceivedItems(playerHistory, DateTime.MinValue);
var orderedRecvItems = recvItems.OrderByDescending(_Value => _Value.Key);
int i = 0;
foreach (var recvItem in orderedRecvItems)
{
if (i++ > 10)
{
break;
}
List <Tuple <PlayerItemInfo, ItemInfo> > newestItems = new List <Tuple <PlayerItemInfo, ItemInfo> >();
foreach (var item in recvItem.Value)
{
var itemInfo = DatabaseAccess.GetItemInfo(item.ItemID, wowVersion);
if (itemInfo.ItemQuality >= 4) //Atleast epic(4)
{
newestItems.Add(Tuple.Create(item, itemInfo));
}
}
if (newestItems.Count > 0)
{
latestItems.Add(Tuple.Create(recvItem.Key, player, newestItems));
}
}
}
}
string latestItemsStr = "";
{
var itemSummaryDB = Hidden.ApplicationInstance.Instance.GetItemSummaryDatabase();
string currentItemDatabase = DatabaseAccess.GetCurrentItemDatabaseAddress();
var orderedLatestItems = latestItems.OrderByDescending((_Value) => _Value.Item1);
int i = 0;
foreach (var recvItem in orderedLatestItems)
{
if (i++ > 100)
{
break;
}
int recvItemIndex = 0;
int xMax = 58 * 3;
int yMax = (int)((recvItem.Item3.Count - 1) / 3) * 58;
yMax += 58;
string itemLinks = "<div class='inventory' style='background: none; width: " + xMax + "px; height: " + yMax + "px;'>";
foreach (var item in recvItem.Item3)
{
int xPos = (recvItemIndex % 3) * 58;
int yPos = (int)(recvItemIndex / 3) * 58;
//string itemLink = currentItemDatabase + "?item=" + item.Item1.ItemID + "' rel='rand=" + item.Item1.SuffixID + ";ench=0";
var itemInfo = item.Item2;
itemLinks += "<div style='background: none; width: 58px; height: 58px;margin: " + yPos + "px " + xPos + "px;'>"
+ "<img class='itempic' src='" + "http://realmplayers.com/" + itemInfo.GetIconImageAddress() + "'/>"
+ "<div class='quality' id='" + CharacterViewer.ItemQualityConversion[itemInfo.ItemQuality] + "'></div>"
+ "<img class='itemframe' src='assets/img/icons/ItemNormalFrame.png'/>"
+ CharacterViewer.GenerateItemLink(currentItemDatabase, item.Item1, wowVersion);
var itemUsageCount = itemSummaryDB.GetItemUsageCount(realm, item.Item1);
itemLinks += "<a class='itemplayersframe' href='ItemUsageInfo.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&item=" + item.Item1.ItemID + (item.Item1.SuffixID != 0 ? "&suffix=" + item.Item1.SuffixID : "") + "'>" + itemUsageCount + "</a>";
itemLinks += "</div>";
++recvItemIndex;
}
itemLinks += "</div>";
latestItemsStr += PageUtility.CreateTableRow(""
, PageUtility.CreateTableColumn(itemLinks)
+ PageUtility.CreateTableColumn(PageUtility.CreateColorCodedPlayerLink(realm, recvItem.Item2))
+ PageUtility.CreateTableColumn("<div style='overflow: hidden;white-space: nowrap;'>" + recvItem.Item1.ToString("yyyy-MM-dd") + "</div>"));
}
}
m_LatestItemsHTML = new MvcHtmlString(latestItemsStr);
}
}
public string CreateInventoryInfo(List <PlayerItemInfo> _Items, PlayerRace _Race, PlayerClass _Class, PlayerSex _Sex, WowRealm _Realm = WowRealm.All, WowVersionEnum _WowVersion = WowVersionEnum.Vanilla)
{
string invInfo = "";
string currentItemDatabase = DatabaseAccess.GetCurrentItemDatabaseAddress();
var itemSummaryDB = Hidden.ApplicationInstance.Instance.GetItemSummaryDatabase();
string modelEqString = "";
var itemIDs = _Items.Select((_Value) => _Value.ItemID);
foreach (var item in _Items)
{
var itemInfo = DatabaseAccess.GetItemInfo(item.ItemID, _WowVersion);
if (itemInfo == null)
{
invInfo += "<div class='equipment-slot' id='" + CharacterViewer.ItemSlotToIDConversion[item.Slot] + "'><div class='quality' id='epic'></div><img src='assets/img/icons/inv_misc_questionmark.png'/></div>";
}
else
{
string currInvInfo = "<div class='equipment-slot' id='" + CharacterViewer.ItemSlotToIDConversion[item.Slot] + "'>"
+ "<img class='itempic' src='" + "http://realmplayers.com/" + itemInfo.GetIconImageAddress() + "'/>"
+ "<div class='quality' id='" + CharacterViewer.ItemQualityConversion[itemInfo.ItemQuality] + "'></div>"
+ "<img class='itemframe' src='assets/img/icons/ItemNormalFrame.png'/>"
+ CharacterViewer.GenerateItemLink(currentItemDatabase, item, _WowVersion, itemInfo.GenerateSetPcsStr(itemIDs));
if (item.Slot == ItemSlot.Head && ModelViewerOptions.HideHead == true)
{
}
else
{
if ((_Class == VF_RealmPlayersDatabase.PlayerClass.Hunter && (item.Slot == ItemSlot.Main_Hand || item.Slot == ItemSlot.Off_Hand)) ||
(_Class != VF_RealmPlayersDatabase.PlayerClass.Hunter && item.Slot == ItemSlot.Ranged))
{
}
else
{
int modelViewerID = 0;
int modelViewerSlot = 0;
if (itemInfo.GetModelViewerIDAndSlot(item.Slot, out modelViewerID, out modelViewerSlot, true) == true)
{
if (item.Slot == ItemSlot.Off_Hand)
{
if (itemInfo.AjaxTooltip.Contains("Shield") == false)
{
modelViewerSlot = 22;
}
}
if (modelViewerID != 0)
{
modelEqString = modelEqString + "," + modelViewerSlot + "," + modelViewerID;
}
}
}
}
//List<Tuple<DateTime, string>> players = null;
if (_Realm != WowRealm.All)
{
int usageCount = itemSummaryDB.GetItemUsageCount(_Realm, item);
currInvInfo += "<a class='itemplayersframe' href='ItemUsageInfo.aspx?realm=" + StaticValues.ConvertRealmParam(_Realm) + "&item=" + item.ItemID + (item.SuffixID != 0 ? "&suffix=" + item.SuffixID : "") + "'>" + usageCount + "</a>";
}
currInvInfo += "</div>";
invInfo += currInvInfo;
}
}
invInfo += "<img style='position: absolute;z-index: 1; pointer-events: none;' src='assets/img/bg/CharacterBackgroundTransparent.png'></img>";
string modelViewerQuery = PageUtility.GetQueryString(Request, "modelviewer", "unknown").ToLower();
if (modelViewerQuery != "false" && modelEqString != "" && ModelViewerOptions.View3DModel == true)
{
if (modelEqString[0] == ',')//För att bli av med det första ","
{
modelEqString = modelEqString.Substring(1);
}
//modelEqString = "1,33743,3,33653,5,33650,6,31110,7,31115,8,31111,9,31127,10,33651,13,25629";
string modelCharString = ((_Race == VF_RealmPlayersDatabase.PlayerRace.Undead) ? "Scourge" : _Race.ToString().Replace("_", "")) + _Sex.ToString();// "orcmale";
invInfo += "<div style='z-index: 0; position: absolute; margin: 33px 77px; width:385px; height:512px;'><object type='application/x-shockwave-flash' data='http://wow.zamimg.com/modelviewer/ZAMviewerfp11.swf' width='385' height='512' id='dsjkgbdsg2346' style='visibility: visible;'>"
+ "<param name='quality' value='low'>"
+ "<param name='allowscriptaccess' value='always'>"
+ "<param name='allowfullscreen' value='false'>"
+ "<param name='menu' value='false'>"
+ "<param name='bgcolor' value='#181818'>"
+ "<param name='wmode' value='direct'>"
+ "<param name='flashvars' value='hd=false&model="
+ modelCharString
+ "&modelType=16&contentPath=http://wow.zamimg.com/modelviewer/&equipList="
+ modelEqString
+ "'>"
+ "</object></div>";
}
else
{
invInfo += "<img class='characterimage' src='" + StaticValues.GetRaceCrestImageUrl(_Race) + "'></img>";
}
Hidden.ApplicationInstance.Instance.BackupItemInfos();
return(invInfo);
}
protected void Page_Load(object sender, EventArgs e)
{
m_BreadCrumbHTML = new MvcHtmlString(PageUtility.BreadCrumb_AddHome()
+ PageUtility.BreadCrumb_AddFinish("RareItemsList"));
var realm = RealmControl.Realm;
if (realm == WowRealm.Unknown)
{
return;
}
var wowVersion = StaticValues.GetWowVersion(realm);
int count = PageUtility.GetQueryInt(Request, "count", 100);
var itemSummaryDB = Hidden.ApplicationInstance.Instance.GetItemSummaryDatabase();
m_ItemUsageInfoHTML = new MvcHtmlString("<h1>Rarest items<span class='badge badge-inverse'>" + count + " Items</span></h1>"
+ "<p>List contains the most rarest items on the realm.</p>");
Dictionary <PlayerColumn, string[]> extraColumns = new Dictionary <PlayerColumn, string[]>();
PlayerColumn ItemAndAquiredDateAfterColumn = PlayerColumn.Number;
extraColumns.Add(ItemAndAquiredDateAfterColumn, new string[] { "Item", "Count", "First Aquired", "First Player(s)" });
m_TableHeadHTML = new MvcHtmlString(PageUtility.CreatePlayerTableHeaderRow(Table_Columns, extraColumns));
string currentItemDatabase = DatabaseAccess.GetCurrentItemDatabaseAddress();
string tableBody = "";
int nr = 1;
Func <KeyValuePair <ulong, VF_RPDatabase.ItemSummary>, int> lambdaComparison = (_Tuple) => { return(_Tuple.Value.m_ItemOwners.Count((_Value) => (itemSummaryDB.GetPlayerRealm(_Value.Item1) == realm))); };
Func <Tuple <ulong, DateTime>, DateTime> lambdaDateTimeComparison = (_Tuple) => { return(_Tuple.Item2); };
var rareItemsList = itemSummaryDB.m_Items.OrderBy(lambdaComparison);
foreach (var rareItem in rareItemsList)
{
if (nr >= count)
{
break;
}
int rareItemCount = rareItem.Value.m_ItemOwners.Count((_Value) => (itemSummaryDB.GetPlayerRealm(_Value.Item1) == realm));
if (rareItemCount > 0 && Code.Resources.ItemAnalyzer.IsRareItem(rareItem.Value.m_ItemID) == true)
{
var itemInfo = DatabaseAccess.GetItemInfo(rareItem.Value.m_ItemID, wowVersion);
if (itemInfo.ItemQuality < 4)
{
continue;
}
//rareItem.
Player player = null;
var orderedAquires = rareItem.Value.m_ItemOwners.OrderBy(lambdaDateTimeComparison);
DateTime dateTimeCutoff = orderedAquires.First((_Value) => (itemSummaryDB.GetPlayerRealm(_Value.Item1) == realm)).Item2;
if (dateTimeCutoff < new DateTime(2013, 8, 1, 0, 0, 0))
{
dateTimeCutoff = new DateTime(2013, 8, 1, 0, 0, 0);
}
else
{
dateTimeCutoff = dateTimeCutoff.AddDays(3);
}
string firstPlayers = "<div style='overflow: hidden; display: table; height: 58px;'>";
var interestingItems = orderedAquires.Where((_Tuple) => { return(_Tuple.Item2 < dateTimeCutoff && (itemSummaryDB.GetPlayerRealm(_Tuple.Item1) == realm)); });
if (interestingItems.Count() < 5)
{
foreach (var playerAquire in interestingItems)
{
if (playerAquire.Item2 < dateTimeCutoff)
{
player = DatabaseAccess.FindRealmPlayer(this, realm, itemSummaryDB.GetPlayerName(playerAquire.Item1));
if (player != null)
{
var playerFaction = StaticValues.GetFaction(player.Character.Race);
firstPlayers += "<div class='" + StaticValues.GetFactionCSSName(playerFaction) + "_col' style='display: table-cell; width:160px;" /*"background-color: " + (playerFaction == PlayerFaction.Horde ? "#372727" : "#272f37")*/ + "'>";
firstPlayers += "<p style='text-align:center;'><a href='CharacterViewer.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&player=" + System.Web.HttpUtility.HtmlEncode(player.Name) + "'>" + PageUtility.CreateColorCodedName(player.Name, player.Character.Class) + "</a>";
if (player.Guild.GuildName != "nil")
{
string visualGuildName = PageUtility.BreakLongStr(player.Guild.GuildName, 16, 8);
firstPlayers += "<br>" + PageUtility.CreateLink("GuildViewer.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&guild=" + System.Web.HttpUtility.HtmlEncode(player.Guild.GuildName), "<" + visualGuildName + ">") + "</p>";
}
firstPlayers += "</div>";
}
}
else
{
break;
}
}
}
else
{
firstPlayers += "Data not detailed enough<br>(more than 5 players within aquire timespan)";
}
firstPlayers += "</div>";
extraColumns[ItemAndAquiredDateAfterColumn] = new string[] {
"<div class='inventory' style='background: none; width: 58px; height: 58px;'><div>"
+ "<img class='itempic' src='" + "http://realmplayers.com/" + itemInfo.GetIconImageAddress() + "'/>"
+ "<div class='quality' id='" + CharacterViewer.ItemQualityConversion[itemInfo.ItemQuality] + "'></div>"
+ "<img class='itemframe' src='assets/img/icons/ItemNormalFrame.png'/>"
+ CharacterViewer.GenerateItemLink(currentItemDatabase, rareItem.Value.m_ItemID, rareItem.Value.m_SuffixID, wowVersion)
+ "<a class='itemplayersframe' href='ItemUsageInfo.aspx?realm=" + StaticValues.ConvertRealmParam(realm) + "&item=" + rareItem.Value.m_ItemID + (rareItem.Value.m_SuffixID != 0 ? "&suffix=" + rareItem.Value.m_SuffixID : "") + "'>" + rareItemCount.ToString() + "</a>"
+ "</div></div>"
, rareItemCount.ToString()
, " > " + interestingItems.First().Item2.ToString("yyyy-MM-dd") + "<br> < " + dateTimeCutoff.ToString("yyyy-MM-dd")
, firstPlayers
};
tableBody += PageUtility.CreateTableRow("",
PageUtility.CreateTableColumn("#" + (nr++))
+ PageUtility.CreateTableColumn(extraColumns[ItemAndAquiredDateAfterColumn][0])
+ PageUtility.CreateTableColumn(extraColumns[ItemAndAquiredDateAfterColumn][1])
+ PageUtility.CreateTableColumn(extraColumns[ItemAndAquiredDateAfterColumn][2])
+ PageUtility.CreateTableColumn(extraColumns[ItemAndAquiredDateAfterColumn][3]));
}
}
m_TableBodyHTML = new MvcHtmlString(tableBody);
}