/*
    File: fn_wantedAdd.sqf
    Author: Bryan "Tonic" Boardwine"
    Database Persistence By: ColinM
    Assistance by: Paronity
    Stress Tests by: Midgetgrimm

    This file is for Nanou's HeadlessClient.

    Description:
    Adds or appends a unit to the wanted list.
*/
private ["_uid","_type","_index","_data","_crime","_val","_customBounty","_name","_pastCrimes","_query","_queryResult"];
_uid = [_this,0,"",[""]] call BIS_fnc_param;
_name = [_this,1,"",[""]] call BIS_fnc_param;
_type = [_this,2,"",[""]] call BIS_fnc_param;
_customBounty = [_this,3,-1,[0]] call BIS_fnc_param;
if (_uid isEqualTo "" || _type isEqualTo "" || _name isEqualTo "") exitWith {}; //Bad data passed.

//What is the crime?
switch (_type) do
{
    case "187V": {_type = ["187V",650]};
    case "187": {_type = ["187",2000]};
    case "901": {_type = ["901",450]};
    case "215": {_type = ["215",200]};
    case "213": {_type = ["213",1000]};
    case "211": {_type = ["211",100]};
    case "207": {_type = ["207",350]};
    case "207A": {_type = ["207A",200]};
    case "390": {_type = ["390",1500]};
    case "487": {_type = ["487",150]};
    case "488": {_type = ["488",70]};
    case "480": {_type = ["480",100]};
    case "481": {_type = ["481",100]};
    case "482": {_type = ["482",500]};
    case "483": {_type = ["483",950]};
    case "459": {_type = ["459",650]};
    case "666": {_type = ["666",200]};
    case "667": {_type = ["667",4500]};
    case "668": {_type = ["668",1500]};

    case "1": {_type = ["1",250]};
    case "2": {_type = ["2",100]};
    case "3": {_type = ["3",75]};
    case "4": {_type = ["4",125]};
    case "5": {_type = ["5",50]};
    case "6": {_type = ["6",40]};
    case "7": {_type = ["7",75]};
    case "8": {_type = ["8",2500]};
    case "9": {_type = ["9",2500]};
    case "10": {_type = ["10",7500]};
    case "11": {_type = ["11",5000]};
    case "12": {_type = ["12",1250]};
    case "13": {_type = ["13",750]};
    case "14": {_type = ["14",250]};
    case "15": {_type = ["15",1250]};
    case "16": {_type = ["16",750]};
    case "17": {_type = ["17",50]};
    case "18": {_type = ["18",750]};
    case "19": {_type = ["19",1250]};
    case "20": {_type = ["20",250]};
    case "21": {_type = ["21",250]};
    case "22": {_type = ["22",1000]};
    case "23": {_type = ["23",2500]};
    case "24": {_type = ["24",5000]};
    case "25": {_type = ["25",10000]};
    default {_type = [];};
};

if (_type isEqualTo []) exitWith {}; //Not our information being passed...
//Is there a custom bounty being sent? Set that as the pricing.
if !(_customBounty isEqualTo -1) then {_type set[1,_customBounty];};
//Search the wanted list to make sure they are not on it.

_query = format ["SELECT wantedID FROM wanted WHERE wantedID='%1'",_uid];
_queryResult = [_query,2,true] call HC_fnc_asyncCall;
_val = [_type select 1] call HC_fnc_numberSafe;
_number = _type select 0;

if !(count _queryResult isEqualTo 0) then
{
    _crime = format ["SELECT wantedCrimes, wantedBounty FROM wanted WHERE wantedID='%1'",_uid];
    _crimeresult = [_crime,2] call HC_fnc_asyncCall;
    _pastcrimess = [_crimeresult select 0] call HC_fnc_mresToArray;
    if (_pastcrimess isEqualType "") then {_pastcrimess = call compile format ["%1", _pastcrimess];};
    _pastCrimes = _pastcrimess;
    _pastCrimes pushBack _number;
    _pastCrimes = [_pastCrimes] call HC_fnc_mresArray;
    _query = format ["UPDATE wanted SET wantedCrimes = '%1', wantedBounty = wantedBounty + '%2', active = '1' WHERE wantedID='%3'",_pastCrimes,_val,_uid];
    [_query,1] call HC_fnc_asyncCall;
} else {
    _crime = [_type select 0];
    _crime = [_crime] call HC_fnc_mresArray;
    _query = format ["INSERT INTO wanted (wantedID, wantedName, wantedCrimes, wantedBounty, active) VALUES('%1', '%2', '%3', '%4', '1')",_uid,_name,_crime,_val];
    [_query,1] call HC_fnc_asyncCall;
};