sql error PRIMARY KEY must be unique
#4

OnGameModeInit
pawn Код:
new DBResult:Result = db_query(VehicleDB, "SELECT * FROM `vehicles`");
VehicleInfo[LoadedVehicles][vID] = db_num_rows(Result);
db_free_result(Result);
adding new vehicle into database
pawn Код:
new Query[208];
VehicleInfo[LoadedVehicles][vID]++;
format(Query, sizeof Query, "INSERT INTO vehicles (owner, ownerid, price, forsale, model, posx, posy, posz, posa) VALUES ('NONE', %d, %d, %d, %d, '%f', '%f', '%f', '%f')", -1, price, 1, model, cPos[0], cPos[1], cPos[2], cPos[3]);
db_query(VehicleDB, Query);
Reply


Messages In This Thread
sql error PRIMARY KEY must be unique - by lackmail - 28.10.2017, 23:10
Re: sql error PRIMARY KEY must be unique - by Jefff - 28.10.2017, 23:41
Re: sql error PRIMARY KEY must be unique - by lackmail - 28.10.2017, 23:47
Re: sql error PRIMARY KEY must be unique - by Jefff - 28.10.2017, 23:51
Re: sql error PRIMARY KEY must be unique - by lackmail - 29.10.2017, 00:04
Re: sql error PRIMARY KEY must be unique - by lackmail - 29.10.2017, 00:40

Forum Jump:


Users browsing this thread: 1 Guest(s)