async def scoreratio(ctx, *, arg=None):
di = getArgs(arg)
if not di.__contains__("-score"):
di["-score"] = 1000000000
embed = controller.checkProfile("cast(ranked_score as float) / cast(GREATEST(total_score, 1) as float) * 1000", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def scoreperclear(ctx, *, arg=None):
di = getArgs(arg)
if not di.__contains__("-score"):
di["-score"] = 1000000000
print(di["-score"])
embed = controller.checkProfile("cast(ranked_score / greatest((ssh_count + sh_count + s_count + ss_count + a_count), 1) as int)", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def pp(ctx, *, arg=None):
di = getArgs(arg)
if di.__contains__("-filter"):
embed = controller.checkfile("weightedpp_" + di["-filter"], di)
await ctx.send(embed=embed)
else:
embed = controller.checkProfile("pp_raw", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def total_s(ctx, *, arg=None):
di = getArgs(arg)
if di.__contains__("-filter"):
embed = controller.checkfile("totals_" + di["-filter"], di)
await ctx.send(embed=embed)
else:
embed = controller.checkProfile("(sh_count + s_count)", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def a_ranks(ctx, *, arg=None):
di = getArgs(arg)
if di.__contains__("-filter"):
embed = controller.checkfile("a-rank_" + di["-filter"], di)
await ctx.send(embed=embed)
else:
embed = controller.checkProfile("a_count", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def rankedscore(ctx, *, arg=None):
di = getArgs(arg)
if di.__contains__("-filter"):
embed = controller.checkfile("rankedscore_" + di["-filter"], di)
await ctx.send(embed=embed)
else:
embed = controller.checkProfile("ranked_score", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def totalscore(ctx, *, arg=None):
di = getArgs(arg)
embed = controller.checkProfile("total_score", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def playcount(ctx, *, arg=None):
di = getArgs(arg)
embed = controller.checkProfile("playcount", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def playtime(ctx, *, arg=None):
di = getArgs(arg)
embed = controller.checkProfile("cast(playtime / 3600 as int)", cur, di)
await ctx.send(embed=embed)
await updatelists()
async def totalhits(ctx, *, arg=None):
di = getArgs(arg)
embed = controller.checkProfile("(count300 + count100 + count50)", cur, di)
await ctx.send(embed=embed)
await updatelists()
