[gabitzu4ever]

I have a bug similar to the one below. How do I fix?

[ame]http://www.youtube.com/watch?v=Dm8pYxgI61s[/ame]

You can see the entire map area.

[Riddick94]

How the hell we can do fix it?! WHERE'S the code.

[gabitzu4ever]

pawn Код:

forward LoadTeritorii();
public LoadTeritorii()
{
    new teritorii=0;
    for(new idx = 1; idx < 50; idx++)
    {
        new Query[255];
        format(Query, sizeof(Query), "SELECT * FROM teritorii WHERE id= %d",idx);
        mysql_query(Query); // Querys the "Query" Variable.
        mysql_store_result(); // Stores the result from Query
        if(mysql_num_rows()) // Checks if theres anyrow.
        if(mysql_fetch_row_format(Query,"|")) // Splits the row
        {
                    sscanf(Query, "p<|>e<is[256]iifffffff>",TeritoriuData[idx]);
                    teritorii++;
        }
        new ttext[10];
        if(TeritoriuData[idx][tOwned] == 11)
        {
            ttext = "Sadoveanu";
        }
        else if(TeritoriuData[idx][tOwned] == 12)
        {
            ttext = "Capone";
        }
        else if(TeritoriuData[idx][tOwned] == 13)
        {
            ttext = "Duduianu";
        }
        else if(TeritoriuData[idx][tOwned] == 14)
        {
            ttext = "Corsicanu";
        }
        else if(TeritoriuData[idx][tOwned] == 15)
        {
            ttext = "Tobosaru";
        }
        else if(TeritoriuData[idx][tOwned] == 16)
        {
            ttext = "Camataru";
        }
        new string[MAX_STRING];
        format(string, sizeof(string), "Acest teritoriu apartine\n {FF0000} Clanului %s",ttext);
        //printf("Teritoriu id: %d tId %d tOwner %s tPozZ3 %f",idx,TeritoriuData[idx][tId],TeritoriuData[idx][tOwner],TeritoriuData[idx][tPozZ3]);
        CreateDynamicPickup(1239,23,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], -1, -1,-1,100.0);
        if(TeritoriuData[idx][tOwned] == 11)
        {
            Turfidd[idx] = CreateDynamic3DTextLabel(string,0x40863CFF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
        }
        else if(TeritoriuData[idx][tOwned] == 12)
        {
            Turfidd[idx] = CreateDynamic3DTextLabel(string,0xD900D9FF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);

        }
        else if(TeritoriuData[idx][tOwned] == 13)
        {
            Turfidd[idx] = CreateDynamic3DTextLabel(string,0xFD7E00FF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);

        }
        else if(TeritoriuData[idx][tOwned] == 14)
        {
            Turfidd[idx] = CreateDynamic3DTextLabel(string,0x6A4444FF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
        }
        else if(TeritoriuData[idx][tOwned] == 15)
        {
            Turfidd[idx] = CreateDynamic3DTextLabel(string,0x98B1ACFF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
        }
        else if(TeritoriuData[idx][tOwned] == 16)
        {
            Turfidd[idx] = CreateDynamic3DTextLabel(string,0x2F2F2FFF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);

        }
    }
    printf("-Teritorii citite: %d", teritorii);
    return 1;
}

...........

[Riddick94]

Is this thing is good for sure?

pawn Код:

sscanf(Query, "p<|>e<is[256]iifffffff>",TeritoriuData[idx]);

For the logic.. i think it's not. Maybe i can be wrong, because you're doing it in MySql, but you got only TeritoriuData after comma, but sscanf says something different some float values and other thing.

[gabitzu4ever]

Quote:

Originally Posted by Riddick94 Is this thing is good for sure? pawn Код: sscanf(Query, "p<|>e<is[256]iifffffff>",TeritoriuData[idx]); For the logic.. i think it's not. Maybe i can be wrong, because you're doing it in MySql, but you got only TeritoriuData after comma, but sscanf says something different some float values and other thing.

And how can I solve?