bumxd 16 Posted January 7, 2016 Share Posted January 7, 2016 (edited) hi,i have problem in account.account in safebox_expire, autoloot_expire who have register before.. have it for 2016 year.. can anybody help and say how i can do it to ex:2050year on accounts who have already 2016..? screen: Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Hik 108 Posted January 7, 2016 Share Posted January 7, 2016 Hello. I'm no expert, but this query will set the date in 2050 on all accounts: UPDATE account.account SET safebox_expire = '2050-01-24 00:00:00'; Link to comment Share on other sites More sharing options...
ondry 333 Posted January 7, 2016 Share Posted January 7, 2016 UPDATE account SET safebox_expire = '2050-12-12 00:00:00', autoloot_expire = '2050-12-12 00:00:00' WHERE safebox_expire LIKE '2016%' Link to comment Share on other sites More sharing options...
Hik 108 Posted January 7, 2016 Share Posted January 7, 2016 warning: incorrect datetime value '2016%' for collum 'safebox_expire' at row 1 Link to comment Share on other sites More sharing options...
Premium MrLibya 554 Posted January 7, 2016 Premium Share Posted January 7, 2016 (edited) Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal If you're going to do something, then do it right. Link to comment Share on other sites More sharing options...
bumxd 16 Posted February 5, 2016 Author Share Posted February 5, 2016 # Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now