Reply to thread

Message

<blockquote data-quote="treebeard" data-source="post: 430090" data-attributes="member: 79259">Hello everyone,I've recently been trying to get the marketplace working in my Plus emulator R2. When trying to add a new furni offer to the marketplace I get this error immediately:<img src="https://i.imgur.com/U1irhWk.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> Here's the packet headers I have in my Communication &gt; Packets:[CODE]Client Packet Header--------------------public const int GetMarketplaceCanMakeOfferMessageEvent = 1552;//1647public const int GetMarketplaceItemStatsMessageEvent = 1561;//1203public const int GetMarketplaceConfigurationMessageEvent = 2811;//1604Server Packet Header--------------------public const int MarketplaceCanMakeOfferResultMessageComposer = 2452;//1874public const int MarketplaceConfigurationMessageComposer = 1817;//3702public const int MarketplaceItemStatsMessageComposer = 480;//2909public const int MarketPlaceOwnOffersMessageComposer = 1892;//2806public const int MarketPlaceOffersMessageComposer = 291;//2985public const int MarketplaceMakeOfferResultMessageComposer = 480;//3960public const int MarketplaceCancelOfferResultMessageComposer = 1892;//202[/CODE]Here's the code I have for marketplace in my EMU:MarketOffer.cs[CODE]namespace Plus.HabboHotel.Catalog.Marketplace{&nbsp; &nbsp; public class MarketOffer&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public int OfferID { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public int ItemType { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public int SpriteId { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public int TotalPrice { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public int LimitedNumber { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public int LimitedStack { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; public MarketOffer(int OfferID, int SpriteId, int TotalPrice, int ItemType, int LimitedNumber, int LimitedStack)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.OfferID = OfferID;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.SpriteId = SpriteId;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.ItemType = ItemType;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.TotalPrice = TotalPrice;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.LimitedNumber = LimitedNumber;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.LimitedStack = LimitedStack;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE]MarketplaceManager.cs[CODE]using System;using System.Collections.Generic;using Plus.Database.Interfaces;namespace Plus.HabboHotel.Catalog.Marketplace{&nbsp; &nbsp; public class MarketplaceManager&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public List&lt;int&gt; MarketItemKeys = new List&lt;int&gt;();&nbsp; &nbsp; &nbsp; &nbsp; public List&lt;MarketOffer&gt; MarketItems = new List&lt;MarketOffer&gt;();&nbsp; &nbsp; &nbsp; &nbsp; public Dictionary&lt;int, int&gt; MarketCounts = new Dictionary&lt;int, int&gt;();&nbsp; &nbsp; &nbsp; &nbsp; public Dictionary&lt;int, int&gt; MarketAverages = new Dictionary&lt;int, int&gt;();&nbsp; &nbsp; &nbsp; &nbsp; public MarketplaceManager()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public int AvgPriceForSprite(int SpriteID)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int num = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int num2 = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (this.MarketAverages.ContainsKey(SpriteID) &amp;&amp; this.MarketCounts.ContainsKey(SpriteID))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (this.MarketCounts[SpriteID] &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (this.MarketAverages[SpriteID] / this.MarketCounts[SpriteID]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbClient.SetQuery(&quot;SELECT `avgprice` FROM `catalog_marketplace_data` WHERE `sprite` = '&quot; + SpriteID + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; num = dbClient.GetInteger();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbClient.SetQuery(&quot;SELECT `sold` FROM `catalog_marketplace_data` WHERE `sprite` = '&quot; + SpriteID + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; num2 = dbClient.GetInteger();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.MarketAverages.Add(SpriteID, num);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.MarketCounts.Add(SpriteID, num2);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (num2 &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return Convert.ToInt32(Math.Ceiling((double)(num / num2)));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 0;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string FormatTimestampString()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return this.FormatTimestamp().ToString().Split(new char[] { ',' })[0];&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public double FormatTimestamp()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (PlusEnvironment.GetUnixTimestamp() - 172800.0);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public int OfferCountForSprite(int SpriteID)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dictionary&lt;int, MarketOffer&gt; dictionary = new Dictionary&lt;int, MarketOffer&gt;();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dictionary&lt;int, int&gt; dictionary2 = new Dictionary&lt;int, int&gt;();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (MarketOffer item in this.MarketItems)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (dictionary.ContainsKey(item.SpriteId))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (dictionary[item.SpriteId].TotalPrice &gt; item.TotalPrice)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dictionary.Remove(item.SpriteId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dictionary.Add(item.SpriteId, item);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int num = dictionary2[item.SpriteId];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dictionary2.Remove(item.SpriteId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dictionary2.Add(item.SpriteId, num + 1);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dictionary.Add(item.SpriteId, item);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dictionary2.Add(item.SpriteId, 1);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (dictionary2.ContainsKey(SpriteID))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return dictionary2[SpriteID];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 0;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public int CalculateComissionPrice(float SellingPrice)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return Convert.ToInt32(Math.Ceiling(SellingPrice / 100 * 1));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE]&amp; I'm using PRODUCTION-201701242205-837386173If there's any other information that can better equip you to assist me, feel free to let me know.As always, I appreciate the time, energy, and effort that goes into all feedback. Thanks!</blockquote>

