2 functions

[Scooty]

Hi, i need 2 simple functions but i cant do it myself ;/

1. CountOnlineGuildMembers(cid) - checking number of online players from cids guild
2. CountGuildMembers(cid) - checking number of players from cids guilds(online and offline)

Can somebody do it?

Thanks

 

[Critico]

function CountGuildMembers(cid) -- vodkart
local count = 0 
local lista = db.getResult("SELECT `name`, `rank_id` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = " .. getGuildId(getPlayerGuildName(cid)) .. ");")  
if(lista:getID() ~= -1) then  
repeat  count = count + 1 until not lista:next()  lista:free() return count end
end

function CountOnlineGuildMembers(cid) -- vodkart
        count = 0
        for _, cid in pairs(getPlayersOnline()) do
                if getPlayerGuildName(cid) == getPlayerGuildName(cid) then
                        count = count + 1
                end
        end
        return count
end

exemple talk:

if getPlayerGuildId(cid) <= 0  then
return doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You must be in the Guild!")
else
return doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "you guild have "..CountOnlineGuildMembers(cid).." player online / members total of guild : "..CountGuildMembers(cid))
end

 

[Scooty]

all working fine

ty Critico, rep++