filippos1234 6 Posted November 8, 2019 Share Posted November 8, 2019 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 Link to comment Share on other sites More sharing options...
Premium Syreldar 1875 Posted November 8, 2019 Premium Share Posted November 8, 2019 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. "Nothing's free in this life. Ignorant people have an obligation to make up for their ignorance by paying those who help them. Either you got the brains or cash, if you lack both you're useless." Syreldar Link to comment Share on other sites More sharing options...
filippos1234 6 Posted November 8, 2019 Author Share Posted November 8, 2019 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 Link to comment Share on other sites More sharing options...
Premium Syreldar 1875 Posted November 9, 2019 Premium Share Posted November 9, 2019 DELETE FROM `player.item` WHERE `owner_id` = ID_OF_THE_BANNED_PLAYER; "Nothing's free in this life. Ignorant people have an obligation to make up for their ignorance by paying those who help them. Either you got the brains or cash, if you lack both you're useless." Syreldar Link to comment Share on other sites More sharing options...
filippos1234 6 Posted November 9, 2019 Author Share Posted November 9, 2019 i fixed it thanks..i just cleared player>item table Link to comment Share on other sites More sharing options...
Premium Syreldar 1875 Posted November 9, 2019 Premium Share Posted November 9, 2019 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. 2 "Nothing's free in this life. Ignorant people have an obligation to make up for their ignorance by paying those who help them. Either you got the brains or cash, if you lack both you're useless." Syreldar Link to comment Share on other sites More sharing options...
filippos1234 6 Posted November 9, 2019 Author Share Posted November 9, 2019 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now