[UBEREMU] Create room limit [UBEREMU]

Find:

Code:

---

private void CanCreateRoom()

---

Code:

---

int roomsamount;
            int roomslimit;
            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {

                roomsamount = dbClient.ReadInt32("SELECT COUNT(*) FROM rooms WHERE owner='" + Session.GetHabbo().Username + "'");
                roomslimit = dbClient.ReadInt32("SELECT value FROM config WHERE variable_name='user_maxrooms'");
            }
            if (roomsamount > roomslimit)
            {
                Session.SendNotif("You are not allowed to own more than " + roomslimit + " rooms.");
               

            }
            else

---

SQL:

Code:

---

CREATE TABLE `config` (
  `variable_name` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `config` VALUES ('user_max_rooms', '50');

---

You can edit user max rooms value.

Find:

Code:

---

        private void CanCreateRoom()
        {
            GetResponse().Init(512);
            GetResponse().AppendBoolean(false); // true = show error with number below
            GetResponse().AppendInt32(99999);
            SendResponse();

            // todo: room limit
        }

---

And replace with:

Code:

---

        private void CanCreateRoom()
        {

            GetResponse().Init(512);
            GetResponse().AppendBoolean(false); // true = show error with number below
            GetResponse().AppendInt32(99999);
            SendResponse();

            int RoomsLimit;
            int RoomsAmount;

            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                RoomsAmount = dbClient.ReadInt32("SELECT COUNT(*) FROM rooms WHERE owner='" + Session.GetHabbo().Username + "'");
                RoomsLimit = dbClient.ReadInt32("SELECT value FROM config WHERE variable_name='user_maxrooms'");
            }

            if (RoomsAmount > RoomsLimit)
            {
                Session.SendNotif("You are not allowed to own more than " + RoomsLimit + " rooms.");
            }
        }

---

Nice :) Great Work

Adding to spazzlake SVN

This is ok i guess 8/10

its pretty good 9/10 :D

Code:

---

        private void CanCreateRoom()
        {
            int MaxRooms = Convert.ToInt16(UberEnvironment.GetConfig().data["client.notifications.rooms.maxrooms"]);

            Response.Init(512);

            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                dbClient.AddParamWithValue("owner", Session.GetHabbo().Username);
                int roomcount = int.Parse(dbClient.ReadString("SELECT COUNT(*) FROM rooms WHERE owner = @owner;"));

                if (roomcount >= MaxRooms)
                    Response.AppendBoolean(true); // true = show error with number below
                else
                    Response.AppendBoolean(false);
            }

            Response.AppendInt32(MaxRooms);
            SendResponse();
        }

---

^_^

thanks i guess haha 9/10