TreXeh

Deleting a player from the DB

9 posts in this topic

Hi all, have a problem with a dead player,

Soultion is  DELETE FROM `player` WHERE `is_alive` = 1 AND `damage` = 1 from a post from Flow

However so new to SQL not quite sure how to go about it, could any one point me in the right direction to some resources where to look.

Staring at the SQL workbench just a bit lost only thing i am sure of is not to select "Drop Tables" ha! 


Regards


TreXeh

Share this post


Link to post
Share on other sites
7 minutes ago, TreXeh said:

Hi all, have a problem with a dead player,

Soultion is  DELETE FROM `player` WHERE `is_alive` = 1 AND `damage` = 1 from a post from Flow

However so new to SQL not quite sure how to go about it, could any one point me in the right direction to some resources where to look.

Staring at the SQL workbench just a bit lost only thing i am sure of is not to select "Drop Tables" ha! 


Regards


TreXeh

I had the very same issue yesterday, the specific player actually had two alive bodies in the sql so I had to completely remove them both to solve the issue. If you are lost in the workbench at least you didnt drop the tables LOL. When you open the sql in the workbench there is a drop down menu GUI you can use to show, ( players, vehicles, territory and such ) . When you select on one of those you right click it and show rows 1-100 then use the next window to sort by name or UID or what ever  your fancy is to find the particular player. You can then select the ROW the player is located in , right click and delete that LINE. If this dosen't help solve your issue feel free to message me here

Share this post


Link to post
Share on other sites
Advertisement

Hey thanks for the reply!

 

So I'm in workbench and gone Exile>Tables>Player>Columns>Name*Select row - Limit 1000 

When I right click on the player in question the delete rows is greyed out and only have the copy fields able to be selected

Am I in the wrong part? 

Share this post


Link to post
Share on other sites

I just look at the data in HeidiSQL, find the affected row, right click and delete the row.

Share this post


Link to post
Share on other sites

^^ Spartans method will fix your issue, any issues faced with character deletion should be resolved using it. Its perfect for character reset etc in the case of a glitched player.

1 person likes this

Share this post


Link to post
Share on other sites
1 hour ago, Spartan said:

I just look at the data in HeidiSQL, find the affected row, right click and delete the row.

 

1 hour ago, TheCoon said:

^^ Spartans method will fix your issue, any issues faced with character deletion should be resolved using it. Its perfect for character reset etc in the case of a glitched player.

 

2 hours ago, |DG|SixKado said:

I had the very same issue yesterday, the specific player actually had two alive bodies in the sql so I had to completely remove them both to solve the issue. If you are lost in the workbench at least you didnt drop the tables LOL. When you open the sql in the workbench there is a drop down menu GUI you can use to show, ( players, vehicles, territory and such ) . When you select on one of those you right click it and show rows 1-100 then use the next window to sort by name or UID or what ever  your fancy is to find the particular player. You can then select the ROW the player is located in , right click and delete that LINE. If this dosen't help solve your issue feel free to message me here

 


Thanks guys Hedi over SQL workbench and delete from accounts and player tables 


Cheers again!

Share this post


Link to post
Share on other sites

Posted (edited)

im lost.....

when i go:

Navicat for MySql:

Exile>Tables>account> there is no any info showed , everything just (NULL),(NULL),(NULL),(NULL).

in MySql:

Exile>Tables>"RightClick" Select Rows - Limit 1000 no any info (accunt,clan,player , etc) everywhere just (NULL),(NULL),(NULL),(NULL),

what im doing wrong ? i want to perform server wipe

Anywhere else could be player data stored ?

Thanks!

 

Edited by fau5tz

Share this post


Link to post
Share on other sites

Posted (edited)

bump...

 

NVM... sorted i guess

Edited by fau5tz

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.