[actions]

[domelxp]

i need to script :
item who give 200 points to sms shop for who recive this item
. thx

 

[KylerXX]

function onUse(cid, item, fromPosition, itemEx, toPosition)
local points = 1
doRemoveItem(item.uid, 1)
doPlayerSendTextMessage(cid, 22, "You have received ".. points ..".")
db.executeQuery("INSERT INTO `table` (`cid`, `points`) VALUES ('"..getPlayerGUID(cid).."', '"..points.."');")
return true
end

I do not know much of SQL code, sorry if is not works.
You need to modify the function db.ExecuteQuery,`table`to your players table, and local points to the points to receive.