Reply to thread

Message

<blockquote data-quote="Ghost" data-source="post: 415084" data-attributes="member: 18103">\Communication\Packets\Incoming\Groups\GetForumsListDataEvent.cs[CODE]using Plus.Communication.Packets.Outgoing;using Plus.Communication.Packets.Outgoing.Groups;using Plus.HabboHotel.GameClients;using Plus.HabboHotel.Groups.Forums;using System;using Plus.Database.Interfaces;using System.Collections.Generic;using System.Data;namespace Plus.Communication.Packets.Incoming.Groups{&nbsp; &nbsp; class GetForumsListDataEvent : IPacketEvent&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public void Parse(GameClient Session, ClientPacket Packet)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var int1 = Packet.PopInt();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var int2 = Packet.PopInt();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int int3 = Packet.PopInt();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var forums = new List&lt;GroupForum&gt;();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataTable table;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; switch (int1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 2:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var Forums = PlusEnvironment.GetGame().GetGroupForumManager().GetForumsByUserId(Session.GetHabbo().Id);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Forums.Count - 1 &gt;= int2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Forums = Forums.GetRange(int2, Math.Min(int3, Forums.Count));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendPacket(new ForumsListDataComposer(Forums, Session, int1, int2, int3));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 0:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter adap = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.SetQuery(&quot;SELECT g.id FROM groups as g INNER JOIN group_forums_thread_posts as posts, group_forums_threads as threads WHERE posts.thread_id = threads.id AND @now - posts.`timestamp`&lt;=&nbsp; @Sdays AND threads.forum_id = g.id GROUP BY g.id ORDER BY posts.`timestamp` DESC LIMIT&nbsp; @Index,&nbsp; @LiMiT&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.AddParameter(&quot;limit&quot;, int3);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.AddParameter(&quot;index&quot;, int2);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.AddParameter(&quot;now&quot;, (int)PlusEnvironment.GetUnixTimestamp());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.AddParameter(&quot;sdays&quot;, (60 * 60 * 24 * 7));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table = adap.GetTable();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (DataRow Row in table.Rows)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GroupForum forum;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (PlusEnvironment.GetGame().GetGroupForumManager().TryGetForum(Convert.ToInt32(Row[&quot;id&quot;]), out forum))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; forums.Add(forum);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 1:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter adap = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.SetQuery(&quot;SELECT g.id FROM groups as g INNER JOIN group_forums_thread_views as v, group_forums_threads as threads WHERE v.thread_id = threads.id AND threads.forum_id = g.id AND&nbsp; @now - v.`timestamp` &lt;=&nbsp; @Sdays GROUP BY g.id ORDER BY v.`timestamp` DESC LIMIT&nbsp; @Index,&nbsp; @LiMiT&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.AddParameter(&quot;limit&quot;, int3);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.AddParameter(&quot;index&quot;, int2);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.AddParameter(&quot;now&quot;, (int)PlusEnvironment.GetUnixTimestamp());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adap.AddParameter(&quot;sdays&quot;, (60 * 60 * 24 * 7));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table = adap.GetTable();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (DataRow Row in table.Rows)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GroupForum forum;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (PlusEnvironment.GetGame().GetGroupForumManager().TryGetForum(Convert.ToInt32(Row[&quot;id&quot;]), out forum))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; forums.Add(forum);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendPacket(new ForumsListDataComposer(forums, Session, int1, int2, int3));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE]Does your GetForumsListDataEvent.cs Look like that?</blockquote>

[QUOTE="Ghost, post: 415084, member: 18103"] \Communication\Packets\Incoming\Groups\GetForumsListDataEvent.cs [CODE] using Plus.Communication.Packets.Outgoing; using Plus.Communication.Packets.Outgoing.Groups; using Plus.HabboHotel.GameClients; using Plus.HabboHotel.Groups.Forums; using System; using Plus.Database.Interfaces; using System.Collections.Generic; using System.Data; namespace Plus.Communication.Packets.Incoming.Groups { class GetForumsListDataEvent : IPacketEvent { public void Parse(GameClient Session, ClientPacket Packet) { var int1 = Packet.PopInt(); var int2 = Packet.PopInt(); int int3 = Packet.PopInt(); var forums = new List<GroupForum>(); DataTable table; switch (int1) { case 2: var Forums = PlusEnvironment.GetGame().GetGroupForumManager().GetForumsByUserId(Session.GetHabbo().Id); if (Forums.Count - 1 >= int2) { Forums = Forums.GetRange(int2, Math.Min(int3, Forums.Count)); } Session.SendPacket(new ForumsListDataComposer(Forums, Session, int1, int2, int3)); return; case 0: using (IQueryAdapter adap = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { adap.SetQuery("SELECT g.id FROM groups as g INNER JOIN group_forums_thread_posts as posts, group_forums_threads as threads WHERE posts.thread_id = threads.id AND @now - posts.`timestamp`<= @Sdays AND threads.forum_id = g.id GROUP BY g.id ORDER BY posts.`timestamp` DESC LIMIT @Index, @LiMiT"); adap.AddParameter("limit", int3); adap.AddParameter("index", int2); adap.AddParameter("now", (int)PlusEnvironment.GetUnixTimestamp()); adap.AddParameter("sdays", (60 * 60 * 24 * 7)); table = adap.GetTable(); } foreach (DataRow Row in table.Rows) { GroupForum forum; if (PlusEnvironment.GetGame().GetGroupForumManager().TryGetForum(Convert.ToInt32(Row["id"]), out forum)) forums.Add(forum); } break; case 1: using (IQueryAdapter adap = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { adap.SetQuery("SELECT g.id FROM groups as g INNER JOIN group_forums_thread_views as v, group_forums_threads as threads WHERE v.thread_id = threads.id AND threads.forum_id = g.id AND @now - v.`timestamp` <= @Sdays GROUP BY g.id ORDER BY v.`timestamp` DESC LIMIT @Index, @LiMiT"); adap.AddParameter("limit", int3); adap.AddParameter("index", int2); adap.AddParameter("now", (int)PlusEnvironment.GetUnixTimestamp()); adap.AddParameter("sdays", (60 * 60 * 24 * 7)); table = adap.GetTable(); } foreach (DataRow Row in table.Rows) { GroupForum forum; if (PlusEnvironment.GetGame().GetGroupForumManager().TryGetForum(Convert.ToInt32(Row["id"]), out forum)) forums.Add(forum); } break; } Session.SendPacket(new ForumsListDataComposer(forums, Session, int1, int2, int3)); } } }[/CODE] Does your GetForumsListDataEvent.cs Look like that? [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members