|
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, SlashContext |
|
6
|
|
|
|
|
7
|
|
|
import cogs.cogbase as cogbase |
|
8
|
|
|
from cogs.databasecog import DatabaseCog |
|
9
|
|
|
from modules.utils import get_dominant_color |
|
10
|
|
|
|
|
11
|
|
|
|
|
12
|
|
|
class LeaderboardsCog(cogbase.BaseCog): |
|
13
|
|
|
def __init__(self, base): |
|
14
|
|
|
super().__init__(base) |
|
15
|
|
|
|
|
16
|
|
|
self.common_total = 0 |
|
17
|
|
|
self.update_leaderboards_loop.start() |
|
18
|
|
|
|
|
19
|
|
|
def cog_unload(self): |
|
20
|
|
|
self.update_leaderboards_loop.cancel() |
|
21
|
|
|
|
|
22
|
|
|
# Send leaderboards to specified channel |
|
23
|
|
|
async def update_leaderboard(self, channel: int, ch_type: str) -> None: |
|
24
|
|
|
top_ch = self.bot.get_channel(channel) |
|
25
|
|
|
spots_df = await DatabaseCog.db_get_spots_df() |
|
26
|
|
|
monsters_df = await DatabaseCog.db_get_monster_spots_df() |
|
27
|
|
|
# Hard coded because there is only one interesting monster |
|
28
|
|
|
event_monster_df = monsters_df.filter(["member_id", "Nightmare"], axis=1) |
|
29
|
|
|
spots_df = pd.merge(spots_df, event_monster_df, on=["member_id"]) |
|
30
|
|
|
spots_df = spots_df.drop(spots_df[spots_df.member_id == self.bot.user.id].index) |
|
31
|
|
|
spots_df["total"] = spots_df["legendary"] * self.legend_multiplier + spots_df["rare"] + (spots_df["Nightmare"]) |
|
32
|
|
|
spots_df_top = spots_df.sort_values(ch_type, ascending=False).head(15) |
|
33
|
|
|
spots_df_top = spots_df_top.reset_index(drop=True) |
|
34
|
|
|
await self.print_leaderboard(top_ch, spots_df_top, ch_type) |
|
35
|
|
|
|
|
36
|
|
|
self.create_log_msg(f"Leaderboards updated - {ch_type}") |
|
37
|
|
|
|
|
38
|
|
|
# TODO: get data from spot_temp table |
|
39
|
|
|
# TODO: create temp event db |
|
40
|
|
|
async def update_event_leaderboards(self, channel: int, event_monster: str) -> None: |
|
41
|
|
|
top_ch = self.bot.get_channel(channel) |
|
42
|
|
|
spots_df = await DatabaseCog.db_get_monster_spots_df() |
|
43
|
|
|
event_monster_df = spots_df.filter(["member_id", event_monster], axis=1) |
|
44
|
|
|
member_names_df = await DatabaseCog.db_get_member_names() |
|
45
|
|
|
|
|
46
|
|
|
event_df = pd.merge(event_monster_df, member_names_df, on=["member_id"]) |
|
47
|
|
|
event_df = event_df.drop(event_df[event_df.member_id == self.bot.user.id].index) |
|
48
|
|
|
event_df = event_df.sort_values(event_monster, ascending=False).head(15) |
|
49
|
|
|
event_df = event_df.reset_index(drop=True) |
|
50
|
|
|
await self.print_leaderboard(top_ch, event_df, event_monster) |
|
51
|
|
|
self.create_log_msg('Leaderboards updated - event') |
|
52
|
|
|
|
|
53
|
|
|
async def print_leaderboard(self, leaderboard_ch, monster_df, monster_type): |
|
54
|
|
|
try: |
|
55
|
|
|
await leaderboard_ch.purge() |
|
56
|
|
|
except discord.errors.NotFound: |
|
57
|
|
|
pass |
|
58
|
|
|
|
|
59
|
|
|
top_print = [] |
|
60
|
|
|
top_user_id = int(monster_df.at[0, 'member_id']) |
|
61
|
|
|
for index, row in monster_df.iterrows(): |
|
62
|
|
|
if row[monster_type] == 0: |
|
63
|
|
|
member_stats = "" |
|
64
|
|
|
elif row['member_id'] == top_user_id: |
|
65
|
|
|
member_stats = [f"**[{index + 1}] {row['display_name']} - {row[monster_type]}**"] |
|
66
|
|
|
else: |
|
67
|
|
|
member_stats = [f"**[{index + 1}]** {row['display_name']} - {row[monster_type]}"] |
|
68
|
|
|
top_print.append(member_stats) |
|
69
|
|
|
top_print = ['\n'.join(sublist) for sublist in top_print] |
|
70
|
|
|
top_print = "\n".join(top_print) |
|
71
|
|
|
ch_type = ''.join(i for i in monster_type if not i.isdigit()) |
|
72
|
|
|
|
|
73
|
|
|
top_user = get(self.bot.get_all_members(), id=top_user_id) |
|
74
|
|
|
top_user_color = get_dominant_color(top_user.avatar_url) |
|
75
|
|
|
embed_command = discord.Embed(title=f"TOP 15 {ch_type.upper()}", description=top_print, |
|
76
|
|
|
color=top_user_color) |
|
77
|
|
|
member = self.bot.get_user(monster_df['member_id'].iloc[0]) |
|
78
|
|
|
embed_command.set_thumbnail(url=f'{member.avatar_url}') |
|
79
|
|
|
dt_string = self.bot.get_current_time() |
|
80
|
|
|
embed_command.set_footer(text=f"{dt_string}") |
|
81
|
|
|
await leaderboard_ch.send(embed=embed_command) |
|
82
|
|
|
|
|
83
|
|
|
# Update member spotting role(total/common) |
|
84
|
|
|
async def update_roles(self, guild, spot_roles: dict, common: bool) -> None: |
|
85
|
|
|
roles_type = "common" if common else "total" |
|
86
|
|
|
spots_df = await DatabaseCog.db_get_spots_df() |
|
87
|
|
|
|
|
88
|
|
|
if not common: |
|
89
|
|
|
monsters_df = await DatabaseCog.db_get_monster_spots_df() |
|
90
|
|
|
event_monster_df = monsters_df.filter(["member_id", "Nightmare"], axis=1) |
|
91
|
|
|
spots_df = pd.merge(spots_df, event_monster_df, on=["member_id"]) |
|
92
|
|
|
spots_df["total"] = spots_df["legendary"] * self.legend_multiplier \ |
|
93
|
|
|
+ spots_df["rare"] + (spots_df["Nightmare"]) |
|
94
|
|
|
for guild_member in guild.members: |
|
95
|
|
|
member_data = spots_df.loc[spots_df["member_id"] == guild_member.id] |
|
96
|
|
|
member_score = member_data[roles_type].iloc[0] |
|
97
|
|
|
roles_list = [key for (key, value) in spot_roles.items() if member_score >= value] |
|
98
|
|
|
if roles_list: |
|
99
|
|
|
await self.update_role_ext(guild, roles_list, guild_member) |
|
100
|
|
|
# except KeyError as e: |
|
101
|
|
|
# print(e) |
|
102
|
|
|
|
|
103
|
|
|
async def update_role_ext(self, guild, roles_list: list, guild_member) -> None: |
|
104
|
|
|
await self.create_new_role(guild, roles_list[-1]) |
|
105
|
|
|
role_new = get(guild.roles, name=roles_list[-1]) |
|
106
|
|
|
if role_new not in guild_member.roles: |
|
107
|
|
|
await guild_member.add_roles(role_new) |
|
108
|
|
|
if len(roles_list) > 1: |
|
109
|
|
|
await self.create_new_role(guild, roles_list[-2]) |
|
110
|
|
|
role_old = get(guild.roles, name=roles_list[-2]) |
|
111
|
|
|
if role_old in guild_member.roles: |
|
112
|
|
|
await guild_member.remove_roles(role_old) |
|
113
|
|
|
|
|
114
|
|
|
# Update members' spotting roles |
|
115
|
|
|
async def update_member_roles(self) -> None: |
|
116
|
|
|
guild = self.bot.get_guild(self.bot.guild[0]) |
|
117
|
|
|
spot_roles_total = self.bot.config["total_milestones"][0] |
|
118
|
|
|
spot_roles_common = self.bot.config["common_milestones"][0] |
|
119
|
|
|
await self.update_roles(guild, spot_roles_total, False) |
|
120
|
|
|
await self.update_roles(guild, spot_roles_common, True) |
|
121
|
|
|
|
|
122
|
|
|
async def update_leaderboards(self) -> None: |
|
123
|
|
|
await self.update_leaderboard(self.bot.ch_leaderboards, "total") |
|
124
|
|
|
await self.update_leaderboard(self.bot.ch_leaderboards_common, "common") |
|
125
|
|
|
# Update during the event |
|
126
|
|
|
# await self.update_event_leaderboards(self.bot.ch_leaderboards_event, "Nightmare") |
|
127
|
|
|
self.create_log_msg('All leaderboards updated') |
|
128
|
|
|
await self.update_member_roles() |
|
129
|
|
|
self.create_log_msg('All member roles updated') |
|
130
|
|
|
|
|
131
|
|
|
@tasks.loop(minutes=30) |
|
132
|
|
|
async def update_leaderboards_loop(self) -> None: |
|
133
|
|
|
await self.update_leaderboards() |
|
134
|
|
|
|
|
135
|
|
|
@update_leaderboards_loop.before_loop |
|
136
|
|
|
async def before_update_leaderboards_loop(self) -> None: |
|
137
|
|
|
self.create_log_msg('Waiting until Bot is ready') |
|
138
|
|
|
common_ch = self.bot.get_channel(self.bot.ch_common) |
|
139
|
|
|
try: |
|
140
|
|
|
async for _ in common_ch.history(limit=None, oldest_first=True): |
|
141
|
|
|
self.common_total += 1 |
|
142
|
|
|
except AttributeError: |
|
143
|
|
|
pass |
|
144
|
|
|
await self.bot.wait_until_ready() |
|
145
|
|
|
|
|
146
|
|
|
@cog_ext.cog_slash(name="reloadLeaderboards", guild_ids=cogbase.GUILD_IDS, |
|
147
|
|
|
description="Reload leaderboards", |
|
148
|
|
|
default_permission=False, |
|
149
|
|
|
permissions=cogbase.PERMISSION_MODS) |
|
150
|
|
|
async def reload_leaderboards(self, ctx: SlashContext) -> None: |
|
151
|
|
|
await ctx.send('Leaderboards reloaded', hidden=True) |
|
152
|
|
|
await self.update_leaderboards() |
|
153
|
|
|
|
|
154
|
|
|
|
|
155
|
|
|
def setup(bot: commands.Bot) -> None: |
|
156
|
|
|
bot.add_cog(LeaderboardsCog(bot)) |
|
157
|
|
|
|
BonHowi /
discordPogmareBot
