[Actions] [PEDIDO] Item que da Nobility Points

Descripcion escribió:Buenas amigos, necesito de su ayuda para crear un Item que al usarlo te de 1 Nobility Points en la columna "nobility" que esta en la tabla "players"

Ya intente con esto pero no me lo da

Código:

function onUse(cid, item, fromPosition, itemEx, toPosition)
db.executeQuery('UPDATE players SET nobility=nobility+'..points..' WHERE name=' .. getPlayerAccountId(cid))
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE,"You has added 1 nobility point to your character.")
doRemoveItem(item.uid, 1)

end

Imagen Explicativa escribió:Imagen Explicativa:
Version del Scripts: TFs 0.4.0

Código:


local points = 1 -- cantidad a agregar

function onUse(cid, item, fromPosition, itemEx, toPosition)
    if isPlayer(cid) == TRUE  then
 local Sql = "UPDATE `accounts` SET `nobility` = `nobility` + "..points.." where id="..getPlayerAccountId(cid)
                db.executeQuery(Sql)
 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received 1 nobility Point")
   doRemoveItem(item.uid)
   end
        return true
end


Código:

 local points = 1

function onUse(cid, item, fromPosition, itemEx, toPosition)
db.executeQuery("UPDATE `players` SET `nobility`= `nobility`+"..points.." WHERE `id` = " .. getPlayerGUID(cid))
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE,"You has added 1 nobility point to your character.")
doRemoveItem(item.uid, 1)

end