New command [UBEREMU] :givedrink and fix :online

[dimitri54480]

Hi,
I find a code in iEmulator by jmmc v2

Go to Misc/ChatCommandHandler.cs

before case "pickall":

ADD

case "givedrink":
                        if (Session.GetHabbo().HasFuse("fuse_admin"))
                        {
                            TargetRoom = UberEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
                            TargetClient = UberEnvironment.GetGame().GetClientManager().GetClientByHabbo(Params[1]);

                            if (TargetRoom == null)
                            {
                                return false;
                            }

                            TargetRoomUser = TargetRoom.GetRoomUserByHabbo(TargetClient.GetHabbo().Id);

                            if (TargetRoomUser == null)
                            {
                                return false;
                            }

                            try
                            {
                                TargetRoomUser.CarryItem(int.Parse(Params[2]));
                            }
                            catch (Exception) { }

                            return true;
                        }

                        return false;

Add command in allowedCommands +=

Fix Online

Find

case "online":

Replace function by

case "whoson":
                    case "whosonline":
                    case "online":
                        {
                            DataTable onlineData = new DataTable("online");
                            int count = onlineData.Columns.Count;
                            int Conter = UberEnvironment.GetGame().GetClientManager().ClientCount;
                            string message = "Utilisateurs connectés (" + Conter + "):\r";
                            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                            {
                                onlineData = dbClient.ReadDataTable("SELECT SQL_NO_CACHE username FROM users WHERE online = '1';");
                            }
                            foreach (DataRow user in onlineData.Rows)
                            {
                                message = message + user["username"] + "\r";
                            }
                            Session.SendNotif(message);
                            return true;
                        }

This code is extract to Iemulator by itachi v2.5.2

I have replace function

int Conter = onlineData.Rows.Count;

by

int Conter = UberEnvironment.GetGame().GetClientManager().ClientCount;

[MentaL]

[Muscab]

Most servers have these commands working already...

I'll give it a go later

[Richardjuhh]

I have it already, but nice for people who don't have....

[PEjump2]

Doing a query everytime the :whoson / :whosonline / :online command is requested? Ugh..

[FlyCoder]

Doing a query every time that command is used will use more SQL, 1/10.

[wichard]

/facepalm
cache it bro dont overload

[anthony93260]

Doing a query every time that command is used will use more SQL, 1/10.

Yeah... Dimitri, could you stop sharing useless things?