Jump to content

Help players that lost important gear after conversion [SQL]


Donnovan

Recommended Posts

This SQL change the old id with the new id and the new id with the old id, so you have your old character back.

set @oldID = '82888333';
set @newID = '76561197993172434';

update character_data set PlayerUID = concat(@oldID,'_CHANGE') where PlayerUID = @oldID and Alive = 1;
update character_data set PlayerUID = @oldID where PlayerUID = @newID and Alive = 1;
update character_data set PlayerUID = @newID where PlayerUID = concat(@oldID,'_CHANGE') and Alive = 1;
82888333 is the old id

76561197993172434 is the new id

Note the 'Alive=1' condition. If the player was in dead state before the version change, there is nothing to do.

If you want to do it in only one server instance, you need to add the Instance=11 (11, or wathever instance you want to change) condition on the 3 update lines.

To find old id and new id you can use this SQL:

select * from player_data where PlayerName like '%Jones%';
Where Jones is the hint for the nick.

To avoid character steal, you can ask for key itens that was on the old character. To see the itens on the old character, you can use this SQL:

set @oldID = '82888333';
select Inventory, Backpack from character_data where PlayerUID = @oldID and Alive = 1;
82888333 is the old id.

You also can ask for the old player id as a way to avoid steal, but in my few experiences on this most players don't had it.

Link to comment
Share on other sites

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
  • Discord

×
×
  • Create New...