public static void Reset()
{
set4p = 0;
ShopAllList.Clear();
ShopBuyableList.Clear();
ShopUniqueList.Clear();
ShopDataMt1.Clear();
ShopDataMt2.Clear();
ShopDataGoods.Clear();
ShopDataItems.Clear();
TotalGoods = 0;
TotalItems = 0;
TotalMatching1 = 0;
TotalMatching2 = 0;
}
public static void Load(int type)
{
try
{
using (NpgsqlConnection connection = SQLjec.getInstance().conn())
{
connection.Open();
NpgsqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT * FROM shop";
command.CommandType = CommandType.Text;
NpgsqlDataReader data = command.ExecuteReader();
while (data.Read())
{
GoodItem good = new GoodItem
{
id = data.GetInt32(0),
price_gold = data.GetInt32(3),
price_cash = data.GetInt32(4),
auth_type = data.GetInt16(6),
buy_type2 = data.GetInt16(7),
buy_type3 = data.GetInt16(8),
tag = data.GetInt16(9),
title = data.GetInt16(10),
visibility = data.GetInt16(11)
};
good._item.SetItemId(data.GetInt32(1));
good._item._name = data.GetString(2);
good._item._count = (UInt32)data.GetInt32(5);
int Static = ComDiv.getIdStatics(good._item._id, 1);
if (type == 1 || type == 2 && Static == 12)
{
ShopAllList.Add(good);
if (good.visibility != 2 && good.visibility != 4)
{
ShopBuyableList.Add(good);
}
if (!ShopUniqueList.ContainsKey(good._item._id) && good.auth_type > 0)
{
ShopUniqueList.Add(good._item._id, good);
if (good.visibility == 4)
{
set4p++;
}
}
}
}
if (type == 1)
{
LoadDataMatching1Goods(0);
LoadDataMatching2(1);
LoadDataItems();
}
command.Dispose();
data.Close();
connection.Dispose();
connection.Close();
}
if (set4p > 0)
{
Printf.warning("[Aviso] Existem " + set4p + " itens na loja invisíveis, porém com os ícones liberados.");
}
}
catch (Exception ex)
{
SaveLog.fatal(ex.ToString());
Printf.b_danger("[ShopManager.Load] Erro fatal!");
}
}
