private void OnRecvGetWorldMarket(IChannel channel, Message message)
{
CGetWorldMarket request = message as CGetWorldMarket;
Player player = (Player)channel.GetContent();
var connString = "Host=localhost;Port=5432;Username=postgres;Password=123456;Database=postgres";
SWorldMarketAttribute response = new SWorldMarketAttribute();
Console.WriteLine("Getting world market items");
var conn = new NpgsqlConnection(connString);
conn.Open();
var cmd = new NpgsqlCommand("SELECT item_id,item,seller,price,state FROM worldmarket", conn);
Console.WriteLine("sql finished");
var reader = cmd.ExecuteReader();
String world_market_item_id;
player.world_market_item_name.Clear();
player.world_market_item_price.Clear();
player.world_market_item_seller.Clear();
while (reader.Read())
{
if (Convert.ToInt16(reader["state"]) == 0)
{
world_market_item_id = Convert.ToString(reader["item_id"]);
//Console.WriteLine(reader["item_id"]);
player.world_market_item_name.Add(world_market_item_id, Convert.ToString(reader["item"]));
//Console.WriteLine(reader["item"]);
player.world_market_item_seller.Add(world_market_item_id, Convert.ToString(reader["seller"]));
//Console.WriteLine(reader["seller"]);
player.world_market_item_price.Add(world_market_item_id, Convert.ToInt16(reader["price"]));
//Console.WriteLine(reader["price"]);
}
}
reader.Close();
response.world_market_item_name = player.world_market_item_name;
response.world_market_item_seller = player.world_market_item_seller;
response.world_market_item_price = player.world_market_item_price;
channel.Send(response);
}
public void OnRefreshClicked()
{
foreach (Transform transform in this.transform)
{
Destroy(transform.gameObject);
}
CGetWorldMarket get = new CGetWorldMarket();
Client.Instance.Send(get);
foreach (KeyValuePair <string, string> kv in WorldMarket.world_market_item_name)
{
string key = kv.Key;
string seller = WorldMarket.world_market_item_seller[key];
if (seller != Attribute.name)
{
GameObject cloned = GameObject.Instantiate(WorldMarketShelfItem);
if (cloned == null)
{
continue;
}
cloned.SetActive(true);
cloned.transform.SetParent(this.transform, false);
WorldMarketShelfItemUI handler = cloned.GetComponent <WorldMarketShelfItemUI>();
if (handler == null)
{
continue;
}
//Debug.Log(key + " seller " + seller + " name " + Attribute.name);
handler.Init(key);
}
}
WorldMarketShelfItem.SetActive(false);
//GameObject.FindObjectOfType<CoinsUI>().GValue.SetText(Convert.ToString(Gamekit3D.Attribute.gold_coins), true);
//GameObject.FindObjectOfType<CoinsUI>().SValue.SetText(Convert.ToString(Gamekit3D.Attribute.silver_coins), true);
}
