Files
AltisLifeFramework/life_hc/MySQL/WantedSystem/fn_wantedFetch.sqf
Benjamin Kyd c8014ec81e initial commit
2019-06-05 00:45:50 +01:00

50 lines
1.4 KiB
Plaintext

#include "\life_hc\hc_macros.hpp"
/*
File: fn_wantedFetch.sqf
Author: Bryan "Tonic" Boardwine"
Database Persistence By: ColinM
Assistance by: Paronity
Stress Tests by: Midgetgrimm
This file is for Nanou's HeadlessClient.
Description:
Displays wanted list information sent from the server.
*/
private ["_ret","_list","_result","_queryResult","_units","_inStatement"];
_ret = [_this,0,objNull,[objNull]] call BIS_fnc_param;
if (isNull _ret) exitWith {};
_inStatement = "";
_list = [];
_units = [];
{if ((side _x) isEqualTo civilian) then {_units pushBack (getPlayerUID _x)};} forEach playableUnits;
if (_units isEqualTo []) exitWith {[_list] remoteExec ["life_fnc_wantedList",_ret];};
{
if (count _units > 1) then {
if (_inStatement isEqualTo "") then {
_inStatement = "'" + _x + "'";
} else {
_inStatement = _inStatement + ", '" + _x + "'";
};
} else {
_inStatement = _x;
};
} forEach _units;
_query = format ["SELECT wantedID, wantedName FROM wanted WHERE active='1' AND wantedID in (%1)",_inStatement];
_queryResult = [_query,2,true] call HC_fnc_asyncCall;
diag_log format ["Query: %1",_query];
{
_list pushBack (_x);
}
forEach _queryResult;
if (_list isEqualTo []) exitWith {[_list] remoteExec ["life_fnc_wantedList",_ret];};
[_list] remoteExec ["life_fnc_wantedList",_ret];