Get free mysql slot? Threaded
#3

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.)

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);
Reply


Messages In This Thread
Get free mysql slot? Threaded - by Dokins - 07.04.2016, 16:47
Re: Get free mysql slot? Threaded - by Konstantinos - 07.04.2016, 17:11
Re: Get free mysql slot? Threaded - by Dokins - 07.04.2016, 17:13

Forum Jump:


Users browsing this thread: 1 Guest(s)