async def job_leave(self, ctx):
"""Leave your job."""
db_connection = await db.dbconnection()
cursor = await db_connection.cursor()
user_id = ctx.author.id
sql = "SELECT * FROM jobs WHERE character_id = '%s' AND current_job = %s"
val = (user_id, 'true')
await cursor.execute(sql, val)
results = await cursor.fetchall()
if is_empty(results):
await cursor.close()
db_connection.close()
return await ctx.send(
"You dont have a job. Use `!job join {job_name}` to join one.")
else:
sql = "SELECT job FROM jobs WHERE current_job = %s"
val = "true"
await cursor.execute(sql, (val, ))
results = await cursor.fetchall()
sql = "UPDATE jobs SET current_job = %s WHERE character_id = '%s' AND job = %s"
val = ('false', user_id, results[0][0])
await cursor.execute(sql, val)
await db_connection.commit()
await cursor.close()
db_connection.close()
return await ctx.send("Left your job.")
async def reset_cmd(self, ctx):
"""Reset your character."""
db_connection = await db.dbconnection()
cursor = await db_connection.cursor()
user_id = ctx.author.id
channel = ctx.channel
select_characters = "SELECT * FROM `character` WHERE user_id = '%s'"
val = user_id
await cursor.execute(select_characters, (val, ))
result = await cursor.fetchall()
if is_empty(result) is True:
await cursor.close()
db_connection.close()
return await ctx.send(
"Can't reset progress because you havent created a character yet."
)
else:
await ctx.send("Are you sure you want to reset your progress? y/n")
try:
def check(m):
return m.channel == channel and ctx.author == m.author
msg = await self.bot.wait_for('message',
timeout=15.0,
check=check)
if msg.content == 'y' or msg.content == 'Y':
sql = "DELETE FROM `character` WHERE user_id = '%s'"
val = user_id
await cursor.execute(sql, (val, ))
try:
await db_connection.commit()
await cursor.close()
db_connection.close()
return await ctx.send(
'Character removed. Use !character to create a new one.'
)
except:
await cursor.close()
db_connection.close()
return await ctx.send(
'Could not remove your character. Something went wrong.'
)
elif msg.content == 'n' or msg.content == 'N':
await cursor.close()
db_connection.close()
return await ctx.send("Character reset cancelled.")
except asyncio.TimeoutError:
await cursor.close()
db_connection.close()
return await ctx.send('No response. Character reset stopped.')
async def job_join(self, ctx, job_to_join: str):
"""Join a new job."""
db_connection = await db.dbconnection()
cursor = await db_connection.cursor()
user_id = ctx.author.id
sql = "SELECT * FROM jobs WHERE character_id = '%s'"
val = user_id
await cursor.execute(sql, (val, ))
results = await cursor.fetchall()
result = []
available_jobs = []
columns = [desc[0] for desc in cursor.description]
for row in results:
row = dict(zip(columns, row))
if row['current_job'] == 'false':
result.append(row)
available_jobs.append(row['job'])
if is_empty(result):
await cursor.close()
db_connection.close()
return await ctx.send("You may only have 1 job at a time.")
else:
if job_to_join in available_jobs:
sql = "UPDATE jobs SET current_job = 'true' WHERE character_id = '%s' AND job = %s"
val = (user_id, job_to_join.lower())
await cursor.execute(sql, val)
await db_connection.commit()
await cursor.close()
db_connection.close()
return await ctx.send(
f"Changed your job to: {job_to_join.lower()}.")
else:
await cursor.close()
db_connection.close()
return await ctx.send(
f"That job doesnt exist. Pick one of the following: {[job for job in available_jobs]}"
)
async def character_cmd(self, ctx):
"""View your character or create one."""
db_connection = await db.dbconnection()
cursor = await db_connection.cursor()
user_id = ctx.author.id
channel = ctx.channel
select_characters = "SELECT * FROM `character` WHERE user_id = '%s'"
val = user_id
await cursor.execute(select_characters, (val, ))
result = await cursor.fetchall()
if is_empty(result) is True:
await ctx.send(
"Starting character creation process, what do you want your character to be called?"
)
try:
def check(m):
return m.channel == channel and ctx.author == m.author
msg = await self.bot.wait_for('message',
timeout=15.0,
check=check)
except asyncio.TimeoutError:
return await ctx.send(
'No response. Character creation stopped.')
character_name = msg.content
await ctx.send('Give me a short background on your character.')
try:
def check(m):
return m.channel == channel and ctx.author == m.author
msg = await self.bot.wait_for('message',
timeout=120.0,
check=check)
except asyncio.TimeoutError:
return await ctx.send(
'No response. Character creation stopped.')
character_description = msg.content
# insert the data the user has submitted
sql = "INSERT INTO `character`(`name`, user_id, description) VALUES(%s, %s, %s)"
val = (character_name, user_id, character_description)
await cursor.execute(sql, val)
# insert the standard data that is set on default
sql = "INSERT INTO inventory(character_id, gold) VALUES(%s, %s)"
val = (user_id, 100)
await cursor.execute(sql, val)
sql = "INSERT INTO jobs(character_id, job) VALUES(%s, %s)"
val = (user_id, 'miner')
await cursor.execute(sql, val)
try:
await db_connection.commit()
await cursor.close()
db_connection.close()
return await ctx.send(
'Succesfully created your character! Use !character to acces it.'
)
except:
await cursor.close()
db_connection.close()
return await ctx.send(
'Could not create your character. Something went wrong.')
else:
pages = []
select_character = "SELECT * FROM `character` " \
"LEFT JOIN inventory ON `character`.user_id = inventory.character_id " \
"LEFT JOIN jobs ON inventory.character_id = jobs.character_id " \
"AND jobs.current_job = %s " \
"WHERE `character`.user_id = '%s'"
val = ('true', user_id)
await cursor.execute(select_character, val)
results = await cursor.fetchall()
columns = [desc[0] for desc in cursor.description]
result = []
for row in results:
row = dict(zip(columns, row))
result.append(row)
embed = Embed(title=result[0]['name'],
colour=Colour.blurple(),
description=result[0]['description'])
embed.add_field(name="Details",
value=f"**Current Job:** {result[0]['job']} \n")
ores = ['stone', 'coal', 'iron', 'ruby']
desc = ''
for x in ores:
if result[0][x] > 0:
desc += f"**{x.capitalize()}:** {result[0][x]} \n"
embed.add_field(name='Inventory',
value=f"**Gold:** {result[0]['gold']}\n{desc}",
inline=False)
embed.set_footer(text="Page 1/3")
pages.append(embed)
desc = f"**Skill Shards:** {result[0]['skillshard']}"
embed = Embed(title="Skills",
colour=Colour.blurple(),
description=desc)
embed.set_footer(text="Page 2/3")
pages.append(embed)
desc = f"**Autosell:** {result[0]['autosell']}"
embed = Embed(title="Settings",
colour=Colour.blurple(),
description=desc)
embed.set_footer(text="Page 3/3")
pages.append(embed)
await cursor.close()
db_connection.close()
embed = Paginator(embed=False,
timeout=90,
use_defaults=True,
extra_pages=pages,
length=1)
await embed.start(ctx)