Username Searcher

[caspa]

can i ask an npc where if i put the player name it would give me his account's info like email,password,username and the list of character on that account?

[Emistry]

like this ?

http://pastebin.com/raw.php?i=KpFkcTmD

[caspa]

Sir Em... it's the script i need but im getting the SQL errors.... how do i solve it?

 

like this ?

http://pastebin.com/raw.php?i=KpFkcTmD

Edited February 18, 2013 by caspa

[Emistry]

work fine for me .... i using rAthena 17049...

based on the SQL file here

trunk/sql-files/main.sql ( login table )

 

i think your login table and above login table might be different....

double check it....

else..show your login table structure..

 

or edit this part ..

	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";
	

[Capuche]

or like this ? (lol)

prontera,159,180,5	script	hjkl	456,{
	input .@name$;
	atcommand "@accinfo "+ .@name$;
	close;
}

Edited February 18, 2013 by Capuche

[xmaniacx]

work fine for me .... i using rAthena 17049...

based on the SQL file here

trunk/sql-files/main.sql ( login table )

 

i think your login table and above login table might be different....

double check it....

else..show your login table structure..

 

or edit this part ..

	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";
	

I'm using this script and i'm also getting the sql errror, does this error have a major effect on the server if its ignored? and used the script anyways?

Edited February 19, 2013 by xmaniacx

[caspa]

tried this one today.......... [ SOLVED ]

[Brian]

work fine for me .... i using rAthena 17049...

based on the SQL file here trunk/sql-files/main.sql ( login table )

 

i think your login table and above login table might be different....

 

When working with SQL, it's a good practice to specify all the column names you are selecting. Then you can be 100% sure your query will return the columns you expect, in the order you expect.

I avoid using SELECT * in scripts.