Solved Useitem get x points problem

[gremlee]

Hello i use 0.4 rev 8.6 i also use znote aac,

i want to use item id 10141 then i get 1 donate point to my account on website i tryend alot of script but seems that nothing is working for me.

Thx for you help

bump

 

[Ninja]

Most scripts are for Gesior/Modern AAC, did you change the fields so it matches Znote AAC?

e.g

local player = Player(cid)
local accountId, points = player:getAccountId(), 5
db.query("UPDATE znote_accounts SET points = points + " .. points .. " WHERE account_id = " .. accountId)

 

[gremlee]

Most scripts are for Gesior/Modern AAC, did you change the fields so it matches Znote AAC?

e.g

local player = Player(cid)
local accountId, points = player:getAccountId(), 5
db.query("UPDATE znote_accounts SET points = points + " .. points .. " WHERE account_id = " .. accountId)

function onUse(cid, item, fromPosition, itemEx, toPosition)
if item.itemid == 11260 then
doPlayerAddPremiumDays(cid, 1)
doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 days of premium access.")
doRemoveItem(item.uid)
elseif item.itemid == 10141 then
db.query("UPDATE znote_accounts SET points = points + " .. points .. " WHERE account_id = " .. accountId)
doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 shop point to your account.")
doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
doRemoveItem(item.uid)

i tryied and i change it but getting errors now something stack traceback.

 

[Ninja]

function onUse(cid, item, fromPosition, itemEx, toPosition)
    if item.itemid == 11260 then
        doPlayerAddPremiumDays(cid, 1)
        doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
        doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 days of premium access.")
        doRemoveItem(item.uid)
    elseif item.itemid == 10141 then
        local accountId, points = getPlayerAccountId(cid), 1
        db.query("UPDATE znote_accounts SET points = points + " .. points .. " WHERE account_id = " .. accountId)
        doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 shop point to your account.")
        doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
        doRemoveItem(item.uid)
    end
    return true
end

 

[gremlee]

function onUse(cid, item, fromPosition, itemEx, toPosition)
    if item.itemid == 11260 then
        doPlayerAddPremiumDays(cid, 1)
        doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
        doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 days of premium access.")
        doRemoveItem(item.uid)
    elseif item.itemid == 10141 then
        local accountId, points = getPlayerAccountId(cid), 1
        db.query("UPDATE znote_accounts SET points = points + " .. points .. " WHERE account_id = " .. accountId)
        doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 shop point to your account.")
        doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
        doRemoveItem(item.uid)
    end
    return true
end

Thanks alot ninja!!!

 

[Oldschool'er]

can someone make this for gesior and not znote?

 

[StreamSide]

can someone make this for gesior and not znote?

what? is just a query, change

UPDATE znote_accounts SET points = points WHERE account_id

to

UPDATE accounts SET premium_points = premium_points WHERE id

or bigmoma_points idk

 

[Oldschool'er]

what? is just a query, change

UPDATE znote_accounts SET points = points WHERE account_id

to

UPDATE accounts SET premium_points = premium_points WHERE id

or bigmoma_points idk

how do i add it to this?

elseif item.itemid == 10141 then
        local accountId, points = getPlayerAccountId(cid), 1
        db.query("UPDATE znote_accounts SET points = points + " .. points .. " WHERE account_id = " .. accountId)
        doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 shop point to your account.")
        doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
        doRemoveItem(item.uid)

i added it but got this error

 

[Limos]

UPDATE accounts SET premium_points = premium_points WHERE id

 

[Oldschool'er]

another error = s

script

elseif item.itemid == 10141 then
        local accountId, points = getPlayerAccountId(cid), 1
        db.query("UPDATE accounts SET premium_points = premium_points WHERE id" .. accountId)
        doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 shop point to your account.")
        doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
        doRemoveItem(item.uid)

 

[Limos]

add = after id.

 

[Oldschool'er]

add = after id.

ok thanks i will test it

 

[Oldschool'er]

no error but doesnt give points :s

 

[Ninja]

db.query("UPDATE accounts SET premium_points = premium_points + " .. points .. " WHERE id = " .. accountId)

 

[Oldschool'er]

db.query("UPDATE accounts SET premium_points = premium_points + " .. points .. " WHERE id = " .. accountId)

thanks works now

 

[imback1]

function onUse(cid, item, fromPosition, itemEx, toPosition)
    if item.itemid == 11260 then
        doPlayerAddPremiumDays(cid, 1)
        doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
        doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 days of premium access.")
        doRemoveItem(item.uid)
    elseif item.itemid == 10141 then
        local accountId, points = getPlayerAccountId(cid), 1
        db.query("UPDATE znote_accounts SET points = points + " .. points .. " WHERE account_id = " .. accountId)
        doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have been granted 1 shop point to your account.")
        doSendMagicEffect(getThingPos(cid), CONST_ME_FIREWORK_BLUE)
        doRemoveItem(item.uid)
    end
    return true
end

excuse me is it for 0.3.6 and please tell me where can i put this

 

[Oldschool'er]

it works for 0.3.6