[Stefand]

Well, My vehicle system works all fine but my CarFileID is Auto_Increasement.
When I delete a vehicle it just keeps counting up, for example, I have vehicle 1 2 3 4 5 6, and I delete 4 it will continue with 7 8 9 10...

Is there a way to change that?

if not, how can I change this code:
to make it work that it just loads Every single vehicle data, not including CarFileID?

pawn Код:

stock InitVehicles()
{
    new query[400];
    for(new id; id < MAX_VEHICLES; id++) // Goes through all the slots, looking for the data
    {
        format(query, sizeof(query), "SELECT * FROM `Vehicles` WHERE `CarFileID` = '%d'", id); // Selects all the information from the table
        mysql_function_query(g_connectionHandle, query, true, "LoadVehiclesCallback", "d", id);
    }
    return 1;
}

[Vince]

I'd say use a while loop, but I just noticed there is caching. Either way;

pawn Код:

mysql_function_query(g_connectionHandle, "SELECT * FROM Vehicles", true, "LoadVehiclesCallback", "d", id);

pawn Код:

new
    rows,
    fields;

cache_get_data(rows, fields, g_connectionHandle);

for(new i; i < rows; i++)
{
    new carFileId = cache_get_row_int(i, 0, g_connectionHandle);
    // Load stuff
}

[Stefand]

Quote:

Originally Posted by Vince I'd say use a while loop, but I just noticed there is caching. Either way; pawn Код: mysql_function_query(g_connectionHandle, "SELECT * FROM Vehicles", true, "LoadVehiclesCallback", "d", id); pawn Код: new     rows,     fields; cache_get_data(rows, fields, g_connectionHandle); for(new i; i < rows; i++) {     new carFileId = cache_get_row_int(i, 0, g_connectionHandle);     // Load stuff }

This still does not stop this right?
Well, My vehicle system works all fine but my CarFileID is Auto_Increasement.
When I delete a vehicle it just keeps counting up, for example, I have vehicle 1 2 3 4 5 6, and I delete 4 it will continue with 7 8 9 10...