TreXeh 1 Report post Posted December 23, 2015 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
|DG|SixKado 5 Report post Posted December 23, 2015 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
TreXeh 1 Report post Posted December 23, 2015 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
CEN 449 Report post Posted December 23, 2015 since 0.94 there is no more is_alive column. Share this post Link to post Share on other sites
Spartan 85 Report post Posted December 23, 2015 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
TheCoon 21 Report post Posted December 23, 2015 ^^ 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 Share this post Link to post Share on other sites
TreXeh 1 Report post Posted December 23, 2015 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
fau5tz 2 Report post Posted March 30, 2016 (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 March 31, 2016 by fau5tz Share this post Link to post Share on other sites
fau5tz 2 Report post Posted April 2, 2016 (edited) bump... NVM... sorted i guess Edited April 2, 2016 by fau5tz Share this post Link to post Share on other sites
Noughts | hellcase.com 0 Report post Posted July 14, 2017 @fau5tzCould you maybe explain how you did fix it? I am 100% lost i dnt see anything u guys are talking about here are pics of what i am looking at: Share this post Link to post Share on other sites