DB Cleaner

[Dissidia]

A script that can clean never logged in account?

[crazyarashi]

A Simple SQL Query Will Do for deleting an account that hasnt been log in yet

DELETE FROM `login` WHERE `logincount` = 0;

 

Edited September 7, 2017 by crazyarashi

[Chaos92]

DELETE FROM login
WHERE logincount=0;

But I didnt recommend you delete any accounts

[sader1992]

7 minutes ago, Chaos92 said:

DELETE FROM login
WHERE logincount=0;

But I didnt recommend you delete any accounts

there is no problem deleting accounts that didn't login even once

no char or items connected to the account

[Chaos92]

1 minute ago, sader1992 said:

there is no problem deleting accounts that didn't login even once

no char or items connected to the account

login from fluxcp does it count ?
if any account related database for example voteforpoints, freebies, or any other fluxcp addon?

[sader1992]

1 minute ago, Chaos92 said:

login from fluxcp does it count ?
if any account related database for example voteforpoints, freebies, or any other fluxcp addon?

i am not good in web development but let's say it's true

he can also delete all the variables for that account too

and also flux wont give the account id to a new account it <<(i don't know what but that tested in every server i made[not sure if flux side or rathena side])

so even if he didn't delete the variables no one will get them if they made new account cuz they can't get the same id (unless it added in the database manualy)

[Chaos92]

Just now, sader1992 said:

i am not good in web development but let's say it's true

he can also delete all the variables for that account too

and also flux wont give the account id to a new account it <<(i don't know what but that tested in every server i made[not sure if flux side or rathena side])

so even if he didn't delete the variables no one will get them if they made new account cuz they can't get the same id (unless it added in the database manualy)

yeah its true.. but u will have redundancy of data if u didnt check thoroughly  for any other related data to login table. for sure it should work
im just saying, I didnt recommended that.

[Dissidia]

Thank you guys, I'll try it. I will also look for the flux that needs to delete.