Item give points

[xLosT]

if use on item id xxxx give 5 pontos

 

[Dante_]

All depends on where you're storing the points, what the points are supposed to be, and if you have a function for the points.

 

[xLosT]

accounts / premium_points
gesior acc

 

[xLosT]

up
up

 

[Knight God]

function onUse(cid, item, fromPosition, itemEx, toPosition)
local points = 5 
    function doAddPoints(cid, points) 
  db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";") 
    doRemoveItem(item.uid)
  end
     return true
end

try :/

 

[Dantarrix]

If Knight God's script doesn't work, try this one:

function onUse(cid, item, fromPosition, itemEx, toPosition)
local points = 5 
  db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";") 
    doRemoveItem(item.uid)
     return true
end

Only removed 2 lines... xDDD Cause i think they dont have any function in the script....

 

[xLosT]

please msg, you have gain 5 points.

 

[Knight God]

function onUse(cid, item, fromPosition, itemEx, toPosition)
local points = 5 
    function doAddPoints(cid, points) 
      db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";") 
        doRemoveItem(item.uid)
     doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "you have received 5 premium points.")
  end
     return true
end

 

[Erexo]

OR:

function onUse(cid, item, fromPosition, itemEx, toPosition) 
local points = 5
function doAddPremiumPoints(accountName, points)
	points = tostring(points)
	return db.executeQuery('UPDATE `accounts` SET `premium_points` = `premium_points` ' .. (not points:find('^%-') and '+' or '-') .. points:sub(points:find('%d+')) .. ' WHERE `name` = ' .. accountName .. ' LIMIT 1;')
end
-- By Erexo
doAddPremiumPoints(getPlayerAccount(cid), points)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "you have received "..points.." premium points.") 
return true
end

NOT TESTED

 

[Knight God]

is the same xD

My script is simple

 

[xLosT]

you script not fuction
i add you doplayersendmsg...
in Dantarrix script
thx all

 

[Dantarrix]

Mine works? LOL xD