[Release] Delete Characters (CoEmu v2)

[LetterX]

Note: This will need to be changed a little bit if warehouse passwords are implemented.

Step 1: Go to CoEmu v2 GameServer -> Database -> Database.cs. Under the static int NewCharacter, put:

        public static void DeleteCharacter(int CharID) //LetterX Codes
        {
            MySqlCommand Cmd = new MySqlCommand("DELETE from `characters` WHERE `CharID` = " + CharID + "", DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Dispose();
            MySqlCommand Cmd2 = new MySqlCommand("DELETE from `items` WHERE `CharID` = " + CharID + "", DatabaseConnection.NewConnection());
            Cmd2.ExecuteNonQuery();
            Cmd2.Connection.Close();
            Cmd2.Dispose();
            MySqlCommand Cmd3 = new MySqlCommand("DELETE from `prof` WHERE `CharID` = " + CharID + "", DatabaseConnection.NewConnection());
            Cmd3.ExecuteNonQuery();
            Cmd3.Connection.Close();
            Cmd3.Dispose();
            MySqlCommand Cmd4 = new MySqlCommand("DELETE from `skills` WHERE `CharID` = " + CharID + "", DatabaseConnection.NewConnection());
            Cmd4.ExecuteNonQuery();
            Cmd4.Connection.Close();
            Cmd4.Dispose();
            MySqlCommand Cmd5 = new MySqlCommand("DELETE from `ignored` WHERE `CharID` = " + CharID + "", DatabaseConnection.NewConnection());
            Cmd5.ExecuteNonQuery();
            Cmd5.Connection.Close();
            Cmd5.Dispose();
        }

(Database function for deleting the row / character & the items associated with the character)

Step 2: Go to PacketProcessor.cs -> case 1010 (packet 0x3f2). Above case 97: //Confirm Guild, put this:

                                case 95: //Delete Character (LetterX Codes)
                                    {
                                        CSocket.Disconnect();
                                        Database.Database.DeleteCharacter(CSocket.Client.ID);
                                        
                                        break;
                                    }

(This is where the server comprehends the client's request and then disconnects and deletes the character).

So if you don't how to do it, all you do is when logged in, go to Options -> Delete and then click 'Okay', insert a ZERO (" 0 ") into the box, and then click "Okay" again and your character and items are completely deleted.

That's pretty much it. =d

edit: scottdavey found I forgot to delete character items. *Fixed*
edit2: Forgot to delete Skills and Profs *Fixed*

[scottdavey]

You need to delete all the items that are associated with that UID also, pretty cool though.

[LetterX]

Originally Posted by scottdavey

You need to delete all the items that are associated with that UID also, pretty cool though.

Completely forgot about that. Used to LOTF's way of putting everything in the character table. ;D

edit: Fixed. Thank you for pointing out the error.

[scottdavey]

Nice work, you need to delete from Ignored too though.

[LetterX]

Originally Posted by scottdavey

Nice work, you need to delete from Ignored too though.

I'll add it in, but I searched in the source and nothing loads or uses the 'Ignored' table right now. xD

[scottdavey]

Originally Posted by LetterX

I'll add it in, but I searched in the source and nothing loads or uses the 'Ignored' table right now. xD

Better to be safe than sorry :P