Jayz Posted August 26, 2022 Group: Members Topic Count: 59 Topics Per Day: 0.01 Content Count: 407 Reputation: 55 Joined: 07/24/12 Last Seen: October 22, 2024 Share Posted August 26, 2022 (edited) Hello, how to add multiplier on query this is the example of script input .@amount; query_sql("INSERT INTO `mapreg` (`varname`, `index`, `value`) VALUES ('$Events', 0, '5*.@amount') ON DUPLICATE KEY UPDATE `value` = `value` + 5*.@amount"); '5*.@amount' is not working instead they put on the value the whole text Thank you EDIT: SOLVED It will be 1*"+.@amount+" Thanks @Balfear Edited August 26, 2022 by Jayz Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted August 27, 2022 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2372 Joined: 10/28/11 Last Seen: Sunday at 01:46 PM Share Posted August 27, 2022 you can just do like this $Events = 5 * .@amount; Quote Link to comment Share on other sites More sharing options...
Question
Jayz
Hello, how to add multiplier on query this is the example of script
input .@amount; query_sql("INSERT INTO `mapreg` (`varname`, `index`, `value`) VALUES ('$Events', 0, '5*.@amount') ON DUPLICATE KEY UPDATE `value` = `value` + 5*.@amount");
'5*.@amount' is not working instead they put on the value the whole text
Thank you
EDIT: SOLVED
It will be 1*"+.@amount+"
Thanks @Balfear
Edited by JayzLink to comment
Share on other sites
1 answer 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.