|
1
|
|
|
import discord |
|
2
|
|
|
import pandas as pd |
|
3
|
|
|
from discord.ext import commands, tasks |
|
4
|
|
|
from discord.utils import get |
|
5
|
|
|
from discord_slash import cog_ext |
|
6
|
|
|
import cogs.cogbase as cogbase |
|
7
|
|
|
from cogs.databasecog import DatabaseCog |
|
8
|
|
|
|
|
9
|
|
|
legend_multiplier = 5 |
|
10
|
|
|
|
|
11
|
|
|
|
|
12
|
|
|
class LeaderboardsCog(cogbase.BaseCog): |
|
13
|
|
|
def __init__(self, base): |
|
14
|
|
|
super().__init__(base) |
|
15
|
|
|
self.update_leaderboards_loop.start() |
|
16
|
|
|
|
|
17
|
|
|
# Send leaderboards to specified channel |
|
18
|
|
|
async def update_leaderboards(self, channel: int, ch_type: str): |
|
19
|
|
|
top_ch = self.bot.get_channel(channel) |
|
20
|
|
|
spots_df = await DatabaseCog.db_get_spots_df() |
|
21
|
|
|
spots_df = pd.DataFrame(spots_df) |
|
22
|
|
|
spots_df["total"] = spots_df["legendary"] * legend_multiplier + spots_df["rare"] |
|
23
|
|
|
spots_df_top = spots_df.sort_values(ch_type, ascending=False).head(15) |
|
24
|
|
|
spots_df_top = spots_df_top.reset_index(drop=True) |
|
25
|
|
|
await top_ch.purge() |
|
26
|
|
|
|
|
27
|
|
|
top_print = [] |
|
28
|
|
|
for index, row in spots_df_top.iterrows(): |
|
29
|
|
|
member_stats = [f"**[{index + 1}]** {row['display_name']} - {row[ch_type]}"] |
|
30
|
|
|
top_print.append(member_stats) |
|
31
|
|
|
top_print = ['\n'.join([elem for elem in sublist]) for sublist in top_print] |
|
32
|
|
|
top_print = "\n".join(top_print) |
|
33
|
|
|
embed_command = discord.Embed(title=f"TOP 15 {ch_type.upper()}", description=top_print, |
|
34
|
|
|
color=0xf1c232) |
|
35
|
|
|
member = self.bot.get_user(spots_df_top['member_id'].iloc[0]) |
|
36
|
|
|
embed_command.set_thumbnail(url=f'{member.avatar_url}') |
|
37
|
|
|
await top_ch.send(embed=embed_command) |
|
38
|
|
|
|
|
39
|
|
|
# Update member spotting role(total/common) |
|
40
|
|
|
async def update_role(self, guild, guild_member, spot_roles, common: bool): |
|
41
|
|
|
roles_type = "common" if common else "total" |
|
42
|
|
|
try: |
|
43
|
|
|
spots_df = await DatabaseCog.db_get_member_stats(guild_member.id) |
|
44
|
|
|
spots_df["total"] = spots_df["legendary"] * legend_multiplier + spots_df["rare"] |
|
45
|
|
|
roles_list = [key for (key, value) in spot_roles.items() if spots_df.loc[0, roles_type] >= value] |
|
46
|
|
|
if roles_list: |
|
47
|
|
|
await self.create_role(guild, roles_list[-1]) |
|
48
|
|
|
role_new = get(guild.roles, name=roles_list[-1]) |
|
49
|
|
|
await guild_member.add_roles(role_new) |
|
50
|
|
|
if len(roles_list) > 1: |
|
51
|
|
|
await self.create_role(guild, roles_list[-2]) |
|
52
|
|
|
role_old = get(guild.roles, name=roles_list[-2]) |
|
53
|
|
|
await self.create_role(guild, roles_list[-2]) |
|
54
|
|
|
await guild_member.remove_roles(role_old) |
|
55
|
|
|
except KeyError as e: |
|
56
|
|
|
print(e) |
|
57
|
|
|
|
|
58
|
|
|
# Update members' spotting roles |
|
59
|
|
|
async def update_member_roles(self): |
|
60
|
|
|
guild = self.bot.get_guild(self.bot.guild[0]) |
|
61
|
|
|
spot_roles_total = self.bot.config["total_milestones"][0] |
|
62
|
|
|
spot_roles_common = self.bot.config["common_milestones"][0] |
|
63
|
|
|
for guild_member in guild.members: |
|
64
|
|
|
await self.update_role(guild, guild_member, spot_roles_total, False) |
|
65
|
|
|
await self.update_role(guild, guild_member, spot_roles_common, True) |
|
66
|
|
|
|
|
67
|
|
|
# @tasks.loop(seconds=15) |
|
68
|
|
|
@tasks.loop(minutes=15) |
|
69
|
|
|
async def update_leaderboards_loop(self): |
|
70
|
|
|
await self.update_leaderboards(self.bot.ch_leaderboards, "total") |
|
71
|
|
|
await self.update_leaderboards(self.bot.ch_leaderboards_common, "common") |
|
72
|
|
|
await self.update_member_roles() |
|
73
|
|
|
dt_string = self.get_current_time() |
|
74
|
|
|
print(f'({dt_string})\t[{self.__class__.__name__}]: Leaderboards updated') |
|
75
|
|
|
|
|
76
|
|
|
@update_leaderboards_loop.before_loop |
|
77
|
|
|
async def before_update_leaderboards_loop(self): |
|
78
|
|
|
dt_string = self.get_current_time() |
|
79
|
|
|
print(f'({dt_string})\t[{self.__class__.__name__}]: Waiting until Bot is ready') |
|
80
|
|
|
await self.bot.wait_until_ready() |
|
81
|
|
|
|
|
82
|
|
|
# Get own spotting stats |
|
83
|
|
|
@cog_ext.cog_slash(name="myStats", guild_ids=cogbase.GUILD_IDS, |
|
84
|
|
|
description="Get your spot stats", |
|
85
|
|
|
default_permission=True) |
|
86
|
|
|
async def get_stats(self, ctx): |
|
87
|
|
|
spot_roles = self.bot.config["total_milestones"][0] |
|
88
|
|
|
guild = self.bot.get_guild(self.bot.guild[0]) |
|
89
|
|
|
spots_df = await DatabaseCog.db_get_member_stats(ctx.author.id) |
|
90
|
|
|
spots_df["total"] = spots_df["legendary"] * legend_multiplier + spots_df["rare"] |
|
91
|
|
|
|
|
92
|
|
|
role_new = "" |
|
93
|
|
|
spots_for_new = -1 |
|
94
|
|
|
roles_list = [key for (key, value) in spot_roles.items() if spots_df.at[0, "total"] < value] |
|
95
|
|
|
values_list = [value for (key, value) in spot_roles.items() if spots_df.at[0, "total"] < value] |
|
96
|
|
|
if roles_list: |
|
97
|
|
|
role_new = get(guild.roles, name=roles_list[0]) |
|
98
|
|
|
spots_for_new = values_list[0] |
|
99
|
|
|
|
|
100
|
|
|
message = f"**Legends**: {spots_df.at[0, 'legendary']}\n" \ |
|
101
|
|
|
f"**Rares**: {spots_df.at[0, 'rare']}\n" \ |
|
102
|
|
|
f"**Commons**: {spots_df.at[0, 'common']}\n\n" \ |
|
103
|
|
|
f"**Total points**: {spots_df.at[0, 'total']}\n" \ |
|
104
|
|
|
f"**Progress**: {spots_df.at[0, 'total']}/{spots_for_new}\n" \ |
|
105
|
|
|
f"**Next role**: _{role_new}_" |
|
106
|
|
|
|
|
107
|
|
|
await ctx.send(f"{ctx.author.mention} stats:\n{message}", hidden=True) |
|
108
|
|
|
|
|
109
|
|
|
|
|
110
|
|
|
def setup(bot: commands.Bot): |
|
111
|
|
|
bot.add_cog(LeaderboardsCog(bot)) |
|
112
|
|
|
|
BonHowi /
discordPogmareBot
