Problem with account-players

[filippos1234 7]

hello today i found something by a mistake..i deleted my account .. when i re-created it with same details and login to it i have players with LV0 and no name

what shoud l i do to dissapear those players?

edit:i just realized that warehouse items stay too..

thanks for your time

[Syreldar 2732]

Items, just like everything else that is linked to players and account, do not get removed if you remove the player, they'll still be there, even though linked to a no-longer-existing player (or account in the case of the warehouse).

To make those players disappear you have to remove their definitions inside player_index.

To also remove the items etc. just write a very simple query.

 

[filippos1234 7]

10 hours ago, Syreldar said:

Items, just like everything else that is linked to players and account, do not get removed if you remove the player, they'll still be there, even though linked to a no-longer-existing player (or account in the case of the warehouse).

To make those players disappear you have to remove their definitions inside player_index.

To also remove the items etc. just write a very simple query.

 

Thanks worked for players that was still showing..im not good with this so what query should i write?any example or something

thx

[Syreldar 2732]

 

DELETE FROM `player.item` WHERE `owner_id` = ID_OF_THE_BANNED_PLAYER;

 

[filippos1234 7]

i fixed it thanks..i just cleared player>item table

[Syreldar 2732]

1 hour ago, filippos1234 said:

i fixed it thanks..i just cleared player>item table

But that deleted the items of all the players in the game. lol.

[filippos1234 7]

8 hours ago, Syreldar said:

But that deleted the items of all the players in the game. lol.

i know .. i deleted all accounts sorry i didnt said that