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"]);
}
public void HandleRequest(int Id, bool Accepted)
{
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
if (Accepted)
{
dbClient.SetQuery("INSERT INTO group_memberships (user_id, group_id) VALUES (@uid, @gid)");
dbClient.AddParameter("gid", this.Id);
dbClient.AddParameter("uid", Id);
dbClient.RunQuery();
this._members.Add(Id);
}
dbClient.SetQuery("DELETE FROM group_requests WHERE user_id=@uid AND group_id=@gid LIMIT 1");
dbClient.AddParameter("gid", this.Id);
dbClient.AddParameter("uid", Id);
dbClient.RunQuery();
}
if (this._requests.Contains(Id))
{
this._requests.Remove(Id);
}
}
public void OnPlace(GameClient Session, Item Item)
{
Item.GetRoom().GetRoomItemHandler().HopperCount++;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO items_hopper (hopper_id, room_id) VALUES (@hopperid, @roomid);");
dbClient.AddParameter("hopperid", Item.Id);
dbClient.AddParameter("roomid", Item.RoomId);
dbClient.RunQuery();
}
if (Item.InteractingUser != 0)
{
RoomUser User = Item.GetRoom().GetRoomUserManager().GetRoomUserByHabbo(Item.InteractingUser);
if (User != null)
{
User.ClearMovement(true);
User.AllowOverride = false;
User.CanWalk = true;
}
Item.InteractingUser = 0;
}
}
public void AddMember(int Id)
{
if (this.IsMember(Id) || this.GroupType == GroupType.LOCKED && this._requests.Contains(Id))
{
return;
}
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
if (this.IsAdmin(Id))
{
dbClient.SetQuery("UPDATE `group_memberships` SET `rank` = '0' WHERE user_id = @uid AND group_id = @gid");
this._administrators.Remove(Id);
this._members.Add(Id);
}
else if (this.GroupType == GroupType.LOCKED)
{
dbClient.SetQuery("INSERT INTO `group_requests` (user_id, group_id) VALUES (@uid, @gid)");
this._requests.Add(Id);
}
else
{
dbClient.SetQuery("INSERT INTO `group_memberships` (user_id, group_id) VALUES (@uid, @gid)");
this._members.Add(Id);
}
dbClient.AddParameter("gid", this.Id);
dbClient.AddParameter("uid", Id);
dbClient.RunQuery();
}
}
public void DeleteMember(int Id)
{
if (IsMember(Id))
{
if (this._members.Contains(Id))
{
this._members.Remove(Id);
}
}
else if (IsAdmin(Id))
{
if (this._administrators.Contains(Id))
{
this._administrators.Remove(Id);
}
}
else
{
return;
}
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("DELETE FROM group_memberships WHERE user_id=@uid AND group_id=@gid LIMIT 1");
dbClient.AddParameter("gid", this.Id);
dbClient.AddParameter("uid", Id);
dbClient.RunQuery();
}
}
public TonerData(int Item)
{
ItemId = Item;
DataRow Row;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT enabled,data1,data2,data3 FROM room_items_toner WHERE id=" + ItemId + " LIMIT 1");
Row = dbClient.getRow();
}
if (Row == null)
{
//throw new NullReferenceException("No toner data found in the database for " + ItemId);
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("INSERT INTO `room_items_toner` VALUES (" + ItemId + ",'0',0,0,0)");
dbClient.SetQuery("SELECT enabled,data1,data2,data3 FROM room_items_toner WHERE id=" + ItemId + " LIMIT 1");
Row = dbClient.getRow();
}
}
Enabled = int.Parse(Row[0].ToString());
Hue = Convert.ToInt32(Row[1]);
Saturation = Convert.ToInt32(Row[2]);
Lightness = Convert.ToInt32(Row[3]);
}
public void Disconnect()
{
try
{
if (GetHabbo() != null)
{
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery(GetHabbo().GetQueryString);
}
GetHabbo().OnDisconnect();
}
}
catch (Exception e)
{
Logging.LogException(e.ToString());
}
if (!_disconnected)
{
if (_connection != null)
{
_connection.Dispose();
}
_disconnected = true;
}
}
public void Parse(GameClient Session, ClientPacket Packet)
{
if (Session == null)
{
return;
}
int RoomId = Packet.PopInt();
RoomData Data = RocketEmulador.GetGame().GetRoomManager().GenerateRoomData(RoomId);
if (Data == null || Session.GetHabbo().FavoriteRooms.Count >= 30 || Session.GetHabbo().FavoriteRooms.Contains(RoomId))
{
// send packet that favourites is full.
return;
}
Session.GetHabbo().FavoriteRooms.Add(RoomId);
Session.SendMessage(new UpdateFavouriteRoomComposer(RoomId, true));
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("INSERT INTO user_favorites (user_id,room_id) VALUES (" + Session.GetHabbo().Id + "," + RoomId + ")");
}
}
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 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 Init()
{
if (this._televisions.Count > 0)
{
_televisions.Clear();
}
DataTable getData = null;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `items_youtube` ORDER BY `id` DESC");
getData = dbClient.getTable();
if (getData != null)
{
foreach (DataRow Row in getData.Rows)
{
this._televisions.Add(Convert.ToInt32(Row["id"]), new TelevisionItem(Convert.ToInt32(Row["id"]), Row["youtube_id"].ToString(), Row["title"].ToString(), Row["description"].ToString(), RocketEmulador.EnumToBool(Row["enabled"].ToString())));
}
}
}
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine(" [FUNCIONANDO] => [Rocket Emu] => Carregando item da televisão..");
}
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 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 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 bool TryGetGroup(int Id, out Group Group)
{
Group = null;
if (this._groups.ContainsKey(Id))
{
return(this._groups.TryGetValue(Id, out Group));
}
lock (this._groupLoadingSync)
{
if (this._groups.ContainsKey(Id))
{
return(this._groups.TryGetValue(Id, out Group));
}
DataRow Row = null;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `groups` WHERE `id` = @id LIMIT 1");
dbClient.AddParameter("id", Id);
Row = dbClient.getRow();
if (Row != null)
{
Group = new Group(
Convert.ToInt32(Row["id"]), Convert.ToString(Row["name"]), Convert.ToString(Row["desc"]), Convert.ToString(Row["badge"]), Convert.ToInt32(Row["room_id"]), Convert.ToInt32(Row["owner_id"]),
Convert.ToInt32(Row["created"]), Convert.ToInt32(Row["state"]), Convert.ToInt32(Row["colour1"]), Convert.ToInt32(Row["colour2"]), Convert.ToInt32(Row["admindeco"]), Convert.ToInt32(Row["has_forum"]) == 1);
this._groups.TryAdd(Group.Id, Group);
return(true);
}
}
}
return(false);
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int GroupId = Packet.PopInt();
string Name = RocketEmulador.GetGame().GetChatManager().GetFilter().CheckMessage(Packet.PopString());
string Desc = RocketEmulador.GetGame().GetChatManager().GetFilter().CheckMessage(Packet.PopString());
Group Group = null;
if (!RocketEmulador.GetGame().GetGroupManager().TryGetGroup(GroupId, out Group))
{
return;
}
if (Group.CreatorId != Session.GetHabbo().Id)
{
return;
}
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `groups` SET `name`= @name, `desc` = @desc WHERE `id` = '" + GroupId + "' LIMIT 1");
dbClient.AddParameter("name", Name);
dbClient.AddParameter("desc", Desc);
dbClient.RunQuery();
}
Group.Name = Name;
Group.Description = Desc;
Session.SendMessage(new GroupInfoComposer(Group, Session));
}
public static Item CreateSingleItemNullable(ItemData Data, Habbo Habbo, string ExtraData, string DisplayFlags, int GroupId = 0, int LimitedNumber = 0, int LimitedStack = 0)
{
if (Data == null)
{
throw new InvalidOperationException("Data cannot be null.");
}
Item Item = new Item(0, 0, Data.Id, ExtraData, 0, 0, 0, 0, Habbo.Id, GroupId, LimitedNumber, LimitedStack, "");
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `items` (base_item,user_id,room_id,x,y,z,wall_pos,rot,extra_data,`limited_number`,`limited_stack`) VALUES (@did,@uid,@rid,@x,@y,@z,@wall_pos,@rot,@extra_data, @limited_number, @limited_stack)");
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);
Item.Id = Convert.ToInt32(dbClient.InsertQuery());
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();
}
return(Item);
}
}
private void UpdateOnlineUsers()
{
TimeSpan Uptime = DateTime.Now - RocketEmulador.ServerStarted;
int UsersOnline = Convert.ToInt32(RocketEmulador.GetGame().GetClientManager().Count);
int RoomCount = RocketEmulador.GetGame().GetRoomManager().Count;
Console.Title = "Rocket Emulador - " + UsersOnline + " usuários online - " + RoomCount + " quartos online - " + Uptime.Days + " dia(s) " + Uptime.Hours + " hora(s) ligado";
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `server_status` SET `users_online` = @users, `loaded_rooms` = @loadedRooms LIMIT 1;");
dbClient.AddParameter("users", UsersOnline);
dbClient.AddParameter("loadedRooms", RoomCount);
dbClient.RunQuery();
}
int userPeak;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `userpeak` FROM `server_status` LIMIT 1");
userPeak = dbClient.getInteger();
}
if (UsersOnline > userPeak)
{
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `server_status` SET `userpeak` = @userpeak LIMIT 1;");
dbClient.AddParameter("userpeak", UsersOnline);
dbClient.RunQuery();
}
}
}
public void Init()
{
if (this._races.Count > 0)
{
this._races.Clear();
}
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `catalog_pet_races`");
DataTable Table = dbClient.getTable();
if (Table != null)
{
foreach (DataRow Row in Table.Rows)
{
PetRace Race = new PetRace(Convert.ToInt32(Row["raceid"]), Convert.ToInt32(Row["color1"]), Convert.ToInt32(Row["color2"]), (Convert.ToString(Row["has1color"]) == "1"), (Convert.ToString(Row["has2color"]) == "1"));
if (!this._races.Contains(Race))
{
this._races.Add(Race);
}
}
}
}
}
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 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 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 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)
{
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 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 UpdateUses()
{
this.CurrentUses += 1;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `catalog_vouchers` SET `current_uses` = `current_uses` + '1' WHERE `voucher` = '" + this._code + "' LIMIT 1");
}
}
public void Disable()
{
Enabled = false;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE room_items_moodlight SET enabled = 0 WHERE item_id = '" + ItemId + "' LIMIT 1");
}
}
public static void CreateTonerData(Item Item)
{
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `room_items_toner` (`id`, `data1`, `data2`, `data3`, `enabled`) VALUES (@id, 0, 0, 0, '0')");
dbClient.AddParameter("id", Item.Id);
dbClient.RunQuery();
}
}
public void Parse(GameClient Session, ClientPacket Packet)
{
string VoucherCode = Packet.PopString().Replace("\r", "");
Voucher Voucher = null;
if (!RocketEmulador.GetGame().GetCatalog().GetVoucherManager().TryGetVoucher(VoucherCode, out Voucher))
{
Session.SendMessage(new VoucherRedeemErrorComposer(0));
return;
}
if (Voucher.CurrentUses >= Voucher.MaxUses)
{
Session.SendNotification("Oops, this voucher has reached the maximum usage limit!");
return;
}
DataRow GetRow = null;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `user_vouchers` WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND `voucher` = @Voucher LIMIT 1");
dbClient.AddParameter("Voucher", VoucherCode);
GetRow = dbClient.getRow();
}
if (GetRow != null)
{
Session.SendNotification("You've already used this voucher code, one per each user, sorry!");
return;
}
else
{
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `user_vouchers` (`user_id`,`voucher`) VALUES ('" + Session.GetHabbo().Id + "', @Voucher)");
dbClient.AddParameter("Voucher", VoucherCode);
dbClient.RunQuery();
}
}
Voucher.UpdateUses();
if (Voucher.Type == VoucherType.CREDIT)
{
Session.GetHabbo().Credits += Voucher.Value;
Session.SendMessage(new CreditBalanceComposer(Session.GetHabbo().Credits));
}
else if (Voucher.Type == VoucherType.DUCKET)
{
Session.GetHabbo().Duckets += Voucher.Value;
Session.SendMessage(new HabboActivityPointNotificationComposer(Session.GetHabbo().Duckets, Voucher.Value));
}
Session.SendMessage(new VoucherRedeemOkComposer());
}
public ModeratorRoomChatlogComposer(Room Room)
: base(ServerPacketHeader.ModeratorRoomChatlogMessageComposer)
{
base.WriteByte(1);
base.WriteShort(2);//Count
base.WriteString("roomName");
base.WriteByte(2);
base.WriteString(Room.Name);
base.WriteString("roomId");
base.WriteByte(1);
base.WriteInteger(Room.Id);
DataTable Table = null;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT id,user_id,room_id, message,DATE_FORMAT(from_unixtime(timestamp),'%k:%i') FROM `chatlogs` WHERE `room_id` = @rid ORDER BY `id` DESC LIMIT 250");
dbClient.AddParameter("rid", Room.Id);
Table = dbClient.getTable();
}
base.WriteShort(Table.Rows.Count);
if (Table != null)
{
foreach (DataRow Row in Table.Rows)
{
UserCache Habbo = RocketEmulador.GetGame().GetCacheManager().GenerateUser(Convert.ToInt32(Row["user_id"]));
//FALTA ARREGLAR QUE SE VEA LA HORA
if (Habbo == null)
{
//base.WriteInteger(((int)RocketEmulador.GetUnixTimestamp() - Convert.ToInt32(Row["timestamp"])) * 1000);
//DateTime time = new DateTime(Convert.ToInt32(Row["timestamp"]));
//base.WriteString(time.ToString("hh:mm"));
//int time = ((int)RocketEmulador.GetUnixTimestamp() - Convert.ToInt32(Row["timestamp"])) * 1000;
//string time2 = time.ToString();
base.WriteString(Convert.ToString(Row[4]));
base.WriteInteger(-1);
base.WriteString("Unknown User");
base.WriteString(string.IsNullOrWhiteSpace(Convert.ToString(Row["message"])) ? "*user sent a blank message*" : Convert.ToString(Row["message"]));
base.WriteBoolean(false);
}
else
{
//base.WriteInteger(((int)RocketEmulador.GetUnixTimestamp() - Convert.ToInt32(Row["timestamp"])) * 1000);
//DateTime time = new DateTime(Convert.ToInt32(Row["timestamp"]));
//base.WriteString(time.ToString("hh:mm"));
//int time = ((int)RocketEmulador.GetUnixTimestamp() - Convert.ToInt32(Row["timestamp"])) * 1000;
//string time2 = time.ToString();
base.WriteString(Convert.ToString(Row[4]));
base.WriteInteger(Habbo.Id);
base.WriteString(Habbo.Username);
base.WriteString(string.IsNullOrWhiteSpace(Convert.ToString(Row["message"])) ? "*user sent a blank message*" : Convert.ToString(Row["message"]));
base.WriteBoolean(false);
}
}
}
}