internal void GetGroupForumThreadRoot()
        {
            uint GroupId = Request.PopWiredUInt();
            int StartIndex = Request.PopWiredInt32();
            int EndIndex = Request.PopWiredInt32(); // igual siempre será 20.

            Guild Group = MercuryEnvironment.GetGame().GetGroupManager().GetGroup(GroupId);
            if (Group == null || !Group.HasForum)
            {
                return;
            }

            using (IQueryAdapter dbClient = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
            {
                dbClient.setQuery("SELECT * FROM group_forum_posts WHERE group_id = '" + GroupId + "' AND parent_id = 0 ORDER BY timestamp DESC;");
                DataTable Table = dbClient.getTable();

                if (Table == null)
                {
                    ServerMessage Méssich = new ServerMessage(Outgoing.GroupForumThreadRootMessageComposer);
                    Méssich.AppendUInt(GroupId);
                    Méssich.AppendInt32(0);
                    Méssich.AppendInt32(0);
                    Session.SendMessage(Méssich);
                    return;
                }

                int b = (Table.Rows.Count <= 20) ? Table.Rows.Count : 20;
                List<GroupForumPost> Threads = new List<GroupForumPost>();
                int i = 1;
                while (i <= b)
                {
                    DataRow Row = Table.Rows[i - 1];
                    if (Row == null)
                    {
                        b--;
                        continue;
                    }
                    GroupForumPost thread = new GroupForumPost(Row);
                    
                    Threads.Add(thread);
                    i++;
                }
                Threads = Threads.OrderByDescending(x => x.Pinned).ToList();

                ServerMessage Message = new ServerMessage(Outgoing.GroupForumThreadRootMessageComposer);
                Message.AppendUInt(GroupId);
                Message.AppendInt32(StartIndex);
                Message.AppendInt32(b);
                foreach (GroupForumPost Thread in Threads)
                {
                    Message.AppendUInt(Thread.Id);
                    Message.AppendUInt(Thread.PosterId);
                    Message.AppendString(Thread.PosterName);
                    Message.AppendString(Thread.Subject);
                    Message.AppendBoolean(Thread.Pinned);
                    Message.AppendBoolean(Thread.Locked);
                    Message.AppendInt32((MercuryEnvironment.GetUnixTimestamp() - Thread.Timestamp));
                    Message.AppendInt32(Thread.MessageCount + 1);
                    Message.AppendInt32(0);
                    Message.AppendInt32(0);//readtimes?
                    Message.AppendInt32(0);
                    Message.AppendString("");
                    Message.AppendInt32((MercuryEnvironment.GetUnixTimestamp() - Thread.Timestamp));
                    Message.AppendByte((Thread.Hidden) ? 10 : 1);
                    Message.AppendInt32(0);
                    Message.AppendString(Thread.Hider);
                    Message.AppendInt32(0);//Unknown, but unused. Parece ID
                }
                Session.SendMessage(Message);
            }
        }
        internal void AlterForumThreadState()
        {
            uint GroupId = Request.PopWiredUInt();
            uint ThreadId = Request.PopWiredUInt();
            int StateToSet = Request.PopWiredInt32();


            using (IQueryAdapter dbClient = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
            {
                dbClient.setQuery("SELECT * FROM group_forum_posts WHERE group_id = '" + GroupId + "' AND id = '" + ThreadId + "' LIMIT 1;");
                DataRow Row = dbClient.getRow();
                Guild Group = MercuryEnvironment.GetGame().GetGroupManager().GetGroup(GroupId);
                if (Row != null)
                {
                    if ((uint)Row["poster_id"] == Session.GetHabbo().Id || Group.Admins.ContainsKey(Session.GetHabbo().Id))
                    {
                        dbClient.setQuery("UPDATE group_forum_posts SET hidden = @hid WHERE id = " + ThreadId + ";");
                        dbClient.addParameter("hid", (StateToSet == 10) ? "1" : "0");
                        dbClient.runQuery();
                    }
                }

                GroupForumPost Thread = new GroupForumPost(Row);

                ServerMessage Notif = new ServerMessage(Outgoing.SuperNotificationMessageComposer);
                Notif.AppendString((StateToSet == 10) ? "forums.thread.hidden" : "forums.thread.restored");
                    Notif.AppendInt32(0);
                    Session.SendMessage(Notif);

                if (Thread.ParentId != 0)
                {
                    return;
                }
                ServerMessage Message = new ServerMessage(Outgoing.GroupForumThreadUpdateMessageComposer);
                Message.AppendUInt(GroupId);
                Message.AppendUInt(Thread.Id);
                Message.AppendUInt(Thread.PosterId);
                Message.AppendString(Thread.PosterName);
                Message.AppendString(Thread.Subject);
                Message.AppendBoolean(Thread.Pinned);
                Message.AppendBoolean(Thread.Locked);
                Message.AppendInt32((MercuryEnvironment.GetUnixTimestamp() - Thread.Timestamp));
                Message.AppendInt32(Thread.MessageCount + 1);
                Message.AppendInt32(0);
                Message.AppendInt32(0);//readtimes?
                Message.AppendInt32(0);
                Message.AppendString("");
                Message.AppendInt32((MercuryEnvironment.GetUnixTimestamp() - Thread.Timestamp));
                Message.AppendByte(StateToSet);
                Message.AppendInt32(0);
                Message.AppendString(Thread.Hider);
                Message.AppendInt32(0);//Unknown, but unused. Parece ID
                Session.SendMessage(Message);
            }
        }
        internal void ReadForumThread()
        {
            uint GroupId = Request.PopWiredUInt();
            uint ThreadId = Request.PopWiredUInt();
            int StartIndex = Request.PopWiredInt32();
            int EndIndex = Request.PopWiredInt32();

            Guild Group = MercuryEnvironment.GetGame().GetGroupManager().GetGroup(GroupId);
            if (Group == null || !Group.HasForum)
            {
                return;
            }

            using (IQueryAdapter dbClient = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
            {
                dbClient.setQuery("SELECT * FROM group_forum_posts WHERE group_id = '" + GroupId + "' AND parent_id = '" + ThreadId + "' OR id = '" + ThreadId + "' ORDER BY timestamp ASC;");
                DataTable Table = dbClient.getTable();

                if (Table == null)
                {
                    return;
                }

                int b = (Table.Rows.Count <= 20) ? Table.Rows.Count : 20;
                List<GroupForumPost> posts = new List<GroupForumPost>();
                int i = 1;
                while (i <= b)
                {
                    DataRow Row = Table.Rows[i - 1];
                    if (Row == null)
                    {
                        b--;
                        continue;
                    }
                    GroupForumPost thread = new GroupForumPost(Row);
                    if (thread.ParentId == 0 && thread.Hidden)
                    {
                        return;//
                    }

                    posts.Add(thread);
                    i++;
                }

                ServerMessage Message = new ServerMessage(Outgoing.GroupForumReadThreadMessageComposer);
                Message.AppendUInt(GroupId);
                Message.AppendUInt(ThreadId);
                Message.AppendInt32(StartIndex);
                Message.AppendInt32(b);

                int indx = 0;

                foreach (GroupForumPost Post in posts)
                {
                    Message.AppendInt32(indx++ - 1);
                    Message.AppendInt32(indx - 1);
                    Message.AppendUInt(Post.PosterId);
                    Message.AppendString(Post.PosterName);
                    Message.AppendString(Post.PosterLook);
                    Message.AppendInt32((MercuryEnvironment.GetUnixTimestamp() - Post.Timestamp));
                    Message.AppendString(Post.PostContent);
                    Message.AppendByte(0);
                    Message.AppendInt32(0);
                    Message.AppendString(Post.Hider);
                    Message.AppendInt32(0);//Unknown, but unused. Parece ID
                }
                Session.SendMessage(Message);
            }
        }
        internal void PublishForumThread()
        {
            if ((MercuryEnvironment.GetUnixTimestamp() - Session.GetHabbo().lastSqlQuery) < 20)
            {
                Session.SendNotif("Please wait 20 seconds before publishing the next post!");
                return;
            }

            uint GroupId = Request.PopWiredUInt();
            uint ThreadId = Request.PopWiredUInt();
            string Subject = Request.PopFixedString();
            string Content = Request.PopFixedString();

            Guild Group = MercuryEnvironment.GetGame().GetGroupManager().GetGroup(GroupId);
            
            if (Group == null || !Group.HasForum)
            {
                return;
            }

            int Timestamp = MercuryEnvironment.GetUnixTimestamp();

            using (IQueryAdapter dbClient = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
            {
                if (ThreadId != 0)
                {
                    dbClient.setQuery("SELECT * FROM group_forum_posts WHERE id = " + ThreadId);
                    DataRow Row = dbClient.getRow();
                    GroupForumPost Post = new GroupForumPost(Row);

                    if (Post.Locked || Post.Hidden)
                    {
                        Session.SendNotif("¡No puedes publicar a este tema porque está oculto y/o bloqueado! Por favor, haz clic en 'Cancelar'.");
                        return;
                    }
                }

                this.Session.GetHabbo().lastSqlQuery = MercuryEnvironment.GetUnixTimestamp();
                dbClient.setQuery("INSERT INTO group_forum_posts (group_id, parent_id, timestamp, poster_id, poster_name, poster_look, subject, post_content) VALUES (@gid, @pard, @ts, @pid, @pnm, @plk, @subjc, @content)");
                dbClient.addParameter("gid", GroupId);
                dbClient.addParameter("pard", ThreadId);
                dbClient.addParameter("ts", Timestamp);
                dbClient.addParameter("pid", Session.GetHabbo().Id);
                dbClient.addParameter("pnm", Session.GetHabbo().Username);
                dbClient.addParameter("plk", Session.GetHabbo().Look);
                dbClient.addParameter("subjc", Subject);
                dbClient.addParameter("content", Content);
                ThreadId = (uint)dbClient.getInteger();
            }

            Group.ForumScore += 0.25;
            Group.ForumLastPosterName = Session.GetHabbo().Username;
            Group.ForumLastPosterId = Session.GetHabbo().Id;
            Group.ForumLastPosterTimestamp = Timestamp;
            Group.ForumMessagesCount++;
            Group.UpdateForum();

            if (ThreadId == 0)
            {
                ServerMessage Message = new ServerMessage(Outgoing.GroupForumNewThreadMessageComposer);
                Message.AppendUInt(GroupId);
                Message.AppendUInt(ThreadId);
                Message.AppendUInt(Session.GetHabbo().Id);
                Message.AppendString(Subject);
                Message.AppendString(Content);
                Message.AppendBoolean(false);
                Message.AppendBoolean(false);
                Message.AppendInt32((MercuryEnvironment.GetUnixTimestamp() - Timestamp));
                Message.AppendInt32(1);
                Message.AppendInt32(0);
                Message.AppendInt32(0);//readtimes?
                Message.AppendInt32(1);
                Message.AppendString("");
                Message.AppendInt32((MercuryEnvironment.GetUnixTimestamp() - Timestamp));
                Message.AppendByte(1);
                Message.AppendInt32(1);
                Message.AppendString("");
                Message.AppendInt32(0);//Unknown, but unused. Parece ID
                Session.SendMessage(Message);
            }
            else
            {
                ServerMessage Message = new ServerMessage(Outgoing.GroupForumNewResponseMessageComposer);
                Message.AppendUInt(GroupId);
                Message.AppendUInt(ThreadId);
                Message.AppendUInt(Group.ForumMessagesCount);//something quick
                Message.AppendInt32(0);//something quick
                Message.AppendUInt(Session.GetHabbo().Id);
                Message.AppendString(Session.GetHabbo().Username);
                Message.AppendString(Session.GetHabbo().Look);
                Message.AppendInt32((MercuryEnvironment.GetUnixTimestamp() - Timestamp));
                Message.AppendString(Content);
                Message.AppendByte(0);
                Message.AppendInt32(0);
                Message.AppendString("");
                Message.AppendInt32(0);//Unknown, but unused. Parece ID
                Session.SendMessage(Message);
            }
        }