Jump to content
  • 0

Fix Warning in Script


Azeroth

Question


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  383
  • Reputation:   121
  • Joined:  03/31/12
  • Last Seen:  

Hello, i need some support of this account info system, which lines should i edit and fixed it.

Thank you in Advance!

Suggestion: i would be happy if you guys can add also the names of each characters.

 

Script author: Emistry.

 

Thank you!

 

post-3539-0-75594500-1444047975_thumb.png


prontera.gat,155,156,5    script    Sample    757,{

    if( getgmlevel() < 99 ) end;

        mes "Enter player name ?";

        mes "^FF0000 Min. 4 words.^000000";

        do {

    input .@search$;

        } while( getstrlen( .@search$ ) < 4 );

if( query_sql( "SELECT `account_id`,`name` FROM `char` WHERE `name` LIKE '%"+escape_sql( .@search$ )+"%' GROUP BY `account_id` LIMIT 50",.@id,.@name$ ) ){

    .@size = getarraysize( .@id );

    if( .@size > 1 ){

        mes "^777777==========================^000000";

        mes "Found ^FF0000"+.@size+" Accounts^000000 where it's character's name consist of ";

        mes "\"^FF0000"+.@search$+"^000000 \"";

        .@i = select( implode( .@name$,":" ) ) - 1;

    }

    next;

    if( query_sql( "SELECT * FROM `login` WHERE `account_id`='"+.@id[.@i]+"'",.@id,.@user_id$,.@user_pass$,.@sex$,.@email$,.@group_id,.@state,.@unban_time,.@expiration_time,.@login_count,.@last_login$,.@last_ip$,.@birth_date$ ) ){

        mes "^777777AID : ^FF0000"+.@id+"^000000";

        mes "^777777User ID : ^FF0000"+.@user_id$+"^000000";

        mes "^777777Password : ^FF0000"+.@user_pass$+"^000000";

        mes "^777777Gender : ^FF0000"+.@sex$+"^000000";

        mes "^777777Email : ^FF0000"+.@email$+"^000000";

        mes "^777777Group ID : ^FF0000"+.@group_id+"^000000";

        mes "^777777State : ^FF0000"+.@state+"^000000";

        if( .@unban_time ) mes "^777777UnBan Time : ^FF0000"+.@unban_time+"^000000";

        if( .@expiration_time ) mes "^777777Expire Time : ^FF0000"+.@expiration_time+"^000000";

        mes "^777777Login Count : ^FF0000"+.@login_count+"^000000";

        mes "^777777Last Login : ^FF0000"+.@last_login$+"^000000";

        mes "^777777Last IP : ^FF0000"+.@last_ip$+"^000000";

        mes "^777777Birthdate : ^FF0000"+.@birth_date$+"^000000";

    

        } else{

        mes "No Records found for this account..";

        }

    

    } else{

        mes "No players found with this name.";

    }

close;

}
Link to comment
Share on other sites

3 answers to this question

Recommended Posts


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  


if( query_sql( "SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate` FROM `login` WHERE `account_id`='"+.@id[.@i]+"'",.@id,.@user_id$,.@user_pass$,.@sex$,.@email$,.@group_id,.@state,.@unban_time,.@expiration_time,.@login_count,.@last_login$,.@last_ip$,.@birth_date$ ) ){

Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

  if( query_sql( "SELECT * FROM `login` WHERE `account_id`='"+.@id[.@i]+"'",.@id,.@user_id$,.@user_pass$,.@sex$,.@email$,.@group_id,.@state,.@unban_time,.@expiration_time,.@login_count,.@last_login$,.@last_ip$,.@birth_date$ ) ){

replace the  asterisk ( * )

with all the column name that retrieved from the script. you can based on the variable amount at the end.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  383
  • Reputation:   121
  • Joined:  03/31/12
  • Last Seen:  

  if( query_sql( "SELECT * FROM `login` WHERE `account_id`='"+.@id[.@i]+"'",.@id,.@user_id$,.@user_pass$,.@sex$,.@email$,.@group_id,.@state,.@unban_time,.@expiration_time,.@login_count,.@last_login$,.@last_ip$,.@birth_date$ ) ){

replace the  asterisk ( * )

with all the column name that retrieved from the script. you can based on the variable amount at the end.

 

 

i don't get it, i will replace the ? into this "*"

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...