async def addalias(self, ctx, alias, *, member):
"""Add alias to a member [Format: %addalias (alias) (member full name)]"""
try:
c.execute(
"SELECT COUNT(*) FROM groupmembers.Member WHERE FullName = %s",
(member, ))
counter = fetch_one()
if counter == 0:
await ctx.send("> **That person does not exist.**")
else:
c.execute(
"SELECT Aliases FROM groupmembers.Member WHERE FullName = %s",
(member, ))
current_aliases = fetch_one()
if current_aliases == "NULL":
new_aliases = alias
else:
new_aliases = f"{current_aliases},{alias.lower()}"
c.execute(
"UPDATE groupmembers.Member SET Aliases = %s WHERE FullName = %s",
(new_aliases, member))
DBconn.commit()
await ctx.send(f"> **Added Alias: {alias} to {member}**")
except Exception as e:
await ctx.send(e)
log.console(e)
async def get_photos(self, url, member, groups, stage_name, aliases):
try:
if aliases != "NULL":
aliases = aliases.lower()
c.execute(
"SELECT COUNT(*) FROM groupmembers.Member WHERE FullName = %s",
(member, ))
count = fetch_one()
if count == 0:
c.execute(
"INSERT INTO groupmembers.Member VALUES (%s,%s,%s,%s)",
(member, stage_name, groups, aliases))
DBconn.commit()
c.execute(
"SELECT ID FROM groupmembers.Member WHERE FullName = %s",
(member, ))
id = fetch_one()
c.execute("INSERT INTO groupmembers.ImageLinks VALUES (%s,%s)",
(url, id))
DBconn.commit()
else:
c.execute(
"SELECT ID FROM groupmembers.Member WHERE FullName = %s",
(member, ))
id = fetch_one()
c.execute("INSERT INTO groupmembers.ImageLinks VALUES (%s,%s)",
(url, id))
log.console(f"Added {url} for {member}")
except Exception as e:
# most likely unique constraint failed.
log.console(f"{e} {url} for {member}")
pass
DBconn.commit()
async def stand(self, ctx):
"""Keep Your Cards [Format: %stand]"""
userid = ctx.author.id
try:
c.execute(
"SELECT GameID FROM currency.Games WHERE Player1 = %s OR Player2 = %s",
(userid, userid))
game_id = fetch_one()
c.execute(
"SELECT PLayer1,Player2 FROM currency.Games WHERE Player1 = %s OR Player2 = %s",
(userid, userid))
player = c.fetchone
Player1 = player[0]
Player2 = player[1]
c.execute("SELECT Stand FROM currency.GAMES WHERE GameID = %s",
(game_id, ))
stand = str(fetch_one())
if userid == Player1:
xyz = 1
if stand == '11' or stand == '12':
if stand[1] == '1':
new_stand = 21
if stand[1] == '2':
new_stand = 22
c.execute(
"UPDATE currency.Games SET Stand = %s WHERE GameID = %s",
(
new_stand,
game_id,
))
DBconn.commit()
if userid == Player2:
xyz = 2
if stand == '11' or stand == '21':
if stand[0] == '1':
new_stand = 12
if stand[0] == '2':
new_stand = 22
c.execute(
"UPDATE currency.Games SET Stand = %s WHERE GameID = %s",
(
new_stand,
game_id,
))
DBconn.commit()
c.execute(
"SELECT Score{} FROM currency.Games WHERE GameID = %s".format(
xyz), (game_id, ))
current_val = fetch_one()
await ctx.send(
"> **<@{}> has finalized their deck with a total of ||{}|| points.**"
.format(userid, current_val),
delete_after=40)
except:
await ctx.send("> **You are not currently in a game.**",
delete_after=40)
async def count(self, ctx, *, name):
"""Shows howmany times an idol has been called. [Format: %count (idol's name)]"""
try:
c.execute(
"SELECT ID, FullName, StageName, Aliases FROM groupmembers.Member"
)
all_members = fetch_all()
final_count = "Unknown"
for mem in all_members:
check = 0
ID = mem[0]
full_name = mem[1]
stage_name = mem[2]
aliases = mem[3]
if aliases != "NULL":
aliases = aliases.split(',')
for alias in aliases:
if alias.lower() == name.lower():
check = 1
if name.lower() == full_name.lower() or name.lower(
) == stage_name.lower():
check = 1
if check == 1:
c.execute(
"SELECT COUNT(*) FROM groupmembers.Count WHERE MemberID = %s",
(ID, ))
counter = fetch_one()
if counter == 0:
await ctx.send(
f"> **{full_name} ({stage_name}) has not been called by a user yet.**"
)
else:
c.execute(
"SELECT Count FROM groupmembers.Count WHERE MemberID = %s",
(ID, ))
counter = fetch_one()
c.execute(
"SELECT MemberID FROM groupmembers.Count ORDER BY Count DESC"
)
all_counters = fetch_all()
count = 0
for rank in all_counters:
count += 1
mem_id = rank[0]
if mem_id == ID:
final_count = count
await ctx.send(
f"> **{full_name} ({stage_name}) has been called {counter} times at rank {final_count}.**"
)
except Exception as e:
log.console(e)
async def on_message(message):
try:
# fetching temporary channels that have delays for removed messages.
c.execute("SELECT chanID, delay FROM currency.TempChannels")
temp_channels = fetch_all()
message_sender = message.author
message_content = message.clean_content
message_channel = message.channel
# check if messages are in a temporary channel
for temp in temp_channels:
chan_id = temp[0]
delay = temp[1]
if message_channel.id == chan_id:
await message.delete(delay=delay)
if check_message_not_empty(message):
# check if the message belongs to the bot
if message_sender.id != client.user.id:
if message_content[0] != '%':
# it had to be written somewhere :( and I'm not about to pull it from a table
if 'n***a' in message_content.lower(
) or 'nigger' in message_content.lower(
) and ':' not in message_content.lower():
author_id = message_sender.id
# checks how many instances ( should logically only be 0 or 1 )
c.execute(
"SELECT COUNT(*) FROM currency.Counter WHERE UserID = %s::bigint",
(author_id, ))
checker = fetch_one()
if checker > 0:
c.execute(
"SELECT NWord FROM currency.Counter WHERE UserID = %s::bigint",
(author_id, ))
current_count = fetch_one()
current_count += 1
c.execute(
"UPDATE currency.Counter SET NWord = %s WHERE UserID = %s::bigint",
(current_count, author_id))
if checker == 0:
c.execute(
"INSERT INTO currency.Counter VALUES (%s,%s)",
(author_id, 1))
DBconn.commit()
if get_message_prefix(message) == '%':
log.console(
f"CMD LOG: ChannelID = {message_channel.id} - {message_sender} || {message_content} "
)
await client.process_commands(message)
except Exception as e:
log.console(e)
DBconn.rollback()
async def new_task5(self):
check = True
try:
c.execute("SELECT link FROM currency.links")
links = fetch_all()
except Exception as e:
check = False
pass
if check:
try:
for link in links:
c.execute(
"SELECT LinkID FROM currency.links WHERE Link = %s",
link)
link_id = fetch_one()
async with aiohttp.ClientSession() as session:
async with session.get('{}'.format(link[0])) as r:
if r.status == 200:
page_html = await r.text()
# log.console(page_html)
page_soup = soup(page_html, "html.parser")
view_count = (page_soup.find(
"div", {"class": "watch-view-count"})).text
now = datetime.now()
c.execute(
"INSERT INTO currency.ViewCount VALUES (%s,%s,%s)",
(link_id, view_count, now))
self.view_count.append(view_count)
self.now.append(now)
DBconn.commit()
# log.console("Updated Video Views Tracker")
except Exception as e:
log.console(e)
self.view_count = []
self.now = []
async def endgame(self, ctx):
"""End your current game [Format: %endgame] [Aliases: eg]"""
try:
c.execute(
"SELECT currency.GameID FROM Games WHERE Player1 = %s OR Player2 = %s",
(ctx.author.id, ctx.author.id))
game_id = fetch_one()
c.execute(
"DELETE FROM currency.Games WHERE Player1 = %s OR Player2 = %s",
(ctx.author.id, ctx.author.id))
c.execute("DELETE FROM currency.BlackJack WHERE GameID = %s",
(game_id, ))
DBconn.commit()
for task in self.tasks:
# await ctx.send(task)
x = task[0]
y = task[1]
z = task[2]
if ctx.author.id == y or ctx.author.id == z:
x.stop()
self.tasks.remove(task)
await ctx.send(
"> **You have been removed from your current game.**",
delete_after=5)
self.count = 0
except:
await ctx.send("> **You are not currently in a running game.**",
delete_after=40)
async def latest(self, ctx):
"""Grabs the highest resolution possible from MOST RECENT DC Post [Format: %latest]"""
c.execute("SELECT URL FROM currency.DCUrl")
my_url = fetch_one()
try:
async with aiohttp.ClientSession() as session:
async with session.get('{}'.format(my_url)) as r:
url_list = []
if r.status == 200:
page_html = await r.text()
page_soup = soup(page_html, "html.parser")
image_url = (page_soup.findAll("div", {"class": "imgSize width"}))
for image in image_url:
new_image_url = image.img["src"]
DC_Date = new_image_url[41:49]
unique_id = new_image_url[55:87]
file_format = new_image_url[93:]
HD_Link = f'https://file.candlemystar.com/post/{DC_Date}{unique_id}{file_format}'
url_list.append(HD_Link)
await ctx.send(f"> **Here are the Original Photos for <{my_url}>**:")
for link in url_list:
await ctx.send(f"<{link}>")
else:
await ctx.send(f"> **Error {r.status}: Unable to retrieve latest photos.**")
except:
await ctx.send(f"> **Unable to retrieve latest photos.** ")
async def leaderboard(self, ctx):
"""Shows Top 10 Users [Format: %leaderboard][Aliases: leaderboards, lb]"""
c.execute("SELECT count(UserID) FROM currency.Currency")
counter = fetch_one()
embed = discord.Embed(title=f"Currency Leaderboard", color=0xffb6c1)
embed.set_author(name="Irene", url='https://www.youtube.com/watch?v=dQw4w9WgXcQ', icon_url='https://cdn.discordapp.com/emojis/693392862611767336.gif?v=1')
embed.set_footer(text="Type %bal (user) to view their balance.", icon_url='https://cdn.discordapp.com/emojis/683932986818822174.gif?v=1')
if counter == 0:
await ctx.send("> **There are no users to display.**", delete_after=60)
if counter > 0:
c.execute("Select UserID,Money FROM currency.Currency")
amount = fetch_all()
sort_money = []
for sort in amount:
new_user = [sort[0], int(sort[1])]
sort_money.append(new_user)
sort_money.sort(key=lambda x: x[1], reverse=True)
count = 0
for a in sort_money:
count += 1
UserID = a[0]
Money = a[1]
UserName = self.client.get_user(UserID)
if count <= 10:
embed.add_field(name=f"{count}) {UserName} ({UserID})", value=await shorten_balance(str(Money)), inline=True)
await ctx.send(embed=embed)
async def sendall(self, ctx):
"""Toggles sending all messages to log channel. If turned off, it only sends edited & deleted messages."""
if await check_if_logged(server_id=ctx.guild.id):
c.execute("SELECT sendall FROM logging.servers WHERE serverid = %s", (ctx.guild.id,))
if fetch_one() == 0:
c.execute("UPDATE logging.servers SET sendall = %s WHERE serverid = %s", (1, ctx.guild.id))
await ctx.send(f"> **All messages will now be sent in the logging channel.**")
else:
c.execute("UPDATE logging.servers SET sendall = %s WHERE serverid = %s", (0, ctx.guild.id))
await ctx.send(f"> **Only edited and deleted messages will be sent in the logging channel.**")
else:
await ctx.send("> **This server is not being logged.**")
async def nword(self, ctx, user: discord.Member = "@user"):
"""Checks how many times a user has said the N Word [Format: %nword @user]"""
if user == "@user":
await ctx.send("> **Please @ a user**")
if user != "@user":
c.execute(
"SELECT COUNT(*) FROM currency.Counter WHERE UserID = %s",
(user.id, ))
checker = fetch_one()
if checker > 0:
c.execute(
"SELECT NWord FROM currency.Counter WHERE UserID = %s",
(user.id, ))
current_count = fetch_one()
await ctx.send(
f"> **<@{user.id}> has said the N-Word {current_count} time(s)!**"
)
if checker == 0:
await ctx.send(
f"> **<@{user.id}> has not said the N-Word a single time!**"
)
async def on_message_log(self, message):
if await check_logging_requirements(message):
try:
c.execute("SELECT sendall FROM logging.servers WHERE serverid = %s", (message.guild.id,))
if fetch_one() == 1:
logging_channel = await get_log_channel_id(message, self.client)
files = await get_attachments(message)
embed_message = f"**{message.author} ({message.author.id})\nMessage: **{message.content}**\nFrom {message.guild} in {message.channel}\nCreated at {message.created_at}\n<{message.jump_url}>**"
embed = discord.Embed(title="Message Sent", description=embed_message, color=0xffffff)
await logging_channel.send(embed=embed, files=files)
except Exception as e:
log.console(f"ON_MESSAGE_LOG ERROR: {e} Server ID: {message.guild.id} Channel ID: {message.channel.id}")
async def updates(self, ctx,*, solution=""):
"""Send DC Updates to your current text channel [Format: %updates] | To Stop : [Format: %updates stop]"""
channel = ctx.channel.id
if solution == "stop":
c.execute("SELECT COUNT(*) From currency.DreamCatcher WHERE ServerID = %s",(channel,))
counter = fetch_one()
if counter == 1:
await ctx.send ("> **This channel will no longer receive updates.**")
c.execute("DELETE FROM currency.DreamCatcher WHERE ServerID = %s",(channel,))
DBconn.commit()
if counter == 0:
await ctx.send("> **This channel does not currently receive updates.**")
if solution != "stop":
c.execute("SELECT COUNT(*) From currency.DreamCatcher WHERE ServerID = %s", (channel,))
counter = fetch_one()
if counter == 1:
await ctx.send ("> **This channel already receives DC Updates**")
if counter == 0:
channel_name = self.client.get_channel(channel)
await ctx.send("> **I Will Post All DC Updates In {}**".format(channel_name))
c.execute("INSERT INTO currency.DreamCatcher VALUES (%s)",(channel,))
DBconn.commit()
async def removealias(self, ctx, alias, *, member):
"""Add alias to a member [Format: %addalias (alias) (member full name)]"""
try:
c.execute(
"SELECT COUNT(*) FROM groupmembers.Member WHERE FullName = %s",
(member, ))
count = fetch_one()
if count == 0:
await ctx.send("> **That person does not exist.**")
else:
c.execute(
"SELECT Aliases FROM groupmembers.Member WHERE FullName = %s",
(member, ))
current_aliases = fetch_one()
if current_aliases == "NULL":
await ctx.send("> **That alias does not exist**")
else:
check = current_aliases.find(alias.lower(), 0)
if check == -1:
await ctx.send(f"> **Could not find alias: {alias}**")
else:
new_aliases = ""
alias_list = current_aliases.split(',')
for alias2 in alias_list:
if alias.lower() != alias2.lower():
new_aliases += f"{alias2.lower()},"
if new_aliases == "" or new_aliases == ",":
new_aliases = "NULL"
if new_aliases[len(new_aliases) - 1] == ',':
new_aliases = new_aliases[0:len(new_aliases) - 2]
c.execute(
"UPDATE groupmembers.Member SET Aliases = %s WHERE FullName = %s",
(new_aliases, member))
DBconn.commit()
await ctx.send(
f"> **Alias: {alias} was removed from {member}.**")
except Exception as e:
await ctx.send(e)
log.console(e)
async def amount_of_links(member_id, current_full_name,
current_stage_name):
c.execute(
"SELECT COUNT(*) FROM groupmembers.ImageLinks WHERE MemberID = %s",
(member_id, ))
counter = fetch_one()
if counter == 0:
await ctx.send(
f"> **There are no results for {current_full_name} ({current_stage_name})**"
)
else:
await ctx.send(
f"> **There are {counter} images for {current_full_name} ({current_stage_name}).**"
)
def checker():
c.execute("SELECT COUNT(*) FROM archive.ArchivedChannels")
check = fetch_one()
if check > 0:
c.execute(
"SELECT id, filename, filetype, folderid FROM archive.ArchivedChannels"
)
posts = fetch_all()
for post in posts:
ID = post[0]
FileName = post[1]
FileType = post[2]
FolderID = post[3]
Drive.upload_to_drive(ID, FolderID, FileName, FileType)
async def logadd(self, ctx):
"""Start logging the current text channel."""
if await check_if_logged(server_id=ctx.guild.id):
if not await check_if_logged(channel_id=ctx.channel.id):
c.execute("SELECT COUNT(*) FROM logging.servers WHERE channelid = %s", (ctx.channel.id,))
if fetch_one() == 0:
logging_id = await get_logging_id(ctx.guild.id)
c.execute("INSERT INTO logging.channels (channelid, server) VALUES(%s, %s)", (ctx.channel.id, logging_id))
DBconn.commit()
await ctx.send(f"> **This channel is now being logged.**")
else:
await ctx.send(f"> **This channel can not be logged since log messages are sent here.**")
else:
await ctx.send(f"> **This channel is already being logged.**")
else:
await ctx.send(f"> **The server must be logged in order to log a channel.**")
async def sort(self, ctx):
"""Approve member links with a small sorting game."""
try:
keep_going = True
while keep_going:
c.execute("SELECT COUNT(*) FROM groupmembers.ScrapedLinks")
counter = fetch_one()
if counter == 0:
await ctx.send("> **There are no links to sort.**")
keep_going = False
c.execute("SELECT ID,Link FROM groupmembers.ScrapedLinks")
all_links = fetch_all()
for data in all_links:
data_id = data[0]
link = data[1]
await ctx.send(
f"> {link} **Please respond with the member's ID, delete, or stop**"
)
check_msg = await self.on_message2(ctx.message, 1)
if check_msg == 'delete':
c.execute(
"DELETE FROM groupmembers.ScrapedLinks WHERE ID = %s",
(data_id, ))
DBconn.commit()
await ctx.send("> **The link has been removed.**")
elif check_msg == 'stop':
await ctx.send("> **Stopping Sort**")
keep_going = False
break
elif check_msg == 'deleteall':
await ctx.send("> **Deleted all links**")
c.execute("DELETE FROM groupmembers.ScrapedLinks")
DBconn.commit()
keep_going = False
break
else:
c.execute(
"INSERT INTO groupmembers.imagelinks VALUES (%s,%s)",
(link, int(check_msg)))
c.execute(
"DELETE FROM groupmembers.scrapedlinks WHERE ID = %s",
(data_id, ))
DBconn.commit()
except Exception as e:
log.console(e)
async def clearnword(self, ctx, user: discord.Member = "@user"):
"""Clear A User's Nword Counter [Format: %clearnword @user]"""
if user == "@user":
await ctx.send("> **Please @ a user**")
if user != "@user":
c.execute(
"SELECT COUNT(*) FROM currency.Counter WHERE UserID = %s",
(user.id, ))
checker = fetch_one()
if checker > 0:
c.execute("DELETE FROM currency.Counter where UserID = %s",
(user.id, ))
await ctx.send("**> Cleared.**")
DBconn.commit()
if checker == 0:
await ctx.send(
f"> **<@{user.id}> has not said the N-Word a single time!**"
)
async def scandrive(self, ctx, name="NULL", member_id=0):
"""Scan DriveIDs Table and update other tables."""
try:
c.execute("SELECT id, linkid, name FROM archive.DriveIDs")
all_links = fetch_all()
for pic in all_links:
try:
ID = pic[0]
Link_ID = pic[1]
Link_Name = pic[2]
new_link = f"https://drive.google.com/uc?export=view&id={Link_ID}"
c.execute("SELECT Name FROM archive.ChannelList")
all_names = fetch_all()
if name == "NULL" and member_id == 0:
for idol_name in all_names:
idol_name = idol_name[0]
if idol_name == Link_Name and (
idol_name != "Group"
or idol_name != "MDG Group"):
c.execute(
"SELECT ID FROM groupmembers.Member WHERE StageName = %s",
(idol_name, ))
member_id1 = fetch_one()
c.execute(
"INSERT INTO groupmembers.ImageLinks VALUES(%s,%s)",
(new_link, member_id1))
c.execute(
"DELETE FROM archive.DriveIDs WHERE ID = %s",
(ID, ))
DBconn.commit()
elif Link_Name.lower() == name.lower():
c.execute("DELETE FROM archive.DriveIDs WHERE ID = %s",
(ID, ))
c.execute(
"INSERT INTO groupmembers.ImageLinks VALUES(%s,%s)",
(new_link, member_id))
DBconn.commit()
except Exception as e:
log.console(e)
DBconn.commit()
await ctx.send(f"> **Completed Scan**")
except Exception as e:
log.console(e)
DBconn.commit()
async def deletechannel(self, ctx):
"""Stop the current channel from being archived [Format: %deletechannel]"""
try:
c.execute(
"SELECT COUNT(*) FROM archive.ChannelList WHERE ChannelID = %s",
(ctx.channel.id, ))
count = fetch_one()
if count == 0:
await ctx.send(
"> **This channel is not currently being archived.**")
else:
c.execute(
"DELETE FROM archive.ChannelList WHERE ChannelID = %s",
(ctx.channel.id, ))
DBconn.commit()
await ctx.send("> **This channel is no longer being archived**"
)
except Exception as e:
log.console(e)
await ctx.send("> **There was an error.**")
async def scrapeyoutube(self, ctx):
"""Scrape Youtube Video"""
c.execute("SELECT link FROM currency.links")
links = fetch_all()
for link in links:
c.execute("SELECT LinkID FROM currency.links WHERE Link = %s",
(link, ))
id = fetch_one()
async with aiohttp.ClientSession() as session:
async with session.get('{}'.format(link[0])) as r:
if r.status == 200:
page_html = await r.text()
log.console(page_html)
page_soup = soup(page_html, "html.parser")
view_count = (page_soup.find(
"div", {"class": "watch-view-count"})).text
# c.execute("INSERT INTO currency.ViewCount VALUES (%s,%s)", (id,datetime.now()))
# DBconn.commit()
await ctx.send(
f"> **Managed to scrape DC SCREAM -- {view_count} -- {datetime.now()}**"
)
async def download_all_task(ctx):
self.download_all_number += 1
number = self.download_all_number
# if number >= latest post
# last run on 40830
c.execute("SELECT PostID FROM currency.DCPost")
if number >= fetch_one():
download_all_task.cancel()
else:
my_url = 'https://dreamcatcher.candlemystar.com/post/{}'.format(number)
async with aiohttp.ClientSession() as session:
async with session.get('{}'.format(my_url)) as r:
if r.status == 200:
page_html = await r.text()
page_soup = soup(page_html, "html.parser")
username = (page_soup.find("div", {"class": "card-name"})).text
if username in self.list:
image_url = (page_soup.findAll("div", {"class": "imgSize width"}))
for image in image_url:
new_image_url = image.img["src"]
DC_Date = new_image_url[41:49]
unique_id = new_image_url[55:87]
file_format = new_image_url[93:]
HD_Link = f'https://file.candlemystar.com/post/{DC_Date}{unique_id}{file_format}'
async with session.get(HD_Link) as resp:
fd = await aiofiles.open('DCAppDownloaded/{}'.format(f"{unique_id[:8]}{file_format}"), mode='wb')
await fd.write(await resp.read())
await fd.close()
log.console(f"Downloaded {unique_id[:8]}{file_format} on {number}")
number += 1
else:
log.console("DOWNLOAD Passing Post from POST #{}".format(number))
elif r.status == 304:
log.console("> **Access Denied - {}**".format(number))
elif r.status == 404:
log.console("DOWNLOAD Error 404. {} was not Found.".format(number))
pass
else:
log.console("DOWNLOAD Other Error")
async def paste_all_links(ctx):
# put to 1 if you already have links that can be used
try:
self.create_links_number += 1
number = self.create_links_number
# if number >= latest post
c.execute("SELECT PostID FROM currency.DCPost")
if number >= fetch_one():
paste_all_links.cancel()
else:
my_url = 'https://dreamcatcher.candlemystar.com/post/{}'.format(number)
async with aiohttp.ClientSession() as session:
async with session.get('{}'.format(my_url)) as r:
if r.status == 200:
page_html = await r.text()
page_soup = soup(page_html, "html.parser")
username = (page_soup.find("div", {"class": "card-name"})).text
if username in self.list:
Gahyeon = self.list[0]
Siyeon = self.list[1]
Yoohyeon = self.list[2]
JiU = self.list[3]
SuA = self.list[4]
DC = self.list[5]
Dami = self.list[6]
Handong = self.list[7]
member_name = ""
if username == Gahyeon:
member_name = "Gahyeon"
if username == Siyeon:
member_name = "Siyeon"
if username == Yoohyeon:
member_name = "Yoohyeon"
if username == JiU:
member_name = "JIU"
if username == SuA:
member_name = "SUA"
if username == DC:
member_name = "DC"
if username == Dami:
member_name = "Dami"
if username == Handong:
member_name = "Handong"
image_url = (page_soup.findAll("div", {"class": "imgSize width"}))
for image in image_url:
new_image_url = image.img["src"]
DC_Date = new_image_url[41:49]
unique_id = new_image_url[55:87]
file_format = new_image_url[93:]
HD_Link = f'https://file.candlemystar.com/post/{DC_Date}{unique_id}{file_format}'
try:
c.execute("INSERT INTO currency.DCHDLinks VALUES (%s,%s,%s)", (HD_Link, member_name, number))
except Exception as e:
log.console(e)
pass
DBconn.commit()
log.console(f"DC Link posted on DB for post {number}")
else:
log.console("LINK Passing Post from POST #{}".format(number))
elif r.status == 304:
log.console("> **Access Denied - {}**".format(number))
elif r.status == 404:
log.console("LINK Error 404. {} was not Found.".format(number))
pass
else:
log.console("LINK Other Error")
except:
pass
async def new_task4(self):
# log.console (self.number)
self.count_loop += 1
if self.first_run == 1:
c.execute("SELECT PostID FROM currency.DCPost")
number = fetch_one()
self.first_run = 0
self.number = number
self.post_list.append(number)
if self.error_status == 1:
if self.tries >= 2 and self.tries < 5:
self.number += 1
if self.tries >= 5:
count_list = (len(self.post_list))
# log.console (count_list)
# log.console (self.post_list)
self.number = self.post_list[count_list - 1]
# log.console (self.number)
self.tries = 0
if self.error_status == 0:
self.tries = 0
self.number += 1
pass
# log.console (self.number)
my_url = 'https://dreamcatcher.candlemystar.com/post/{}'.format(self.number)
async with aiohttp.ClientSession() as session:
async with session.get('{}'.format(my_url)) as r:
if r.status == 200:
c.execute("DELETE FROM currency.DCPost")
c.execute("INSERT INTO currency.DCPost VALUES(%s)", (self.number,))
DBconn.commit()
self.error_status = 0
if self.number not in self.post_list:
# log.console("Connection Found")
page_html = await r.text()
# log.console(await r.text())
page_soup = soup(page_html, "html.parser")
username = (page_soup.find("div", {"class": "card-name"})).text
# await ctx.send(username)
if username in self.list:
Gahyeon = self.list[0]
Siyeon = self.list[1]
Yoohyeon = self.list[2]
JiU = self.list[3]
SuA = self.list[4]
DC = self.list[5]
Dami = self.list[6]
Handong = self.list[7]
image_url = (page_soup.findAll("div", {"class": "imgSize width"}))
image_links = []
for image in image_url:
new_image_url = image.img["src"]
DC_Date = new_image_url[41:49]
unique_id = new_image_url[55:87]
file_format = new_image_url[93:]
HD_Link = f'https://file.candlemystar.com/post/{DC_Date}{unique_id}{file_format}'
image_links.append(HD_Link)
async with session.get(HD_Link) as resp:
fd = await aiofiles.open(
'DreamHD/{}'.format(f"{unique_id[:8]}{file_format}"), mode='wb')
await fd.write(await resp.read())
await fd.close()
another_list = []
new_count = -1
final_image_list = []
for image in image_url:
new_count += 1
new_image_url = image.img["src"]
file_name = new_image_url[82:]
async with session.get(new_image_url) as resp:
fd = await aiofiles.open('DCApp/{}'.format(file_name), mode='wb')
await fd.write(await resp.read())
await fd.close()
file_size = (os.path.getsize(f'DCApp/{file_name}'))
if file_size <= 20000:
keep_going = True
loop_count = 0
while keep_going:
log.console(f"Stuck in a loop {loop_count}")
loop_count += 1
try:
os.unlink(f'DCApp/{file_name}')
except Exception as e:
log.console(e)
fd = await aiofiles.open('DCApp/{}'.format(file_name), mode='wb')
await fd.write(await resp.read())
await fd.close()
file_size = (os.path.getsize(f'DCApp/{file_name}'))
if file_size > 20000:
another_list.append(file_name)
keep_going = False
if loop_count == 30:
try:
final_image_list.append(image_links[new_count])
os.unlink(f'DCApp/{file_name}')
keep_going = False
except Exception as e:
log.console(e)
keep_going = False
elif file_size > 20000:
another_list.append(file_name)
c.execute("DELETE FROM currency.DCUrl")
c.execute("INSERT INTO currency.DCUrl VALUES(%s)", (my_url,))
DBconn.commit()
video_list = (page_soup.findAll("div", {"class": "swiper-slide img-box video-box width"}))
count_numbers = 0
video_name_list = []
bat_name_list = []
for video in video_list:
count_numbers += 1
new_video_url = video.source["src"]
bat_name = "{}DC.bat".format(count_numbers)
bat_name_list.append(bat_name)
ab = open("Videos\{}".format(bat_name), "a+")
video_name = "{}DCVideo.mp4".format(count_numbers)
info = 'ffmpeg -i "{}" -c:v libx264 -preset slow -crf 22 "Videos/{}"'.format(new_video_url,
video_name)
video_name_list.append(video_name)
ab.write(info)
ab.close()
for bat_name in bat_name_list:
# open bat file
check_bat = await asyncio.create_subprocess_exec("Videos\\{}".format(bat_name),
stderr=asyncio.subprocess.PIPE)
await check_bat.wait()
c.execute("SELECT ServerID FROM currency.DreamCatcher")
a1 = fetch_all()
for channel in a1:
channel = channel[0]
DC_Videos = []
try:
if len(video_name_list) != 0:
for video_name in video_name_list:
dc_video = discord.File(fp='Videos/{}'.format(video_name), filename=video_name)
DC_Videos.append(dc_video)
except Exception as e:
log.console (e)
pass
DC_Photos = []
try:
if len(another_list) != 0:
for file_name in another_list:
dc_photo = discord.File(fp='DCApp/{}'.format(file_name),
filename=file_name)
DC_Photos.append(dc_photo)
except Exception as e:
log.console (e)
pass
channel = self.client.get_channel(channel)
# 'NoneType' object has no attribute 'send' -- Channel does not exist (catching error)
try:
member_id = None
member_name = None
if username == Gahyeon:
member_name = "Gahyeon"
member_id = 163
await channel.send(">>> **New Gahyeon Post\n<{}>**".format(my_url))
if username == Siyeon:
member_name = "Siyeon"
member_id = 159
await channel.send(">>> **New Siyeon Post\n<{}>**".format(my_url))
if username == Yoohyeon:
member_name = "Yoohyeon"
member_id = 161
await channel.send(">>> **New Yoohyeon Post\n<{}>**".format(my_url))
if username == JiU:
member_name = "JIU"
member_id = 157
await channel.send(">>> **New JiU Post\n<{}>**".format(my_url))
if username == SuA:
member_name = "SUA"
member_id = 158
await channel.send(">>> **New SuA Post\n<{}>**".format(my_url))
if username == DC:
member_name = "DC"
await channel.send(">>> **New DreamCatcher Post\n<{}>**".format(my_url))
if username == Dami:
member_name = "Dami"
member_id = 162
await channel.send(">>> **New Dami Post\n<{}>**".format(my_url))
if username == Handong:
member_name = "Handong"
member_id = 160
await channel.send(">>> **New Handong Post\n<{}>**".format(my_url))
if self.already_added == 1:
for link in image_links:
try:
if member_id is not None:
c.execute("INSERT INTO groupmembers.imagelinks VALUES (%s,%s)", (link, member_id))
c.execute("INSERT INTO currency.DCHDLinks VALUES (%s,%s,%s)", (link, member_name, self.number))
DBconn.commit()
self.already_added = 1
except Exception as e:
log.console(e)
pass
except Exception as e:
log.console(e)
pass
try:
if len(another_list) != 0:
for dc_photo in DC_Photos:
await channel.send(file=dc_photo)
if len(video_name_list) != 0:
for video in video_name_list:
await channel.send(file=video)
if len(final_image_list) != 0:
for link in final_image_list:
await channel.send(link)
except Exception as e:
log.console (e)
pass
all_videos = os.listdir('Videos')
for video in all_videos:
try:
os.unlink('Videos/{}'.format(video))
except Exception as e:
log.console(e)
pass
all_photos = os.listdir('DCApp')
for photo in all_photos:
try:
os.unlink('DCApp/{}'.format(photo))
except Exception as e:
log.console (e)
pass
else:
log.console("Passing Post from POST #{}".format(self.number))
# await ctx.send(">>> **Passing Post from {}, POST #{}**".format(username, self.number))
self.post_list.append(self.number)
elif r.status == 304:
log.console("> **Access Denied - {}**".format(self.number))
elif r.status == 404:
self.tries += 1
if self.count_loop % 500 == 0:
log.console("Error 404. {} was not Found.".format(self.number))
self.error_status = 1
pass
else:
log.console(r.status)
async def blackjack(self, ctx, *, amount=0):
"""Start a game of BlackJack [Format: %blackjack (amount)] [Aliases: bj]"""
if amount >= 0:
try:
game_type = 'blackjack'
player_1 = ctx.author.id
c.execute(
"SELECT count(*) FROM currency.Games WHERE Player1 = %s or Player2 = %s",
(player_1, player_1))
counter = fetch_one()
if counter == 1:
embed_message = "**You are already in a pending/active game. Please type %endgame to end your current game.**"
embed = discord.Embed(title="Error",
description=embed_message,
color=0xff00f6)
await ctx.send(embed=embed, delete_after=40)
if counter == 0:
player_2 = 0
player1_bid = amount
player2_bid = 0
c.execute(
"SELECT count(UserID) FROM currency.Currency WHERE USERID = %s",
(player_1, ))
count = fetch_one()
if count == 0:
await ctx.send(
"> **You are not currently registered. Please type %register to register.**",
delete_after=40)
if count == 1:
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_amount = int(fetch_one())
if amount > current_amount:
await ctx.send(
"> **You do not have enough money to give!**",
delete_after=40)
if amount <= current_amount:
c.execute(
"INSERT INTO currency.Games VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
(player_1, player_2, player1_bid, player2_bid,
0, 0, game_type, 11))
DBconn.commit()
c.execute(
"SELECT GameID FROM currency.Games WHERE Player1 = %s",
(player_1, ))
game_id = fetch_one()
await ctx.send(
"> **There are currently 1/2 members signed up for BlackJack. To join the game, please type %joingame {} (bid)**"
.format(game_id))
if count > 1:
await ctx.send(
"> **There is an error with the database. Please report to an administrator**",
delete_after=40)
except Exception as e:
log.console(e)
await ctx.send(
"> **You are already in a pending/active game. Please type %endgame to end your current game.**",
delete_after=40)
elif amount < 0:
await ctx.send("> **You cannot bet a negative number**")
async def joingame(self, ctx, gameid=0, amount=0):
"""Join a game [Format: %joingame (gameid) (bid)] [Aliases: jg]"""
if amount >= 0:
if gameid == 0:
await ctx.send(
"> **Please include the game id in your command. [Format: %jg (gameid) (bid)]**",
delete_after=40)
if gameid != 0:
try:
rules = "**Each Player gets 2 cards.\nIn order to get blackjack, your final value must equal 21.\nIf Player1 exceeds 21 and Player2 doesn't, Player1 busts and Player2 wins the game.\nYou will have two options.\nThe first option is to %Hit, which means to grab another card.\nThe second option is to %stand to not pick up anymore cards.\nEach Player will play one at a time so think ahead!\nIf both players bust, Player closest to 21 wins!\nNumber cards are their values.\nAces can be 1 or 11 depending on the scenario.\nJack, Queen, and King are all worth 10. **"
player_2 = ctx.author.id
player2_bid = amount
game_id = gameid
c.execute(
"SELECT Player1 FROM currency.Games WHERE GameID = %s",
(game_id, ))
check = fetch_one()
c.execute(
"SELECT Player2 FROM currency.Games WHERE GameID = %s",
(game_id, ))
check2 = fetch_one()
c.execute(
"SELECT COUNT(*) FROM currency.Games WHERE Player1 = %s OR Player2 = %s",
(player_2, player_2))
count_checker = fetch_one()
if count_checker >= 1:
await ctx.send(
"> **You are already in a pending/active game. Please type %endgame to end your current game.**",
delete_after=40)
if count_checker == 0:
if check2 != 0:
await ctx.send(
"> **This game has already started.**",
delete_after=40)
if check2 == 0:
if check == player_2:
await ctx.send(
"> **You are already in this game.**",
delete_after=40)
if check != player_2:
c.execute(
"SELECT count(UserID) FROM currency.Currency WHERE USERID = %s",
(player_2, ))
count = fetch_one()
if count == 0:
await ctx.send(
"> **You are not currently registered. Please type %register to register.**",
delete_after=40)
if count == 1:
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_amount = int(fetch_one())
if amount > current_amount:
await ctx.send(
"> **You do not have enough money to give!**",
delete_after=40)
if amount <= current_amount:
c.execute(
"UPDATE currency.Games SET Player2 = %s, Bid2 = %s WHERE GameID = %s",
(player_2, player2_bid, game_id))
DBconn.commit()
c.execute(
"SELECT Bid1, Bid2 FROM currency.Games Where GameID = %s",
(game_id, ))
total_1 = fetch_all()
for a in total_1:
x = a[0]
y = a[1]
total = x + y
await ctx.send(
"> **Starting BlackJack with a total bid of {:,} Dollars.**"
.format(total),
delete_after=60)
await ctx.send(">>> {}".format(rules),
delete_after=60)
new_list = []
file_1 = []
file_2 = []
for i in range(0, 4):
random_card = randint(1, 52)
while random_card in new_list:
random_card = randint(1, 52)
new_list.append(random_card)
for i in range(0, 2):
c.execute(
"SELECT cardname FROM currency.CardValues WHERE CardID = %s",
(new_list[i], ))
card_name = fetch_one()
c.execute(
"SELECT value FROM currency.CardValues WHERE CardID = %s",
(new_list[i], ))
card_value = fetch_one()
c.execute(
"SELECT Score1 FROM currency.Games WHERE GameID = %s",
(game_id, ))
current_val = fetch_one()
c.execute(
"INSERT INTO currency.BlackJack VALUES (%s, %s, %s)",
(game_id, new_list[i], 1))
tot1 = current_val + card_value
c.execute(
"UPDATE currency.Games SET Score1 = %s WHERE GameID = %s",
(tot1, game_id))
card_1 = discord.File(
fp='Cards/{}.jpg'.format(
new_list[i]),
filename='{}.jpg'.format(
new_list[i]),
spoiler=True)
file_1.append(card_1)
DBconn.commit()
for i in range(2, 4):
c.execute(
"SELECT cardname FROM currency.CardValues WHERE CardID = %s",
(new_list[i], ))
card_name = fetch_one()
c.execute(
"SELECT value FROM currency.CardValues WHERE CardID = %s",
(new_list[i], ))
card_value = fetch_one()
c.execute(
"SELECT Score2 FROM currency.Games WHERE GameID = %s",
(game_id, ))
current_val = fetch_one()
c.execute(
"INSERT INTO currency.BlackJack VALUES (%s, %s, %s)",
(game_id, new_list[i], 2))
tot = current_val + card_value
c.execute(
"UPDATE currency.Games SET Score2 = %s WHERE GameID = %s",
(tot, game_id))
card_2 = discord.File(
fp='Cards/{}.jpg'.format(
new_list[i]),
filename='{}.jpg'.format(
new_list[i]),
spoiler=True)
file_2.append(card_2)
DBconn.commit()
c.execute(
"SELECT Player1 FROM currency.Games WHERE GameID = %s",
(game_id, ))
player_1 = fetch_one()
await ctx.send(
"<@{}>'s current score is ||{}||".
format(player_1, tot1),
files=file_1,
delete_after=120)
await ctx.send(
"<@{}>'s current score is ||{}||".
format(player_2, tot),
files=file_2,
delete_after=120)
self.aces = 0
self.game_list = []
self.game_list.append(game_id)
# self._start_tasks()
self._start_tasks(
ctx, game_id, player_1, player_2)
# self.bgloop.start(ctx, game_id, player_1, player_2)
if count > 1:
await ctx.send(
"> **There is an error with the database. Please report to an administrator**",
delete_after=40)
except Exception as e:
log.console(e)
await ctx.send(
"> **Failed to join. This game does not exist.**",
delete_after=40)
elif amount < 0:
await ctx.send("> **You cannot bet a negative number**")
async def hit(self, ctx):
"""Pick A Card [Format: %hit]"""
userid = ctx.author.id
try:
random_card = randint(1, 52)
c.execute(
"SELECT GameID FROM currency.Games WHERE Player1 = %s OR Player2 = %s",
(userid, userid))
game_id = fetch_one()
c.execute(
"SELECT Player1,Player2 FROM currency.Games WHERE Player1 = %s OR Player2 = %s",
(userid, userid))
player = c.fetchone()
c.execute("SELECT CardID FROM currency.BlackJack WHERE GameID =%s",
(game_id, ))
cards = fetch_all()
while random_card in cards:
random_card = randint(1, 52)
Player1 = player[0]
Player2 = player[1]
c.execute("SELECT Stand FROM currency.Games WHERE GameID = %s",
(game_id, ))
current_stand = str(fetch_one())
keep_going = True
if userid == Player1:
xyz = 1
if current_stand[0] == 2:
keep_going = False
if userid == Player2:
xyz = 2
if current_stand[1] == 2:
keep_going = False
if keep_going == True:
c.execute("INSERT INTO currency.BlackJack VALUES (%s, %s, %s)",
(game_id, random_card, xyz))
abc = discord.File(fp='Cards/{}.jpg'.format(random_card),
filename='{}.jpg'.format(random_card),
spoiler=True)
c.execute(
"SELECT value FROM currency.CardValues WHERE CardID = %s",
(random_card, ))
card_value = fetch_one()
c.execute(
"SELECT Score{} FROM currency.Games WHERE GameID = %s".
format(xyz), (game_id, ))
current_val = fetch_one()
tot = current_val + card_value
c.execute(
"SELECT COUNT(*) FROM currency.BlackJack WHERE CardID = %s AND Position = %s AND GameID = %s",
(1, xyz, game_id))
check_for_ace1 = fetch_one()
c.execute(
"SELECT COUNT(*) FROM currency.BlackJack WHERE CardID = %s AND Position = %s AND GameID = %s",
(14, xyz, game_id))
check_for_ace2 = fetch_one()
c.execute(
"SELECT COUNT(*) FROM currency.BlackJack WHERE CardID = %s AND Position = %s AND GameID = %s",
(27, xyz, game_id))
check_for_ace3 = fetch_one()
c.execute(
"SELECT COUNT(*) FROM currency.BlackJack WHERE CardID = %s AND Position = %s AND GameID = %s",
(40, xyz, game_id))
check_for_ace4 = fetch_one()
self.aces = 0
if check_for_ace1 == 1:
self.aces += 1
current = 1
c.execute(
"UPDATE currency.BlackJack SET Position = %s WHERE GameID = %s AND CardID = %s",
(3, game_id, 1))
if check_for_ace2 == 1:
self.aces += 1
current = 1
c.execute(
"UPDATE currency.BlackJack SET Position = %s WHERE GameID = %s AND CardID = %s",
(3, game_id, 14))
if check_for_ace3 == 1:
self.aces += 1
current = 1
c.execute(
"UPDATE currency.BlackJack SET Position = %s WHERE GameID = %s AND CardID = %s",
(3, game_id, 27))
if check_for_ace4 == 1:
self.aces += 1
current = 1
c.execute(
"UPDATE currency.BlackJack SET Position = %s WHERE GameID = %s AND CardID = %s",
(3, game_id, 40))
self.ace_list = []
if self.aces >= 1:
self.ace_list.append(userid)
self.ace_list.append(self.aces)
self.ace2_list.append(self.ace_list)
for ace in self.ace2_list:
user = ace[0]
card_ace = ace[1]
if ctx.author.id == user and tot > 21 and card_ace >= 1:
ace[1] -= 1
if ace[1] == 0:
self.ace2_list.remove(ace)
tot = tot - 10
await ctx.send("<@{}>'s current score is ||{}||".format(
userid, tot),
file=abc,
delete_after=120)
c.execute(
"UPDATE currency.Games SET Score{} = %s WHERE GameID = %s".
format(xyz), (tot, game_id))
DBconn.commit()
except Exception as e:
log.console(e)
await ctx.send("> **You are not currently playing a game.**",
delete_after=40)
pass
async def new_task():
self.count += 1
# log.console (game)
c.execute("SELECT Stand FROM currency.Games WHERE GameID = %s",
(game_id, ))
stand = str(fetch_one())
if stand == '22':
c.execute(
"SELECT Score1 FROM currency.Games WHERE GameID = %s",
(game_id, ))
score_1 = fetch_one()
c.execute(
"SELECT Score2 FROM currency.Games WHERE GameID = %s",
(game_id, ))
score_2 = fetch_one()
c.execute(
"SELECT Bid1 FROM currency.Games WHERE GameID = %s",
(game_id, ))
bid_1 = fetch_one()
c.execute(
"SELECT Bid2 FROM currency.Games WHERE GameID = %s",
(game_id, ))
bid_2 = fetch_one()
bid_sum = bid_1 + bid_2
c.execute("DELETE FROM currency.Games WHERE GameID = %s",
(game_id, ))
c.execute(
"DELETE FROM currency.BlackJack WHERE GameID = %s",
(game_id, ))
if score_1 > 21 and score_2 > 21:
if score_1 == score_2:
await ctx.send(
"> **You have both tied with a score of {}! No prizes were given.**"
.format(score_1),
delete_after=40)
result_1 = score_1 - 21
result_2 = score_2 - 21
if result_1 < result_2:
# player 1 wins
# add money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_val = int(fetch_one())
total_amount = bid_2 + current_val
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(total_amount, player_1))
# subtract money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_val = int(fetch_one())
total_amount = current_val - bid_2
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(total_amount, player_2))
await ctx.send(
"> **<@{}> has won {:,} Dollars with {} points against <@{}> with {} points in BlackJack.**"
.format(player_1, bid_sum, score_1, player_2,
score_2),
delete_after=40)
if result_2 < result_1:
# player 2 wins
# add money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_val = fetch_one()
total_amount = bid_1 + current_val
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(total_amount, player_2))
# subtract money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_val = int(fetch_one())
total_amount = current_val - bid_1
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(total_amount, player_1))
await ctx.send(
"> **<@{}> has won {:,} Dollars with {} points against <@{}> with {} points in BlackJack.**"
.format(player_2, bid_sum, score_2, player_1,
score_1),
delete_after=40)
if score_1 < 21 and score_2 < 21:
if score_1 == score_2:
await ctx.send(
"> **You have both tied with a score of {}! No prizes were given.**"
.format(score_1),
delete_after=40)
if score_1 > score_2:
# player 1 wins
# add money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_val = int(fetch_one())
total_amount = bid_2 + current_val
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(total_amount, player_1))
# subtract money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_val = int(fetch_one())
total_amount = current_val - bid_2
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(total_amount, player_2))
await ctx.send(
"> **<@{}> has won {:,} Dollars with {} points against <@{}> with {} points in BlackJack.**"
.format(player_1, bid_sum, score_1, player_2,
score_2),
delete_after=40)
if score_2 > score_1:
# player 2 wins
# add money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_val = int(fetch_one())
total_amount = bid_1 + current_val
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_2))
# subtract money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_val = int(fetch_one())
total_amount = current_val - bid_1
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_1))
await ctx.send(
"> **<@{}> has won {:,} Dollars with {} points against <@{}> with {} points in BlackJack.**"
.format(player_2, bid_sum, score_2, player_1,
score_1),
delete_after=40)
if score_1 == 21 or score_2 == 21:
if score_1 == score_2:
await ctx.send(
"> **You have both achieved BlackJack as a tie! No prizes were given.**"
.format(score_1),
delete_after=40)
if score_1 != score_2:
if score_1 == 21:
# player1 wins
# add money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_val = int(fetch_one())
total_amount = bid_2 + current_val
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_1))
# subtract money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_val = int(fetch_one())
total_amount = current_val - bid_2
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_2))
await ctx.send(
"> **<@{}> has won {:,} Dollars with {} points against <@{}> with {} points in BlackJack.**"
.format(player_1, bid_sum, score_1,
player_2, score_2),
delete_after=40)
if score_2 == 21:
# player2 wins
# add money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_val = int(fetch_one())
total_amount = bid_1 + current_val
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_2))
# subtract money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_val = int(fetch_one())
total_amount = current_val - bid_1
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_1))
await ctx.send(
"> **<@{}> has won {:,} Dollars with {} points against <@{}> with {} points in BlackJack.**"
.format(player_2, bid_sum, score_2,
player_1, score_1),
delete_after=40)
if score_1 < 21 and score_2 > 21:
# player1 wins
# add money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_val = int(fetch_one())
total_amount = bid_2 + current_val
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_1))
# subtract money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_val = int(fetch_one())
total_amount = current_val - bid_2
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_2))
await ctx.send(
"> **<@{}> has won {:,} Dollars with {} points against <@{}> with {} points in BlackJack.**"
.format(player_1, bid_sum, score_1, player_2,
score_2),
delete_after=40)
if score_1 > 21 and score_2 < 21:
# player2 wins
# add money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_2, ))
current_val = int(fetch_one())
total_amount = bid_1 + current_val
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_2))
# subtract money
c.execute(
"SELECT Money FROM currency.Currency WHERE UserID = %s",
(player_1, ))
current_val = int(fetch_one())
total_amount = current_val - bid_1
c.execute(
"UPDATE currency.Currency SET Money = %s WHERE UserID = %s",
(f'{total_amount}', player_1))
await ctx.send(
"> **<@{}> has won {:,} Dollars with {} points against <@{}> with {} points in BlackJack.**"
.format(player_2, bid_sum, score_2, player_1,
score_1),
delete_after=40)
DBconn.commit()
self.tasks.remove(self.task_list)
self.count = 0
new_task.stop()
if self.count == 60:
await ctx.send(
"> **Game {} has been deleted due to it's 5 minute limit.**"
.format(game_id))
# await ctx.send("sending {}".format(self.task_list))
c.execute("DELETE FROM currency.Games WHERE GameID = %s",
(game_id, ))
c.execute(
"DELETE FROM currency.BlackJack WHERE GameID = %s",
(game_id, ))
DBconn.commit()
self.tasks.remove(self.task_list)
self.count = 0
new_task.stop()
async def addchannel(self,
ctx,
drive_folder_id,
name="NULL",
owner_present=0):
"""REQUIRES BOT OWNER PRESENCE -- Make the current channel start archiving images to google drive [Format: %addchannel <drive folder id> <optional - name>]"""
try:
if owner_present == 0:
await ctx.send(
f"> **In order to start archiving your channels, you must talk to the bot owner <@{self.bot_owner_id}>**"
)
if owner_present == 1:
await ctx.send("> **Awaiting confirmation**")
if await self.on_message(ctx, 1):
c.execute(
"SELECT COUNT(*) FROM archive.ChannelList WHERE DriveID = %s",
(drive_folder_id, ))
checker = fetch_one()
if checker == 0:
c.execute(
"SELECT COUNT(*) FROM archive.ChannelList WHERE ChannelID = %s",
(ctx.channel.id, ))
count = fetch_one()
if count == 0:
url = f"https://drive.google.com/drive/folders/{drive_folder_id}"
async with aiohttp.ClientSession() as session:
async with session.get(url) as r:
if r.status == 200:
c.execute(
"INSERT INTO archive.ChannelList VALUES(%s,%s,%s,%s)",
(ctx.channel.id, ctx.guild.id,
drive_folder_id, name))
DBconn.commit()
await ctx.send(
f"> **This channel is now being archived under {url}**"
)
pass
elif r.status == 404:
await ctx.send(
f"> **{url} does not exist.**")
elif r.status == 403:
await ctx.send(
f"> **I do not have access to {url}.**"
)
else:
await ctx.send(
f"> **Something went wrong with {url}"
)
else:
await ctx.send(
"> **This channel is already being archived**")
else:
url = f"https://drive.google.com/drive/folders/{drive_folder_id}"
await ctx.send(f"> **{url} is already being used.**")
else:
await ctx.send(
"> **The bot owner did not confirm in time.**")
except Exception as e:
log.console(e)
await ctx.send("> **There was an error.**")
pass
