/// <summary>
/// Changes auth level of account.
/// </summary>
/// <param name="accountId"></param>
/// <param name="level"></param>
/// <returns></returns>
public bool ChangeAuth(string accountId, int level)
{
using (var conn = AuraDb.Instance.Connection)
using (var cmd = new UpdateCommand("UPDATE `accounts` SET {0} WHERE `accountId` = @accountId", conn))
{
cmd.AddParameter("@accountId", accountId);
cmd.Set("authority", level);
return (cmd.Execute() > 0);
}
}
/// <summary>
/// Writes guild robe information to database.
/// </summary>
/// <param name="guild"></param>
public void UpdateGuildRobe(Guild guild)
{
using (var conn = this.Connection)
using (var cmd = new UpdateCommand("UPDATE `guilds` SET {0} WHERE `guildId` = @guildId", conn))
{
cmd.AddParameter("@guildId", guild.Id);
cmd.Set("hasRobe", guild.HasRobe);
if (guild.HasRobe)
{
cmd.Set("emblemMark", guild.Robe.EmblemMark);
cmd.Set("emblemOutline", guild.Robe.EmblemOutline);
cmd.Set("stripes", guild.Robe.Stripes);
cmd.Set("robeColor", guild.Robe.RobeColor);
cmd.Set("badgeColor", guild.Robe.BadgeColor);
cmd.Set("emblemMarkColor", guild.Robe.EmblemMarkColor);
cmd.Set("emblemOutlineColor", guild.Robe.EmblemOutlineColor);
cmd.Set("stripesColor", guild.Robe.StripesColor);
}
cmd.Execute();
}
}
/// <summary>
/// Sets read flag for given note.
/// </summary>
/// <param name="noteId"></param>
public void SetNoteRead(long noteId)
{
using (var conn = this.Connection)
using (var cmd = new UpdateCommand("UPDATE `notes` SET {0} WHERE `noteId` = @noteId", conn))
{
cmd.Set("read", true);
cmd.AddParameter("@noteId", noteId);
cmd.Execute();
}
}
/// <summary>
/// Updates deletion time for character, or deletes it.
/// </summary>
/// <param name="character"></param>
public void UpdateDeletionTime(Character character)
{
using (var conn = this.Connection)
{
if (character.DeletionFlag == DeletionFlag.Delete)
{
using (var mc = new MySqlCommand("DELETE FROM `creatures` WHERE `creatureId` = @creatureId", conn))
{
mc.Parameters.AddWithValue("@creatureId", character.CreatureId);
mc.ExecuteNonQuery();
}
}
else
{
using (var cmd = new UpdateCommand("UPDATE `creatures` SET {0} WHERE `creatureId` = @creatureId", conn))
{
cmd.AddParameter("@creatureId", character.CreatureId);
cmd.Set("deletionTime", character.DeletionTime);
cmd.Execute();
}
}
}
}
/// <summary>
/// Updates lastLogin and loggedIn from the account.
/// </summary>
/// <param name="account"></param>
public void UpdateAccount(Account account)
{
using (var conn = this.Connection)
using (var cmd = new UpdateCommand("UPDATE `accounts` SET `lastLogin` = @lastLogin, `loggedIn` = @loggedIn WHERE `accountId` = @accountId", conn))
{
cmd.Set("accountId", account.Name);
cmd.Set("lastLogin", account.LastLogin);
cmd.Set("loggedIn", account.LoggedIn);
cmd.Execute();
}
}
/// <summary>
/// Updates contact's last login time.
/// </summary>
/// <param name="contact"></param>
private void UpdateLastLogin(Contact contact)
{
using (var conn = this.Connection)
using (var cmd = new UpdateCommand("UPDATE `contacts` SET {0} WHERE `contactId` = @contactId", conn))
{
cmd.AddParameter("@contactId", contact.Id);
cmd.Set("lastLogin", contact.LastLogin);
cmd.Execute();
}
}
/// <summary>
/// Updates friendship status for contact 1.
/// </summary>
/// <param name="contactId"></param>
/// <returns></returns>
public void SetFriendshipStatusOneSided(int contactId1, int contactId2, FriendshipStatus status)
{
using (var conn = this.Connection)
using (var cmd = new UpdateCommand("UPDATE `friends` SET {0} WHERE (`userId1` = @userId1 AND `userId2` = @userId2)", conn))
{
cmd.Set("status", (byte)status);
cmd.AddParameter("@userId1", contactId1);
cmd.AddParameter("@userId2", contactId2);
cmd.Execute();
}
}
/// <summary>
/// Deletes group from database and moves friends in that group to ETC.
/// </summary>
/// <param name="user"></param>
/// <param name="groupId"></param>
public void DeleteGroup(User user, int groupId)
{
using (var conn = this.Connection)
{
// Move friends
using (var cmd = new UpdateCommand("UPDATE `friends` SET {0} WHERE `userId1` = @userId1 AND `groupId` = @oldGroupId", conn))
{
cmd.Set("groupId", -1);
cmd.AddParameter("@userId1", user.Id);
cmd.AddParameter("@oldGroupId", groupId);
cmd.Execute();
}
// Delete group
using (var mc = new MySqlCommand("DELETE FROM `groups` WHERE `contactId` = @contactId AND `groupId` = @groupId", conn))
{
mc.Parameters.AddWithValue("@contactId", user.Id);
mc.Parameters.AddWithValue("@groupId", groupId);
mc.ExecuteNonQuery();
}
}
}
/// <summary>
/// Changes group the friend is in in the database.
/// </summary>
/// <param name="user"></param>
/// <param name="friendContactId"></param>
/// <param name="groupId"></param>
public void ChangeGroup(User user, int friendContactId, int groupId)
{
using (var conn = this.Connection)
using (var cmd = new UpdateCommand("UPDATE `friends` SET {0} WHERE `userId1` = @userId1 AND `userId2` = @userId2", conn))
{
cmd.Set("groupId", groupId);
cmd.AddParameter("@userId1", user.Id);
cmd.AddParameter("@userId2", friendContactId);
cmd.Execute();
}
}
/// <summary>
/// Renames group in database.
/// </summary>
/// <param name="user"></param>
/// <param name="groupId"></param>
/// <param name="groupName"></param>
public void RenameGroup(User user, int groupId, string groupName)
{
using (var conn = this.Connection)
using (var cmd = new UpdateCommand("UPDATE `groups` SET {0} WHERE `groupId` = @groupId AND `contactId` = @contactId", conn))
{
cmd.Set("name", groupName);
cmd.AddParameter("@groupId", groupId);
cmd.AddParameter("@contactId", user.Id);
cmd.Execute();
}
}
/// <summary>
/// Saves user's options to database.
/// </summary>
/// <param name="user"></param>
public void SaveOptions(User user)
{
using (var conn = this.Connection)
using (var cmd = new UpdateCommand("UPDATE `contacts` SET {0} WHERE `contactId` = @contactId", conn))
{
cmd.Set("status", (byte)user.Status);
cmd.Set("chatOptions", (uint)user.ChatOptions);
cmd.Set("nickname", user.Nickname ?? "");
cmd.AddParameter("@contactId", user.Id);
cmd.Execute();
}
}
