Lua Scroll Premium Points in WebsiteShop

[Monomalo00]

Hii! Any script so that when you give him a scroll, you get "X" premium points in shop? +REP

 

[seleo]

this one adds 30 premium points to your account in use

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

 

[Cornex]

Change

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received 1 Premium Point")

to

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received "..points.." Premium Point")

And please, use search or learn some lua. This are EXREMLY easy/basic

 

[Monomalo00]

this one adds 30 premium points to your account in use

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

where I put that?

 

[Limos]

In actions.

 

[Monomalo00]

And in Actions.xml?

 

[Amiroslo]

If the function is onUse then it means it's an action, because you gonna use smthn. If it's onkill/look/death/preparedeath/login then they are a creaturescript (not sure if I missed some) and you also have movement and globalevents etc

 

[Cronox]

use script Seleo
data/actions/scripts
create 1 file archive .lua
name.. points.lua

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

and now goto data/actions open actions.xml
add this line

<action itemid="123" script="points.lua"/>

or

<action itemid="123" event="script" value="points.lua"/>

just only edit itemid="123" to itemid your scroll..

 

[GM Ambera]

1. local points = 30 -- amount of premium points
2. 
   
3. function onUse(cid, item, fromPosition, itemEx, toPosition)
4. if isPlayer(cid) == TRUE then
5. local Sql = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)
6. db.executeQuery(Sql)
7. doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received 30 Premium Point")
8. doRemoveItem(item.uid)
9. end
10. return true
11. end

i got znote accounts i was changed but didnt added points ... Script work but dont add premium points please help