[Mattakil]

I converted my vehicle system to SQLite from YINI and now nothing seems to be working. It's not saving the vehicles to the table, it is not loading the vehicle data either, in other words, the fuel textdraw doesnt show, and the vehicles do not save. This all worked prior to changing it, and I dunno what I fucked up, i'm new to this xD Also, when you do /createvehicle, it dont put the player in the vehicle.

pawn Код:

CMD:createvehicle(playerid, params[])
    {
    if(PlayerInfo[playerid][pAdmin] >=4)
        {
        new modelid, color1, color2;
        if(sscanf(params, "ddd", modelid, color1, color2))
            {
            UsageMessage(pid, "/createvehicle [modelid] [color1] [color2]");
            return 1;
            }
        else
            {
            new Float:X, Float:Y, Float:Z, Float:A;
            new string[30];
            format(string, sizeof(string), "%s", GetName(playerid));
            GetPlayerPos(playerid, X, Y, Z);
            GetPlayerFacingAngle(playerid, A);
            new vehicleid = VehicleCreate(0, modelid, X, Y, Z, A, color1, color2);
            PutPlayerInVehicle(playerid, vehicleid, 0);
            VehicleInfo[vehicleid][vOwner] = string;
            VehicleInfo[vehicleid][vFuel] = 100;
            VehicleInfo[vehicleid][vModel] = modelid;
            VehicleInfo[vehicleid][vCol1] = color1;
            VehicleInfo[vehicleid][vCol2] = color2;
            VehicleInfo[vehicleid][vSpawnX] = X;
            VehicleInfo[vehicleid][vSpawnY] = Y;
            VehicleInfo[vehicleid][vSpawnZ] = Z;
            VehicleInfo[vehicleid][vSpawnA] = A;
            return 1;
            }
        }
    return 1;
    }

pawn Код:

stock VehicleGetFreeSlot()
{
    for(new i = 0; i < MAX_VEHICLES; i++) 
    {
        if(!vCreated[i]) return i;
    }

    return -1;
}

stock VehicleCreate(owner, vehicleModel, Float:X, Float:Y, Float:Z, Float:A, vehicleColor1, vehicleColor2)
{
    new Query[300];
    new vehicleID = VehicleGetFreeSlot();
    //VehicleInfo[vehicleID][vOwner] = owner;
    VehicleInfo[vehicleID][vFuel] = 100;
    VehicleInfo[vehicleID][vModel] = vehicleModel;
    VehicleInfo[vehicleID][vCol1] = vehicleColor1;
    VehicleInfo[vehicleID][vCol2] = vehicleColor2;
    VehicleInfo[vehicleID][vSpawnX] = X;
    VehicleInfo[vehicleID][vSpawnY] = Y;
    VehicleInfo[vehicleID][vSpawnZ] = Z;
    VehicleInfo[vehicleID][vSpawnA] = A;
    format(Query, sizeof(Query), "INSERT INTO `ACCOUNTS` (`OWNER`, `FUEL`, `MODEL`, `COLOR 1`, `COLOR 2`, `ID`, `SPAWN X`, `SPAWN Y`, `SPAWN Z`, `SPAWN A`) VALUES('%s','20','%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d')", VehicleInfo[vehicleID][vOwner], VehicleInfo[vehicleID][vModel], VehicleInfo[vehicleID][vCol1], VehicleInfo[vehicleID][vCol2], VehicleInfo[vehicleID][vID], VehicleInfo[vehicleID][vSpawnX], VehicleInfo[vehicleID][vSpawnY], VehicleInfo[vehicleID][vSpawnZ], VehicleInfo[vehicleID][vSpawnA]);
    db_query(survival, Query);
    VehicleInfo[vehicleID][vID] = CreateVehicle(vehicleModel, X, Y, Z, A, vehicleColor1, vehicleColor2, 999999);
    vCreated[vehicleID] = true;
    return vehicleID;
}

