public void UpdateHobbies(SqlDatabaseClient MySqlClient, uint LabelId, string mHobby) { switch (LabelId) { case 1: this.string_5 = mHobby; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("Hobby", this.string_5); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET hobby_1 = @Hobby WHERE id = @id LIMIT 1"); return; case 2: this.string_6 = mHobby; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("Hobby", this.string_6); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET hobby_2 = @Hobby WHERE id = @id LIMIT 1"); return; case 3: this.string_7 = mHobby; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("Hobby", this.string_7); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET hobby_3 = @Hobby WHERE id = @id LIMIT 1"); return; } this.string_5 = mHobby; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("Hobby", this.string_5); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET hobby_1 = @Hobby WHERE id = @id LIMIT 1"); }
public void UpdateIcon(int Background, int Foreground, Dictionary <int, int> Objects) { lock (mSyncRoot) { mIcon = new RoomIcon(Background, Foreground, Objects); using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("id", mId); MySqlClient.SetParameter("icon", mIcon.Serialize()); MySqlClient.ExecuteNonQuery("UPDATE rooms SET icon = @icon WHERE id = @id LIMIT 1"); } } }
public void AddToQuantity() { lock (mSyncRoot) { mQuantity++; using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("id", mId); MySqlClient.SetParameter("quantity", mQuantity); MySqlClient.ExecuteNonQuery("UPDATE avatar_effects SET quantity = @quantity WHERE id = @id LIMIT 1"); } } }
public void UpdateVotes(SqlDatabaseClient MySqlClient, uint ColorId, int Vote) { switch (ColorId) { case 1: this.int_12 += Vote; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("GreenVotes", this.int_12); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET votos_legal = @GreenVotes WHERE id = @id LIMIT 1"); return; case 2: this.int_13 += Vote; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("BlueVotes", this.int_13); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET votos_sexy = @BlueVotes WHERE id = @id LIMIT 1"); return; case 3: this.int_14 += Vote; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("OrangeVotes", this.int_14); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET votos_simpatico = @OrangeVotes WHERE id = @id LIMIT 1"); return; } this.int_12 += Vote; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("GreenVotes", this.int_12); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET votos_legal = @GreenVotes WHERE id = @id LIMIT 1"); }
public void DoActorCountSync() { int NewActorCount = HumanActorCount; using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("id", RoomId); MySqlClient.SetParameter("usercount", NewActorCount); MySqlClient.ExecuteNonQuery("UPDATE rooms SET current_users = @usercount WHERE id = @id LIMIT 1"); } mCachedNavigatorUserCount = NewActorCount; mActorCountSyncNeeded = false; }
public void IncreaseScore() { lock (mSyncRoot) { mScore++; using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("id", mId); MySqlClient.SetParameter("score", mScore); MySqlClient.ExecuteNonQuery("UPDATE rooms SET score = @score WHERE id = @id LIMIT 1"); } } }
public void UpdateWishes(SqlDatabaseClient MySqlClient, uint LabelId, string mWish) { switch (LabelId) { case 1: this.string_8 = mWish; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("Wish", this.string_8); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET deseo_1 = @Wish WHERE id = @id LIMIT 1"); return; case 2: this.string_9 = mWish; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("Wish", this.string_9); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET deseo_2 = @Wish WHERE id = @id LIMIT 1"); return; case 3: this.string_10 = mWish; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("Wish", this.string_10); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET deseo_3 = @Wish WHERE id = @id LIMIT 1"); return; } this.string_8 = mWish; MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("Wish", this.string_8); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET deseo_1 = @Wish WHERE id = @id LIMIT 1"); }
public void EditSpace(string Name, string Description, SpaceAccessType AccessType, string Password, bool AllowUppercuts, bool AllowCoconuts, List <string> WhiteList, List <string> BlackList) { lock (this.object_0) { this.string_0 = Name; this.string_1 = Description; this.spaceAccessType_0 = AccessType; this.string_3 = Password; this.bool_1 = AllowUppercuts; this.bool_0 = AllowCoconuts; this.list_0 = WhiteList; this.list_1 = BlackList; using (SqlDatabaseClient client = SqlDatabaseManager.GetClient()) { StringBuilder builder = new StringBuilder(); StringBuilder builder2 = new StringBuilder(); foreach (string str in WhiteList) { if (builder.Length > 0) { builder.Append(","); } builder.Append(str); } foreach (string str2 in BlackList) { if (builder2.Length > 0) { builder2.Append(","); } builder.Append(str2); } string str3 = "open"; if (this.spaceAccessType_0 == SpaceAccessType.PasswordProtected) { str3 = "password"; } else if (this.spaceAccessType_0 == SpaceAccessType.Locked) { str3 = "lock"; } client.SetParameter("id", this.uint_0); client.SetParameter("name", this.string_0); client.SetParameter("description", this.string_1); client.SetParameter("accesstype", str3); client.SetParameter("password", this.string_3); client.SetParameter("whitelist", builder); client.SetParameter("blacklist", builder2); client.SetParameter("allowuppercuts", this.bool_1 ? "1" : "0"); client.SetParameter("allowcoconuts", this.bool_0 ? "1" : "0"); client.ExecuteNonQuery("UPDATE escenarios SET nombre = @name, descripcion = @description, acceso = @accesstype, password = @password, lista_verde = @whitelist, lista_negra = @blacklist, permitir_upper = @allowuppercuts, permitir_coco = @allowcoconuts WHERE id = @id LIMIT 1"); } } }
public void AssignTo(SqlDatabaseClient MySqlClient, uint ModeratorId) { if (mStatus > ModerationTicketStatus.Assigned) { return; } mModeratorUserId = ModeratorId; mStatus = (ModeratorId > 0 ? ModerationTicketStatus.Assigned : ModerationTicketStatus.OpenTicket); MySqlClient.SetParameter("id", mId); MySqlClient.SetParameter("status", (ModeratorId > 0 ? (int)ModerationTicketStatus.Assigned : (int)ModerationTicketStatus.OpenTicket).ToString()); MySqlClient.SetParameter("moderatorid", ModeratorId); MySqlClient.ExecuteNonQuery("UPDATE moderation_tickets SET status = @status, moderator_user_id = @moderatorid WHERE id = @id LIMIT 1"); }
public void Activate() { lock (mSyncRoot) { mActivated = true; mTimestampActivated = UnixTimestamp.GetCurrent(); using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("id", mId); MySqlClient.SetParameter("timestamp", mTimestampActivated); MySqlClient.ExecuteNonQuery("UPDATE avatar_effects SET activated = '1', timestamp_activated = @timestamp WHERE id = @id LIMIT 1"); } } }
public void UpdateUppercuts(SqlDatabaseClient MySqlClient, bool Sent) { if (Sent) { this.int_6++; } else { this.int_11++; } MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("SentUppercuts", this.int_6); MySqlClient.SetParameter("ReceivedUppercuts", this.int_11); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET uppercuts_enviados = @SentUppercuts, uppercuts_recibidos = @ReceivedUppercuts WHERE id = @id LIMIT 1"); }
public static uint CreateRoom(uint OwnerId, string Name, string Model) { string Result = string.Empty; using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("type", "flat"); MySqlClient.SetParameter("ownerid", OwnerId); MySqlClient.SetParameter("name", Name); MySqlClient.SetParameter("model", Model); Result = MySqlClient.ExecuteScalar("INSERT INTO rooms (type,owner_id,name,model) VALUES (@type,@ownerid,@name,@model); SELECT LAST_INSERT_ID();").ToString(); } return(Result == string.Empty ? 0 : uint.Parse(Result)); }
public void UpdateKisses(SqlDatabaseClient MySqlClient, bool Sent) { if (Sent) { this.int_2++; } else { this.int_7++; } MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("SentKisses", this.int_2); MySqlClient.SetParameter("ReceivedKisses", this.int_7); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET besos_enviados = @SentKisses, besos_recibidos = @ReceivedKisses WHERE id = @id LIMIT 1"); }
public void UpdateRoses(SqlDatabaseClient MySqlClient, bool Sent) { if (Sent) { this.int_4++; } else { this.int_9++; } MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("SentRoses", this.int_4); MySqlClient.SetParameter("ReceivedRoses", this.int_9); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET flores_enviadas = @SentRoses, flores_recibidas = @ReceivedRoses WHERE id = @id LIMIT 1"); }
public void UpdateCoconuts(SqlDatabaseClient MySqlClient, bool Sent) { if (Sent) { this.int_5++; } else { this.int_10++; } MySqlClient.SetParameter("id", this.uint_0); MySqlClient.SetParameter("SentCoconuts", this.int_5); MySqlClient.SetParameter("ReceivedCoconuts", this.int_10); MySqlClient.ExecuteNonQuery("UPDATE usuarios SET cocos_enviados = @SentCoconuts, cocos_recibidos = @ReceivedCoconuts WHERE id = @id LIMIT 1"); }
public static List <uint> GetFriendsForUser(SqlDatabaseClient MySqlClient, uint UserId, int Confirmed) { List <uint> Friends = new List <uint>(); MySqlClient.SetParameter("id", UserId); MySqlClient.SetParameter("confirmed", Confirmed); DataTable Table = MySqlClient.ExecuteQueryTable("SELECT user_2_id FROM messenger_friendships WHERE user_1_id = @id AND confirmed = @confirmed"); foreach (DataRow Row in Table.Rows) { Friends.Add((uint)Row[0]); } return(Friends); }
public void Unmute(SqlDatabaseClient MySqlClient) { mModerationMutedUntil = 0; MySqlClient.SetParameter("id", mId); MySqlClient.ExecuteNonQuery("UPDATE characters SET moderation_muted_until_timestamp = 0 WHERE id = @id LIMIT 1"); }
public void Expire() { mHcTime = PastHcTime; mVipTime = PastVipTime; mBaseLevel = ClubSubscriptionLevel.None; mTimestampCreated = 0; mTimestampExpire = 0; using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("userid", mUserId); MySqlClient.SetParameter("hctime", mHcTime); MySqlClient.SetParameter("viptime", mVipTime); MySqlClient.ExecuteNonQuery("UPDATE user_subscriptions SET subscription_level = '0', timestamp_created = 0, timestamp_expire = 0 WHERE user_id = @userid LIMIT 1"); } }
private static void PerformDatabaseCleanup(SqlDatabaseClient MySqlClient) { MySqlClient.ExecuteNonQuery("UPDATE rooms SET current_users = 0"); MySqlClient.SetParameter("timestamp", UnixTimestamp.GetCurrent()); MySqlClient.ExecuteNonQuery("UPDATE room_visits SET timestamp_left = @timestamp WHERE timestamp_left = 0"); MySqlClient.ExecuteNonQuery("UPDATE characters SET auth_ticket = ''"); }
public static void ReloadCache(SqlDatabaseClient MySqlClient) { lock (mSyncRoot) { mCharacterBlacklist.Clear(); mRemoteAddressBlacklist.Clear(); MySqlClient.SetParameter("timestamp", UnixTimestamp.GetCurrent()); DataTable Table = MySqlClient.ExecuteQueryTable("SELECT * FROM bans WHERE timestamp_expire > @timestamp"); foreach (DataRow Row in Table.Rows) { uint UserId = (uint)Row["user_id"]; string RemoteAddr = (string)Row["remote_address"]; if (UserId > 0 && !mCharacterBlacklist.Contains(UserId)) { mCharacterBlacklist.Add(UserId); } if (RemoteAddr.Length > 0 && !mRemoteAddressBlacklist.Contains(RemoteAddr)) { mRemoteAddressBlacklist.Add(RemoteAddr); } } } }
public static SpaceInfo GetSpaceInfo(uint SpaceId, bool IgnoreCache) { SpaceInstance instanceBySpaceId = SpaceManager.GetInstanceBySpaceId(SpaceId); if (instanceBySpaceId != null) { return(instanceBySpaceId.Info); } if (!IgnoreCache) { SpaceInfo info = smethod_1(SpaceId); if (info != null) { return(info); } } using (SqlDatabaseClient client = SqlDatabaseManager.GetClient()) { client.SetParameter("id", SpaceId); DataRow row = client.ExecuteQueryRow("SELECT * FROM escenarios WHERE id = @id LIMIT 1"); if (row != null) { return(GenerateSpaceInfoFromRow(row)); } } return(null); }
public static VoucherValueData GetVoucherValue(string Code) { using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("code", Code); DataRow Row = MySqlClient.ExecuteQueryRow("SELECT value_credits,value_pixels,value_furni FROM vouchers WHERE code = @code AND enabled = '1' AND uses > 0 LIMIT 1"); if (Row == null) { return(null); } List <uint> FurniValue = new List <uint>(); foreach (string FurniValueBit in Row["value_furni"].ToString().Split(',')) { uint NewValue = 0; uint.TryParse(FurniValueBit, out NewValue); if (NewValue > 0) { FurniValue.Add(NewValue); } } return(new VoucherValueData((int)Row["value_credits"], (int)Row["value_pixels"], FurniValue)); } }
public void MarkUserIgnored(uint UserId) { lock (this.object_0) { if (!this.list_0.Contains(UserId)) { this.list_0.Add(UserId); using (SqlDatabaseClient client = SqlDatabaseManager.GetClient()) { client.SetParameter("user_id", this.uint_0); client.SetParameter("ignore_id", UserId); client.ExecuteNonQuery("INSERT INTO ignorados (id_usuario,id_ignorada) VALUES (@user_id,@ignore_id)"); } } } }
public void MarkUserUnignored(uint UserId) { lock (this.object_0) { if (this.list_0.Contains(UserId)) { this.list_0.Remove(UserId); using (SqlDatabaseClient client = SqlDatabaseManager.GetClient()) { client.SetParameter("user_id", this.uint_0); client.SetParameter("ignore_id", UserId); client.ExecuteNonQuery("DELETE FROM ignorados WHERE id_usuario = @user_id AND id_ignorada = @ignore_id LIMIT 1"); } } } }
public static CharacterInfo GetCharacterInfo(SqlDatabaseClient MySqlClient, uint CharacterId, uint LinkedClientId, bool IgnoreCache) { if (SessionManager.ContainsCharacterId(CharacterId)) { Session Session = SessionManager.GetSessionByCharacterId(CharacterId); return(Session.CharacterInfo); } if (!IgnoreCache) { CharacterInfo CachedInfo = TryGetInfoFromCache(CharacterId); if (CachedInfo != null) { return(CachedInfo); } } MySqlClient.SetParameter("id", CharacterId); DataRow Row = MySqlClient.ExecuteQueryRow("SELECT * FROM characters WHERE id = @id LIMIT 1"); if (Row != null) { return(GenerateCharacterInfoFromRow(MySqlClient, LinkedClientId, Row)); } return(null); }
public void ReloadCache(SqlDatabaseClient MySqlClient) { lock (mInner) { mInner.Clear(); MySqlClient.SetParameter("userid", mCharacterId); DataTable Table = MySqlClient.ExecuteQueryTable("SELECT * FROM items WHERE user_id = @userid"); foreach (DataRow Row in Table.Rows) { Item Item = ItemFactory.CreateFromDatabaseRow(Row); if (Item == null || Item.Definition == null || Item.InSoundManager) { continue; } if (Item.PendingExpiration && Item.ExpireTimeLeft <= 0) { Item.RemovePermanently(MySqlClient); continue; } mInner.Add(Item.Id, Item); } } }
public static RoomInfo GetRoomInfo(uint RoomId, bool IgnoreCache) { RoomInstance Instance = RoomManager.GetInstanceByRoomId(RoomId); if (Instance != null) { return(Instance.Info); } if (!IgnoreCache) { RoomInfo CachedInfo = TryGetInfoFromCache(RoomId); if (CachedInfo != null) { return(CachedInfo); } } using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.SetParameter("id", RoomId); DataRow Row = MySqlClient.ExecuteQueryRow("SELECT * FROM rooms WHERE id = @id LIMIT 1"); if (Row != null) { return(GenerateRoomInfoFromRow(Row)); } } return(null); }
public static uint GetUidFromName(string Name) { lock (dictionary_0) { foreach (KeyValuePair <uint, string> pair in dictionary_0) { if (pair.Value.ToLower() == Name.ToLower()) { return(pair.Key); } } using (SqlDatabaseClient client = SqlDatabaseManager.GetClient()) { client.SetParameter("username", Name); object obj2 = client.ExecuteScalar("SELECT id FROM usuarios WHERE usuario = @username LIMIT 1"); if (obj2 != null) { uint key = (uint)obj2; dictionary_0.Add(key, Name); return(key); } } } return(0); }
public static void DeleteIsland(SqlDatabaseClient MySqlClient, uint IslandId) { MySqlClient.SetParameter("id", IslandId); MySqlClient.ExecuteNonQuery("DELETE FROM escenarios WHERE id = @id LIMIT 1"); SpaceInfoLoader.RemoveFromCache(IslandId); Navigator.ReloadOfficialItems(MySqlClient); }
public static void ReloadCache(SqlDatabaseClient MySqlClient) { lock (object_0) { list_0.Clear(); list_1.Clear(); dictionary_0.Clear(); MySqlClient.SetParameter("timestamp", UnixTimestamp.GetCurrent()); foreach (DataRow row in MySqlClient.ExecuteQueryTable("SELECT * FROM baneos WHERE timestampex > @timestamp OR tipo_baneo > 0").Rows) { uint item = (uint)row["id_usuario"]; uint banType = (uint)row["tipo_baneo"]; string reason = (string)row["detalles"]; string moderator = (string)row["moderador"]; string str3 = (string)row["direccion_ip"]; double timestamp = (double)row["timestamp"]; double timestampEx = (double)row["timestampex"]; if ((item > 0) && !list_0.Contains(item)) { list_0.Add(item); } if ((str3.Length > 0) && !list_1.Contains(str3)) { list_1.Add(str3); } if ((item > 0) && !dictionary_0.ContainsKey(item)) { dictionary_0.Add(item, new BanDetails(item, banType, reason, timestamp, timestampEx, moderator)); } } } }