SQL bank

[BrunoMayer7]

Hello, I am trying to change something in my sql bank with this comand>

Query_SQL "UPDATE `char` SET `quest_points` = `quest_points` + "+10+", `E` = `E` + "+1+" WHERE `account_id` = "+getcharid(3);

But wen I use this comand change every char in my account, I want to change only the char that use the NPC.

I try change the account_id >>> char_id and it do not work.

Query_SQL "UPDATE `char` SET `quest_points` = `quest_points` + "+10+", `E` = `E` + "+1+" WHERE `char_id ` = "+getcharid(3);

 

How I can change the quest_points only in 1 char?

 I don`t want to change all account.

(sorry for my bad English).

[BrunoMayer7]

done!

Query_SQL "UPDATE `char` SET `quest_points` = `quest_points` + "+10+", `E` = `E` + "+1+" WHERE `char_id` = "+getcharid(0);

[Emistry]

On 1/12/2021 at 2:24 PM, BrunoMayer7 said:

done!

Query_SQL "UPDATE `char` SET `quest_points` = `quest_points` + "+10+", `E` = `E` + "+1+" WHERE `char_id` = "+getcharid(0);

number doesn't need concatenation.

query_sql("UPDATE `char` SET `quest_points` = `quest_points` + 10, `E` = `E` + 1 WHERE `char_id` = "+getcharid(0));