Welcome lobby via Navicat

[Jwake]

Uhh, Hello.
So, today I was wondering if someone could help me set a welcome lobby via navicat. I know how to do it in phpMyAdmin/Xampp but i've never really done it on Navicat. - I wanna do this to set a welcome lobby on my hotel.

 

[Occult]

You literally do the same thing on Navicat as you do for phpmyadmin, btw.

 

[Berk]

Just run this query,

UPDATE users SET home_room = 'ROOMID';

 

[Joe]

Just run this query,

UPDATE users SET home_room = 'ROOMID';

Also, remember to set the default home_room in the users table, so when people register it's automatically set to this figure.

 

[Jwake]

Also, remember to set the default home_room in the users table, so when people register it's automatically set to this figure.

What do you mean???

 

[Occult]

What do you mean???

UPDATE users SET home_room = 'ROOMID';
> This updates all existing users homeroom.

But you also need to set the default so that all future users who register have the desired homeroom.

ALTER TABLE users ADD CONSTRAINT DF_homeroom DEFAULT 'ROOMID' FOR home_room;
> This sets default for all future users.

(Replace 'ROOMID' with your desired room id).

 

[Jwake]

UPDATE users SET home_room = 'ROOMID';
> This updates all existing users homeroom.

But you also need to set the default so that all future users who register have the desired homeroom.

ALTER TABLE users ADD CONSTRAINT DF_homeroom DEFAULT 'ROOMID' FOR home_room;
> This sets default for all future users.

(Replace 'ROOMID' with your desired room id).

oo ok, thanks!