Is this Query in LUA correct?

[Tyson12302]

local points = 10 -- amount of premium points

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

I'm trying to use this for a Premium Points scroll everything works and it says that i received the points but when i check the website and database it is not there.

 

[WibbenZ]

local points = 10 -- amount of premium points
function onUse(cid, item, fromPosition, itemEx, toPosition)
    db.executeQuery("UPDATE `znote_accounts` SET `points` = `points` + " .. points .. " where id = " .. getPlayerAccountId(cid) .. ";")
    doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received 10 Premium Point")
    doRemoveItem(item.uid)
    return true
end

If it dosen't work then check if the columns name match your database structure.

 

[Tyson12302]

Still doesn't work. I checked and my Shop points come from the column "points" and they are from "znote_accounts. What is the problem?

 

[RosOT]

Try this.

local points = 10 -- amount of premium points

function onUse(cid, item, fromPosition, itemEx, toPosition)
if isPlayer(cid) == TRUE then
db.executeQuery('UPDATE znote_accounts SET points=points+'.. points ..' WHERE account_id=' .. getPlayerAccountId(cid))
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"You have received ".. points .." shop points.")
doRemoveItem(item.uid)
end
return true
end

 

[Tyson12302]

Fixed. My Query was wrong i changed it to

db.executeQuery('UPDATE znote_accounts SET points=points+1 WHERE account_id='.. getPlayerAccountId(cid))

and it started to work.

 

[WibbenZ]

Fixed. My Query was wrong i changed it to

db.executeQuery('UPDATE znote_accounts SET points=points+1 WHERE account_id='.. getPlayerAccountId(cid))

and it started to work.

In the future remember to actually check the queries, it's very easy that it's something wrong when you download things.

If it dosen't work then check if the columns name match your database structure.