Hallo.
Ich schreibe momentan das Fahndungslisten-System um.
Ich habe nun eine neue DB erstellt und mich an dem Code von fn_getVehicles (life_server) orientiert.
fn_getVehicles
Code
_query = format["SELECT id, side, classname, type, pid, alive, active, plate, color FROM vehicles WHERE pid='%1' AND alive='1' AND active='0' AND side='%2' AND type='%3'",_pid,_side,_type];
_tickTime = diag_tickTime;
_queryResult = [_query,2,true] call DB_fnc_asyncCall;
if (EXTDB_SETTING(getNumber,"DebugMode") isEqualTo 1) then {
diag_log "------------- Client Query Request -------------";
diag_log format["QUERY: %1",_query];
diag_log format["Time to complete: %1 (in seconds)",(diag_tickTime - _tickTime)];
diag_log format["Result: %1",_queryResult];
diag_log "------------------------------------------------";
};
if (_queryResult isEqualType "") exitWith {
[[]] remoteExec ["life_fnc_impoundMenu",(owner _unit)];
};
[_queryResult,_type] remoteExec ["life_fnc_impoundMenu",_unit];
Alles anzeigen
So nun habe ich das ganze übertragen auf das Fahndungssystem
Code: fn_wantedCrimes (life_server)
#include "\life_server\script_macros.hpp"
/*
File: fn_wantedCrimes.sqf
Author: ColinM
Assistance by: Paronity
Stress Tests by: Midgetgrimm
Description:
Grabs a list of crimes committed by a person.
*/
private["_display","_criminal","_tab","_queryResult","_result","_ret","_crimesDb","_crimesArr","_type"];
disableSerialization;
_ret = [_this,0,ObjNull,[ObjNull]] call BIS_fnc_param;
_criminal = [_this,1,[],[]] call BIS_fnc_param;
//_query = format["SELECT reason, price, insert_time FROM wantedlist WHERE active='1' AND playerid='%1' ORDER BY reason",_criminal select 0];
_query = format["SELECT reason, price, insert_time FROM wantedlist WHERE active='1' AND playerid='Meine PlayerID' ORDER BY reason"];
_queryResult = [_query,2,true] call DB_fnc_asyncCall;
_ret = owner _ret;
[_queryResult] remoteExec ["life_fnc_wantedInfo",_ret];
Alles anzeigen
Leider liefert mich das keine Data (in PHPMyAdmin schon...)
-> hint Ergebnis: []
Ich hoffe ihr könnt mir schnell helfen