Set home_room command

[xDotcom]

Hello I am trying to make a command to set the home_room but somehow it does not work. This is the current code and I've tried so MANY combinations of it that I would love to rip my hair of... LoL

This is the current code:
dbClient.RunQuery("UPDATE users SET home_room = '29' WHERE id='" + TargetClient.GetHabbo().Id + "' LIMIT 1");

But that won't update the home_room. I am using the exact same syntax for other commands that uses the database this way and they work. Assuming this is something with the home_room column. Does not work even if you restart the emulator.
I am using RevCms with Plusemu.

Best Regards!

[MentaL]

[Articuz]

Use this in client if you want people to get automatic "home_room" when they login into the client!

<?php $query = mysql_query("UPDATE users SET home_room = 'room_id' "); ?>

[xDotcom]

Use this in client if you want people to get automatic "home_room" when they login into the client!

<?php $query = mysql_query("UPDATE users SET home_room = 'room_id' "); ?>

Hi I've sent you a PM for futher explanation about how I shall use this query