[AnonymousUser]

I have a problem with loading last player connect date and last player connected IP. It is always null! But the values in PMA is not null :3 Tried to print, everything is fine.

OnPlayerConnect:

pawn Код:

format(szQuery, 77, "SELECT `Name` FROM `players` WHERE `Name` = '%s'", GetPlayerNameEx(playerid));
mysql_function_query(iHandle, szQuery, true, "OnPlayerConnectEx", "ds", playerid, szName[playerid]);

OnPlayerConnectEx:

pawn Код:

PUB::OnPlayerConnectEx(playerid, Name[])
{
    new iFields, iRows;
        
    cache_get_data(iRows, iFields);
    if (iRows)
    {
           // login check
    }
    else
    {
           // register
    }
    return true;
}

Login:

pawn Код:

format(szQuery, 77, "SELECT `Name` FROM `players` WHERE `Name` = '%s'", GetPlayerNameEx(playerid));
mysql_function_query(iHandle, szQuery, true, "OnPlayerLogin", "dsd", playerid, GetPlayerNameEx(playerid), 1);

OnPlayerLogin:

pawn Код:

PUB::OnPlayerLogin(playerid, Name[], ResultID)
{
    new szQuery[213], iFields, iRows;
        
    switch (ResultID)
    {
        case 1:
        {
            cache_get_data(iRows, iFields);
            format(szQuery, 61, "SELECT `IP` FROM `players` WHERE `IP` = '%s'", GetPlayerIpEx(playerid));
            mysql_function_query(iHandle, szQuery, true, "OnPlayerLogin", "dsd", playerid, GetPlayerNameEx(playerid), (iRows) ? (2) : (3));
        }
        case 2:
        {
            cache_get_data(iRows, iFields);
            if (iRows)
            {
                format(szQuery, 125, "SELECT `LastSeen`, `LastIP` FROM `players` WHERE `Name` = '%s'", GetPlayerNameEx(playerid));
                mysql_function_query(iHandle, szQuery, true, "OnPlayerLogin", "dsd", playerid, GetPlayerNameEx(playerid), 5);
            }
            else
            {
                // The IP doesnt match with registration IP,  let's open login dialog
            }
        }
        case 3:
        {
            cache_get_data(iRows, iFields);
            if (iRows >= MAX_ACCOUNTS_PER_IP)
            {
                // Player haves 3 accounts already, kick him.
                Kick(playerid);
            }
            else
            {
                // Player doesnt have more than three accounts, open registration dialog
            }
        }
        case 4:
        {
            cache_get_data(iRows, iFields);
            if (iRows)
            {
                format(szQuery, 125, "SELECT `LastSeen`, `LastIP` FROM `players` WHERE `Name` = '%s'", GetPlayerNameEx(playerid));
                mysql_function_query(iHandle, szQuery, true, "OnPlayerLogin", "dsd", playerid, GetPlayerNameEx(playerid), 5);
            }
            else
            {
                if (iBadPassword[playerid] == MAX_PASSWORD_WARNS - 1)
                {
                    // Player entered wrong password three times. Kick him
                    Kick(playerid);
                    return true;
                }
                // Player havent entered wrong password three times, lets open login dialog.
                iBadPassword[playerid] += 1;
            }
        }
        case 5:
        {
            cache_get_row(0, 0, pInfo[playerid][statsLastSeen]);
            cache_get_row(0, 1, pInfo[playerid][statsLastIP]);

            printf("Last Seen: %s\nLast IP: %s", date(pInfo[playerid][statsLastSeen]), pInfo[playerid][statslastIP]);

            strcpy(pInfo[playerid][statsLastIP], GetPlayerIpEx(playerid), 17);
            pInfo[playerid][statsLastSeen] = GetCurrentDateInUnix();
            iLoggedIn[playerid] = true;
        }
    }
    return true;
}

Functions date(), GetCurrentDateInUnix(), GetPlayerIpEx() works fine in other places..

[AnonymousUser]

Bump.

[AnonymousUser]

Bump.

[MadeMan]

pawn Код:

case 5:
        {
            cache_get_row(0, 0, pInfo[playerid][statsLastSeen]);
            cache_get_row(0, 1, pInfo[playerid][statsLastIP]);

            printf("Last Seen: %s\nLast IP: %s", date(pInfo[playerid][statsLastSeen]), pInfo[playerid][statslastIP]);
        }

statsLastIP and statslastIP

Show the print from server log.