[vassilis]

Quote:

Originally Posted by Sreyas Basically GetPlayerIp returns 1 on success and 0 on failure.So what you doing is wrong logically. You can do it like this way. PHP код: CMD:aka(playerid, params[])  {      new query[60],pIP[16];      GetPlayerIp(playerid,pIP,sizeof(pIP));     mysql_format(mysql, query, sizeof(query),"SELECT `Username` from `players` WHERE `IP` = '%s'", pIP );            mysql_tquery(mysql, query, "CheckAka", "i", playerid);      return 1;  }

Still doesnt work..

PHP код:

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


PHP код:

CMD:aka(playerid, params[])
{
    new query[60],pIP[16];
    GetPlayerIp(playerid,pIP,sizeof(pIP));
    mysql_format(mysql, query, sizeof(query),"SELECT `Username` from `players` WHERE `IP` = '%s'", 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;
}