async def force_new_licensed_member(
self, ctx, member: discord.Member, role: discord.Role,
*, license_dur: license_duration
):
expiration_date = construct_expiration_date(license_dur)
await self.bot.main_db.add_new_licensed_member(member.id, ctx.guild.id, expiration_date, role.id)
await ctx.send(embed=success("Done", ctx.me))
async def activate_license(self, ctx, license, member):
"""
:param ctx: invoked context
:param license: license to add
:param member: who to give role to
"""
guild = ctx.guild
if await self.bot.main_db.is_valid_license(license, guild.id):
# Adding role to the member requires that role object
# First we get the role linked to the license
role_id = await self.bot.main_db.get_license_role_id(license)
role = ctx.guild.get_role(role_id)
if role is None:
log_error_msg = (
f"Can't find role {role_id} in guild {guild.id} '{guild.name}' "
f"from license: '{license}' member to give the role to: {member.id} '{member.name}'"
"\n\nProceeding to delete this invalid license from database!"
)
logger.critical(log_error_msg)
msg = (
"Well this is awkward...\n\n"
"The role that was supposed to be given out by this license has been deleted from this guild!"
f"\n\nError message:\n\n{log_error_msg}")
await ctx.send(embed=failure_embed(msg))
await self.bot.main_db.delete_license(license)
return
# Now before doing anything check if member already has the role
# Beside for logic (why redeem already existing subscription?) if we don't check this we will get
# sqlite3.IntegrityError:
# UNIQUE constraint failed:LICENSED_MEMBERS.MEMBER_ID,LICENSED_MEMBERS.LICENSED_ROLE_ID
# when adding new licensed member to table LICENSED_MEMBERS if member already has the role (because in that
# table the member id and role id is unique aka can only have uniques roles tied to member id)
if role in member.roles:
# We notify user that he already has the role, we also show him the expiration date
try:
expiration_date = await self.bot.main_db.get_member_license_expiration_date(
member.id, role_id)
except DatabaseMissingData as e:
# TODO print role name instead of ID (from e)
msg = e.message
msg += (
f"\nThe bot did not register {member.mention} in the database with that role but somehow they have it."
"\nThis probably means that they were manually assigned this role without using the bot license system."
"\nHave someone remove the role from them and call this command again."
)
await ctx.send(embed=failure_embed(msg))
await ctx.message.delete()
return
remaining_time = get_remaining_time(expiration_date)
msg = (
f"{member.mention} already has an active subscription for the {role.mention} role!"
f"\nIt's valid for another {remaining_time}")
await ctx.send(embed=warning_embed(msg))
await ctx.message.delete()
return
# We add the role to the member, we do this before adding/removing stuff from db
# just in case the bot doesn't have perms and throws exception (we already
# checked for bot_has_permissions(manage_roles=True) but it can happen that bot has
# that permission and check is passed but it's still forbidden to alter role for the
# member because of it's role hierarchy.) -> will raise Forbidden and be caught by cmd error handler
await member.add_roles(role, reason="Redeemed license.")
# We add entry to db table LICENSED_MEMBERS (which we will checked periodically for expiration)
# First we get the license duration so we can calculate expiration date
license_duration = await self.bot.main_db.get_license_duration_hours(
license)
expiration_date = construct_expiration_date(license_duration)
# In case where you successfully redeemed the role and it's still in database(not expired)
# BUT someone manually removed the role, in that case when you try to redeem a valid license
# for the said role you will get IntegrityError because LICENSED_ROLE_ID and MEMBER_ID have to
# be unique (and the entry still exists in database).
# Even when caught by remove role event leave this
try:
await self.bot.main_db.add_new_licensed_member(
member.id, guild.id, expiration_date, role_id)
except IntegrityError:
# We remove the database entry because when role was remove the bot was
# probably offline and couldn't register the role remove event
await self.bot.main_db.delete_licensed_member(
member.id, role_id)
await self.bot.main_db.add_new_licensed_member(
member.id, guild.id, expiration_date, role_id)
msg = (
f"Someone removed the role manually from {member.mention} but no worries,\n"
"since the license is valid we're just gonna reactivate it :)"
)
await ctx.send(embed=info_embed(msg, ctx.me))
# Remove guild license from database, so it can't be redeemed again
await self.bot.main_db.delete_license(license)
# Send message notifying user
msg = f"License valid - adding role {role.mention} to {member.mention} in duration of {license_duration}h"
await ctx.send(embed=success_embed(msg, ctx.me))
else:
await ctx.send(embed=failure_embed(
"The license key you entered is invalid/deactivated."))