I have an odd issue, which I think relates to an SQL query but I'm not sure. A while ago, I ran an sql statement to cleanup untouched items in the Object table after 60 days.
It deleted a load of things which was great to clean up the server, but it now seems that player bases are asking for maintenance payments and then the walls and things are disappearing.
In the Hive.ext the cleanupafterdays=-1 so this should mean that nothing gets deleted right?
So my thinking is that the SQL I have used is now running all the time and deleting player bases. So my question is how do I see the sql statements that are running in order to get rid of them?
Question
ahughes3
Hey folks,
I have an odd issue, which I think relates to an SQL query but I'm not sure. A while ago, I ran an sql statement to cleanup untouched items in the Object table after 60 days.
It deleted a load of things which was great to clean up the server, but it now seems that player bases are asking for maintenance payments and then the walls and things are disappearing.
In the Hive.ext the cleanupafterdays=-1 so this should mean that nothing gets deleted right?
So my thinking is that the SQL I have used is now running all the time and deleting player bases. So my question is how do I see the sql statements that are running in order to get rid of them?
I have Navicat if that's of any use?
Any help would be greatly appreciated.
Link to comment
Share on other sites
2 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