Moving from Phoenix to BcStorm -> table 'items'

[ProducerMark]

Hi,,

I have a hotel that runs on Phoenix, but I might move to BcStorm/SwiftEmu or whatever R63B Emulator.
I can convert the database to the new tables, sure, but there's one thing I can't fix:
How do I convert the table 'items' to the new table, especially the change with the columns: X, Y, and Z.
I can't afford losing all the rooms and furniture positions.

How do I convert these, and how is the new format?
(for example: the new (bcstorm) x = x.y from the old database (phoenix).
I'm struggling with this, and appreciate help.

Thank you,

[MentaL]

[superjason]

http://forum.ragezone.com/f353/conve...5/#post7496197

[ProducerMark]

Hi, thanks for your response, I'm currently working on it, and I came across a problem:
When I convert my old furniture table to items_base, I tried these things:
- Running the emu -> freezes on loading items
- Setting the item_id INT(11) to SmallInt (6) (same as the database the emu provided) -> Error duplicate entry
- Just to try if INT(11) is making the problem, I deleted all rows but 100, so I could change to Smallint, and started the emu.
- It started perfectly, so the INT is making trouble, the EMU only tries to read INT and not the Smallint.

Someone please help, I can't afford losing all furni, or making a reset.

Edit:
I found out that it won't load if the Item_id >= 65536.
I changed UInt(16 to UInt(32 but I don't see any difference, It still freezes like it did first.

If I press a key/enter I get this:
http://prntscr.com/1nb2k5

What I've tried:

go to HabboHotel > Items > ItemManager and find
Code:
uint id = Convert.ToUInt16(row[0]);
and change it to
Code:
uint id = Convert.ToUInt32(row[0]);

Also Edit

Go to butterfly/habbohotel/items/catalogs/catalogitems.cs
Edit from:
this.Items.Add((uint) int.Parse(this.ItemIdString));
To:
this.Items.Add((uint) uint.Parse(this.ItemIdString));

Debugged it with the green square, and I don't see any difference.
Still need help with this ..

[Superfun]

Change the int(11) to a higher value, revert any (other) stupid changes you did there. No need to change to a 32 bit int