kick and delete through script

[Hanashi]

how to kick any online character of a certain account and delete the kicked account?

[Neffletics]

-	script	KickDelete	-1,{
OnKick:
		mes "[ Kick Delete NPC ]";
		mes "I'll kick the user and delete his account";
		next;
	Inputing:
		mes "Enter the character ID";
		input .@ign$;
		next;
		mes "Enter the account ID";
		input .@account$;
		if (.@ign$ != 0 ) {
			mes "[ Kick Delete NPC ]";
			mes "You didnt' enter the character ID!";
			next;
			goto Inputing;
		} if (.@account$ != 0 ) {
			mes "[ Kick Delete NPC ]";
			mes "You didn't enter an account ID";
			next;
			goto Inputing;		
		} else {
			mes "[ Kick Delete NPC ]";
			mes "Kicking and deleting...";
			atcommand "@kick" +@ign$+ "";
			query_sql "DELETE FROM `login` WHERE `account_id` = " +.@account$+ "";
			end;
		}
}

Disclaimer: This is not tested (written on phone) and has no validations but this will give you an idea. Good luck!

[Emistry]

maybe you can give this a try...

https://pastebin.com/JK3KPDE2

it clear other data as well ... but still some of these tables aren't suppose to delete data in such way... use at your own risk.

[nitrous]

Why not just ban the account?

[Neffletics]

2 hours ago, Nitrous said:

Why not just ban the account?

I had this question in my mind too. Yea, why not?

[Hanashi]

On 11/29/2016 at 6:13 AM, Nitrous said:

Why not just ban the account?

On 11/29/2016 at 8:39 AM, Neffletics said:

I had this question in my mind too. Yea, why not?

 

banning doesnt clear mysql database which i prefer cleaning it than banning with those useless info stuck on database

[nitrous]

rA doesn't lend itself to deleting data in the database. Deleting unused data won't really show a performance increase.