public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int craftingTable = Packet.PopInt();
string recipeName = Packet.PopString();
//Console.WriteLine("ID Mesa: " + craftingTable);
//Console.WriteLine("Receta: " + recipeName);
var recipe = QuasarEnvironment.GetGame().GetCraftingManager().GetRecipe(recipeName);
if (recipe == null)
{
return;
}
ItemData resultItem = QuasarEnvironment.GetGame().GetItemManager().GetItemByName(recipe.Result);
if (resultItem == null)
{
return;
}
bool success = true;
foreach (var need in recipe.ItemsNeeded)
{
for (var i = 1; i <= need.Value; i++)
{
ItemData item = QuasarEnvironment.GetGame().GetItemManager().GetItemByName(need.Key);
if (item == null)
{
success = false;
continue;
}
var inv = Session.GetHabbo().GetInventoryComponent().GetFirstItemByBaseId(item.Id);
if (inv == null)
{
success = false;
continue;
}
Session.GetHabbo().GetInventoryComponent().RemoveItem(inv.Id);
}
}
if (success)
{
Session.GetHabbo().GetInventoryComponent().AddNewItem(0, resultItem.Id, "", 0, true, false, 0, 0);
Session.SendMessage(new FurniListUpdateComposer());
}
Session.SendMessage(new CraftingResultComposer(recipe, success));
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int SellingPrice = Packet.PopInt();
int ComissionPrice = Packet.PopInt();
int ItemId = Packet.PopInt();
Item Item = Session.GetHabbo().GetInventoryComponent().GetItem(ItemId);
if (Item == null)
{
Session.SendMessage(new MarketplaceMakeOfferResultComposer(0));
return;
}
if (!ItemUtility.IsRare(Item))
{
Session.SendNotification("Alleen Rares en Limited Edition - meubi's zijn toegestaan in de Habbis Marktplaats.");
return;
}
if (SellingPrice > 70000000 || SellingPrice == 0)
{
Session.SendMessage(new MarketplaceMakeOfferResultComposer(0));
return;
}
int Comission = QuasarEnvironment.GetGame().GetCatalog().GetMarketplace().CalculateComissionPrice((float)SellingPrice);
int TotalPrice = SellingPrice + Comission;
int ItemType = 1;
if (Item.GetBaseItem().Type == 'i')
{
ItemType++;
}
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `catalog_marketplace_offers` (`furni_id`,`item_id`,`user_id`,`asking_price`,total_price,public_name,sprite_id,item_type,timestamp,extra_data,limited_number,limited_stack) VALUES ('" + ItemId + "','" + Item.BaseItem + "','" + Session.GetHabbo().Id + "','" + SellingPrice + "','" + TotalPrice + "',@public_name,'" + Item.GetBaseItem().SpriteId + "','" + ItemType + "','" + QuasarEnvironment.GetUnixTimestamp() + "',@extra_data, '" + Item.LimitedNo + "', '" + Item.LimitedTot + "')");
dbClient.AddParameter("public_name", Item.GetBaseItem().PublicName);
dbClient.AddParameter("extra_data", Item.ExtraData);
dbClient.RunQuery();
dbClient.RunQuery("DELETE FROM `items` WHERE `id` = '" + ItemId + "' AND `user_id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
}
Session.GetHabbo().GetInventoryComponent().RemoveItem(ItemId);
Session.SendMessage(new MarketplaceMakeOfferResultComposer(1));
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int GroupId = Packet.PopInt();
int UserId = Packet.PopInt();
Group Group = null;
if (!QuasarEnvironment.GetGame().GetGroupManager().TryGetGroup(GroupId, out Group))
{
return;
}
if (Session.GetHabbo().Id != Group.CreatorId || !Group.IsMember(UserId))
{
return;
}
Habbo Habbo = QuasarEnvironment.GetHabboById(UserId);
if (Habbo == null)
{
Session.SendNotification("Oeps! Deze gebruiker is niet in de kamer aanwezig.");
return;
}
Group.MakeAdmin(UserId);
Room Room = null;
if (QuasarEnvironment.GetGame().GetRoomManager().TryGetRoom(Group.RoomId, out Room))
{
RoomUser User = Room.GetRoomUserManager().GetRoomUserByHabbo(UserId);
if (User != null)
{
if (!User.Statusses.ContainsKey("flatctrl 3"))
{
User.AddStatus("flatctrl 3", "");
}
User.UpdateNeeded = true;
if (User.GetClient() != null)
{
User.GetClient().SendMessage(new YouAreControllerComposer(3));
}
}
}
Session.SendMessage(new GroupMemberUpdatedComposer(GroupId, Habbo, 1));
}
public MarketPlaceOwnOffersComposer(int UserId)
: base(ServerPacketHeader.MarketPlaceOwnOffersMessageComposer)
{
int i = 0;
DataTable table = null;
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT timestamp, state, offer_id, item_type, sprite_id, total_price, limited_number, limited_stack FROM catalog_marketplace_offers WHERE user_id = '" + UserId + "'");
table = dbClient.getTable();
dbClient.SetQuery("SELECT SUM(asking_price) FROM catalog_marketplace_offers WHERE state = '2' AND user_id = '" + UserId + "'");
i = dbClient.getInteger();
base.WriteInteger(i);
if (table != null)
{
base.WriteInteger(table.Rows.Count);
foreach (DataRow row in table.Rows)
{
int num2 = Convert.ToInt32(Math.Floor((double)(((((double)row["timestamp"]) + 172800.0) - QuasarEnvironment.GetUnixTimestamp()) / 60.0)));
int num3 = int.Parse(row["state"].ToString());
if ((num2 <= 0) && (num3 != 2))
{
num3 = 3;
num2 = 0;
}
base.WriteInteger(Convert.ToInt32(row["offer_id"]));
base.WriteInteger(num3);
base.WriteInteger(1);
base.WriteInteger(Convert.ToInt32(row["sprite_id"]));
base.WriteInteger(256);
base.WriteString("");
base.WriteInteger(Convert.ToInt32(row["limited_number"]));
base.WriteInteger(Convert.ToInt32(row["limited_stack"]));
base.WriteInteger(Convert.ToInt32(row["total_price"]));
base.WriteInteger(num2);
base.WriteInteger(Convert.ToInt32(row["sprite_id"]));
}
}
else
{
base.WriteInteger(0);
}
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (!Session.GetHabbo().InRoom)
{
return;
}
int BotId = Packet.PopInt();
if (BotId == 0)
{
return;
}
Room Room = Session.GetHabbo().CurrentRoom;
if (Room == null)
{
return;
}
RoomUser BotUser = null;
if (!Room.GetRoomUserManager().TryGetBot(BotId, out BotUser))
{
return;
}
if (Session.GetHabbo().Id != BotUser.BotData.ownerID && !Session.GetHabbo().GetPermissions().HasRight("bot_place_any_override"))
{
Session.SendWhisper("Oeps! Je kunt alleen Bots oppakken van jezelf.");
return;
}
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `bots` SET `room_id` = '0' WHERE `id` = @id LIMIT 1");
dbClient.AddParameter("id", BotId);
dbClient.RunQuery();
}
Room.GetGameMap().RemoveUserFromMap(BotUser, new System.Drawing.Point(BotUser.X, BotUser.Y));
Session.GetHabbo().GetInventoryComponent().TryAddBot(new Bot(Convert.ToInt32(BotUser.BotData.Id), Convert.ToInt32(BotUser.BotData.ownerID), BotUser.BotData.Name, BotUser.BotData.Motto, BotUser.BotData.Look, BotUser.BotData.Gender));
Session.SendMessage(new BotInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetBots()));
Room.GetRoomUserManager().RemoveBot(BotUser.VirtualId, false);
}
public static int GetHopperId(int NextRoom)
{
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT hopper_id FROM items_hopper WHERE room_id = @room LIMIT 1");
dbClient.AddParameter("room", NextRoom);
string Row = dbClient.getString();
if (Row == null)
{
return(0);
}
return(Convert.ToInt32(Row));
}
}
/// <summary>
/// Activates the AvatarEffect
/// </summary>
public bool Activate()
{
double TsNow = UnixTimestamp.GetNow();
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `user_effects` SET `is_activated` = '1', `activated_stamp` = @ts WHERE `id` = @id");
dbClient.AddParameter("ts", TsNow);
dbClient.AddParameter("id", this.Id);
dbClient.RunQuery();
this._activated = true;
this._timestampActivated = TsNow;
return(true);
}
}
private void LoadThreads()
{
DataTable table;
using (var adap = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
adap.SetQuery("SELECT * FROM group_forums_threads WHERE forum_id = @id ORDER BY id DESC");
adap.AddParameter("id", Id);
table = adap.getTable();
}
foreach (DataRow Row in table.Rows)
{
Threads.Add(new GroupForumThread(this, Convert.ToInt32(Row["id"]), Convert.ToInt32(Row["user_id"]), Convert.ToInt32(Row["timestamp"]), Row["caption"].ToString(), Convert.ToInt32(Row["pinned"]) == 1, Convert.ToInt32(Row["locked"]) == 1, Convert.ToInt32(Row["deleted_level"]), Convert.ToInt32(Row["deleter_user_id"])));
}
}
public override void OnUserEnterRoom(RoomUser User)
{
if (User.GetClient() != null && User.GetClient().GetHabbo() != null)
{
RoomUser Pet = GetRoomUser();
if (Pet != null)
{
if (User.GetClient().GetHabbo().Username == Pet.PetData.OwnerName)
{
string[] Speech = QuasarEnvironment.GetGame().GetChatManager().GetPetLocale().GetValue("welcome.speech.pet" + Pet.PetData.Type);
string rSpeech = Speech[RandomNumber.GenerateRandom(0, Speech.Length - 1)];
Pet.Chat(rSpeech, false);
}
}
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int ItemId = Packet.PopInt();
int SpriteId = Packet.PopInt();
DataRow Row = null;
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `avgprice` FROM `catalog_marketplace_data` WHERE `sprite` = @SpriteId LIMIT 1");
dbClient.AddParameter("SpriteId", SpriteId);
Row = dbClient.getRow();
}
Session.SendMessage(new MarketplaceItemStatsComposer(ItemId, SpriteId, (Row != null ? Convert.ToInt32(Row["avgprice"]) : 0)));
}
internal ItemData GetBaseItem(int ItemIds)
{
ItemData obj = null;
if (!QuasarEnvironment.GetGame().GetItemManager().GetItem(ItemIds, out obj))
{
return(null);
}
if (obj == null && this.Name != "room_ad_Quasar_badge")
{
Console.WriteLine("UNKNOWN ItemIds: " + ItemIds);
}
return(obj);
}
/// <summary>
/// Initialize the PermissionComponent.
/// </summary>
/// <param name="Player"></param>
public bool Init(Habbo Player)
{
if (this._permissions.Count > 0)
{
this._permissions.Clear();
}
if (this._commands.Count > 0)
{
this._commands.Clear();
}
this._permissions.AddRange(QuasarEnvironment.GetGame().GetPermissionManager().GetPermissionsForPlayer(Player));
this._commands.AddRange(QuasarEnvironment.GetGame().GetPermissionManager().GetCommandsForPlayer(Player));
return(true);
}
public bool RequestExists(int requestID)
{
if (_requests.ContainsKey(requestID))
{
return(true);
}
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery(
"SELECT user_one_id FROM messenger_friendships WHERE user_one_id = @myID AND user_two_id = @friendID");
dbClient.AddParameter("myID", Convert.ToInt32(_userId));
dbClient.AddParameter("friendID", Convert.ToInt32(requestID));
return(dbClient.findsResult());
}
}
public void DestroyFriendship(int friendID)
{
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("DELETE FROM messenger_friendships WHERE (user_one_id = " + _userId + " AND user_two_id = " + friendID + ") OR (user_two_id = " + _userId + " AND user_one_id = " + friendID + ")");
}
OnDestroyFriendship(friendID);
GameClient User = QuasarEnvironment.GetGame().GetClientManager().GetClientByUserID(friendID);
if (User != null && User.GetHabbo().GetMessenger() != null)
{
User.GetHabbo().GetMessenger().OnDestroyFriendship(_userId);
}
}
public GroupFurniConfigComposer(ICollection <Group> Groups)
: base(ServerPacketHeader.GroupFurniConfigMessageComposer)
{
base.WriteInteger(Groups.Count);
foreach (Group Group in Groups)
{
base.WriteInteger(Group.Id);
base.WriteString(Group.Name);
base.WriteString(Group.Badge);
base.WriteString((QuasarEnvironment.GetGame().GetGroupManager().SymbolColours.ContainsKey(Group.Colour1)) ? QuasarEnvironment.GetGame().GetGroupManager().SymbolColours[Group.Colour1].Colour : "4f8a00"); // Group Colour 1
base.WriteString((QuasarEnvironment.GetGame().GetGroupManager().BackGroundColours.ContainsKey(Group.Colour2)) ? QuasarEnvironment.GetGame().GetGroupManager().BackGroundColours[Group.Colour2].Colour : "4f8a00"); // Group Colour 2
base.WriteBoolean(false);
base.WriteInteger(Group.CreatorId);
base.WriteBoolean(Group.ForumEnabled);
}
}
public void BroadCastChat(Habbo User, string message)
{
foreach (var client in QuasarEnvironment.GetGame().GetClientManager().GetClientsById(GetAllMembers))
{
if (client.GetHabbo() == null)
{
continue;
}
if (client.GetHabbo().Id == User.Id)
{
continue;
}
client.SendMessage(new NewConsoleMessageComposer(this.Id, message, 0, User.Id, User.Username, User.Look));
}
}
internal void Initialize()
{
predesignedRoom = new Dictionary <uint, PredesignedRooms>();
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM catalog_predesigned_rooms;");
var table = dbClient.getTable();
foreach (DataRow row in table.Rows)
{
predesignedRoom.Add(Convert.ToUInt32(row["id"]), new PredesignedRooms(Convert.ToUInt32(row["id"]),
Convert.ToUInt32(row["id"]), (string)row["room_model"], (string)row["flooritems"].ToString().TrimEnd(';'),
(string)row["wallitems"].ToString().TrimEnd(';'), (string)row["catalogitems"].ToString().TrimEnd(';'),
(string)row["room_decoration"]));
}
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int RoomId = Packet.PopInt();
string word;
string Name = Packet.PopString();
Name = QuasarEnvironment.GetGame().GetChatManager().GetFilter().IsUnnaceptableWord(Name, out word) ? "Spam" : Name;
string Desc = Packet.PopString();
Desc = QuasarEnvironment.GetGame().GetChatManager().GetFilter().IsUnnaceptableWord(Desc, out word) ? "Spam" : Desc;
RoomData Data = QuasarEnvironment.GetGame().GetRoomManager().GenerateRoomData(RoomId);
if (Data == null)
{
return;
}
if (Data.OwnerId != Session.GetHabbo().Id)
{
return; //HAX
}
if (Data.Promotion == null)
{
Session.SendNotification("Oeps! Er is geen promotie bezig in deze kamer.");
return;
}
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `room_promotions` SET `title` = @title, `description` = @desc WHERE `room_id` = " + RoomId + " LIMIT 1");
dbClient.AddParameter("title", Name);
dbClient.AddParameter("desc", Desc);
dbClient.RunQuery();
}
Room Room;
if (!QuasarEnvironment.GetGame().GetRoomManager().TryGetRoom(Convert.ToInt32(RoomId), out Room))
{
return;
}
Data.Promotion.Name = Name;
Data.Promotion.Description = Desc;
Room.SendMessage(new RoomEventComposer(Data, Data.Promotion));
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
Session.GetHabbo().GetBadgeComponent().ResetSlots();
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `user_badges` SET `badge_slot` = '0' WHERE `user_id` = '" + Session.GetHabbo().Id + "'");
}
for (int i = 0; i < 5; i++)
{
int Slot = Packet.PopInt();
string Badge = Packet.PopString();
if (Badge.Length == 0)
{
continue;
}
if (!Session.GetHabbo().GetBadgeComponent().HasBadge(Badge) || Slot < 1 || Slot > 5)
{
return;
}
Session.GetHabbo().GetBadgeComponent().GetBadge(Badge).Slot = Slot;
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `user_badges` SET `badge_slot` = " + Slot + " WHERE `badge_id` = @badge AND `user_id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
dbClient.AddParameter("badge", Badge);
dbClient.RunQuery();
}
}
QuasarEnvironment.GetGame().GetQuestManager().ProgressUserQuest(Session, QuestType.PROFILE_BADGE);
Room Room;
if (Session.GetHabbo().InRoom&& QuasarEnvironment.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
{
Session.GetHabbo().CurrentRoom.SendMessage(new HabboUserBadgesComposer(Session.GetHabbo()));
}
else
{
Session.SendMessage(new HabboUserBadgesComposer(Session.GetHabbo()));
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
Room Room = null;
if (!QuasarEnvironment.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
{
return;
}
RoomUser User = Room.GetRoomUserManager().GetRoomUserByHabbo(Session.GetHabbo().Id);
if (User == null)
{
return;
}
if (User.IsAsleep)
{
return;
}
User.UnIdle();
int X = Packet.PopInt();
int Y = Packet.PopInt();
if ((X == User.X && Y == User.Y) || User.IsWalking || User.RidingHorse)
{
return;
}
int Rot = Rotation.Calculate(User.X, User.Y, X, Y);
User.SetRot(Rot, false);
User.UpdateNeeded = true;
if (User.RidingHorse)
{
RoomUser Horse = Session.GetHabbo().CurrentRoom.GetRoomUserManager().GetRoomUserByVirtualId(User.HorseID);
if (Horse != null)
{
Horse.SetRot(Rot, false);
Horse.UpdateNeeded = true;
}
}
}
public void Execute(GameClient Session, Room Room, string[] Params)
{
if (!Room.CheckRights(Session, true))
{
return;
}
if (Params.Length == 1)
{
Session.SendWhisper("Je bent vergeten een (geldig) nummer in te vullen.");
return;
}
int MaxAmount;
if (int.TryParse(Params[1], out MaxAmount))
{
if (MaxAmount == 0)
{
MaxAmount = 10;
Session.SendWhisper("Het getal is te laag, het is automatisch naar 10 gezet.");
}
else if (MaxAmount > 200 &&
!Session.GetHabbo().GetPermissions().HasRight("override_command_setmax_limit"))
{
MaxAmount = 200;
Session.SendWhisper("Het getal is te hoog, het is automatisch .");
}
else
{
Session.SendWhisper("Aantal spelers die in je kamer mogen verzet naar " + MaxAmount + ".");
}
Room.UsersMax = MaxAmount;
Room.RoomData.UsersMax = MaxAmount;
using (var dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `rooms` SET `users_max` = " + MaxAmount + " WHERE `id` = '" + Room.Id +
"' LIMIT 1");
}
}
else
{
Session.SendWhisper("Oeps, vul een geldig getal in.");
}
}
public bool Execute(params object[] Params)
{
if (Params.Length != 1)
{
return(false);
}
Habbo Player = (Habbo)Params[0];
if (Player == null)
{
return(false);
}
RoomUser User = Instance.GetRoomUserManager().GetRoomUserByHabbo(Player.Id);
if (User == null)
{
return(false);
}
if (Player.GetPermissions().HasRight("mod_tool") || this.Instance.OwnerId == Player.Id)
{
Player.GetClient().SendMessage(new WhisperComposer(User.VirtualId, "Wired Mute Exception: Unmutable Player", 0, 0));
return(false);
}
int Time = (StringData != null ? int.Parse(StringData.Split(';')[0]) : 0);
string Message = (StringData != null ? (StringData.Split(';')[1]) : "No message!");
if (Time > 0)
{
Player.GetClient().SendMessage(new WhisperComposer(User.VirtualId, "Wired Mute: Muted for " + Time + "! Message: " + Message, 0, 0));
if (!Instance.MutedUsers.ContainsKey(Player.Id))
{
Instance.MutedUsers.Add(Player.Id, (QuasarEnvironment.GetUnixTimestamp() + (Time * 60)));
}
else
{
Instance.MutedUsers.Remove(Player.Id);
Instance.MutedUsers.Add(Player.Id, (QuasarEnvironment.GetUnixTimestamp() + (Time * 60)));
}
}
return(true);
}
public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)
{
Session.GetHabbo().AllowPetSpeech = !Session.GetHabbo().AllowPetSpeech;
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `users` SET `pets_muted` = '" + ((Session.GetHabbo().AllowPetSpeech) ? 1 : 0) + "' WHERE `id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
}
if (Session.GetHabbo().AllowPetSpeech)
{
Session.SendWhisper("Verandering aangebracht! Je ontvangt nu geen berichten meer van dieren en baby's.", 34);
}
else
{
Session.SendWhisper("Verandering aangebracht! Je ontvangt nu weer berichten van dieren en baby's.", 34);
}
}
public void Init()
{
this._values = new Dictionary <string, string[]>();
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `bots_pet_responses`");
DataTable Pets = dbClient.getTable();
if (Pets != null)
{
foreach (DataRow Row in Pets.Rows)
{
this._values.Add(Row[0].ToString(), Row[1].ToString().Split(';'));
}
}
}
}
public void ClearItems()
{
UpdateItems(true);
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("DELETE FROM items WHERE room_id='0' AND user_id = " + _userId); //Do join
}
this._floorItems.Clear();
this._wallItems.Clear();
if (_client != null)
{
_client.SendMessage(new FurniListUpdateComposer());
}
}
public void SendNewTicket(GameClient Session, int Category, int ReportedUser, String Message, List <string> Messages)
{
int TicketId = 0;
SupportTicket Ticket;
if (Session.GetHabbo().CurrentRoomId <= 0)
{
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO moderation_tickets (score,type,status,sender_id,reported_id,moderator_id,message,room_id,room_name,timestamp) VALUES (1,'" + Category + "','open','" + Session.GetHabbo().Id + "','" + ReportedUser + "','0',@message,'0','','" + QuasarEnvironment.GetUnixTimestamp() + "')");
dbClient.AddParameter("message", Message);
TicketId = Convert.ToInt32(dbClient.InsertQuery());
dbClient.RunQuery("UPDATE `user_info` SET `cfhs` = `cfhs` + '1' WHERE `user_id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
}
Ticket = new SupportTicket(TicketId, 1, 7, Session.GetHabbo().Id, ReportedUser, Message, 0, "", QuasarEnvironment.GetUnixTimestamp(), Messages);
Tickets.Add(Ticket);
SendTicketToModerators(Ticket);
// Otherwise return; here - Lets check
QuasarEnvironment.GetGame().GetClientManager().StaffAlert(RoomNotificationComposer.SendBubble("tickets", "Een Habbi heeft een verzoek om hulp gestuurd, bekijk de Moderator Tickets.", ""));
return;
}
RoomData Data = QuasarEnvironment.GetGame().GetRoomManager().GenerateRoomData(Session.GetHabbo().CurrentRoomId);
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO moderation_tickets (score,type,status,sender_id,reported_id,moderator_id,message,room_id,room_name,timestamp) VALUES (1,'" + Category + "','open','" + Session.GetHabbo().Id + "','" + ReportedUser + "','0',@message,'" + Data.Id + "',@name,'" + QuasarEnvironment.GetUnixTimestamp() + "')");
dbClient.AddParameter("message", Message);
dbClient.AddParameter("name", Data.Name);
TicketId = Convert.ToInt32(dbClient.InsertQuery());
dbClient.RunQuery("UPDATE user_info SET cfhs = cfhs + 1 WHERE user_id = '" + Session.GetHabbo().Id + "' LIMIT 1");
QuasarEnvironment.GetGame().GetClientManager().StaffAlert(RoomNotificationComposer.SendBubble("tickets", "Een Habbi heeft een verzoek om hulp gestuurd, bekijk de Moderator Tickets.", ""));
}
Ticket = new SupportTicket(TicketId, 1, 7, Session.GetHabbo().Id, ReportedUser, Message, Data.Id, Data.Name, QuasarEnvironment.GetUnixTimestamp(), Messages);
Tickets.Add(Ticket);
SendTicketToModerators(Ticket);
}
public CraftableProductsComposer()
: base(ServerPacketHeader.CraftableProductsMessageComposer)
{
var crafting = QuasarEnvironment.GetGame().GetCraftingManager();
base.WriteInteger(crafting.CraftingRecipes.Count);
foreach (var recipe in crafting.CraftingRecipes.Values)
{
base.WriteString(recipe.Result);
base.WriteString(recipe.Result);
}
base.WriteInteger(crafting.CraftableItems.Count);
foreach (var itemName in crafting.CraftableItems)
{
base.WriteString(itemName);
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (Session == null)
{
return;
}
int GroupId = Packet.PopInt();
if (GroupId == 0)
{
return;
}
Group Group = null;
if (!QuasarEnvironment.GetGame().GetGroupManager().TryGetGroup(GroupId, out Group))
{
return;
}
Session.GetHabbo().GetStats().FavouriteGroupId = Group.Id;
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `user_stats` SET `groupid` = " + Session.GetHabbo().GetStats().FavouriteGroupId + " WHERE `id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
}
if (Session.GetHabbo().InRoom&& Session.GetHabbo().CurrentRoom != null)
{
Session.GetHabbo().CurrentRoom.SendMessage(new RefreshFavouriteGroupComposer(Session.GetHabbo().Id));
if (Group != null)
{
Session.GetHabbo().CurrentRoom.SendMessage(new HabboGroupBadgesComposer(Group));
RoomUser User = Session.GetHabbo().CurrentRoom.GetRoomUserManager().GetRoomUserByHabbo(Session.GetHabbo().Id);
if (User != null)
{
Session.GetHabbo().CurrentRoom.SendMessage(new UpdateFavouriteGroupComposer(Session.GetHabbo().Id, Group, User.VirtualId));
}
}
}
else
{
Session.SendMessage(new RefreshFavouriteGroupComposer(Session.GetHabbo().Id));
}
}
public List <int> BannedUsers()
{
var Bans = new List <int>();
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT user_id FROM room_bans WHERE expire > UNIX_TIMESTAMP() AND room_id=" + Id);
DataTable Table = dbClient.getTable();
foreach (DataRow Row in Table.Rows)
{
Bans.Add(Convert.ToInt32(Row[0]));
}
}
return(Bans);
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int EffectId = Packet.PopInt();
AvatarEffect Effect = Session.GetHabbo().Effects().GetEffectNullable(EffectId, false, true);
if (Effect == null || Session.GetHabbo().Effects().HasEffect(EffectId, true))
{
return;
}
if (Effect.Activate())
{
Session.SendMessage(new AvatarEffectActivatedComposer(Effect));
QuasarEnvironment.GetGame().GetAchievementManager().ProgressAchievement(Session, "ACH_ExploreEffects", 1);
}
}
