/// <summary>
/// </summary>
/// <param name="charId">
/// </param>
/// <returns>
/// </returns>
public static DBLoginData GetByCharacterId(int charId)
{
DBCharacter character = null;
try
{
using (IDbConnection conn = Connector.GetConnection())
{
character = CharacterDao.GetById(charId).First();
DynamicParameters p = new DynamicParameters();
p.Add("username", character.Username);
return(conn.Query <DBLoginData>("SELECT * FROM login WHERE Username=@username", p).First());
}
}
catch (Exception)
{
if (character == null)
{
LogUtil.Debug("No character " + charId + " in database. huh?");
}
else
{
LogUtil.Debug("No Account found for Character " + character.Name + " (" + character.Id + ")");
}
throw;
}
}
/// <summary>
/// </summary>
/// <param name="user">
/// </param>
public static void LogoffChars(string user)
{
IEnumerable <DBCharacter> characters = CharacterDao.GetAllForUser(user);
foreach (DBCharacter character in characters)
{
OnlineDao.SetOffline(character.Id);
}
}