function getGuildMembers(GuildId)
local players,query = {},db.getResult("SELECT `name` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = " .. GuildId .. ");")
if (query:getID() ~= -1) then
repeat
table.insert(players,query:getDataString("name"))
until not query:next()
query:free()
end
return #players > 0 and players or false
end
function onSay(cid, words, param, channel)
local time, storage = 10,786974
local min_player = 20
local level_min = 250
if getPlayerGuildId(cid) <= 0 or getPlayerGuildLevel(cid) < GUILDLEVEL_LEADER then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "você precisa ser lider de uma guild") return true
elseif #getGuildMembers(getPlayerGuildId(cid)) < min_player then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Sua guild precisa ter no min "..min_player.." players") return true
elseif getPlayerLevel(cid) < level_min then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Voce precisa ser level "..min_player.."ou mais para mandars mensagens") return true
elseif getPlayerStorageValue(cid, storage) - os.time() > 0 then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You need to wait " .. os.time() - getPlayerStorageValue(cid, storage) .. " seconds.") return true
end
for _, pid in ipairs(getPlayersOnline()) do
if(getPlayerGuildLevel(pid) == GUILDLEVEL_LEADER) then
doPlayerSendTextMessage(pid, MESSAGE_EVENT_ADVANCE, getCreatureName(cid) .. ": " .. param)
end
end
doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "Mensagem enviada com sucesso")
setPlayerStorageValue(cid, storage, os.time()+time*60)
return true
end