ADAC Nachrichten leer (SQL Phone)

#include "..\..\script_macros.hpp"
/*
file: fn_newMsg.sqf    
Author: Silex    
*/
private["_to","_type","_playerData","_msg"];
disableSerialization;
_type = [_this,0,-1] call BIS_fnc_param;
_playerData = [_this,1,-1] call BIS_fnc_param;
_msg = [_this,2,"",[""]] call BIS_fnc_param;
_display = findDisplay 88888;
_cPlayerList = _display displayCtrl 88881;
_cMessageEdit = _display displayCtrl 88884;
switch(_type) do{    
 case 0:    { 
 life_smartphoneTarget = call compile format["%1",_playerData];
 ctrlSetText[88886, format["message: %1",name life_smartphoneTarget]];
 if((FETCH_CONST(life_adminlevel) < 1)) then {
 ctrlShow[888897,false];
 };
 };
 //normal message    
 case 1:    { 
 if(isNUll life_smartphoneTarget) exitWith {hint format["No person selected!"];
};
 ctrlShow[88885, false];
 if(_msg == "") exitWith {hint "You must enter a message to be sent!";
 ctrlShow[88885, true];
};
[life_smartphoneTarget,_msg,player,0] remoteExec ["TON_fnc_handleMessages",2];
 hint format["You sent %1 a message: %2",name life_smartphoneTarget,_msg];
 ctrlShow[88885, true];
 closeDialog 88883;
 };
 //copmessage    
 case 2:    { if(({side _x == west} count playableUnits) == 0) exitWith {hint format["The police is currently inaccessible. Please try again later."];
};
 ctrlShow[888895,false];
 if(_msg == "") exitWith {hint "You must enter a message to be sent!";
 ctrlShow[888895,true];
};
[ObjNull,_msg,player,1] remoteExec ["TON_fnc_handleMessages",2];
 _to = "Police";
 hint format["You sent %1 a message: %2",_to,_msg];
 ctrlShow[888895,true];
 closeDialog 887890;
 };
 //msgadmin    
 case 3:    { ctrlShow[888896,false];
 if(_msg == "") exitWith {hint "You must enter a message to be sent!";
 ctrlShow[888896,true];
};
[ObjNull,_msg,player,2] remoteExec ["TON_fnc_handleMessages",2];
 _to = "The Admins";
 hint format["You sent %1 a message: %2",_to,_msg];
 ctrlShow[888896,true];
 closeDialog 887890;
 };
 //emsrequest    
 case 4:    { if(({side _x == independent} count playableUnits) == 0) exitWith {hint format["Currently there is no EMS on duty . Please try again later."];
};
 ctrlShow[888899,false];
 if(_msg == "") exitWith {hint "You must enter a message to be sent!";
 ctrlShow[888899,true];
};
[ObjNull,_msg,player,3] remoteExec ["TON_fnc_handleMessages",2];
 hint format["You have sent a message to all EMS units.",_msg];
 ctrlShow[888899,true];
 closeDialog 887890;
 };
 //adminToPerson    
 case 5:    { if((call life_adminlevel) < 1) exitWith {hint "You are not an admin!";
};

 if(isNULL life_smartphoneTarget) exitWith {hint format["No person selected!"];
 };
 if(_msg == "") exitWith {hint "You must enter a message to be sent!";
 };
[life_smartphoneTarget,_msg,player,4] remoteExec ["TON_fnc_handleMessages",2];
 hint format["Administrator Message sent: %1 - Message: %2",name life_smartphoneTarget,_msg];
 closeDialog 88883;
 };
 //emergencyloading    
 case 6:    { if((FETCH_CONST(life_adminlevel) < 1)) then {
 ctrlShow[888898,false];
 ctrlShow[888896,true];
 } else { 
 ctrlShow[888898,true];
 ctrlShow[888896,false];
 };
 };
 //adminMsgAll    
 case 7:    { if((FETCH_CONST(life_adminlevel) < 1)) exitWith {hint "You are not an admin!";
};
 if(_msg == "") exitWith {hint "You must enter a message to be sent!";
 };
[ObjNull,_msg,player,5] remoteExec ["TON_fnc_handleMessages",2];
 hint format["A message sent to all admins: %1",_msg];
 closeDialog 887890;
 };
 
 //adacrequest    
 case 8:    { if(({side _x == east} count playableUnits) == 0) exitWith {hint format["Currently there is no ADAC on duty . Please try again later."];
};
 ctrlShow[3023,false];
 if(_msg == "") exitWith {hint "You must enter a message to be sent!";
 ctrlShow[3023,true];
};

[ObjNull,_msg,player,3] remoteExec ["TON_fnc_handleMessages",2];
 hint format["You have sent a message to all ADAC units.",_msg];
 ctrlShow[3023,true];
 closeDialog 3023;
};

 
};

private["_msg","_to","_target","_player","_type"];
_target = [_this,0,ObjNull,[ObjNull]] call BIS_fnc_param;
_msg = [_this,1,"",[""]] call BIS_fnc_param;
_player = [_this,2,ObjNull,[ObjNull]] call BIS_fnc_param;
_type = [_this,3,-1] call BIS_fnc_param;
switch(_type) do{    //normal message    
case 0:    { if(isNULL _target) exitWith {};
 _to = call compile format["%1", _target];
[_msg,name _player,0] remoteExec ["TON_fnc_clientMessage",_to];
 private["_query","_pid","_toID"];
 _pid = getPlayerUID _player;
 _toID = getPlayerUID _target;
 _msg = [_msg] call DB_fnc_mresString;
 _fromName = name _player;
 _toName = name _target;
 _query = format["INSERT INTO messages (fromID, toID, message, fromName, toName) VALUES('%1', '%2', '""%3""', '%4', '%5')",_pid,_toID,_msg,_fromName,_toName];
 diag_log format["Query: %1",_query];
 waitUntil{!DB_Async_Active};
 [_query,1] call DB_fnc_asyncCall;
 };
 //message to cops    
 case 1:    { 
[_msg,name _player,1] remoteExec ["TON_fnc_clientMessage",west];
 };
 //to admins    
 case 2:    { 
[_msg,name _player,2] remoteExec ["TON_fnc_clientMessage",0];
 };
 //ems request    
 case 3:    { 
[_msg,name _player,5] remoteExec ["TON_fnc_clientMessage",independent];
 };
 //adminToPerson    
 case 4:    { _to = call compile format["%1", _target];
 if(isNull _to) exitWith {};
[_msg,name _player,3] remoteExec ["TON_fnc_clientMessage",_to];
 };
 //adminMsgAll    
 case 5:    {[_msg,name _player,4] remoteExec ["TON_fnc_clientMessage",0];
 };
  case 8:    { 
[_msg,name _player,5] remoteExec ["TON_fnc_clientMessage",east];
 };
 
};