def get_guild_members_count(guild_id): cursor = pydb.get_cursor() sql = "SELECT COUNT(`char_id`) FROM `char` WHERE `guild_id`='%s' " cur = cursor.execute(sql % (guild_id)) if cur: count = cursor.fetchone() return count[0]
def get_guild_name(guild_id): cursor = pydb.get_cursor() sql = "SELECT `name` FROM `guild` WHERE `guild_id` = '%s' " cur = cursor.execute(sql % (guild_id)) if cur == 1: guildd = cursor.fetchone() guild = guildd[0] else: guild = "None" return guild
def get_party_name(party_id): cursor = pydb.get_cursor() sql = "SELECT `name` FROM `party` WHERE `party_id` = '%s' " cur = cursor.execute(sql % (party_id)) if cur == 1: party = cursor.fetchone() name = party[0] else: name = "None" return name
def get_guild_members(guild_id): cursor = pydb.get_cursor() ''' chars[0] - Char ID chars[1] - Char Name chars[2] - Class # chars[3] - Base Level chars[4] - Job Level chars[5] - Online state ''' sql = "SELECT `char_id`, `name`, `class`, `base_level`, `job_level`, `online` FROM `char` WHERE `guild_id`='%s' " cur = cursor.execute(sql % (guild_id)) if cur: chars = cursor.fetchall() return chars
def get_guild_info(guild_id): cursor = pydb.get_cursor() ''' guild[0] - Guild ID guild[1] - Guild Name guild[2] - Guildmaster ID guild[3] - Guildmaster Name guild[4] - Guild LVL guild[5] - Guildmembers's average level guild[6] - Guild Exp guild[7] - Emblem Length ''' sql = "SELECT `guild_id`, `name`, `char_id`, `master`, `guild_lv`, `average_lv`, `exp`, `emblem_len` FROM `guild` WHERE `guild_id`=%s" cur = cursor.execute(sql % (guild_id)) guild = cursor.fetchone() return guild
def get_guilds_ranks(): cursor = pydb.get_cursor() ''' guilds[0] - Guild ID guilds[1] - Guild Name guilds[2] - Guildmaster ID guilds[3] - Guildmaster Name guilds[4] - Guild LVL guilds[5] - Guildmembers's average level guilds[6] - Guild Exp guilds[7] - Guild Exp ''' sql = "SELECT `guild_id`, `name`, `char_id`, `master`, `guild_lv`, `average_lv`, `exp`, `emblem_len` FROM `guild` ORDER BY `guild_lv` DESC LIMIT 0, 20 " cur = cursor.execute(sql) guilds = cursor.fetchall() return guilds
def check_guild_icon(guild_id): cursor = pydb.get_cursor() ''' guild[0] - Guild ID guild[1] - Guild Name guild[2] - Guildmaster ID guild[3] - Guildmaster Name guild[4] - Guild LVL guild[5] - Guildmembers's average level guild[6] - Guild Exp ''' sql = "SELECT `emblem_len` FROM `guild` WHERE `guild_id`=%s " cur = cursor.execute(sql % (guild_id)) guild = cursor.fetchone() if guild[0] > 0: return True else: return False
def get_chars_ranks(start=0,count=20, order='`base_level`'): cursor = pydb.get_cursor() ''' chars[0] - Char ID chars[1] - Char Name chars[2] - Class # chars[3] - Guild ID chars[4] - Base Level chars[5] - Job Level chars[6] - Online state chars[7] - Zeny amount chars[8] - Kills in PvP chars[9] - Deaths in PvP chars[10] - Kills on WoE chars[11] - Deaths on WoE ''' sql = "SELECT `char_id`, `name`, `class`, `guild_id`, `base_level`, `job_level`, `online`, `zeny`, `pvp_kills`, `pvp_death`, `woe_kills`, `woe_death` FROM `char` ORDER BY %s DESC LIMIT %s, %s " cur = cursor.execute(sql % (order, start, count)) chars = cursor.fetchall() return chars
def get_char_info(char_id): cursor = pydb.get_cursor() ''' chars[0] - Char ID chars[1] - Char Name chars[2] - Class # chars[3] - Guild ID chars[4] - Base Level chars[5] - Job Level chars[6] - Base Exp chars[7] - Job Exp chars[8] - Party ID chars[9] - Kills in PvP chars[10] - Deaths in PvP chars[11] - Kills on WoE chars[12] - Deaths on WoE chars[13] - Online state ''' sql = "SELECT `char_id`, `name`, `class`, `guild_id`, `base_level`, `job_level`, `base_exp`, `job_exp`, `party_id`, `pvp_kills`, `pvp_death`, `woe_kills`, `woe_death`, `online` FROM `char` WHERE `char_id`= '%s'" cur = cursor.execute(sql % (char_id)) chars = cursor.fetchone() return chars