Critico
Sexy
- Joined
- Mar 25, 2010
- Messages
- 370
- Reaction score
- 176
050-function
Version with one query to mysql By PhoOwned ~
/yourcomand PLAYERNAME
or example actions:
members/vicelider add item for only guild leader
Lua:
function getGuildLeaderName(GuildName) -- function by vodkart
local leader = db.getResult("SELECT `players`.`name` FROM `players` WHERE `players`.`id` = (SELECT `guilds`.`ownerid` FROM `guilds` WHERE `guilds`.`name` = ".. db.escapeString(GuildName) .. ")")
if(leader:getID() ~= -1) then
return leader:getDataString("name")
end
return nil
end
Version with one query to mysql By PhoOwned ~
Lua:
function getGuildLeaderGUID(GuildName)
local leader = db.getResult("SELECT `players`.`id` FROM `players` WHERE `players`.`id` = (SELECT `guilds`.`ownerid` FROM `guilds` WHERE `guilds`.`name` = ".. db.escapeString(GuildName) .. ")")
if(leader:getID() ~= -1) then
return leader:getDataString("id")
end
return nil
end
[/LUa]
[B]example talk[/B]:
[code=lua]
function onSay(cid, words, param)
local player = getPlayerByName(param)
if param == '' then
return doPlayerSendCancel(cid, "param not valid.")
elseif (not player or isPlayerGhost(player)) then
return doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Player with this name doesn\'t exist or is offline.")
elseif getPlayerGuildId(player) <= 0 then
return doPlayerSendCancel(cid, "player are not a guild member.")
end
local leader = getGuildLeaderName(getPlayerGuildName(player))
return doPlayerSendTextMessage(cid,MESSAGE_STATUS_CONSOLE_BLUE,'Leader Name is '..leader..'')
end
/yourcomand PLAYERNAME
or example actions:
members/vicelider add item for only guild leader
Lua:
function onUse(cid, item, frompos, item2, topos)
local leader,pid = getGuildLeaderName(getPlayerGuildName(cid)),getPlayerByName(leader)
local item = 2400
if getPlayerGuildId(cid) <= 0 then
return doPlayerSendCancel(cid, "You are not a guild member.")
elseif (not pid or isPlayerGhost(pid)) then
return doPlayerSendCancel(cid, "Sorry, The Leader [".. leader .."] is offline and will not receive the item!")
end
doPlayerAddItem(pid,item,1)
return TRUE
end
Last edited: