[Yaa]

Code:

PHP код:

public OnMySQLValided(playerid) 
{ 
        cache_get_value_name_int(0, "Admin", PlayerInfo[playerid][Admin]); 
        cache_get_value_name_int(0, "VIP", PlayerInfo[playerid][VIP]); 
        cache_get_value_name_int(0, "Money", PlayerInfo[playerid][Money]); 
        cache_get_value_name(0, "DeathMessage", PlayerInfo[playerid][pDM]);
        cache_get_value_name_int(0, "Deaths", PlayerInfo[playerid][pDeaths]);
        cache_get_value_name_int(0, "Kills", PlayerInfo[playerid][pKills]);
        cache_get_value_name_int(0, "Bans", PlayerInfo[playerid][pBans]);
        cache_get_value_name_int(0, "Kicks", PlayerInfo[playerid][pKicks]);
        cache_get_value_name_int(0, "Car", MyCar[playerid]);
    new query[150];
    mysql_format(register, query, sizeof(query), "SELECT * FROM `accounts_2` WHERE `Name` = '%s' LIMIT 1", GetName(playerid));
    mysql_tquery(register, query, "LoadPlayersHours", "i", playerid);
    return 1; 
}  
public LoadPlayersHours(playerid)
{
    cache_get_value_name_int(0, "Hours", PlayerInfo[playerid][pHours]);
    cache_get_value_name_int(0, "Minutes", PlayerInfo[playerid][pMin]);
    cache_get_value_name_int(0, "BankValue", BankInfo[playerid][Deposit]);
    cache_get_value_name_int(0, "SkinID", PlayerInfo[playerid][pSkin]);
    TogglePlayerSpectating(playerid, false); 
    GivePlayerMoney(playerid, PlayerInfo[playerid][Money]); 
    SendClientMessage(playerid, -1, "You have successfully logged in."); 
    SetSpawnInfo(playerid, 0, PlayerInfo[playerid][pSkin], 1958.33, 1343.12, 15.36, 269.15, 26, 36, 28, 150, 0, 0 );
    return 1;
} 


Errors:

PHP код:

[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:18)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:19)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:20)
[13:53:24] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:21)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:22)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:23)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:24)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:25)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:26)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:46)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:47)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:48)
[13:53:24] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0') (D:\pawn-editor\include\VCData\Server\Functions.pwn:49) 


Thanks in advence

[SoLetsGO]

Well it shows number of rows = 0 which means that there is nothing found. Where do you create the mysql query and are you sure that there is data in the table?

[Yaa]

Quote:

Originally Posted by SoLetsGO Well it shows number of rows = 0 which means that there is nothing found. Where do you create the mysql query and are you sure that there is data in the table?

Yes I'm sure