[[HUN]Amf]

Hi! Every hour make pays, but get this error: [ERROR] cache_get_value_name: invalid row index 'X'

Код:

	    new STRING[ 128 ]; format( STRING, sizeof( STRING ), "SELECT * FROM users WHERE PayCheck != '0'" );
    mysql_tquery( MHandle, STRING, "MakePays", "d", 0 );
	 
	forward MakePays( playerid );
public MakePays( playerid )
{
    new rows, STRING[ 128 ], NAME[ 24 ], PAY;
    cache_get_row_count( rows ), printf( "%d", rows );
	    for( new i; i != rows; i ++ )
    {
        cache_get_value_name( i, "PlayerName", NAME );
        cache_get_value_name_int( i, "PayCheck", PAY );
	        mysql_format( MHandle, STRING , sizeof( STRING ), "UPDATE bank_accounts SET Balance=Balance+%d WHERE Owner='%s' && Disabled=0 LIMIT 1", PAY, NAME ), mysql_query( MHandle, STRING );
        mysql_format( MHandle, STRING , sizeof( STRING ), "UPDATE users SET PayCheck='0' WHERE PlayerName='%s' LIMIT 1", NAME ), mysql_query( MHandle, STRING );
	        for( playerid; playerid < MAX_PLAYERS; playerid ++ )
        {
            if( CompareEx( NAME, PlayerName( playerid ) ) )
            {
                if( IsPlayerConnected( playerid ) )
                {
                    SendFormatMessage( playerid, -1, "[{f3ff4a} SZERVER {ffffff}] Fizetйsed бtutalva a bankszбmlбdra! ( {f3ff4a}$%s{ffffff} )", FormatNumber( PAY ) );
                }
            }
        }
    }
    
    return 1;
}

But, this, works fine:

Код:

	    new STRING[ 128 ]; format( STRING, sizeof( STRING ), "SELECT PlayerName, Rank FROM users WHERE Fraction = '%d'", GetPlayerFraction( playerid ) );
		mysql_tquery( MHandle, STRING, "ShowMembers", "d", playerid );

public ShowMembers( playerid )
{
	if( GetPlayerFraction( playerid ) == 1 )
	{
	    new rows, PART[ 128 ], STRING[ 2024 ], NAME[ 24 ], RANG, RANK[ 24 ];

	    cache_get_row_count( rows );

	    for (new i; i != rows; i++)
	    {
	        cache_get_value_name( i, "PlayerName", NAME );
	        cache_get_value_name_int( i, "Rank", RANG );

			switch( RANG )
			{
			    case 1: RANK = "Sherrif";
			    case 2: RANK = "Undersherrif";
			    case 3: RANK = "Deputy-Sherrif";
			    case 4: RANK = "Academy-Student";
			}

	        format( PART, sizeof( PART ), "{ffffff}Nйv: {f3ff4a}%s{ffffff} Rang: {f3ff4a}%s\n", NAME, RANK ), strcat( STRING, PART );
	    }

	    ShowPlayerDialog( playerid, 1000, DIALOG_STYLE_MSGBOX, "{ffffff}Sherrif Tagok", STRING, "Rendben", "" );
	}

return 1;
}