[BANZAI] Esphere Banzai reload the tile Colors. 90%

[Elienay]

ADD THIS TO YOUR DB AT ROOM_ITEMS:

ALTER TABLE  `room_items` ADD  `bb_apparatus_state` INT( 255 ) NOT NULL DEFAULT  '0'

AND THIS CODE AT ROOM.CS IN YOUR SERVER..

if (Item.GetBaseItem().InteractionType.ToLower() == "bb_apparatus")
                    using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                    {
                        string color = dbClient.ReadString("SELECT bb_ball FROM `users` WHERE id='" + User.HabboId + "'");
                        int state;
                        string ColorBase = "";

                        state = dbClient.ReadInt32("SELECT bb_apparatus_state FROM `room_items` WHERE id = '" + Item.Id + "' LIMIT 1");
                        {
                            if (state == 1)
                            {

                                ColorBase = "0";
                                dbClient.ExecuteQuery("UPDATE `room_items` SET bb_state = '0'");
                            }
                            else if (state == 2)
                            {

                                ColorBase = "0";
                                dbClient.ExecuteQuery("UPDATE `room_items` SET bb_state = '0'");
                            }
                            else if (state == 3)
                            {

                                ColorBase = "0";
                                dbClient.ExecuteQuery("UPDATE `room_items` SET bb_state = '0'");
                            }
                            else if (state == 4)
                            {

                                ColorBase = "0";
                                dbClient.ExecuteQuery("UPDATE `room_items` SET bb_state = '0'");
                            }

                            ServerMessage Baldosa = new ServerMessage(88);
                            Baldosa.AppendStringWithBreak(Item.Id.ToString());
                            Baldosa.AppendStringWithBreak(ColorBase);
                            SendMessage(Baldosa);
                            Item.UPDATEState(true, true);
                        }
                    }

AND THEN ADD THE INTERACTION BB_APPARATUS AT THE FURNITURE.

MATTERS:

- THE COLOR JUST RELOAD IF YOU WALK ON THE TILE.
- THE TILE IN ALL ROOMS OF DB, RELOAD.



LOOK, BB_APPARATUS:

SO, CREDITS FOR ME (NAY)
I'M BRAZILLIAN, THANKS .

 

[Zak©]

Nice ;]

 

[Maintenance]

Ill test this right now
Thx

 

[Elienay]

=)
Works perfectly .

 

[No0b]

Works like a charm thanks.

 

[Adde]

welldone.