Setting a homeroom for new users

[FrostBiteRetros]

This is simple to do. go to localhost/phpmyadmin , login, open the database, then go to the users tab.
go to structure, then find home_room

Go into the client, go into the room you want to be homeroom, then press room info. down the bottom it gives a link with a link that would take you straight to that room.
example :

You must be registered for see links

where it says /room/8 is where you want to look at. 8 would be the id of the room.
so go back to the database, and in the home_room line, click the change button. Now change the ''Default'' to the room id (mine would be 8).
then click away and it will save. now clear cache, restart the emu and reload client, and you will spawn there! (unless youve already set a spawn point for yourself).

 

[Zymf]

Or run this as a query...
For all users once they register:

ALTER TABLE `users`
MODIFY COLUMN `home_room`  int(10) UNSIGNED NOT NULL DEFAULT 'roomid';

For users already registered:

UPDATE users SET home_room = 'room_id'

 

[Nerfed]

Thanks, great tutorial, I'm sure this would help many people.
To make it better and more noob friendly, you should make your steps neater and possibly with images. Right now it's a jumble of sentences only separated by commas and full stops.

 

[Jerry]

This is a simple tut, Thanks!