Setting Default HomeRoom!

[Benjames]

Hello! I'm looking to find out how to set a default homeroom for my Phoenix Retro. I made a little script to change everyones homeroom to a specific value but I want it to be default.

I'm unsure of how to do this in Navicat. (I know how to set default values in phpmyadmin)

Can someone tell me how to set a default value?

Thanks

Ben!

Also, Does anyone have the original UberCms Release?

 

[St4nley]

Run query

UPDATE `users` SET `home_room` = 'id'

change id to the room id

 

[Zymf]

UPDATE users SET home_room = 'ROOMID';

 

[Benjames]

Run query

UPDATE `users` SET `home_room` = 'id'

change id to the room id

UPDATE users SET home_room = 'ROOMID';

They're not default values though? For example, if a new user joins, he wont have that home room..

 

[St4nley]

As far as your question title goes "
Setting Default HomeRoom!"

our answers are correct, all of the detail you give doesnt really make sense, the answer we give you
is so when a user signs into the hotel loads the client they will be prompted to a homeroom (aka a welcome room)
and this will happen to every user that signs on unless the room id is changed.
as far as your detail i really don't understand what you would like. sorry if you could clarify i would gladly help.

 

[Kaz]

try - ALTER TABLE table_name SET DEFAULT room_id;

Think it will work, if not just google Mysql Alter Table or something similar

 

[Weasel]

Question has been awnsered, and also can be found in previous threads.

/thread