Dėl darbo mašinų saugojimo krovimo

[TheNerka]

Sveiki kaip reikėtų saugoti/krauti darbo mašinas iš mysql?
pvz pas mane enum:
 

enum JobVehicleMysql
{
    ID,
    Model,
    Priklauso[50],
    Float:PosX,
    Float:PosY,
    Float:PosZ,
    Float:PosA,  
    Color1,
    Color2,
    NumberPlate[50],
    Float:Rida,
};
new JobVehicleData[MAX_VEHICLES][JobVehicleMysql];

pvz ID - NULL (AI)
Model - 411
Priklauso - Pica
PosX - 5.05
PosY - 5.25
PosZ - 8.88
PosA - 1.23
Color1 - 5
Color2 - 2
NumberPlate - ABC-123
Rida - 5.5

kaip padaryti kad pvz priklauso darbui masina yra atskiras enum:

enum JobsCarData {
    //Be pakvietimo
    Pica,
    Valytojai,
    Autobusai,
    //Su pakvietimais
    Policija,
    Gydytojai,
    Mechanikai,
    Taksi,
    Furistai,
    Dyleriai,
    //Kita
    Nuoma,
    //VM
    vMokyklaMoc,
    vMokyklaAuto,
    vMokyklaFura,
    
};
new JobCarData[MAX_VEHICLES][JobsCarData];


Kuriu masinas (ne mysql)

