Solved Lua Scripts

[nevix]

Whats wrong with this code? Please help

  local accid = getAccountNumberByPlayerName(getPlayerName(cid))
db.executeQuery("UPDATE `znote_accounts` SET `points` = `points`+2 WHERE `account_id` = " .. accid .. " LIMIT 1;")

TFS 1.0

 

[dominique120]

local cfg =
{
  points = 25,
}
db.executeQuery("UPDATE `znote_accounts` SET `points` = `points` + " .. cfg.points .. " WHERE `account_id` = '" .. getAccountNumberByPlayerName(getCreatureName(itemEx.uid)) .. "' LIMIT 1;")

How about this?

 

[Ninja]

local accid = Player(cid):getAccountId()
local points = 2
db.query("UPDATE `znote_accounts` SET `points` = `points` + " .. points .. " WHERE `account_id` = " .. accid)

 

[nevix]

Thx, guys. With your all help i created own last man standing event. I learned so much