players SET name = '[DNT] "..getCreatureName(cid).."' WHERE id = "..getPlayerGUID(cid)..";")with promote vocation?
Post automatically merged:
local config = {
[1] = {5}, -- sorcerer
[2] = {6}, -- druid
[3] = {7}, -- paladin
[4] = {8}, -- knight
}
function onUse(cid, item, fromPosition, itemEx, toPosition)
local v = config[getPlayerVocation(cid)]
if v then
doPlayerSetVocation(cid, v[1])
doCreatureSay(cid, "You are now an "..getPlayerVocationName(cid).."!", TALKTYPE_ORANGE_1)
db.executeQuery("UPDATEplayersSETname= '[DNT] "..getCreatureName(cid).."' WHEREid= "..getPlayerGUID(cid)..";")
doPlayerSendTextMessage(cid,25,"Trankilo no Pasara Nada.")
addEvent(doRemoveCreature, 5*1000, cid, true)
doRemoveItem(item.uid, 1)
else
doPlayerSendCancel(cid,"Tu Ya Eres DNT.")
end
return true
end
local vocCount = 4
local level = 20
function onUse(cid, item, fromPosition, itemEx, toPosition)
if getPlayerVocation(cid) > vocCount then
doPlayerSendCancel(cid, "Tu Ya Eres DNT.")
return false
end
if getPlayerLevel(cid) < level then
doPlayerSendCancel(cid, "You need level 20 to promote.")
return false
end
doRemoveItem(item.uid, 1)
doCreatureSay(cid, "You are now an "..getPlayerVocationName(cid).."!", TALKTYPE_ORANGE_1)
doPlayerSetVocation(getPlayerVocation(cid) + 4)
db.executeQuery("UPDATE players SET name = '[DNT] "..getCreatureName(cid).."' WHERE id = "..getPlayerGUID(cid)..";")
addEvent(doRemoveCreature, 5*1000, cid, true)
return true
end