vS7NtZbG

1********Estos son los fix para plusEMu******8
21). HabboHotel\Items\Wired\Boxes\Effects\BotChangesClothesBox.cs
3
4Encuentra:
5using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
6{
7dbClient.RunQuery("UPDATE `bots` SET `look` = '" + User.BotData.Look + "', `gender` = '" + User.BotData.Gender + "' WHERE `id` = '" + User.BotData.Id + "' LIMIT 1");
8}
9
10Y coloca esto ahi:
11using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) {
12dbClient.SetQuery("UPDATE `bots` SET `look` = @look, `gender` = '" + User.BotData.Gender + "' WHERE `id` = '" + User.BotData.Id + "' LIMIT 1");
13dbClient.AddParameter("look", User.BotData.Look);
14dbClient.RunQuery();
15}
16
172). Communication\Packets\Incoming\Rooms\AI\Bots\SaveBotActionEvent.cs
18
19Encuentra:
20using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
21{
22dbClient.RunQuery("UPDATE `bots` SET `look` = '" + Session.GetHabbo().Look + "', `gender` = '" + Session.GetHabbo().Gender + "' WHERE `id` = '" + Bot.BotData.Id + "' LIMIT 1");
23}
24
25Y coloca esto:
26using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
27{
28dbClient.SetQuery("UPDATE `bots` SET `look` = @look, `gender` = '" + Session.GetHabbo().Gender + "' WHERE `id` = '" + Bot.BotData.Id + "' LIMIT 1");
29dbClient.AddParameter("look", Session.GetHabbo().Look);
30dbClient.RunQuery();
31}
32
333). Communication\Packets\Incoming\Rooms\Furni\Wired\SaveWiredConfigEvent.cs
34
35Encuentra:
36Room Room = Session.GetHabbo().CurrentRoom;
37if (Room == null)
38return;
39
40Y coloca:
41Room Room = Session.GetHabbo().CurrentRoom;
42if (Room == null)
43return;
44if (!Room.CheckRights(Session, false) && !Room.CheckRights(Session, true))
45return;
46
474). Communication\Packets\Incoming\Catalog\CheckGnomeNameEvent.cs (Thanks to @Damien Jolly & thanks to @Shorty for sending me)
48
49Encuentra:
50if (Item == null || Item.Data == null)
51return;
52
53Y coloca:
54if (Item == null || Item.Data == null || Item.UserID != Session.GetHabbo().Id || Item.Data.InteractionType != InteractionType.GNOME_BOX)
55return;
56
575). HabboHotel\Users\UserData\UserDataFactory.cs (Thanks to @Damien Jolly)
58
59Encuentra:
60dbClient.SetQuery("SELECT `id`,`username`,`rank`,`motto`,`look`,`gender`,`last_online`,`credits`,`activity_points`,`home_room`,`block_newfriends`,`hide_online`,`hide_inroom`,`vip`,`account_created`,`vip_points`,`machine_id`,`volume`,`chat_preference`,`focus_preference`, `pets_muted`,`bots_muted`,`advertising_report_blocked`,`last_change`,`gotw_points`,`ignore_invites`,`time_muted`,`allow_gifts`,`friend_bar_state`,`disable_forced_effects`,`allow_mimic`,`rank_vip` FROM `users` WHERE `auth_ticket` = @sso LIMIT 1");
61
62Y coloca:
63dbClient.SetQuery("SELECT users.id,users.username,users.rank,users.motto,users.look,users.gender,users.last_online,users.credits,users.activity_points,users.home_room,users.block_newfriends,users.hide_online,users.hide_inroom,users.vip,users.account_created,users.vip_points,users.machine_id,users.volume,users.chat_preference,users.focus_preference,users.pets_muted,users.bots_muted,users.advertising_report_blocked,users.last_change,users.gotw_points,users.ignore_invites,users.time_muted,users.allow_gifts,users.friend_bar_state,users.disable_forced_effects,users.allow_mimic,users.rank_vip " + 
64"FROM users " +
65"JOIN user_auth_ticket " +
66"ON users.id = user_auth_ticket.user_id " +
67"WHERE user_auth_ticket.auth_ticket = @sso " +
68"LIMIT 1");
69
706).
71Encuentra:
72dbClient.RunQuery("UPDATE `users` SET `online` = '1', `auth_ticket` = '' WHERE `id` = '" + UserId + "' LIMIT 1");
73
74
75y coloca:
76dbClient.RunQuery("UPDATE `users` SET `online` = '1' WHERE `id` = '" + UserId + "' LIMIT 1");
77dbClient.RunQuery("DELETE FROM `user_auth_ticket` WHERE `user_id` = '" + UserId + "' LIMIT 1");
78
797).
80PlusEnviroment.cs
81
82Encuentra:
83dbClient.RunQuery("UPDATE `users` SET online = '0', `auth_ticket` = NULL");
84
85y coloca:
86dbClient.RunQuery("TRUNCATE `user_auth_ticket`");
87dbClient.RunQuery("UPDATE `users` SET online = '0'");
88
898). Corre este sql query en tu database
90
91
92-- ----------------------------
93-- Table structure for `user_auth_ticket`
94-- ----------------------------
95DROP TABLE IF EXISTS `user_auth_ticket`;
96CREATE TABLE `user_auth_ticket` (
97`user_id` int(11) NOT NULL,
98`auth_ticket` varchar(60) NOT NULL,
99PRIMARY KEY (`user_id`)
100) ENGINE=InnoDB DEFAULT CHARSET=utf8;