Sukkaed

[FIX] 7 digit ExileDatabaseID will break the server

1 post in this topic

As Arma has always had some troubles dealing with 7 digit numbers, this becomes a problem when database ID in player, construction, container or vehicle table reaches a million.

Until someone bothers to add some formatting in Exile before using this number as variable in game, here is database query which will set the id numbers to start from 1 again:

UPDATE construction JOIN (SELECT @number := 0) r SET id = @number:=@number +1;
ALTER TABLE construction AUTO_INCREMENT = 1;

UPDATE container JOIN (SELECT @number := 0) r SET id = @number:=@number +1;
ALTER TABLE container AUTO_INCREMENT = 1;

UPDATE player JOIN (SELECT @number := 0) r SET id = @number:=@number +1;
ALTER TABLE player AUTO_INCREMENT = 1;

UPDATE vehicle JOIN (SELECT @number := 0) r SET id = @number:=@number +1;
ALTER TABLE vehicle AUTO_INCREMENT = 1;

...and stop the server before doing this.

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.