gettime or gettimestr

[Version]

how to get current time of redeem item from npc to sql logs?

this kind of format ?

2020-07-27 13:49:41

 

[Start_]

gettimestr

 

refer: \doc\script_commands.txt lines 3167

[Emistry]

create a datetime column in your sql table, and store the value using this

https://www.w3schools.com/sql/func_mysql_now.asp

[Version]

7 hours ago, Emistry said:

create a datetime column in your sql table, and store the value using this

https://www.w3schools.com/sql/func_mysql_now.asp

still dont get it.. 

error  need '('

query_sql "INSERT INTO `redeembetalog` (`code`, `item_amount`,`name`, `time`) VALUES ('"+@voucher_code$+"', '"+@amt+"', '"+strcharinfo(0)+"',  '"+SELECT NOW() + 1;+"')";

 

10 hours ago, Start_ said:

gettimestr

refer: \doc\script_commands.txt lines 3167

still error 

script:add_word: invalid word. A word consists of undercores and/or alphanumeric characters, and valid variable prefixes/postfixes.

query_sql "INSERT INTO `redeembetalog` (`code`, `item_amount`,`name`, `time`) VALUES ('"+@voucher_code$+"', '"+@amt+"', '"+strcharinfo(0)+"',  '"+gettimestr("%Y-%m/%d %H:%M:%S",21);+"')";

 

thank you Patskie,Emistry, and Start_

solved.. that escape_sql and now() works..

 

[Patskie]

31 minutes ago, Version said:

still error 

script:add_word: invalid word. A word consists of undercores and/or alphanumeric characters, and valid variable prefixes/postfixes.

query_sql "INSERT INTO `redeembetalog` (`code`, `item_amount`,`name`, `time`) VALUES ('"+@voucher_code$+"', '"+@amt+"', '"+strcharinfo(0)+"',  '"+gettimestr("%Y-%m/%d %H:%M:%S",21);+"')";

 

query_sql ("INSERT INTO `redeembetalog` (`code`, `item_amount`,`name`, `time`) VALUES ('"+escape_sql(@voucher_code$)+"', '"+@amt+"', '"+strcharinfo(0)+"', NOW())");

Store your data like above.

Then whenever you pull the data, format them first before showing to the npc.

Edited August 30, 2020 by Patskie