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()