public void Init()
{
if (_races.Count > 0)
{
_races.Clear();
}
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `catalog_pet_races`");
DataTable Table = dbClient.getTable();
if (Table != null)
{
foreach (DataRow Row in Table.Rows)
{
PetRace Race = new PetRace(Convert.ToInt32(Row["raceid"]), Convert.ToInt32(Row["color1"]), Convert.ToInt32(Row["color2"]), (Convert.ToString(Row["has1color"]) == "1"), (Convert.ToString(Row["has2color"]) == "1"));
if (!_races.Contains(Race))
{
_races.Add(Race);
}
}
}
}
}
public void Execute(GameClient Session, Room Room, string[] Params)
{
if (Params.Length != 3)
{
Session.SendWhisper("Introduce el nombre del usuario a quien deseas enviar una placa!", 34);
return;
}
GameClient TargetClient = NeonEnvironment.GetGame().GetClientManager().GetClientByUsername(Params[1]);
if (TargetClient != null)
{
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.runFastQuery("UPDATE `users` SET `tag`= '" + Params[2] + "' WHERE `id` = '" + TargetClient.GetHabbo().Id + "'");
TargetClient.GetHabbo().Tags.Add(Params[2]);
}
Session.SendMessage(RoomNotificationComposer.SendBubble("definitions", "Has añadido el tag \"" + Params[2] + "\" a " + TargetClient.GetHabbo().Username + " correctamente.", ""));
TargetClient.SendMessage(RoomNotificationComposer.SendBubble("definitions", Session.GetHabbo().Username + " te ha añadido el tag " + Params[2] + ".", ""));
foreach (RoomUser RoomUser in Room.GetRoomUserManager().GetRoomUsers())
{
RoomUser.GetClient().SendMessage(new UserTagsComposer(TargetClient.GetHabbo().Id, TargetClient));
}
}
}
public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)
{
if (Room == null)
{
return;
}
//if (!NeonEnvironment.GetGame().GetCatalog().GetPredesignedRooms().Exists((uint)Room.Id))
//{
// Session.SendWhisper("La sala no existe en la lista.");
// return;
//}
uint predesignedId = 0U;
using (Database.Interfaces.IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT id FROM catalog_predesigned_rooms WHERE room_id = " + Room.Id + ";");
predesignedId = (uint)dbClient.getInteger();
dbClient.runFastQuery("DELETE FROM catalog_predesigned_rooms WHERE room_id = " + Room.Id + " AND id = " +
predesignedId + ";");
}
NeonEnvironment.GetGame().GetCatalog().GetPredesignedRooms().predesignedRoom.Remove(predesignedId);
Session.SendWhisper("La Sala se eliminó correctamente de la lista.");
}
public bool Init(Habbo Player)
{
if (_savedSearches.Count > 0)
{
_savedSearches.Clear();
}
DataTable GetSearches = null;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `id`,`filter`,`search_code` FROM `user_saved_searches` WHERE `user_id` = @UserId");
dbClient.AddParameter("UserId", Player.Id);
GetSearches = dbClient.getTable();
if (GetSearches != null)
{
foreach (DataRow Row in GetSearches.Rows)
{
_savedSearches.TryAdd(Convert.ToInt32(Row["id"]), new SavedSearch(Convert.ToInt32(Row["id"]), Convert.ToString(Row["filter"]), Convert.ToString(Row["search_code"])));
}
}
}
return(true);
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int SlotId = Packet.PopInt();
string Look = NeonEnvironment.GetGame().GetAntiMutant().RunLook(Packet.PopString());
string Gender = Packet.PopString();
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT null FROM `user_wardrobe` WHERE `user_id` = " + Session.GetHabbo().Id + " AND `slot_id` = @slot");
dbClient.AddParameter("slot", SlotId);
if (dbClient.getRow() != null)
{
dbClient.SetQuery("UPDATE `user_wardrobe` SET `look` = @look, `gender` = @gender WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND `slot_id` = @slot LIMIT 1");
dbClient.AddParameter("slot", SlotId);
dbClient.AddParameter("look", Look);
dbClient.AddParameter("gender", Gender.ToUpper());
dbClient.RunQuery();
}
else
{
dbClient.SetQuery("INSERT INTO `user_wardrobe` (`user_id`,`slot_id`,`look`,`gender`) VALUES ('" + Session.GetHabbo().Id + "',@slot,@look,@gender)");
dbClient.AddParameter("slot", SlotId);
dbClient.AddParameter("look", Look);
dbClient.AddParameter("gender", Gender.ToUpper());
dbClient.RunQuery();
}
}
}
public override void OnUserLeaveRoom(GameClient Client)
{
if (GetBotData() == null)
{
return;
}
_ = GetRoomUser();
if (Client.GetHabbo().CurrentRoom.OwnerId == Client.GetHabbo().Id)
{
DataTable getRoom;
using (IQueryAdapter query = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
query.SetQuery("DELETE FROM room_visits WHERE roomid = @id");
query.AddParameter("id", Client.GetHabbo().CurrentRoom.RoomId);
getRoom = query.getTable();
}
}
DataTable getUpdate;
using (IQueryAdapter query = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
query.SetQuery("UPDATE room_visits SET gone = @gone WHERE roomid = @id AND username = @username");
query.AddParameter("gone", "se ha ido.");
query.AddParameter("id", Client.GetHabbo().CurrentRoom.RoomId);
query.AddParameter("username", Client.GetHabbo().Username);
getUpdate = query.getTable();
}
}
public void ClearLTDS()
{
UpdateItems(true);
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("DELETE FROM items WHERE room_id='0' AND limited_number > 0 AND user_id = " + _userId); //Do join
}
foreach (KeyValuePair <int, Item> Fi in _floorItems)
{
if (Fi.Value.LimitedNo < 1)
{
continue;
}
_floorItems.Clear();
}
foreach (KeyValuePair <int, Item> Wi in _wallItems)
{
if (Wi.Value.LimitedNo < 1)
{
continue;
}
_wallItems.Clear();
}
if (_client != null)
{
_client.SendMessage(new FurniListUpdateComposer());
}
}
public void Init()
{
_petCommands.Clear();
_commandRegister.Clear();
_commandDatabase.Clear();
DataTable Table = null;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `bots_pet_commands`");
Table = dbClient.getTable();
if (Table != null)
{
foreach (DataRow row in Table.Rows)
{
_commandRegister.Add(Convert.ToInt32(row[0]), row[1].ToString());
_commandDatabase.Add(row[1] + ".input", row[2].ToString());
}
}
}
foreach (KeyValuePair <int, string> pair in _commandRegister)
{
int commandID = pair.Key;
string commandStringedID = pair.Value;
string[] commandInput = _commandDatabase[commandStringedID + ".input"].Split(',');
foreach (string command in commandInput)
{
_petCommands.Add(command, new PetCommand(commandID, command));
}
}
}
public static List <Item> GetItemsForUser(int UserId)
{
DataTable Items = null;
List <Item> I = new List <Item>();
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `items`.*, COALESCE(`items_groups`.`group_id`, 0) AS `group_id` FROM `items` LEFT OUTER JOIN `items_groups` ON `items`.`id` = `items_groups`.`id` WHERE `items`.`room_id` = 0 AND `items`.`user_id` = @uid;");
dbClient.AddParameter("uid", UserId);
Items = dbClient.getTable();
if (Items != null)
{
foreach (DataRow Row in Items.Rows)
{
if (NeonEnvironment.GetGame().GetItemManager().GetItem(Convert.ToInt32(Row["base_item"]), out ItemData Data))
{
I.Add(new Item(Convert.ToInt32(Row["id"]), Convert.ToInt32(Row["room_id"]), Convert.ToInt32(Row["base_item"]), Convert.ToString(Row["extra_data"]),
Convert.ToInt32(Row["x"]), Convert.ToInt32(Row["y"]), Convert.ToDouble(Row["z"]), Convert.ToInt32(Row["rot"]), Convert.ToInt32(Row["user_id"]),
Convert.ToInt32(Row["group_id"]), Convert.ToInt32(Row["limited_number"]), Convert.ToInt32(Row["limited_stack"]), Convert.ToString(Row["wall_pos"])));
}
else
{
// Item data does not exist anymore.
}
}
}
}
return(I);
}
public int AvgPriceForSprite(int SpriteID)
{
int num = 0;
int num2 = 0;
if (MarketAverages.ContainsKey(SpriteID) && MarketCounts.ContainsKey(SpriteID))
{
if (MarketCounts[SpriteID] > 0)
{
return(MarketAverages[SpriteID] / MarketCounts[SpriteID]);
}
return(0);
}
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `avgprice` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1");
num = dbClient.getInteger();
dbClient.SetQuery("SELECT `sold` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1");
num2 = dbClient.getInteger();
}
MarketAverages.Add(SpriteID, num);
MarketCounts.Add(SpriteID, num2);
if (num2 > 0)
{
return(Convert.ToInt32(Math.Ceiling((double)(num / num2))));
}
return(0);
}
public TonerData(int Item)
{
ItemId = Item;
DataRow Row;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT enabled,data1,data2,data3 FROM room_items_toner WHERE id=" + ItemId + " LIMIT 1");
Row = dbClient.getRow();
}
if (Row == null)
{
//throw new NullReferenceException("No toner data found in the database for " + ItemId);
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("INSERT INTO `room_items_toner` VALUES (" + ItemId + ",'0',0,0,0)");
dbClient.SetQuery("SELECT enabled,data1,data2,data3 FROM room_items_toner WHERE id=" + ItemId + " LIMIT 1");
Row = dbClient.getRow();
}
}
Enabled = int.Parse(Row[0].ToString());
Hue = Convert.ToInt32(Row[1]);
Saturation = Convert.ToInt32(Row[2]);
Lightness = Convert.ToInt32(Row[3]);
}
public static Item CreateGiftItem(ItemData Data, Habbo Habbo, string ExtraData, string DisplayFlags, int ItemId, int LimitedNumber = 0, int LimitedStack = 0)
{
if (Data == null)
{
throw new InvalidOperationException("Data cannot be null.");
}
Item Item = new Item(ItemId, 0, Data.Id, ExtraData, 0, 0, 0, 0, Habbo.Id, 0, LimitedNumber, LimitedStack, "");
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO `items` (`id`,base_item,user_id,room_id,x,y,z,wall_pos,rot,extra_data,`limited_number`,`limited_stack`) VALUES (@id, @did,@uid,@rid,@x,@y,@z,@wall_pos,@rot,@extra_data, @limited_number, @limited_stack)");
dbClient.AddParameter("id", ItemId);
dbClient.AddParameter("did", Data.Id);
dbClient.AddParameter("uid", Habbo.Id);
dbClient.AddParameter("rid", 0);
dbClient.AddParameter("x", 0);
dbClient.AddParameter("y", 0);
dbClient.AddParameter("z", 0);
dbClient.AddParameter("wall_pos", "");
dbClient.AddParameter("rot", 0);
dbClient.AddParameter("extra_data", ExtraData);
dbClient.AddParameter("limited_number", LimitedNumber);
dbClient.AddParameter("limited_stack", LimitedStack);
dbClient.RunQuery();
return(Item);
}
}
public RoomPollQuestion(int id, int pollId, string question, string type, int seriesOrder, int minimumSlections)
{
Id = id;
PollId = pollId;
Question = question;
Type = RoomPollQuestionTypeUtility.GetQuestionType(type);
SeriesOrder = seriesOrder;
MinimumSlections = minimumSlections;
_selections = new Dictionary <int, RoomPollQuestionSelection>();
DataTable GetSelections = null;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `room_poll_questions_selections` WHERE `question_id` = @QuestionId");
dbClient.AddParameter("QuestionId", Id);
GetSelections = dbClient.getTable();
if (GetSelections != null)
{
foreach (DataRow Row in GetSelections.Rows)
{
if (!_selections.ContainsKey(Convert.ToInt32(Row["id"])))
{
_selections.Add(Convert.ToInt32(Row["id"]), new RoomPollQuestionSelection(Convert.ToInt32(Row["id"]), Id, Convert.ToString(Row["text"]), Convert.ToString(Row["value"])));
}
}
}
}
}
public void GiveBadge(string Badge, bool InDatabase, GameClient Session)
{
if (HasBadge(Badge))
{
return;
}
if (InDatabase)
{
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("INSERT INTO user_badges (user_id,badge_id,badge_slot) VALUES (" + _player.Id + ",@badge," + 0 + ")");
dbClient.AddParameter("badge", Badge);
dbClient.RunQuery();
}
}
_badges.Add(Badge, new Badge(Badge, 0));
if (Session != null)
{
Session.SendMessage(new BadgesComposer(Session));
Session.SendMessage(new FurniListNotificationComposer(1, 4));
}
}
public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)
{
if (!Room.CheckRights(Session, true))
{
return;
}
if (Params.Length == 1)
{
Session.SendWhisper("Ingresa que velocidad desea para los roller.");
return;
}
if (int.TryParse(Params[1], out int Speed))
{
Session.GetHabbo().CurrentRoom.GetRoomItemHandler().SetSpeed(Speed);
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `rooms` SET `roller_speed` = " + Speed + " WHERE `id` = '" + Room.Id + "' LIMIT 1");
}
}
else
{
Session.SendWhisper("Cantidad invalida, solo es permitido en numeros.");
}
}
public MoodlightData(int ItemId)
{
this.ItemId = ItemId;
DataRow Row = null;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id = '" + ItemId + "' LIMIT 1");
Row = dbClient.getRow();
}
if (Row == null)
{
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("INSERT INTO `room_items_moodlight` (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (" + ItemId + ",0,1,'#000000,255,0','#000000,255,0','#000000,255,0')");
dbClient.SetQuery("SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id=" + ItemId + " LIMIT 1");
Row = dbClient.getRow();
}
}
Enabled = NeonEnvironment.EnumToBool(Row["enabled"].ToString());
CurrentPreset = Convert.ToInt32(Row["current_preset"]);
Presets = new List <MoodlightPreset>
{
GeneratePreset(Convert.ToString(Row["preset_one"])),
GeneratePreset(Convert.ToString(Row["preset_two"])),
GeneratePreset(Convert.ToString(Row["preset_three"]))
};
}
public void Parse(GameClient Session, ClientPacket Packet)
{
string username = Packet.PopString();
Habbo targetData = NeonEnvironment.GetHabboByUsername(username);
if (targetData == null)
{
Session.SendNotification("Ha ocurrido un error buscando el perfil del usuario.");
return;
}
List <Group> groups = NeonEnvironment.GetGame().GetGroupManager().GetGroupsForUser(targetData.Id);
int friendCount = 0;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT COUNT(0) FROM `messenger_friendships` WHERE (`user_one_id` = @userid OR `user_two_id` = @userid)");
dbClient.AddParameter("userid", targetData.Id);
friendCount = dbClient.getInteger();
}
Session.SendMessage(new ProfileInformationComposer(targetData, Session, groups, friendCount));
}
public void Init()
{
if (_leaderboards.Count > 0)
{
_leaderboards.Clear();
}
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
DataTable GetData = null;
dbClient.SetQuery("SELECT * FROM `games_leaderboard`");
GetData = dbClient.getTable();
if (GetData != null)
{
foreach (DataRow Row in GetData.Rows)
{
LeaderBoardData value = new LeaderBoardData(Convert.ToInt32(Row["game_id"]), Convert.ToInt32(Row["user_id"]), Convert.ToInt32(Row["points"]), Convert.ToInt32(Row["record"]), Convert.ToInt32(Row["week"]), Convert.ToInt32(Row["year"]));
_leaderboards.Add(Convert.ToInt32(Row["id"]), value);
}
}
}
log.Info(">> LeaderBoardData Manager -> READY!");
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int CreditsOwed = 0;
DataTable Table = null;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `asking_price` FROM `catalog_marketplace_offers` WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND state = '2'");
Table = dbClient.getTable();
}
if (Table != null)
{
foreach (DataRow row in Table.Rows)
{
CreditsOwed += Convert.ToInt32(row["asking_price"]);
}
if (CreditsOwed >= 1)
{
Session.GetHabbo().Duckets += CreditsOwed;
Session.SendMessage(new HabboActivityPointNotificationComposer(Session.GetHabbo().Duckets, CreditsOwed));
}
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("DELETE FROM `catalog_marketplace_offers` WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND `state` = '2'");
}
}
}
public void RemoveFromDatabase()
{
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("DELETE FROM room_items_songs WHERE itemid = " + itemID);
}
}
public Item AddNewItem(int Id, int BaseItem, string ExtraData, int Group, bool ToInsert, bool FromRoom, int LimitedNumber, int LimitedStack)
{
if (ToInsert)
{
if (FromRoom)
{
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("UPDATE `items` SET `base_item` = " + BaseItem + ", `room_id` = 0, `user_id` = " + _userId + " WHERE `id` = " + Id);
}
}
else
{
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
if (Id > 0)
{
dbClient.RunQuery("INSERT INTO `items` (`id`,`base_item`, `extradata`, `user_id`, `limited_number`, `limited_stack`) VALUES ('" + Id + "', '" + BaseItem + "', '" + ExtraData + "', '" + _userId + "', '" + LimitedNumber + "', '" + LimitedStack + "')");
}
else
{
dbClient.SetQuery("INSERT INTO `items` (`base_item`, `user_id`, `extra_data`, `limited_number`, `limited_stack`) VALUES ('" + BaseItem + "', '" + _userId + "', '" + ExtraData + "', '" + LimitedNumber + "', '" + LimitedStack + "')");
Id = Convert.ToInt32(dbClient.InsertQuery());
}
SendNewItems(Convert.ToInt32(Id));
if (Group > 0)
{
dbClient.RunQuery("INSERT INTO `items_groups` VALUES (" + Id + ", " + Group + ")");
}
if (!string.IsNullOrEmpty(ExtraData))
{
dbClient.SetQuery("UPDATE `items` SET `extra_data` = @extradata WHERE `id` = '" + Id + "' LIMIT 1");
dbClient.AddParameter("extradata", ExtraData);
dbClient.RunQuery();
}
}
}
}
Item ItemToAdd = new Item(Id, 0, BaseItem, ExtraData, 0, 0, 0, 0, _userId, Group, LimitedNumber, LimitedStack, string.Empty);
if (UserHoldsItem(Id))
{
RemoveItem(Id);
}
if (ItemToAdd.IsWallItem)
{
_wallItems.TryAdd(ItemToAdd.Id, ItemToAdd);
}
else
{
_floorItems.TryAdd(ItemToAdd.Id, ItemToAdd);
}
return(ItemToAdd);
}
public WardrobeComposer(GameClient Session)
: base(ServerPacketHeader.WardrobeMessageComposer)
{
base.WriteInteger(1);
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `slot_id`,`look`,`gender` FROM `user_wardrobe` WHERE `user_id` = '" + Session.GetHabbo().Id + "'");
DataTable WardrobeData = dbClient.getTable();
if (WardrobeData == null)
{
base.WriteInteger(0);
}
else
{
base.WriteInteger(WardrobeData.Rows.Count);
foreach (DataRow Row in WardrobeData.Rows)
{
base.WriteInteger(Convert.ToInt32(Row["slot_id"]));
base.WriteString(Convert.ToString(Row["look"]));
base.WriteString(Row["gender"].ToString().ToUpper());
}
}
}
}
public void Init()
{
if (_clothing.Count > 0)
{
_clothing.Clear();
}
DataTable GetClothing = null;
using (Database.Interfaces.IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `id`,`clothing_name`,`clothing_parts` FROM `catalog_clothing`");
GetClothing = dbClient.getTable();
}
if (GetClothing != null)
{
foreach (DataRow Row in GetClothing.Rows)
{
_clothing.Add(Convert.ToInt32(Row["id"]),
new ClothingItem(Convert.ToInt32(Row["id"]), Convert.ToString(Row["clothing_name"]),
Convert.ToString(Row["clothing_parts"])));
}
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int GroupId = Packet.PopInt();
string Name = Packet.PopString();
Name = NeonEnvironment.GetGame().GetChatManager().GetFilter().IsUnnaceptableWord(Name, out string word) ? "Spam" : Name;
string Desc = Packet.PopString();
Desc = NeonEnvironment.GetGame().GetChatManager().GetFilter().IsUnnaceptableWord(Desc, out word) ? "Spam" : Desc;
if (!NeonEnvironment.GetGame().GetGroupManager().TryGetGroup(GroupId, out Group Group))
{
return;
}
if (Group.CreatorId != Session.GetHabbo().Id)
{
return;
}
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `groups` SET `name`= @name, `desc` = @desc WHERE `id` = '" + GroupId + "' LIMIT 1");
dbClient.AddParameter("name", Name);
dbClient.AddParameter("desc", Desc);
dbClient.RunQuery();
}
Group.Name = Name;
Group.Description = Desc;
Session.SendMessage(new GroupInfoComposer(Group, Session));
}
public void Init()
{
_items = new Dictionary <int, RentableSpaceItem>();
using (IQueryAdapter con = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
con.SetQuery("SELECT * FROM `items_rentablespace`");
DataTable table = con.getTable();
if (table != null)
{
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
if (row != null)
{
int id = Convert.ToInt32(row["item_id"].ToString());
int ownerid = Convert.ToInt32(row["owner"].ToString());
string ownername = "";
if (ownerid > 0)
{
Habbo owner = NeonEnvironment.GetHabboById(ownerid);
if (owner != null)
{
ownername = owner.Username;
}
}
int expirestamp = Convert.ToInt32(row["expire"].ToString());
int price = Convert.ToInt32(row["price"].ToString());
AddItem(new RentableSpaceItem(id, ownerid, ownername, expirestamp, price));
}
}
}
}
}
public void Init()
{
if (_subscriptions.Count > 0)
{
_subscriptions.Clear();
}
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `subscriptions`;");
DataTable GetSubscriptions = dbClient.getTable();
if (GetSubscriptions != null)
{
foreach (DataRow Row in GetSubscriptions.Rows)
{
if (!_subscriptions.ContainsKey(Convert.ToInt32(Row["id"])))
{
_subscriptions.Add(Convert.ToInt32(Row["id"]), new SubscriptionData(Convert.ToInt32(Row["id"]), Convert.ToString(Row["name"]), Convert.ToString(Row["badge_code"]), Convert.ToInt32(Row["credits"]), Convert.ToInt32(Row["duckets"]), Convert.ToInt32(Row["respects"])));
}
}
}
}
//log.Info(">> Subscription Manager " + this._subscriptions.Count + " loaded.");
log.Info(">> Subscription Manager -> READY!");
}
public void Disconnect()
{
try
{
if (GetHabbo() != null)
{
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery(GetHabbo().GetQueryString);
}
GetHabbo().OnDisconnect();
}
}
catch (Exception e)
{
Logging.LogException(e.ToString());
}
if (!_disconnected)
{
if (_connection != null)
{
_connection.Dispose();
}
_disconnected = true;
}
}
public void GetCurrentQuest(GameClient Session, ClientPacket Message)
{
if (!Session.GetHabbo().InRoom)
{
return;
}
Quest UserQuest = GetQuest(Session.GetHabbo().QuestLastCompleted);
Quest NextQuest = GetNextQuestInSeries(UserQuest.Category, UserQuest.Number + 1);
if (NextQuest == null)
{
return;
}
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.RunQuery("REPLACE INTO `user_quests`(`user_id`,`quest_id`) VALUES (" + Session.GetHabbo().Id + ", " + NextQuest.Id + ")");
dbClient.RunQuery("UPDATE `user_stats` SET `quest_id` = '" + NextQuest.Id + "' WHERE `id` = '" + Session.GetHabbo().Id + "' LIMIT 1");
}
Session.GetHabbo().GetStats().QuestID = NextQuest.Id;
GetList(Session, null);
Session.SendMessage(new QuestStartedComposer(Session, NextQuest));
}
/// <summary>
/// Initializes the EffectsComponent.
/// </summary>
/// <param name="UserId"></param>
public bool Init(Habbo Habbo)
{
if (_allClothing.Count > 0)
{
return(false);
}
using (Database.Interfaces.IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `id`,`part_id`,`part` FROM `user_clothing` WHERE `user_id` = @id;");
dbClient.AddParameter("id", Habbo.Id);
DataTable GetClothing = dbClient.getTable();
if (GetClothing != null)
{
foreach (DataRow Row in GetClothing.Rows)
{
_allClothing.TryAdd(Convert.ToInt32(Row["part_id"]),
new ClothingParts(Convert.ToInt32(Row["id"]), Convert.ToInt32(Row["part_id"]),
Convert.ToString(Row["part"])));
}
}
}
_habbo = Habbo;
return(true);
}
public void Execute(GameClients.GameClient Session, Room Room, string[] Params)
{
if (!Room.CheckRights(Session, false, false))
{
Session.SendWhisper("¡No tienes derechos en esa sala!", 34);
return;
}
Room.HideWired = !Room.HideWired;
if (Room.HideWired)
{
Session.SendWhisper("Wired está oculto.", 34);
}
else
{
Session.SendWhisper("Wired fue mostrado.", 34);
}
using (IQueryAdapter con = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
con.SetQuery("UPDATE `rooms` SET `hide_wired` = @enum WHERE `id` = @id LIMIT 1");
con.AddParameter("enum", NeonEnvironment.BoolToEnum(Room.HideWired));
con.AddParameter("id", Room.Id);
con.RunQuery();
}
_ = new List <ServerPacket>();
List <ServerPacket> list = Room.HideWiredMessages(Room.HideWired);
Room.SendMessage(list);
}
