Vip system error

[-Mohamed Shipl-]

i need fix this script for vip effects

function onThink(interval, lastExecution)
for _, name in ipairs(getOnlinePlayers() do
local cid = getPlayerByName(name)
if getPlayerVipDays(cid) >= 1 then
doSendMagicEffect(getPlayerPosition(cid), 27)
doSendAnimatedText(getPlayerPosition(cid), "VIP!", TEXTCOLOR_RED)
end
end
return true
end

i got this error

 

[Limos]

function onThink(interval, lastExecution)
     for _, name in ipairs(getOnlinePlayers()) do
         local cid = getPlayerByName(name)
         if getPlayerVipDays(cid) >= 1 then
             doSendMagicEffect(getPlayerPosition(cid), 27)
             doSendAnimatedText(getPlayerPosition(cid), "VIP!", TEXTCOLOR_RED)
         end
     end
     return true
end

 

[-Mohamed Shipl-]

i got the same error

 

[Limos]

Can you upload the Lua file on speedyshare?
It's not possible to get such an error from the script I just posted.

 

[-Mohamed Shipl-]

i got this again

 

[Limos]

http://otland.net/threads/the-best-vip-system-ever-action-movevent-globalevent.71638/

Add the functions to data/lib/050-function.lua

function getPlayerVipDays(cid)
     local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
     if Info:getID() ~= LUA_ERROR then
         local days= Info:getDataInt("vipdays")
         Info:free()
         return days
     end
     return LUA_ERROR
end

 

[-Mohamed Shipl-]

i god error when i add it man can u give me ur function and add this to it

edit the functions and give me it can u

?

 

[Limos]

All functions:

function getPlayerVipDays(cid)
     local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
     if Info:getID() ~= LUA_ERROR then
         local days= Info:getDataInt("vipdays")
         Info:free()
         return days
     end
     return LUA_ERROR
end

function doAddVipDays(cid, days)
     db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

function doRemoveVipDays(cid, days)
     db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

Add this to data/lib/050-function.lua.
If you have errors, post them.

 

[-Mohamed Shipl-]

hmm , i need to remove all in the functions or add this to it?

 

[Limos]

No, just add this, don't remove anything there. Or if you already added getPlayerVipDays, just the other 2 functions.

 

[EvilSkillz]

hmm , i need to remove all in the functions or add this to it?

you have empty mind -_-
you got error because you don't got the fucken function
so you need to add them

 

[-Mohamed Shipl-]

man can i upload the function file and add it can u please?

?

 

[Limos]

Just select the functions I posted, click copy and paste in your 050-function.lua.
If you get errors after that, post your 050-function.lua with the functions you added.

 

[-Mohamed Shipl-]

i got this again

 

[Limos]

Post your 050-function.lua.

 

[-Mohamed Shipl-]

says~~
please, enter message with no more that 10000 characters

 

[Limos]

http://pastebin.com/

 

[-Mohamed Shipl-]

go....!make that and give me it
http://pastebin.com/f7h9Aux2

 

[Limos]

Remove the part where I added the red square, so what is inside that remove that.
http://4.ii.gl/QClg8ACs.png

 

[-Mohamed Shipl-]

i got this again~!
[01/07/2014 20:37:46] Error during getDataInt(vipdays).