Hello, i have with a talkaction command !skullremove, everything is okey skull is removed but the frags is still in database, so when i relog i get again rs. I'm using this script
trying also with frag remover item and same problem with frags in db.
Lua:
local exstorage = 1499
-- how many premium points are needed to take off the red skull
local COST = 20
-- "yes" or "no" // should it also remove all frags?
local REMOVE_FRAGS = "yes"
-- effect to use // you can find the list in data/lib/constant.lua
local EFFECT = CONST_ME_YELLOW_RINGS
function onSay(cid, words, param, channel)
if (exhaustion.check(cid, exstorage) == true) then
doPlayerSendCancel(cid, "You are exhausted")
return false
end
if getCreatureSkullType(cid) == SKULL_RED then
local query = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
local points = query:getDataInt("premium_points")
if points >= COST then
local update = db.executeQuery("UPDATE `accounts` SET `premium_points`= "..(points - COST).." WHERE `id`= " .. getPlayerAccountId(cid) .. "; ")
if (update == true) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_RED, "Your red skull has been taken off!\nRemaining premium points: " .. (points - COST))
doCreatureSetSkullType(cid, SKULL_NONE)
doWriteLogFile("./data/logs/removeskull.log", "Success: " .. getCreatureName(cid))
if (REMOVE_FRAGS == "yes") then
doPlayerSetRedSkullTicks(cid, 0)
end
doSendMagicEffect(getPlayerPosition(cid), effect)
else
doPlayerSendCancel(cid, "Database error")
end
else
doPlayerSendCancel(cid, "You need " ..COST.. " premium points to remove red skull")
end
else
doPlayerSendCancel(cid, "You do not have red skull")
end
exhaustion.set(cid, exstorage, 30)
if (query ~= nil) then
query:free()
end
return TRUE
end
trying also with frag remover item and same problem with frags in db.