示例#1
0
        public ServerMessage method_5(int int_0, int int_1, string string_0, int int_2)
        {
            DataTable     dataTable     = null;
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("WHERE state = '1' AND timestamp >= " + this.method_4());
            if (int_0 >= 0)
            {
                stringBuilder.Append(" AND total_price > " + int_0);
            }
            if (int_1 >= 0)
            {
                stringBuilder.Append(" AND total_price < " + int_1);
            }
            string text;

            switch (int_2)
            {
            case 1:
                text = "ORDER BY asking_price DESC";
                goto IL_82;
            }
            text = "ORDER BY asking_price ASC";
IL_82:
            using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
            {
                @class.AddParamWithValue("search_query", "%" + string_0 + "%");
                if (string_0.Length >= 1)
                {
                    stringBuilder.Append(" AND public_name LIKE @search_query");
                }
                dataTable = @class.ReadDataTable(string.Concat(new string[]
                {
                    "SELECT offer_id, item_type, sprite_id, total_price FROM catalog_marketplace_offers ",
                    stringBuilder.ToString(),
                    " ",
                    text,
                    " LIMIT 500"
                }));
            }
            ServerMessage Message = new ServerMessage(615u);

            this.list_1.Clear();
            this.list_0.Clear();
            if (dataTable != null)
            {
                foreach (DataRow dataRow in dataTable.Rows)
                {
                    if (!this.list_0.Contains((uint)dataRow["offer_id"]))
                    {
                        MarketplaceOffers item = new MarketplaceOffers((uint)dataRow["offer_id"], (int)dataRow["sprite_id"], (int)dataRow["total_price"], int.Parse(dataRow["item_type"].ToString()));
                        this.list_0.Add((uint)dataRow["offer_id"]);
                        this.list_1.Add(item);
                    }
                }
                return(this.method_6(int_0, int_1));
            }
            else
            {
                Message.AppendInt32(0);
                return(Message);
            }
        }
示例#2
0
 public ServerMessage method_5(int int_0, int int_1, string string_0, int int_2)
 {
     DataTable dataTable = null;
     StringBuilder stringBuilder = new StringBuilder();
     stringBuilder.Append("WHERE state = '1' AND timestamp >= " + this.method_4());
     if (int_0 >= 0)
     {
         stringBuilder.Append(" AND total_price > " + int_0);
     }
     if (int_1 >= 0)
     {
         stringBuilder.Append(" AND total_price < " + int_1);
     }
     string text;
     switch (int_2)
     {
     case 1:
         text = "ORDER BY asking_price DESC";
         goto IL_82;
     }
     text = "ORDER BY asking_price ASC";
     IL_82:
     using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
     {
         @class.AddParamWithValue("search_query", "%" + string_0 + "%");
         if (string_0.Length >= 1)
         {
             stringBuilder.Append(" AND public_name LIKE @search_query");
         }
         dataTable = @class.ReadDataTable(string.Concat(new string[]
         {
             "SELECT offer_id, item_type, sprite_id, total_price FROM catalog_marketplace_offers ",
             stringBuilder.ToString(),
             " ",
             text,
             " LIMIT 500"
         }));
     }
     ServerMessage Message = new ServerMessage(615u);
     this.list_1.Clear();
     this.list_0.Clear();
     if (dataTable != null)
     {
         foreach (DataRow dataRow in dataTable.Rows)
         {
             if (!this.list_0.Contains((uint)dataRow["offer_id"]))
             {
                 MarketplaceOffers item = new MarketplaceOffers((uint)dataRow["offer_id"], (int)dataRow["sprite_id"], (int)dataRow["total_price"], int.Parse(dataRow["item_type"].ToString()));
                 this.list_0.Add((uint)dataRow["offer_id"]);
                 this.list_1.Add(item);
             }
         }
         return this.method_6(int_0, int_1);
     }
     else
     {
         Message.AppendInt32(0);
         return Message;
     }
 }