stock VehicleGet(vehicleID)
{
    GetVehiclePos(VehicleInfo[vehicleID][vID], VehicleInfo[vehicleID][vSpawnX], VehicleInfo[vehicleID][vSpawnY], VehicleInfo[vehicleID][vSpawnZ]);
    GetVehicleZAngle(VehicleInfo[vehicleID][vID], VehicleInfo[vehicleID][vSpawnA]);
}
stock VehicleLoad(vehicleID)
{
    new
    Query[ 800 ],
    DBResult: Result;
    format(Query, sizeof(Query), "SELECT * FROM `VEHICLES` WHERE `ID` = '%d'", vehicleID);
    Result = db_query(survival, Query);
    if(db_num_rows(Result))
        {
        new Field[30];
        db_get_field_assoc(Result, "OWNER", Field, 30);
        VehicleInfo[vehicleID][vOwner] = Field;
        db_get_field_assoc(Result, "MODEL", Field, 30);
        VehicleInfo[vehicleID][vModel] = strval(Field);
        db_get_field_assoc(Result, "COLOR 1", Field, 30);
        VehicleInfo[vehicleID][vCol1] = strval(Field);
        db_get_field_assoc(Result, "COLOR 2", Field, 30);
        VehicleInfo[vehicleID][vCol2] = strval(Field);
        db_get_field_assoc(Result, "ID", Field, 30);
        VehicleInfo[vehicleID][vID] = strval(Field);
        db_get_field_assoc(Result, "SPAWN X", Field, 30);
        VehicleInfo[vehicleID][vSpawnX] = strval(Field);
        db_get_field_assoc(Result, "SPAWN Y", Field, 30);
        VehicleInfo[vehicleID][vSpawnY] = strval(Field);
        db_get_field_assoc(Result, "SPAWN Z", Field, 30);
        VehicleInfo[vehicleID][vSpawnZ] = strval(Field);
        db_get_field_assoc(Result, "SPAWN A", Field, 30);
        VehicleInfo[vehicleID][vSpawnA] = strval(Field);
        printf(Query);
        return 1;
        }
    VehicleCreate(VehicleInfo[vehicleID][vOwner], VehicleInfo[vehicleID][vModel], VehicleInfo[vehicleID][vSpawnX], VehicleInfo[vehicleID][vSpawnY], VehicleInfo[vehicleID][vSpawnZ], VehicleInfo[vehicleID][vSpawnA], VehicleInfo[vehicleID][vCol1], VehicleInfo[vehicleID][vCol2]);
    return 1;
}
stock VehicleSave(vehicleID)
{
    new Query[1000];
    format(Query, sizeof(Query), "UPDATE `VEHICLES` SET OWNER = '%s', FUEL = '%d', MODEL = '%d', COLOR 1 = '%d', COLOR 2 = '%d', SPAWN X = '%d', SPAWN Y = '%d', SPAWN Z = '%d', SPAWN A = '%d' WHERE ID = '%d'",
    VehicleInfo[vehicleID][vOwner], VehicleInfo[vehicleID][vFuel], VehicleInfo[vehicleID][vModel], VehicleInfo[vehicleID][vCol1], VehicleInfo[vehicleID][vCol2], VehicleInfo[vehicleID][vSpawnX], VehicleInfo[vehicleID][vSpawnY], VehicleInfo[vehicleID][vSpawnZ], VehicleInfo[vehicleID][vSpawnA], vehicleID);
    db_query(survival, Query);
    printf(Query);
}
stock VehicleLoadAll()
{
    new index = 0;

    for(new i = 0; i < MAX_VEHICLES; i++)
    {
        if(vCreated[i])
        {
            VehicleGet(index);
            VehicleLoad(index);
            index++;
        }
    }

    printf("Vehicles Loaded: %d", index); 
}
stock VehicleSaveAll()
{
    new index = 0; 

    for(new i = 0; i < MAX_VEHICLES; i++)
    {
        if(vCreated[i]) 
        {
            VehicleGet(index);
            VehicleSave(index);
            index++;
        }
    }

    printf("Vehicles Saved: %d", index);
}