[RxErT]

Well, i was trying to make an AKA (Also known as) command, i used the script's variables and everything, also compiled without any error, but when i test it, i get Player Doesn't exist what did i do wrong?

PHP код:

COMMAND:aka(playerid, params[])
{
    if(playerData[playerid][playerLoggedIn])
    {
        new otherID, playersIP[10], playername[500][30], query[100];
        if(playerData[playerid][playerLevel] >= 4)
        {
            if(sscanf(params, "u", otherID))
            {
                SendClientMessage(playerid, COLOR_ORANGE, "Usage:\"aka <playername/id>\"");
            }
            else
            {
                if(IsPlayerConnected(otherID))
                {
                    if(playerData[otherID][playerLoggedIn])
                    {
                        GetPlayerIp(otherID, playersIP, sizeof(playersIP));
                        format(query, sizeof(query), "SELECT playerName FROM playerdata  WHERE playerIP`='%s' ORDER BY `playerName asc", playersIP);    
                        mysql_query(query);
                        mysql_store_result();
                        new i=0;
                        new num=mysql_num_rows();
                        new row[20];
                        if(mysql_num_rows())
                        {    
                            mysql_fetch_row(row, "|", connection);
                            explode(row, playername, "|");
                            for(i=1; i<num; i++)
                            {
                                mysql_fetch_row(playername[i], "playerName");    
                            }
                            SendClientMessage(playerid, COLOR_WHITE, "{00ffff}--------------------------------------------");
                            new msg[100];    
                            format(msg, sizeof(msg),"Player register with the ip:{B7B7B7}%s", playersIP);
                            SendClientMessage(playerid, COLOR_WHITE, msg);        
                            for(new j=0; j<num; j++)
                            {
                                new report[100];
                                format(report, sizeof(report), "%s", playername[j]);
                                SendClientMessage(playerid, COLOR_WHITE, report);
                            }
                            SendClientMessage(playerid, COLOR_WHITE,"{00ffff}--------------------------------------------");
                        }    
                        else
                        {
                            SendClientMessage(playerid, COLOR_WHITE, "{B7B7B7}[SERVER] {FFFFFF}That player doesn't exist.");
                        }
                        mysql_free_result();
                    }
                    else
                    {
                        SendClientMessage(playerid, COLOR_WHITE, "{B7B7B7}[SERVER] {FFFFFF}That player doesn't logged in.");
                    }
                }
                else
                {
                    SendClientMessage(playerid, COLOR_WHITE, "{B7B7B7}[SERVER] {FFFFFF}That player isn't connected.");
                }
            }
    
        }
        else
        {
             return 0;
        }
    }
    return 1;
} 


[Mugala]

problem is here.

PHP код:

                        GetPlayerIp(otherID, playersIP, sizeof(playersIP)); 
                        format(query, sizeof(query), "SELECT playerName FROM playerdata  WHERE playerIP`='%s' ORDER BY `playerName asc", playersIP);     
                        mysql_query(query); 
                        mysql_store_result(); 
                        new i=0; 
                        new num=mysql_num_rows(); 
                        new row[20]; 
                        if(mysql_num_rows()) 


and probably in here format(query, sizeof(query), "SELECT playerName FROM playerdata WHERE playerIP`='%s' ORDER BY `playerName asc", playersIP);
check the mysql logs, if there's no such kind of error/warning than use this function
format(query, sizeof(query), "SELECT playerName FROM playerdata WHERE `playerIP`= '%s' ORDER BY playerName asc", playersIP);

[RxErT]

Quote:

Originally Posted by Mugala problem is here. PHP код:                         GetPlayerIp(otherID, playersIP, sizeof(playersIP));                          format(query, sizeof(query), "SELECT playerName FROM playerdata  WHERE playerIP`='%s' ORDER BY `playerName asc", playersIP);                              mysql_query(query);                          mysql_store_result();                          new i=0;                          new num=mysql_num_rows();                          new row[20];                          if(mysql_num_rows())  and probably in here format(query, sizeof(query), "SELECT playerName FROM playerdata WHERE playerIP`='%s' ORDER BY `playerName asc", playersIP); check the mysql logs, if there's no such kind of error/warning than use this function format(query, sizeof(query), "SELECT playerName FROM playerdata WHERE `playerIP`= '%s' ORDER BY playerName asc", playersIP);

Thanks appreciated.