uint num10; uint base_id = 4692;
using (adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
adapter.setQuery("SELECT item_id FROM items_base WHERE item_name = 'matic_box' LIMIT 1");
base_id = Convert.ToUInt32(adapter.getInteger());
if (adapter.dbType == DatabaseType.MSSQL)
{
adapter.setQuery(string.Concat(new object[] { "INSERT INTO items (base_id, rareid,placedBy) OUTPUT INSERTED.* VALUES ('",base_id,"','','",this.Session.GetHabbo().Id,"')" }));
}
else
{
adapter.setQuery(string.Concat(new object[] { "INSERT INTO items (base_id, rareid, placedBy) VALUES ('", base_id, "','0','", this.Session.GetHabbo().Id, "')" }));
}
num10 = (uint)adapter.insertQuery();
adapter.runFastQuery(string.Concat(new object[] { "INSERT INTO items_users VALUES (", num10, ",", Session.GetHabbo().Id, ")" }));
adapter.setQuery("INSERT INTO items_extradata VALUES (" + num10 + ",@timestamp)");
adapter.addParameter("timestamp", DateTime.Now.ToLongDateString());
adapter.runQuery();
adapter.setQuery(string.Concat(new object[] { "INSERT INTO user_presents (item_id,base_id,amount,extra_data) VALUES (", num10, ",", randomEcotronReward.BaseId, ",'1','')" }));
adapter.runQuery();
}
UserItem item3 = Session.GetHabbo().GetInventoryComponent().AddNewItem(num10, base_id, DateTime.Now.ToLongDateString(), false, false, 0, "", 0);
Session.GetHabbo().GetInventoryComponent().SendFloorInventoryUpdate();