Delete character Script.

[Venture]

Is there any way to delete character with an NPC script?

 

something like

 

delchar <Char ID>;

[Skorm]

Right there are actually quite a few different tables to clear relating to characters.

 

http://rathena.org/board/topic/84590-how-to-delete-account-using-sql-if-they-are-not-active/?hl=%2Bdelete+%2Baccount

 

If you just delete the character from `char` you'd be leaving a whole mess of stuff behind.

[sandbox]

prontera,100,200,4	script	delete	46,{

mes "Input char to delete";
input .@char$;
if(getcharid(3,.@char$)) atcommand "@kick "+.@char$;
query_sql("DELETE FROM `char` WHERE `char_id`='"+getcharid(3,.@char$)+"'");
close;

}

There has been a thread like this before, which we discussed that you should keep in mind that other tables contain data from player too, inventory, party, guild, etc.

[Venture]

Right there are actually quite a few different tables to clear relating to characters.

 

http://rathena.org/board/topic/84590-how-to-delete-account-using-sql-if-they-are-not-active/?hl=%2Bdelete+%2Baccount

 

If you just delete the character from `char` you'd be leaving a whole mess of stuff behind.

That works, thanks!