Modern account website character deletion

[Killzon32]

I know this probably been asked a couple of times I tried searching without finding an answer.
But people can't delete characters off the modern acc website I am wondering how you fix this bug.... If this is a easy fix then Accept my free rep by answering it :3

 

[Liikuid]

Follow the next steps:

1.- Create Account
2.- Create a Character
3.- Try Login in your OT
4.- Now, go to your Page and delete it (Character).
5.- Now, try login in your OT

What happened? this function won't delete your character from the database, this function deactivated your character and this works how a deletion no permanent.

 

[Killzon32]

I click on x button on website it says do you want to delete it I click yes, and it does nothing and its still there, It deletes it in game but not on website.

 

[Killzon32]

bump

 

[Killzon32]

bump

 

[Killzon32]

bump? No one knows how to fix this problem D:?

 

[Znote]

You need to update the SQL query, and verify that the player is offline before deleting it.

This is very simplified, but some logic like this:

<?php
$query = "SELECT online FROM players WHERE name='%s'", mysql_real_escape_string($charname);
if ($query == 0){ // If player is offline
$query = "DELETE FROM players WHERE name='%s'", mysql_real_escape_string($charname);
mysql_query($query);
} else {
echo 'Character must be offline before deleting!';
}
?>

You have to figure out how modern aac does this, and change the behavior to slightly mimic my sample.

 

[Killzon32]

You need to update the SQL query, and verify that the player is offline before deleting it.

This is very simplified, but some logic like this:

<?php
$query = "SELECT online FROM players WHERE name='%s'", mysql_real_escape_string($charname);
if ($query == 0){ // If player is offline
$query = "DELETE FROM players WHERE name='%s'", mysql_real_escape_string($charname);
mysql_query($query);
} else {
echo 'Character must be offline before deleting!';
}
?>

You have to figure out how modern aac does this, and change the behavior to slightly mimic my sample.

 

[Killzon32]

bump

 

[City]

You want to hide the character that is disabled (aka deleted) in the account panel or delete it completely?

 

[Killzon32]

delete it completely

 

[City]

Ok I cant really help much but I can tell you what lines to modify but together with zNote's code it should work if you have a clue about php (which I dont).

// system/application/controllers/account.php - line 458
$this->account_model->deletePlayer($id); // change this line

// system\application\libraries\POT/OTS_players_list
//change line 26 -- change it so it deletes the whole table. I tried but couldnt figure out how to do it myself

//function deletePlayer

public function deletePlayer(OTS_Player $player)
    {
        $this->db->query('DELETE FROM ' . $this->db->tableName('players') . ' WHERE ' . $this->db->fieldName('id') . ' = ' . $player->getId() );
    }

 

[Killzon32]

where do i put znotes code?

 

[City]

you cant just throw them in there but in

system\application\libraries\POT/OTS_players_list - line 26

system/application/controllers/account.php - line 458

 

[Killzon32]

Do I put your script or his? I tried doing what urs said but it did not fix problem, x,x

 

[City]

You have to change the line 26 in system\application\libraries\POT/OTS_players_list to delete the selected character's table in 'players'

 

[Killzon32]

and what would the script be?

 

[Leyla Cullin]

Sorry for pushing. But I got the same problem until 5 minutes ago and im sure i will not be the only one in the future.

Simply go into htdocs\system\application\models\account_model.php and overwrite this function:

    public function deletePlayer($id) {
        $this->db->update('players', array('deleted' => 1), array('id' => $id));
    }

with that one:

    public function deletePlayer($id) {
        $this->db->query("DELETE FROM `players` WHERE `id` = ".$this->db->escape($id)."");
    }

This will DELETE the whole user from your database without making trouble with Modern AAC

Feel loved by me, Leyla.