BrunoMayer7 Posted January 12, 2021 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 4 Reputation: 0 Joined: 01/08/20 Last Seen: May 22, 2023 Share Posted January 12, 2021 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). Quote Link to comment Share on other sites More sharing options...
0 BrunoMayer7 Posted January 12, 2021 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 4 Reputation: 0 Joined: 01/08/20 Last Seen: May 22, 2023 Author Share Posted January 12, 2021 done! Query_SQL "UPDATE `char` SET `quest_points` = `quest_points` + "+10+", `E` = `E` + "+1+" WHERE `char_id` = "+getcharid(0); Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted January 15, 2021 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: Sunday at 05:32 PM Share Posted January 15, 2021 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)); Quote Link to comment Share on other sites More sharing options...
Question
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).
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.