Setting the homeroom

[Stevee]

Hi, I was wondering how to set the homeroom for everyone so like it will automatically make them go to a certain room like lets say the room ID was 10, so it'd make all the users go to that specific room.

 

[Sledmore]

Run this as a MySQL query:

UPDATE `users` SET `home_room` = '10';

Change 10 with the ID of the room. - Also, change the default value in the users table for new members.

 

[Legion]

If PHPMyAdmin, Go to your db > Users > Structure > home_room > edit > 10

 

[Stevee]

Run this as a MySQL query:

UPDATE `users` SET `home_room` = '10';

Change 10 with the ID of the room. - Also, change the default value in the users table for new members.

I thought that was the code thank you, and I was confused on how to do the second part if you could briefly explain what I should do to change the default value e_e sorry.

 

[Sledmore]

I thought that was the code thank you, and I was confused on how to do the second part if you could briefly explain what I should do to change the default value e_e sorry.

You using Navicat?

 

[Stevee]

You using Navicat?

Yes I am.

 

[Sledmore]

Yes I am.

Open your database, open the `users` table, hit `ctrl + d` on your keyboard find `home_room` change the `Default` at the bottom to the room ID.

 

[Stevee]

Open your database, open the `users` table, hit `ctrl + d` on your keyboard find `home_room` change the `Default` at the bottom to the room ID.

I get this big error when doing that.

You must be registered for see links

 

[Sledmore]

I get this big error when doing that.

You must be registered for see links

uhm, odd you sure you edited the right thing, or that error wasn't already there?

 

[Stevee]

uhm, odd you sure you edited the right thing, or that error wasn't already there?

I edited it like you told me too, go to users go to ctrl D fine home_rooms change default from 0 to 10 the ctrl S to save correct?

could it be because its an int instead of a varchar? 

You must be registered for see links

You must be registered for see links

screenie of the tables.