[AphexCCFC]

pawn Код:

public AccountLoad(playerid)
{
    new temp[40], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(temp, sizeof(temp), "SERVER: Welcome %s", pname);
    SendClientMessage(playerid, -1, temp);

    // Field indexes are relative to the query.
    PlayerInfo[playerid][pLevel] =  cache_get_row_int(0, 2, g_Handle);
    PlayerInfo[playerid][pCash] =   cache_get_row_int(0, 3, g_Handle);
    PlayerInfo[playerid][pHealth] = cache_get_row_float(0, 4, g_Handle);
    PlayerInfo[playerid][pPos][0] = cache_get_row_float(0, 5, g_Handle);
    PlayerInfo[playerid][pPos][1] = cache_get_row_float(0, 6, g_Handle);
    PlayerInfo[playerid][pPos][2] = cache_get_row_float(0, 7, g_Handle);
    PlayerInfo[playerid][pPos][3] = cache_get_row_float(0, 8, g_Handle);
    cache_get_row(0, 9, temp, g_Handle), PlayerInfo[playerid][pIP] = strval(temp);

    GivePlayerMoney(playerid, PlayerInfo[playerid][pCash]);
    SetPlayerHealth(playerid, PlayerInfo[playerid][pHealth]);
    SetSpawnInfo(playerid, 0, DefaultSkin, PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2], PlayerInfo[playerid][pPos][3], 0, 0, 0, 0, 0, 0);
    SpawnPlayer(playerid);
    return 1;
}

Код:

[22:28:03] [WARNING] cache_get_data - no active cache
[22:28:03] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('2')
[22:28:03] [ERROR] cache_get_row_int - invalid datatype
[22:28:03] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('3')
[22:28:03] [ERROR] cache_get_row_int - invalid datatype
[22:28:03] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('4')
[22:28:03] [ERROR] cache_get_row_float - invalid datatype
[22:28:03] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('5')
[22:28:03] [ERROR] cache_get_row_float - invalid datatype
[22:28:03] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('6')
[22:28:03] [ERROR] cache_get_row_float - invalid datatype
[22:28:03] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('7')
[22:28:03] [ERROR] cache_get_row_float - invalid datatype
[22:28:03] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('8')
[22:28:03] [ERROR] cache_get_row_float - invalid datatype
[22:28:03] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('9')

The rows and indexes are correct and the datatypes too?

[Binx]

First off, hash your passwords using Whirlpool. Second, money should be "9", it might not make a difference but it'll help. Third, activate the cache(from false to true) when executing OnPlayerLoad. Fourth, PLEASE add an ID column, set it to Primary Index and A_I.