Lua [SQLite] -=[TFS]=- 0.4 8.60 How can I fix this script with problem in storage vip

[samuel157]

(getPlayerStorageValue(cid, 13545)

function onSay(cid, words, param)
local level = getPlayerLevel(cid)
local vocation = getPlayerVocationName(cid)
local health, maxhealth = getCreatureHealth(cid), getCreatureMaxHealth(cid)
local mana, maxmana = getCreatureMana(cid), getCreatureMaxMana(cid)
local balance, pdays = getPlayerBalance(cid), getPlayerPremiumDays(cid)
local fist, club, sword, axe = getPlayerSkillLevel(cid, 0), getPlayerSkillLevel(cid, 1), getPlayerSkillLevel(cid, 2), getPlayerSkillLevel(cid, 3)
local distance, shield, fishing, magic =  getPlayerSkillLevel(cid, 4), getPlayerSkillLevel(cid, 5), getPlayerSkillLevel(cid, 6), getPlayerMagLevel(cid)
local lvldodge = getPlayerStorageValue(cid, 98798644)
local lvlcrit  = getPlayerStorageValue(cid, 48903)
local lvlatk = getPlayerStorageValue(cid, 48904)
local days = getPlayerStorageValue(cid, 13545)
local reset = getPlayerStorageValue(cid, 54676)
local cap = getPlayerFreeCap(cid)
local msg = "Vocation: "..vocation.."\nLevel: ".. level .."\nHP: ".. health .."/".. maxhealth .."\nMP: ".. mana .."/".. maxmana .."\nCapacity: ".. cap .."\nBalance: "..balance.."\nPremium Days: "..pdays.."\nDodge Level: ".. lvldodge .."\nCritical Level: ".. lvlcrit .."\nBOOSTER ATK: ".. lvlatk .."\nMagic Level: ".. magic .."\n[VIP] Days: ".. days .." \nReset Count: ".. reset .." \n\nFist: ".. fist .."\nClub: ".. club .."\nSword: ".. sword .."\nAxe: ".. axe .."\nDistance: ".. distance .."\nShield: ".. shield .."\nFishing: ".. fishing ..""
doPlayerPopupFYI(cid, msg)
return true
end

I have 30 days VIP

 

[lursky]

It looks more like a timestamp, You should calculate diff between now and that.

local vipEndTime = getPlayerStorageValue(cid, 13545)
local vipSeconds = math.max(0, vipEndTime - os.time())
local days = math.ceil(vipSeconds / 86400)

 

[samuel157]

local days = getPlayerStorageValue(cid, 13545) \n[VIP] Days: ".. days .."

Post automatically merged: Aug 20, 2023

@lursky can you fix the script? Solved.​

 

[Mateus Robeerto]

function onSay(cid, words, param)
    local level = getPlayerLevel(cid)
    local vocation = getPlayerVocationName(cid)
    local health, maxhealth = getCreatureHealth(cid), getCreatureMaxHealth(cid)
    local mana, maxmana = getCreatureMana(cid), getCreatureMaxMana(cid)
    local balance, pdays = getPlayerBalance(cid), getPlayerPremiumDays(cid)
    local fist, club, sword, axe = getPlayerSkillLevel(cid, 0), getPlayerSkillLevel(cid, 1), getPlayerSkillLevel(cid, 2), getPlayerSkillLevel(cid, 3)
    local distance, shield, fishing, magic = getPlayerSkillLevel(cid, 4), getPlayerSkillLevel(cid, 5), getPlayerSkillLevel(cid, 6), getPlayerMagLevel(cid)
    local lvldodge = getPlayerStorageValue(cid, 98798644)
    local lvlcrit = getPlayerStorageValue(cid, 48903)
    local lvlatk = getPlayerStorageValue(cid, 48904)
    
    local vipEndTime = getPlayerStorageValue(cid, 13545)
    local vipSeconds = math.max(0, vipEndTime - os.time())
    local days = math.ceil(vipSeconds / 86400)
    
    local reset = getPlayerStorageValue(cid, 54676)
    local cap = getPlayerFreeCap(cid)
    
    local msg = "Vocation: " .. vocation .. "\nLevel: " .. level .. "\nHP: " .. health .. "/" .. maxhealth .. "\nMP: " .. mana .. "/" .. maxmana .. "\nCapacity: " .. cap .. "\nBalance: " .. balance .. "\nPremium Days: " .. pdays .. "\nDodge Level: " .. lvldodge .. "\nCritical Level: " .. lvlcrit .. "\nBOOSTER ATK: " .. lvlatk .. "\nMagic Level: " .. magic .. "\n[VIP] Days: " .. days .. " \nReset Count: " .. reset .. " \n\nFist: " .. fist .. "\nClub: " .. club .. "\nSword: " .. sword .. "\nAxe: " .. axe .. "\nDistance: " .. distance .. "\nShield: " .. shield .. "\nFishing: " .. fishing .. ""
    
    doPlayerPopupFYI(cid, msg)
    return true
end