Vehicles problem [mysql] - Printable Version

Vehicles problem [mysql] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Vehicles problem [mysql] (/showthread.php?tid=527453)

Vehicles problem [mysql] - erikhenri - 22.07.2014

Problem is, cars getting messy when deleting car inbetween cars.
Example:
Player buys car A, car A ID is 1
I do /veh to create a temporary car B, car B ID is 2
Player buys car C, car C ID is 3

When that temporary car dissapears, ID 3 car stats are not working anymore after the server restart.

Re: Vehicles problem [mysql] - erikhenri - 23.07.2014

Also here's the load function.

PHP код:





stock LoadCars()

{

    new query[600];

    for(new id = 1; id < MAX_AUTOD; id++)

    {

        format(query, sizeof(query), "SELECT * FROM autod WHERE IID = %d", id);

        mysql_query(query);

        mysql_store_result();

        if(mysql_num_rows())

        if(mysql_fetch_row_format(query,"|"))

        {

            sscanf(query, "p<|>iiis[32]is[32]iiffffiiiis[32]i",

            Autos[id][aAutoID],Autos[id][aAutoV6ti],Autos[id][iID],

            Autos[id][aOmanik],Autos[id][aMudel],Autos[id][AutoNimi],

            Autos[id][aHind],Autos[id][aKiirus], Autos[id][aPosx],

            Autos[id][aPosy],Autos[id][aPosz],

            Autos[id][aAngle],Autos[id][vAku],

            Autos[id][vKytus],Autos[id][vVarv1],Autos[id][vVarv2],

            Autos[id][aNumbriM2rk],Autos[id][aArvel]);


            Total_Cars_Created++;

            printf("Car: %d Owner: %s CarID: %d ss %d  %f x  %f y  %f z  %f a", Autos[id][aAutoID],Autos[id][aOmanik],Autos[id][iID], Autos[id][aAutoV6ti], Autos[id][aPosx], Autos[id][aPosy],Autos[id][aPosz], Autos[id][aAngle]);

            SetVehicleNumberPlate(CreateVehicle(Autos[id][aMudel], Autos[id][aPosx], Autos[id][aPosy], Autos[id][aPosz], Autos[id][aAngle],Autos[id][vVarv1],Autos[id][vVarv2], -1), Autos[id][aNumbriM2rk]) ;

        }

    }

    printf("> %d cars loaded.", Total_Cars_Created);

    return 1;

}

Re: Vehicles problem [mysql] - erikhenri - 25.07.2014

Got it fixed, made an auto update ID.