Reply to thread

Message

<blockquote data-quote="antiny2010" data-source="post: 404330" data-attributes="member: 54335">[CODE]using System;using System.Linq;using System.Text;using System.Collections.Generic;using System.Data;using Plus.HabboHotel.GameClients;using Plus.HabboHotel.Rooms;using Plus.Communication.Packets.Outgoing.Users;using Plus.Communication.Packets.Outgoing.Rooms.Avatar;using System.Threading;using System.Threading.Tasks;using Plus.Communication.Packets.Outgoing.Rooms.Chat;using Plus.HabboHotel.Items;using Plus.HabboHotel.Catalog;using Plus.Communication.Packets.Outgoing.Inventory.Furni;using Plus.Database.Interfaces;using Plus.Communication.Packets.Outgoing.Notifications;using Plus.Communication.Packets.Outgoing.Rooms.Engine;namespace Plus.HabboHotel.Rooms.Chat.Commands.Moderator{&nbsp; &nbsp; class ViewPrivateMessageCommand : IChatCommand&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string PermissionRequired&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;command_view_pms&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string Parameters&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;%username%&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string Description&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;Lets you view recent PMs from and to a user.&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public void Exec(GameClients.GameClient Session, Rooms.Room Room, string[] Params)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Params.Length == 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendWhisper(&quot;Please enter the username of the user you wish to view private messages of.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GameClient TargetClient = PlusEnvironment.GetGame().GetClientManager().GetClientByUsername(Params[1]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (TargetClient == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendWhisper(&quot;An error occoured whilst finding that user, maybe they're not online.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (TargetClient.GetHabbo() == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendWhisper(&quot;An error occoured whilst finding that user, maybe they're not online.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; StringBuilder b = new StringBuilder();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b.Append(&quot;Private messages - &quot; + TargetClient.GetHabbo().Username + &quot;\n\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter db = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db.SetQuery(&quot;SELECT * FROM `chatlogs_console` WHERE `from_id` = @id OR `to_id` = @id ORDER BY id DESC LIMIT 100&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db.AddParameter(&quot;id&quot;, TargetClient.GetHabbo().Id);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db.RunQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataTable t = db.GetTable();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (DataRow r in t.Rows)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b.Append(UnixTimeStampToDateTime((double)PlusEnvironment.GetUnixTimestamp()) + &quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b.Append(getUsernameFromId(Convert.ToInt32(r[&quot;from_id&quot;])) + &quot; to &quot; + getUsernameFromId(Convert.ToInt32(r[&quot;to_id&quot;])) + &quot;: &quot; + Convert.ToString(r[&quot;message&quot;]) + &quot;\n\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendMessage(new MOTDNotificationComposer(b.ToString()));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private DateTime UnixTimeStampToDateTime(double unixTimeStamp)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Unix timestamp is seconds past epoch&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.DateTime dtDateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dtDateTime = dtDateTime.AddSeconds(unixTimeStamp).ToLocalTime();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return dtDateTime;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private string getUsernameFromId(int userId)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (PlusEnvironment.GetHabboById(userId) != null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return PlusEnvironment.GetHabboById(userId).Username;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter db = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db.SetQuery(&quot;SELECT `username` FROM `users` WHERE `id` = @id&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db.AddParameter(&quot;id&quot;, userId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db.RunQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return db.GetString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE][doublepost=1490012076,1490011784][/doublepost]thats for view pms command</blockquote>

[QUOTE="antiny2010, post: 404330, member: 54335"] [CODE]using System; using System.Linq; using System.Text; using System.Collections.Generic; using System.Data; using Plus.HabboHotel.GameClients; using Plus.HabboHotel.Rooms; using Plus.Communication.Packets.Outgoing.Users; using Plus.Communication.Packets.Outgoing.Rooms.Avatar; using System.Threading; using System.Threading.Tasks; using Plus.Communication.Packets.Outgoing.Rooms.Chat; using Plus.HabboHotel.Items; using Plus.HabboHotel.Catalog; using Plus.Communication.Packets.Outgoing.Inventory.Furni; using Plus.Database.Interfaces; using Plus.Communication.Packets.Outgoing.Notifications; using Plus.Communication.Packets.Outgoing.Rooms.Engine; namespace Plus.HabboHotel.Rooms.Chat.Commands.Moderator { class ViewPrivateMessageCommand : IChatCommand { public string PermissionRequired { get { return "command_view_pms"; } } public string Parameters { get { return "%username%"; } } public string Description { get { return "Lets you view recent PMs from and to a user."; } } public void Exec(GameClients.GameClient Session, Rooms.Room Room, string[] Params) { if (Params.Length == 1) { Session.SendWhisper("Please enter the username of the user you wish to view private messages of."); return; } GameClient TargetClient = PlusEnvironment.GetGame().GetClientManager().GetClientByUsername(Params[1]); if (TargetClient == null) { Session.SendWhisper("An error occoured whilst finding that user, maybe they're not online."); return; } if (TargetClient.GetHabbo() == null) { Session.SendWhisper("An error occoured whilst finding that user, maybe they're not online."); return; } StringBuilder b = new StringBuilder(); b.Append("Private messages - " + TargetClient.GetHabbo().Username + "\n\n"); using (IQueryAdapter db = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { db.SetQuery("SELECT * FROM `chatlogs_console` WHERE `from_id` = @id OR `to_id` = @id ORDER BY id DESC LIMIT 100"); db.AddParameter("id", TargetClient.GetHabbo().Id); db.RunQuery(); DataTable t = db.GetTable(); foreach (DataRow r in t.Rows) { b.Append(UnixTimeStampToDateTime((double)PlusEnvironment.GetUnixTimestamp()) + "\n"); b.Append(getUsernameFromId(Convert.ToInt32(r["from_id"])) + " to " + getUsernameFromId(Convert.ToInt32(r["to_id"])) + ": " + Convert.ToString(r["message"]) + "\n\n"); } } Session.SendMessage(new MOTDNotificationComposer(b.ToString())); } private DateTime UnixTimeStampToDateTime(double unixTimeStamp) { // Unix timestamp is seconds past epoch System.DateTime dtDateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc); dtDateTime = dtDateTime.AddSeconds(unixTimeStamp).ToLocalTime(); return dtDateTime; } private string getUsernameFromId(int userId) { if (PlusEnvironment.GetHabboById(userId) != null) return PlusEnvironment.GetHabboById(userId).Username; using (IQueryAdapter db = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { db.SetQuery("SELECT `username` FROM `users` WHERE `id` = @id"); db.AddParameter("id", userId); db.RunQuery(); return db.GetString(); } } } } [/CODE] [doublepost=1490012076,1490011784][/doublepost]thats for view pms command [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members