string query2 = "SELECT * FROM vehicles";
        DataTable result2 = API.exported.database.executeQueryWithResult(query2);

        if (result2.Rows.Count != 0)
        {
            foreach (DataRow row in result2.Rows)
            {

                var posxvalue = (float)row["pos_x"];
                var posyvalue = (float)row["pos_y"];
                var poszvalue = (float)row["pos_z"];

                double resultdoublex;
                double resultdoubley;
                double resultdoublez;

                resultdoublex = Convert.ToDouble(posxvalue);
                resultdoubley = Convert.ToDouble(posyvalue);
                resultdoublez = Convert.ToDouble(poszvalue);

                Console.WriteLine("#" + row["id"] + " Model: " + row["model"] + " X: " + resultdoublex + " Y: " + resultdoubley + " Z: " + resultdoublez + ".");
                VehicleHash vehicleHash = API.vehicleNameToModel(row["model"].ToString());

                var car = API.createVehicle(vehicleHash, new Vector3(resultdoublex, resultdoubley, resultdoublez), new Vector3((float)row["rot_x"], (float)row["rot_y"], (float)row["rot_z"]), (int)row["color_1"], (int)row["color_2"], 0);
                API.setEntityData(car, "VEHICLEID", row["id"]);
                API.setEntityData(car, "OWNER", row["owner"]);
                API.setEntityData(car, "pos_x", row["pos_x"]);
                API.setEntityData(car, "pos_y", row["pos_y"]);
                API.setEntityData(car, "pos_z", row["pos_z"]);
                Console.WriteLine(API.getEntityData(car, "VEHICLEID"));

                API.setVehicleMod(car, 1, (int)row["mod_bumper_front"]);
                API.setVehicleMod(car, 2, (int)row["mod_bumper_rear"]);
                API.setVehicleMod(car, 3, (int)row["mod_sideskirt"]);
                API.setVehicleMod(car, 4, (int)row["mod_exhaust"]);
                API.setVehicleMod(car, 5, (int)row["mod_frame"]);
                API.setVehicleMod(car, 6, (int)row["mod_grille"]);
                API.setVehicleMod(car, 7, (int)row["mod_hood"]);
                API.setVehicleMod(car, 8, (int)row["mod_fender"]);
                API.setVehicleMod(car, 9, (int)row["mod_fender_right"]);
                API.setVehicleMod(car, 10, (int)row["mod_roof"]);
                API.setVehicleMod(car, 11, (int)row["mod_engine"]);
                API.setVehicleMod(car, 12, (int)row["mod_brakes"]);
                API.setVehicleMod(car, 13, (int)row["mod_transmission"]);
                API.setVehicleMod(car, 14, (int)row["mod_horn"]);
                API.setVehicleMod(car, 18, (int)row["mod_turbo"]);
                API.setVehicleMod(car, 22, (int)row["mod_xenon"]);
                API.setVehicleMod(car, 23, (int)row["mod_wheels_front"]);
                API.setVehicleMod(car, 24, (int)row["mod_wheels_back"]);
                API.setVehicleMod(car, 25, (int)row["mod_plate_holder"]);
                API.setVehicleMod(car, 27, (int)row["mod_trim"]);
                API.setVehicleMod(car, 28, (int)row["mod_ornaments"]);
                API.setVehicleMod(car, 30, (int)row["mod_dial"]);
                API.setVehicleMod(car, 33, (int)row["mod_steering"]);
                API.setVehicleMod(car, 34, (int)row["mod_shift"]);
                API.setVehicleMod(car, 35, (int)row["mod_plaque"]);
                API.setVehicleMod(car, 38, (int)row["mod_hydraulics"]);
                API.setVehicleMod(car, 48, (int)row["mod_livery"]);
                API.setVehicleMod(car, 69, (int)row["mod_windowtint"]);
                API.setVehicleMod(car, 66, (int)row["mod_color_1"]);
                API.setVehicleMod(car, 67, (int)row["mod_color_2"]);
                API.setVehicleMod(car, 15, (int)row["mod_color_2"]);
            }
        }