PlusEMU Support thread.

[Sledmore]

Hi,

Figured I'd finally offer some support, nothing too big just help with some errors all in one thread.

Fire away.

 

[Rain]

hello here's another fix,which makes it possible to send queries, drop tables and what not,this spotted by user
"

You must be registered for see links

" so credits to him on the rival forums for this fix.

1). HabboHotel\Items\Wired\Boxes\Effects\BotChangesClothesBox.cs
find

using (QueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `bots` SET `look` = '" + User.BotData.Look + "', `gender` = '" + User.BotData.Gender + "' WHERE `id` = '" + User.BotData.Id + "' LIMIT 1");
}

Replace:

using (QueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `bots` SET `look` = @look, `gender` = '" + User.BotData.Gender + "' WHERE `id` = '" + User.BotData.Id + "' LIMIT 1");
dbClient.AddParameter("look", User.BotData.Look);
dbClient.RunQuery();
}

And be sure to also find :

2). Communication\Packets\Incoming\Rooms\AI\Bots\SaveBotActionEvent.cs

Find:

using (QueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `bots` SET `look` = '" + Session.GetHabbo().Look + "', `gender` = '" + Session.GetHabbo().Gender + "' WHERE `id` = '" + Bot.BotData.Id + "' LIMIT 1");
}

Replace:

using (QueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `bots` SET `look` = @look, `gender` = '" + Session.GetHabbo().Gender + "' WHERE `id` = '" + Bot.BotData.Id + "' LIMIT 1");
dbClient.AddParameter("look", Session.GetHabbo().Look);
dbClient.RunQuery();
}

Wish i had this before last night ;/

 

[Sledmore]

Wish i had this before last night ;/

Daily back ups are a good thing.

 

[Rain]

Daily back ups are a good thing.

I auto-backup every 6 hours now..
 
Was a combination of all of my hotels got killed at once. I've lost over 100 users daily from peace turkey, over 30+ daily from peace eng, and almost all malaysians.. Just part of the game tho right?

 

[Joe]

I auto-backup every 6 hours now..
 
Was a combination of all of my hotels got killed at once. I've lost over 100 users daily from peace turkey, over 30+ daily from peace eng, and almost all malaysians.. Just part of the game tho right?

u wer getin 2 close they had 2 destroy u!

 

[Sledmore]

I auto-backup every 6 hours now..

Best thing to do. Funny thing is, I coded that myself without even realising.

I doubt there is much more surprises, the odd thing slips through especially when you no longer can find the motivation to code for such a rubbish cause.

Out of curiosity, any special techniques for your back ups? Mine run every 12 hour, but I find it hard to upload them automatically, as they're 45 GB+ each and constantly growing.

 

[Rain]

Best thing to do. Funny thing is, I coded that myself without even realising.

I doubt there is much more surprises, the odd thing slips through especially when you no longer can find the motivation to code for such a rubbish cause.

Out of curiosity, any special techniques for your back ups? Mine run every 12 hour, but I find it hard to upload them automatically, as they're 45 GB+ each and constantly growing.

I have a second server, a small 4GB dedi with 2TB storage, bought from here:

You must be registered for see links

I can help you put windows on it if you wish to use one.
I have a batch job in navicat which backs up DB every 6 hours. Although my db is just over 1gb

 

[Joe]

couldn't u compress them into a .psc or something a long those lines

 

[Rain]

couldn't u compress them into a .psc or something a long those lines

Maybe, but i've got 2tb, and a small database Nothin to worry abt

 

[Sledmore]

I have a second server, a small 4GB dedi with 2TB storage, bought from here:

You must be registered for see links

I can help you put windows on it if you wish to use one.
I have a batch job in navicat which backs up DB every 6 hours. Although my db is just over 1gb

My only problem is instantly transferring them.

I currently; cycle every 12 hours, truncate 4 tables (once a week, not each cycle) then back up, then finally archive it. Just not sure of a nice way to instantly send it over to another server. FTP is an option but I'm not sure.

Just basically want it all automated. As of now, I have to manually upload.

 

[Rain]

My only problem is instantly transferring them.

I currently; cycle every 12 hours, truncate 4 tables (once a week, not each cycle) then back up, then finally archive it. Just not sure of a nice way to instantly send it over to another server. FTP is an option but I'm not sure.

Just basically want it all automated. As of now, I have to manually upload.

The other server is connected to the main mysql server?
It just backs up every 6 hours, and i clear old backups every now and then

 

[Sledmore]

The other server is connected to the main mysql server?
It just backs up every 6 hours, and i clear old backups every now and then

Oh, I guess that's one solution.

 

[Hashh]

@Sledmore I try to click 'Create Room' nothing happens help

You must be registered for see links

 

[Alaska]

Anyone got any clue how to make any of the following work?
info_terminal -

wf_act_give_reward -

tile_fxprovider_nfs -

All would be super useful

 

[Its0llie]

Hey guys,
I hope you can help me with this one.

So I have a problem (obviously) and it happens to many of my users.
When you first log into the client, everything works fine. After about 10 mins of play, when you go into a different room, the furni are black boxes, avatars turn into ghosts and the catalog stops showing items. Once you reload the client, everything works again.
It seems like a session issue, but wanted to run it past you lovely people to see if you have any ideas.
I am currently running Sledmore's PlusEMU edit PRODUCTION-201601012205-226667486.

 

[Rain]

Hey guys,
I hope you can help me with this one.

So I have a problem (obviously) and it happens to many of my users.
When you first log into the client, everything works fine. After about 10 mins of play, when you go into a different room, the furni are black boxes, avatars turn into ghosts and the catalog stops showing items. Once you reload the client, everything works again.
It seems like a session issue, but wanted to run it past you lovely people to see if you have any ideas.
I am currently running Sledmore's PlusEMU edit PRODUCTION-201601012205-226667486.

Seems like an easy fix, change the challenge allowed time in cloudflare to 1 day (its 30 mins by default)

 

[mcmatters]

Anyone know how to set it so that rank 3 or above receive staff alerts and not rank 2, cant seem to find anything in database and StaffAlertCommand.cs

permissions databases

 

[ChrisRetro]

The emu doesnt allow more than 2 users on when i add the proxy help?

 

[nabbodayhotel]

Need help to make my sso safe noting works to fix

 

[AmineHR]

Hi guys how to activate forum? i'm start coded forums, but don't worked..

add on skype: exitsf2

 

[Brad]

The emu doesnt allow more than 2 users on when i add the proxy help?

go into the emulator config and change maxconperip to 500.