09.08.2015, 18:20
Hello, I have a probleme when a player buys a car its spawn good also in the mysql table is there but IG when you enter the car it says the car is not owned but when i reboot the server and you go in the car then it says its owned ...
Код:
new query[300], result[300]; format(query, sizeof(query), "SELECT COUNT(*) FROM vehicles"); mysql_query(query); mysql_store_result(); mysql_fetch_row(result); new newCarId = strval(result) + 1; mysql_free_result(); new Float:x, Float:y, Float:z; GetPlayerPos(playerid, x, y, z); mysql_debug(1); format(query, sizeof(query), "INSERT INTO vehicles SET id=%d, model=%d, x=%f, y=%f, z=%f, angle=%f, description='%s'", newCarId,GetVehicleModel(modelId), 2130.1914, -1109.5881, 25.1890, 76.2599, GetVehicleName(modelId)); mysql_query(query); CarInfo[newCarId][cModel] = GetVehicleModel(modelId); CarInfo[newCarId][cLocationx] = 2130.1914; CarInfo[newCarId][cLocationy] = -1109.5881; CarInfo[newCarId][cLocationz] = 25.1890; CarInfo[newCarId][cAngle] = 76.2599; CarInfo[newCarId][cColorOne] = 1; CarInfo[newCarId][cColorTwo] = 1; memcpy(CarInfo[newCarId][cOwner], playerid, 0, MAX_PLAYER_NAME*4, MAX_PLAYER_NAME*4); memcpy(CarInfo[newCarId][cOldOwner], NOMDEFAULT, 0, MAX_PLAYER_NAME*4, MAX_PLAYER_NAME*4); memcpy(CarInfo[newCarId][cDescription], GetVehicleName(modelId), 0, 32*4, 32*4); CarInfo[newCarId][cOwned] = 1; CarInfo[newCarId][cLock] = 0; CarInfo[newCarId][cValue] = CarPrice[modelId]; CarInfo[newCarId][cRespawnTime] = 3600; CarInfo[newCarId][cArme1] = 0; CarInfo[newCarId][cArme2] = 0; CarInfo[newCarId][cArme3] = 0; CarInfo[newCarId][cArme4] = 0; CarInfo[newCarId][cArme5] = 0; CarInfo[newCarId][cAmo1] = 0; CarInfo[newCarId][cAmo2] = 0; CarInfo[newCarId][cAmo3] = 0; CarInfo[newCarId][cAmo4] = 0; CarInfo[newCarId][cAmo5] = 0; CarInfo[newCarId][cDrugs] = 0; CarInfo[newCarId][cHero] = 0; CarInfo[newCarId][cMatos] = 0; CarInfo[newCarId][tPaintJob] = -1; CarInfo[newCarId][tMod][0] = -1; CarInfo[newCarId][tMod][1] = -1; CarInfo[newCarId][tMod][2] = -1; CarInfo[newCarId][tMod][3] = -1; CarInfo[newCarId][tMod][4] = -1; CarInfo[newCarId][tMod][5] = -1; CarInfo[newCarId][tMod][6] = -1; CarInfo[newCarId][tMod][7] = -1; CarInfo[newCarId][tMod][8] = -1; CarInfo[newCarId][tMod][9] = -1; CarInfo[newCarId][tMod][10] = -1; CarInfo[newCarId][tMod][11] = -1; CarInfo[newCarId][tMod][12] = -1; CarInfo[newCarId][tMod][13] = -1; memcpy(CarInfo[newCarId][cPlaque], "-1", 0,32*4,32*4); CarInfo[newCarId][dVehicle] = AddStaticVehicleEx(GetVehicleModel(modelId), 2130.1914, -1109.5881, 25.1890, 76.2599, 1, 1, 3600000); SaveSQLCar(newCarId,false); totalcars++;