Buy Skill

function onSay(cid, words, param, channel)

local SKILLS = {
["sword"] = {skillId = 2, onlyVocs = {4, 8}, needItem = 2160, max = 350},
["club"] = {skillId = 1, onlyVocs = {4, 8}, needItem = 2160, max = 350},
["axe"] = {skillId = 3, onlyVocs = {4, 8}, needItem = 2160, max = 350},
["distance"] = {skillId = 4, onlyVocs = {3, 7}, needItem = 2160, max = 350},
["shield"] = {skillId = 5, onlyVocs = {3, 4, 7, 8}, needItem = 2160, max = 300},
["magic"] = {skillId = 7, onlyVocs = {1, 2, 5, 6}, needItem = 2160, max = 250},
}

local s = string.explode(param, ",")
local a = SKILLS[s[1]]
local str = "Items necessários para comprar o skill " .. param .. "/n/n"
local str2 = "Skill's existentes/n/n"

if a then
if isPremium(cid) then
if getTilePzInfo(getThingPos(cid)) == 1 then
if isInArray(a.onlyVocs, getPlayerVocation(cid)) then
if getPlayerItemCount(cid, a.needItem) >= s[2] then
if getPlayerSkillLevel(cid, a.skillId) <= a.max then
db.query("UPDATE `player_skills` SET `value` = " .. (getPlayerSkillLevel(cid, a.skillId, true) + s[2]) .. ", `count` = 0 WHERE `skillid` = " .. a.skillId .. " and `player_id` = " .. getPlayerGUID(cid) .. ";")
doPlayerSendTextMessage(cid, 25, "Você comprou 1(um) skill level(" .. param .. ") por " .. s[2] .. "x " .. getItemNameById(a.needItem) .. ".")
doSendMagicEffect(getThingPos(cid), math.random(28, 30))
doSendAnimatedText(getThingPos(cid), param, math.random(1, 255))
addEvent(doRemoveCreature, 2 * 1000, cid)
doRemoveItem(cid, a.needItem, s[2])
else
doPlayerSendTextMessage(cid, 27, "Você já está com o skill no máximo.")
end
else
str = str .. s[2]"x - " .. getItemNameById(a.needItem)
doShowTextDialog(cid, 2170, str)
end
else
doPlayerSendTextMessage(cid, 27, "A sua vocação não pode comprar esse skill.")
end
else
doPlayerSendTextMessage(cid, 27, "Só pode ser usado em protection zone.")
end
else
doPlayerSendTextMessage(cid, 27, "Somente premium players podem comprar.")
end
else
for a, b in pairs(SKILLS) do
str2 = str2 .. "" .. a .. "/n"
end
doShowTextDialog(cid, 2160, str2)
end
return true
end