Lua TFS 0.x - Get guild ID from offline Player

[Critico]

Tibia 8.60

Version: 0.3.6 ~ 0.4x

can someone tell me if there is a function that return GUILD ID an offline players?

exemple: "getPlayerGuildId" but offline.

 

[Critico]

I need guild ID from player offline '-'

but, thanks man!!

SQL... do you have any idea how to do this query?

function onSay(cid, words, param)
    local t = param:lower()
    if (param == "") then
        doPlayerSendCancel(cid, "invalid") return true
    end
    local id = getPlayerGUIDByName(t)
    if not id then
        doPlayerSendCancel(cid, "Sorry, player [" .. t .. "] does exist.") return true
    end
    local offline = getPlayerGuildId(id) -- player offline
    ...
    return true
end

 

[Critico]

#BUMP

 

[Snavy]

Avoid bumping.

Try this, haven't tested.

function getOfflinePlayerGuildId(name)
    local result = db.getResult("SELECT `guild_ranks`.`guild_id` AS `guildid` FROM `guild_ranks`, `guilds` WHERE `guild_ranks`.`id` = (SELECT `players`.`rank_id` FROM `players` WHERE `name` LIKE '".. name .."') AND `guild_ranks`.`guild_id` = `guilds`.`id` LIMIT 1")
    if result then
        return result:getDataInt("guildid")
    end
    return 0
end

 

[Critico]

worked!!! Thanks alot man <3