Blue Jem Posted May 31, 2014 Group: Members Topic Count: 151 Topics Per Day: 0.04 Content Count: 393 Reputation: 3 Joined: 09/16/13 Last Seen: June 4, 2014 Share Posted May 31, 2014 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: Quote Link to comment Share on other sites More sharing options...
Capuche Posted May 31, 2014 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 616 Joined: 07/05/12 Last Seen: March 20 Share Posted May 31, 2014 doc/atcommands.txt#L548 Quote Link to comment Share on other sites More sharing options...
Blue Jem Posted June 2, 2014 Group: Members Topic Count: 151 Topics Per Day: 0.04 Content Count: 393 Reputation: 3 Joined: 09/16/13 Last Seen: June 4, 2014 Author Share Posted June 2, 2014 on eathena svn there are no @accinfo command i want to manual type Quote Link to comment Share on other sites More sharing options...
Capuche Posted June 2, 2014 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 616 Joined: 07/05/12 Last Seen: March 20 Share Posted June 2, 2014 - 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) Quote Link to comment Share on other sites More sharing options...
Blue Jem Posted June 3, 2014 Group: Members Topic Count: 151 Topics Per Day: 0.04 Content Count: 393 Reputation: 3 Joined: 09/16/13 Last Seen: June 4, 2014 Author Share Posted June 3, 2014 i try i wish master this script is working to eathena Quote Link to comment Share on other sites More sharing options...
Capuche Posted June 3, 2014 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 616 Joined: 07/05/12 Last Seen: March 20 Share Posted June 3, 2014 i didn't test it on eathena but it should work on Quote Link to comment Share on other sites More sharing options...
Blue Jem Posted June 4, 2014 Group: Members Topic Count: 151 Topics Per Day: 0.04 Content Count: 393 Reputation: 3 Joined: 09/16/13 Last Seen: June 4, 2014 Author Share Posted June 4, 2014 yea is working thx for this help and the script Quote Link to comment Share on other sites More sharing options...
Question
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:
Link to comment
Share on other sites
6 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.