public void AwardItem() { CCreateItem msg = new CCreateItem(); msg.luck = attr_intelligence; msg.fromFrontend = false; Network.Incoming.OnRecvPlayerTakeItem(connection, msg); }
public void PlayerTakeItem() { CCreateItem msg = new CCreateItem(); Debug.Log("Take item"); int count = FrontEnd.World.Instance.fPlayer.inventory.Count; if (count >= FrontEnd.World.Instance.fPlayer.inventory_max) { MessageBox.Show("Can't get more Items."); } else { MyNetwork.Send(msg); } }
public void CreateItem() { CCreateItem msg = new CCreateItem(); Debug.Log("Take item"); refreshAttr(); msg.luck = intelligence; int count = inventory.Count; if (count >= inventory_max) { MessageBox.Show("Can't get more Items."); } else { Client.Instance.Send(msg); } }
static public void OnRecvPlayerTakeItem(IChannel channel, Message message) { SGetItem response = new SGetItem(); CCreateItem request = message as CCreateItem; Player player = channel.GetContent() as Player; DItem item = FItem.CreateRandomItem(request.luck).ToDItem(); using (var conn = GameDataBase.GetConnection()) { using (var trans = conn.BeginTransaction()) { int item_id; using (var cmd = conn.CreateCommand()) { cmd.CommandText = "Select items_count From Player Where player_id=@player_id And items_count<40;"; cmd.Parameters.AddWithValue("player_id", player.player_id); var res = cmd.ExecuteScalar(); if (res == null) { trans.Rollback(); ClientTipInfo(channel, "Full Inventory! Cannot Get More Items."); return; } } using (var cmd = conn.CreateCommand()) { cmd.CommandText = "Insert Into Item(item_id, player_id, type, status, name," + "health_value, speed_value, damage_value, intelligence_value, defence_value, icon, silver_value)" + "Values(DEFAULT, @player_id, '" + item.item_type + "', 'Storing', @name," + "@health_value, @speed_value, @damage_value, @intelligence_value, @defence_value, @icon, @silver_value) Returning item_id;"; cmd.Parameters.AddWithValue("player_id", player.player_id); //cmd.Parameters.AddWithValue("type", item.item_type.ToString()); cmd.Parameters.AddWithValue("name", item.name); cmd.Parameters.AddWithValue("health_value", item.health_value); cmd.Parameters.AddWithValue("speed_value", item.speed_value); cmd.Parameters.AddWithValue("damage_value", item.damage_value); cmd.Parameters.AddWithValue("intelligence_value", item.intelligence_value); cmd.Parameters.AddWithValue("defence_value", item.defence_value); cmd.Parameters.AddWithValue("icon", item.icon_name); cmd.Parameters.AddWithValue("silver_value", item.silver_value); var res = cmd.ExecuteScalar(); if (res == null) { trans.Rollback(); ClientTipInfo(channel, "Fail to pick new item!"); return; } item_id = (int)res; } using (var cmd = conn.CreateCommand()) { cmd.CommandText = "Update Player Set items_count=items_count+1 Where player_id=@player_id;"; cmd.Parameters.AddWithValue("player_id", player.player_id); var res = cmd.ExecuteNonQuery(); if (res != 1) { trans.Rollback(); ClientTipInfo(channel, "Fail to pick new item [2] !"); return; } } trans.Commit(); item.item_id = item_id; response.success = true; response.dItem = item; channel.Send(response); if (request.fromFrontend) { SBroadcastMessage bmsg = new SBroadcastMessage(); bmsg.message = string.Format("{0} 通过寻宝获得物品 {1}", player.user, response.dItem.name); World.Instance.Broundcast(bmsg); } } // trans } // conn }