public OnPlayerCharacterSelection(playerid) { #if TESTSERVER == true print("OnPlayerCharacterSelection Called."); #endif MySQL::getData(rows, fields); printf("Rows: %i", rows); for(new i = 0; i < rows; i++) { MySQL::storeString(i, 1, Temp[i][0]); if(strfind(Temp[i], "null", true) != -1) strcat((Temp[i][0] = EOS, Temp[i]), "Create Character", 17); } format(str, sizeof(str), "%s\n%s\n%s", Temp[0], Temp[1], Temp[2]); ShowPlayerDialog(playerid, DIALOG_ACCOUNT, DIALOG_STYLE_LIST, ""SVR_NAME" - Account", str, DIALOG_BUTTON_SELECT, DIALOG_BUTTON_EXIT); }
[16:43:08] [DEBUG] mysql_format - connection: 1, len: 450, format: "SELECT Username FROM playerdata WHERE ID IN(%i, %i, %i) ORDER BY ID ASC" [16:43:08] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Username FROM playerdata WHERE ID IN(1, 2, 0) ORDER BY ID", callback: "OnPlayerCharacterSelection", format: "i" [16:43:08] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [16:43:08] [DEBUG] CMySQLQuery::Execute[OnPlayerCharacterSelection] - starting query execution [16:43:08] [DEBUG] CMySQLQuery::Execute[OnPlayerCharacterSelection] - query was successfully executed within 3.37 milliseconds [16:43:08] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [16:43:08] [DEBUG] Calling callback "OnPlayerCharacterSelection".. [16:43:08] [DEBUG] cache_get_data - connection: 1 [16:43:08] [DEBUG] cache_get_row - row: 0, field_idx: 1, connection: 1, max_len: 1 [16:43:08] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('1') [16:43:08] [DEBUG] cache_get_row - row: 1, field_idx: 1, connection: 1, max_len: 1 [16:43:08] [WARNING] CMySQLResult::GetRowData - invalid row ('1') or field index ('1')
I know, but I am trying to get the data in the second field
|
"SELECT Username FROM playerdata WHERE ID IN(1, 2, 0) ORDER BY ID"