[vassilis]

I am trying to make an AKA(As Known As) command but it doesnt detect IP so when i type /aka it doesnt show any client message.. like AKA: vassilis

mysql_log

Код:

[DEBUG] mysql_format - connection: 1, len: 60, format: "SELECT `Username` from `players` WHERE `IP` = '%s'"
 [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Username` from `players` WHERE `IP` = '
'", callback: "CheckAka", format: "i"
[DEBUG] CMySQLQuery::Execute[CheckAka] - starting query execution
 [DEBUG] CMySQLQuery::Execute[CheckAka] - query was successfully executed within 1.230 milliseconds
[DEBUG] CMySQLResult::CMySQLResult() - constructor called
[DEBUG] Calling callback "CheckAka"..
 [DEBUG] cache_get_data - connection: 1
 [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

Command:

PHP код:

CMD:aka(playerid, params[])
{
    new query[60],pIP[16];
    mysql_format(mysql, query, sizeof(query),"SELECT `Username` from `players` WHERE `IP` = '%s'",  GetPlayerIp(playerid,pIP,sizeof(pIP)));
    
    mysql_tquery(mysql, query, "CheckAka", "i", playerid);
    return 1;
}
function CheckAka(playerid)
{    
    new rows, fields; 
    cache_get_data(rows, fields, mysql);
    
    if(rows)
    {
        cache_get_field_content(rows, "Username", Name[playerid]);
        SendFM(playerid, -1, "AKA: %s",Name[playerid]);
    }
    return 1;
}