How to search for player IP using player name in mysql?

[fireicesurfer 3]

Hi! noob question..

How to search for player IP using player name in mysql?

[chatterboy 21]

2 hours ago, fireicesurfer said:

Hi! noob question..

How to search for player IP using player name in mysql?

-	script	account	-1,{

OnInit: // Auto Initialize when the server is Online
	bindatcmd "acc",strnpcinfo(3)+"::OnWhisperGlobal",99,0; // GM Level can only access this wispher
	end;
	
OnWhisperGlobal:

					switch(select("~ Cheack Player Info:~ Quit")){
						
						
			case 1:
					mes "---[SYSTEM]---";
					mes "Type the User Name";
					mes "you wish to check";		
					input .@charName$;
					next;
					// Fetch the player account ID
					.@size = query_sql ("SELECT `account_id` FROM char WHERE `name` = '"+.@charName$+"';",.@acc_id);
					
					if(!.@size){
					mes "---[SYSTEM]---";
					mes "Info:";
					mes " ERROR 404 Player "+.@charName$+" is not found...";
					close;}
					
					// Fetch information of the Player IGN  input ^_^
					query_sql "SELECT `userid`, `last_ip`, `email` FROM login WHERE `account_id` = '"+.@acc_id+"';",.@user_id$,.@lastIp,.@emai$;
					
					
					// Visual Ingame....
					mes "---[SYSTEM]---";
					mes "AccID: "+.@acc_id+"";
					mes "UserID: "+.@user_id$+"";
					mes "LastIP: "+.@lastIp+"":
					mes "Email: "+.@emai$+"";
					mes "Verifying Successful!!!";
					close;
					
					
			case 2:
			close;
			
}					

           

Edited May 5 by chatterboy

[fireicesurfer 3]

22 minutes ago, chatterboy said:

-	script	account	-1,{

OnInit: // Auto Initialize when the server is Online
	bindatcmd "acc",strnpcinfo(3)+"::OnWhisperGlobal",99,0; // GM Level can only access this wispher
	end;
	
OnWhisperGlobal:

					switch(select("~ Cheack Player Info:~ Quit")){
						
						
			case 1:
					mes "---[SYSTEM]---";
					mes "Type the User Name";
					mes "you wish to check";		
					input .@charName$;
					next;
					// Fetch the player account ID
					.@size = query_sql ("SELECT `account_id` FROM char WHERE `name` = '"+.@charName$+"';",.@acc_id);
					
					if(!.@size){
					mes "---[SYSTEM]---";
					mes "Info:";
					mes " ERROR 404 Player "+.@charName$+" is not found...";
					close;}
					
					// Fetch information of the Player IGN  input ^_^
					query_sql "SELECT `userid`, `last_ip`, `email` FROM login WHERE `account_id` = '"+.@acc_id+"';",.@user_id$,.@lastIp,.@emai$;
					
					
					// Visual Ingame....
					mes "---[SYSTEM]---";
					mes "AccID: "+.@acc_id+"";
					mes "UserID: "+.@user_id$+"";
					mes "LastIP: "+.@lastIp+"":
					mes "Email: "+.@emai$+"";
					mes "Verifying Successful!!!";
					close;
					
					
			case 2:
			close;
			
}					

           

thanks youre the best

 

[chatterboy 21]

4 hours ago, fireicesurfer said:

thanks youre the best

 

no prob ^_^ we all need help from other sometimes