[Bwandon]

I'll try to explain this problem to best of my ability, basically I have a command '/acar create < model id / model name.'
This inserts a new row in to the MySQL table `VehicleInfo` (a new vehicle). Once this has finished querying, I then send a new query to the database, getting the data from it and then spawning the vehicle. Although, during testing I created 6 vehicles then empty'd the table but when I go in to the server and create another new vehicle it's registering the ID as 7 instead of 1 again (Note: 1 - 6 vehicle ID's nolonger exist within the table)

I also stopped the server then empty'd the table.

Here is some code:

Command:

PHP код:

if(!strcmp(iParams, "create", true, 6)) {
        if(PlayerInfo[playerid][aAdmin] < 4) return SendError(playerid, CANT_USE_CMD);
        if(!strlen(iParamsEx)) return SCP(playerid, "/acar create", "< model / id >");
        new slctedID;
        if(!IsNumeric(iParamsEx)) slctedID = ModelFromName(iParamsEx);
        else slctedID = strval(iParamsEx);
        if(slctedID < 400 || slctedID > 611) return SCP(playerid, "/acar create", "< model / id >");
        new Float:playerX, Float:playerY, Float:playerZ, Float:playerA;
        GetPlayerPos(playerid, playerX, playerY, playerZ);
        GetPlayerFacingAngle(playerid, playerA);
        CreateNewVehicle(PlayerName(playerid), slctedID, playerX, playerY, playerZ, playerA);
        new iFormat[159];
        format(iFormat, sizeof(iFormat), "(( AdmCmd | {CCCCCC}You have successfully created a new vehicle: %s! {D13F3F}))", VehicleName[slctedID - 400]);
        SendPlayerMessage(playerid, 0xD13F3FFF, iFormat, "(( AdmCmd | {CCCCCC}");
        return 1;
    } 


CreateNewVehicle function

PHP код:

stock CreateNewVehicle(vehOwner[], vehModel, Float:vehX, Float:vehY, Float:vehZ, Float:vehA, vVW = 0, rRes = VEHICLE_OWNED) {
    new iQuery[450];
    mysql_format(Pipeline, iQuery, sizeof(iQuery), "INSERT INTO `VehicleInfo` (`Owner`, `Model`, `X`, `Y`, `Z`, `A`, `VirtualWorld`, `Type`) VALUES ('%e', %d, %f, %f, %f, %f, %d, %d)", vehOwner, vehModel, vehX, vehY, vehZ, vehA, vVW, rRes);
    mysql_tquery(Pipeline, iQuery, "OnVehicleCreation");
} 


OnVehicleCreation

PHP код:

public OnVehicleCreation() {
    new vehicleid = cache_insert_id();
    printf("[ON VEHICLE CREATE] %d has been created successfully!", vehicleid);
    new iQuery[159]; mysql_format(Pipeline, iQuery, sizeof(iQuery), "SELECT * FROM `VehicleInfo` WHERE `ID` = %d LIMIT 1", vehicleid);
    mysql_tquery(Pipeline, iQuery, "OnLoadVehicles", "d", 0);
    return 1;
}