local function isValidMoney(value)
    if(value == nil) then
        return false
    end

    return (value > 0 and value <= 99999999999999)
end

function onSay(cid, words, param, channel)
    local guild = getPlayerGuildId(cid)
    if(guild == 0) then
        return false
    end

    local t = string.explode(param, ' ', 1)
    if(getPlayerGuildLevel(cid) == GUILDLEVEL_LEADER and isInArray({ 'pick' }, t[1])) then
        if(t[1] == 'pick') then
            local money = { tonumber(t[2]) }
            if(not isValidMoney(money[1])) then
                doPlayerSendChannelMessage(cid, '', 'Invalid amount of money specified.', TALKTYPE_CHANNEL_W, 0)
                return true
            end

            local result = db.getResult('SELECT `balance` FROM `guilds` WHERE `id` = ' .. guild)
            if(result:getID() == -1) then
                return false
            end

            money[2] = result:getDataLong('balance')
            result:free()

            if(money[1] > money[2]) then
                doPlayerSendChannelMessage(cid, '', 'The balance is too low for such amount.', TALKTYPE_CHANNEL_W, 0)
                return true
            end

            if(not db.executeQuery('UPDATE `guilds` SET `balance` = `balance` - ' .. money[1] .. ' WHERE `id` = ' .. guild .. ' LIMIT 1;')) then
                return false
            end

            doPlayerAddMoney(cid, money[1])
            doPlayerSendChannelMessage(cid, '', 'You have just picked ' .. money[1] .. ' money from your guild balance.', TALKTYPE_CHANNEL_W, 0)
        else
            doPlayerSendChannelMessage(cid, '', 'Invalid sub-command.', TALKTYPE_CHANNEL_W, 0)
        end
    elseif(t[1] == 'donate') then
        local money = tonumber(t[2])
        if(not isValidMoney(money)) then
            doPlayerSendChannelMessage(cid, '', 'Invalid amount of money specified.', TALKTYPE_CHANNEL_W, 0)
            return true
        end

        if(getPlayerMoney(cid) < money) then
            doPlayerSendChannelMessage(cid, '', 'You don\'t have enough money.', TALKTYPE_CHANNEL_W, 0)
            return true
        end

        if(not doPlayerRemoveMoney(cid, money)) then
            return false
        end

        db.executeQuery('UPDATE `guilds` SET `balance` = `balance` + ' .. money .. ' WHERE `id` = ' .. guild .. ' LIMIT 1;')
        doPlayerSendChannelMessage(cid, '', 'You have transfered ' .. money .. ' money to your guild balance.', TALKTYPE_CHANNEL_W, 0)
    else
        local result = db.getResult('SELECT `name`, `balance` FROM `guilds` WHERE `id` = ' .. guild)
        if(result:getID() == -1) then
            return false
        end

        doPlayerSendChannelMessage(cid, '', 'Current balance of guild ' .. result:getDataString('name') .. ' is: ' .. result:getDataLong('balance') .. ' bronze coins.', TALKTYPE_CHANNEL_W, 0)
        result:free()
    end

    return true
end