How to delete inactive accounts?

[Anime s2]

How  to delete players accounts if player is not active for almost 11 months?

[Emistry]

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.

[Emistry]

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 );

 

[Musika6988]

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