fireicesurfer Posted May 5, 2020 Share Posted May 5, 2020 Hi! noob question.. How to search for player IP using player name in mysql? Quote Link to comment Share on other sites More sharing options...
0 chatterboy Posted May 5, 2020 Share Posted May 5, 2020 (edited) 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, 2020 by chatterboy 1 Quote Link to comment Share on other sites More sharing options...
0 fireicesurfer Posted May 5, 2020 Author Share Posted May 5, 2020 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 Quote Link to comment Share on other sites More sharing options...
0 chatterboy Posted May 6, 2020 Share Posted May 6, 2020 4 hours ago, fireicesurfer said: thanks youre the best no prob ^_^ we all need help from other sometimes Quote Link to comment Share on other sites More sharing options...
Hi! noob question..
How to search for player IP using player name in mysql?
Link to comment
Share on other sites