25.08.2017, 15:46
Thank you for the reply!
I've modified my code accordingly (I think...) --
and I'm also inserting the values in one by one. This has fixed the issue with the Plate setting the Locked/World/Parked values - they now remain at 0, which is their default, however the Plate is still not working, it is saving into the database like this...
I've modified my code accordingly (I think...) --
PHP код:
PlayerCar_Create(ownerid, modelid, Float:x, Float:y, Float:z, Float:angle, color1, color2)
{
for (new i = 0; i != MAX_DYNAMIC_CARS; i ++)
{
if (!CarData[i][carExists])
{
if (color1 == -1)
color1 = random(127);
if (color2 == -1)
color2 = random(127);
CarData[i][carExists] = true;
CarData[i][carModel] = modelid;
CarData[i][carOwner] = ownerid;
CarData[i][carPos][0] = x;
CarData[i][carPos][1] = y;
CarData[i][carPos][2] = z;
CarData[i][carPos][3] = angle;
CarData[i][carColor1] = color1;
CarData[i][carColor2] = color2;
new str[8], query[400];
format(str, sizeof(str), "%c%c%d%d%c%c%c", LetterList[random(sizeof(LetterList))], LetterList[random(sizeof(LetterList))], random(10), random(10), LetterList[random(sizeof(LetterList))], LetterList[random(sizeof(LetterList))], LetterList[random(sizeof(LetterList))]);
SetVehicleNumberPlate(i, str);
format(CarData[i][carPlate], 11, "%s", str);
CarData[i][carPaintjob] = -1;
CarData[i][carLocked] = false;
CarData[i][carParked] = 0;
CarData[i][carWorld] = 0;
CarData[i][carImpounded] = -1;
CarData[i][carImpoundPrice] = 0;
for (new j = 0; j < 14; j ++)
{
if (j < 5)
{
CarData[i][carWeapons][j] = 0;
CarData[i][carAmmo][j] = 0;
}
CarData[i][carMods][j] = 0;
}
CarData[i][carVehicle] = CreateVehicle(modelid, x, y, z, angle, color1, color2, -1);
if (CarData[i][carVehicle] != INVALID_VEHICLE_ID) {
ResetVehicle(CarData[i][carVehicle]);
}
//mysql_function_query(g_iHandle, "INSERT INTO `playercars` (`carModel`) VALUES(0)", false, "OnPlayerCarCreated", "d", i);
mysql_format(g_iHandle, query, sizeof(query), "INSERT INTO `playercars` (carModel, carOwner, carPosX, carPosY, carPosZ, carPosR, carColor1, carColor2, carPlate, carPaintjob, carParked, carWorld) VALUES(%d, %d, %f, %f, %f, %f, %d, %d, '%s', -1, 0, 0)",
CarData[i][carModel],
CarData[i][carOwner],
CarData[i][carPos][0],
CarData[i][carPos][1],
CarData[i][carPos][2],
CarData[i][carPos][3],
CarData[i][carColor1],
CarData[i][carColor2],
CarData[i][carPlate],
CarData[i][carPaintjob],
CarData[i][carParked],
CarData[i][carWorld]);
mysql_tquery(g_iHandle, query, "OnplayerCarCreated", "d", i);
return 1;
}
}
return -1;
}