How do I set home room for every user?

[Ch0wd3r]

I'm using Butterfly emulator leenster edition, r63b and I want to make a start room for every user.
But how do I do that?

 

[GodFather]

Try this Mysql query UPDATE users SET home_room = 'THEROOMIDHERE'

 

[Ch0wd3r]

I tried that SQL but it didn't work.

 

[KyleVonnie]

I tried that SQL but it didn't work.

That SQL should work, which error are you getting?

 

[Ch0wd3r]

Well the rooms are setted as home room but when I open client it won't go directly to that room.

 

[KyleVonnie]

Well the rooms are setted as home room but when I open client it won't go directly to that room.

Try restarting EMU, and clearing cache.

 

[Ch0wd3r]

It didn't work just tried it.

 

[KyleVonnie]

It didn't work just tried it.

Erm, try using some :update_ commands, I dont exactly remember which ones there are,

 

[Ch0wd3r]

Don't know what you mean, there is no command called ":update_commands"

 

[KyleVonnie]

Don't know what you mean, there is no command called ":update_commands"

No I mean using the ":update_" commands, There are a few of those, I just forgot what they were.

 

[Noman]

On R63B the default home room doesn't take you straight to the room like R63 retros, it's different.

Click that, it'll take you to your default homeroom.

Alternatively If the query that GodFather posted earlier, try this method below;
If you have Navicat installed, go into your database and then click the 'Users' table, once clicked simply right click and 'Design Table'.

Once you've done that, this should popup;

Scroll down abit until you see 'home_room' As soon as you see it, click it and then you should see this option popup the 'Default:' and 'Comment:' the main part you'll need to edit is the 'Default:' the Default for my hotel is 295 meaning that the default room (Room ID) is 295, However you can set your default room ID to your specified choice just make sure it matches with the current room you're in and that the Room ID is corrected. New users that register will automatically have a homeroom, all they have to click on is the 'Go to my home room' button on the client located at the left hand top corner.

 

[Ch0wd3r]

Oh dammit, but thanks for posting the fix.

 

[Creation]

On R63B the default home room doesn't take you straight to the room like R63 retros, it's different.

Click that, it'll take you to your default homeroom.

Alternatively If the query that GodFather posted earlier, try this method below;
If you have Navicat installed, go into your database and then click the 'Users' table, once clicked simply right click and 'Design Table'.

Once you've done that, this should popup;

Scroll down abit until you see 'home_room' As soon as you see it, click it and then you should see this option popup the 'Default:' and 'Comment:' the main part you'll need to edit is the 'Default:' the Default for my hotel is 295 meaning that the default room (Room ID) is 295, However you can set your default room ID to your specified choice just make sure it matches with the current room you're in and that the Room ID is corrected. New users that register will automatically have a homeroom, all they have to click on is the 'Go to my home room' button on the client located at the left hand top corner.

It does. Try looking at HabJam and Eubbo. (;