07.04.2016, 17:13
What do you mean?
I'm basically trying to assign a vehicle to an inactive slot, it changes ALL of the inactive to 1. Actually....I might be looking in the wrong place.
EDIT:
EDIT 2:
RESOLVED, STRING SIZE WAS TOO SMALL AND WAS AFFECTING ALL ROWS.
The issue seems to be with delete vehicle.
It deletes ALL the vehicles (sets them to inactive.)
I'm basically trying to assign a vehicle to an inactive slot, it changes ALL of the inactive to 1. Actually....I might be looking in the wrong place.
EDIT:
EDIT 2:
RESOLVED, STRING SIZE WAS TOO SMALL AND WAS AFFECTING ALL ROWS.
The issue seems to be with delete vehicle.
It deletes ALL the vehicles (sets them to inactive.)
pawn Код:
format(query, sizeof(query), "UPDATE `vehicles` SET Inactive = 1, VehModel = 0, VehJob = -1,VehOwner = 0, VehColour1 = 0, VehColour2 = 0, VehPlate = '0', VehSpawnX = 0, VehSpawnY = 0, VehSpawnZ = 0, VehSpawnAngle = 0, VehFuel = 0, VehCash = 0, VehArmour = 0,VehFaction = 0,VehFRank = 0, VehOwned = 0, VehFactioned = 0, VehWeed = 0, VehCoke = 0, VehBizID = 0, VehForSale = 0, VehPrice = 0 WHERE `id` = %d LIMIT 1", VehicleSQLID[vehicleid]);
mysql_tquery(dbHandle, query, "DeletedVeh", "ii", playerid, vehicleid);
