internal static ServerMessage SerializeRoomVisits(UInt32 UserId)
{
Habbo User = UsersCache.getHabboCache(UserId);
ServerMessage Message = new ServerMessage(Outgoing.RoomsVisits);
Message.AppendUInt(UserId);
Message.AppendString(UsersCache.getUsernameById(UserId));
if (User == null)
{
Message.AppendInt32(0);
}
else
{
Message.AppendInt32(User.RoomsVisited.Count);
foreach (RoomVisits Room in User.RoomsVisited)
{
// Message.AppendBoolean(Room.IsPublic);
Message.AppendUInt(Room.RoomId);
Message.AppendString(Room.RoomName);
Message.AppendInt32(Room.Hour);
Message.AppendInt32(Room.Minute);
}
}
return(Message);
}
internal void LoadLast()
{
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT owner_id, date_created FROM groups_forums_boards WHERE groupid = '" + GroupId + "' AND sub_post_id = '" + this.Id + "' OR id = '" + this.Id + "' ORDER BY id DESC LIMIT 1");
DataRow dRow = dbClient.getRow();
if (dRow != null)
{
this.LastOwnerId = Convert.ToUInt32(dRow["owner_id"]);
this.LastOwnerName = UsersCache.getUsernameById(this.LastOwnerId);
this.LastUnix = Convert.ToDouble(dRow["date_created"]);
}
}
}
internal GroupItem(DataRow dRow)
{
Id = Convert.ToUInt32(dRow["id"]);
Name = (string)dRow["name"];
Description = (string)dRow["description"];
RoomId = Convert.ToUInt32(dRow["roomid"]);
CustomColor1 = (int)dRow["customcolor1"];
CustomColor2 = (int)dRow["customcolor2"];
temChat = OtanixEnvironment.EnumToBool((string)dRow["temChat"]);
GroupBase = (int)dRow["groupbase"];
GroupBaseColor = (int)dRow["groupbasecolor"];
GroupBasePosition = (int)dRow["groupbaseposition"];
var zGroupItem1 = ((string)dRow["groupitem1"]).Split(';');
if (zGroupItem1.Count() == 3)
{
GroupItem1 = new int[] { int.Parse(zGroupItem1[0]), int.Parse(zGroupItem1[1]), int.Parse(zGroupItem1[2]) }
}
;
var zGroupItem2 = ((string)dRow["groupitem2"]).Split(';');
if (zGroupItem2.Count() == 3)
{
GroupItem2 = new int[] { int.Parse(zGroupItem2[0]), int.Parse(zGroupItem2[1]), int.Parse(zGroupItem2[2]) }
}
;
var zGroupItem3 = ((string)dRow["groupitem3"]).Split(';');
if (zGroupItem3.Count() == 3)
{
GroupItem3 = new int[] { int.Parse(zGroupItem3[0]), int.Parse(zGroupItem3[1]), int.Parse(zGroupItem3[2]) }
}
;
var zGroupItem4 = ((string)dRow["groupitem4"]).Split(';');
if (zGroupItem4.Count() == 3)
{
GroupItem4 = new int[] { int.Parse(zGroupItem4[0]), int.Parse(zGroupItem4[1]), int.Parse(zGroupItem4[2]) }
}
;
GroupImage = (string)dRow["groupimage"];
HtmlColor1 = (string)dRow["htmlcolor1"];
HtmlColor2 = (string)dRow["htmlcolor2"];
DateCreated = (string)dRow["datecreated"];
OwnerId = Convert.ToUInt32(dRow["ownerid"]);
OwnerName = UsersCache.getUsernameById(OwnerId);
Type = Convert.ToInt32(dRow["type"]);
RightsType = Convert.ToInt32(dRow["rightsType"]);
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT COUNT(*) FROM groups_users WHERE groupid = '" + Id + "' AND acepted = '1'");
MembersCount = dbClient.getInteger();
dbClient.setQuery("SELECT * FROM groups_forums WHERE groupid = " + Id);
DataRow dForum = dbClient.getRow();
if (dForum != null)
{
Forum = new GroupForum(Id, Convert.ToInt32(dForum["can_read"]), Convert.ToInt32(dForum["can_write"]), Convert.ToInt32(dForum["can_create"]), Convert.ToInt32(dForum["can_moderate"]), true);
}
}
}
internal override void OnUserSay(RoomUser User, string Message)
{
if (User == null || User.GetClient() == null)
{
return;
}
if (GetRoom() == null)
{
return;
}
if (GetRoom().RoomData.OwnerId == User.HabboId)
{
if (Message.ToLower().Equals(LanguageLocale.GetValue("bot.soplon.keyword")))
{
StringBuilder botMessage = new StringBuilder();
if (GetBotData().SoplonLeaveRoom.Count > 0)
{
foreach (UInt32 HabboId in GetBotData().SoplonLeaveRoom)
{
string Username = UsersCache.getUsernameById(HabboId);
if (String.IsNullOrEmpty(Username))
{
continue;
}
if ((LanguageLocale.GetValue("bot.soplon.leave").Length + botMessage.Length + Username.Length) >= 100)
{
botMessage = botMessage.Remove(botMessage.Length - 2, 2);
ServerMessage ChatMessage = new ServerMessage(Outgoing.Talk);
ChatMessage.AppendInt32(GetRoomUser().VirtualId);
ChatMessage.AppendString(botMessage + " " + LanguageLocale.GetValue("bot.soplon.leave"));
ChatMessage.AppendInt32(0);
ChatMessage.AppendInt32(OtanixEnvironment.GetGame().GetRoomRankConfig().BOTS_DEFAULT_COLOR);
ChatMessage.AppendInt32(0);
ChatMessage.AppendInt32(-1);
User.GetClient().SendMessage(ChatMessage);
botMessage.Clear();
}
botMessage.Append(Username + ", ");
}
if (botMessage.Length > 0)
{
botMessage = botMessage.Remove(botMessage.Length - 2, 2);
ServerMessage ChatMessage = new ServerMessage(Outgoing.Talk);
ChatMessage.AppendInt32(GetRoomUser().VirtualId);
ChatMessage.AppendString(botMessage + " " + LanguageLocale.GetValue("bot.soplon.leave"));
ChatMessage.AppendInt32(0);
ChatMessage.AppendInt32(OtanixEnvironment.GetGame().GetRoomRankConfig().BOTS_DEFAULT_COLOR);
ChatMessage.AppendInt32(0);
ChatMessage.AppendInt32(-1);
User.GetClient().SendMessage(ChatMessage);
botMessage.Clear();
}
GetBotData().SoplonLeaveRoom.Clear();
}
if (GetBotData().SoplonOnRoom.Count > 0)
{
foreach (UInt32 HabboId in GetBotData().SoplonOnRoom)
{
string Username = UsersCache.getUsernameById(HabboId);
if (String.IsNullOrEmpty(Username))
{
continue;
}
if ((LanguageLocale.GetValue("bot.soplon.onroom").Length + botMessage.Length + Username.Length) >= 100)
{
botMessage = botMessage.Remove(botMessage.Length - 2, 2);
ServerMessage ChatMessage = new ServerMessage(Outgoing.Talk);
ChatMessage.AppendInt32(GetRoomUser().VirtualId);
ChatMessage.AppendString(botMessage + " " + LanguageLocale.GetValue("bot.soplon.onroom"));
ChatMessage.AppendInt32(0);
ChatMessage.AppendInt32(OtanixEnvironment.GetGame().GetRoomRankConfig().BOTS_DEFAULT_COLOR);
ChatMessage.AppendInt32(0);
ChatMessage.AppendInt32(-1);
User.GetClient().SendMessage(ChatMessage);
botMessage.Clear();
}
botMessage.Append(Username + ", ");
}
if (botMessage.Length > 0)
{
botMessage = botMessage.Remove(botMessage.Length - 2, 2);
ServerMessage ChatMessage = new ServerMessage(Outgoing.Talk);
ChatMessage.AppendInt32(GetRoomUser().VirtualId);
ChatMessage.AppendString(botMessage + " " + LanguageLocale.GetValue("bot.soplon.onroom"));
ChatMessage.AppendInt32(0);
ChatMessage.AppendInt32(OtanixEnvironment.GetGame().GetRoomRankConfig().BOTS_DEFAULT_COLOR);
ChatMessage.AppendInt32(0);
ChatMessage.AppendInt32(-1);
User.GetClient().SendMessage(ChatMessage);
botMessage.Clear();
}
GetBotData().SoplonOnRoom.Clear();
}
}
}
}
