async def updateweeklies(week):
channel = client.get_channel(792818934743040052)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\rankedscore_" + str(week) + ".csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if (str(week) + "/52 of project 2021") in str(fetchMessage[0].content):
await fetchMessage[0].edit(content = "**Week " + str(week) + "/52 of project 2021" + "**\n" + formatter.formatcsv(f, 50))
else:
await channel.send("**Week " + str(week) + "/52 of project 2021" + "**\n" + formatter.formatcsv(f, 50))
channel = client.get_channel(792819496829452290)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\fccount_" + str(week) + ".csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if (str(week) + "/52 of project 2021") in str(fetchMessage[0].content):
await fetchMessage[0].edit(content = "**Week " + str(week) + "/52 of project 2021" + "**\n" + formatter.formatcsv(f, 50))
else:
await channel.send("**Week " + str(week) + "/52 of project 2021" + "**\n" + formatter.formatcsv(f, 50))
channel = client.get_channel(792819520581664768)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\sscount_" + str(week) + ".csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if (str(week) + "/52 of project 2021") in str(fetchMessage[0].content):
await fetchMessage[0].edit(content = "**Week " + str(week) + "/52 of project 2021" + "**\n" + formatter.formatcsv(f, 50))
else:
await channel.send("**Week " + str(week) + "/52 of project 2021" + "**\n" + formatter.formatcsv(f, 50))
channel = client.get_channel(792819540567916574)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\clearcount_" + str(week) + ".csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if (str(week) + "/52 of project 2021") in str(fetchMessage[0].content):
await fetchMessage[0].edit(content = "**Week " + str(week) + "/52 of project 2021" + "**\n" + formatter.formatcsv(f, 50))
else:
await channel.send("**Week " + str(week) + "/52 of project 2021" + "**\n" + formatter.formatcsv(f, 50))
async def updateplayers():
channel = client.get_channel(792875271782531102)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\totalhits.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
channel = client.get_channel(792883515565146112)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\totalscore.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
channel = client.get_channel(792883547559952415)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\playcount.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
channel = client.get_channel(792920423011844106)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\playtime.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
async def projectXYZ(ctx, *, arg=None):
args = []
if arg != None:
args = arg.split()
di = {}
for i in range(0,len(args)//2):
di.update({args[2*i]:args[2*i+1]})
if not di.__contains__("-v"):
await ctx.send("Please specify a value using -v")
if di.__contains__("-o"):
if di["-o"] in ["fc", "score", "clears", "ss"]:
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\" + di["-o"] + "_" + str(di["-v"]) + ".csv", newline='')
embed = discord.Embed(title = 'Result', colour=discord.Colour(0xE5E242))
s = formatter.formatcsv(f, 10)
if di.__contains__("-u"):
di["-u"] = str(di["-u"]).replace("+", " ")
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\" + di["-o"] + "_" + str(di["-v"]) + ".csv", newline='')
s = s[:-3] + formatter.finduser(f, di["-u"])
embed.description = s
await ctx.send(embed=embed)
else:
await ctx.send("Not implemented yet")
else:
await ctx.send("Please specify a leaderboard type using -o")
async def updateyearlies():
channel = client.get_channel(792863236705746954)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\2021_score_all.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
channel = client.get_channel(792863272860123156)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\2021_fc_all.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
channel = client.get_channel(792863301184913469)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\2021_ss_all.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
channel = client.get_channel(792863357563961364)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\2021_clears_all.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
channel = client.get_channel(795159066133004308)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\2021_pp_all.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
print("update complete")
channel = client.get_channel(795159261755736104)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\2021_top1_all.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
print("update complete")
channel = client.get_channel(795159304024883230)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\2021_top50_all.csv", newline='')
fetchMessage = await channel.history(limit = 1).flatten()
if len(fetchMessage) == 0:
await channel.send('hello')
fetchMessage = await channel.history(limit = 1).flatten()
await fetchMessage[0].edit(content = formatter.formatcsv(f, 50))
print("update complete")
async def oldestnumberone(ctx, *, arg=None):
di = getArgs(arg)
limit = 10
page = 1
if di.__contains__("-l"):
limit = di["-l"]
if di.__contains__("-p"):
page = di["-p"]
offset = int(limit) * (int(page) - 1)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\oldestTop1s.csv", newline='')
embed = discord.Embed(title = 'Result', colour=discord.Colour(0xE5E242))
s = formatter.formatcsv(f, int(limit), int(offset))
embed.description = s
await ctx.send(embed=embed)
await updatelists()
def checkfile(filename, di):
limit = 10
page = 1
if di.__contains__("-l"):
limit = di["-l"]
if di.__contains__("-p"):
page = di["-p"]
offset = int(limit) * (int(page) - 1)
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\" + filename +
".csv",
newline='')
embed = discord.Embed(title='Result', colour=discord.Colour(0xE5E242))
s = formatter.formatcsv(f, int(limit), int(offset))
if di.__contains__("-u"):
f = open("C:\\Users\\sensa\\Documents\\VSCode\\bot\\data\\" +
filename + ".csv",
newline='')
di["-u"] = str(di["-u"]).replace("+", " ")
s = s[:-3] + formatter.finduser(f, di["-u"])
embed.description = s
return embed