Hallo ich würde mit der Resource SimpleRoleplay gerne beim Fahrzeug einparken die Tuning Daten in die Datenbank eintragen beim ausparken werde die Tuning teile schon aus der Datenbank auf das Auto gesetzt aber nicht vom Auto in die Datenbank hier ist mein nicht Funktionierender Code
Dies Funktioniert aber leider nicht. Vielleicht hat ja jemand eine Idee wie dies vielleicht funktionieren könnte. Ich bin anscheinend nicht schlau genug dafür.
Code:
public static void UpdateMods(OwnedVehicle ownedVehicle)
{
Dictionary<string, string> parameters = new Dictionary<string, string>
{
{ "@Spoiler", ownedVehicle.ActiveHandle.getMod(0).ToString() },
{ "@FrontBumper", ownedVehicle.ActiveHandle.getMod(1).ToString() },
{ "@RearBumper", ownedVehicle.ActiveHandle.getMod(2).ToString() },
{ "@SideSkirt", ownedVehicle.ActiveHandle.getMod(3).ToString() },
{ "@Exhaust", ownedVehicle.ActiveHandle.getMod(4).ToString() },
{ "@Frame", ownedVehicle.ActiveHandle.getMod(5).ToString() },
{ "@Grill", ownedVehicle.ActiveHandle.getMod(6).ToString() },
{ "@Hood", ownedVehicle.ActiveHandle.getMod(7).ToString() },
{ "@Fender", ownedVehicle.ActiveHandle.getMod(8).ToString() },
{ "@RightFender", ownedVehicle.ActiveHandle.getMod(9).ToString() },
{ "@Roof", ownedVehicle.ActiveHandle.getMod(10).ToString() },
{ "@Engine", ownedVehicle.ActiveHandle.getMod(11).ToString() },
{ "@Brakes", ownedVehicle.ActiveHandle.getMod(12).ToString() },
{ "@Transmission", ownedVehicle.ActiveHandle.getMod(13).ToString() },
{ "@Horn", ownedVehicle.ActiveHandle.getMod(14).ToString() },
{ "@Suspension", ownedVehicle.ActiveHandle.getMod(15).ToString() },
{ "@Armor", ownedVehicle.ActiveHandle.getMod(16).ToString() },
{ "@Turbo", ownedVehicle.ActiveHandle.getMod(18).ToString() },
{ "[USER=8755]@xenon[/USER]", ownedVehicle.ActiveHandle.getMod(22).ToString() },
{ "@FrontWheels", ownedVehicle.ActiveHandle.getMod(23).ToString() },
{ "@BackWheels", ownedVehicle.ActiveHandle.getMod(24).ToString() },
{ "@PlateHolder", ownedVehicle.ActiveHandle.getMod(25).ToString() },
{ "@TrimDesign", ownedVehicle.ActiveHandle.getMod(27).ToString() },
{ "@Ornaments", ownedVehicle.ActiveHandle.getMod(28).ToString() },
{ "@DialDesign", ownedVehicle.ActiveHandle.getMod(30).ToString() },
{ "@SteeringWheel", ownedVehicle.ActiveHandle.getMod(33).ToString() },
{ "@ShiftLever", ownedVehicle.ActiveHandle.getMod(34).ToString() },
{ "@Plaques", ownedVehicle.ActiveHandle.getMod(35).ToString() },
{ "@Hydraulics", ownedVehicle.ActiveHandle.getMod(38).ToString() },
{ "@Plate", ownedVehicle.ActiveHandle.getMod(62).ToString() },
{ "@WindowTint", ownedVehicle.ActiveHandle.getMod(69).ToString() },
{ "@DashboardColor", ownedVehicle.ActiveHandle.getMod(74).ToString() },
{ "@TrimColor", ownedVehicle.ActiveHandle.getMod(75).ToString() }
};
DataTable result = DatabaseHandler.ExecutePreparedStatement("UPDATE ownedvehicles SET Spoiler = @Spoiler, FrontBumper = @FrontBumper, RearBumper = @RearBumper, SideSkirt = @SideSkirt, SideSkirt = @SideSkirt, Exhaust = @Exhaust, Frame = @Frame, Grill = @Grill, Hood = @Hood," +
" Fender = @Fender, RightFender = @RightFender, Roof = @Roof, Engine = @Engine, Brakes = @Brakes, Transmission = @Transmission, Horn = @Horn, Suspension = @Suspension, Armor = @Armor," +
" Xenon = [USER=8755]@xenon[/USER], FrontWheels = @FrontWheels, BackWheels = @BackWheels, PlateHolder = @PlateHolder, TrimDesign = @TrimDesign, Ornaments = @Ornaments, DialDesign = @DialDesign," +
" SteeringWheel = @SteeringWheel, ShiftLever = @ShiftLever, Plaques = @Plaques, Hydraulics = @Hydraulics, Plate = @Plate, WindowTint = @WindowTint, DashboardColor = @DashboardColor," +
" TrimColor = @TrimColor WHERE Id = @Id LIMIT 1", parameters);
}