[ryansheilds]

When trying to load all data, only the first field is loaded and the rest are loaded as blank.

Loading (Not all variables are shown.):

pawn Код:

stock LoadPlayerAccount(playerid)
{
    new string[128];
    
    format(string, sizeof(string), "SELECT * FROM `players` WHERE Username = '%s'", GetPlayerRPName(playerid));
    mysql_query(string, LOADUSERDATA_THREAD, playerid, iConnectionHandle);
    return 1;
}

pawn Код:

case LOADUSERDATA_THREAD:
        {
            mysql_store_result(connectionHandle);
            if(mysql_num_rows(connectionHandle) > 0)
            { 
                mysql_retrieve_row();

                new
                    szReturn[128];

                //mysql_fetch_field_row(PlayerInfo[extraid][pPass], "Pass", connectionHandle);

                mysql_fetch_field_row(szReturn, "DBID", connectionHandle);
                PlayerInfo[extraid][pDBID] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "Cash", connectionHandle);
                PlayerInfo[extraid][pCash] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "Deposit", connectionHandle);
                PlayerInfo[extraid][pDeposit] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "CreditCard", connectionHandle);
                PlayerInfo[extraid][pCreditCard] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "PayDay", connectionHandle);
                PlayerInfo[extraid][pPayDay] = strval(szReturn);
                
                mysql_fetch_field_row(szReturn, "PayDayHad", connectionHandle);
                PlayerInfo[extraid][pPayDayHad] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "PayCheck", connectionHandle);
                PlayerInfo[extraid][pPayCheck] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "ConnectHours", connectionHandle);
                PlayerInfo[extraid][pConnectHours] = strval(szReturn);
                
                mysql_fetch_field_row(szReturn, "ConnectSeconds", connectionHandle);
                PlayerInfo[extraid][pConnectSeconds] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "WRestricted", connectionHandle);
                PlayerInfo[extraid][pWRestricted] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "Age", connectionHandle);
                PlayerInfo[extraid][pAge] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "Sex", connectionHandle);
                PlayerInfo[extraid][pSex] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "Level", connectionHandle);
                PlayerInfo[extraid][pLevel] = strval(szReturn);

                mysql_fetch_field_row(szReturn, "HasCellphone", connectionHandle);
                PlayerInfo[extraid][pHasCellphone] = strval(szReturn);

...

MySQL log:

Quote:

[17:29:22] Passing query SELECT * FROM `players` WHERE Username = 'Ryan_Sheilds' | siii [17:29:22] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM `players` WHERE Username = 'Ryan_Sheilds') [17:29:22] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [17:29:22] OnQueryFinish(siii) - Threaded function called. [17:29:22] >> mysql_store_result( Connection handle: 1 ) [17:29:22] CMySQLHandler::StoreResult() - Result was stored. [17:29:22] >> mysql_num_rows( Connection handle: 1 ) [17:29:22] CMySQLHandler::NumRows() - Returned 1 row(s) [17:29:22] >> mysql_retrieve_row( Connection handle: 1 ) [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("DBID") - 1 [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("Cash") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("Deposit") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("CreditCard") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("PayDay") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("PayDayHad") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("PayCheck") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("ConnectHours") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("ConnectSeconds") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("WRestricted") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("Age") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("Sex") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("Level") - [17:29:22] >> mysql_fetch_field_row( Connection handle: 1 ) [17:29:22] CMySQLHandler::FetchField("HasCellphone") -

What's the problem?