Share AUTOCREATE? NO PROBLEM!

[Carvalho123456]

(I am Brazilian and I used Google Translate to make this publication.
so, if I couldn't understand, I beg your pardon. Whoever understands, I hope you like it)

 

Well, I see that a lot of people use autocreate on their servers

this causes an excess of players who make mistakes when logging in and ends up creating a new account

when he realizes that he didn’t log in to his account, he relogs and logs in correctly

but with that the account is still in the database

 

I don't know anything about sql, and I managed to make a command that compares if the account has a char created

if not, the account is deleted

 

DELETE FROM accounts WHERE login NOT IN (SELECT account_name FROM characters);

 

with that you can create a Query in your Navicat for this command to be saved

or better, automate it with Navicat's own Schedule and place it for this command to be executed

daily, weekly, or as many times as you want

and together with this command, you can also use ...

the one that will identify if the player has more than 3 months without logging in and deleting the char

DELETE FROM characters WHERE lastAccess < 466560000;

 

Tutorial: How to let auto commands run in navicat

 

1- Click on Quary

2-Paste the command in the Query Editor tab and click on Save As

3-Type a name for your query and you can close the quary

4-Click on Schedule

5-New Batch Job

6-Locate the file you just saved and double click

7-it goes to the bottom

8-click Save As and enter a name for your Job

9-Close the Schedule

10-Click on your job, still on the Schedule tab

11-Set Task Schedule

12-Set password, and type your computer's admin password and click Apply

"For Navicat to execute Schedule functions automatically, it is necessary that Windows has an admin password, otherwise it will not release"

13-Click on the Agenda tab

14-Click New

15- And select the best type of schedule for you and set the time and OK

NEVER YOUR DATABASE WILL BE FILLED WITH ACCOUNTS THAT ARE NOT USED

 

Credits: myself

[HyperBlown]

Your code has some huge failure rate. 
If an character gets deleted, Most of the time other tables wont delete with it. (Not all tables are linked). So it might happen that the item table of that character are still there. And if a new character gets created, and somehow it gets the objectId of the deleted character, it will have the same itens and skill from that deleted character.... U might need a bigger delete list mate

Edited April 10, 2021 by HyperBlown

[An4rchy]

7 hours ago, HyperBlown said:

Your code has some huge failure rate. 
If an character gets deleted, Most of the time other tables wont delete with it. (Not all tables are linked). So it might happen that the item table of that character are still there. And if a new character gets created, and somehow it gets the objectId of the deleted character, it will have the same itens and skill from that deleted character.... U might need a bigger delete list mate

aCis takes care of that if I remember correctly, in IdFactory.

[HyperBlown]

6 hours ago, An4rchy said:

aCis takes care of that if I remember correctly, in IdFactory.

Oh damn really? Didnt knew. I'm sure many of the others doesn't have this feature. 

 

[Carvalho123456]

On 09/04/2021 at 22:58, HyperBlown said:

Seu código tem uma taxa de falha enorme. 
Se um caractere for excluído, na maioria das vezes as outras tabelas não serão excluídas com ele. (Nem todas as tabelas estão vinculadas). Portanto, pode acontecer que a tabela de itens desse personagem ainda esteja lá. E se um novo personagem for criado, e de alguma forma ele obtiver o objectId do personagem excluído, ele terá os mesmos itens e habilidades daquele personagem excluído .... Você pode precisar de um companheiro de lista de exclusão maior 😉">

again, google translator, hope you understand

but items are not linked to obj_id?
and when the player deletes the character, the items are also not deleted?
and even if the player deletes the character and I delete the account, and the player creates the account with the same name including the character, will the obj_id not be different?