mysql loading but not setting the variable.
#1

As I stated in the topic title, the MySQL of my LoadPlayerVehicles() stock, reads and prints out how I want it to, but it just doesn't set the variable to be what it is loaded.

EG: If I have in the SQL database; vImpounded and it is equal to '1', it loads and prints '1', but the variable loads as '0'.

Here is the code:

pawn Code:
while(mysql_fetch_row(Query))
        {
            sscanf(Query, "p<|>iiiiis[24]s[9]ffffiiiiiiiiiiiiiiiiiiiiiiii", vID, vModel2, vC[0], vC[1], vPrice2, vOwner2, vPla, Pos[0], Pos[1], Pos[2], Pos[3], vPaint_Job, vLock, vMods[1], vMods[2], vMods[3],
            vMods[4], vMods[5], vMods[6], vMods[7], vMods[8], vMods[9], vMods[10], vMods[11], vMods[12], vMods[13], vMods[14], vMods[15], vMods[16], vMods[17], vMi, vCoc, vWe, vMo, vImp);
            Vehicles[vID][vModel] = vModel2;
            Vehicles[vID][vColor1] = vC[0];
            Vehicles[vID][vColor2] = vC[1];
            Vehicles[vID][vPrice] = vPrice2;
            strmid(Vehicles[vID][VehicleOwner], vOwner2, 0, 24, 24);
            Vehicles[vID][vPosX] = Pos[0];
            Vehicles[vID][vPosY] = Pos[1];
            Vehicles[vID][vPosZ] = Pos[2];
            Vehicles[vID][vPosA] = Pos[3];
            Vehicles[vID][VehiclePaintJob] = vPaint_Job;
            Vehicles[vID][vLocked] = vLock;
            Vehicles[vID][mod1] = vMods[1];
            Vehicles[vID][mod2] = vMods[2];
            Vehicles[vID][mod3] = vMods[3];
            Vehicles[vID][mod4] = vMods[4];
            Vehicles[vID][mod5] = vMods[5];
            Vehicles[vID][mod6] = vMods[6];
            Vehicles[vID][mod7] = vMods[7];
            Vehicles[vID][mod8] = vMods[8];
            Vehicles[vID][mod9] = vMods[9];
            Vehicles[vID][mod10] = vMods[10];
            Vehicles[vID][mod11] = vMods[11];
            Vehicles[vID][mod12] = vMods[12];
            Vehicles[vID][mod13] = vMods[13];
            Vehicles[vID][mod14] = vMods[14];
            Vehicles[vID][mod15] = vMods[15];
            Vehicles[vID][mod16] = vMods[16];
            Vehicles[vID][mod17] = vMods[17];
            Vehicles[vID][vMiles] = vMi;
            Vehicles[vID][vCocaine] = vCoc;
            Vehicles[vID][vWeed] = vWe;
            Vehicles[vID][vMoney] = vMo;
            format(Vehicles[vID][vPlate], 9, "%s", vPla);
            Vehicles[vID][vImpounded] = vImp;
If anybody can help me I would really appreciate this as this is stopping me doing the update that is needed on my server.

Thanks a lot!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)