public void InsertAccountTime(int id, AccountTime accTime)
{
MySqlConnection connection = DAO.GetConnection();
try
{
connection.Open();
string cmdText = "INSERT INTO account_time(account_id, create_time, last_active, expiration_type, expiration_time, expiration_period) VALUES (?account_id, ?create_time, ?last_active, ?expiration_type, ?expiration_time, ?expiration_period)";
MySqlCommand mySqlCommand = new MySqlCommand(cmdText, connection);
mySqlCommand.Parameters.AddWithValue("?account_id", id);
mySqlCommand.Parameters.AddWithValue("?create_time", accTime.CreateTime);
mySqlCommand.Parameters.AddWithValue("?last_active", accTime.LastLoginTime);
mySqlCommand.Parameters.AddWithValue("?expiration_type", accTime.ExpirationType.ToString());
mySqlCommand.Parameters.AddWithValue("?expiration_time", accTime.ExpirationTime);
mySqlCommand.Parameters.AddWithValue("?expiration_period", accTime.ExpirationPeriod);
mySqlCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
ProjectData.SetProjectError(ex);
Exception ex2 = ex;
log.Error((object)ex2);
ProjectData.ClearProjectError();
}
finally
{
connection.Close();
}
}
public SM_GS_ACCOUNT_AUTH_RESPONSE(int accountId, bool ok, Account acc)
{
_accountId = accountId;
_ok = ok;
_acc = acc;
if (!Information.IsNothing(acc))
{
_time = acc.AccountTime;
_reward = acc.LoginReward;
_luna = acc.LunaInfo;
}
}
private static Account CreateAccount(string userName, string password)
{
if (!NamePattern.Match(userName).Success)
{
return(null);
}
string password2 = Conversions.ToString(EncodePassword(password));
Account account = new Account();
account.Name = userName;
account.Password = password2;
account.Activated = 1;
if (DAOManager.AccountDAO.InsertAccount(account))
{
AccountTime accountTime = new AccountTime(account.Id);
accountTime.CreateTime = DateAndTime.Now;
accountTime.ExpirationPeriod = DateAndTime.Now;
DateTime lastTime = DateAndTime.Now.AddDays(-1.0);
DateTime dayTime = new DateTime(DateAndTime.Now.Year, DateAndTime.Now.Month, DateAndTime.Now.Day, 8, 0, 0);
DateTime birthDayTime = new DateTime(DateAndTime.Now.Year, DateAndTime.Now.Month, DateAndTime.Now.Day);
if (ExpirationConfig.EXPIRATION_ENABLE)
{
accountTime.ExpirationType = (ExpirationType)Conversions.ToInteger(Enum.Parse(typeof(ExpirationType), ExpirationConfig.EXPIRATION_TYPE, ignoreCase: true));
if (accountTime.ExpirationType == ExpirationType.TIMING)
{
accountTime.ExpirationPeriod = DateAndTime.Now.AddHours(ExpirationConfig.EXPIRATION_VALUE);
}
else if (accountTime.ExpirationType == ExpirationType.PERIOD)
{
accountTime.ExpirationTime = checked ((uint)(ExpirationConfig.EXPIRATION_VALUE * 60 * 60));
}
}
else
{
accountTime.ExpirationType = ExpirationType.FREE;
}
DAOManager.AccountTimeDAO.InsertAccountTime(account.Id, accountTime);
account.AccountTime = accountTime;
account.LoginReward = new LoginReward(account.Id, 0, 0, lastTime, dayTime, birthDayTime);
DAOManager.LoginRewardDAO.InsertLoginReward(account.LoginReward);
account.LunaInfo = new LunaInfo(account.Id, 0L, 0, 0, 0, dayTime.AddHours(1.0));
DAOManager.LunaDAO.Store(account.LunaInfo);
return(account);
}
return(null);
}
protected override void runImpl()
{
LoginReward loginReward = DAOManager.LoginRewardDAO.LoadLoginReward(accountId);
AccountTime accountTime = DAOManager.AccountTimeDAO.LoadAccountTime(accountId);
loginReward.RewardID = rewardId;
loginReward.RewardIndex = rewardIndex;
if (updataDay)
{
loginReward.LastRewardTime = DateAndTime.Now;
loginReward.NextRewardTime = DateAndTime.DateAdd(DateInterval.Day, 1.0, new DateTime(DateAndTime.Now.Year, DateAndTime.Now.Month, DateAndTime.Now.Day, 8, 0, 0));
log.InfoFormat("帐号ID为 {0} 的用户领取了切克隆每日奖励!", (object)accountId);
}
if (updataBirth)
{
loginReward.NextBirthDayTime = DateAndTime.DateAdd(DateInterval.Year, 1.0, new DateTime(DateAndTime.Now.Year, accountTime.CreateTime.Month, accountTime.CreateTime.Day));
log.InfoFormat("帐号ID为 {0} 的用户领取了切克隆生日奖励!", (object)accountId);
}
DAOManager.LoginRewardDAO.UpdataLoginReward(loginReward);
}
internal AccountTime LoadAccountTime(int id)
{
AccountTime accountTime = new AccountTime(id);
MySqlConnection connection = DAO.GetConnection();
try
{
connection.Open();
string cmdText = "SELECT * FROM account_time WHERE account_id = ?account_id";
MySqlCommand mySqlCommand = new MySqlCommand(cmdText, connection);
mySqlCommand.Parameters.AddWithValue("?account_id", id);
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
if (mySqlDataReader.Read())
{
accountTime.CreateTime = mySqlDataReader.GetDateTime("create_time");
accountTime.LastLoginTime = mySqlDataReader.GetDateTime("last_active");
accountTime.ExpirationType = (ExpirationType)Conversions.ToInteger(Enum.Parse(typeof(ExpirationType), mySqlDataReader.GetString("expiration_type"), ignoreCase: true));
accountTime.ExpirationTime = mySqlDataReader.GetUInt32("expiration_time");
accountTime.ExpirationPeriod = mySqlDataReader.GetDateTime("expiration_period");
}
mySqlDataReader.Close();
return(accountTime);
}
catch (Exception ex)
{
ProjectData.SetProjectError(ex);
Exception ex2 = ex;
log.Error((object)ex2);
ProjectData.ClearProjectError();
return(accountTime);
}
finally
{
connection.Close();
}
}
