public MoodlightData(int ItemId)
{
this.ItemId = ItemId;
DataRow Row = null;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id = '" + ItemId + "' LIMIT 1");
Row = dbClient.getRow();
}
if (Row == null)
{
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("INSERT INTO `room_items_moodlight` (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (" + ItemId + ",0,1,'#000000,255,0','#000000,255,0','#000000,255,0')");
dbClient.SetQuery("SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id=" + ItemId + " LIMIT 1");
Row = dbClient.getRow();
}
}
Enabled = RocketEmulador.EnumToBool(Row["enabled"].ToString());
CurrentPreset = Convert.ToInt32(Row["current_preset"]);
Presets = new List <MoodlightPreset>();
Presets.Add(GeneratePreset(Convert.ToString(Row["preset_one"])));
Presets.Add(GeneratePreset(Convert.ToString(Row["preset_two"])));
Presets.Add(GeneratePreset(Convert.ToString(Row["preset_three"])));
}
public void AddView(int userid, int count = -1)
{
GroupForumThreadPostView v;
if ((v = GetView(userid)) != null)
{
v.Count = count >= 0 ? count : Posts.Count;
using (IQueryAdapter adap = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
adap.SetQuery("UPDATE group_forums_thread_views SET count = @c WHERE thread_id = @p AND user_id = @u");
adap.AddParameter("c", v.Count);
adap.AddParameter("p", this.Id);
adap.AddParameter("u", userid);
adap.RunQuery();
}
}
else
{
v = new GroupForumThreadPostView(0, userid, Posts.Count);
using (IQueryAdapter adap = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
adap.SetQuery("INSERT INTO group_forums_thread_views (thread_id, user_id, count) VALUES (@t, @u, @c)");
adap.AddParameter("t", this.Id);
adap.AddParameter("u", userid);
adap.AddParameter("c", v.Count);
v.Id = (int)adap.InsertQuery();
Views.Add(v);
}
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (Session == null || Session.GetHabbo() == null || !Session.GetHabbo().InRoom)
{
return;
}
Room Room;
if (!RocketEmulador.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
{
return;
}
if (!Room.CanTradeInRoom)
{
return;
}
Trade Trade = Room.GetUserTrade(Session.GetHabbo().Id);
if (Trade == null)
{
return;
}
Item Item = Session.GetHabbo().GetInventoryComponent().GetItem(Packet.PopInt());
if (Item == null)
{
return;
}
Trade.TakeBackItem(Session.GetHabbo().Id, Item);
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (Session == null || Session.GetHabbo() == null || !Session.GetHabbo().InRoom)
{
return;
}
Room Room;
if (!RocketEmulador.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
{
return;
}
if (!Room.CanTradeInRoom)
{
return;
}
Trade Trade = Room.GetUserTrade(Session.GetHabbo().Id);
if (Trade == null)
{
return;
}
Trade.Accept(Session.GetHabbo().Id);
}
public TargetOfferMessageComposer() : base(ServerPacketHeader.TargetOfferMessageComposer)
{
base.WriteInteger(1);
base.WriteInteger(190);
base.WriteString("bf16_tko_gr1");
base.WriteString("bf16_tko1");
base.WriteInteger(105); //Credits
base.WriteInteger(105); //Diamonds
base.WriteInteger(5);
base.WriteInteger(2);
base.WriteInteger(RocketEmulador.Oferta); //3 Days ... time in seconds
base.WriteString(RocketEmulador.RocketData().data["oferta.title"]); //Title
base.WriteString(RocketEmulador.RocketData().data["oferta.desc"]); //Description
base.WriteString(RocketEmulador.RocketData().data["oferta.image"]); //Image Large
base.WriteString(RocketEmulador.RocketData().data["oferta.image1"]); //Image on Close Notification
base.WriteInteger(1);
base.WriteInteger(15);
base.WriteString("wf_act_mute_triggerer"); //1 Month HC
base.WriteString("wf_xtra_random"); //Snack
base.WriteString("wf_act_leave_team"); //10 Credits
base.WriteString("wf_trg_game_ends"); //Roof Building
base.WriteString("wf_trg_game_ends"); //Snack
base.WriteString("wf_trg_game_ends"); //10 Credits
base.WriteString("wf_trg_game_ends"); //10 Credits
base.WriteString("wf_trg_game_ends"); //Building 1
base.WriteString("wf_trg_game_ends"); //Building 2
base.WriteString("wf_trg_game_ends"); //10 Credits
base.WriteString("wf_trg_game_ends"); //Clothes Scarf
base.WriteString("wf_trg_game_ends"); //10 Credits
base.WriteString("wf_trg_game_ends"); //10 Credits
base.WriteString("wf_trg_game_ends"); //
base.WriteString("wf_trg_game_ends"); //10 Credits
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int CreditsOwed = 0;
DataTable Table = null;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `asking_price` FROM `catalog_marketplace_offers` WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND state = '2'");
Table = dbClient.getTable();
}
if (Table != null)
{
foreach (DataRow row in Table.Rows)
{
CreditsOwed += Convert.ToInt32(row["asking_price"]);
}
if (CreditsOwed >= 1)
{
Session.GetHabbo().Credits += CreditsOwed;
Session.SendMessage(new CreditBalanceComposer(Session.GetHabbo().Credits));
}
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("DELETE FROM `catalog_marketplace_offers` WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND `state` = '2'");
}
}
}
public static List <Item> GetItemsForUser(int UserId)
{
DataTable Items = null;
List <Item> I = new List <Item>();
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `items`.*, COALESCE(`items_groups`.`group_id`, 0) AS `group_id` FROM `items` LEFT OUTER JOIN `items_groups` ON `items`.`id` = `items_groups`.`id` WHERE `items`.`room_id` = 0 AND `items`.`user_id` = @uid;");
dbClient.AddParameter("uid", UserId);
Items = dbClient.getTable();
if (Items != null)
{
foreach (DataRow Row in Items.Rows)
{
ItemData Data = null;
if (RocketEmulador.GetGame().GetItemManager().GetItem(Convert.ToInt32(Row["base_item"]), out Data))
{
I.Add(new Item(Convert.ToInt32(Row["id"]), Convert.ToInt32(Row["room_id"]), Convert.ToInt32(Row["base_item"]), Convert.ToString(Row["extra_data"]),
Convert.ToInt32(Row["x"]), Convert.ToInt32(Row["y"]), Convert.ToDouble(Row["z"]), Convert.ToInt32(Row["rot"]), Convert.ToInt32(Row["user_id"]),
Convert.ToInt32(Row["group_id"]), Convert.ToInt32(Row["limited_number"]), Convert.ToInt32(Row["limited_stack"]), Convert.ToString(Row["wall_pos"])));
}
else
{
// Item data does not exist anymore.
}
}
}
}
return(I);
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
string Volume = "";
for (int i = 0; i < 3; i++)
{
int Vol = Packet.PopInt();
if (Vol < 0 || Vol > 100)
{
Vol = 100;
}
if (i < 2)
{
Volume += Vol + ",";
}
else
{
Volume += Vol;
}
}
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE users SET volume = @volume WHERE `id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
dbClient.AddParameter("volume", Volume);
dbClient.RunQuery();
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int GroupId = Packet.PopInt();
int UserId = Packet.PopInt();
Group Group = null;
if (!RocketEmulador.GetGame().GetGroupManager().TryGetGroup(GroupId, out Group))
{
return;
}
if (Session.GetHabbo().Id != Group.CreatorId && !Group.IsAdmin(Session.GetHabbo().Id))
{
return;
}
if (!Group.HasRequest(UserId))
{
return;
}
Group.HandleRequest(UserId, false);
Session.SendMessage(new UnknownGroupComposer(Group.Id, UserId));
}
public void Parse(GameClient Session, ClientPacket Packet)
{
var ForumId = Packet.PopInt();
var WhoCanRead = Packet.PopInt();
var WhoCanReply = Packet.PopInt();
var WhoCanPost = Packet.PopInt();
var WhoCanMod = Packet.PopInt();
var forum = RocketEmulador.GetGame().GetGroupForumManager().GetForum(ForumId);
if (forum == null)
{
Session.SendNotification("Forum not found 404!");
return;
}
if (forum.Settings.GetReasonForNot(Session, forum.Settings.WhoCanModerate) != "")
{
Session.SendNotification("Can't update thread, you don't have the correct rights!");
return;
}
forum.Settings.WhoCanRead = WhoCanRead;
forum.Settings.WhoCanModerate = WhoCanMod;
forum.Settings.WhoCanPost = WhoCanReply;
forum.Settings.WhoCanInitDiscussions = WhoCanPost;
forum.Settings.Save();
RocketEmulador.GetGame().GetAchievementManager().ProgressAchievement(Session, "ACH_SelfModRoomFilterSeen", 1);
Session.SendMessage(new ForumDataComposer(forum, Session));
Session.SendMessage(new ThreadsListDataComposer(forum, Session));
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (Session == null || Session.GetHabbo() == null)
{
return;
}
if (!Session.GetHabbo().GetPermissions().HasRight("mod_tool"))
{
return;
}
int UserId = Packet.PopInt();
Habbo Habbo = RocketEmulador.GetHabboById(UserId);
if (Habbo == null)
{
Session.SendNotification("Oops, we couldn't find this user.");
return;
}
try
{
Session.SendMessage(new ModeratorUserChatlogComposer(UserId));
}
catch { Session.SendNotification("Overflow :/"); }
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
Room Room = null;
if (!RocketEmulador.GetGame().GetRoomManager().TryGetRoom(Packet.PopInt(), out Room))
{
return;
}
if (!Room.CheckRights(Session, true))
{
return;
}
int CategoryId = Packet.PopInt();
int TradeSettings = Packet.PopInt();
if (TradeSettings < 0 || TradeSettings > 2)
{
TradeSettings = 0;
}
SearchResultList SearchResultList = null;
if (!RocketEmulador.GetGame().GetNavigator().TryGetSearchResultList(CategoryId, out SearchResultList))
{
CategoryId = 36;
}
if (SearchResultList.CategoryType != NavigatorCategoryType.CATEGORY || SearchResultList.RequiredRank > Session.GetHabbo().Rank)
{
CategoryId = 36;
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (!Session.GetHabbo().InRoom)
{
return;
}
int ItemId = Packet.PopInt();
ICollection <TelevisionItem> Videos = RocketEmulador.GetGame().GetTelevisionManager().TelevisionList;
if (Videos.Count == 0)
{
Session.SendNotification("Oh, it looks like the hotel manager haven't added any videos for you to watch! :(");
return;
}
Dictionary <int, TelevisionItem> dict = RocketEmulador.GetGame().GetTelevisionManager()._televisions;
foreach (TelevisionItem value in RandomValues(dict).Take(1))
{
Session.SendMessage(new GetYouTubeVideoComposer(ItemId, value.YouTubeId));
}
Session.SendMessage(new GetYouTubePlaylistComposer(ItemId, Videos));
}
public void Parse(GameClient Session, ClientPacket Packet)
{
var ForumId = Packet.PopInt(); //Maybe Forum ID
var ThreadId = Packet.PopInt(); //Maybe Thread ID
var StartIndex = Packet.PopInt(); //Start index
var length = Packet.PopInt(); //List Length
var Forum = RocketEmulador.GetGame().GetGroupForumManager().GetForum(ForumId);
if (Forum == null)
{
// Session.SendNotification("Forum introuvable!");
return;
}
var Thread = Forum.GetThread(ThreadId);
if (Thread == null)
{
Session.SendNotification("Forum discussion introuvable!");
return;
}
Session.SendMessage(new ThreadDataComposer(Thread, StartIndex, length));
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (Session == null || Session.GetHabbo() == null)
{
return;
}
// if (RocketEmulador.GetGame().GetModerationManager().UsersHasPendingTicket(Session.GetHabbo().Id))
{
Session.SendMessage(new BroadcastMessageAlertComposer("You currently already have a pending ticket, please wait for a response from a moderator."));
return;
}
int photoId;
if (!int.TryParse(Packet.PopString(), out photoId))
{
return;
}
int roomId = Packet.PopInt();
int creatorId = Packet.PopInt();
int categoryId = Packet.PopInt();
//RocketEmulador.GetGame().GetModerationManager().SendNewTicket(Session, categoryId, creatorId, "", new List<string>(), (int) ModerationSupportTicketType.PHOTO, photoId);
RocketEmulador.GetGame().GetClientManager().ModAlert("A new support ticket has been submitted!");
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
if (!Session.GetHabbo().InRoom)
{
return;
}
Room Room = null;
if (!RocketEmulador.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
{
return;
}
if (!Room.CheckRights(Session))
{
return;
}
Item Item = Room.GetRoomItemHandler().GetItem(Packet.PopInt());
if (Item == null)
{
return;
}
if (Item.GetBaseItem().InteractionType == InteractionType.POSTIT || Item.GetBaseItem().InteractionType == InteractionType.CAMERA_PICTURE)
{
Room.GetRoomItemHandler().RemoveFurniture(Session, Item.Id);
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("DELETE FROM `items` WHERE `id` = '" + Item.Id + "' LIMIT 1");
}
}
}
public void Parse(GameClient Session, ClientPacket Packet)
{
string PetName = Packet.PopString();
if (PetName.Length < 2)
{
Session.SendMessage(new CheckPetNameComposer(2, "2"));
return;
}
else if (PetName.Length > 15)
{
Session.SendMessage(new CheckPetNameComposer(1, "15"));
return;
}
else if (!RocketEmulador.IsValidAlphaNumeric(PetName))
{
Session.SendMessage(new CheckPetNameComposer(3, ""));
return;
}
else if (RocketEmulador.GetGame().GetChatManager().GetFilter().IsFiltered(PetName))
{
Session.SendMessage(new CheckPetNameComposer(4, ""));
return;
}
Session.SendMessage(new CheckPetNameComposer(0, ""));
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
Room Room = null;
if (!RocketEmulador.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
{
return;
}
if (!Room.CheckRights(Session))
{
return;
}
int itemID = Packet.PopInt();
string wallPositionData = Packet.PopString();
Item Item = Room.GetRoomItemHandler().GetItem(itemID);
if (Item == null)
{
return;
}
try
{
string WallPos = Room.GetRoomItemHandler().WallPositionCheck(":" + wallPositionData.Split(':')[1]);
Item.wallCoord = WallPos;
}
catch { return; }
Room.GetRoomItemHandler().UpdateItem(Item);
Room.SendMessage(new ItemUpdateComposer(Item, Room.OwnerId));
}
public QuestCompletedComposer(GameClient Session, Quest Quest)
: base(ServerPacketHeader.QuestCompletedMessageComposer)
{
int AmountInCat = RocketEmulador.GetGame().GetQuestManager().GetAmountOfQuestsInCategory(Quest.Category);
int Number = Quest == null ? AmountInCat : Quest.Number;
int UserProgress = Quest == null ? 0 : Session.GetHabbo().GetQuestProgress(Quest.Id);
base.WriteString(Quest.Category);
base.WriteInteger(1); // Quest progress in this cat
base.WriteInteger((Quest.Name.Contains("xmas2012")) ? 1 : AmountInCat); // Total quests in this cat
base.WriteInteger(Quest == null ? 3 : Quest.RewardType); // Reward type (1 = Snowflakes, 2 = Love hearts, 3 = Pixels, 4 = Seashells, everything else is pixels
base.WriteInteger(Quest == null ? 0 : Quest.Id); // Quest id
base.WriteBoolean(Quest == null ? true : Session.GetHabbo().GetStats().QuestID == Quest.Id); // Quest started
base.WriteString(Quest == null ? string.Empty : Quest.ActionName);
base.WriteString(Quest == null ? string.Empty : Quest.DataBit);
base.WriteInteger(Quest == null ? 0 : Quest.Reward);
base.WriteString(Quest == null ? string.Empty : Quest.Name);
base.WriteInteger(UserProgress); // Current progress
base.WriteInteger(Quest == null ? 10 : Quest.GoalData); // Target progress
base.WriteInteger(Quest == null ? 11110 : Quest.TimeUnlock); // "Next quest available countdown" in seconds
base.WriteString("");
base.WriteString("");
base.WriteBoolean(true); // ?
base.WriteBoolean(true); // Activate next quest..
}
public WardrobeComposer(GameClient Session)
: base(ServerPacketHeader.WardrobeMessageComposer)
{
base.WriteInteger(1);
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `slot_id`,`look`,`gender` FROM `user_wardrobe` WHERE `user_id` = '" + Session.GetHabbo().Id + "'");
DataTable WardrobeData = dbClient.getTable();
if (WardrobeData == null)
{
base.WriteInteger(0);
}
else
{
base.WriteInteger(WardrobeData.Rows.Count);
foreach (DataRow Row in WardrobeData.Rows)
{
base.WriteInteger(Convert.ToInt32(Row["slot_id"]));
base.WriteString(Convert.ToString(Row["look"]));
base.WriteString(Row["gender"].ToString().ToUpper());
}
}
}
}
public void Init(ItemDataManager itemDataManager)
{
RocketEmulador.RocketData().data.TryGetValue("camera.path.preview", out this._previewPath);
RocketEmulador.RocketData().data.TryGetValue("camera.path.purchased", out this._purchasedPath);
if (RocketEmulador.RocketData().data.ContainsKey("camera.preview.maxcache"))
{
this._maxPreviewCacheCount = int.Parse(RocketEmulador.RocketData().data["camera.preview.maxcache"]);
}
if (RocketEmulador.GetDBConfig().DBData.ContainsKey("camera.photo.purchase.price.coins"))
{
this._purchaseCoinsPrice = int.Parse(RocketEmulador.GetDBConfig().DBData["camera.photo.purchase.price.coins"]);
}
if (RocketEmulador.GetDBConfig().DBData.ContainsKey("camera.photo.purchase.price.duckets"))
{
this._purchaseDucketsPrice = int.Parse(RocketEmulador.GetDBConfig().DBData["camera.photo.purchase.price.duckets"]);
}
if (RocketEmulador.GetDBConfig().DBData.ContainsKey("camera.photo.publish.price.duckets"))
{
this._publishDucketsPrice = int.Parse(RocketEmulador.GetDBConfig().DBData["camera.photo.publish.price.duckets"]);
}
int ItemId = int.Parse(RocketEmulador.GetDBConfig().DBData ["camera.photo.purchase.item_id"]);
if (!itemDataManager.GetItem(ItemId, out this._photoPoster))
{
log.Error("Couldn't load photo poster item " + ItemId + ", no furniture record found.");
}
//log.Info("Camera Photo Manager -> LOADED");
}
public MarketPlaceOffersComposer(int MinCost, int MaxCost, Dictionary <int, MarketOffer> dictionary, Dictionary <int, int> dictionary2)
: base(ServerPacketHeader.MarketPlaceOffersMessageComposer)
{
base.WriteInteger(dictionary.Count);
if (dictionary.Count > 0)
{
foreach (KeyValuePair <int, MarketOffer> pair in dictionary)
{
base.WriteInteger(pair.Value.OfferID);
base.WriteInteger(1);//State
base.WriteInteger(1);
base.WriteInteger(pair.Value.SpriteId);
base.WriteInteger(256);
base.WriteString("");
base.WriteInteger(pair.Value.LimitedNumber);
base.WriteInteger(pair.Value.LimitedStack);
base.WriteInteger(pair.Value.TotalPrice);
base.WriteInteger(0);
base.WriteInteger(RocketEmulador.GetGame().GetCatalog().GetMarketplace().AvgPriceForSprite(pair.Value.SpriteId));
base.WriteInteger(dictionary2[pair.Value.SpriteId]);
}
}
base.WriteInteger(dictionary.Count);//Item count to show how many were found.
}
public bool Execute(params object[] Params)
{
if (Params == null || Params.Length == 0)
{
return(false);
}
Habbo Player = (Habbo)Params[0];
if (Player == null || Player.GetClient() == null)
{
return(false);
}
Habbo Owner = RocketEmulador.GetHabboById(Player.Id);
if (Owner == null || !Owner.GetPermissions().HasRight("room_item_wired_rewards"))
{
Player.GetClient().SendMessage(new RoomNotificationComposer("supernoti", "message", "Você não tem permissão para utilizar este wired..."));
}
RoomUser User = Player.CurrentRoom.GetRoomUserManager().GetRoomUserByHabbo(Player.Username);
if (User == null)
{
return(false);
}
if (string.IsNullOrEmpty(this.StringData))
{
return(false);
}
string HandI = this.StringData;
User.CarryItem(Convert.ToInt32(HandI));
return(true);
}
public void OnTrigger(GameClient Session, Item Item, int Request, bool HasRights)
{
int Modes = Item.GetBaseItem().Modes - 1;
if (Session == null || !HasRights || Modes <= 0)
{
return;
}
RocketEmulador.GetGame().GetQuestManager().ProgressUserQuest(Session, QuestType.FURNI_SWITCH);
int CurrentMode = 0;
int NewMode = 0;
if (!int.TryParse(Item.ExtraData, out CurrentMode))
{
}
if (CurrentMode <= 0)
{
NewMode = 1;
}
else if (CurrentMode >= Modes)
{
NewMode = 0;
}
else
{
NewMode = CurrentMode + 1;
}
Item.ExtraData = NewMode.ToString();
Item.UpdateState();
}
public void Init()
{
if (_games.Count > 0)
{
_games.Clear();
}
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
DataTable GetData = null;
dbClient.SetQuery("SELECT `id`,`name`,`colour_one`,`colour_two`,`resource_path`,`string_three`,`game_swf`,`game_assets`,`game_server_host`,`game_server_port`,`socket_policy_port`,`game_enabled` FROM `games_config`");
GetData = dbClient.getTable();
if (GetData != null)
{
foreach (DataRow Row in GetData.Rows)
{
this._games.Add(Convert.ToInt32(Row["id"]), new GameData(Convert.ToInt32(Row["id"]), Convert.ToString(Row["name"]), Convert.ToString(Row["colour_one"]), Convert.ToString(Row["colour_two"]), Convert.ToString(Row["resource_path"]), Convert.ToString(Row["string_three"]), Convert.ToString(Row["game_swf"]), Convert.ToString(Row["game_assets"]), Convert.ToString(Row["game_server_host"]), Convert.ToString(Row["game_server_port"]), Convert.ToString(Row["socket_policy_port"]), RocketEmulador.EnumToBool(Row["game_enabled"].ToString())));
}
}
}
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine(" [FUNCIONANDO] => [Rocket Emu] => Carregando as configurações de jogos.");
}
public int AvgPriceForSprite(int SpriteID)
{
int num = 0;
int num2 = 0;
if (this.MarketAverages.ContainsKey(SpriteID) && this.MarketCounts.ContainsKey(SpriteID))
{
if (this.MarketCounts[SpriteID] > 0)
{
return(this.MarketAverages[SpriteID] / this.MarketCounts[SpriteID]);
}
return(0);
}
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `avgprice` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1");
num = dbClient.getInteger();
dbClient.SetQuery("SELECT `sold` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1");
num2 = dbClient.getInteger();
}
this.MarketAverages.Add(SpriteID, num);
this.MarketCounts.Add(SpriteID, num2);
if (num2 > 0)
{
return(Convert.ToInt32(Math.Ceiling((double)(num / num2))));
}
return(0);
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int SlotId = Packet.PopInt();
string Look = RocketEmulador.GetGame().GetAntiMutant().RunLook(Packet.PopString());
string Gender = Packet.PopString();
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT null FROM `user_wardrobe` WHERE `user_id` = " + Session.GetHabbo().Id + " AND `slot_id` = @slot");
dbClient.AddParameter("slot", SlotId);
if (dbClient.getRow() != null)
{
dbClient.SetQuery("UPDATE `user_wardrobe` SET `look` = @look, `gender` = @gender WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND `slot_id` = @slot LIMIT 1");
dbClient.AddParameter("slot", SlotId);
dbClient.AddParameter("look", Look);
dbClient.AddParameter("gender", Gender.ToUpper());
dbClient.RunQuery();
}
else
{
dbClient.SetQuery("INSERT INTO `user_wardrobe` (`user_id`,`slot_id`,`look`,`gender`) VALUES ('" + Session.GetHabbo().Id + "',@slot,@look,@gender)");
dbClient.AddParameter("slot", SlotId);
dbClient.AddParameter("look", Look);
dbClient.AddParameter("gender", Gender.ToUpper());
dbClient.RunQuery();
}
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int userID = Packet.PopInt();
Boolean IsMe = Packet.PopBoolean();
Habbo targetData = RocketEmulador.GetHabboById(userID);
if (targetData == null)
{
Session.SendNotification("An error occured whilst finding that user's profile.");
return;
}
List <Group> Groups = RocketEmulador.GetGame().GetGroupManager().GetGroupsForUser(targetData.Id);
int friendCount = 0;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT COUNT(0) FROM `messenger_friendships` WHERE (`user_one_id` = @userid OR `user_two_id` = @userid)");
dbClient.AddParameter("userid", userID);
friendCount = dbClient.getInteger();
}
Session.SendMessage(new ProfileInformationComposer(targetData, Session, Groups, friendCount));
}
public void Parse(GameClient Session, ClientPacket Packet)
{
if (!Session.GetHabbo().InRoom)
return;
int Action = Packet.PopInt();
Room Room = null;
if (!RocketEmulador.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
return;
RoomUser User = Room.GetRoomUserManager().GetRoomUserByHabbo(Session.GetHabbo().Id);
if (User == null)
return;
if (User.DanceId > 0)
User.DanceId = 0;
if (Session.GetHabbo().Effects().CurrentEffect > 0)
Room.SendMessage(new AvatarEffectComposer(User.VirtualId, 0));
User.UnIdle();
Room.SendMessage(new ActionComposer(User.VirtualId, Action));
if (Action == 5) // idle
{
User.IsAsleep = true;
Room.SendMessage(new SleepComposer(User, true));
}
RocketEmulador.GetGame().GetQuestManager().ProgressUserQuest(Session, QuestType.SOCIAL_WAVE);
}
public GroupForumSettings(GroupForum Forum)
{
this.ParentForum = Forum;
DataRow Row;
using (IQueryAdapter adap = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
adap.SetQuery("SELECT * FROM group_forums_settings WHERE group_id = '" + Forum.Id + "'");
//adap.AddParameter("id", Forum.Id);
Row = adap.getRow();
}
if (Row == null)
{
using (IQueryAdapter adap = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
adap.SetQuery("REPLACE INTO group_forums_settings (group_id) VALUES (@id);SELECT * FROM group_forums_settings WHERE group_id = @id");
adap.AddParameter("id", Forum.Id);
Row = adap.getRow();
}
}
this.WhoCanRead = Convert.ToInt32(Row["who_can_read"]);
this.WhoCanPost = Convert.ToInt32(Row["who_can_post"]);
this.WhoCanInitDiscussions = Convert.ToInt32(Row["who_can_init_discussions"]);
this.WhoCanModerate = Convert.ToInt32(Row["who_can_mod"]);
}
