[Loinal]

PHP код:

public OnPlayerConnectSafe(playerid)
{
    new query[128];
    GetPlayerIp(playerid, IP[playerid], 16);
    mysql_format(mysql, query, sizeof(query),"SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1", pName(playerid));
    mysql_tquery(mysql, query, "OnAccountCheck", "i", playerid);
    return 1;
} 


If the player is not banned the OnPlayerConnectSafe is requested it works
2) when the data is loaded i requested the script to saveplayerdata which means to update the player ip and variables

PHP код:

    if(IsLoggedIn[playerid] == 1)
    {
    SavePlayerData(playerid);
    IRC_GroupSay(groupID, IRC_aCHANNEL, "data saved and updated ip");
    } 


3) i checked the saveplayerdata its fine but it doesn't update the ip

PHP код:

stock SavePlayerData(playerid)
{
    if(IsLoggedIn[playerid] == 1)
    {
    new query[300];
    mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `IP` = '%e', `Admin` = %d, `Tokens` = %d, `Kills` = %d,`Deaths` = %d, `Score` = %d, `Money` = %d, `Hours` = %d,\
    `Minutes` = %d, `RaceWon` = %d WHERE `ID` = %d",
    IP[playerid], pData[playerid][Admin], pData[playerid][Tokens], pData[playerid][Kills],pData[playerid][Deaths], GetPlayerScore(playerid),\
    pData[playerid][Money], pData[playerid][pHours], pData[playerid][pMinutes],pData[playerid][RaceWon], pData[playerid][ID]);
    mysql_tquery(mysql, query);
    }
    return 1;
}