[QUOTE="treebeard, post: 430090, member: 79259"] Hello everyone, I've recently been trying to get the marketplace working in my Plus emulator R2. When trying to add a new furni offer to the marketplace I get this error immediately: [IMG]https://i.imgur.com/U1irhWk.png[/IMG] [B][U]Here's the packet headers I have in my Communication > Packets:[/U][/B] [CODE]Client Packet Header -------------------- public const int GetMarketplaceCanMakeOfferMessageEvent = 1552;//1647 public const int GetMarketplaceItemStatsMessageEvent = 1561;//1203 public const int GetMarketplaceConfigurationMessageEvent = 2811;//1604 Server Packet Header -------------------- public const int MarketplaceCanMakeOfferResultMessageComposer = 2452;//1874 public const int MarketplaceConfigurationMessageComposer = 1817;//3702 public const int MarketplaceItemStatsMessageComposer = 480;//2909 public const int MarketPlaceOwnOffersMessageComposer = 1892;//2806 public const int MarketPlaceOffersMessageComposer = 291;//2985 public const int MarketplaceMakeOfferResultMessageComposer = 480;//3960 public const int MarketplaceCancelOfferResultMessageComposer = 1892;//202[/CODE] Here's the code I have for marketplace in my EMU: [B][U]MarketOffer.cs[/U][/B] [CODE]namespace Plus.HabboHotel.Catalog.Marketplace { public class MarketOffer { public int OfferID { get; set; } public int ItemType { get; set; } public int SpriteId { get; set; } public int TotalPrice { get; set; } public int LimitedNumber { get; set; } public int LimitedStack { get; set; } public MarketOffer(int OfferID, int SpriteId, int TotalPrice, int ItemType, int LimitedNumber, int LimitedStack) { this.OfferID = OfferID; this.SpriteId = SpriteId; this.ItemType = ItemType; this.TotalPrice = TotalPrice; this.LimitedNumber = LimitedNumber; this.LimitedStack = LimitedStack; } } }[/CODE] [B][U]MarketplaceManager.cs[/U][/B] [CODE]using System; using System.Collections.Generic; using Plus.Database.Interfaces; namespace Plus.HabboHotel.Catalog.Marketplace { public class MarketplaceManager { public List<int> MarketItemKeys = new List<int>(); public List<MarketOffer> MarketItems = new List<MarketOffer>(); public Dictionary<int, int> MarketCounts = new Dictionary<int, int>(); public Dictionary<int, int> MarketAverages = new Dictionary<int, int>(); public MarketplaceManager() { } public int AvgPriceForSprite(int SpriteID) { int num = 0; int num2 = 0; if (this.MarketAverages.ContainsKey(SpriteID) && this.MarketCounts.ContainsKey(SpriteID)) { if (this.MarketCounts[SpriteID] > 0) { return (this.MarketAverages[SpriteID] / this.MarketCounts[SpriteID]); } return 0; } using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `avgprice` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1"); num = dbClient.GetInteger(); dbClient.SetQuery("SELECT `sold` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1"); num2 = dbClient.GetInteger(); } this.MarketAverages.Add(SpriteID, num); this.MarketCounts.Add(SpriteID, num2); if (num2 > 0) return Convert.ToInt32(Math.Ceiling((double)(num / num2))); return 0; } public string FormatTimestampString() { return this.FormatTimestamp().ToString().Split(new char[] { ',' })[0]; } public double FormatTimestamp() { return (PlusEnvironment.GetUnixTimestamp() - 172800.0); } public int OfferCountForSprite(int SpriteID) { Dictionary<int, MarketOffer> dictionary = new Dictionary<int, MarketOffer>(); Dictionary<int, int> dictionary2 = new Dictionary<int, int>(); foreach (MarketOffer item in this.MarketItems) { if (dictionary.ContainsKey(item.SpriteId)) { if (dictionary[item.SpriteId].TotalPrice > item.TotalPrice) { dictionary.Remove(item.SpriteId); dictionary.Add(item.SpriteId, item); } int num = dictionary2[item.SpriteId]; dictionary2.Remove(item.SpriteId); dictionary2.Add(item.SpriteId, num + 1); } else { dictionary.Add(item.SpriteId, item); dictionary2.Add(item.SpriteId, 1); } } if (dictionary2.ContainsKey(SpriteID)) { return dictionary2[SpriteID]; } return 0; } public int CalculateComissionPrice(float SellingPrice) { return Convert.ToInt32(Math.Ceiling(SellingPrice / 100 * 1)); } } } [/CODE] & I'm using [B][U]PRODUCTION-201701242205-837386173[/U][/B] If there's any other information that can better equip you to assist me, feel free to let me know. As always, I appreciate the time, energy, and effort that goes into all feedback. Thanks! [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members