fireicesurfer Posted May 5, 2020 Group: Members Topic Count: 34 Topics Per Day: 0.02 Content Count: 101 Reputation: 3 Joined: 04/15/20 Last Seen: August 21, 2023 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 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 309 Reputation: 26 Joined: 11/26/12 Last Seen: November 22, 2024 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 Group: Members Topic Count: 34 Topics Per Day: 0.02 Content Count: 101 Reputation: 3 Joined: 04/15/20 Last Seen: August 21, 2023 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 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 309 Reputation: 26 Joined: 11/26/12 Last Seen: November 22, 2024 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...
Question
fireicesurfer
Hi! noob question..
How to search for player IP using player name in mysql?
Link to comment
Share on other sites
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.