[FIX]Marketplace minCost [SWIFT / GENERATING LOGS]
Hello guys,
Today I will teach you how to get rid of that annoying log that talks about "minCost".
So here we go,
First go to -> HabboHotel/Catalogs/Marketplace.cs and search for: internal static ServerMessage SerializeOffers
Replace all void by:
Code:
internal static ServerMessage SerializeOffers(int MinCost, int MaxCost, string SearchQuery, int FilterMode)
{
StringBuilder builder = new StringBuilder();
builder.Append("WHERE state = '1' AND timestamp >= " + FormatTimestampString());
if (MinCost >= 0)
{
builder.Append(" AND total_price > @minCost");
}
if (MaxCost >= 0)
{
builder.Append(" AND total_price < @maxCost");
}
if (SearchQuery.Length >= 1)
{
builder.Append(" AND public_name LIKE @query");
}
switch (FilterMode)
{
case 1:
builder.Append(" ORDER BY asking_price DESC");
break;
case 2:
builder.Append(" ORDER BY asking_price ASC");
break;
}
using (IQueryAdapter adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
adapter.setQuery("SELECT * FROM catalog_marketplace_offers " + builder.ToString());
if (MinCost >= 0)
{
adapter.addParameter("minCost", MinCost);
}
if (MaxCost >= 0)
{
adapter.addParameter("maxCost", MaxCost);
}
if (SearchQuery.Length >= 1)
{
adapter.addParameter("query", "%" + SearchQuery + "%");
}
DataTable table = adapter.getTable();
adapter.setQuery("SELECT COUNT(DISTINCT sprite_id) FROM catalog_marketplace_offers " + builder.ToString() + " LIMIT 250");
int i = adapter.getInteger();
int num2 = 0;
List<int> list = new List<int>();
ServerMessage message = new ServerMessage(Outgoing.GetOffers);
message.AppendInt32(i);
foreach (DataRow row in table.Rows)
{
if (!list.Contains((int)row["sprite_id"]))
{
list.Add((int)row["sprite_id"]);
int[] avarage = GetAvarage((int)row["sprite_id"]);
message.AppendInt32(int.Parse(row["offer_id"].ToString()));
message.AppendInt32(1);
message.AppendInt32(1);
message.AppendInt32((int)row["sprite_id"]);
message.AppendInt32(0);
message.AppendString("");
message.AppendInt32((int)row["total_price"]);
message.AppendInt32(0);
message.AppendInt32(avarage[0]);
message.AppendInt32(avarage[1]);
num2 += avarage[1];
}
}
message.AppendInt32(num2);
return message;
}
}
Okay, now will no longer generate that log boring. And it is free from exploits.
PS.: This fix will avoid that when you open the Marketplace generate logs related to 'minCost'.
Regards,
neto737
Re: [FIX]Marketplace minCost [SWIFT / GENERATING LOGS]
Nice job. Do you think you could find the packets for showing the more info (chart) and showing the "market sell" button in inventory packets?
Re: [FIX]Marketplace minCost [SWIFT / GENERATING LOGS]
Quote:
Originally Posted by
Ddos Attack
Nice job. Do you think you could find the packets for showing the more info (chart) and showing the "market sell" button in inventory packets?
I do not know, now I'm just fixing bugs Swift .. If you can arrange the packets maybe we try to encode together .. :)