10.08.2012, 16:22
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.):
MySQL log:
What's the problem?
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);
...
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") - |