Français Solved Inclusion du numéro du propriétaire dans l'interface de la fourrière

[Enzo2991]

Salut, comme marquer au dessus, j'aimerais mettre le numéro du propriétaire du véhicule dans la fourrière


Merci d'avance Enzo

 

[Maxence]

Hello !
Dans ton @The_Programmer/addons/impound/server/fn_getFourriere.sqf, remplace ces lignes :

_query = format ["SELECT id, classname, pid, color, plate FROM vehicles WHERE pid='%1' AND alive='1' AND active='0' AND fourriere='1' AND side='%2' AND type='%3'",_pid,_side,_type];
if (_pid isEqualTo "all") then {
    _idColumName = if ((getNumber (missionConfigFile >> "Max_Settings_Fourriere" >> "tonic_version")) isEqualTo 5) then {"pid"} else {"playerid"};

    _query = format ["SELECT vehicles.id, vehicles.classname, vehicles.pid, vehicles.color, vehicles.plate, players.name FROM vehicles INNER JOIN players WHERE vehicles.alive='1' AND vehicles.active='0' AND vehicles.fourriere='1' AND vehicles.type='%1' AND vehicles.pid=players.%2",_type,_idColumName];
};

par :

_idColumName = if ((getNumber (missionConfigFile >> "Max_Settings_Fourriere" >> "tonic_version")) isEqualTo 5) then {"pid"} else {"playerid"};
_query = format ["SELECT vehicles.id, vehicles.classname, vehicles.pid, vehicles.color, vehicles.plate, players.name, players.phone_number FROM vehicles INNER JOIN players WHERE vehicles.pid='%1' AND vehicles.alive='1' AND vehicles.active='0' AND vehicles.fourriere='1' AND vehicles.side='%2' AND vehicles.type='%3' AND vehicles.pid=players.%4",_pid,_side,_type,_idColumName];
if (_pid isEqualTo "all") then {
    _query = format ["SELECT vehicles.id, vehicles.classname, vehicles.pid, vehicles.color, vehicles.plate, players.name, players.phone_number FROM vehicles INNER JOIN players WHERE vehicles.alive='1' AND vehicles.active='0' AND vehicles.fourriere='1' AND vehicles.type='%1' AND vehicles.pid=players.%2",_type,_idColumName];
};

Dans ton @The_Programmer/addons/impound/server/fn_searchFourriere.sqf, remplace cette ligne :

_query = format ["SELECT vehicles.id, vehicles.classname, vehicles.pid, vehicles.color, vehicles.plate, players.name FROM vehicles INNER JOIN players WHERE vehicles.alive='1' AND vehicles.active='0' AND vehicles.fourriere='1' AND vehicles.type='%1' AND players.name LIKE '%4%3%4' AND vehicles.pid=players.%2",_type,_idColumName,_name,"%"];

par :

_query = format ["SELECT vehicles.id, vehicles.classname, vehicles.pid, vehicles.color, vehicles.plate, players.name, players.phone_number FROM vehicles INNER JOIN players WHERE vehicles.alive='1' AND vehicles.active='0' AND vehicles.fourriere='1' AND vehicles.type='%1' AND players.name LIKE '%4%3%4' AND vehicles.pid=players.%2",_type,_idColumName,_name,"%"];

Dans ton @The_Programmer/addons/impound/server/fn_garageLBChangevehFourriere.sqf, ajoute après + " : <t color='#32A832'>%1</t><br/>" + :

"Numéro de téléphone du propriétaire : %5<br/>" +

Dans le même fichier, ajoute après [_retrievePrice] call life_fnc_numberText :

, if ((_vehicleData select 6) != "0") then {(_vehicleData select 6)} else {"Pas de téléphone"}

Dis-moi si ça fonctionne

 

[Enzo2991]

Super ça fonctionne merci Maxence