[13:15:37.241] [Error - TalkAction Interface]

[13:15:37.242] data/talkactions/scripts/ban.lua:onSay

[13:15:37.242] Description:

[13:15:37.243] data/talkactions/scripts/ban.lua:17: attempt to call global 'doAd

dBanishment' (a nil value)

[13:15:37.244] stack traceback:

[13:15:37.244]  data/talkactions/scripts/ban.lua:17: in function <data/talkactio

ns/scripts/ban.lua:4>

[13:15:37.245] sqlite3_prepare_v2(): SQLITE ERROR: no such table: player_stateme

nts (INSERT INTO "player_statements" ("player_id", "channel_id", "text", "date")

 VALUES (6, 0, '/ban Testa, 12, aa', 1440173737))

 

 

Como resolver estes dois erros?

Oi de novo! kk   Não sei se vai resolver, mas tente executando em Sqlitestudio > Open SQL query editor:

DROP TABLE IF EXISTS player_statements;
CREATE TABLE player_statements (
id INTEGER PRIMARY KEY,
player_id INTEGER NOT NULL,
channel_id INTEGER NOT NULL
DEFAULT '0',
text VARCHAR( 255 ) NOT NULL,
date INTEGER NOT NULL
DEFAULT '0',
FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

Resolveu, mas agora só falta o do ban, se puder me ajudar.

 

Obrigadão

data/talkactions/scripts/ban.lua

local comment = ""
local length = 1 -- ban time in hours

function onSay(cid, words, param)
    local param = string.explode(param, ",")
    if param[1] then
        local accId = getAccountIdByName(param[1])
        if accId > 0 then
            if param[2] and tonumber(param[2]) and tonumber(param[2]) > 0 then
                length = tonumber(param[2])
            end
            if param[3] then
                comment = param[3]
            end
            doAddAccountBanishment(accId, getPlayerGUIDByName(param[1]), length * 3600, 23, ACTION_BANISHMENT, comment, getPlayerGUID(cid))
            local player = getPlayerByNameWildcard(param[1])
            if isPlayer(player) then
                doRemoveCreature(player)
            end
        else
            doPlayerSendCancel(cid, "Player with name " .. param[1] .. " doesn't exist.")
        end
    else
        doPlayerSendCancel(cid, "You must enter a player name.")
    end
    return true
end

Se não funcionar, posta seu arquivo, por favor...

Editado Agosto 21, 2015 10 anos por Larissa Azhaurn (veja o histórico de edições)

Esse não deu erro o player desloga e consegue relogar, eu estou testando esse > http://www.tibiaking.com/forum/topic/18565-radbr-banishment-system/ 

Mas ele também não dá erro e o personagem apenas desloga.