[Edw]

We have created a system and I have a little problem when extracting the name of the player database.
I do not know how well I understand but so idea:

PHP код:

mysql_format(SQL, szQuery, sizeof(szQuery), "SELECT * FROM `aplicatii`");
result = mysql_query(SQL, szQuery);
for(new i, j = cache_get_row_count (); i != j; ++i) {
    cache_get_field_content(i, "Userid",szResult); userid = strval(szResult);
    cache_get_field_content(i, "Date", szResult); format(date, 256, szResult);
    printf("%d | %s", userid, date);
    format(szDialog, sizeof(szDialog), "%s\t%s\n", GetNameFromDB(userid), date);
    strcat(szDialog2, szDialog);
    Selected[playerid][x] = userid;
    x++;
}
cache_delete(result);
    
stock GetNameFromDB(userid) {
    new szQuery[256], Cache: result;
    mysql_format(SQL, szQuery, sizeof(szQuery), "SELECT * FROM `users` WHERE `id`='%d'", userid);
    result = mysql_query(SQL, szQuery);
    new szResult[256], szName[256];
    format(szName, 256, "Null");
    for(new i, j = cache_get_row_count (); i < j; i++)
    {
         cache_get_field_content(i, "username", szResult); format(szName, 256, szResult);
    }
    cache_delete(result);
    printf("%s", szName);
    return szName;
} 


Debug:

PHP код:

With GetNameFromDB(userid):
[12:35:06] 1 | 1
[12:35:06] Null
[12:35:06] 1 | 1
[12:35:06] Null
[12:35:06] 1 | 1
[12:35:06] Null
[12:35:06] 1 | 1
Without:
[12:12:15] 1 | 1
[12:12:15] 2 | 2
[12:12:15] 3 | 3
[12:12:15] 4 | 4 


Database:
I hope you understand.

[Edw]

no one knows?

[SyS]

what is exactly your problem?

[Edw]

Quote:

Originally Posted by Sreyas what is exactly your problem?

If using the 'GetNameFromDB' everywhere looks the same, view and debug (1, 1, 1, 1) if you do not use, looks correct database (1,2,3,4)

[Wantedboy21]

WHAT IS PROBLEM ?

[Konstantinos]

Why don't you just join the two tables to get the player's name? Moreover consider using threaded queries:

pawn Код:

mysql_tquery(SQL, "SELECT a.Userid,IFNULL(u.username,\"\"),Date FROM aplicatii a LEFT JOIN users u ON u.id=a.Userid;", "OnAplicatiiLoadForPlayer", "i", playerid);

PHP код:

forward OnAplicatiiLoadForPlayer(playerid);
public OnAplicatiiLoadForPlayer(playerid)
{
    new
        tmp_userid,
        tmp_date[32]; // change accordingly, 256 is way too much
  
    szDialog2[0] = EOS; // reset the string, we don't want any text previously stored
    for (new i, j = cache_get_row_count(); i != j; i++)
    {
        // rowid 0 = Userid | rowid 1 = username | rowid 2 = Date
        tmp_userid = cache_get_row_int(i, 0);
        cache_get_row(i, 1, szDialog); 
        cache_get_row(i, 2, tmp_date);
        format(szDialog, sizeof szDialog, "%s\t%s\n", szDialog, tmp_date);
        strcat(szDialog2, szDialog); 
        Selected[playerid][i] = tmp_userid; 
    }
}