Lua GlobalEvent for remove VIP Days

[_Aion_]

Hello, i'm making one script that remove VIP Days and [VIP] from name of player.
but i dont know what is wrong.
this is my code

function onTime()
if string.find(tostring(getCreatureName(cid)),"[[VIP]]") and getPlayerVipDays(cid) == 0 then

db.executeQuery("UPDATE `players` SET `name` = '"..string.sub(getCreatureName(cid), 7).."' WHERE `id` = "..getPlayerGUID(cid)..";")
db.executeQuery("UPDATE players SET vipdays = vipdays - 1 WHERE vipdays > 0;")
print("VIP's Removidas com Sucesso!!")
end
return true
end

Dont remove and give error.

(LuaInterface::internalGetPlayerInfo) Player not found when requesting player info #18

Is for remove from players offline, but i tried all and no sucess

 

[Sir Islam]

function onTime()
for _, cid in ipairs(getPlayersOnline()) do

if string.find(tostring(getCreatureName(cid)),"[[VIP]]") and getPlayerVipDays(cid) == 0 then

db.executeQuery("UPDATE `players` SET `name` = '"..string.sub(getCreatureName(cid), 7).."' WHERE `id` = "..getPlayerGUID(cid)..";")
db.executeQuery("UPDATE players SET vipdays = vipdays - 1 WHERE vipdays > 0;")
print("VIP's Removidas com Sucesso!!")
end
end
return true
end

 

[_Aion_]

This will remove from players offline or just online?

 

[Evil Puncker]

just online

 

[Sir Islam]

just online

 

[_Aion_]

And for offline player?
how i put?

 

[Sir Islam]

And for offline player?
how i put?

if player relog will remove from him [VIP] i think

 

[_Aion_]

For player Online works perfeclty, but i need for offline player :X

 

[Sir Islam]

bro this like rl tibia in remove Premium days player need relog to remove this not problem