Gooober Posted December 20, 2013 Report Share Posted December 20, 2013 What would happen if I deleted my Player_login data? I've noticed mine is up to 637 pages at 30 items per page. or is there another way to maintain this part of the database. Link to comment Share on other sites More sharing options...
0 cen Posted December 20, 2013 Report Share Posted December 20, 2013 nothing, I clear mine out every restart. Link to comment Share on other sites More sharing options...
0 Gooober Posted December 20, 2013 Author Report Share Posted December 20, 2013 Thanks. Just trying to keep database clean. How long do you keep players character data? I have been deleting anyone that has not log'd in for 40 dayz. Link to comment Share on other sites More sharing options...
0 cen Posted December 20, 2013 Report Share Posted December 20, 2013 I run this every restart: delete FROM `character_data` USING character_data, character_data AS tmpcharacter_data WHERE NOT character_data.CharacterID=tmpcharacter_data.CharacterID AND character_data.CharacterID<tmpcharacter_data.CharacterID AND (character_data.PlayerUID=tmpcharacter_data.PlayerUID) Link to comment Share on other sites More sharing options...
Question
Gooober
What would happen if I deleted my Player_login data? I've noticed mine is up to 637 pages at 30 items per page. or is there another way to maintain this part of the database.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now