[db.query] How can i add "honor" points to database?

[tejdi]

Hello i want to add "honor points" to my server, so:
1. I added this:

     `honor` INT NOT NULL DEFAULT 0,

to my mysql.sql
2. I added this to my quest:

 db.query("UPDATE `players` SET `honor` = 10")

but it's giving honor for all players on the server. when i want add for only one who is making quest, can somebody say me how can i do it? Thanks

 

[Zippow]

050-function.lua

function doPlayerAddHonorPoints(cid, points)
return db.executeQuery("UPDATE `accounts` SET `honor` = `honor` + " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

In your quest LUA:

doPlayerAddHonorPoints(cid, amount)

 

[tejdi]

UPDATE `players` not `accounts` but thanks a lot <3
@Zippow