Anime s2 Posted November 24, 2016 Group: Members Topic Count: 25 Topics Per Day: 0.01 Content Count: 68 Reputation: 6 Joined: 11/29/13 Last Seen: June 13, 2022 Share Posted November 24, 2016 How to delete players accounts if player is not active for almost 11 months? Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted December 23, 2016 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10013 Reputation: 2347 Joined: 10/28/11 Last Seen: April 6 Share Posted December 23, 2016 I got this old script that I write about 2~3 years ago... you can give it a try.. https://pastebin.com/cxdvX05K You may probably need to double check the list for account id table and char id table to delete all inactive records. Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted December 23, 2016 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10013 Reputation: 2347 Joined: 10/28/11 Last Seen: April 6 Share Posted December 23, 2016 query_sql( "SELECT `account_id` FROM `login` WHERE DATEDIFF( NOW(),`lastlogin` ) > 30 )",.@aid ); to query_sql( "SELECT `account_id` FROM `login` WHERE DATEDIFF( NOW(),`lastlogin` ) > 90 )",.@aid ); Quote Link to comment Share on other sites More sharing options...
0 Musika6988 Posted April 20, 2018 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 53 Reputation: 6 Joined: 09/09/13 Last Seen: April 5, 2023 Share Posted April 20, 2018 On 12/23/2016 at 12:14 AM, Emistry said: I got this old script that I write about 2~3 years ago... you can give it a try.. https://pastebin.com/cxdvX05K You may probably need to double check the list for account id table and char id table to delete all inactive records. Hi Ems, I'm having this error. Can you please help me resolve this? 1.bmp Quote Link to comment Share on other sites More sharing options...
Question
Anime s2
How to delete players accounts if player is not active for almost 11 months?
Link to comment
Share on other sites
3 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.