• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC SQL Query

Svira

Svira

Banned User
Joined
Jan 27, 2008
Messages
361
Solutions
13
Reaction score
105
Hello, try add XXXX value in DB. The value in the script is given as PLAYER_DPS[pid]

my database query
LUA: 
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
Click to expand...


SOLVED:
SQL: 
db.query("UPDATE `players` SET `dps` = (\"".. PLAYER_DPS[pid] .."\") WHERE `id` = " .. guid)
 
Last edited:
Sort by date Sort by votes
LUA: 
local query = string.format("UPDATE `player` SET `dps` = %d WHERE `id` = %d", PLAYER_DPS[pid], guid)
db.query(query)
 
Upvote 0 Downvote
Back
Top