def archiveChannel(guildID: int, channel: int):
try: dbTables.archive()
except: pass
query = f"""INSERT INTO `archive` (
guild_id, channel
) VALUES (%s, %s) ON DUPLICATE KEY UPDATE channel = VALUES(channel)"""
values = (guildID, channel)
dbConnect.commit(query, values)
def archivePins(guildID: int, pins: bool):
try: dbTables.archive()
except: pass
query = f"""INSERT INTO `archive` (
guild_id, pins
) VALUES (%s, %s) ON DUPLICATE KEY UPDATE pins = VALUES(pins)"""
values = (guildID, pins)
dbConnect.commit(query, values)
def commandCount(guildID: int, name: str):
try:
query = f"""UPDATE `commands`
SET times_used = IFNULL(times_used, 0) + 1
WHERE guild_id = %s AND command_name = %s AND is_enabled = 1"""
values = (guildID, name)
dbConnect.commit(query, values)
except:
pass # command does not exist
def archive(guildID: int, channel: int, role: int, pins: bool, toggle: bool):
try: dbTables.archive()
except: pass
query = f"""INSERT INTO `archive` (
guild_id, channel, role, pins, toggle
) VALUES (%s, %s, %s, %s, %s) ON DUPLICATE KEY UPDATE channel = VALUES(channel), role = VALUES(role), pins = VALUES(pins), toggle = VALUES(toggle)"""
values = (guildID, channel, role, pins, toggle)
dbConnect.commit(query, values)
def config(guildID: int, name: str, value: str):
try: dbTables.config()
except: pass
query = f"""INSERT INTO `config` (
guild_id, option_name, value
) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE value = VALUES(value)"""
values = (guildID, name, value)
dbConnect.commit(query, values)
def prefix(guildID: int, pref: str):
try: dbTables.prefix()
except: pass
query = f"""INSERT INTO `prefix` (
guild_id, prefix
) VALUES (%s, %s) ON DUPLICATE KEY UPDATE prefix = VALUES(prefix)"""
values = (guildID, pref)
dbConnect.commit(query, values)
def cogs(name: str, enabled: bool, loaded: bool):
try: dbTables.cogs()
except: pass
query = f"""INSERT INTO `cogs` (
cog_name, is_enabled, is_loaded
) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE is_enabled = VALUES(is_enabled), is_loaded = VALUES(is_loaded)"""
values = (name, enabled, loaded)
dbConnect.commit(query, values)
def commands(guildID: int, name: str, enabled: bool):
try: dbTables.commands()
except: pass
query = f"""INSERT INTO `commands` (
guild_id, command_name, is_enabled
) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE is_enabled = VALUES(is_enabled)"""
values = (guildID, name, enabled)
dbConnect.commit(query, values)
def archiveRole(guildID: int, role: int):
try: dbTables.archive()
except: pass
query = f"""INSERT INTO `archive` (
guild_id, role
) VALUES (%s, %s) ON DUPLICATE KEY UPDATE role = VALUES(role)"""
values = (guildID, role)
dbConnect.commit(query, values)
def ignore(guildID: int, guild_name: str, member: str, ignored: bool):
try: dbTables.ignore()
except: pass
query = f"""INSERT INTO `ignore` (
guild_id, guild_name, member_id, is_ignored
) VALUES (%s, %s, %s, %s)
ON DUPLICATE KEY UPDATE
is_ignored = VALUES(is_ignored),
guild_name = VALUES(guild_name)"""
values = (guildID, guild_name, member, ignored)
dbConnect.commit(query, values)
def archive(guildID: int):
try: dbTables.archive()
except: pass
query = f"""SELECT * FROM `archive` WHERE guild_id = {guildID}"""
values = ()
data = dbConnect.commit(query, values, True)
return data[0]
def leaderboard(guildID: int, memberID: int):
try: dbTables.leaderboard()
except: pass
query = f"""SELECT * FROM `leaderboard` WHERE guild_id = %s AND member_id = %s"""
values = (guildID, memberID)
data = dbConnect.commit(query, values, True)
return data[0]
def leaderboard(guild_id: int, guild_name: str, member_id: int, member_name: str, level: int, points: int, next_level: int, last_added, message_count: int):
try: dbTables.archive()
except: pass
query = f"""INSERT INTO `leaderboard` (
guild_id, guild_name, member_id, member_name, level, points, next_level, last_added, message_count
) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)
ON DUPLICATE KEY UPDATE
guild_name = VALUES(guild_name),
member_name = VALUES(member_name),
level = VALUES(level),
points = VALUES(points),
next_level = VALUES(next_level),
last_added = VALUES(last_added),
message_count = VALUES(message_count)"""
values = (guild_id, guild_name, member_id, member_name, level, points, next_level, last_added, message_count)
dbConnect.commit(query, values)
def command(guildID: int, cmd: str):
query = f"""SELECT is_enabled FROM `commands` WHERE guild_id = %s AND command_name = %s"""
values = (guildID, cmd)
data = dbConnect.commit(query, values, True)
if len(data) == 0:
return False
else:
for i in data:
return bool(i[0])
def ignore(guildID: int, memberID: int):
query = f"""SELECT is_ignored FROM `ignore` WHERE guild_id = %s AND member_id = %s"""
values = (guildID, memberID)
data = dbConnect.commit(query, values, True)
if len(data) == 0:
return False
else:
for i in data:
return bool(i[0])
def prefix(guildID: int):
try:
query = f"""SELECT prefix FROM `prefix` WHERE guild_id = {guildID}"""
values = ()
data = dbConnect.commit(query, values, True)
for i in data:
return i[0]
except:
pass
try:
conf = config.read('mainConfig.ini')
return conf['main']['prefix']
except:
pass
def commandCount(guildID: int, cmd: str):
query = f"""SELECT times_used FROM `commands` WHERE guild_id = %s AND command_name = %s"""
values = (guildID, cmd)
data = dbConnect.commit(query, values, True)
for i in data:
return i[0]
def config(guildID: int, name: str):
query = f"""SELECT value FROM `config` WHERE option_name = %s AND guild_id = %s"""
values = (name, guildID)
data = dbConnect.commit(query, values, True)
for i in data:
return i[0]
def cogLoaded(name: str):
query = f"""SELECT is_loaded FROM `cogs` WHERE cog_name = '{name}'"""
values = ()
data = dbConnect.commit(query, values, True)
for i in data:
return bool(i[0])
