Get name_clan and show crest + name via DB?

fa1thDEV

Baron
Customer
Hello, I want receive clan_name and clan_crest, how I obtain it?, I know I can get the name via characters -> clanid and in clan_data table I can get the name, crest and ally crest, but not work for me D':

My logic:

in characters we can get the clanid but not the name and its crest, in characters (the table) is the character name obj_id, pvpkills, pkkills, online and clanid.

But going to the table “clan_data” we will have the following: clan_id, crest and largecrest.

But to know the name, the name is found in the table “clan_subpledges” which contains ‘clan_id’ and “name”.
 
Last edited:
you already figured it out, use the clan_id to find it :) send exactly the same message into an AI of sort and ask for a SQL query, it will return what you need
 
Back
Top