[FIX][Uber] Room loading error

[flx5]

Hey, I have seen, that sometimes after changeing the Furnidata.txt and using an Script for correct the Id's, sometimes there are Roomloading errors.
I made an fix for this Issue.

Open RoomItems.cs and find public RoomItem
Replace the following code

public RoomItem(uint Id, uint RoomId, uint BaseItem, string ExtraData, int X, int Y, Double Z, int Rot, string WallPos)
        {
            this.Id = Id;
            this.RoomId = RoomId;
            this.BaseItem = BaseItem;
            this.ExtraData = ExtraData;
            this.X = X;
            this.Y = Y;
            this.Z = Z;
            this.Rot = Rot;
            this.WallPos = WallPos;
            this.UpdateNeeded = false;
            this.UpdateCounter = 0;
            this.InteractingUser = 0;
            this.InteractingUser2 = 0;

            switch (GetBaseItem().InteractionType.ToLower())
            {
                case "teleport":

                    ReqUpdate(0);

                    break;
            }
        }

with this

public RoomItem(uint Id, uint RoomId, uint BaseItem, string ExtraData, int X, int Y, Double Z, int Rot, string WallPos)
        {

            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                int count = dbClient.ReadInt32("SELECT COUNT(id) as count FROM furniture WHERE id = " + BaseItem + "");

                if (count == 0)
                {
                    dbClient.ExecuteQuery("DELETE FROM room_items WHERE base_item = " + BaseItem + "");
                }
                else
                {

                    this.Id = Id;
                    this.RoomId = RoomId;
                    this.BaseItem = BaseItem;
                    this.ExtraData = ExtraData;
                    this.X = X;
                    this.Y = Y;
                    this.Z = Z;
                    this.Rot = Rot;
                    this.WallPos = WallPos;
                    this.UpdateNeeded = false;
                    this.UpdateCounter = 0;
                    this.InteractingUser = 0;
                    this.InteractingUser2 = 0;

                    switch (GetBaseItem().InteractionType.ToLower())
                    {
                        case "teleport":

                            ReqUpdate(0);

                            break;
                    }
                }
            }

        }

I think it's not the best Fix, but it's a fix
I have testet it and I was first kicked out of the Hotel, but when I loadet the Room an second time, it worked perfectly...
So it seems, that you are going to get kicked out of the hotel, but after this it will work ;)

This was testet with BubbaEmulator by PinkFruit & Technik.Freak.
I don't know if it will work with other Emus...

[MentaL]

[Livar]

Nice release.

[Mikehunt]

Does this delete the items from a room if it gives an error?

[flx5]

Yes because it was unable to find the furniture in the furniture Table.

[DarkBreakX]

flx5 That's gay! Please code the Code better xD

German: Wieso so gay? Verbesser den Code! Weil wenn es errors gibt sollte ned jeder Raum gelöscht werden bzw. geleert!

[toperwin]

Sow, actually it's a fix for peeps who have a uncomplete sql database from nasty friends?

btw, thanks ;) It is a fix ;p maybe not verry usefull for much persons, but it is a fix and it still works ;)

[flx5]

Only the Bugfull furni will be deleted...
This happens when some people update their Furnidata.txt, so maybe I'll find a posibility to set the base_id correct.

I am going to make it better ;)

But it's a start

[DarkBreakX]

You mean the catalogfix? Already released and works perfectly...

-Slaxxer

[flx5]

I know but I got the Problem after using it...

[seanrom]

its more and help or short tutorial but thanks for share with us!

[zakite0]

Gracias me funciono muy bien :D hablo español lo siento si no me entienden de todos modos

gracias¡¡¡

in english xD

Thank You¡¡

[HFpr0ducti0ns]

i have that problem with my emulator + cms

[flx5]

I want to help you, but I can't see anything on the image...

[HFpr0ducti0ns]

please send a private message to me with your skype or msn :D