Function to check account number

[president vankk]

Which function to use in TFS 1.0 to check the player online account number, I tryed getAccountNumberByPlayerName(getCreatureName(cid)) and get the ID in accounts table.

Ex:

function onSay(cid, words, param)
   print("" .. getAccountNumberByPlayerName(getCreatureName(cid)) .. "")
end

Thanks.

 

[StreamSide]

function onSay(player, words, param)
    player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, "ACCid: "..player:getAccountId())
    return false
end

 

[president vankk]

I don't want the ID, just the account number from the player.

 

[StreamSide]

I don't want the ID, just the account number from the player.

acc number = acc id
player->accountNumber = result->getNumber<uint32_t>("account_id");

 

[president vankk]

But for what I need, the script will check the mysql and need the account number, because the table is selected by account number, and not by ID.

 

[RazorBlade]

function onSay(player, words, param)
    local id = player:getAccountId()
    local resultId = db.storeQuery("SELECT * FROM `accounts` WHERE `id` = " .. id)
    if resultId ~= false then
        local name = result.getDataString(resultId, "name")
        result.free(resultId)
        player:sendTextMessage(MESSAGE_INFO_DESCR, "Your account name is " .. name .. ".")
    end
    return false
end

Somethin' like this?