public JsonResult Validate([FromBody] PostValidateRequest request)
{
IQueryable <Tokens> tokens = null;
if (request.clientToken == null)
{
tokens = from t in db.Tokens where t.AccessToken == request.accessToken && t.Status == 2 select t;
}
else
{
tokens = from t in db.Tokens where t.AccessToken == request.accessToken && t.ClientToken == request.clientToken && t.Status == 2 select t;
}
if (tokens.Count() != 1)
{
log.Info($"[ID: {HttpContext.Connection.Id}]{HttpContext.Connection.RemoteIpAddress.MapToIPv4()}:{HttpContext.Connection.RemotePort} vaild token failed.");
return(new JsonResult(ExceptionWorker.InvalidToken())
{
StatusCode = (int)HttpStatusCode.Forbidden
});
}
else
{
log.Info($"[ID: {HttpContext.Connection.Id}]{HttpContext.Connection.RemoteIpAddress.MapToIPv4()}:{HttpContext.Connection.RemotePort} vaild token successful.");
return(new JsonResult(null)
{
StatusCode = (int)HttpStatusCode.NoContent
});
}
}
public JsonResult Join([FromBody] PostJoinRequest request)
{
// Check token.
var tokens = from t in db.Tokens where t.AccessToken == request.accessToken && t.Status == 2 select t;
if (tokens.Count() != 1)
{
return(new JsonResult(ExceptionWorker.InvalidToken())
{
StatusCode = (int)HttpStatusCode.Forbidden
});
}
var token = tokens.First();
// Check profile.
var profiles = from p in db.Profiles where p.Uuid == request.selectedProfile select p;
if (profiles.Count() != 1)
{
return(new JsonResult(ExceptionWorker.InvalidToken())
{
StatusCode = (int)HttpStatusCode.Forbidden
});
}
var profile = profiles.First();
if (token.BindProfileId != profile.Id)
{
return(new JsonResult(ExceptionWorker.InvalidToken())
{
StatusCode = (int)HttpStatusCode.Forbidden
});
}
db.Sessions.Add(new Sessions()
{
AccessToken = request.accessToken,
ServerId = request.serverId,
ExpireTime = TimeWorker.GetTimeStamp10(Program.SessionsExpireSeconds),
ClientIp = HttpContext.Connection.RemoteIpAddress.MapToIPv4().ToString()
});
db.SaveChanges();
// Clean expired sessions.
var time = long.Parse(TimeWorker.GetTimeStamp10());
var sessions = from s in db.Sessions where long.Parse(s.ExpireTime) < time select s;
foreach (var item in sessions)
{
db.Sessions.Remove(item);
}
db.SaveChanges();
log.Info($"[ID: {HttpContext.Connection.Id}]Player {profile.Name} with IP {HttpContext.Connection.RemoteIpAddress.MapToIPv4()}:{HttpContext.Connection.RemotePort} tried to login server.");
return(new JsonResult(null)
{
StatusCode = (int)HttpStatusCode.NoContent
});
}
public JsonResult Refresh([FromBody] PostRefreshRequest request)
{
log.Info($"[ID: {HttpContext.Connection.Id}]{HttpContext.Connection.RemoteIpAddress.MapToIPv4()}:{HttpContext.Connection.RemotePort} tried to refresh token.");
var isAlreadyBindProfile = false;
// Check token.
IQueryable <Tokens> tokens = null;
if (request.clientToken != null)
{
tokens = from t in db.Tokens where t.AccessToken == request.accessToken && t.ClientToken == request.clientToken && t.Status >= 1 select t;
}
else
{
tokens = from t in db.Tokens where t.AccessToken == request.accessToken && t.Status >= 1 select t;
}
if (tokens.Count() != 1)
{
log.Info($"[ID: {HttpContext.Connection.Id}]Token invalid.");
return(new JsonResult(ExceptionWorker.InvalidToken())
{
StatusCode = (int)HttpStatusCode.Forbidden
});
}
// Invalid token.
int?profileId = null;
int?userId = null;
var token = tokens.First();
if (token.BindProfileId != null)
{
profileId = token.BindProfileId;
isAlreadyBindProfile = true;
}
else
{
var profiles = from p in db.Profiles where p.Id == profileId select p;
if (profiles.Count() == 1)
{
userId = profiles.First().Uid;
}
}
token.Status = 0;
db.SaveChanges();
log.Info($"[ID: {HttpContext.Connection.Id}]Access token {token.AccessToken} has invalided.");
// Check others temp invalid tokens.
var time = long.Parse(TimeWorker.GetTimeStamp10());
var tempInvalidTokens = from t in db.Tokens where (long.Parse(t.CreateTime) + Program.TokensExpireDaysLimit * 24 * 60 * 60) <= time select t;
foreach (var t in tempInvalidTokens)
{
t.Status = 1;
}
db.SaveChanges();
// Delete invalid tokens.
var invalidTokens = from t in db.Tokens where t.Status == 0 select t;
foreach (var t in invalidTokens)
{
db.Tokens.Remove(t);
}
db.SaveChanges();
// Bind profile.
PostRefreshResponse response = new PostRefreshResponse();
Tokens tokenNew = new Tokens();
if (request.selectedProfile != null)
{
if (isAlreadyBindProfile)
{
return(new JsonResult(ExceptionWorker.AlreadyBind())
{
StatusCode = (int)HttpStatusCode.Forbidden
});
}
else
{
var profiles = from p in db.Profiles where p.Uuid == request.selectedProfile.Value.id select p;
var profile = profiles.First();
if (profiles.Count() == 1)
{
profile.IsSelected = 1;
profileId = profile.Id;
tokenNew.BindProfileId = profile.Id;
response.selectedProfile = request.selectedProfile;
}
;
userId = profile.Uid;
profiles = from p in db.Profiles where p.Uid == profile.Uid select p;
foreach (var p in profiles)
{
if (p.Id != profileId && p.IsSelected == 1)
{
p.IsSelected = 0;
}
}
db.SaveChanges();
log.Info($"[ID: {HttpContext.Connection.Id}]Bind profile {profile.Name}.");
}
}
// Check if token reach the limit.
tokens = from t in db.Tokens where t.BindProfileId == profileId && t.Status == 1 select t;
if (tokens.Count() > Program.MaxTokensPerProfile)
{
long createTime = long.MaxValue;
foreach (var t in tokens)
{
if (long.Parse(t.CreateTime) <= createTime)
{
createTime = long.Parse(t.CreateTime);
}
}
tokens = from t in db.Tokens where t.BindProfileId == profileId && t.CreateTime == createTime.ToString() select t;
tokens.First().Status = 0;
db.SaveChanges();
}
// Build response and hand the new token out.
response.accessToken = tokenNew.AccessToken = UuidWorker.GetUuid();
if (request.clientToken != null)
{
response.clientToken = tokenNew.ClientToken = request.clientToken;
}
else
{
response.clientToken = tokenNew.ClientToken = UuidWorker.GetUuid();
}
tokenNew.CreateTime = time.ToString();
tokenNew.Status = 2;
db.Tokens.Add(tokenNew);
db.SaveChanges();
// User info.
if (request.selectedProfile == null && request.requestUser)
{
var users = from u in db.Users where u.Id == userId select u;
var user = users.First();
var properties = new Properties()
{
name = "preferredLanguage",
value = user.PreferredLanguage
};
response.user = new User()
{
id = user.Username
};
}
return(new JsonResult(response));
}