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;
}
