public void SavePosVehicule(int IDBDDVeh)
{
VehiculeInfo objveh = VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh);
Vector3 vpos = API.getEntityPosition(objveh.handle);
Vector3 vrot = API.getEntityRotation(objveh.handle);
API.exported.database.executeQuery("UPDATE Vehicules SET Locked='" + Convert.ToInt32(API.getVehicleLocked(objveh.handle)) + "',PosX='" + vpos.X + "',PosY='" + vpos.Y + "',PosZ='" + vpos.Z + "',RotX='" + vrot.X + "',RotY='" + vrot.Y + "',RotZ='" + vrot.Z + "',Dimension='" + API.getEntityDimension(objveh.handle) + "',DansGarage='" + Convert.ToInt32(objveh.Dansgarage) + "' WHERE ID = '" + IDBDDVeh + "'");
}
public void SaveTuningVehicule(int IDBDDVeh)
{
string[] mod = { "FrontBumper", "RearBumper", "SideSkirt", "Exhaust", "Frame", "Grille", "Hood", "Fender", "RightFender", "Roof", "Engine", "Brakes", "Transmission", "Horns", "Suspension", "Armor", "Turbo", "Xenon", "FrontWheels", "BackWheels", "PlateHolders", "TrimDesign", "Ornaments", "DialDesign", "SteeringWheel", "ShiftLever", "Plaques", "Hydraulics", "Livery", "Plate", "Color1", "Color2", "WindowTint" };
int[] mod2 = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18, 22, 23, 24, 25, 27, 28, 30, 33, 34, 35, 38, 48, 62, 66, 67, 69 };
if (VerifTableModVehExiste(IDBDDVeh))
{
string requete = "UPDATE ModVehicules SET ";
if (API.getEntityData(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, "Spoilers") != null)
{
requete += String.Format("Spoilers={0}", API.getVehicleMod(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, 0));
}
else
{
requete += "Spoilers=-1";
}
for (int i = 0; i < mod.Length; i++)
{
if (API.getEntityData(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, mod[i]) == null)
{
requete += String.Format(",{0}=-1", mod[i]);
}
else
{
requete += String.Format(",{0}={1}", mod[i], API.getVehicleMod(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, mod2[i]));
}
}
requete += " WHERE IDVeh = '" + IDBDDVeh + "'";
API.exported.database.executeQuery(requete);
}
else
{
string requete;
if (API.getEntityData(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, "Spoilers") != null)
{
requete = "INSERT INTO ModVehicules VALUES ('','" + IDBDDVeh + "','" + API.getEntityData(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, "Spoilers") + "'";
}
else
{
requete = "INSERT INTO ModVehicules VALUES ('','" + IDBDDVeh + "','-1'";
}
for (int i = 0; i < mod2.Length; i++)
{
if (API.getEntityData(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, mod[i]) == null)
{
requete += ", '-1'";
}
else
{
requete += String.Format(", {0}", API.getVehicleMod(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, mod2[i]));
}
}
requete += ");";
API.exported.database.executeQuery(requete);
}
}
public static bool PlayerHaveVehicleKeys(Client player, int IDBDDVehicule)
{
PlayerInfo objplayer = PlayerInfo.GetPlayerInfoObject(player);
VehiculeInfo objvehicule = VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVehicule);
if (ClefInfo.GetPlayerKeysByObjetID(objplayer.dbid, IDBDDVehicule).Count < 1)
{
return(false);
}
else
{
return(true);
}
}
public void LoadMods(int IDBDDVeh)
{
DataTable result = API.exported.database.executeQueryWithResult("SELECT * FROM ModVehicules WHERE IDVeh = '" + IDBDDVeh + "'");
foreach (DataRow row in result.Rows)
{
string[] mod = { "Spoilers", "FrontBumper", "RearBumper", "SideSkirt", "Exhaust", "Frame", "Grille", "Hood", "Fender", "RightFender", "Roof", "Engine", "Brakes", "Transmission", "Horns", "Suspension", "Armor", "Turbo", "Xenon", "FrontWheels", "BackWheels", "PlateHolders", "TrimDesign", "Ornaments", "DialDesign", "SteeringWheel", "ShiftLever", "Plaques", "Hydraulics", "Livery", "Plate", "Color1", "Color2", "WindowTint" };
int[] mod2 = { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18, 22, 23, 24, 25, 27, 28, 30, 33, 34, 35, 38, 48, 62, 66, 67, 69 };
for (int i = 0; i < mod.Length; i++)
{
if (Convert.ToInt32(row[mod[i]]) != -1)
{
API.setEntityData(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, mod[i], Convert.ToInt32(row[mod[i]]));
API.setVehicleMod(VehiculeInfo.GetVehicleInfoByIdBDD(IDBDDVeh).handle, mod2[i], Convert.ToInt32(row[mod[i]]));
}
}
}
}
public void Vliste(Client player)
{
DataTable result = API.exported.database.executeQueryWithResult("SELECT * FROM Vehicules WHERE Proprio = '" + PlayerInfo.GetPlayerInfoObject(player).dbid + "'");
if (result.Rows.Count == 0)
{
API.sendChatMessageToPlayer(player, "~r~Tu n'es proprietaire d'aucuns vehicules.");
}
else
{
API.sendChatMessageToPlayer(player, "~g~Vehicules dont tu es le propriétaire :");
for (int i = 0; i < result.Rows.Count; i++)
{
if (VehiculeInfo.GetVehicleInfoByIdBDD(Convert.ToInt32(result.Rows[i]["ID"])) == null)
{
API.sendChatMessageToPlayer(player, String.Format("~g~{0}~s~ : {1} Etat : ~r~Garé~s~.", i + 1, API.getVehicleDisplayName((VehicleHash)result.Rows[i]["model"])));
}
else
{
API.sendChatMessageToPlayer(player, String.Format("~g~{0}~s~ : {1} Etat : ~g~Spawn~s~.", i + 1, API.getVehicleDisplayName((VehicleHash)result.Rows[i]["model"])));
}
}
}
}
