public static void DeleteRoom(SqlDatabaseClient MySqlClient, uint RoomId)
{
MySqlClient.SetParameter("id", RoomId);
MySqlClient.ExecuteNonQuery("DELETE FROM rooms WHERE id = @id LIMIT 1");
MySqlClient.SetParameter("id", RoomId);
MySqlClient.ExecuteNonQuery("DELETE FROM navigator_frontpage WHERE room_id = @id");
RoomInfoLoader.RemoveFromCache(RoomId);
Navigator.ReloadOfficialItems(MySqlClient);
}
public static void CreateFriendship(SqlDatabaseClient MySqlClient, uint UserId1, uint UserId2, bool Confirmed)
{
for (int i = 0; i < (Confirmed ? 2 : 1); i++)
{
MySqlClient.SetParameter("user1", (i == 1 ? UserId1 : UserId2));
MySqlClient.SetParameter("user2", (i == 1 ? UserId2 : UserId1));
MySqlClient.SetParameter("accepted", (int)(Confirmed ? 1 : 0));
MySqlClient.ExecuteNonQuery("INSERT INTO messenger_friendships (user_1_id,user_2_id,confirmed) VALUES (@user1,@user2,@accepted)");
}
}
public static bool DestroyFriendship(SqlDatabaseClient MySqlClient, uint UserId1, uint UserId2)
{
int aff = 0;
for (int i = 0; i < 2; i++)
{
MySqlClient.SetParameter("user1", (i == 1 ? UserId1 : UserId2));
MySqlClient.SetParameter("user2", (i == 1 ? UserId2 : UserId1));
aff += MySqlClient.ExecuteNonQuery("DELETE FROM messenger_friendships WHERE user_1_id = @user1 AND user_2_id = @user2 LIMIT 1");
}
return (aff > 0);
}
public static void BanUser(SqlDatabaseClient MySqlClient, uint UserId, string MessageText, uint ModeratorId, double Length)
{
MySqlClient.SetParameter("userid", UserId);
MySqlClient.SetParameter("reason", MessageText);
MySqlClient.SetParameter("timestamp", UnixTimestamp.GetCurrent());
MySqlClient.SetParameter("timestampex", UnixTimestamp.GetCurrent() + Length);
MySqlClient.SetParameter("moderator", ModeratorId);
MySqlClient.ExecuteNonQuery("INSERT INTO bans (user_id,reason_text,timestamp_created,timestamp_expire,moderator_id) VALUES (@userid,@reason,@timestamp,@timestampex,@moderator)");
lock (mSyncRoot)
{
mCharacterBlacklist.Add(UserId);
}
}
public void AddOrUpdateData(SqlDatabaseClient MySqlClient, uint QuestId, int Progress, bool ActiveQuest)
{
if (ActiveQuest)
{
if (mCurrentQuest > 0)
{
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.SetParameter("questid", mCurrentQuest);
MySqlClient.ExecuteNonQuery("UPDATE user_quests SET is_current = '0' WHERE user_id = @userid AND quest_id = @questid LIMIT 1");
}
mCurrentQuest = QuestId;
}
else if (mCurrentQuest == QuestId)
{
mCurrentQuest = 0;
}
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.SetParameter("questid", QuestId);
MySqlClient.SetParameter("progress", Progress);
MySqlClient.SetParameter("iscurrent", ActiveQuest ? "1" : "0");
lock (mSyncRoot)
{
if (mInner.ContainsKey(QuestId))
{
mInner[QuestId] = Progress;
MySqlClient.ExecuteNonQuery("UPDATE user_quests SET progress = @progress, is_current = @iscurrent WHERE user_id = @userid AND quest_id = @questid LIMIT 1");
}
else
{
mInner.Add(QuestId, Progress);
MySqlClient.ExecuteNonQuery("INSERT INTO user_quests (user_id,quest_id,progress,is_current) VALUES (@userid,@questid,@progress,@iscurrent)");
}
}
}
public void AddOrUpdateData(SqlDatabaseClient MySqlClient, string Group, int Level, int Progress)
{
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.SetParameter("group", Group);
MySqlClient.SetParameter("level", Level);
MySqlClient.SetParameter("progress", Progress);
lock (mSyncRoot)
{
if (mInner.ContainsKey(Group))
{
mInner[Group].Level = Level;
mInner[Group].Progress = Progress;
MySqlClient.ExecuteNonQuery("UPDATE user_achievements SET level = @level, progress = @progress WHERE user_id = @userid AND group_id = @group LIMIT 1");
}
else
{
mInner.Add(Group, new UserAchievement(Group, Level, Progress));
MySqlClient.ExecuteNonQuery("INSERT INTO user_achievements (user_id,group_id,level,progress) VALUES (@userid,@group,@level,@progress)");
}
}
}
public void UpdateWeed(SqlDatabaseClient MySqlClient, int Amount)
{
mWeed += Amount;
MySqlClient.SetParameter("userid", mId);
MySqlClient.SetParameter("weed", mWeed);
MySqlClient.ExecuteNonQuery("UPDATE characters SET weed = @weed WHERE id = @userid LIMIT 1");
}
public void UpdateWanted(SqlDatabaseClient MySqlClient, int Value)
{
Wanted = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("wanted", Wanted);
MySqlClient.ExecuteNonQuery("UPDATE characters SET wanted = @wanted WHERE id = @id LIMIT 1");
}
public void Stop(SqlDatabaseClient MySqlClient)
{
if (Stopped)
{
return;
}
mSocket.Close();
mSocket = null;
if (Authenticated)
{
mCharacterInfo.SynchronizeStatistics(MySqlClient);
if (CurrentRoomId > 0)
{
RoomManager.RemoveUserFromRoom(this, false);
}
MySqlClient.SetParameter("userid", CharacterId);
MySqlClient.ExecuteNonQuery("UPDATE users SET online = 0 WHERE id = @userid");
MessengerHandler.MarkUpdateNeeded(this, 0, true);
}
Output.WriteLine("Stopped and disconnected client " + Id + ".", OutputLevel.DebugInformation);
mStoppedTimestamp = UnixTimestamp.GetCurrent();
}
public void UpdateAchievementBadge(SqlDatabaseClient MySqlClient, string AchievementGroup, Badge NewBadge)
{
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.SetParameter("sourcetype", "achievement");
MySqlClient.SetParameter("sourcedata", AchievementGroup);
MySqlClient.SetParameter("badgeid", NewBadge.Id);
lock (mSyncRoot)
{
if (mAchievementBadges.ContainsKey(AchievementGroup))
{
Badge OldBadge = mAchievementBadges[AchievementGroup];
if (OldBadge == NewBadge)
{
MySqlClient.ClearParameters();
return;
}
mIndexCache.Remove(OldBadge.Code);
mAchievementBadges[AchievementGroup] = NewBadge;
MySqlClient.ExecuteNonQuery("UPDATE badges SET badge_id = @badgeid WHERE user_id = @userid AND source_type = @sourcetype AND source_data = @sourcedata LIMIT 1");
foreach (KeyValuePair<int, Badge> Badge in mEquippedBadges)
{
if (Badge.Value.Id == OldBadge.Id)
{
mEquippedBadges[Badge.Key] = NewBadge;
break;
}
}
}
else
{
mAchievementBadges.Add(AchievementGroup, NewBadge);
MySqlClient.ExecuteNonQuery("INSERT INTO badges (user_id,badge_id,source_type,source_data) VALUES (@userid,@badgeid,@sourcetype,@sourcedata)");
}
mRightsCache = RegenerateRights();
mIndexCache.Add(NewBadge.Code);
}
}
public void UpdateLicence(SqlDatabaseClient MySqlClient, int Value)
{
Licence = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("licence", Licence);
MySqlClient.ExecuteNonQuery("UPDATE characters SET licence = @licence WHERE id = @id LIMIT 1");
}
public void UpdateShotgun(SqlDatabaseClient MySqlClient, int Value)
{
Shotgun = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("shotgun", Shotgun);
MySqlClient.ExecuteNonQuery("UPDATE characters SET shotgun = @shotgun WHERE id = @id LIMIT 1");
}
public void UpdateScore(SqlDatabaseClient MySqlClient, int Amount)
{
mScore += Amount;
MySqlClient.SetParameter("userid", mId);
MySqlClient.SetParameter("score", mScore);
MySqlClient.ExecuteNonQuery("UPDATE characters SET score = @score WHERE id = @userid LIMIT 1");
}
public void UpdatePhone(SqlDatabaseClient MySqlClient, int Value)
{
Phone = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("phone", Phone);
MySqlClient.ExecuteNonQuery("UPDATE characters SET phone = @phone WHERE id = @id LIMIT 1");
}
public void UpdatePellet(SqlDatabaseClient MySqlClient, int Value)
{
Pellet = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("pellet", Pellet);
MySqlClient.ExecuteNonQuery("UPDATE characters SET pellet = @pellet WHERE id = @id LIMIT 1");
}
public void UpdateNewFigure(SqlDatabaseClient MySqlClient, string NewFigure)
{
mNewFigure = NewFigure;
MySqlClient.SetParameter("userid", mId);
MySqlClient.SetParameter("figure", mFigure);
MySqlClient.ExecuteNonQuery("UPDATE characters SET figure = @figure WHERE id = @userid LIMIT 1");
}
public void UpdateMotto(SqlDatabaseClient MySqlClient, string NewMotto)
{
mMotto = NewMotto;
MySqlClient.SetParameter("userid", mId);
MySqlClient.SetParameter("motto", NewMotto);
MySqlClient.ExecuteNonQuery("UPDATE characters SET motto = @motto WHERE id = @userid LIMIT 1");
}
public void UpdateWorking(SqlDatabaseClient MySqlClient, int Value)
{
Working = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("working", Working);
MySqlClient.ExecuteNonQuery("UPDATE characters SET working = @working WHERE id = @id LIMIT 1");
}
public void UpdateXP(SqlDatabaseClient MySqlClient, int Value)
{
XP = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("xp", XP);
MySqlClient.ExecuteNonQuery("UPDATE characters SET xp = @xp WHERE id = @id LIMIT 1");
}
public void SynchronizeDatabase(SqlDatabaseClient MySqlClient)
{
MySqlClient.SetParameter("id", mId);
MySqlClient.SetParameter("roomid", mRoomId);
MySqlClient.SetParameter("roompos", mRoomPosition.ToString());
MySqlClient.SetParameter("exp", mExperience);
MySqlClient.SetParameter("energy", mEnergy);
MySqlClient.SetParameter("happy", mHappiness);
MySqlClient.SetParameter("score", mScore);
MySqlClient.ExecuteNonQuery("UPDATE pets SET room_id = @roomid, room_pos = @roompos, experience = @exp, energy = @energy, happiness = @happy, score = @score WHERE id = @id LIMIT 1");
}
public void UpdateStr(SqlDatabaseClient MySqlClient, int Value)
{
Strength = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("str", Strength);
MySqlClient.ExecuteNonQuery("UPDATE characters SET str = @str WHERE id = @id LIMIT 1");
}
public static void LogChatMessage(SqlDatabaseClient MySqlClient, uint UserId, uint RoomId, string Message)
{
if (!(bool)ConfigManager.GetValue("moderation.chatlogs.enabled"))
{
return;
}
MySqlClient.SetParameter("userid", UserId);
MySqlClient.SetParameter("roomid", RoomId);
MySqlClient.SetParameter("message", Message);
MySqlClient.SetParameter("timestamp", UnixTimestamp.GetCurrent());
MySqlClient.ExecuteNonQuery("INSERT INTO moderation_chatlogs (user_id,room_id,message,timestamp) VALUES (@userid,@roomid,@message,@timestamp)");
}
public static void LogModerationAction(SqlDatabaseClient MySqlClient, Session Session, string ActionDescr, string ActionDetail)
{
MySqlClient.SetParameter("userid", Session.CharacterId);
MySqlClient.SetParameter("username", Session.CharacterInfo.Username);
MySqlClient.SetParameter("timestamp", UnixTimestamp.GetCurrent());
MySqlClient.SetParameter("actiondescr", ActionDescr);
MySqlClient.SetParameter("actiondetail", ActionDetail);
MySqlClient.ExecuteNonQuery("INSERT INTO moderation_action_log (moderator_id,moderator_name,action_descr,action_detail,timestamp) VALUES (@userid,@username,@actiondescr,@actiondetail,@timestamp)");
}
public void UpdateTimer(SqlDatabaseClient MySqlClient, int Amount)
{
Timer += Amount;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("timer", Timer);
MySqlClient.ExecuteNonQuery("UPDATE characters SET timer = @timer WHERE id = @id LIMIT 1");
}
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_id,slot_id,source_type,source_data FROM badges WHERE user_id = @userid");
foreach (DataRow Row in Table.Rows)
{
Badge Badge = RightsManager.GetBadgeById((uint)Row["badge_id"]);
if (Badge == null)
{
continue;
}
string SourceType = Row["source_type"].ToString();
string SourceData = Row["source_data"].ToString();
Badge BadgeToEquip = null;
if (SourceType == "static")
{
BadgeToEquip = Badge;
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("badgeid", Badge.Id);
MySqlClient.ExecuteNonQuery("DELETE FROM badges WHERE user_id = @userid AND badge_id = @badgeid");
continue;
}
string Code = UserAchievement.GetBadgeCodeForLevel();
BadgeToEquip = (Badge.Code == Code ? Badge : RightsManager.GetBadgeByCode(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;
mRightsCache = RegenerateRights();
mIndexCache = IndexCache;
}
}
public void UpdateTokens(SqlDatabaseClient MySqlClient, int Amount)
{
mTokens += Amount;
MySqlClient.SetParameter("userid", mId);
MySqlClient.SetParameter("tokens", mTokens);
MySqlClient.ExecuteNonQuery("UPDATE characters SET tokens = @tokens WHERE id = @userid LIMIT 1");
}
public void UpdateBadgeOrder(SqlDatabaseClient MySqlClient, Dictionary<int, Badge> NewSettings)
{
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.ExecuteNonQuery("UPDATE badges SET slot_id = 0 WHERE user_id = @userid");
foreach (KeyValuePair<int, Badge> EquippedBadge in NewSettings)
{
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.SetParameter("slotid", EquippedBadge.Key);
MySqlClient.SetParameter("badgeid", EquippedBadge.Value.Id);
MySqlClient.ExecuteNonQuery("UPDATE badges SET slot_id = @slotid WHERE user_id = @userid AND badge_id = @badgeid LIMIT 1");
}
lock (mSyncRoot)
{
mEquippedBadges = NewSettings;
}
}
public void UpdateUzi(SqlDatabaseClient MySqlClient, int Value)
{
Uzi = Value;
MySqlClient.SetParameter("id", Id);
MySqlClient.SetParameter("uzi", Uzi);
MySqlClient.ExecuteNonQuery("UPDATE characters SET uzi = @uzi WHERE id = @id LIMIT 1");
}
public void SynchronizeDatabase(SqlDatabaseClient MySqlClient)
{
MySqlClient.SetParameter("id", mItemId);
MySqlClient.SetParameter("data1", mData1);
MySqlClient.SetParameter("data2", mData2);
MySqlClient.SetParameter("data3", mData3);
MySqlClient.SetParameter("data4", mData4);
MySqlClient.SetParameter("data5", mData5);
MySqlClient.SetParameter("time", mTime);
MySqlClient.ExecuteNonQuery("UPDATE wired_items SET data1 = @data1, data2 = @data2, data3 = @data3, data4 = @data4, data5 = @data5, time = @time WHERE item_id = @id LIMIT 1");
}
public void UpdateVar(SqlDatabaseClient MySqlClient, string Var, string Value)
{
MySqlClient.SetParameter("id", this.Id);
MySqlClient.SetParameter("value", Value);
MySqlClient.ExecuteNonQuery("UPDATE characters SET " + Var + " = " + Var + " + @value WHERE id = @id LIMIT 1");
}
