[binnyl]

Estou tendo dificuldade, e preciso de alguйm experiente com MYSQL pra me ajudar...

Preciso carregar uma lista de atores, mas preciso que essa lista comeзe a carregar do 15, com id 15

Eu tentei assim, mas sem sucesso:

Код:

CarregarActores()
{
    mysql_tquery(ConnectMYSQL, "SELECT * FROM actores WHERE OwnerID != 0 AND sActor > 14", "Carregar_Actores", "");
}
forward Carregar_Actores();
public Carregar_Actores()
{
    new rows;
    cache_get_row_count(rows);
    if(rows > 0)
    {
        for(new a = 15; a < rows; a++)
        {
            // ints
            cache_get_value_int(a, "OwnerID", ActorInfo[a][OwnerID]);
            cache_get_value_int(a, "sActor", ActorInfo[a][actor]);
            cache_get_value_int(a, "sSKIN", ActorInfo[a][sSKIN]);
            // floats
            cache_get_value_float(a, "sX", ActorInfo[a][sX]);
            cache_get_value_float(a, "sY", ActorInfo[a][sY]);
            cache_get_value_float(a, "sZ", ActorInfo[a][sZ]);
            cache_get_value_float(a, "sR", ActorInfo[a][sR]);
            // criar ator
            if(ActorInfo[a][OwnerID] > 0) {
			    ActorInfo[a][actor] = CreateDynamicActor(ActorInfo[a][sSKIN], ActorInfo[a][sX], ActorInfo[a][sY], ActorInfo[a][sZ], ActorInfo[a][sR]);
			    SetDynamicActorInvulnerable(ActorInfo[a][actor], false);
			    SetDynamicActorHealth(ActorInfo[a][actor], 100);
			    new string[128];
			    format(string, sizeof(string), "(ActorID: %i OwnerID: %i).", a, ActorInfo[a][OwnerID], ActorInfo[a][sNAME]);
			    Text3DsActors[a] = CreateDynamic3DTextLabel(string, COLOR_GREY, ActorInfo[a][sX], ActorInfo[a][sY], ActorInfo[a][sZ], NAME_DRAWDISTANCE, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, ActorInfo[a][sVW]);
            }
        }
    }
    return 1;
}

[RodrigoMSR]

Remova o 15 do loop, deixe somente a condiзгo > 14 na query.

[binnyl]

Quote:

Originally Posted by RodrigoMSR Remova o 15 do loop, deixe somente a condiзгo > 14 na query.

Eu jб havia tentado:

Код:

CarregarActores()
{
    mysql_tquery(ConnectMYSQL, "SELECT * FROM actores WHERE OwnerID != 0 AND sActor > 14", "Carregar_Actores", "");
}
forward Carregar_Actores();
public Carregar_Actores()
{
    new rows;
    cache_get_row_count(rows);
    if(rows > 0)
    {
        for(new a = 0; a < rows; a++)
        {
            // ints
            cache_get_value_int(a, "OwnerID", ActorInfo[a][OwnerID]);
            cache_get_value_int(a, "sActor", ActorInfo[a][actor]);
            cache_get_value_int(a, "sSKIN", ActorInfo[a][sSKIN]);
            // floats
            cache_get_value_float(a, "sX", ActorInfo[a][sX]);
            cache_get_value_float(a, "sY", ActorInfo[a][sY]);
            cache_get_value_float(a, "sZ", ActorInfo[a][sZ]);
            cache_get_value_float(a, "sR", ActorInfo[a][sR]);
            // criar ator
            if(ActorInfo[a][OwnerID] > 0) {
			    ActorInfo[a][actor] = CreateDynamicActor(ActorInfo[a][sSKIN], ActorInfo[a][sX], ActorInfo[a][sY], ActorInfo[a][sZ], ActorInfo[a][sR]);
			    SetDynamicActorInvulnerable(ActorInfo[a][actor], false);
			    SetDynamicActorHealth(ActorInfo[a][actor], 100);
			    new string[128];
			    format(string, sizeof(string), "(ActorID: %i OwnerID: %i).", a, ActorInfo[a][OwnerID], ActorInfo[a][sNAME]);
			    Text3DsActors[a] = CreateDynamic3DTextLabel(string, COLOR_GREY, ActorInfo[a][sX], ActorInfo[a][sY], ActorInfo[a][sZ], NAME_DRAWDISTANCE, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, ActorInfo[a][sVW]);
            }
        }
    }
    return 1;
}

Mas dai carrega o id 15 no banco de dados, mas insere os dados no ator 0, eu precisava que comeзasse a iserir no id 15, saca?

[Bruno13]

Quote:

Originally Posted by binnyl Eu jб havia tentado: Код: CarregarActores() { mysql_tquery(ConnectMYSQL, "SELECT * FROM actores WHERE OwnerID != 0 AND sActor > 14", "Carregar_Actores", ""); } forward Carregar_Actores(); public Carregar_Actores() { new rows; cache_get_row_count(rows); if(rows > 0) { for(new a = 0; a < rows; a++) { // ints cache_get_value_int(a, "OwnerID", ActorInfo[a][OwnerID]); cache_get_value_int(a, "sActor", ActorInfo[a][actor]); cache_get_value_int(a, "sSKIN", ActorInfo[a][sSKIN]); // floats cache_get_value_float(a, "sX", ActorInfo[a][sX]); cache_get_value_float(a, "sY", ActorInfo[a][sY]); cache_get_value_float(a, "sZ", ActorInfo[a][sZ]); cache_get_value_float(a, "sR", ActorInfo[a][sR]); // criar ator if(ActorInfo[a][OwnerID] > 0) { ActorInfo[a][actor] = CreateDynamicActor(ActorInfo[a][sSKIN], ActorInfo[a][sX], ActorInfo[a][sY], ActorInfo[a][sZ], ActorInfo[a][sR]); SetDynamicActorInvulnerable(ActorInfo[a][actor], false); SetDynamicActorHealth(ActorInfo[a][actor], 100); new string[128]; format(string, sizeof(string), "(ActorID: %i OwnerID: %i).", a, ActorInfo[a][OwnerID], ActorInfo[a][sNAME]); Text3DsActors[a] = CreateDynamic3DTextLabel(string, COLOR_GREY, ActorInfo[a][sX], ActorInfo[a][sY], ActorInfo[a][sZ], NAME_DRAWDISTANCE, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, ActorInfo[a][sVW]); } } } return 1; } Mas dai carrega o id 15 no banco de dados, mas insere os dados no ator 0, eu precisava que comeзasse a iserir no id 15, saca?

Simples cara, nas variбveis basta adicionar +15 na variбvel de index 'a' do loop.

PHP код:

ActorInfo[a + 15][OwnerID] 


[binnyl]

Quote:

Originally Posted by Bruno13 Simples cara, nas variбveis basta adicionar +15 na variбvel de index 'a' do loop. PHP код: ActorInfo[a + 15][OwnerID]

Putz, й verdade, +rep