Alliance leader in Database

[reblock]

Hello. Can you help me. I can't find where alliance leader is stored in database. I found only clan_data table, but there is no such field.
Second question. Why ally_name and ally_crest_id are stored in clan_data (dublicated records)? Maybe we need to make normalization (or I didn't understand something)?

[AdvancedSky]

Hello. Can you help me. I can't find where alliance leader is stored in database. I found only clan_data table, but there is no such field.
Second question. Why ally_name and ally_crest_id are stored in clan_data (dublicated records)? Maybe we need to make normalization (or I didn't understand something)?

1. I think if you take clan_id (clan nr. 1) and put it to ally_id (to clan nr. 2) , then clan nr.1 and clan nr.2 will have alliance. And the clan_id that is same as the ally_id is the ally leader clan -> this clans leader is ally leader auto.
2. See nr 1, that's why.

[reblock]

Thanks. You are right.
P. S. I am writing now PTS (Hellbound) -> L2J database transfer script.