problem countRankInClan

[//_Dragon]

Hey there i want to count how many leaders are in clan but it counts only numbers of members 

	    local leaders = countPlayersInClan(clan)

anybody can help me to make it works ? countLeaders in clan

[Dimos7]

Well if you have rank like members and leader are store some where then use it to find how many are the leaders

[//_Dragon]

i add it only in sql clan_leaders but it doesnt has any relation with it i should find his local

function countPlayersInClan(clan)
	local q = executeSQLQuery("SELECT * FROM clan_members WHERE clan=?",clan)
	local q = executeSQLQuery("SELECT * FROM clan_leaders WHERE clan=?",clan)
	return #q
end

function callMeMaybe()
	local tbl = {}
	local q = executeSQLQuery("SELECT * FROM clans")
	for i,v in ipairs(q) do
		local query = executeSQLQuery("SELECT username FROM accountUsername WHERE account=?",v.owner)
		local clan = v.name
		local tag = v.tag
		local r = v.r
		local g = v.g
		local b = v.b
		local members = countPlayersInClan(clan)
	    local leaders = countPlayersInClan(clan)
		table.insert(tbl,#tbl+1,{owner=query[1].username:gsub("%[.*%]", ""),name=clan,tag=tag,r=r,g=g,b=b,members=members,leaders=leaders})

 

Edited August 16, 2019 by //_Dragon

[HassoN]

local members = countPlayersInClan(clan)
local leaders = countPlayersInClan(clan)

How are you using the same code twice for two different purposes?

Does your database have any information about member's ranks?

 

local q = executeSQLQuery("SELECT * FROM clan_leaders WHERE clan=?",clan)

this should work ONLY IF you had a table called "clan_leaders" that actually has a list of all the leaders of a certain clan.

[//_Dragon]

my database  has clan_leaders the only issue is countPlayerInClan i need  to replace it to get fixed

[HassoN]

Then use 2 different functions

function countPlayersInClan(clan)
	local q = executeSQLQuery("SELECT * FROM clan_members WHERE clan=?",clan)
	return #q
end

function countLeadersInClan(clan)
	local q = executeSQLQuery("SELECT * FROM clan_leaders WHERE clan=?",clan)
	return #q
end

function callMeMaybe()
	local tbl = {}
	local q = executeSQLQuery("SELECT * FROM clans")
	for i,v in ipairs(q) do
		local query = executeSQLQuery("SELECT username FROM accountUsername WHERE account=?",v.owner)
		local clan = v.name
		local tag = v.tag
		local r = v.r
		local g = v.g
		local b = v.b
		local members = countPlayersInClan(clan)
	    local leaders = countLeadersInClan(clan)
		table.insert(tbl,#tbl+1,{owner=query[1].username:gsub("%[.*%]", ""),name=clan,tag=tag,r=r,g=g,b=b,members=members,leaders=leaders})