/// <summary>
/// Check if User has Obtained an achievement on this Score Submission
/// </summary>
/// <param name="factory">Context Factory</param>
/// <param name="user">Who tries to Obtain</param>
/// <param name="score">Submitted Score</param>
/// <param name="map">Beatmap</param>
/// <param name="set">Beatmap Set</param>
/// <param name="oldLb">Old LeaderBoard</param>
/// <param name="newLb">New LeaderBoard</param>
/// <returns>Obtained Achievements</returns>
public static string ProcessAchievements(SoraDbContext ctx,
DbUser user,
DbScore score,
Beatmap map,
BeatmapSet set,
DbLeaderboard oldLb,
DbLeaderboard newLb
)
{
var l = new List <Achievement>();
/*
* if ((int) newLB.PerformancePointsOsu == 4914)
* {
* var ach = DBAchievement.GetAchievement(factory, "oog");
* if (!user.AlreadyOptainedAchievement(ach))
* _l.Add(ach);
* }
*/
// Insert custom achievements here. I'll implement a Plugin System later! but this will work for now.
// END OF CUSTOM ACHIEVEMENTS
var retVal = l.Aggregate("", (current, ach) => current + ach.ToOsuString() + "/");
retVal.TrimEnd('/');
return(retVal);
}
public static DbBeatmap FromBeatmap(Beatmap beatmap, BeatmapSet parent) => new DbBeatmap
{
Id = beatmap.BeatmapID,
SetId = parent.SetID,
RankedStatus = parent.RankedStatus,
FileMd5 = beatmap.FileMD5,
PlayMode = beatmap.Mode,
Artist = parent.Artist,
Title = parent.Title,
DiffName = beatmap.DiffName,
FileName = $"{parent.Artist} - {parent.Title} ({parent.Creator}) [{beatmap.DiffName}].osu",
Flags = DbBeatmapFlags.None,
};
public static IEnumerable <DbBeatmap> FromBeatmapSet(BeatmapSet set) => set.ChildrenBeatmaps.Select(beatmap => FromBeatmap(beatmap, set));
public async Task <IActionResult> GetScoreResult(
[FromQuery(Name = "v")] ScoreboardType type,
[FromQuery(Name = "c")] string fileMd5,
[FromQuery(Name = "f")] string f,
[FromQuery(Name = "m")] PlayMode playMode,
[FromQuery(Name = "i")] int i,
[FromQuery(Name = "mods")] Mod mods,
[FromQuery(Name = "us")] string us,
[FromQuery(Name = "ha")] string pa,
[FromServices] IServiceProvider serviceProvider,
[FromServices] SoraDbContext ctx,
[FromServices] DbContextPool <SoraDbContext> ctxPool,
[FromServices] Pisstaube pisstaube,
[FromServices] Cache cache)
{
try
{
var dbUser = await DbUser.GetDbUser(ctx, us);
if (dbUser?.IsPassword(pa) != true)
{
return(Ok("error: pass"));
}
var cacheHash =
Hex.ToHex(
Crypto.GetMd5(
$"{fileMd5}{playMode}{mods}{type}{dbUser.Id}{dbUser.UserName}"
)
);
if (cache.TryGet($"sora:Scoreboards:{cacheHash}", out string cachedData))
{
return(Ok(cachedData));
}
var scores = DbScore.GetScores(ctx, fileMd5, dbUser, playMode,
type == ScoreboardType.Friends,
type == ScoreboardType.Country,
type == ScoreboardType.Mods,
mods);
BeatmapSet set = null;
DbScore ownScore = null;
var beatmap = DbBeatmap.GetBeatmap(ctx, fileMd5);
if (beatmap == null)
{
var apiSet = await pisstaube.FetchBeatmapSetAsync(fileMd5);
if (apiSet == null)
{
goto JustContinue;
}
var beatmaps = DbBeatmap.FromBeatmapSet(apiSet).ToList();
var beatmapChecksums = beatmaps.Select(s => s.FileMd5);
var dbBeatmaps =
ctx.Beatmaps.Where(rset => beatmapChecksums.Any(lFileMd5 => rset.FileMd5 == lFileMd5))
.ToList();
var pool = serviceProvider.GetRequiredService <DbContextPool <SoraDbContext> >();
Task.WaitAll(beatmaps.Select(rawBeatmap => Task.Run(async() =>
{
var context = pool.Rent();
try
{
var dbBeatmap = dbBeatmaps.FirstOrDefault(s => s.FileMd5 == rawBeatmap.FileMd5);
if (dbBeatmap != null && (dbBeatmap.Flags & DbBeatmapFlags.RankedFreeze) != 0)
{
rawBeatmap.RankedStatus = dbBeatmap.RankedStatus;
rawBeatmap.Flags = dbBeatmap.Flags;
}
context.Beatmaps.AddOrUpdate(rawBeatmap);
await context.SaveChangesAsync();
}
finally
{
pool.Return(context);
}
})).ToArray());
beatmap = beatmaps.FirstOrDefault(s => s.FileMd5 == fileMd5);
}
await foreach (var score in DbScore.GetScores(ctx, fileMd5, dbUser, playMode, false, false, false, mods, true))
{
ownScore = score;
break;
}
if (beatmap != null)
{
set = new BeatmapSet
{
SetID = beatmap.Id,
Artist = beatmap.Artist,
Title = beatmap.Title,
RankedStatus = beatmap.RankedStatus,
ChildrenBeatmaps = new List <Beatmap>
{
new Beatmap
{
FileMD5 = beatmap.FileMd5,
DiffName = beatmap.DiffName,
ParentSetID = beatmap.SetId,
BeatmapID = beatmap.Id,
Mode = beatmap.PlayMode,
},
},
}
}
;
JustContinue:
var sboard = new Scoreboard(set?.ChildrenBeatmaps.FirstOrDefault(bm => bm.FileMD5 == fileMd5),
set, scores, ownScore);
cache.Set($"sora:Scoreboards:{cacheHash}", cachedData = await sboard.ToOsuString(ctxPool), TimeSpan.FromSeconds(30));
return(Ok(cachedData));
}
catch (Exception ex)
{
Logger.Err(ex);
return(Ok("Failed"));
}
}
