[Tayab]

I've tried to make a dynamic dealership system which uses two stocks. Those stock load the dealership and the cars of it when the gamemode starts. But the seem to be not working. When I comment the loading lines the gamemode runs otherwise it doesn't.


Here are the stocks. Any further code will be pasted upon request.

pawn Код:

stock LoadDealershipCars()
{
    new id = 1;
    while(id < MAX_DEALERSHIPCARS)
    {
        format(query,sizeof(query),"SELECT * FROM `dealershipcars` WHERE `id` = '%d'",id);
        mysql_query(query);
        mysql_store_result();
        if(mysql_num_rows())
        {
            if(mysql_fetch_row_format(query,"|"))
            {
                sscanf(query,"p<|>ffffddddd",DealerVehInfo[id][vX],DealerVehInfo[id][vY],DealerVehInfo[id][vZ],DealerVehInfo[id][vA],DealerVehInfo[id][vModel],DealerVehInfo[id][vC1],DealerVehInfo[id][vC2],DealerVehInfo[id][vPrice],DealerVehInfo[id][vDealershipid]);
                DealerVehInfo[id][vVehid] = CreateVehicle(DealerVehInfo[id][vModel],DealerVehInfo[id][vX],DealerVehInfo[id][vY],DealerVehInfo[id][vZ],DealerVehInfo[id][vA],DealerVehInfo[id][vC1],DealerVehInfo[id][vC2],10000);
                format(string,sizeof(string),"%d",DealerVehInfo[id][vPrice]);
                DealerVehInfo[id][vText] = CreateDynamic3DTextLabel(string, 0x00FF00FF, DealerVehInfo[id][vX],DealerVehInfo[id][vY],DealerVehInfo[id][vZ], 50.0);
            }
        }
    }
    return 1;
}
stock LoadDealerships()
{
    new i = 1;
    while(i < MAX_DEALERSHIPS)
    {
        format(query,sizeof(query),"SELECT * FROM `dealerships` WHERE `id` = '%d'",i);
        mysql_query(query);
        
        mysql_store_result();
        if(mysql_num_rows())
        {
            if(mysql_fetch_row_format(query,"|"))
            {
                sscanf(query,"p<|>fffs[64]d",DealerInfo[i][dX],DealerInfo[i][dY],DealerInfo[i][dZ],DealerInfo[i][dName],DealerInfo[i][dVehs]);
                DealerInfo[i][dText] = CreateDynamic3DTextLabel(DealerInfo[i][dName], 0xFFFFFFFF, DealerInfo[i][dX],DealerInfo[i][dY],DealerInfo[i][dZ], 50);
                DealerInfo[i][dPickup] = CreateDynamicCP(DealerInfo[i][dX],DealerInfo[i][dY],DealerInfo[i][dZ],7.0);
            }
        }
    }
    return 1;
}

Seeking a quick help.

[Nero_3D]

You need to increase your variables, just use for loops

pawn Код:

for(new id = 1; id < MAX_DEALERSHIPCARS; ++id)

[Tayab]

But I've been using while loops in every other loading system. It works perfectly fine.

[Tayab]

Still unresolved.

[Nero_3D]

The problem is that you never did id++ / i++, so the loop is stuck at id = 1

[Tayab]

Thanks, you're right but that still didn't work well.

[Tayab]

Still unresolved.