[BcStorm] White boxes, moodlights and mysqlerrors

[TheRook]

Well first of all: Im sorry if this have been posted before.

Now onto the bad stuff:
1. When we add customs to our hotel, it ends up being white boxes.

2. Users cannot place moodlights in rooms.. They could before we changed to Leenster's latest release of bcstorm.

3. We got an error in our errorlogs:

"Error in query:
UPDATE rooms SET caption = [URL='http://devbest.com/members/caption.12084/']Caption[/URL], description = @description, password = [URL='http://devbest.com/members/password.1306/']Password[/URL], category = 1, state = 'locked', tags = @tags, users_max = 50, allow_pets = 1, allow_pets_eat = 0, allow_walkthrough = 0, allow_hidewall = 0, floorthickness = 0, wallthickness = 0 WHERE id = 256
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'allow_pets_eat' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
  at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
  at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()

Any help would be greatly appreciated!

 

[Ghost]

You must be registered for see links

 

[sim0n]

You have to recode the sql codes for adding furniture to bcstorm. since they are completely different from phoenix.

 

[Nebula]

Just a simple fix for wall items.
There is an error in the Packet for handling wall items!

In incoming.cs
search for:

Code:
Incoming.HandleWallItem
Replace that with:

Code:
Incoming.HandleWallItem = 2622;
Wall items will now have their interaction states back!

 

[TheRook]

You have to recode the sql codes for adding furniture to bcstorm. since they are completely different from phoenix.

I use the Phoenix to BCStorm translater shit

Just a simple fix for wall items.
There is an error in the Packet for handling wall items!

In incoming.cs
search for:

Code:
Incoming.HandleWallItem
Replace that with:

Code:
Incoming.HandleWallItem = 2622;
Wall items will now have their interaction states back!

It still don't work.

 

[sim0n]

I use the Phoenix to BCStorm translater shit


It still don't work.

Placing items on the walls didn't work for me either, until I upgraded to Leensters edition. Now I got even more functions, like working bots and more!

 

[TheRook]

Placing items on the walls didn't work for me either, until I upgraded to Leensters edition. Now I got even more functions, like working bots and more!

Mind taking a look I'll pay you 5 dollars if you help me solving the furniture and moodlight shit. I'll PM you