tenta usar o script desse jeito la no globalevents

function pegarPoints(acc)
local info = db.getResult("SELECT `p_points` FROM `accounts` WHERE `id` = "..acc)
return info:getDataInt("p_points") < 0 and 0 or info:getDataInt("p_points")
end
function onThink(interval)
local config = {
       p_time = 3600, -- Tempo em segundos para receber os pontos( 3600 = 1hora )
       p_points = 1 -- Quantidade de pontos recebida a cada "p_time"
} 
for _, cid in ipairs(getPlayersOnline()) do
if os.time() - getCreatureStorage(cid, 1219) >= config.p_time then
local dono = getPlayerAccountId(cid)
db.executeQuery("UPDATE `accounts` SET `p_points` = " .. (pegarPoints(dono) + config.p_points) .. " WHERE `id` = "..dono)
doPlayerSendTextMessage(cid, 19, "Congratulations, you recieved ".. config.p_points .." p points. Now you have ".. getPoints(cid) .." p points in your account. Your timer was reseted.")   
doCreatureSetStorage(cid, 1219, 0)
doCreatureSetStorage(cid, 1219, os.time())
end
end
return true
end

Editado Maio 21, 2015 10 anos por Vodkart (veja o histórico de edições)

 

tenta usar o script desse jeito la no globalevents

function pegarPoints(acc)
local info = db.getResult("SELECT `p_points` FROM `accounts` WHERE `id` = "..acc)
return info:getDataInt("p_points") < 0 and 0 or info:getDataInt("p_points")
end
function onThink(interval)
local config = {
       p_time = 3600, -- Tempo em segundos para receber os pontos( 3600 = 1hora )
       p_points = 1 -- Quantidade de pontos recebida a cada "p_time"
} 
for _, cid in ipairs(getPlayersOnline()) do
if os.time() - getCreatureStorage(cid, 1219) >= config.p_time then
local dono = getPlayerAccountId(cid)
db.executeQuery("UPDATE `accounts` SET `p_points` = " .. (pegarPoints(dono) + config.p_points) .. " WHERE `id` = "..dono)
doPlayerSendTextMessage(cid, 19, "Congratulations, you recieved ".. config.p_points .." p points. Now you have ".. getPoints(cid) .." p points in your account. Your timer was reseted.")   
doCreatureSetStorage(cid, 1219, 0)
doCreatureSetStorage(cid, 1219, os.time())
end
end
return true
end

db.executeQuery

[21/05/2015 13:56:07] [Error - GlobalEvent Interface]
[21/05/2015 13:56:07] data/globalevents/scripts/pointsperhour.lua:onThink
[21/05/2015 13:56:07] Description:
[21/05/2015 13:56:07] data/globalevents/scripts/pointsperhour.lua:13: attempt to call field 'executeQuery' (a nil value)
[21/05/2015 13:56:07] stack traceback:
[21/05/2015 13:56:07]     data/globalevents/scripts/pointsperhour.lua:13: in function <data/globalevents/scripts/pointsperhour.lua:5>
[21/05/2015 13:56:07] [Error - GlobalEvents::think] Couldn't execute event: points

 

db.query

[21/05/2015 13:58:05] [Error - GlobalEvent Interface]
[21/05/2015 13:58:05] data/globalevents/scripts/pointsperhour.lua:onThink
[21/05/2015 13:58:05] Description:
[21/05/2015 13:58:05] data/globalevents/scripts/pointsperhour.lua:13: attempt to call field 'query' (a nil value)
[21/05/2015 13:58:05] stack traceback:
[21/05/2015 13:58:05]     data/globalevents/scripts/pointsperhour.lua:13: in function <data/globalevents/scripts/pointsperhour.lua:5>
[21/05/2015 13:58:05] [Error - GlobalEvents::think] Couldn't execute event: points

 

 

 

db.escapeString

com esse fica sem erro no distro, porém não adiciona os pontos

tenta usar 'db.Query'

tenta usar 'db.Query'

 

 

 

 

db.query

[21/05/2015 13:58:05] [Error - GlobalEvent Interface]
[21/05/2015 13:58:05] data/globalevents/scripts/pointsperhour.lua:onThink
[21/05/2015 13:58:05] Description:
[21/05/2015 13:58:05] data/globalevents/scripts/pointsperhour.lua:13: attempt to call field 'query' (a nil value)
[21/05/2015 13:58:05] stack traceback:
[21/05/2015 13:58:05]     data/globalevents/scripts/pointsperhour.lua:13: in function <data/globalevents/scripts/pointsperhour.lua:5>
[21/05/2015 13:58:05] [Error - GlobalEvents::think] Couldn't execute event: points

é db.Query com o Q maiusculo