Determine Character Gender for script.

[Xellyehria]

Just a quick question, how can I check the sex of a character if it's offline and in the SQL it's marked as "U" instead of F or M? Is there another way to check a character gender if they are offline? 

TLDR: I need to make a script that can search for a character and determine its info including their sex even if they are offline. 

Edited September 1, 2022 by Xellyehria

[Akkarin]

You can do this in an SQL statement. If it's in an NPC script:

prontera,123,123,5	script	sql_test	123,{
	mes "Input player's char ID";
	input .@charid;
	next;
	query_sql("SELECT `name`, `sex` FROM `char` WHERE `char_id` = '"+ .@charid +" LIMIT 1", .@name$, .@sex$);
	if(getarraysize(.@name$) == 0){
		mes "Unknown Char ID";
	} else {
		mes "Char ID: "+ .@charid;
		mes "Char Name: "+ .@name$[0];
		mes "Char Sex: "+ .@sex$[0];
	}
	close;
}

Untested, but should work.

[Xellyehria]

Thank you for the response, however as I've mentioned, in the SQL  db sex in the server is usually marked as "U" instead of "M" or "F" for most characters and I am not sure how to convert it. For example this is a female character but when i query for sex with the script you gave as example, it show "U" . 
 

 I check in my offline and some character are marked with "F" and "M" but there's also "U".. and in the live server most character has U instead of F or M. So I'm not sure how to determine what is the actual sex of those characters. 

Edited September 1, 2022 by Xellyehria

[Akkarin]

Are you allowing players to create chars outside of the client? Or are you using a client that doesn't support char-specific genders?