Normal Erro na dristo

[kiinho 11]

Alguém ajuda a resolver esse erro:

Spoiler

[14:49:47.729] [Error - GlobalEvent Interface]
[14:49:47.730] data/globalevents/scripts/raid.lua:onThink
[14:49:47.731] Description:
[14:49:47.732] data/globalevents/scripts/raid.lua:27: attempt to compare string with number
[14:49:47.732] stack traceback:
[14:49:47.733]  data/globalevents/scripts/raid.lua:27: in function <data/globalevents/scripts/raid.lua:26>
[14:49:47.734] [Error - GlobalEvents::think] Couldn't execute event: raid

E esse:

Spoiler

[14:54:35.550] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)

Aqui o raid.lua :

Spoiler

local storage = 1344
local raids = {
    "Morgaroth",
    "Ghazbaran",
    "Undead Jester",
    "goblin",
    "Dryads",
    "Halloweenhare",
    "Hornedfox",
    "Necropharus",
    "Wolfsraid",
    "UndeadArmy",
    "UndeadDarashia",
    "The Old Widow",
    "Scarabs",
    "Rats",
    "Quara",
    "Pirates",
    "Orshabaal",
    "OrcsThais",
    "Ferumbras",
    "Elfs",
    "Demodras",
    "Barbarian"
}
function onThink(interval, lastExecution, thinkInterval)
    if getGlobalStorageValue(storage) == -1 or getGlobalStorageValue(storage) < os.time() then
        executeRaid(raids[math.random(1, #raids)])
        setGlobalStorageValue(storage, os.time() + 9 * 60 * 60)
    end
    return TRUE
end

 

Editado Fevereiro 27, 2017 por kiinho (veja o histórico de edições)

[Sekk 396]

Spoiler

local storage = 1344
local raids = {
    "Morgaroth",
    "Ghazbaran",
    "Undead Jester",
    "goblin",
    "Dryads",
    "Halloweenhare",
    "Hornedfox",
    "Necropharus",
    "Wolfsraid",
    "UndeadArmy",
    "UndeadDarashia",
    "The Old Widow",
    "Scarabs",
    "Rats",
    "Quara",
    "Pirates",
    "Orshabaal",
    "OrcsThais",
    "Ferumbras",
    "Elfs",
    "Demodras",
    "Barbarian"
}
function onThink(interval, lastExecution, thinkInterval)
    if getGlobalStorageValue(storage) == -1 or getGlobalStorageValue(storage) < os.time() then
        executeRaid(math.random(1, #raids))
        setGlobalStorageValue(storage, os.time() + 9 * 60 * 60)
    end
    return TRUE
end

 

 

 

CREATE TABLE z_ots_comunication ( 
    id        INTEGER( 11 )   PRIMARY KEY
                              NOT NULL,
    name      VARCHAR( 255 )  NOT NULL,
    type      VARCHAR( 255 )  NOT NULL,
    [action]  VARCHAR( 255 )  NOT NULL,
    param1    VARCHAR( 255 )  NOT NULL,
    param2    VARCHAR( 255 )  NOT NULL,
    param3    VARCHAR( 255 )  NOT NULL,
    param4    VARCHAR( 255 )  NOT NULL,
    param5    VARCHAR( 255 )  NOT NULL,
    param6    VARCHAR( 255 )  NOT NULL,
    param7    VARCHAR( 255 )  NOT NULL,
    delete_it INTEGER( 2 )    NOT NULL
                              DEFAULT ( 1 ) 
);

 

[kiinho 11]

@Sekk

 

aonde coloco isso?

Spoiler

CREATE TABLE z_ots_comunication ( id INTEGER( 11 ) PRIMARY KEY NOT NULL, name VARCHAR( 255 ) NOT NULL, type VARCHAR( 255 ) NOT NULL, [action] VARCHAR( 255 ) NOT NULL, param1 VARCHAR( 255 ) NOT NULL, param2 VARCHAR( 255 ) NOT NULL, param3 VARCHAR( 255 ) NOT NULL, param4 VARCHAR( 255 ) NOT NULL, param5 VARCHAR( 255 ) NOT NULL, param6 VARCHAR( 255 ) NOT NULL, param7 VARCHAR( 255 ) NOT NULL, delete_it INTEGER( 2 ) NOT NULL DEFAULT ( 1 ) );

 

[Sekk 396]

executa na sua database

[kiinho 11]

1 minuto atrás, Sekk disse:

executa na sua database

Como? não sei mexer :x

[Sekk 396]

vc usa mysql ou sqlite?

[kiinho 11]

19 minutos atrás, Sekk disse:

vc usa mysql ou sqlite?

sqlite

@Sekk up

[Sekk 396]

abre o sqlite studio, vai no lapis la em cima no menu, cola o codigo e aperta f9

[kiinho 11]

@Sekk 

 

Fiz tudo como vc disse e deu nisso:

 

 

[roriscrave 61]

local storage = 1344
local raids = {
    "Morgaroth",
    "Ghazbaran",
    "Undead Jester",
    "goblin",
    "Dryads",
    "Halloweenhare",
    "Hornedfox",
    "Necropharus",
    "Wolfsraid",
    "UndeadArmy",
    "UndeadDarashia",
    "The Old Widow",
    "Scarabs",
    "Rats",
    "Quara",
    "Pirates",
    "Orshabaal",
    "OrcsThais",
    "Ferumbras",
    "Elfs",
    "Demodras",
    "Barbarian"
}
function onThink(interval, lastExecution, thinkInterval)
    if (getGlobalStorageValue(storage) == -1) or (getGlobalStorageValue(storage) < os.time()) then
        executeRaid(raids[math.random(1, #raids)])
        setGlobalStorageValue(storage, os.time() + 9 * 60 * 60)
    end
    return TRUE
end

[Sekk 396]

function onThink(interval, lastExecution)
local storage = 1344
local raids = {"Morgaroth","Ghazbaran", "Undead Jester", "goblin", "Dryads", "Halloweenhare", "Hornedfox", "Necropharus", "UndeadArmy", "UndeadDarashia", "The Old Widow", "Scarabs", "Rats", "Quara", "Pirates", "Orshabaal", "OrcsThais", "Ferumbras", "Elfs", "Demodras", "Barbarian",}

    if getGlobalStorageValue(storage) == -1 or getGlobalStorageValue(storage) < os.time() then
        executeRaid(raids[math.random(1, #raids)])
        setGlobalStorageValue(storage, os.time() + 9 * 60 * 60)
    end
    return TRUE
end