SQL Loading./
#2

pawn Код:
stock LoadOwnedCars(playerid)
{
    new query[300], newcar, vID;
    format(query, sizeof(query), "SELECT * FROM OwnedVehicles WHERE OwnedVehicleOwner = '%s'", pName(playerid));
    mysql_query(query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        mysql_fetch_row(query);
        sscanf(query, "p<|>d", vID);
        sscanf(query, "p<|>{d}ddddffffs[24]s[24]dddddddd", Vehicles[vID][vModel], Vehicles[vID][vColor1], Vehicles[vID][vColor2], Vehicles[vID][vPrice], Vehicles[vID][vPosX], Vehicles[vID][vPosY], Vehicles[vID][vPosZ], Vehicles[vID][vPosA], Vehicles[vID][VehicleOwner], Vehicles[vID][VehiclePlate], Vehicles[vID][VehiclePaintJob], Vehicles[vID][vLocked], Vehicles[vID][vTrunkMoney], Vehicles[vID][vTrunkMats], Vehicles[vID][vTrunkCocaine], Vehicles[vID][vTrunkMoonshine], Vehicles[vID][vFuel]);
        newcar = CreateVehicle(Vehicles[vID][vModel], Vehicles[vID][vPosX], Vehicles[vID][vPosY], Vehicles[vID][vPosZ], Vehicles[vID][vPosA], Vehicles[vID][vColor1], Vehicles[vID][vColor2], -1);
        format(Vehicles[vID][VehicleOwner], 24, "%s", Vehicles[vID][VehicleOwner]);
        format(Vehicles[vID][VehiclePlate], 32, "%s", Vehicles[vID][VehiclePlate]);
        SetVehicleNumberPlate(newcar, Vehicles[vID][VehiclePlate]);
        SetVehicleToRespawn(newcar);
        OwnedCar(newcar) = vID;
    }
    mysql_free_result();
    return 1;
}
Why in god's name are you using 1024 as a string length for your query?
Reply


Messages In This Thread
SQL Loading./ - by iGetty - 18.06.2012, 01:08
Re: SQL Loading./ - by SuperViper - 18.06.2012, 02:11
Re: SQL Loading./ - by iGetty - 18.06.2012, 20:22
Re: SQL Loading./ - by iGetty - 24.06.2012, 16:50

Forum Jump:


Users browsing this thread: 1 Guest(s)