erro no add vip

[andre2005 0]

salve pessoal tenho um ot no qual eu vo add vip ao player fala q o player ta off ou ele não existe

 

ja tem essa forma q e a correta /add vip 50 nome do char

 

/vip add 40 nome do char tentei de tudo quante forma ate inverti os lugares da palavra

 

fala q o player n existe

 

e tbm n consigo fazer a transição de itens pelo gersior 3.8 e nem pelo 3.6 eu vendo os pontos e na hora de troka da essse erro aki na hora de troka pela vip ou item

 

essa e minha add vip q ta dentro do talkactions

 

-- [( Script edited by: DoidinMapper )] --

function onSay(cid, words, param)

access = 4

days = 30

player = getPlayerByName(param)

daysvalue = days*3600*24

storageplayer = getPlayerStorageValue(player,13540)

timenow = os.time()

if storageplayer == -1 or storageplayer == 0 then

time = timenow+daysvalue

else

time = storageplayer+daysvalue

end

if param ~= "" then

if getPlayerGroupId(cid) >= access then

doPlayerSendTextMessage(player, MESSAGE_INFO_DESCR, "Were added ".. days .." VIP day on your character.")

setPlayerStorageValue(player,13540,time)

quantity = math.floor((getPlayerStorageValue(player,13540) - timenow)/(3600*24))

doPlayerSendTextMessage(player, MESSAGE_INFO_DESCR, "You have ".. quantity .." days of VIP time.")

else

doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Only members with greater access to ".. access .." can add VIP.")

end

end

end

________________________________________________________________________________

tbm tem a pasta da vip

q ta assim

 

add

function onSay(cid, words, param, channel)

doPlayerSendCancel(cid, "Added "..param.." Vip Days.")

return doPlayerAddVipDays(cid, param)

end

______________________________________________________________________________

add vip

function onSay(cid, words, param)

if param == "" then

return doPlayerPopupFYI(cid,"Está com problemas?\nAprenda os comandos!\n---------------\nAdicionar vip:\n/vip add days player\n/vip add 30 Real\n---------------\nDeletar vip:\n/vip del player\n/vip del Real\n---------------\nVer a vip:\n/vip see player\n/vip see Real\n---------------\n")

end

if param:lower():find('add') == 1 and 3 then

local _,_,id,name = param:lower():find('add (%d+) (.+)')

name = name or ""

id = tonumber(id or 1) or 1

if tonumber(id) == nil or getPlayerByName(name) == false then

return doPlayerSendTextMessage(cid,25,"Adicionar vip:\n/vip add days player\n/vip add 30 Real\n [Player: "..name.."]")

end

if isPlayer(getPlayerByName(name)) == TRUE then

vip.addVipByAccount(getPlayerAccount(getPlayerByName(name)) ,vip.getDays(id))

 

doPlayerSendTextMessage(cid,25,"Foram adicionados "..tonumber(id).." dias de vip a "..name..".")

doPlayerSendTextMessage(getPlayerByName(name),25,"Você recebeu "..tonumber(id).." dias de vip.")

else

doPlayerSendTextMessage(cid,25,name.." não esta online ou não existe.")

end

elseif param:lower():find('del') == 1 and 3 then

local _,_,name = param:lower():find('del (.+)')

if getPlayerByName(name) == false then

return doPlayerSendTextMessage(cid,25,"Deletar vip:\n/vip del player\n/vip del Real\n")

end

 

vip.setVipByAccount(getPlayerAccount(getPlayerByName(name)),-os.time())

doPlayerSendTextMessage(cid,25,"A vip de "..name.." foi apagada.")

elseif param:lower():find('see') == 1 and 3 then

local _,_,name = param:lower():find('see (.+)')

name = name or ""

if getPlayerByName(name) == false then

return doPlayerSendTextMessage(cid,25,"Ver a vip:\n/vip see player\n/vip see Real\n")

end

local ret_ = vip.getVip(getPlayerByName(name))

if ret_ == 0 then

return doPlayerSendTextMessage(cid, 25,name.." Não tem vip, e nunca teve.")

else

return doPlayerSendTextMessage(cid, 25, "A vip de "..name.." Acaba/terminou em "..os.date("%d %B %Y %X ",ret_))

end

end

return TRUE

end

 

get

function onSay(cid, words, param, channel)

doPlayerSendCancel(cid, ""..getPlayerVipDays(cid).." days VIP left.")

end

____________________________________________________________________________

is

function onSay(cid, words, param, channel)

if isPlayerVip(cid) == TRUE then

doPlayerSendCancel(cid, "You are a VIP player.")

else

doPlayerSendCancel(cid, "You are not a VIP player.")

end

end

_________________________________________________________________________

remove

function onSay(cid, words, param, channel)

doPlayerSendCancel(cid, "Vip removed.")

return doPlayerRemoveVip(cid)

end

___________________________________________________________________________

set

function onSay(cid, words, param, channel)

doPlayerSendCancel(cid, "VIP Days: "..param..".")

return setPlayerVipDays(cid, param)

end

____________________________________________________________________________

vip days

unction onSay(cid, words, param)

if vip.hasVip(cid) == TRUE then

doPlayerSendTextMessage(cid, 22, "Your vip end in "..os.date("%d %B %Y %X ",vip.getVip(cid)))

else

if vip.getVip(cid) ~= 0 then

doPlayerSendTextMessage(cid, 22, "You're not a vip player. Your vip has finished in "..os.date("%d %B %Y %X ", vip.getVip(cid)).." and now is "..os.date("%d %B %Y %X ", os.time()))

else

doPlayerSendTextMessage(cid, 22, "You're not a vip player. You naver has a vip.")

end

end

return TRUE

end

end

_________________________________________________________________________________

esse daki e o erro do site na hora da transição da vip to com os pontos na hora q clico em troka da isso

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:772 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(772): PDO->query('SELECT `vip_tim...') #1 C:\xampp\htdocs\shopsystem.php(390): OTS_Account->getCustomField('vip_time') #2 C:\xampp\htdocs\index.php(208): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 772

 

se alguem poder me ajuda ne um dos dois ja agradeço pois so quero a vip ^^ valendo 1 pontinho ai!