Reply to thread

Message

<blockquote data-quote="Altercationz" data-source="post: 391585" data-attributes="member: 59038">I'm pretty sure he wants to be able to view the users online.Here's the command:[CODE]using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using Plus.Database.Interfaces;using System.Data;namespace Plus.HabboHotel.Rooms.Chat.Commands.User.Fun{&nbsp; &nbsp; class WhosOnlineCommand : IChatCommand&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string PermissionRequired&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;command_whosonline&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;&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;Displays the online users&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string Output = &quot;Current Users Online&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Output += &quot;-----------------------\r&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter Adapter = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.SetQuery(&quot;SELECT FROM users WHERE online = '1'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.RunQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataTable Table = Adapter.getTable();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Table != null)&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; Output += Row[&quot;username&quot;].ToString() + &quot;\r&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendNotification(Output);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE]</blockquote>

[QUOTE="Altercationz, post: 391585, member: 59038"] I'm pretty sure he wants to be able to view the users online. Here's the command: [CODE] using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Plus.Database.Interfaces; using System.Data; namespace Plus.HabboHotel.Rooms.Chat.Commands.User.Fun { class WhosOnlineCommand : IChatCommand { public string PermissionRequired { get { return "command_whosonline"; } } public string Parameters { get { return ""; } } public string Description { get { return "Displays the online users"; } } public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params) { string Output = "Current Users Online"; Output += "-----------------------\r"; using (IQueryAdapter Adapter = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { Adapter.SetQuery("SELECT FROM users WHERE online = '1'"); Adapter.RunQuery(); DataTable Table = Adapter.getTable(); if (Table != null) { foreach (DataRow Row in Table.Rows) { Output += Row["username"].ToString() + "\r"; } } Session.SendNotification(Output); } } } } [/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members