I there i have this problem with chas shop in the beta 19 of S3 E2
this is table t_perioditem_info
when i buy a SEAL put this info, when i disconnect and reconnect Seal desapear.
i found the problem:
memb_guid memb__char ItemCode OptionType ItemEffect1 ItemEffect2 UseTime ExpireDate
15 pejota 6699 0 6 0 8635 08/14/2009 20:13:00
so i change the expiredate to dd/mm/aaaa and then reconnect and the seal apear and with the time resting for expired
15 pejota 6699 0 6 0 8635 14/08/2009 20:13:00
i like to know how to make a query for this, to change the format of datetime, when its safe.
sorry my english
this is table t_perioditem_info
when i buy a SEAL put this info, when i disconnect and reconnect Seal desapear.
i found the problem:
memb_guid memb__char ItemCode OptionType ItemEffect1 ItemEffect2 UseTime ExpireDate
15 pejota 6699 0 6 0 8635 08/14/2009 20:13:00
so i change the expiredate to dd/mm/aaaa and then reconnect and the seal apear and with the time resting for expired
15 pejota 6699 0 6 0 8635 14/08/2009 20:13:00
i like to know how to make a query for this, to change the format of datetime, when its safe.
sorry my english