Help

[Blue Jem]

can i request about information of the player,

Example: the GM staff Type this account_id 200000 or ETC.....

show all info or detais:

 

Username:

Password:

Email:

Sex:

Last login:

Last Ip:

IP:

[Capuche]

doc/atcommands.txt#L548

[Blue Jem]

on eathena svn there are no @accinfo command

i want to manual type 

[Capuche]

-	script	info	-1,{
OnWhisperGlobal:
	if ( getgmlevel() < 99 ) end;
	set .@value, atoi( @whispervar0$ );
	if ( .@value > 0 ) {// account id/char id ?
		if ( .@value < 150000 ) {
			message strcharinfo(0), "invalid ID. Please enter a char id or an account id";
			end;
		}
		if ( .@value < 2000000 ) {
			set .@string$, "char id";
			query_sql( "select `userid`, `user_pass`, `sex`, `email`, `lastlogin`, `last_ip` from login join `char` on `char`.`account_id` = `login`.`account_id` where `char_id` = "+ @whispervar0$,
				.@userid$, .@user_pass$, .@sex$, .@email$, .@lastlogin$, .@last_ip$ );
		}
		else {
			set .@string$, "account id";
			query_sql( "select `userid`, `user_pass`, `sex`, `email`, `lastlogin`, `last_ip` from login where `account_id` = "+ @whispervar0$,
				.@userid$, .@user_pass$, .@sex$, .@email$, .@lastlogin$, .@last_ip$ );
		}
	}
	else {
		set .@string$, "player";
		query_sql( "select `userid`, `user_pass`, `sex`, `email`, `lastlogin`, `last_ip` from login join `char` on `char`.`account_id` = `login`.`account_id` where `name` = '"+ @whispervar0$ +"'",
			.@userid$, .@user_pass$, .@sex$, .@email$, .@lastlogin$, .@last_ip$ );
	}
	if ( .@userid$ == "" )
		message strcharinfo(0), "player "+ @whispervar0$ +" not found";
	else {
		message strcharinfo(0), "Info about "+ .@string$ +" "+ @whispervar0$ +" :";
		message strcharinfo(0), "Username: "+ .@userid$ +"\n" +
								"Password: "+ .@user_pass$ +"\n" +
								"Email: "+ .@email$ +"\n" +
								"Sex: "+ .@sex$ +"\n" +
								"Last login: "+ .@lastlogin$ +"\n" +
								"Last Ip: "+ .@last_ip$;
	}
	end;
}

whisper the npc info

[npc:info] char id/account id/player name (online or not)

[Blue Jem]

i try i wish master this script is working to eathena

[Capuche]

i didn't test it on eathena but it should work on

[Blue Jem]

yea is working thx for this help and the script