Carvalho123456 Posted April 9, 2021 Share Posted April 9, 2021 (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 Quote Link to comment Share on other sites More sharing options...
HyperBlown Posted April 10, 2021 Share Posted April 10, 2021 (edited) 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 Quote Link to comment Share on other sites More sharing options...
An4rchy Posted April 10, 2021 Share Posted April 10, 2021 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. 1 Quote Link to comment Share on other sites More sharing options...
HyperBlown Posted April 10, 2021 Share Posted April 10, 2021 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. Quote Link to comment Share on other sites More sharing options...
Carvalho123456 Posted April 11, 2021 Author Share Posted April 11, 2021 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? Quote Link to comment Share on other sites More sharing options...
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.