fireicesurfer Posted May 5, 2020 Posted May 5, 2020 Hi! noob question.. How to search for player IP using player name in mysql? Quote
0 chatterboy Posted May 5, 2020 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
0 fireicesurfer Posted May 5, 2020 Author 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
0 chatterboy Posted May 6, 2020 Posted May 6, 2020 4 hours ago, fireicesurfer said: thanks youre the best no prob ^_^ we all need help from other sometimes Quote
Question
fireicesurfer
Hi! noob question..
How to search for player IP using player name in mysql?
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.