public static string GetUsernameById(int UserId)
{
string Name = "Unknown User";
GameClient Client = GetGame().GetClientManager().GetClientByUserID(UserId);
if (Client != null && Client.GetHabbo() != null)
{
return(Client.GetHabbo().Username);
}
UserCache User = PlusEnvironment.GetGame().GetCacheManager().GenerateUser(UserId);
if (User != null)
{
return(User.Username);
}
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `username` FROM `users` WHERE `id` = @id LIMIT 1");
dbClient.AddParameter("id", UserId);
Name = dbClient.GetString();
}
if (string.IsNullOrEmpty(Name))
{
Name = "Unknown User";
}
return(Name);
}
public void Execute(GameClient Session, Room Room, RoomUser UserRoom, string[] Params)
{
if (Params.Length > 1 && Session.GetHabbo().HasFuse("fuse_sysadmin"))
{
GameClient clientByUsername = ButterflyEnvironment.GetGame().GetClientManager().GetClientByUsername(Params[1]);
if (clientByUsername != null)
{
clientByUsername.GetHabbo().GetInventoryComponent().ClearItems();
Session.SendNotification(ButterflyEnvironment.GetLanguageManager().TryGetValue("empty.dbcleared", Session.Langue));
}
else
{
using (IQueryAdapter queryreactor = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor())
{
queryreactor.SetQuery("SELECT id FROM users WHERE username = @usrname");
queryreactor.AddParameter("usrname", Params[1]);
int num = int.Parse(queryreactor.GetString());
queryreactor.RunQuery("DELETE items, items_limited, user_presents, room_items_moodlight, tele_links, wired_items FROM items LEFT JOIN items_limited ON (items_limited.item_id = items.id) LEFT JOIN user_presents ON (user_presents.item_id = items.id) LEFT JOIN room_items_moodlight ON (room_items_moodlight.item_id = items.id) LEFT JOIN tele_links ON (tele_one_id = items.id) LEFT JOIN wired_items ON (trigger_id = items.id) WHERE user_id = " + num + " AND room_id = '0'");
Session.SendNotification(ButterflyEnvironment.GetLanguageManager().TryGetValue("empty.cachecleared", Session.Langue));
}
}
}
else
{
Session.GetHabbo().GetInventoryComponent().ClearItems();
Session.SendNotification(ButterflyEnvironment.GetLanguageManager().TryGetValue("empty.cleared", Session.Langue));
}
}
/// <summary>
/// Gets the message count for thread.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns>System.Int32.</returns>
internal int GetMessageCountForThread(uint id)
{
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery($"SELECT COUNT(*) FROM groups_forums_posts WHERE parent_id='{id}'");
return(int.Parse(queryReactor.GetString()));
}
}
public string GetNameById(int Id)
{
GameClient clientByUserId = this.GetClientByUserID(Id);
if (clientByUserId != null)
{
return(clientByUserId.GetHabbo().Username);
}
using (IQueryAdapter queryreactor = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor())
{
queryreactor.SetQuery("SELECT username FROM users WHERE id = " + Id);
return(queryreactor.GetString());
}
}
public void Execute(GameClient Session, Room Room, RoomUser UserRoom, string[] Params)
{
if (UserRoom.team != Team.none || UserRoom.InGame)
{
return;
}
//GameClient Client = ButterflyEnvironment.GetGame().GetClientManager().GetRandomClient();
//if (Client == null || Client.GetHabbo() == null)
//return;
if (Session == null || Session.GetHabbo() == null)
{
return;
}
using (IQueryAdapter queryreactor = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor())
{
queryreactor.SetQuery("SELECT look FROM user_wardrobe WHERE user_id IN (SELECT user_id FROM (SELECT user_id FROM user_wardrobe WHERE user_id >= ROUND(RAND() * (SELECT max(user_id) FROM user_wardrobe)) LIMIT 1) tmp) ORDER BY RAND() LIMIT 1");
Session.GetHabbo().Look = queryreactor.GetString();
}
if (UserRoom.transformation || UserRoom.IsSpectator)
{
return;
}
if (!Session.GetHabbo().InRoom)
{
return;
}
Room currentRoom = Session.GetHabbo().CurrentRoom;
if (currentRoom == null)
{
return;
}
RoomUser roomUserByHabbo = UserRoom;
if (roomUserByHabbo == null)
{
return;
}
Session.SendPacket(new UserChangeComposer(roomUserByHabbo, true));
currentRoom.SendPacket(new UserChangeComposer(roomUserByHabbo, false));
}
/// <summary>
/// Gets the hopper identifier.
/// </summary>
/// <param name="nextRoom">The next room.</param>
/// <returns>System.UInt32.</returns>
internal static uint GetHopperId(uint nextRoom)
{
uint result;
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery("SELECT hopper_id FROM items_hopper WHERE room_id = @room LIMIT 1");
queryReactor.AddParameter("room", nextRoom);
string theString = queryReactor.GetString();
result = theString == null ? 0u : Convert.ToUInt32(theString);
}
return(result);
}
public static int GetHopperId(int NextRoom)
{
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT hopper_id FROM items_hopper WHERE room_id = @room LIMIT 1");
dbClient.AddParameter("room", NextRoom);
string Row = dbClient.GetString();
if (Row == null)
{
return(0);
}
return(Convert.ToInt32(Row));
}
}
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.SetQuery("SELECT trigger_data FROM wired_items WHERE trigger_id = @id ");
dbClient.AddParameter("id", this.item.Id);
string message = dbClient.GetString();
if (message.Contains(":"))
{
this.Effet = message.Split(new char[] { ':' })[0].ToLower();
this.Value = message.Split(new char[] { ':' })[1];
}
else
{
this.Effet = message.ToLower();
}
}
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.SetQuery("SELECT trigger_data FROM wired_items WHERE trigger_id = @id ");
dbClient.AddParameter("id", this.itemID);
string Data = dbClient.GetString();
if (string.IsNullOrWhiteSpace(Data) || !Data.Contains("\t"))
{
return;
}
string[] SplitData = Data.Split('\t');
this.NameBot = SplitData[0].ToString();
this.Look = SplitData[1].ToString();
}
public bool TryExecute(string[] parameters)
{
int userId = 0;
if (!int.TryParse(parameters[0].ToString(), out userId))
{
return(false);
}
GameClient client = PlusEnvironment.GetGame().GetClientManager().GetClientByUserID(userId);
if (client == null || client.GetHabbo() == null)
{
return(false);
}
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `motto` FROM `users` WHERE `id` = @userID LIMIT 1");
dbClient.AddParameter("userID", userId);
client.GetHabbo().Motto = dbClient.GetString();
}
// If we're in a room, we cannot really send the packets, so flag this as completed successfully, since we already updated it.
if (!client.GetHabbo().InRoom)
{
return(true);
}
else
{
//We are in a room, let's try to run the packets.
Room Room = client.GetHabbo().CurrentRoom;
if (Room != null)
{
RoomUser User = Room.GetRoomUserManager().GetRoomUserByHabbo(client.GetHabbo().Id);
if (User != null)
{
Room.SendPacket(new UserChangeComposer(User, false));
return(true);
}
}
}
return(false);
}
public string GetNameById(int id)
{
GameClient client = GetClientByUserId(id);
if (client != null)
{
return(client.Habbo.Username);
}
string username;
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT username FROM users WHERE id = @id LIMIT 1");
dbClient.AddParameter("id", id);
username = dbClient.GetString();
}
return(username);
}
/// <summary>
/// Gets the name by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns>System.String.</returns>
internal string GetNameById(uint id)
{
GameClient clientByUserId = GetClientByUserId(id);
if (clientByUserId != null)
{
return(clientByUserId.GetHabbo().UserName);
}
string userName;
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery("SELECT username FROM users WHERE id = " + id);
userName = queryReactor.GetString();
}
return(string.IsNullOrEmpty(userName) ? "Unknown User" : userName);
}
/// <summary>
/// Fills the specified row.
/// </summary>
/// <param name="row">The row.</param>
internal void Fill(DataRow row)
{
try
{
Id = (uint)row["id"];
Name = (string)row["caption"];
PassWord = (string)row["password"];
Description = (string)row["description"];
Type = (string)row["roomtype"];
Owner = string.Empty;
OwnerId = (uint)row["owner"];
RoomChat = new ConcurrentStack <Chatlog>();
WordFilter = new List <string>();
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery("SELECT username FROM users WHERE id = @userId");
queryReactor.AddParameter("userId", OwnerId);
Owner = queryReactor.GetString();
queryReactor.SetQuery($"SELECT user_id, message, timestamp FROM users_chatlogs WHERE room_id = '{Id}' ORDER BY timestamp ASC LIMIT 150");
DataTable table = queryReactor.GetTable();
foreach (DataRow dataRow in table.Rows)
{
RoomChat.Push(new Chatlog((uint)dataRow[0], (string)dataRow[1], Yupi.UnixToDateTime(int.Parse(dataRow[2].ToString())), false));
}
queryReactor.SetQuery($"SELECT word FROM rooms_wordfilter WHERE room_id = '{Id}'");
DataTable tableFilter = queryReactor.GetTable();
foreach (DataRow dataRow in tableFilter.Rows)
{
WordFilter.Add(dataRow["word"].ToString());
}
}
string roomState = row["state"].ToString().ToLower();
switch (roomState)
{
case "locked":
State = 1;
break;
case "password":
State = 2;
break;
default:
State = 0;
break;
}
ModelName = (string)row["model_name"];
WallPaper = (string)row["wallpaper"];
Floor = (string)row["floor"];
LandScape = (string)row["landscape"];
CcTs = (string)row["public_ccts"];
int.TryParse(row["trade_state"].ToString(), out TradeState);
int.TryParse(row["category"].ToString(), out Category);
int.TryParse(row["walls_height"].ToString(), out WallHeight);
int.TryParse(row["score"].ToString(), out Score);
int.TryParse(row["floorthick"].ToString(), out FloorThickness);
int.TryParse(row["wallthick"].ToString(), out WallThickness);
int.TryParse(row["chat_type"].ToString(), out ChatType);
int.TryParse(row["game_id"].ToString(), out GameId);
int.TryParse(row["mute_settings"].ToString(), out WhoCanMute);
int.TryParse(row["kick_settings"].ToString(), out WhoCanKick);
int.TryParse(row["ban_settings"].ToString(), out WhoCanBan);
uint.TryParse(row["users_now"].ToString(), out UsersNow);
uint.TryParse(row["users_max"].ToString(), out UsersMax);
uint.TryParse(row["group_id"].ToString(), out GroupId);
uint.TryParse(row["chat_balloon"].ToString(), out ChatBalloon);
uint.TryParse(row["chat_speed"].ToString(), out ChatSpeed);
uint.TryParse(row["chat_max_distance"].ToString(), out ChatMaxDistance);
uint.TryParse(row["chat_flood_protection"].ToString(), out ChatFloodProtection);
AllowPets = Yupi.EnumToBool(row["allow_pets"].ToString());
AllowPetsEating = Yupi.EnumToBool(row["allow_pets_eat"].ToString());
AllowWalkThrough = Yupi.EnumToBool(row["allow_walkthrough"].ToString());
HideWall = Yupi.EnumToBool(row["hidewall"].ToString());
AllowRightsOverride = false;
Group = Yupi.GetGame().GetGroupManager().GetGroup(GroupId);
Event = Yupi.GetGame().GetRoomEvents().GetEvent(Id);
_model = Yupi.GetGame().GetRoomManager().GetModel(ModelName, Id);
CompetitionStatus = 0;
Tags = new List <string>();
if (row.IsNull("tags") || string.IsNullOrEmpty(row["tags"].ToString()))
{
return;
}
foreach (string item in row["tags"].ToString().Split(','))
{
Tags.Add(item);
}
}
catch (Exception ex)
{
ServerLogManager.LogException("Exception on RoomData Loading (Fill Void): " + ex);
ServerLogManager.HandleException(ex, "Yupi.HabboHotel.Rooms.RoomData");
}
}
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.SetQuery("SELECT trigger_data FROM wired_items WHERE trigger_id = @id ");
dbClient.AddParameter("id", this.itemID);
this.message = dbClient.GetString();
}
/// <summary>
/// Tries the login.
/// </summary>
/// <param name="authTicket">The authentication ticket.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
internal bool TryLogin(string authTicket)
{
try
{
string ip = GetConnection().GetIp();
uint errorCode;
UserData userData = UserDataFactory.GetUserData(authTicket, out errorCode);
if (errorCode == 1 || errorCode == 2)
{
return(false);
}
Yupi.GetGame().GetClientManager().RegisterClient(this, userData.UserId, userData.User.UserName);
_habbo = userData.User;
userData.User.LoadData(userData);
string banReason = Yupi.GetGame().GetBanManager().GetBanReason(userData.User.UserName, ip, MachineId);
if (!string.IsNullOrEmpty(banReason) || userData.User.UserName == null)
{
SendNotifWithScroll(banReason);
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery($"SELECT ip_last FROM users WHERE id={GetHabbo().Id} LIMIT 1");
string supaString = queryReactor.GetString();
queryReactor.SetQuery($"SELECT COUNT(0) FROM users_bans_access WHERE user_id={_habbo.Id} LIMIT 1");
int integer = queryReactor.GetInteger();
if (integer > 0)
{
queryReactor.RunFastQuery("UPDATE users_bans_access SET attempts = attempts + 1, ip='" + supaString + "' WHERE user_id=" + GetHabbo().Id + " LIMIT 1");
}
else
{
queryReactor.RunFastQuery("INSERT INTO users_bans_access (user_id, ip) VALUES (" + GetHabbo().Id + ", '" + supaString + "')");
}
}
return(false);
}
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
queryReactor.RunFastQuery($"UPDATE users SET ip_last='{ip}' WHERE id={GetHabbo().Id}");
userData.User.Init(this, userData);
QueuedServerMessage queuedServerMessage = new QueuedServerMessage(_connection);
ServerMessage serverMessage = new ServerMessage(LibraryParser.OutgoingRequest("UniqueMachineIDMessageComposer"));
serverMessage.AppendString(MachineId);
queuedServerMessage.AppendResponse(serverMessage);
queuedServerMessage.AppendResponse(new ServerMessage(LibraryParser.OutgoingRequest("AuthenticationOKMessageComposer")));
ServerMessage serverMessage2 = new ServerMessage(LibraryParser.OutgoingRequest("HomeRoomMessageComposer"));
serverMessage2.AppendInteger(_habbo.HomeRoom);
serverMessage2.AppendInteger(_habbo.HomeRoom);
queuedServerMessage.AppendResponse(serverMessage2);
serverMessage = new ServerMessage(LibraryParser.OutgoingRequest("MinimailCountMessageComposer"));
serverMessage.AppendInteger(_habbo.MinimailUnreadMessages);
queuedServerMessage.AppendResponse(serverMessage);
serverMessage = new ServerMessage(LibraryParser.OutgoingRequest("FavouriteRoomsMessageComposer"));
serverMessage.AppendInteger(30);
if (userData.User.FavoriteRooms == null || !userData.User.FavoriteRooms.Any())
{
serverMessage.AppendInteger(0);
}
else
{
serverMessage.AppendInteger(userData.User.FavoriteRooms.Count);
foreach (uint i in userData.User.FavoriteRooms)
{
serverMessage.AppendInteger(i);
}
}
queuedServerMessage.AppendResponse(serverMessage);
ServerMessage rightsMessage = new ServerMessage(LibraryParser.OutgoingRequest("UserClubRightsMessageComposer"));
rightsMessage.AppendInteger(userData.User.GetSubscriptionManager().HasSubscription ? 2 : 0);
rightsMessage.AppendInteger(userData.User.Rank);
rightsMessage.AppendInteger(0);
queuedServerMessage.AppendResponse(rightsMessage);
serverMessage = new ServerMessage(LibraryParser.OutgoingRequest("EnableNotificationsMessageComposer"));
serverMessage.AppendBool(true); //isOpen
serverMessage.AppendBool(false);
queuedServerMessage.AppendResponse(serverMessage);
serverMessage = new ServerMessage(LibraryParser.OutgoingRequest("EnableTradingMessageComposer"));
serverMessage.AppendBool(true);
queuedServerMessage.AppendResponse(serverMessage);
userData.User.UpdateCreditsBalance();
serverMessage = new ServerMessage(LibraryParser.OutgoingRequest("ActivityPointsMessageComposer"));
serverMessage.AppendInteger(2);
serverMessage.AppendInteger(0);
serverMessage.AppendInteger(userData.User.ActivityPoints);
serverMessage.AppendInteger(5);
serverMessage.AppendInteger(userData.User.Diamonds);
queuedServerMessage.AppendResponse(serverMessage);
if (userData.User.HasFuse("fuse_mod"))
{
queuedServerMessage.AppendResponse(Yupi.GetGame().GetModerationTool().SerializeTool(this));
}
queuedServerMessage.AppendResponse(Yupi.GetGame().GetAchievementManager().AchievementDataCached);
if (!GetHabbo().NuxPassed&& ServerExtraSettings.NewUsersGiftsEnabled)
{
queuedServerMessage.AppendResponse(new ServerMessage(LibraryParser.OutgoingRequest("NuxSuggestFreeGiftsMessageComposer")));
}
queuedServerMessage.AppendResponse(GetHabbo().GetAvatarEffectsInventoryComponent().GetPacket());
queuedServerMessage.SendResponse();
Yupi.GetGame().GetAchievementManager().TryProgressHabboClubAchievements(this);
Yupi.GetGame().GetAchievementManager().TryProgressRegistrationAchievements(this);
Yupi.GetGame().GetAchievementManager().TryProgressLoginAchievements(this);
return(true);
}
catch (Exception ex)
{
ServerLogManager.LogCriticalException($"Bug during user login: {ex}");
}
return(false);
}
public void Fill(DataRow Row)
{
Id = Convert.ToInt32(Row["id"]);
Name = Convert.ToString(Row["caption"]);
Description = Convert.ToString(Row["description"]);
Type = Convert.ToString(Row["roomtype"]);
OwnerId = Convert.ToInt32(Row["owner"]);
OwnerName = "";
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `username` FROM `users` WHERE `id` = @owner LIMIT 1");
dbClient.AddParameter("owner", OwnerId);
string result = dbClient.GetString();
if (!String.IsNullOrEmpty(result))
{
OwnerName = result;
}
}
this.Access = RoomAccessUtility.ToRoomAccess(Row["state"].ToString().ToLower());
Category = Convert.ToInt32(Row["category"]);
if (!string.IsNullOrEmpty(Row["users_now"].ToString()))
{
UsersNow = Convert.ToInt32(Row["users_now"]);
}
else
{
UsersNow = 0;
}
UsersMax = Convert.ToInt32(Row["users_max"]);
ModelName = Convert.ToString(Row["model_name"]);
Score = Convert.ToInt32(Row["score"]);
Tags = new List <string>();
AllowPets = Convert.ToInt32(Row["allow_pets"].ToString());
AllowPetsEating = Convert.ToInt32(Row["allow_pets_eat"].ToString());
RoomBlockingEnabled = Convert.ToInt32(Row["room_blocking_disabled"].ToString());
Hidewall = Convert.ToInt32(Row["allow_hidewall"].ToString());
Password = Convert.ToString(Row["password"]);
Wallpaper = Convert.ToString(Row["wallpaper"]);
Floor = Convert.ToString(Row["floor"]);
Landscape = Convert.ToString(Row["landscape"]);
FloorThickness = Convert.ToInt32(Row["floorthick"]);
WallThickness = Convert.ToInt32(Row["wallthick"]);
WhoCanMute = Convert.ToInt32(Row["mute_settings"]);
WhoCanKick = Convert.ToInt32(Row["kick_settings"]);
WhoCanBan = Convert.ToInt32(Row["ban_settings"]);
chatMode = Convert.ToInt32(Row["chat_mode"]);
chatSpeed = Convert.ToInt32(Row["chat_speed"]);
chatSize = Convert.ToInt32(Row["chat_size"]);
TradeSettings = Convert.ToInt32(Row["trade_settings"]);
Group G = null;
if (PlusEnvironment.GetGame().GetGroupManager().TryGetGroup(Convert.ToInt32(Row["group_id"]), out G))
{
Group = G;
}
else
{
Group = null;
}
foreach (string Tag in Row["tags"].ToString().Split(','))
{
Tags.Add(Tag);
}
mModel = PlusEnvironment.GetGame().GetRoomManager().GetModel(ModelName);
this.PushEnabled = PlusEnvironment.EnumToBool(Row["push_enabled"].ToString());
this.PullEnabled = PlusEnvironment.EnumToBool(Row["pull_enabled"].ToString());
this.SPushEnabled = PlusEnvironment.EnumToBool(Row["spush_enabled"].ToString());
this.SPullEnabled = PlusEnvironment.EnumToBool(Row["spull_enabled"].ToString());
this.EnablesEnabled = PlusEnvironment.EnumToBool(Row["enables_enabled"].ToString());
this.RespectNotificationsEnabled = PlusEnvironment.EnumToBool(Row["respect_notifications_enabled"].ToString());
this.PetMorphsAllowed = PlusEnvironment.EnumToBool(Row["pet_morphs_allowed"].ToString());
}
public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)
{
if (Params.Length == 1)
{
Session.SendWhisper("Please enter the username of the user you'd like to IP ban & account ban.");
return;
}
Habbo Habbo = PlusEnvironment.GetHabboByUsername(Params[1]);
if (Habbo == null)
{
Session.SendWhisper("An error occoured whilst finding that user in the database.");
return;
}
if (Habbo.GetPermissions().HasRight("mod_tool") && !Session.GetHabbo().GetPermissions().HasRight("mod_ban_any"))
{
Session.SendWhisper("Oops, you cannot ban that user.");
return;
}
String IPAddress = String.Empty;
Double Expire = PlusEnvironment.GetUnixTimestamp() + 78892200;
string Username = Habbo.Username;
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `user_info` SET `bans` = `bans` + '1' WHERE `user_id` = '" + Habbo.Id + "' LIMIT 1");
dbClient.SetQuery("SELECT `ip_last` FROM `users` WHERE `id` = '" + Habbo.Id + "' LIMIT 1");
IPAddress = dbClient.GetString();
}
string Reason = null;
if (Params.Length >= 3)
{
Reason = CommandManager.MergeParams(Params, 2);
}
else
{
Reason = "No reason specified.";
}
if (!string.IsNullOrEmpty(IPAddress))
{
PlusEnvironment.GetGame().GetModerationManager().BanUser(Session.GetHabbo().Username, ModerationBanType.IP, IPAddress, Reason, Expire);
}
PlusEnvironment.GetGame().GetModerationManager().BanUser(Session.GetHabbo().Username, ModerationBanType.USERNAME, Habbo.Username, Reason, Expire);
if (!string.IsNullOrEmpty(Habbo.MachineId))
{
PlusEnvironment.GetGame().GetModerationManager().BanUser(Session.GetHabbo().Username, ModerationBanType.MACHINE, Habbo.MachineId, Reason, Expire);
}
GameClient TargetClient = PlusEnvironment.GetGame().GetClientManager().GetClientByUsername(Username);
if (TargetClient != null)
{
TargetClient.Disconnect();
}
Session.SendWhisper("Success, you have machine, IP and account banned the user '" + Username + "' for '" + Reason + "'!");
}
/// <summary>
/// Bans the user.
/// </summary>
/// <param name="client">The client.</param>
/// <param name="moderator">The moderator.</param>
/// <param name="lengthSeconds">The length seconds.</param>
/// <param name="reason">The reason.</param>
/// <param name="ipBan">if set to <c>true</c> [ip ban].</param>
/// <param name="machine">if set to <c>true</c> [machine].</param>
internal void BanUser(GameClient client, string moderator, double lengthSeconds, string reason, bool ipBan,
bool machine)
{
ModerationBanType type = ModerationBanType.UserName;
string text = client.GetHabbo().UserName;
string typeStr = "user";
double num = Yupi.GetUnixTimeStamp() + lengthSeconds;
if (ipBan)
{
type = ModerationBanType.Ip;
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery("SELECT ip_last FROM users WHERE username = @name LIMIT 1");
queryReactor.AddParameter("name", text);
text = queryReactor.GetString();
}
typeStr = "ip";
}
if (machine)
{
type = ModerationBanType.Machine;
typeStr = "machine";
text = client.MachineId;
}
ModerationBan moderationBan = new ModerationBan(type, text, reason, num);
switch (moderationBan.Type)
{
case ModerationBanType.Ip:
if (_bannedIPs.Contains(text)) _bannedIPs[text] = moderationBan;
else _bannedIPs.Add(text, moderationBan);
break;
case ModerationBanType.Machine:
if (_bannedMachines.ContainsKey(text)) _bannedMachines[text] = moderationBan;
else _bannedMachines.Add(text, moderationBan);
break;
default:
if (_bannedUsernames.Contains(text)) _bannedUsernames[text] = moderationBan;
else _bannedUsernames.Add(text, moderationBan);
break;
}
using (IQueryAdapter queryreactor2 = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryreactor2.SetQuery(
"INSERT INTO users_bans (bantype,value,reason,expire,added_by,added_date) VALUES (@rawvar,@var,@reason,@num,@mod,@time)");
queryreactor2.AddParameter("rawvar", typeStr);
queryreactor2.AddParameter("var", text);
queryreactor2.AddParameter("reason", reason);
queryreactor2.AddParameter("num", num);
queryreactor2.AddParameter("mod", moderator);
queryreactor2.AddParameter("time", DateTime.Now.ToLongDateString());
queryreactor2.RunQuery();
}
if (ipBan)
{
DataTable dataTable;
using (IQueryAdapter queryreactor3 = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryreactor3.SetQuery("SELECT id FROM users WHERE ip_last = @var");
queryreactor3.AddParameter("var", text);
dataTable = queryreactor3.GetTable();
}
if (dataTable != null)
{
using (IQueryAdapter queryreactor4 = Yupi.GetDatabaseManager().GetQueryReactor())
{
foreach (DataRow dataRow in dataTable.Rows)
queryreactor4.RunFastQuery(
$"UPDATE users_info SET bans = bans + 1 WHERE user_id = {Convert.ToUInt32(dataRow["id"])}");
}
}
BanUser(client, moderator, lengthSeconds, reason, false, false);
return;
}
using (IQueryAdapter queryreactor5 = Yupi.GetDatabaseManager().GetQueryReactor())
queryreactor5.RunFastQuery(
$"UPDATE users_info SET bans = bans + 1 WHERE user_id = {client.GetHabbo().Id}");
client.Disconnect("banned");
}