AAC SQL Query

[Svira]

Hello, try add XXXX value in DB. The value in the script is given as PLAYER_DPS[pid]

my database query

db.query("UPDATE `players` SET `dps` = ' .. PLAYER_DPS[pid] .. ' WHERE `id` = " .. guid)

and error:

Message: Incorrect integer value: ' .. PLAYER_DPS[pid] .. ' for column 'dps' at row 1

SOLVED:

db.query("UPDATE `players` SET `dps` = (\"".. PLAYER_DPS[pid] .."\") WHERE `id` = " .. guid)

 

[Itutorial]

local query = string.format("UPDATE `player` SET `dps` = %d WHERE `id` = %d", PLAYER_DPS[pid], guid)
db.query(query)

 

[Svira]

local query = string.format("UPDATE `player` SET `dps` = %d WHERE `id` = %d", PLAYER_DPS[pid], guid)
db.query(query)

here:
db.query("UPDATE players SET dps = (\"".. PLAYER_DPS[pid] .."\") WHERE id = " .. guid)