Set home_room command

[SlopeQ]

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 drag 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.
I am using RevCms with Plusemu.

Best Regards!

 

[HabboRetroHelper1]

Need a professional @Sledmore

 

[SlopeQ]

Need a professional @Sledmore

Yeah probably...

 

[iGlenn]

You must be registered for see links

 

[HabboRetroHelper1]

You must be registered for see links

Hes making a Command for it, please read it before post.

 

[iGlenn]

Hes making a Command for it, please read it before post.

You must be registered for see links

????????????

 

[SlopeQ]

You must be registered for see links

????????????

I know how to make commands. But somehow this does not work in any way like all other queries does.

 

[Damon]

I managed to fiddle around with what you wanted and succeeded.
What exactly was your problem? Was it chucking an error when debugging, or just not not updating when entering the command?

Anyways this is what I used:

           using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
            {

                dbClient.RunQuery("UPDATE `users` SET `home_room` = '29' WHERE `id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
            }
            StringBuilder HabboInfo = new StringBuilder();
            HabboInfo.Append("Your home room has successfully been updated");
            Session.SendNotification(HabboInfo.ToString());

Or you can check my whole class here:

You must be registered for see links

Hope this works and helps

 

[SlopeQ]

I managed to fiddle around with what you wanted and succeeded.
What exactly was your problem? Was it chucking an error when debugging, or just not not updating when entering the command?

Anyways

           using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
            {

                dbClient.RunQuery("UPDATE `users` SET `home_room` = '29' WHERE `id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
            }
            StringBuilder HabboInfo = new StringBuilder();
            HabboInfo.Append("Your home room has successfully been updated");
            Session.SendNotification(HabboInfo.ToString());

Or you can check my whole class here:

You must be registered for see links

Hope this works and helps

Hi, The error was it just wasn't updating. Trying this code now. Thanks alot!

 

[Damon]

Hi, The error was it just wasn't updating. Trying this code now. Thanks alot!

Oh well, hopefully after you use this it works. I ran it, and checked to make sure it worked and it did. So hopefully same result for yourself.

 

[SlopeQ]

Oh well, hopefully after you use this it works. I ran it, and checked to make sure it worked and it did. So hopefully same result for yourself.

Hi this did not work. I am trying to set the home_room on tha TargetUser and not the session. Maybe it's something wrong with that even though it should work?

 

[Damon]

Hi this did not work. I am trying to set the home_room on tha TargetUser and not the session. Maybe it's something wrong with that even though it should work?

Oh! My bad!

Do you want it like, :homeroom [username] ? Sorry if its not, Its 4am and pretty tired haha.
If so, this worked for me

           GameClient TargetClient = PlusEnvironment.GetGame().GetClientManager().GetClientByUsername(Params[1]);

            using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
            {
                dbClient.RunQuery("UPDATE `users` SET `home_room` = '30' WHERE `id` = '" + TargetClient.GetHabbo().Id + "' LIMIT 1");
            }
            StringBuilder HabboInfo = new StringBuilder();
            HabboInfo.Append(TargetClient.GetHabbo().Username + "'s home room has successfully been updated");
            Session.SendNotification(HabboInfo.ToString());

or full:

You must be registered for see links

 

[SlopeQ]

Oh! My bad!

Do you want it like, :homeroom [username] ? Sorry if its not, Its 4am and pretty tired haha.
If so, this worked for me

           GameClient TargetClient = PlusEnvironment.GetGame().GetClientManager().GetClientByUsername(Params[1]);

            using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
            {
                dbClient.RunQuery("UPDATE `users` SET `home_room` = '30' WHERE `id` = '" + TargetClient.GetHabbo().Id + "' LIMIT 1");
            }
            StringBuilder HabboInfo = new StringBuilder();
            HabboInfo.Append(TargetClient.GetHabbo().Username + "'s home room has successfully been updated");
            Session.SendNotification(HabboInfo.ToString());

or full:

You must be registered for see links

does not work, for me. Very strange. Can I hit you up on skype or something and share my code. I don't want to share it here as this "full" class is a very big thing

 

[Damon]

does not work, for me. Very strange. Can I hit you up on skype or something and share my code. I don't want to share it here as this "full" class is a very big thing

Sure, I've pm'd you my Skype