public void AddGift(GiftInfo info) { Database db = new Database(); db.sqlexecute.Parameters.AddWithValue("@giftid", info.GiftId); db.sqlexecute.Parameters.AddWithValue("@purchasecode", info.PurchaseCode); db.sqlexecute.Parameters.AddWithValue("@payload", info.Payload); db.ExecuteSQL("INSERT INTO Gifts (GiftID, PurchaseCode, Payload) VALUES (@giftid, @purchasecode, @payload);"); db.sqlexecute.Parameters.Clear(); }
protected void btnApply_Click(object sender, EventArgs e) { if (InstanceManager.Game.Users.UserExists(txtUsername.Text)) { UserInfo user = InstanceManager.Game.Users.GetUser(txtUsername.Text); int newId = 0; if (!chkIsGift.Checked) { if (InstanceManager.Game.Catalogue.BuyItem("0", ddPurchaseCode.SelectedValue, "", ref user, true, ref newId)) { ServerCommunicator servComm = new ServerCommunicator(); servComm.SendModCommandToServer("updatehand", mUser.userId, user.userId, "None"); lblInfo.Text = "Item Spawned!"; } else { lblInfo.Text = "Failed to spawn item!"; } } else { int furniId = InstanceManager.Game.Furni.CreateNewFurni(InstanceManager.Game.Furni.GetRandomPresentDefinition(), user.userId); GiftInfo gift = new GiftInfo(); gift.GiftId = furniId; gift.Payload = ""; gift.PurchaseCode = ddPurchaseCode.SelectedValue; InstanceManager.Game.Furni.AddGift(gift); InstanceManager.Game.Furni.SetStuffDataFloorItem(furniId, "!" + SpecialFiltering.FilterChars("2,9,10,13,47", txtMessage.Text)); ServerCommunicator servComm = new ServerCommunicator(); servComm.SendModCommandToServer("updatehand", mUser.userId, user.userId, "None"); lblInfo.Text = "Gift spawned!"; } } else { lblInfo.Text = "Invalid user!"; } }
public GiftInfo GetGift(int giftId) { Database db = new Database(); db.sqlexecute.Parameters.AddWithValue("@giftid", giftId); DataRow dRow = db.GetDataSet("SELECT * FROM Gifts Where GiftID = @giftid;").Tables[0].Rows[0]; db.sqlexecute.Parameters.Clear(); GiftInfo info = new GiftInfo(); info.GiftId = (int)dRow["GiftID"]; info.Payload = dRow["Payload"].ToString(); info.PurchaseCode = dRow["PurchaseCode"].ToString(); return info; }