Olá galera, estou fazendo o top1 players e como faz para opegar o logo da guild do top 1?
minha função esta assim, funciona perdfeitamente mas falta pegar o logo da guild
Código:
defget_top_ranking(): queries = {
"Top Reset": "SELECT TOP 1 Name, ResetCount, cLevel, Class FROM Character ORDER BY ResetCount DESC",
"Top Master Reset": "SELECT TOP 1 Name, GrandResetCount, cLevel, Class FROM Character ORDER BY GrandResetCount DESC",
"Top PK": "SELECT TOP 1 Name, pkcount, cLevel, Class FROM Character ORDER BY pkcount DESC", # Maior pkcount = mais PK
"Top Herói": "SELECT TOP 1 Name, pkcount, cLevel, Class FROM Character ORDER BY pkcount ASC", # Menor pkcount = mais herói
"Top Guild": "SELECT TOP 1 G_Name, G_Score FROM Guild ORDER BY G_Score DESC",
}
results = {}
with connection.cursor() as cursor:
for category, query in queries.items():
cursor.execute(query)
row = cursor.fetchone()
if row:
columns = [col[0] for col in cursor.description]
results[category] = dict(zip(columns, row))
else:
results[category] = None # Caso não haja dados na tabela
returnresults