public static Item CreateGiftItem(ItemData Data, Habbo Habbo, string ExtraData, string DisplayFlags, int ItemId, int LimitedNumber = 0, int LimitedStack = 0)
{
if (Data == null) throw new InvalidOperationException("Data cannot be null.");
Item Item = new Item(ItemId, 0, Data.Id, ExtraData, 0, 0, 0, 0, Habbo.Id, 0, LimitedNumber, LimitedStack, "");
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `items` (`id`,base_item,user_id,room_id,x,y,z,wall_pos,rot,extra_data,`limited_number`,`limited_stack`) VALUES (@id, @did,@uid,@rid,@x,@y,@z,@wall_pos,@rot,@extra_data, @limited_number, @limited_stack)");
dbClient.AddParameter("id", ItemId);
dbClient.AddParameter("did", Data.Id);
dbClient.AddParameter("uid", Habbo.Id);
dbClient.AddParameter("rid", 0);
dbClient.AddParameter("x", 0);
dbClient.AddParameter("y", 0);
dbClient.AddParameter("z", 0);
dbClient.AddParameter("wall_pos", "");
dbClient.AddParameter("rot", 0);
dbClient.AddParameter("extra_data", ExtraData);
dbClient.AddParameter("limited_number", LimitedNumber);
dbClient.AddParameter("limited_stack", LimitedStack);
dbClient.RunQuery();
return Item;
}
}
public OpenGiftComposer(ItemData Data, string Text, Item Item, bool ItemIsInRoom)
: base(ServerPacketHeader.OpenGiftMessageComposer)
{
base.WriteString(Data.Type.ToString());
base.WriteInteger(Data.SpriteId);
base.WriteString(Data.ItemName);
base.WriteInteger(Item.Id);
base.WriteString(Data.Type.ToString());
base.WriteBoolean(ItemIsInRoom);//Is it in the room?
base.WriteString(Text);
}
public PurchaseOKComposer(CatalogItem Item, ItemData BaseItem)
: base(ServerPacketHeader.PurchaseOKMessageComposer)
{
base.WriteInteger(BaseItem.Id);
base.WriteString(BaseItem.ItemName);
base.WriteBoolean(false);
base.WriteInteger(Item.CostCredits);
base.WriteInteger(Item.CostPixels);
base.WriteInteger(0);
base.WriteBoolean(true);
base.WriteInteger(1);
base.WriteString(BaseItem.Type.ToString().ToLower());
base.WriteInteger(BaseItem.SpriteId);
base.WriteString("");
base.WriteInteger(1);
base.WriteInteger(0);
base.WriteString("");
base.WriteInteger(1);
}
public CatalogItem(int Id, int ItemId, ItemData Data, string CatalogName, int PageId, int CostCredits, int CostPixels,
int CostDiamonds, int Amount, int LimitedEditionSells, int LimitedEditionStack, bool HaveOffer, string ExtraData, string Badge, int OfferId)
{
this.Id = Id;
this.Name = CatalogName;
this.ItemId = ItemId;
this.Data = Data;
this.PageID = PageId;
this.CostCredits = CostCredits;
this.CostPixels = CostPixels;
this.CostDiamonds = CostDiamonds;
this.Amount = Amount;
this.LimitedEditionSells = LimitedEditionSells;
this.LimitedEditionStack = LimitedEditionStack;
this.IsLimited = (LimitedEditionStack > 0);
this.HaveOffer = HaveOffer;
this.ExtraData = ExtraData;
this.Badge = Badge;
this.OfferId = OfferId;
}
public static List<Item> CreateMultipleItems(ItemData Data, Habbo Habbo, string ExtraData, int Amount, int GroupId = 0)
{
if (Data == null) throw new InvalidOperationException("Data cannot be null.");
List<Item> Items = new List<Item>();
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
for (int i = 0; i < Amount; i++)
{
dbClient.SetQuery("INSERT INTO `items` (base_item,user_id,room_id,x,y,z,wall_pos,rot,extra_data) VALUES(@did,@uid,@rid,@x,@y,@z,@wallpos,@rot,@flags);");
dbClient.AddParameter("did", Data.Id);
dbClient.AddParameter("uid", Habbo.Id);
dbClient.AddParameter("rid", 0);
dbClient.AddParameter("x", 0);
dbClient.AddParameter("y", 0);
dbClient.AddParameter("z", 0);
dbClient.AddParameter("wallpos", "");
dbClient.AddParameter("rot", 0);
dbClient.AddParameter("flags", ExtraData);
Item Item = new Item(Convert.ToInt32(dbClient.InsertQuery()), 0, Data.Id, ExtraData, 0, 0, 0, 0, Habbo.Id, GroupId, 0, 0, "");
if (GroupId > 0)
{
dbClient.SetQuery("INSERT INTO `items_groups` (`id`, `group_id`) VALUES (@id, @gid)");
dbClient.AddParameter("id", Item.Id);
dbClient.AddParameter("gid", GroupId);
dbClient.RunQuery();
}
Items.Add(Item);
}
}
return Items;
}
public bool GetItem(int Id, out ItemData Item)
{
if (this._items.TryGetValue(Id, out Item))
return true;
return false;
}
public bool GetGift(int SpriteId, out ItemData Item)
{
if (this._gifts.TryGetValue(SpriteId, out Item))
return true;
return false;
}
public static List<Item> CreateTeleporterItems(ItemData Data, Habbo Habbo, int GroupId = 0)
{
List<Item> Items = new List<Item>();
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `items` (base_item,user_id,room_id,x,y,z,wall_pos,rot,extra_data) VALUES(@did,@uid,@rid,@x,@y,@z,@wallpos,@rot,@flags);");
dbClient.AddParameter("did", Data.Id);
dbClient.AddParameter("uid", Habbo.Id);
dbClient.AddParameter("rid", 0);
dbClient.AddParameter("x", 0);
dbClient.AddParameter("y", 0);
dbClient.AddParameter("z", 0);
dbClient.AddParameter("wallpos", "");
dbClient.AddParameter("rot", 0);
dbClient.AddParameter("flags", "");
int Item1Id = Convert.ToInt32(dbClient.InsertQuery());
dbClient.SetQuery("INSERT INTO `items` (base_item,user_id,room_id,x,y,z,wall_pos,rot,extra_data) VALUES(@did,@uid,@rid,@x,@y,@z,@wallpos,@rot,@flags);");
dbClient.AddParameter("did", Data.Id);
dbClient.AddParameter("uid", Habbo.Id);
dbClient.AddParameter("rid", 0);
dbClient.AddParameter("x", 0);
dbClient.AddParameter("y", 0);
dbClient.AddParameter("z", 0);
dbClient.AddParameter("wallpos", "");
dbClient.AddParameter("rot", 0);
dbClient.AddParameter("flags", Item1Id.ToString());
int Item2Id = Convert.ToInt32(dbClient.InsertQuery());
Item Item1 = new Item(Item1Id, 0, Data.Id, "", 0, 0, 0, 0, Habbo.Id, GroupId, 0, 0, "");
Item Item2 = new Item(Item2Id, 0, Data.Id, "", 0, 0, 0, 0, Habbo.Id, GroupId, 0, 0, "");
dbClient.SetQuery("INSERT INTO `room_items_tele_links` (`tele_one_id`, `tele_two_id`) VALUES (" + Item1Id + ", " + Item2Id + "), (" + Item2Id + ", " + Item1Id + ")");
dbClient.RunQuery();
Items.Add(Item1);
Items.Add(Item2);
}
return Items;
}
public Item(int Id, int RoomId, int BaseItem, string ExtraData, int X, int Y, Double Z, int Rot, int Userid, int Group, int limitedNumber, int limitedStack, string wallCoord, Room Room = null)
{
ItemData Data = null;
if (PlusEnvironment.GetGame().GetItemManager().GetItem(BaseItem, out Data))
{
this.Id = Id;
this.RoomId = RoomId;
this._room = Room;
this._data = Data;
this.BaseItem = BaseItem;
this.ExtraData = ExtraData;
this.GroupId = Group;
this._coordX = X;
this._coordY = Y;
if (!double.IsInfinity(Z))
this._coordZ = Z;
this.Rotation = Rot;
this.UpdateNeeded = false;
this.UpdateCounter = 0;
this.InteractingUser = 0;
this.InteractingUser2 = 0;
this.interactingBallUser = 0;
this.interactionCount = 0;
this.value = 0;
this.UserID = Userid;
this.Username = PlusEnvironment.GetUsernameById(Userid);
this.LimitedNo = limitedNumber;
this.LimitedTot = limitedStack;
switch (GetBaseItem().InteractionType)
{
case InteractionType.TELEPORT:
RequestUpdate(0, true);
break;
case InteractionType.HOPPER:
RequestUpdate(0, true);
break;
case InteractionType.ROLLER:
mIsRoller = true;
if (RoomId > 0)
{
GetRoom().GetRoomItemHandler().GotRollers = true;
}
break;
case InteractionType.banzaiscoreblue:
case InteractionType.footballcounterblue:
case InteractionType.banzaigateblue:
case InteractionType.FREEZE_BLUE_GATE:
case InteractionType.freezebluecounter:
team = TEAM.BLUE;
break;
case InteractionType.banzaiscoregreen:
case InteractionType.footballcountergreen:
case InteractionType.banzaigategreen:
case InteractionType.freezegreencounter:
case InteractionType.FREEZE_GREEN_GATE:
team = TEAM.GREEN;
break;
case InteractionType.banzaiscorered:
case InteractionType.footballcounterred:
case InteractionType.banzaigatered:
case InteractionType.freezeredcounter:
case InteractionType.FREEZE_RED_GATE:
team = TEAM.RED;
break;
case InteractionType.banzaiscoreyellow:
case InteractionType.footballcounteryellow:
case InteractionType.banzaigateyellow:
case InteractionType.freezeyellowcounter:
case InteractionType.FREEZE_YELLOW_GATE:
team = TEAM.YELLOW;
break;
case InteractionType.banzaitele:
{
this.ExtraData = "";
break;
}
}
this.mIsWallItem = (GetBaseItem().Type.ToString().ToLower() == "i");
this.mIsFloorItem = (GetBaseItem().Type.ToString().ToLower() == "s");
if (this.mIsFloorItem)
{
this._affectedPoints = Gamemap.GetAffectedTiles(GetBaseItem().Length, GetBaseItem().Width, GetX, GetY, Rot);
}
else if (this.mIsWallItem)
{
this.wallCoord = wallCoord;
this.mIsWallItem = true;
this.mIsFloorItem = false;
this._affectedPoints = new Dictionary<int, ThreeDCoord>();
}
}
}
public ItemData GetBaseItem()
{
if (this._data == null)
{
ItemData I = null;
if (PlusEnvironment.GetGame().GetItemManager().GetItem(this.BaseItem, out I))
this._data = I;
}
return this._data;
}
public void ResetBaseItem()
{
this._data = null;
this._data = this.GetBaseItem();
}
private void FinishOpenGift(GameClient Session, ItemData BaseItem, Item Present, Room Room, DataRow Row)
{
try
{
if (BaseItem == null || Present == null || Room == null || Row == null)
return;
Thread.Sleep(1500);
bool ItemIsInRoom = true;
Room.GetRoomItemHandler().RemoveFurniture(Session, Present.Id);
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `items` SET `base_item` = @BaseItem, `extra_data` = @edata WHERE `id` = " + Present.Id + " LIMIT 1");
dbClient.AddParameter("BaseItem", Row["base_id"]);
dbClient.AddParameter("edata", Row["extra_data"]);
dbClient.RunQuery();
dbClient.RunQuery("DELETE FROM `user_presents` WHERE `item_id` = " + Present.Id + " LIMIT 1");
}
Present.BaseItem = Convert.ToInt32(Row["base_id"]);
Present.ResetBaseItem();
Present.ExtraData = (!string.IsNullOrEmpty(Convert.ToString(Row["extra_data"])) ? Convert.ToString(Row["extra_data"]) : "");
if (Present.Data.Type == 's')
{
if (!Room.GetRoomItemHandler().SetFloorItem(Session, Present, Present.GetX, Present.GetY, Present.Rotation, true, false, true))
{
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `items` SET `room_id` = '0' WHERE `id` = " + Present.Id + " LIMIT 1");
}
ItemIsInRoom = false;
}
}
else
{
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `items` SET `room_id` = '0' WHERE `id` = " + Present.Id + " LIMIT 1");
}
ItemIsInRoom = false;
}
Session.SendMessage(new OpenGiftComposer(Present.Data, Present.ExtraData, Present, ItemIsInRoom));
Session.GetHabbo().GetInventoryComponent().UpdateItems(true);
}
catch
{
}
}