So I am trying to create a /whois command that does the following:
You type '/whois character Sean_Johnson' for example.
As a result, you get this string/msgbox:
SQLID: 10
Account: Stefhan
Characters: Sean_Johnson, Carl_Johnson, Kendl_Johnson
CHRIDS: 40, 41, 49
Level: 10, 5, 8
However, the info required is in two seperate tables (accounts & characters), which is where I get stuck. I simply don't know how to proceed. Can anyone guide me further? What is an?efficient way to do this??Am I even doing it right? I appreciate the assistance.
CMD:whois(playerid, params[])
{
? ? if(Account >= 2)
? ? {
? ? ? ? new subcmd, scmd_params;
? ? ? ? if(sscanf(params, "sS()",subcmd, scmd_params))
? ? ? ? ? ? return SendClientMessage(playerid, COLOR_INFO, "/whois ");
? ? ? ? // whois character subcmd
? ? ? ? if(strmatch(subcmd, "character"))
? ? ? ? {
? ? ? ? ? ? new target, str;
? ? ? ? ? ? if(sscanf(params, "ss",subcmd, target))
? ? ? ? ? ? ? ? return SendClientMessage(playerid, COLOR_INFO, "/whois character ");
? ? ? ? ? ? new query;
? ? ? ? ? ? mysql_format(MHRP_SQL, query, sizeof(query), "SELECT SQLID FROM characters WHERE CharName = '%e'",target);
? ? ? ? ? ? mysql_tquery(MHRP_SQL, query, "OnWhoIsCharacter", "is", playerid, target);
? ? ? ? }
? ? ? ? // whois chrid subcmd
? ? ? ? if(strmatch(subcmd, "chrid"))
? ? ? ? {
? ? ? ? }
? ? ? ? // whois account subcmd
? ? ? ? if(strmatch(subcmd, "account"))
? ? ? ? {
? ? ? ? ? ??
? ? ? ? }
? ? ? ? // whois sqlid subcmd
? ? ? ? if(strmatch(subcmd, "sqlid"))
? ? ? ? {
? ? ? ? ? ??
? ? ? ? }
? ? ? ? // if no strmatch
? ? ? ? else return SendClientMessage(playerid, COLOR_ERROR, "That subcommand does not exist.");
? ? }
? ? else return SendClientMessage(playerid,COLOR_ERROR,"You do not have the required access to execute this command.");
? ? return 1;
}
forward OnWhoIsCharacter(playerid, target[]);
public OnWhoIsCharacter(playerid, target[])
{
? ? if(cache_num_rows() != 1)
? ? ? ? return SendClientMessage(playerid, COLOR_ERROR, "That character does not exist.");
? ? new targetid;
? ? cache_get_value_name_int(0, "SQLID", targetid);
? ? mysql_format(MHRP_SQL, query, sizeof(query), "SELECT CHRID, CharName, Level FROM characters WHERE SQLID = %d LIMIT 3", targetid);
? ? mysql_tquery(MHRP_SQL, query, "OnWhoIsCharacterProcess", "ii", playerid, targetid);
? ? return 1;
}
forward OnWhoIsCharacterProcess(playerid, targetid);
public OnWhoIsCharacterProcess(playerid, targetid)
{
? ? new str, C_ID, C_Name, C_LVL;
? ? for( new id = 0; id < cache_num_rows(); id)
? ? {
? ? ? ? cache_get_value_name_int(id, "CHRID", C_ID);
? ? ? ? cache_get_value_name(id, "CharName", C_Name);
? ? ? ? cache_get_value_name_int(id, "Level", C_LVL);
? ? ? ? format(str, sizeof(str), "%d %s %d\n", C_ID, C_Name, C_LVL);
? ? ? ? SendClientMessage(playerid, str);
? ? }
? ? new query;
? ? mysql_format(MHRP_SQL, query, sizeof(query), "SELECT Username FROM accounts WHERE SQLID = %d", targetid);
? ? mysql_tquery(MHRP_SQL, query);
? ? new A_Name;
? ? cache_get_value_name(0, "Username", A_Name);
? ? return 1;
}