public BadgeCache(SqlDatabaseClient MySqlClient, uint UserId, AchievementCache UserAchievementCache)
{
mUserId = UserId;
mSyncRoot = new object();
mEquippedBadges = new Dictionary<int, Badge>();
mStaticBadges = new List<Badge>();
mAchievementBadges = new Dictionary<string, Badge>();
mIndexCache = new List<string>();
ReloadCache(MySqlClient, UserAchievementCache);
}
public void TryAuthenticate(string Ticket, string RemoteAddress)
{
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
uint AuthedUid = SingleSignOnAuthenticator.TryAuthenticate(MySqlClient, Ticket, RemoteAddress);
if (AuthedUid <= 0)
{
SessionManager.StopSession(mId);
return;
}
CharacterInfo Info = CharacterInfoLoader.GetCharacterInfo(MySqlClient, AuthedUid, mId, true);
if (Info == null || !Info.HasLinkedSession) // not marked online = CharacterInfoLoader failed somehow
{
SessionManager.StopSession(mId);
return;
}
mCharacterInfo = Info;
mAchieventCache = new AchievementCache(MySqlClient, CharacterId);
mBadgeCache = new BadgeCache(MySqlClient, CharacterId, mAchieventCache);
RightsManager.CleanBadges(mCharacterInfo.Rank, this);
if (!HasRight("login"))
{
SessionManager.StopSession(mId);
return;
}
mCharacterInfo.TimestampLastOnline = UnixTimestamp.GetCurrent();
CharacterResolverCache.AddToCache(mCharacterInfo.Id, mCharacterInfo.Username, true);
mMessengerFriendCache = new SessionMessengerFriendCache(MySqlClient, CharacterId);
mFavoriteRoomsCache = new FavoriteRoomsCache(MySqlClient, CharacterId);
mRatedRoomsCache = new RatedRoomsCache();
mInventoryCache = new InventoryCache(MySqlClient, CharacterId);
mIgnoreCache = new UserIgnoreCache(MySqlClient, CharacterId);
mNewItemsCache = new NewItemsCache(MySqlClient, CharacterId);
mAvatarEffectCache = new AvatarEffectCache(MySqlClient, CharacterId);
mQuestCache = new QuestCache(MySqlClient, CharacterId);
mPetCache = new PetInventoryCache(MySqlClient, CharacterId);
// Subscription manager
MySqlClient.SetParameter("userid", CharacterId);
DataRow Row = MySqlClient.ExecuteQueryRow("SELECT * FROM user_subscriptions WHERE user_id = @userid");
mSubscriptionManager = (Row != null ? new ClubSubscription(CharacterId,
(ClubSubscriptionLevel)int.Parse((Row["subscription_level"].ToString())), (double)Row["timestamp_created"],
(double)Row["timestamp_expire"], (double)Row["past_time_hc"], (double)Row["past_time_vip"]) :
new ClubSubscription(CharacterId, ClubSubscriptionLevel.None, 0, 0, 0, 0));
if (mSubscriptionManager.SubscriptionLevel < ClubSubscriptionLevel.VipClub)
{
mBadgeCache.DisableSubscriptionBadge("ACH_VipClub");
}
if (mSubscriptionManager.SubscriptionLevel < ClubSubscriptionLevel.BasicClub)
{
mBadgeCache.DisableSubscriptionBadge("ACH_BasicClub");
}
if (mCharacterInfo.IsPremium)
{
ServerMessage Welcome = new ServerMessage(575);
Welcome.AppendInt32(1);
Welcome.AppendInt32(0);
Welcome.AppendInt32(1);
SendData(Welcome);
}
mAvatarEffectCache.CheckEffectExpiry(this);
mAuthProcessed = true;
SendData(AuthenticationOkComposer.Compose());
SendData(FuseRightsListComposer.Compose(this));
SendData(UserHomeRoomComposer.Compose(mCharacterInfo.HomeRoom));
SendData(UserEffectListComposer.Compose(AvatarEffectCache.Effects));
SendData(NavigatorFavoriteRoomsComposer.Compose(FavoriteRoomsCache.FavoriteRooms));
SendData(InventoryNewItemsComposer.Compose(NewItemsCache.NewItems));
SendData(AchievementDataListComposer.Compose(AchievementManager.Achievements.Values.ToList()));
SendData(AvailabilityStatusMessageComposer.Compose());
SendData(InfoFeedEnableMessageComposer.Compose(1));
SendData(ActivityPointsMessageComposer.Compose());
if (HasRight("moderation_tool"))
{
SendData(ModerationToolComposer.Compose(this, ModerationPresets.UserMessagePresets,
ModerationPresets.UserActionPresets, ModerationPresets.RoomMessagePresets));
foreach (ModerationTicket ModTicket in ModerationTicketManager.ActiveTickets)
{
SendData(ModerationTicketComposer.Compose(ModTicket));
}
}
MessengerHandler.MarkUpdateNeeded(this, 0, true);
}
}
public void ReloadCache(SqlDatabaseClient MySqlClient, AchievementCache UserAchievementCache)
{
Dictionary<int, Badge> EquippedBadges = new Dictionary<int, Badge>();
List<Badge> StaticBadges = new List<Badge>();
Dictionary<string, Badge> AchievementBadges = new Dictionary<string, Badge>();
List<string> IndexCache = new List<string>();
MySqlClient.SetParameter("userid", mUserId);
DataTable Table = MySqlClient.ExecuteQueryTable("SELECT badge_code,slot_id,source_type,source_data FROM user_badges WHERE user_id = @userid");
foreach (DataRow Row in Table.Rows)
{
string SourceType = Row["source_type"].ToString();
string SourceData = Row["source_data"].ToString();
Badge BadgeToEquip = null;
if (SourceType == "static")
{
BadgeToEquip = new Badge(Row["badge_code"].ToString());
StaticBadges.Add(BadgeToEquip);
}
else if (SourceType == "achievement")
{
if (AchievementBadges.ContainsKey(SourceData))
{
continue;
}
UserAchievement UserAchievement = UserAchievementCache.GetAchievementData(SourceData);
if (UserAchievement == null || UserAchievement.Level < 1)
{
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.SetParameter("badgecode", Row["badge_code"].ToString());
MySqlClient.ExecuteNonQuery("DELETE FROM user_badges WHERE user_id = @userid AND badge_id = @badgeid");
continue;
}
string Code = UserAchievement.GetBadgeCodeForLevel();
BadgeToEquip = new Badge(Code);
AchievementBadges.Add(SourceData, BadgeToEquip);
}
if (BadgeToEquip != null)
{
int SlotId = (int)Row["slot_id"];
if (!EquippedBadges.ContainsKey(SlotId) && SlotId >= 1 && SlotId <= 5)
{
EquippedBadges.Add(SlotId, BadgeToEquip);
}
IndexCache.Add(BadgeToEquip.Code);
}
}
lock (mSyncRoot)
{
mEquippedBadges = EquippedBadges;
mStaticBadges = StaticBadges;
mAchievementBadges = AchievementBadges;
mIndexCache = IndexCache;
}
}
public void TryAuthenticate(string Ticket, string RemoteAddress)
{
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
uint AuthedUid = SingleSignOnAuthenticator.TryAuthenticate(MySqlClient, Ticket, RemoteAddress);
if (AuthedUid <= 0)
{
SessionManager.StopSession(mId);
return;
}
CharacterInfo Info = CharacterInfoLoader.GetCharacterInfo(MySqlClient, AuthedUid, mId, true);
if (Info == null || !Info.HasLinkedSession) // not marked online = CharacterInfoLoader failed somehow
{
SessionManager.StopSession(mId);
return;
}
mCharacterInfo = Info;
mAchieventCache = new AchievementCache(MySqlClient, CharacterId);
mBadgeCache = new BadgeCache(MySqlClient, CharacterId, mAchieventCache);
if (!HasRight("login"))
{
SessionManager.StopSession(mId);
return;
}
mCharacterInfo.TimestampLastOnline = UnixTimestamp.GetCurrent();
CharacterResolverCache.AddToCache(mCharacterInfo.Id, mCharacterInfo.Username, true);
mMessengerFriendCache = new SessionMessengerFriendCache(MySqlClient, CharacterId);
mFavoriteRoomsCache = new FavoriteRoomsCache(MySqlClient, CharacterId);
mRatedRoomsCache = new RatedRoomsCache();
mInventoryCache = new InventoryCache(MySqlClient, CharacterId);
mIgnoreCache = new UserIgnoreCache(MySqlClient, CharacterId);
mNewItemsCache = new NewItemsCache(MySqlClient, CharacterId);
mAvatarEffectCache = new AvatarEffectCache(MySqlClient, CharacterId);
mQuestCache = new QuestCache(MySqlClient, CharacterId);
mPetCache = new PetInventoryCache(MySqlClient, CharacterId);
// Subscription manager
MySqlClient.SetParameter("userid", CharacterId);
DataRow Row = MySqlClient.ExecuteQueryRow("SELECT * FROM user_subscriptions WHERE user_id = @userid");
mSubscriptionManager = (Row != null ? new ClubSubscription(CharacterId,
(ClubSubscriptionLevel)int.Parse((Row["subscription_level"].ToString())), (double)Row["timestamp_created"],
(double)Row["timestamp_expire"], (double)Row["past_time_hc"], (double)Row["past_time_vip"]) :
new ClubSubscription(CharacterId, ClubSubscriptionLevel.None, 0, 0, 0, 0));
if (mSubscriptionManager.SubscriptionLevel < ClubSubscriptionLevel.VipClub)
{
mBadgeCache.DisableSubscriptionBadge("ACH_VipClub");
}
if (mSubscriptionManager.SubscriptionLevel < ClubSubscriptionLevel.BasicClub)
{
mBadgeCache.DisableSubscriptionBadge("ACH_BasicClub");
}
mAvatarEffectCache.CheckEffectExpiry(this);
mAuthProcessed = true;
SendData(AuthenticationOkComposer.Compose());
SendData(FuseRightsListComposer.Compose(this));
SendData(UserHomeRoomComposer.Compose(mCharacterInfo.HomeRoom));
SendData(UserEffectListComposer.Compose(AvatarEffectCache.Effects));
SendData(NavigatorFavoriteRoomsComposer.Compose(FavoriteRoomsCache.FavoriteRooms));
SendData(InventoryNewItemsComposer.Compose(NewItemsCache.NewItems));
SendData(MessageOfTheDayComposer.Compose("Welcome to uberHotel.org BETA.\n\n\nThank you for participating in the uberHotel.org BETA test. We hope to gather relevant feedback and ideas to help make this hotel into a success.\n\nPlease submit any bugs, feedback, or ideas via:\nhttp://snowlight.uservoice.com\n\n\nHave fun, and thank you for joining us!"));
SendData(AchievementDataListComposer.Compose(AchievementManager.Achievements.Values.ToList()));
// This is available status packet (AvailabilityStatusMessageComposer)
ServerMessage UnkMessage2 = new ServerMessage(290);
UnkMessage2.AppendInt32(1);
UnkMessage2.AppendInt32(0);
SendData(UnkMessage2);
// This is info feed packet (InfoFeedEnableMessageComposer)
ServerMessage UnkMessage3 = new ServerMessage(517);
UnkMessage3.AppendInt32(1); // 1 = enabled 0 = disabled (true/false)
SendData(UnkMessage3);
// This is activity points message (ActivityPointsMessageComposer) not sure how this is handled...
ServerMessage UnkMessage4 = new ServerMessage(628);
UnkMessage4.AppendInt32(1);
UnkMessage4.AppendInt32(0);
UnkMessage4.AppendInt32(2971);
SendData(UnkMessage4);
SendData(ClientConfigComposer.Compose(CharacterInfo.ConfigVolume, false));
if (HasRight("moderation_tool"))
{
SendData(ModerationToolComposer.Compose(this, ModerationPresets.UserMessagePresets,
ModerationPresets.UserActionPresets, ModerationPresets.RoomMessagePresets));
foreach (ModerationTicket ModTicket in ModerationTicketManager.ActiveTickets)
{
SendData(ModerationTicketComposer.Compose(ModTicket));
}
}
MessengerHandler.MarkUpdateNeeded(this, 0, true);
}
}