public override void Read(PacketStream stream)
{
var mainTabId = stream.ReadByte();
var subTabId = stream.ReadByte();
var page = stream.ReadUInt16();
_log.Warn("ICSGoodsList, MainTabId: {0}, SubTabId: {1}, Page: {2}", mainTabId, subTabId, page);
var item = new CashShopItem();
item.CashShopId = 20100010;
item.CashName = "Костюм копейщицы северного Мейра";
item.MainTab = 1;
item.SubTab = 2;
item.LevelMin = 1;
item.LevelMax = 50;
item.ItemTemplateId = 29181;
item.Price = 950;
var itemDetail = new CashShopItemDetail();
itemDetail.CashShopId = 20100010;
itemDetail.CashUniqId = 201000101;
itemDetail.ItemTemplateId = 29181;
itemDetail.ItemCount = 1;
itemDetail.DefaultFlag = 1;
itemDetail.Price = 950;
Connection.SendPacket(new SCICSGoodListPacket(true, 1, item));
Connection.SendPacket(new SCICSGoodDetailPacket(true, itemDetail));
}
public SCICSGoodDetailPacket(bool pageEnd, CashShopItemDetail itemDetail) : base(0x1c7, 1)
{
_pageEnd = pageEnd;
_itemDetail = itemDetail;
}
public SCICSGoodDetailPacket(bool pageEnd, CashShopItemDetail itemDetail) : base(SCOffsets.SCICSGoodDetailPacket, 1)
{
_pageEnd = pageEnd;
_itemDetail = itemDetail;
}
public void Load()
{
_cashShopItem = new List <CashShopItem>();
_cashShopItemDetail = new Dictionary <uint, CashShopItemDetail>();
using (var connection = MySQL.CreateConnection())
{
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM cash_shop_item";
command.Prepare();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var cashShopItem = new CashShopItem();
var cashShopItemDetail = new CashShopItemDetail();
cashShopItemDetail.CashShopId = cashShopItem.CashShopId = reader.GetUInt32("id");
cashShopItemDetail.CashUniqId = reader.GetUInt32("uniq_id");
cashShopItem.CashName = reader.GetString("cash_name");
cashShopItem.MainTab = reader.GetByte("main_tab");
cashShopItem.SubTab = reader.GetByte("sub_tab");
cashShopItem.LevelMin = reader.GetByte("level_min");
cashShopItem.LevelMax = reader.GetByte("level_max");
cashShopItemDetail.ItemTemplateId = cashShopItem.ItemTemplateId = reader.GetUInt32("item_template_id");
cashShopItem.IsSell = reader.GetByte("is_sell");
cashShopItem.IsHidden = reader.GetByte("is_hidden");
cashShopItem.LimitType = reader.GetByte("limit_type");
cashShopItem.BuyCount = reader.GetUInt16("buy_count");
cashShopItem.BuyType = reader.GetByte("buy_type");
cashShopItem.BuyId = reader.GetUInt32("buy_id");
cashShopItem.SDate = reader.GetDateTime("start_date");
cashShopItem.EDate = reader.GetDateTime("end_date");
cashShopItemDetail.PriceType = cashShopItem.Type = reader.GetByte("type");
cashShopItemDetail.Price = cashShopItem.Price = reader.GetUInt32("price");
cashShopItem.Remain = reader.GetUInt32("remain");
cashShopItem.BonusType = reader.GetInt32("bonus_type");
cashShopItem.BonusCount = reader.GetUInt32("bouns_count");
cashShopItem.CmdUi = reader.GetByte("cmd_ui");
cashShopItemDetail.ItemCount = reader.GetUInt32("item_count");
cashShopItemDetail.SelectType = reader.GetByte("select_type");
cashShopItemDetail.DefaultFlag = reader.GetByte("default_flag");
cashShopItemDetail.EventType = reader.GetByte("event_type");
cashShopItemDetail.EventDate = reader.GetDateTime("event_date");
cashShopItemDetail.DisPrice = reader.GetUInt32("dis_price");
_cashShopItem.Add(cashShopItem);
_cashShopItemDetail.Add(cashShopItem.CashShopId, cashShopItemDetail);
}
}
}
}
}