05.02.2015, 23:04
I do not updating ! The insert is inserted , but not updating
HTML Code:
new query[512], idc; idc = PlayerInfo[playerid][pID]; new Float:pos1 = 494.3450; new Float:pos2 = -1022.9496; new Float:pos3 = 31.8931; new Float:angle = 184.0622; VehiclesInfo[TotalVeh][vServerID] = CreateVehicle(modelid, 494.3450, -1022.9496, 31.8931, 184.0622, 1, 1, 60000); PutPlayerInVehicle(playerid, VehiclesInfo[TotalVeh][vServerID], 0); format(query,300,"INSERT INTO `vehicles` (`Model`,`PositionX`,`PositionY`,`PositionZ`,`Angle`,`Owner`, `ServerID`, `Slot`) \ VALUES ('%d', '%f', '%f', '%f', '%f', '%i', '%i', '1')",modelid,pos1,pos2,pos3,angle,idc, VehiclesInfo[TotalVeh][vServerID]); mysql_query(handle, query); mysql_format(handle, query, sizeof(query), "UPDATE vehicles SET Owner = '%i', ServerID = '%i', Slot = '1' WHERE ID = '%i'", idc, VehiclesInfo[TotalVeh][vServerID], VehiclesInfo[TotalVeh][vID]); mysql_tquery(handle, query, "", "");