GolovaRaoul

Base Deleted - get it back?

5 posts in this topic

Yo,

So we were building a huge admin base and we accidently removed the flag. Base despawned on restart. Fuck.

But we noticed this option in Exileserverconfig:

// Remove all deleted items from the database after X days
            permanentlyDeleteTime = 2;

Does this mean we can still get it back?

Thanks for responding :)
GolovaRaoul

Share this post


Link to post
Share on other sites

In the database it should still be there but will have a time and date in the "deleted at" cell. Set that back to NULL and restart the server.

Edited by kuplion
1 person likes this

Share this post


Link to post
Share on other sites
Advertisement
On 22-9-2016 at 9:31 AM, kuplion said:

In the database it should still be there but will have a time and date in the "deleted at" cell. Set that back to NULL and restart the server.

We did this and still no base. Maybe you need to change the date when you did pay your protection money +   "deleted at" cell and Set that back to NULL?

Share this post


Link to post
Share on other sites

 

in MySQL base find you user uid (like 76561198124921036) in player table. change 'last_paid_at' date and UID in query to your needs

UPDATE `territory`
SET `territory`.`deleted_at` = Null, `territory`.`last_paid_at` = '2017-02-16 19:17:09'
where `territory`.`owner_uid` = 76561198124921036;

Then you need ID from table territory, it will be territory_id in next queries:

UPDATE `construction`
SET `deleted_at` = Null
where `construction`.`territory_id` = 5;
UPDATE `container`
SET `container`.`deleted_at` = Null
where `container`.`territory_id` = 5;

Now you need to restart server.

This helped me to restore user base. 

 

3 people like this

Share this post


Link to post
Share on other sites
On 2/18/2017 at 3:37 PM, NIkita Bel said:

 

in MySQL base find you user uid (like 76561198124921036) in player table. change 'last_paid_at' date and UID in query to your needs


UPDATE `territory`
SET `territory`.`deleted_at` = Null, `territory`.`last_paid_at` = '2017-02-16 19:17:09'
where `territory`.`owner_uid` = 76561198124921036;

Then you need ID from table territory, it will be territory_id in next queries:


UPDATE `construction`
SET `deleted_at` = Null
where `construction`.`territory_id` = 5;

UPDATE `container`
SET `container`.`deleted_at` = Null
where `container`.`territory_id` = 5;

Now you need to restart server.

This helped me to restore user base. 

 

Thank you for posting, very helpful!

Share this post


Link to post
Share on other sites
Advertisement

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 account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.