forward Vehicles();
public Vehicles()
{
    AntiDeAMX();
    //Picerija

    JobCarData[0][Pica] = CreateVehicle(448, 1363.6930, 262.1727, 19.0915, 66.0000, -1, -1, 100);
    JobCarData[1][Pica] = CreateVehicle(448, 1364.8600, 264.6413, 19.0915, 66.0000, -1, -1, 100);
    JobCarData[2][Pica] = CreateVehicle(448, 1361.4364, 257.2383, 19.0915, 66.0000, -1, -1, 100);
    JobCarData[3][Pica] = CreateVehicle(448, 1362.5811, 259.7486, 19.0915, 66.0000, -1, -1, 100);
    JobCarData[4][Pica] = CreateVehicle(448, 1353.1328, 238.4206, 19.0915, 66.0000, -1, -1, 100);
    JobCarData[5][Pica] = CreateVehicle(448, 1356.3854, 245.6447, 19.0915, 66.0000, -1, -1, 100);
    JobCarData[6][Pica] = CreateVehicle(448, 1355.2831, 243.3036, 19.0915, 66.0000, -1, -1, 100);
    JobCarData[7][Pica] = CreateVehicle(448, 1354.1251, 240.7404, 19.0915, 66.0000, -1, -1, 100);

    //Valytojai
    JobCarData[0][Valytojai] = CreateVehicle(552,1386.6694,372.2771,19.4510,246.2257, 1, 1, 60);
    JobCarData[1][Valytojai] = CreateVehicle(552,1389.6237,378.9332,19.4610,247.8843, 1, 1, 60);
    JobCarData[2][Valytojai] = CreateVehicle(552,1392.3658,385.1328,19.4565,246.6833, 1, 1, 60);
    JobCarData[3][Valytojai] = CreateVehicle(552,1394.9601,392.0703,19.4579,246.3130, 1, 1, 60);
    JobCarData[4][Valytojai] = CreateVehicle(574,1397.1606,399.0482,19.4830,246.6838, 1, 1, 60);
    JobCarData[5][Valytojai] = CreateVehicle(574,1399.7330,405.7642,19.4830,247.9171, 1, 1, 60);
    JobCarData[6][Valytojai] = CreateVehicle(574,1402.5721,412.5892,19.4830,246.9279, 1, 1, 60);
    //Autobusai
    /*JobCarData[0][Autobusai] = CreateVehicle(431,2287.0000,222.3000,27.0000000,270.0000000,1, 1, 60);
    JobCarData[1][Autobusai] = CreateVehicle(431,2287.0000,226.2998,27.0000000,270.0000000,1, 1, 60);
    JobCarData[2][Autobusai] = CreateVehicle(431,2287.0000,230.2998,27.0000000,270.0000000,1, 1, 60);
    JobCarData[3][Autobusai] = CreateVehicle(431,2287.0000,234.2998,27.0000000,270.0000000,1, 1, 60);
    JobCarData[4][Autobusai] = CreateVehicle(431,2287.0000,238.2998000,27.0000000,270.0000000,1, 1, 60);
    JobCarData[5][Autobusai] = CreateVehicle(431,2287.0000,242.2998000,27.0000000,270.0000000,1, 1, 60);
    JobCarData[6][Autobusai] = CreateVehicle(437,2286.8000,246.2000000,27.0000000,270.0000000,1, 1, 60);
    JobCarData[7][Autobusai] = CreateVehicle(437,2286.7998,250.2002000,27.0000000,270.0000000,1, 1, 60);
    JobCarData[8][Autobusai] = CreateVehicle(437,2286.7998,254.2002000,27.0000000,270.0000000,1, 1, 60);
    JobCarData[9][Autobusai] = CreateVehicle(437,2286.7998,258.2002000,27.0000000,270.0000000,1, 1, 60);
    JobCarData[10][Autobusai] = CreateVehicle(437,2286.7998,262.2002000,27.0000000,270.0000000,1, 1, 60);
    JobCarData[11][Autobusai] = CreateVehicle(437,2286.7998,266.2002000,27.0000000,270.0000000,1, 1, 60);*/

    JobCarData[0][Nuoma] = CreateVehicle(507, 2380.0051, 183.6569, 26.2179, 90.0000, -1, -1, 100);
    JobCarData[1][Nuoma] = CreateVehicle(507, 2380.0051, 180.6569, 26.2179, 90.0000, -1, -1, 100);
    JobCarData[2][Nuoma] = CreateVehicle(507, 2380.0051, 177.6569, 26.2179, 90.0000, -1, -1, 100);
    JobCarData[3][Nuoma] = CreateVehicle(507, 2380.0051, 174.6569, 26.2179, 90.0000, -1, -1, 100);
    JobCarData[4][Nuoma] = CreateVehicle(507, 2380.0051, 171.6369, 26.2179, 90.0000, -1, -1, 100);
    JobCarData[5][Nuoma] = CreateVehicle(507, 2380.0051, 168.6569, 26.2179, 90.0000, -1, -1, 100);

    //vm
    JobCarData[0][vMokyklaAuto] = CreateVehicle(565,20.4003900,-337.6000100,2.2000000,270.0000000,45,58,15); //Flash
    JobCarData[1][vMokyklaAuto] = CreateVehicle(565,20.4003900,-334.5996100,2.2000000,268.4950000,45,58,15); //Flash
    JobCarData[2][vMokyklaAuto] = CreateVehicle(565,20.4003900,-340.5996100,2.2000000,270.0000000,45,58,15); //Flash
    JobCarData[3][vMokyklaAuto] = CreateVehicle(565,20.4003900,-343.5996100,2.2000000,270.0000000,45,58,15); //Flash
    JobCarData[0][vMokyklaMoc] = CreateVehicle(581,20.8000000,-331.6000100,2.3000000,270.0000000,57,90,15); //BF-400
    JobCarData[1][vMokyklaMoc] = CreateVehicle(581,20.7998100,-328.5996100,2.3000000,270.0000000,57,90,15); //BF-400
    JobCarData[2][vMokyklaMoc] = CreateVehicle(581,20.7998100,-325.5996100,2.3000000,270.0000000,57,90,15); //BF-400
    JobCarData[3][vMokyklaMoc] = CreateVehicle(581,20.7998100,-322.5996100,2.3000000,270.0000000,57,90,15); //BF-400
    JobCarData[0][vMokyklaFura] = CreateVehicle(514,23.3000000,-319.2000100,3.3000000,270.0000000,39,47,15); //Tanker
    JobCarData[1][vMokyklaFura] = CreateVehicle(514,23.2998100,-315.2002000,3.3000000,270.0000000,39,47,15); //Tanker
    JobCarData[2][vMokyklaFura] = CreateVehicle(514,23.2998100,-311.2002000,3.3000000,270.0000000,39,47,15); //Tanker
    JobCarData[3][vMokyklaFura] = CreateVehicle(514,23.2998100,-307.2002000,3.3000000,270.0000000,39,47,15); //Tanker
    JobCarData[4][vMokyklaFura] = CreateVehicle(435,157.5000000,-243.0996100,3.2000000,180.0000000,245,245,15); //Trailer 1
    JobCarData[5][vMokyklaFura] = CreateVehicle(435,153.5000000,-243.0996100,3.2000000,180.0000000,245,245,15); //Trailer 1
    JobCarData[6][vMokyklaFura] = CreateVehicle(435,149.5000000,-243.0996100,3.2000000,180.0000000,245,245,15); //Trailer 1
    JobCarData[7][vMokyklaFura] = CreateVehicle(435,161.5000000,-243.0996100,3.2000000,180.0000000,245,245,15); //Trailer 1

}

if(newstate == PLAYER_STATE_DRIVER)
    {
        for(new i; i < sizeof(JobCarData); i++)
        {
            if(GetPlayerVehicleID(playerid) == JobCarData[i][Pica]) //
            {
                if(PlayerData[playerid][Job] != 10) // 
                {
                    SendClientMessage(playerid, COLOR_RED, "Jūs nedirbate picerijoje!");
                    RemovePlayerFromVehicle(playerid);
                }
                else
                {
                    SendClientMessage(playerid, COLOR_GREEN, "Vežiokite picas į nurodytas vietas ir gaukite pinigų");
                    new rand = random(sizeof(PicaDarboCP));
                    SetPlayerCheckpoint(playerid, PicaDarboCP[rand][0],PicaDarboCP[rand][1],PicaDarboCP[rand][2],PicaDarboCP[rand][3]);
                }
            }
...

norėčiau pasidaryti kad krautu iš mysql dėl ridos

naudoju mysql R38

Redaguota Spalio 12, 2014, nario TheNerka