public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom) { try { string data2 = null; string wireditem = null; dbClient.SetQuery("SELECT trigger_data, trigger_data_2, triggers_item FROM wired_items WHERE trigger_id = @id "); dbClient.AddParameter("id", this.itemID); DataRow row = dbClient.GetRow(); if (row != null) { this.Delay = Convert.ToInt32(row["trigger_data"]); data2 = row["trigger_data_2"].ToString(); wireditem = row["triggers_item"].ToString(); } if (data2 != null) { int rotationint = 0; int.TryParse(data2.Split(';')[0], out rotationint); int movementint = 0; int.TryParse(data2.Split(';')[1], out movementint); this.rotation = (RotationState)rotationint; this.movement = (MovementState)movementint; } else { this.rotation = RotationState.none; this.movement = MovementState.none; } if (wireditem == "" || wireditem == null) { return; } foreach (string itemid in wireditem.Split(';')) { Item roomItem = insideRoom.GetRoomItemHandler().GetItem(Convert.ToInt32(itemid)); if (roomItem != null && !this.items.Contains(roomItem) && roomItem.Id != this.itemID) { this.items.Add(roomItem); } } } catch (Exception ex) { Console.WriteLine("Wired id : " + this.itemID + " erreur :" + ex); } }
/// <summary> /// Loads the specified index. /// </summary> /// <param name="index">The index.</param> /// <returns>SmallPromo.</returns> public static HotelLandingPromos Load(int index) { using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor()) { queryReactor.SetQuery("SELECT hotelview_promos.`index`,hotelview_promos.header,hotelview_promos.body,hotelview_promos.button,hotelview_promos.in_game_promo,hotelview_promos.special_action,hotelview_promos.image,hotelview_promos.enabled FROM hotelview_promos WHERE hotelview_promos.`index` = @x LIMIT 1"); queryReactor.AddParameter("x", index); DataRow row = queryReactor.GetRow(); return(new HotelLandingPromos(index, (string)row[1], (string)row[2], (string)row[3], Convert.ToInt32(row[4]), (string)row[5], (string)row[6])); } }
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); DataRow row = dbClient.GetRow(); if (row == null) { return; } this.NameBot = row["trigger_data"].ToString(); }
public void Parse(GameClient session, ClientPacket packet) { if (session == null || session.GetHabbo() == null) { return; } DataRow row; int offerId = packet.PopInt(); using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `furni_id`, `item_id`, `user_id`, `extra_data`, `offer_id`, `state`, `timestamp`, `limited_number`, `limited_stack` FROM `catalog_marketplace_offers` WHERE `offer_id` = @OfferId LIMIT 1"); dbClient.AddParameter("OfferId", offerId); row = dbClient.GetRow(); } if (row == null) { session.SendPacket(new MarketplaceCancelOfferResultComposer(offerId, false)); return; } if (Convert.ToInt32(row["user_id"]) != session.GetHabbo().Id) { session.SendPacket(new MarketplaceCancelOfferResultComposer(offerId, false)); return; } if (!PlusEnvironment.GetGame().GetItemManager().GetItem(Convert.ToInt32(row["item_id"]), out ItemData item)) { session.SendPacket(new MarketplaceCancelOfferResultComposer(offerId, false)); return; } //PlusEnvironment.GetGame().GetCatalog().DeliverItems(Session, Item, 1, Convert.ToString(Row["extra_data"]), Convert.ToInt32(Row["limited_number"]), Convert.ToInt32(Row["limited_stack"]), Convert.ToInt32(Row["furni_id"])); Item giveItem = ItemFactory.CreateSingleItem(item, session.GetHabbo(), Convert.ToString(row["extra_data"]), Convert.ToString(row["extra_data"]), Convert.ToInt32(row["furni_id"]), Convert.ToInt32(row["limited_number"]), Convert.ToInt32(row["limited_stack"])); session.SendPacket(new FurniListNotificationComposer(giveItem.Id, 1)); session.SendPacket(new FurniListUpdateComposer()); using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("DELETE FROM `catalog_marketplace_offers` WHERE `offer_id` = @OfferId AND `user_id` = @UserId LIMIT 1"); dbClient.AddParameter("OfferId", offerId); dbClient.AddParameter("UserId", session.GetHabbo().Id); dbClient.RunQuery(); } session.GetHabbo().GetInventoryComponent().UpdateItems(true); session.SendPacket(new MarketplaceCancelOfferResultComposer(offerId, true)); }
/// <summary> /// Serializes the user information. /// </summary> /// <param name="userId">The user identifier.</param> /// <returns>ServerMessage.</returns> /// <exception cref="System.NullReferenceException">User not found in database.</exception> internal static ServerMessage SerializeUserInfo(uint userId) { ServerMessage serverMessage = new ServerMessage(LibraryParser.OutgoingRequest("ModerationToolUserToolMessageComposer")); using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor()) { if (queryReactor != null) { queryReactor.SetQuery( "SELECT id, username, mail, look, trade_lock, trade_lock_expire, rank, ip_last, " + "IFNULL(cfhs, 0) cfhs, IFNULL(cfhs_abusive, 0) cfhs_abusive, IFNULL(cautions, 0) cautions, IFNULL(bans, 0) bans, " + "IFNULL(reg_timestamp, 0) reg_timestamp, IFNULL(login_timestamp, 0) login_timestamp " + $"FROM users left join users_info on (users.id = users_info.user_id) WHERE id = '{userId}' LIMIT 1" ); DataRow row = queryReactor.GetRow(); uint id = Convert.ToUInt32(row["id"]); serverMessage.AppendInteger(id); serverMessage.AppendString(row["username"].ToString()); serverMessage.AppendString(row["look"].ToString()); double regTimestamp = (double)row["reg_timestamp"]; double loginTimestamp = (double)row["login_timestamp"]; int unixTimestamp = Yupi.GetUnixTimeStamp(); serverMessage.AppendInteger( (int)(regTimestamp > 0 ? Math.Ceiling((unixTimestamp - regTimestamp) / 60.0) : regTimestamp)); serverMessage.AppendInteger( (int) (loginTimestamp > 0 ? Math.Ceiling((unixTimestamp - loginTimestamp) / 60.0) : loginTimestamp)); serverMessage.AppendBool(true); serverMessage.AppendInteger(Convert.ToInt32(row["cfhs"])); serverMessage.AppendInteger(Convert.ToInt32(row["cfhs_abusive"])); serverMessage.AppendInteger(Convert.ToInt32(row["cautions"])); serverMessage.AppendInteger(Convert.ToInt32(row["bans"])); serverMessage.AppendInteger(0); uint rank = (uint)row["rank"]; serverMessage.AppendString(row["trade_lock"].ToString() == "1" ? Yupi.UnixToDateTime(int.Parse(row["trade_lock_expire"].ToString())).ToLongDateString() : "Not trade-locked"); serverMessage.AppendString(rank < 6 ? row["ip_last"].ToString() : "127.0.0.1"); serverMessage.AppendInteger(id); serverMessage.AppendInteger(0); serverMessage.AppendString($"E-Mail: {row["mail"]}"); serverMessage.AppendString($"Rank ID: {rank}"); } } return(serverMessage); }
/// <summary> /// Gets the linked tele. /// </summary> /// <param name="teleId">The tele identifier.</param> /// <param name="pRoom">The p room.</param> /// <returns>System.UInt32.</returns> internal static uint GetLinkedTele(uint teleId, Room pRoom) { uint result; using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor()) { queryReactor.SetQuery($"SELECT tele_two_id FROM items_teleports WHERE tele_one_id = {teleId}"); DataRow row = queryReactor.GetRow(); result = row == null ? 0 : Convert.ToUInt32(row[0]); } return(result); }
private static RoomModel GetCustomData(int roomID) { DataRow row; using (IQueryAdapter queryreactor = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor()) { queryreactor.SetQuery("SELECT door_x,door_y,door_z,door_dir,heightmap, murheight FROM room_models_customs WHERE roomid = " + roomID); row = queryreactor.GetRow(); } if (row == null) { throw new Exception("The custom room model for room " + roomID + " was not found"); } return(new RoomModel(roomID.ToString(), (int)row["door_x"], (int)row["door_y"], (double)row["door_z"], (int)row["door_dir"], (string)row["heightmap"], (int)row["murheight"])); }
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); DataRow row = dbClient.GetRow(); if (row != null) { this.timeout = Convert.ToInt32(row[0].ToString()); } else { this.timeout = 20; } }
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom) { dbClient.SetQuery("SELECT trigger_data FROM wired_items WHERE trigger_id = @id"); dbClient.AddParameter("id", this.itemID); DataRow row = dbClient.GetRow(); if (row == null) { return; } if (int.TryParse(row[0].ToString(), out int number)) { this.team = (Team)number; } }
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom) { dbClient.SetQuery("SELECT trigger_data, triggers_item FROM wired_items WHERE trigger_id = @id "); dbClient.AddParameter("id", this.itemID); DataRow row = dbClient.GetRow(); this.Delay = 0; if (row == null) { return; } this.Delay = row == null ? 0 : Convert.ToInt32(row[0].ToString()); }
/// <summary> /// Reloads the subscription. /// </summary> internal void ReloadSubscription() { using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor()) { queryReactor.SetQuery( "SELECT * FROM users_subscriptions WHERE user_id=@id AND timestamp_expire > UNIX_TIMESTAMP() ORDER BY subscription_id DESC LIMIT 1"); queryReactor.AddParameter("id", _userId); DataRow row = queryReactor.GetRow(); _subscription = row == null ? null : new Subscription((int)row[1], (int)row[2], (int)row[3], (int)row[4]); } }
/// <summary> /// Gets the linked tele. /// </summary> /// <param name="teleId">The tele identifier.</param> /// <param name="pRoom">The p room.</param> /// <returns>System.UInt32.</returns> internal static UInt32 GetLinkedTele(UInt32 TeleId, Room pRoom) { using (IQueryAdapter dbClient = Plus.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT tele_two_id FROM items_teleports WHERE tele_one_id = " + TeleId); DataRow Row = dbClient.GetRow(); if (Row == null) { return(0); } return(Convert.ToUInt32(Row[0])); } }
public void Parse(HabboHotel.GameClients.GameClient session, ClientPacket packet) { if (!session.Habbo.GetPermissions().HasRight("mod_tool")) { return; } int userId = packet.PopInt(); DataRow user; DataRow info; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `id`,`username`,`online`,`mail`,`ip_last`,`look`,`account_created`,`last_online` FROM `users` WHERE `id` = '" + userId + "' LIMIT 1"); user = dbClient.GetRow(); if (user == null) { session.SendNotification(PlusEnvironment.GetLanguageManager().TryGetValue("user.not_found")); return; } dbClient.SetQuery("SELECT `cfhs`,`cfhs_abusive`,`cautions`,`bans`,`trading_locked`,`trading_locks_count` FROM `user_info` WHERE `user_id` = '" + userId + "' LIMIT 1"); info = dbClient.GetRow(); if (info == null) { dbClient.RunQuery("INSERT INTO `user_info` (`user_id`) VALUES ('" + userId + "')"); dbClient.SetQuery("SELECT `cfhs`,`cfhs_abusive`,`cautions`,`bans`,`trading_locked`,`trading_locks_count` FROM `user_info` WHERE `user_id` = '" + userId + "' LIMIT 1"); info = dbClient.GetRow(); } } session.SendPacket(new ModeratorUserInfoComposer(user, info)); }
public static int GetLinkedTele(int TeleId) { using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `tele_two_id` FROM `room_items_tele_links` WHERE `tele_one_id` = '" + TeleId + "' LIMIT 1"); DataRow Row = dbClient.GetRow(); if (Row == null) { return(0); } return(Convert.ToInt32(Row[0])); } }
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom) { dbClient.SetQuery("SELECT trigger_data, all_user_triggerable FROM wired_items WHERE trigger_id = @id "); dbClient.AddParameter("id", this.item.Id); DataRow row = dbClient.GetRow(); if (row != null) { this.triggerMessage = row[0].ToString(); } else { this.triggerMessage = string.Empty; } }
public override bool Execute(GameClient session, string[] pms) { string userName = pms[0]; if (string.IsNullOrEmpty(userName)) { return(true); } GameClient clientByUserName = Yupi.GetGame().GetClientManager().GetClientByUserName(userName); if (clientByUserName == null || clientByUserName.GetHabbo() == null) { using (IQueryAdapter adapter = Yupi.GetDatabaseManager().GetQueryReactor()) { adapter.SetQuery( "SELECT username, rank, id, credits, activity_points, diamonds FROM users WHERE username=@user LIMIT 1"); adapter.AddParameter("user", userName); DataRow row = adapter.GetRow(); if (row == null) { session.SendWhisper(Yupi.GetLanguage().GetVar("user_not_found")); return(true); } session.SendNotif(string.Format(Yupi.GetLanguage().GetVar("user_info_all"), userName, row[1], row[3], row[4], row[5])); } return(true); } Habbo habbo = clientByUserName.GetHabbo(); StringBuilder builder = new StringBuilder(); if (habbo.CurrentRoom != null) { builder.AppendFormat(" - ROOM INFORMATION [{0}] - \r", habbo.CurrentRoom.RoomId); builder.AppendFormat("Owner: {0}\r", habbo.CurrentRoom.RoomData.Owner); builder.AppendFormat("Room Name: {0}\r", habbo.CurrentRoom.RoomData.Name); builder.Append( string.Concat("Current Users: ", habbo.CurrentRoom.UserCount, "/", habbo.CurrentRoom.RoomData.UsersMax)); } session.SendNotif(string.Concat("User info for: ", userName, " \rUser ID: ", habbo.Id, ":\rRank: ", habbo.Rank, "\rCurrentTalentLevel: ", habbo.CurrentTalentLevel, " \rCurrent Room: ", habbo.CurrentRoomId, " \rCredits: ", habbo.Credits, "\rDuckets: ", habbo.ActivityPoints, "\rDiamonds: ", habbo.Diamonds, "\rMuted: ", habbo.Muted.ToString(), "\r\r\r", builder.ToString())); return(true); }
/// <summary> /// Adds the user score. /// </summary> /// <param name="item">The item.</param> /// <param name="username">The username.</param> /// <param name="score">The score.</param> internal void AddUserScore(RoomItem item, string username, int score) { using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor()) { if (item.GetBaseItem().Name.StartsWith("highscore_classic")) { queryReactor.SetQuery( "INSERT INTO items_highscores (item_id,username,score) VALUES (@itemid,@username,@score)"); queryReactor.AddParameter("itemid", item.Id); queryReactor.AddParameter("username", username); queryReactor.AddParameter("score", score); queryReactor.RunQuery(); } else if (item.GetBaseItem().Name.StartsWith("highscore_mostwin")) { score = 1; queryReactor.SetQuery( "SELECT id,score FROM items_highscores WHERE username = @username AND item_id = @itemid"); queryReactor.AddParameter("itemid", item.Id); queryReactor.AddParameter("username", username); DataRow row = queryReactor.GetRow(); if (row != null) { queryReactor.SetQuery( "UPDATE items_highscores SET score = score + 1 WHERE username = @username AND item_id = @itemid"); queryReactor.AddParameter("itemid", item.Id); queryReactor.AddParameter("username", username); queryReactor.RunQuery(); Lines.Remove((int)row["id"]); score = (int)row["score"] + 1; } else { queryReactor.SetQuery( "INSERT INTO items_highscores (item_id,username,score) VALUES (@itemid,@username,@score)"); queryReactor.AddParameter("itemid", item.Id); queryReactor.AddParameter("username", username); queryReactor.AddParameter("score", score); queryReactor.RunQuery(); } } LastId++; Lines.Add(LastId, new HighScoreLine(username, score)); } }
public void RefreshCompetitions() { Competition = null; using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor()) { queryReactor.SetQuery("SELECT * FROM rooms_competitions WHERE enabled = '1' LIMIT 1"); DataRow row = queryReactor.GetRow(); if (row == null) { return; } Competition = new RoomCompetition((int)row["id"], (string)row["name"], (string)row["required_furnis"]); } }
public static int GetLinkedTele(int TeleId) { using (IQueryAdapter queryreactor = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor()) { queryreactor.SetQuery("SELECT tele_two_id FROM tele_links WHERE tele_one_id = " + TeleId); DataRow row = queryreactor.GetRow(); if (row == null) { return(0); } else { return(Convert.ToInt32(row[0])); } } }
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet) { int ItemId = Packet.PopInt(); int SpriteId = Packet.PopInt(); DataRow Row = null; using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `avgprice` FROM `catalog_marketplace_data` WHERE `sprite` = @SpriteId LIMIT 1"); dbClient.AddParameter("SpriteId", SpriteId); Row = dbClient.GetRow(); } Session.SendPacket(new MarketplaceItemStatsComposer(ItemId, SpriteId, (Row != null ? Convert.ToInt32(Row["avgprice"]) : 0))); }
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom) { dbClient.SetQuery("SELECT trigger_data, trigger_data_2 FROM wired_items WHERE trigger_id = @id "); dbClient.AddParameter("id", this.itemID); DataRow row = dbClient.GetRow(); if (row == null) { return; } this.message = row["trigger_data"].ToString(); int result; this.Delay = (int.TryParse(row["trigger_data_2"].ToString(), out result)) ? result : 0; }
public static SmallPromo load(int index) { DataRow dRow; using (IQueryAdapter DbClient = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor()) { DbClient.SetQuery("SELECT hotelview_promos.`index`,hotelview_promos.header,hotelview_promos.body,hotelview_promos.button,hotelview_promos.in_game_promo,hotelview_promos.special_action," + "hotelview_promos.image,hotelview_promos.enabled FROM hotelview_promos WHERE hotelview_promos.`index` = @x LIMIT 1"); DbClient.AddParameter("x", index); dRow = DbClient.GetRow(); } SmallPromo newPromo = new SmallPromo(index, (string)dRow[1], (string)dRow[2], (string)dRow[3], Convert.ToInt32(dRow[4]), (string)dRow[5], (string)dRow[6]); return(newPromo); }
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom) { dbClient.SetQuery("SELECT trigger_data, trigger_data_2, triggers_item FROM wired_items WHERE trigger_id = @id "); dbClient.AddParameter("id", this.itemID); DataRow row = dbClient.GetRow(); this.Delay = 20; if (row == null) { return; } int result; this.Delay = (int.TryParse(row["trigger_data"].ToString(), out result)) ? result : 20; string itemslist = row["triggers_item"].ToString(); string data2 = row["trigger_data_2"].ToString(); if (data2.Length == 5) { this.EtatActuel = Convert.ToInt32(data2.Split(';')[0]); this.DirectionActuel = Convert.ToInt32(data2.Split(';')[1]); this.PositionActuel = Convert.ToInt32(data2.Split(';')[2]); } if (itemslist == "") { return; } foreach (string item in itemslist.Split(';')) { string[] Item2 = item.Split(':'); if (Item2.Length != 6) { continue; } Item roomItem = insideRoom.GetRoomItemHandler().GetItem(Convert.ToInt32(Item2[0])); if (roomItem != null && !this.items.ContainsKey(roomItem.Id) && roomItem.Id != this.itemID) { this.items.TryAdd(roomItem.Id, new ItemsPosReset(roomItem, Convert.ToInt32(Item2[1]), Convert.ToInt32(Item2[2]), Convert.ToDouble(Item2[3]), Convert.ToInt32(Item2[4]), Item2[5])); } } }
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom) { dbClient.SetQuery("SELECT trigger_data, trigger_data_2 FROM wired_items WHERE trigger_id = @id "); dbClient.AddParameter("id", this.itemID); DataRow row = dbClient.GetRow(); if (row != null) { this.maxCountPerGame = Convert.ToInt32(row[0].ToString()); this.scoreToGive = Convert.ToInt32(row[1].ToString()); } else { this.maxCountPerGame = 0; this.scoreToGive = 0; } }
/// <summary> /// Loads the reward. /// </summary> private void LoadReward() { using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor()) { queryReactor.SetQuery("SELECT hotelview_rewards_promos.furni_id, hotelview_rewards_promos.furni_name FROM hotelview_rewards_promos WHERE hotelview_rewards_promos.enabled = 1 LIMIT 1"); DataRow row = queryReactor.GetRow(); if (row == null) { return; } FurniRewardId = Convert.ToInt32(row[0]); FurniRewardName = Convert.ToString(row[1]); } }
public UserCache GenerateUser(int id) { UserCache user = null; if (_usersCached.ContainsKey(id)) { if (TryGetUser(id, out user)) { return(user); } } GameClient client = PlusEnvironment.GetGame().GetClientManager().GetClientByUserId(id); if (client != null) { if (client.Habbo != null) { user = new UserCache(id, client.Habbo.Username, client.Habbo.Motto, client.Habbo.Look); _usersCached.TryAdd(id, user); return(user); } } /* * TODO: Make this asynchronous! * user = await _dao.GetUserCache(id); * if (user != null) _usersCached.TryAdd(id, user);*/ using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `username`, `motto`, `look` FROM users WHERE id = @id LIMIT 1"); dbClient.AddParameter("id", id); DataRow dRow = dbClient.GetRow(); if (dRow != null) { user = new UserCache(id, dRow["username"].ToString(), dRow["motto"].ToString(), dRow["look"].ToString()); _usersCached.TryAdd(id, user); } } return(user); }
public static ServerPacket SerializeRoomTool(RoomData Data) { Room room = ButterflyEnvironment.GetGame().GetRoomManager().GetRoom(Data.Id); int i = 0; using (IQueryAdapter queryreactor = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor()) { try { queryreactor.SetQuery("SELECT id FROM users WHERE username = @owner"); queryreactor.AddParameter("owner", Data.OwnerName); i = Convert.ToInt32(queryreactor.GetRow()[0]); } catch (Exception ex) { Logging.HandleException(ex, "ModerationTool.SerializeRoomTool"); } } ServerPacket serverMessage = new ServerPacket(ServerPacketHeader.ModeratorRoomInfoMessageComposer); serverMessage.WriteInteger(Data.Id); serverMessage.WriteInteger(Data.UsersNow); if (room != null) { serverMessage.WriteBoolean(room.GetRoomUserManager().GetRoomUserByHabbo(Data.OwnerName) != null); } else { serverMessage.WriteBoolean(false); } serverMessage.WriteInteger(i); serverMessage.WriteString(Data.OwnerName); serverMessage.WriteBoolean(room != null); if (room != null) { serverMessage.WriteString(Data.Name); serverMessage.WriteString(Data.Description); serverMessage.WriteInteger(Data.TagCount); foreach (string s in Data.Tags) { serverMessage.WriteString(s); } } return(serverMessage); }
public void LoadPromotions() { DataRow GetPromotion = null; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT * FROM `room_promotions` WHERE `room_id` = " + Id + " LIMIT 1;"); GetPromotion = dbClient.GetRow(); if (GetPromotion != null) { if (Convert.ToDouble(GetPromotion["timestamp_expire"]) > Plus.Utilities.UnixTimestamp.GetNow()) { this._promotion = new RoomPromotion(Convert.ToString(GetPromotion["title"]), Convert.ToString(GetPromotion["description"]), Convert.ToDouble(GetPromotion["timestamp_start"]), Convert.ToDouble(GetPromotion["timestamp_expire"]), Convert.ToInt32(GetPromotion["category_id"])); } } } }
public static ServerPacket SerializeUserInfo(int UserId) { GameClient User = ButterflyEnvironment.GetGame().GetClientManager().GetClientByUserID(UserId); DataRow row1 = null; if (User == null) { using (IQueryAdapter queryreactor = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor()) { queryreactor.SetQuery("SELECT id, username FROM users WHERE id = " + UserId); row1 = queryreactor.GetRow(); } if (row1 == null) { return(null); } } ServerPacket serverMessage = new ServerPacket(ServerPacketHeader.ModeratorUserInfoMessageComposer); serverMessage.WriteInteger((row1 == null) ? User.GetHabbo().Id : Convert.ToInt32(row1["id"])); serverMessage.WriteString((row1 == null) ? User.GetHabbo().Username : (string)row1["username"]); serverMessage.WriteString("Unknown"); serverMessage.WriteInteger(0); serverMessage.WriteInteger(0); serverMessage.WriteBoolean(User != null); serverMessage.WriteInteger(0); serverMessage.WriteInteger(0); serverMessage.WriteInteger(0); serverMessage.WriteInteger(0); serverMessage.WriteInteger(0); // trading_lock_count_txt serverMessage.WriteString(""); serverMessage.WriteString(""); serverMessage.WriteInteger(0); serverMessage.WriteInteger(0); serverMessage.WriteString("Unknown"); serverMessage.WriteString(""); // ??? return(serverMessage); }
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom) { string triggerdata = null; dbClient.SetQuery("SELECT trigger_data FROM wired_items WHERE trigger_id = @id"); dbClient.AddParameter("id", this.item.Id); DataRow row = dbClient.GetRow(); if (row != null) { triggerdata = row["trigger_data"].ToString(); } if (string.IsNullOrEmpty(triggerdata)) { return; } foreach (string score in triggerdata.Split(';')) { //:lucie:42 string[] score2 = score.Split(':'); int ScoreNum = 0; int.TryParse(score2[score2.Count() - 1], out ScoreNum); string Pseudo = ""; for (int i = 0; i < score2.Count() - 1; i++) { if (i == 0) { Pseudo = score2[i]; } else { Pseudo += ':' + score2[i]; } } //List<string> ListUsernameScore = new List<string>() { score2[0] }; if (!this.item.Scores.ContainsKey(Pseudo)) { this.item.Scores.Add(Pseudo, ScoreNum); } } }