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
