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])