internal static void SellItem(GameClient Session, uint ItemId, int SellingPrice)
{
UserItem Item = Session.GetHabbo().GetInventoryComponent().GetItem(ItemId);
if (Item == null || SellingPrice > 10000 || !CanSellItem(Item))
{
Session.GetMessageHandler().GetResponse().Init(610);
Session.GetMessageHandler().GetResponse().AppendBoolean(false);
Session.GetMessageHandler().GetResponse();
Session.GetMessageHandler().SendResponse();
return;
}
int Comission = CalculateComissionPrice(SellingPrice);
int TotalPrice = SellingPrice + Comission;
int ItemType = 1;
if (Item.GetBaseItem().Type == 'i')
ItemType++;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
if (dbClient.dbType == DatabaseType.MSSQL)
dbClient.setQuery("INSERT INTO catalog_marketplace_offers (item_id,user_id,asking_price,total_price,public_name,sprite_id,item_type,timestamp,extra_data,state) VALUES (" + Item.BaseItem + "," + Session.GetHabbo().Id + "," + SellingPrice + "," + TotalPrice + ",@public_name," + Item.GetBaseItem().SpriteId + "," + ItemType + "," + ButterflyEnvironment.GetUnixTimestamp() + ",@extra_data, '1')");
else
dbClient.setQuery("INSERT INTO catalog_marketplace_offers (item_id,user_id,asking_price,total_price,public_name,sprite_id,item_type,timestamp,extra_data) VALUES (" + Item.BaseItem + "," + Session.GetHabbo().Id + "," + SellingPrice + "," + TotalPrice + ",@public_name," + Item.GetBaseItem().SpriteId + "," + ItemType + "," + ButterflyEnvironment.GetUnixTimestamp() + ",@extra_data)");
dbClient.addParameter("public_name", Item.GetBaseItem().PublicName);
dbClient.addParameter("extra_data", Item.ExtraData);
dbClient.runQuery();
}
Session.GetHabbo().GetInventoryComponent().RemoveItem(ItemId, false);
Session.GetHabbo().GetInventoryComponent().RunDBUpdate();
Session.GetMessageHandler().GetResponse().Init(610);
Session.GetMessageHandler().GetResponse().AppendBoolean(true);
Session.GetMessageHandler().SendResponse();
}
internal void HandlePurchase(GameClient Session, int PageId, uint ItemId, string ExtraData, Boolean IsGift, string GiftUser, string GiftMessage)
{
CatalogPage Page;
if (!Pages.TryGetValue(PageId, out Page))
return;
if (Page == null || Page.ComingSoon || !Page.Enabled || !Page.Visible || Session == null || Session.GetHabbo() == null)
{
return;
}
if (Page.ClubOnly && !Session.GetHabbo().GetSubscriptionManager().HasSubscription("habbo_club"))
{
return;
}
if (Session.GetHabbo().Rank != Page.MinRank) // Workaround
{
if (Session.GetHabbo().Rank < Page.MinRank)
{
return;
}
}
CatalogItem Item = Page.GetItem(ItemId);
if (Item == null)
{
return;
}
uint GiftUserId = 0;
if (IsGift)
{
if (!Item.GetBaseItem().AllowGift)
{
return;
}
DataRow dRow;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT id FROM users WHERE username = @gift_user");
dbClient.addParameter("gift_user", GiftUser);
dRow = dbClient.getRow();
}
if (dRow == null)
{
Session.GetMessageHandler().GetResponse().Init(76);
Session.GetMessageHandler().GetResponse().AppendBoolean(true);
Session.GetMessageHandler().GetResponse().AppendStringWithBreak(GiftUser);
Session.GetMessageHandler().SendResponse();
return;
}
GiftUserId = Convert.ToUInt32(dRow[0]);
if (GiftUserId == 0)
{
Session.GetMessageHandler().GetResponse().Init(76);
Session.GetMessageHandler().GetResponse().AppendBoolean(true);
Session.GetMessageHandler().GetResponse().AppendStringWithBreak(GiftUser);
Session.GetMessageHandler().SendResponse();
return;
}
}
Boolean CreditsError = false;
Boolean PixelError = false;
if (Session.GetHabbo().Credits < Item.CreditsCost)
{
CreditsError = true;
}
if (Session.GetHabbo().ActivityPoints < Item.PixelsCost)
{
PixelError = true;
}
if (CreditsError || PixelError)
{
Session.GetMessageHandler().GetResponse().Init(68);
Session.GetMessageHandler().GetResponse().AppendBoolean(CreditsError);
Session.GetMessageHandler().GetResponse().AppendBoolean(PixelError);
Session.GetMessageHandler().SendResponse();
return;
}
if (IsGift && Item.GetBaseItem().Type == 'e')
{
Session.SendNotif(LanguageLocale.GetValue("catalog.gift.send.error"));
return;
}
if (Item.CrystalCost > 0)
{
int userCrystals = 0;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT crystals FROM users WHERE id = " + Session.GetHabbo().Id);
userCrystals = dbClient.getInteger();
}
if (Item.CrystalCost > userCrystals)
{
Session.SendNotif(LanguageLocale.GetValue("catalog.crystalerror") + Item.CrystalCost);
return;
}
userCrystals = userCrystals - Item.CrystalCost;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.runFastQuery("UPDATE users SET crystals = " + userCrystals + " WHERE id = " + Session.GetHabbo().Id);
}
Session.SendNotif(LanguageLocale.GetValue("catalog.crystalsbought") + userCrystals);
}
if (Item.OudeCredits > 0)
{
int oudeCredits = 0;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT belcredits FROM users WHERE id = " + Session.GetHabbo().Id);
oudeCredits = dbClient.getInteger();
}
if (Item.OudeCredits > oudeCredits)
{
Session.SendNotif(LanguageLocale.GetValue("catalog.oudebelcreditserror") + Item.OudeCredits);
return;
}
oudeCredits = oudeCredits - Item.OudeCredits;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.runFastQuery("UPDATE users SET belcredits = " + oudeCredits + " WHERE id = " + Session.GetHabbo().Id);
}
Session.SendNotif(LanguageLocale.GetValue("catalog.oudebelcreditsok") + oudeCredits);
}
//Console.WriteLine(Item.GetBaseItem().ItemId);
//Console.WriteLine(Item.GetBaseItem().InteractionType.ToLower());
// Extra Data is _NOT_ filtered at this point and MUST BE VERIFIED BELOW:
switch (Item.GetBaseItem().InteractionType)
{
case InteractionType.none:
ExtraData = "";
break;
case InteractionType.musicdisc:
ExtraData = Item.songID.ToString();
break;
#region Pet handling
case InteractionType.pet0:
case InteractionType.pet1:
case InteractionType.pet2:
case InteractionType.pet3:
case InteractionType.pet4:
case InteractionType.pet5:
case InteractionType.pet6:
case InteractionType.pet7:
case InteractionType.pet8:
case InteractionType.pet9:
case InteractionType.pet10:
case InteractionType.pet11:
case InteractionType.pet12:
case InteractionType.pet14:
case InteractionType.pet15:
try
{
//uint count = 0;
//using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
//{
// dbClient.setQuery("SELECT COUNT(*) FROM user_pets WHERE user_id = " + Session.GetHabbo().Id);
// count = uint.Parse(dbClient.getString());
//}
//if (count > 5)
//{
// Session.SendNotif(LanguageLocale.GetValue("catalog.pets.maxpets"));
// return;
//}
string[] Bits = ExtraData.Split('\n');
string PetName = Bits[0];
string Race = Bits[1];
string Color = Bits[2];
int.Parse(Race); // to trigger any possible errors
if (!CheckPetName(PetName))
return;
if (Race.Length != 1)
return;
if (Color.Length != 6)
return;
}
catch (Exception e) {
//Logging.WriteLine(e.ToString());
Logging.HandleException(e, "Catalog.HandlePurchase");
return;
}
break;
#endregion
case InteractionType.roomeffect:
Double Number = 0;
try
{
if (string.IsNullOrEmpty(ExtraData))
Number = 0;
else
Number = Double.Parse(ExtraData, ButterflyEnvironment.cultureInfo);
}
catch (Exception e) { Logging.HandleException(e, "Catalog.HandlePurchase: " + ExtraData); }
ExtraData = Number.ToString().Replace(',', '.');
break; // maintain extra data // todo: validate
case InteractionType.postit:
ExtraData = "FFFF33";
break;
case InteractionType.dimmer:
ExtraData = "1,1,1,#000000,255";
break;
case InteractionType.trophy:
ExtraData = Session.GetHabbo().Username + Convert.ToChar(9) + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year + Convert.ToChar(9) + ButterflyEnvironment.FilterInjectionChars(ExtraData, true);
break;
default:
ExtraData = "";
break;
}
if (Item.CreditsCost > 0)
{
Session.GetHabbo().Credits -= Item.CreditsCost;
Session.GetHabbo().UpdateCreditsBalance();
}
if (Item.PixelsCost > 0)
{
Session.GetHabbo().ActivityPoints -= Item.PixelsCost;
Session.GetHabbo().UpdateActivityPointsBalance(true);
}
Session.GetMessageHandler().GetResponse().Init(101);
Session.GetMessageHandler().SendResponse();
Session.GetMessageHandler().GetResponse().Init(67);
Session.GetMessageHandler().GetResponse().AppendUInt(Item.GetBaseItem().ItemId);
Session.GetMessageHandler().GetResponse().AppendStringWithBreak(Item.GetBaseItem().Name);
Session.GetMessageHandler().GetResponse().AppendInt32(Item.CreditsCost);
Session.GetMessageHandler().GetResponse().AppendInt32(Item.PixelsCost);
Session.GetMessageHandler().GetResponse().AppendInt32(0);
Session.GetMessageHandler().GetResponse().AppendInt32(1);
Session.GetMessageHandler().GetResponse().AppendStringWithBreak(Item.GetBaseItem().Type.ToString().ToLower());
Session.GetMessageHandler().GetResponse().AppendInt32(Item.GetBaseItem().SpriteId);
Session.GetMessageHandler().GetResponse().AppendStringWithBreak("");
Session.GetMessageHandler().GetResponse().AppendInt32(1);
Session.GetMessageHandler().GetResponse().AppendInt32(0);
Session.GetMessageHandler().SendResponse();
if (IsGift)
{
uint itemID;
//uint GenId = GenerateItemId();
Item Present = GeneratePresent();
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
if (dbClient.dbType == Database_Manager.Database.DatabaseType.MSSQL)
dbClient.setQuery("INSERT INTO items (base_id) OUTPUT INSERTED.* VALUES (" + Present.ItemId + ")");
else
dbClient.setQuery("INSERT INTO items (base_id) VALUES (" + Present.ItemId + ")");
itemID = (uint)dbClient.insertQuery();
dbClient.runFastQuery("INSERT INTO items_users VALUES (" + itemID + "," + GiftUserId + ")");
if (!string.IsNullOrEmpty(GiftMessage))
{
dbClient.setQuery("INSERT INTO items_extradata VALUES (" + itemID + ",@data)");
dbClient.addParameter("data", GiftMessage);
dbClient.runQuery();
}
dbClient.setQuery("INSERT INTO user_presents (item_id,base_id,amount,extra_data) VALUES (" + itemID + "," + Item.GetBaseItem().ItemId + "," + Item.Amount + ",@extra_data)");
dbClient.addParameter("gift_message", "!" + GiftMessage);
dbClient.addParameter("extra_data", ExtraData);
dbClient.runQuery();
}
GameClient Receiver = ButterflyEnvironment.GetGame().GetClientManager().GetClientByUserID(GiftUserId);
if (Receiver != null)
{
Receiver.SendNotif(LanguageLocale.GetValue("catalog.gift.received") + Session.GetHabbo().Username);
Receiver.GetHabbo().GetInventoryComponent().AddNewItem(itemID, Present.ItemId, ExtraData, false, false, 0);
Receiver.GetHabbo().GetInventoryComponent().SendFloorInventoryUpdate();
InventoryComponent targetInventory = Receiver.GetHabbo().GetInventoryComponent();
if (targetInventory != null)
targetInventory.RunDBUpdate();
}
Session.SendNotif(LanguageLocale.GetValue("catalog.gift.sent"));
}
else
{
DeliverItems(Session, Item.GetBaseItem(), Item.Amount, ExtraData, Item.songID);
}
}
internal void DeliverItems(GameClient Session, Item Item, int Amount, String ExtraData, uint songID = 0)
{
switch (Item.Type.ToString())
{
case "i":
case "s":
for (int i = 0; i < Amount; i++)
{
//uint GeneratedId = GenerateItemId();
switch (Item.InteractionType)
{
case InteractionType.pet0:
string[] PetData = ExtraData.Split('\n');
Pet GeneratedPet = CreatePet(Session.GetHabbo().Id, PetData[0], 0, PetData[1], PetData[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet1:
string[] PetData1 = ExtraData.Split('\n');
Pet GeneratedPet1 = CreatePet(Session.GetHabbo().Id, PetData1[0], 1, PetData1[1], PetData1[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet1);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet2:
string[] PetData5 = ExtraData.Split('\n');
Pet GeneratedPet5 = CreatePet(Session.GetHabbo().Id, PetData5[0], 2, PetData5[1], PetData5[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet5);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet3:
string[] PetData2 = ExtraData.Split('\n');
Pet GeneratedPet2 = CreatePet(Session.GetHabbo().Id, PetData2[0], 3, PetData2[1], PetData2[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet2);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet4:
string[] PetData3 = ExtraData.Split('\n');
Pet GeneratedPet3 = CreatePet(Session.GetHabbo().Id, PetData3[0], 4, PetData3[1], PetData3[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet3);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet5:
string[] PetData7 = ExtraData.Split('\n');
Pet GeneratedPet7 = CreatePet(Session.GetHabbo().Id, PetData7[0], 5, PetData7[1], PetData7[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet7);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet6:
string[] PetData4 = ExtraData.Split('\n');
Pet GeneratedPet4 = CreatePet(Session.GetHabbo().Id, PetData4[0], 6, PetData4[1], PetData4[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet4);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet7:
string[] PetData6 = ExtraData.Split('\n');
Pet GeneratedPet6 = CreatePet(Session.GetHabbo().Id, PetData6[0], 7, PetData6[1], PetData6[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet6);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet8:
string[] PetData8 = ExtraData.Split('\n');
Pet GeneratedPet8 = CreatePet(Session.GetHabbo().Id, PetData8[0], 8, PetData8[1], PetData8[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet8);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet9:
string[] PetData9 = ExtraData.Split('\n');
Pet GeneratedPet9 = CreatePet(Session.GetHabbo().Id, PetData9[0], 9, PetData9[1], PetData9[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet9);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet10:
string[] PetData10 = ExtraData.Split('\n');
Pet GeneratedPet10 = CreatePet(Session.GetHabbo().Id, PetData10[0], 10, PetData10[1], PetData10[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet10);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet11:
string[] PetData11 = ExtraData.Split('\n');
Pet GeneratedPet11 = CreatePet(Session.GetHabbo().Id, PetData11[0], 11, PetData11[1], PetData11[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet11);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet12:
string[] PetData12 = ExtraData.Split('\n');
Pet GeneratedPet12 = CreatePet(Session.GetHabbo().Id, PetData12[0], 12, PetData12[1], PetData12[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet12);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet14:
string[] PetData14 = ExtraData.Split('\n');
Pet GeneratedPet14 = CreatePet(Session.GetHabbo().Id, PetData14[0], 14, PetData14[1], PetData14[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet14);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.pet15:
string[] PetData15 = ExtraData.Split('\n');
Pet GeneratedPet15 = CreatePet(Session.GetHabbo().Id, PetData15[0], 15, PetData15[1], PetData15[2]);
Session.GetHabbo().GetInventoryComponent().AddPet(GeneratedPet15);
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, 320, "0", true, false, 0);
break;
case InteractionType.teleport:
uint idOne = Session.GetHabbo().GetInventoryComponent().AddNewItem(0, Item.ItemId, "0", true, false, 0).Id;
uint idTwo = Session.GetHabbo().GetInventoryComponent().AddNewItem(0, Item.ItemId, "0", true, false, 0).Id;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.runFastQuery("INSERT INTO items_tele_links (tele_one_id,tele_two_id) VALUES (" + idOne + "," + idTwo + ")");
dbClient.runFastQuery("INSERT INTO items_tele_links (tele_one_id,tele_two_id) VALUES (" + idTwo + "," + idOne + ")");
}
break;
case InteractionType.dimmer:
uint id = Session.GetHabbo().GetInventoryComponent().AddNewItem(0, Item.ItemId, ExtraData, true, false, 0).Id;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.runFastQuery("INSERT INTO items_moodlight (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (" + id + ",0,1,'#000000,255,0','#000000,255,0','#000000,255,0')");
}
break;
case InteractionType.musicdisc:
{
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, Item.ItemId, songID.ToString(), true, false, songID);
break;
}
default:
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, Item.ItemId, ExtraData, true, false, songID);
break;
}
}
Session.GetHabbo().GetInventoryComponent().UpdateItems(false);
break;
case "e":
for (int i = 0; i < Amount; i++)
{
Session.GetHabbo().GetAvatarEffectsInventoryComponent().AddEffect(Item.SpriteId, 3600);
}
break;
case "h":
for (int i = 0; i < Amount; i++)
{
Session.GetHabbo().GetSubscriptionManager().AddOrExtendSubscription("habbo_club", 2678400);
}
if (!Session.GetHabbo().GetBadgeComponent().HasBadge("HC1"))
{
Session.GetHabbo().GetBadgeComponent().GiveBadge("HC1", true);
}
Session.GetMessageHandler().GetResponse().Init(7);
Session.GetMessageHandler().GetResponse().AppendStringWithBreak("habbo_club");
if (Session.GetHabbo().GetSubscriptionManager().HasSubscription("habbo_club"))
{
Double Expire = Session.GetHabbo().GetSubscriptionManager().GetSubscription("habbo_club").ExpireTime;
Double TimeLeft = Expire - ButterflyEnvironment.GetUnixTimestamp();
int TotalDaysLeft = (int)Math.Ceiling(TimeLeft / 86400);
int MonthsLeft = TotalDaysLeft / 31;
if (MonthsLeft >= 1) MonthsLeft--;
Session.GetMessageHandler().GetResponse().AppendInt32(TotalDaysLeft - (MonthsLeft * 31));
Session.GetMessageHandler().GetResponse().AppendBoolean(true);
Session.GetMessageHandler().GetResponse().AppendInt32(MonthsLeft);
}
else
{
for (int i = 0; i < 3; i++)
{
Session.GetMessageHandler().GetResponse().AppendInt32(0);
}
}
Session.GetMessageHandler().SendResponse();
List<string> Rights = ButterflyEnvironment.GetGame().GetRoleManager().GetRightsForHabbo(Session.GetHabbo());
Session.GetMessageHandler().GetResponse().Init(2);
Session.GetMessageHandler().GetResponse().AppendInt32(Rights.Count);
foreach (string Right in Rights)
{
Session.GetMessageHandler().GetResponse().AppendStringWithBreak(Right);
}
Session.GetMessageHandler().SendResponse();
ButterflyEnvironment.GetGame().GetAchievementManager().ProgressUserAchievement(Session, "ACH_BasicClub", 1); //ACH_VipClub
break;
default:
Session.SendNotif(LanguageLocale.GetValue("catalog.buyerror"));
break;
}
}
internal void RemoveUserFromRoom(GameClient Session, Boolean NotifyClient, Boolean NotifyKick)
{
try
{
if (Session == null)
return;
if (Session.GetHabbo() == null)
return;
Session.GetHabbo().GetAvatarEffectsInventoryComponent().OnRoomExit();
if (NotifyClient)
{
if (NotifyKick)
{
Session.GetMessageHandler().GetResponse().Init(33);
Session.GetMessageHandler().GetResponse().AppendInt32(4008);
Session.GetMessageHandler().SendResponse();
}
Session.GetMessageHandler().GetResponse().Init(18);
Session.GetMessageHandler().SendResponse();
}
RoomUser User = GetRoomUserByHabbo(Session.GetHabbo().Id);
if (User != null)
{
RemoveRoomUser(User);
if (Session.GetHabbo() != null)
{
if (!User.IsSpectator)
{
if (User.CurrentItemEffect != ItemEffectType.None)
{
User.GetClient().GetHabbo().GetAvatarEffectsInventoryComponent().CurrentEffect = -1;
}
//UserMatrix[User.X, User.Y] = false;
if (Session.GetHabbo() != null)
{
if (room.HasActiveTrade(Session.GetHabbo().Id))
room.TryStopTrade(Session.GetHabbo().Id);
if (Session.GetHabbo().Username == room.Owner)
{
if (room.HasOngoingEvent)
{
room.Event = new RoomEvent(0, null, null, 0, new List<string>());
ServerMessage Message = new ServerMessage(370);
Message.AppendStringWithBreak("-1");
room.SendMessage(Message);
ButterflyEnvironment.GetGame().GetRoomManager().GetEventManager().QueueRemoveEvent(room.RoomData, room.Event.Category);
}
}
Session.GetHabbo().CurrentRoomId = 0;
if (Session.GetHabbo().GetMessenger() != null)
Session.GetHabbo().GetMessenger().OnStatusChanged(true);
}
//DateTime Start = DateTime.Now;
//using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
//{
// //TimeSpan TimeUsed1 = DateTime.Now - Start;
// //Logging.LogThreadException("Time used on sys part 2: " + TimeUsed1.Seconds + "s, " + TimeUsed1.Milliseconds + "ms", "");
// //if (Session.GetHabbo() != null)
// // dbClient.runFastQuery("UPDATE user_roomvisits SET exit_timestamp = '" + ButterflyEnvironment.GetUnixTimestamp() + "' WHERE room_id = '" + this.Id + "' AND user_id = '" + Id + "' ORDER BY exit_timestamp DESC LIMIT 1");
// //dbClient.runFastQuery("UPDATE rooms SET users_now = " + UsersNow + " WHERE id = " + Id);
// //dbClient.runFastQuery("REPLACE INTO room_active VALUES (" + RoomId + ", " + UsersNow + ")");
// dbClient.runFastQuery("UPDATE room_active SET active_users = " + UsersNow);
//}
}
}
usersByUserID.Remove(User.userID);
if (Session.GetHabbo() != null)
usersByUsername.Remove(Session.GetHabbo().Username.ToLower());
User.Dispose();
}
}
catch (Exception e)
{
Logging.LogCriticalException("Error during removing user from room:" + e.ToString());
}
}
internal void HandlePurchase(GameClient Session, int PageId, uint ItemId, string ExtraData, int amount, GiftData giftData)
{
bool IsGift = giftData != null;
int discountCount = 0;
if (amount >= 6)
discountCount += 1;
if (amount >= 12)
discountCount += 2;
if (amount >= 18)
discountCount += 2;
if (amount >= 24)
discountCount += 2;
if (amount >= 30)
discountCount += 2;
if (amount >= 36)
discountCount += 2;
if (amount >= 42)
discountCount += 2;
if (amount >= 48)
discountCount += 2;
if (amount >= 54)
discountCount += 2;
if (amount >= 60)
discountCount += 2;
if (amount >= 66)
discountCount += 2;
if (amount >= 72)
discountCount += 2;
if (amount >= 78)
discountCount += 2;
if (amount >= 84)
discountCount += 2;
if (amount >= 90)
discountCount += 2;
if (amount >= 96)
discountCount += 2;
if (amount >= 99)
discountCount += 2;
CatalogPage Page;
if (!Pages.TryGetValue(PageId, out Page))
return;
if (Page == null || Page.ComingSoon || !Page.Enabled || !Page.Visible || Session == null || Session.GetHabbo() == null)
{
return;
}
if (Page.ClubOnly && !Session.GetHabboDataContainer().GetSubscriptionManager().HasSubscription(SubscriptionManager.SUBSCRIPTION_TYPE_VIP))
{
return;
}
if (Page.MinRank > Session.GetHabbo().Rank)
{
return;
}
CatalogItem Item = Page.GetItem(ItemId);
if (Item == null)
{
return;
}
uint GiftUserId = 0;
if (Item.isLimited)
{
amount = 1;
discountCount = 0;
if (Item.limitedInStock <= Item.limitedSold++)
return;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.runFastQuery("UPDATE catalog_items SET sold_amount = " + Item.limitedSold + " WHERE id = " + Item.ID);
}
Page.InitMsg();
}
Session.GetHabboDataContainer().SynchronizeDiamondBalance();
int total_cost_credits = Item.creditCost * (amount - discountCount);
int total_cost_pixels = Item.pixelCost * (amount - discountCount);
int total_cost_diamonds = Item.diamondCost * (amount - discountCount);
if (total_cost_diamonds > 0)
{
Session.GetHabbo().SynchronizeDiamondBalance();
}
if (IsGift)
{
if (!Item.GetBaseItem().AllowGift)
{
return;
}
DataRow dRow;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT id FROM users WHERE username = @gift_user");
dbClient.addParameter("gift_user", giftData.sendingUser);
dRow = dbClient.getRow();
}
if (dRow == null)
{
ServerMessage response = PacketHandelingManager.GetRecycledItem(OutputCode.GiftReceiverNotFoundEvent);
response.AddBoolean(true);
response.AddString(giftData.sendingUser);
Session.SendMessage(response);
return;
}
GiftUserId = Convert.ToUInt32(dRow[0]);
if (GiftUserId == 0)
{
ServerMessage response = PacketHandelingManager.GetRecycledItem(OutputCode.GiftReceiverNotFoundEvent);
response.AddBoolean(true);
response.AddString(giftData.sendingUser);
Session.SendMessage(response);
return;
}
}
if (Session.GetHabbo().ActivityPoints < total_cost_pixels || Session.GetHabbo().Credits < total_cost_credits || Session.GetHabbo().Diamonds < total_cost_diamonds)
return;
if (IsGift && Item.GetBaseItem().Type == 'e')
{
Session.SendNotif("Oeps! Er is iets mis gegaan, probeer het opnieuw!\r\r<b>Beschrijving:</b>\rJe kunt dit item niet versturen als cadeau.");
return;
}
if (Item.catalogName.Contains("HABBO_CLUB_VIP") || Item.catalogName.Equals("deal_vip_1_year_and_badge") || Item.catalogName.ToUpper().Contains("DEAL_HC"))
{
if (Item.creditCost > Session.GetHabbo().Credits)
return;
int Days = 0;
//DEAL_HC_3
if (Item.catalogName.ToUpper().Contains("DEAL_HC_"))
{
int k = int.Parse(Item.catalogName.Split('_')[2]);
switch (k)
{
case 1:
Days = 1 * 31;
break;
case 2:
Days = 3 * 31;
break;
case 3:
Days = 6 * 31;
break;
}
}
else if (Item.catalogName.Contains("HABBO_CLUB_VIP_"))
{
if (Item.catalogName.Contains("_DAY"))
{
Days = int.Parse(Item.catalogName.Split('_')[3]);
}
else if (Item.catalogName.Contains("_MONTH"))
{
Days = 31 * int.Parse(Item.catalogName.Split('_')[3]);
}
}
else if (Item.catalogName.Equals("deal_vip_1_year_and_badge"))
{
Days = 31 * 12;
}
else if (Item.catalogName.Equals("HABBO_CLUB_VIP_5_YEAR"))
{
Days = 31 * 5 * 12;
}
if (Item.creditCost > 0)
{
Session.GetHabbo().Credits -= total_cost_credits;
Session.GetHabboDataContainer().UpdateCreditsBalance();
}
if (Item.pixelCost > 0 || Item.diamondCost > 0)
{
Session.GetHabbo().Diamonds -= total_cost_diamonds;
Session.GetHabbo().ActivityPoints -= total_cost_pixels;
Session.GetHabboDataContainer().UpdateActivityPointsBalance();
Session.GetHabboDataContainer().StoreDiamondsNow();
}
Session.GetHabboDataContainer().GetSubscriptionManager().AddOrExtendSubscription(Days * 24 * 3600, SubscriptionManager.SUBSCRIPTION_TYPE_VIP);
//Session.GetHabboDataContainer().SerializeClub();
Session.GetMessageHandler().GetSubscriptionData();
ServerMessage ok = PacketHandelingManager.GetRecycledItem(OutputCode.PurchaseOKMessageEvent);
ok.AddInt32((int)Item.GetBaseItem().ItemId);
ok.AddString(Item.GetBaseItem().Name);
ok.AddBoolean(false);
ok.AddInt32(total_cost_credits);
ok.AddInt32(Item.pixelCost);
ok.AddInt32(0);
ok.AddBoolean(true);
ok.AddInt32(1);
ok.AddString(Item.GetBaseItem().Type.ToString().ToLower());
ok.AddInt32(Item.GetBaseItem().SpriteId);
ok.AddString(string.Empty);
ok.AddInt32(1);
ok.AddInt32(0);
ok.AddString(string.Empty);
ok.AddInt32(1);
Session.SendMessage(ok);
Session.GetHabboDataContainer().SerializeClub();
return;
}
switch (Item.GetBaseItem().InteractionType)
{
case InteractionType.groupClickable:
case InteractionType.groupGate:
case InteractionType.none:
if (Item.GetBaseItem().IsGroupItem)
{
uint groupID = TextHandling.ParseUInt32(ExtraData);
GroupData group = ButterflyEnvironment.GetGame().GetGroupManager().GetGroup(groupID);
if (group == null || !group.IsMember(Session.GetHabbo().Id))
ExtraData = string.Empty;
}
else
{
ExtraData = "";
}
break;
case InteractionType.musicdisc:
ExtraData = Item.songID.ToString();
break;
#region Pet handling
case InteractionType.pet0:
case InteractionType.pet1:
case InteractionType.pet2:
case InteractionType.pet3:
case InteractionType.pet4:
case InteractionType.pet5:
case InteractionType.pet6:
case InteractionType.pet7:
case InteractionType.pet8:
case InteractionType.pet9:
case InteractionType.pet10:
case InteractionType.pet11:
case InteractionType.pet12:
case InteractionType.pet14:
case InteractionType.pet15:
case InteractionType.pet16:
case InteractionType.pet17:
case InteractionType.pet18:
case InteractionType.pet19:
case InteractionType.pet20:
case InteractionType.pet21:
case InteractionType.pet22:
try
{
//uint count = 0;
//using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
//{
// dbClient.setQuery("SELECT COUNT(*) FROM user_pets WHERE user_id = " + Session.GetHabbo().Id);
// count = uint.Parse(dbClient.getString());
//}
//if (count > 5)
//{
// Session.SendNotif(LanguageLocale.GetValue("catalog.pets.maxpets"));
// return;
//}
string[] Bits = ExtraData.Split('\n');
string PetName = Bits[0];
string Race = Bits[1];
string Color = Bits[2];
int.Parse(Race); // to trigger any possible errors
if (!CheckPetName(PetName))
return;
if (Race.Length != 1 && Race.Length != 2)
return;
if (Color.Length != 6)
return;
ButterflyEnvironment.GetGame().GetAchievementManager().ProgressUserAchievement(Session, "ACH_PetLover", 1);
}
catch (Exception e) {
//Logging.WriteLine(e.ToString());
Logging.HandleException(e, "Catalog.HandlePurchase");
return;
}
break;
#endregion
case InteractionType.roomeffect:
Double Number = 0;
try
{
if (string.IsNullOrEmpty(ExtraData))
Number = 0;
else
Number = Double.Parse(ExtraData, ButterflyEnvironment.cultureInfo);
}
catch (Exception e) { Logging.HandleException(e, "Catalog.HandlePurchase: " + ExtraData); }
ExtraData = Number.ToString().Replace(',', '.');
break;
case InteractionType.postit:
ExtraData = "FFFF33";
break;
case InteractionType.dimmer:
ExtraData = "1,1,1,#000000,255";
break;
case InteractionType.trophy:
ExtraData = Session.GetHabbo().Username + Convert.ToChar(9) + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year + Convert.ToChar(9) + ButterflyEnvironment.FilterInjectionChars(ExtraData, true);
break;
case InteractionType.bot:
ExtraData = Item.specialText;
break;
case InteractionType.badge_display:
ExtraData = ExtraData + (char)9 + Session.GetHabbo().Username + (char)9 + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year;
break;
case InteractionType.mannequin:
ExtraData = "m" + Convert.ToChar(5) + "" + Convert.ToChar(5) + "Leet Hotel";
break;
default:
ExtraData = "";
break;
}
if (Item.creditCost > 0)
{
Session.GetHabbo().Credits -= total_cost_credits;
Session.GetHabboDataContainer().UpdateCreditsBalance();
}
if (Item.pixelCost > 0 || Item.diamondCost > 0)
{
Session.GetHabbo().Diamonds -= total_cost_diamonds;
Session.GetHabbo().ActivityPoints -= total_cost_pixels;
Session.GetHabboDataContainer().UpdateActivityPointsBalance();
Session.GetHabboDataContainer().StoreDiamondsNow();
}
ServerMessage resp = PacketHandelingManager.GetRecycledItem(OutputCode.FurniListUpdateEvent);
Session.SendMessage(resp);
resp = PacketHandelingManager.GetRecycledItem(OutputCode.PurchaseOKMessageEvent);
resp.AddInt32((int)Item.GetBaseItem().ItemId);
resp.AddString(Item.GetBaseItem().Name);
resp.AddBoolean(false);
resp.AddInt32(total_cost_credits);
resp.AddInt32(total_cost_pixels);
resp.AddInt32(0);
resp.AddBoolean(true);
resp.AddInt32(1);
resp.AddString(Item.GetBaseItem().Type.ToString().ToLower());
resp.AddInt32(Item.GetBaseItem().SpriteId);
resp.AddString("");
resp.AddInt32(1);
resp.AddInt32(0);
resp.AddString("");
resp.AddInt32(1);
Session.SendMessage(resp);
if (IsGift)
{
uint itemID;
Item Present = GetPresent(giftData.spriteID);
if (Present == null)
return;
ExtraData = giftData.SerializeExtraData(Session.GetHabbo().Id);
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("INSERT INTO items (base_id) VALUES (" + Present.ItemId + ")");
itemID = (uint)dbClient.insertQuery();
dbClient.runFastQuery("INSERT INTO items_users VALUES (" + itemID + "," + GiftUserId + ")");
dbClient.setQuery("INSERT INTO items_extradata (item_id, data) VALUES (@id,@data)");
dbClient.addParameter("id", itemID);
dbClient.addParameter("data", ExtraData);
dbClient.runQuery();
dbClient.setQuery("INSERT INTO user_presents (item_id,base_id,amount) VALUES " +
"(" + itemID + "," + Item.GetBaseItem().ItemId + "," + Item.amount + ")");
dbClient.runQuery();
}
GameClient Receiver = ButterflyEnvironment.GetGame().GetClientManager().GetClientByUserID(GiftUserId);
if (Receiver != null)
{
Receiver.GetHabboDataContainer().GetInventoryComponent().AddNewItem(itemID, Present.ItemId, ExtraData, false, false, 0);
Receiver.GetHabboDataContainer().GetInventoryComponent().SendFloorInventoryUpdate();
InventoryComponent targetInventory = Receiver.GetHabboDataContainer().GetInventoryComponent();
if (targetInventory != null)
targetInventory.RunDBUpdate();
}
}
else
{
DeliverItems(Session, Item.GetBaseItem(), Item.amount * amount, ExtraData, Item.songID);
}
}
