Und du hast weiterhin in der init.sqf 9:ADD_DATABASE_PROTOCOL:%2:SQL:%1:TEXT stehen?
Damit bekomme ich bei der AsyncCall so etwas raus:
[1,[[""76561198103896198"",""Olaf Starkmann"",3947801,65795,5,1,""""[[`license_civ_pass`,1],...
Normalerweise sollte es eher so aussehen:
[1,[["76561198103896198","Olaf Starkmann",3947801,65795,5,1,"[[`license_civ_pass`,1],...
Ne ich habe Text2 drinne
Bei mir gehts jetzt auch.
Falls jemand die realtime.fsm von @Lucian benutzt, die müsst ihr Sie damit ersetzen:
/*%FSM<COMPILE "E:\Program Files (x86)\SteamExtern\steamapps\common\Arma 3 Tools\FSMEditor\scriptedFSM.cfg, Lucian-De100-RealTime">*/
/*%FSM<HEAD>*/
/*
item0[] = {"Main_Init",0,4346,-40.348839,-141.279068,49.651161,-91.279068,0.000000,"Main Init"};
item1[] = {"true",8,218,-39.994308,-65.712906,50.005692,-15.712896,0.000000,"true"};
item2[] = {"Make_it_PUBLIC",2,250,-39.994308,10.874098,50.005707,60.874100,0.000000,"Make it PUBLIC"};
item3[] = {"",7,210,-233.614594,295.445374,-225.614578,303.445374,0.000000,""};
item4[] = {"",7,210,-233.935593,31.234837,-225.935593,39.234840,0.000000,""};
item5[] = {"Wait_1_Minute",4,218,-38.539185,92.835747,51.460873,142.835785,0.000000,"Wait 1 Minute"};
item6[] = {"Update_Time_",2,250,-36.888039,178.612518,53.111916,228.612396,0.000000,"Update Time" \n ""};
item7[] = {"true",8,218,-36.716774,275.104858,53.283058,325.104889,0.000000,"true"};
link0[] = {0,1};
link1[] = {1,2};
link2[] = {2,5};
link3[] = {3,4};
link4[] = {4,2};
link5[] = {5,6};
link6[] = {6,7};
link7[] = {7,3};
globals[] = {0.000000,0,0,0,0,640,480,1,26,6316128,1,-364.209686,266.074158,354.949310,-231.546356,950,884,1};
window[] = {2,-1,-1,-1,-1,870,52,1492,52,3,968};
*//*%FSM</HEAD>*/
class FSM
{
fsmName = "Lucian-De100-RealTime";
class States
{
/*%FSM<STATE "Main_Init">*/
class Main_Init
{
name = "Main_Init";
itemno = 0;
init = /*%FSM<STATEINIT""">*/"private[""_lastcheck"",""_hr"",""_mnt"",""_smarty"",""_day"",""_mnth""];" \n
"_lastcheck = time;" \n
"_smarty = ""extDB3"" callExtension ""9:LOCAL_TIME"";" \n
"life_real_time = call compile (_smarty) select 1;" \n
"_day = if (life_real_time select 2 < 10) then {format [""0%1"",life_real_time select 2]} else {life_real_time select 2};" \n
"_mnth = life_real_time select 1;" \n
"life_real_date = parseNumber (format[""%1%2"",_mnth,_day]);" \n
"publicVariable ""life_real_date"";" \n
"_hr = (life_real_time select 3);" \n
"_mnt = life_real_time select 4;" \n
"if (_hr isEqualto 24) then {_hr = 00};" \n
"life_real_time set [3,_hr];"/*%FSM</STATEINIT""">*/;
precondition = /*%FSM<STATEPRECONDITION""">*/""/*%FSM</STATEPRECONDITION""">*/;
class Links
{
/*%FSM<LINK "true">*/
class true
{
itemno = 1;
priority = 0.000000;
to="Make_it_PUBLIC";
precondition = /*%FSM<CONDPRECONDITION""">*/""/*%FSM</CONDPRECONDITION""">*/;
condition=/*%FSM<CONDITION""">*/"true"/*%FSM</CONDITION""">*/;
action=/*%FSM<ACTION""">*/""/*%FSM</ACTION""">*/;
};
/*%FSM</LINK>*/
};
};
/*%FSM</STATE>*/
/*%FSM<STATE "Make_it_PUBLIC">*/
class Make_it_PUBLIC
{
name = "Make_it_PUBLIC";
itemno = 2;
init = /*%FSM<STATEINIT""">*/"publicVariable ""life_real_time"";"/*%FSM</STATEINIT""">*/;
precondition = /*%FSM<STATEPRECONDITION""">*/""/*%FSM</STATEPRECONDITION""">*/;
class Links
{
/*%FSM<LINK "Wait_1_Minute">*/
class Wait_1_Minute
{
itemno = 5;
priority = 0.000000;
to="Update_Time_";
precondition = /*%FSM<CONDPRECONDITION""">*/""/*%FSM</CONDPRECONDITION""">*/;
condition=/*%FSM<CONDITION""">*/"(time - _lastcheck) >= (60)"/*%FSM</CONDITION""">*/;
action=/*%FSM<ACTION""">*/""/*%FSM</ACTION""">*/;
};
/*%FSM</LINK>*/
};
};
/*%FSM</STATE>*/
/*%FSM<STATE "Update_Time_">*/
class Update_Time_
{
name = "Update_Time_";
itemno = 6;
init = /*%FSM<STATEINIT""">*/"_lastcheck = time;" \n
"_mnt = _mnt + 1;" \n
"if (_mnt >= 60 || _mnt isEqualto 30 || _mnt isEqualto 45 || _mnt isEqualto 15) then {" \n
" _smarty = ""extDB3"" callExtension ""9:LOCAL_TIME"";" \n
" life_real_time = call compile (_smarty) select 1;" \n
" _hr = (life_real_time select 3);" \n
" if (_hr isEqualto 24) then {_hr = 00};" \n
" _mnt = life_real_time select 4;" \n
"};" \n
"life_real_time set [3,_hr];" \n
"life_real_time set [4,_mnt];"/*%FSM</STATEINIT""">*/;
precondition = /*%FSM<STATEPRECONDITION""">*/""/*%FSM</STATEPRECONDITION""">*/;
class Links
{
/*%FSM<LINK "true">*/
class true
{
itemno = 7;
priority = 0.000000;
to="Make_it_PUBLIC";
precondition = /*%FSM<CONDPRECONDITION""">*/""/*%FSM</CONDPRECONDITION""">*/;
condition=/*%FSM<CONDITION""">*/"true"/*%FSM</CONDITION""">*/;
action=/*%FSM<ACTION""">*/""/*%FSM</ACTION""">*/;
};
/*%FSM</LINK>*/
};
};
/*%FSM</STATE>*/
};
initState="Main_Init";
finalStates[] =
{
};
};
/*%FSM</COMPILE>*/Angepasst werden musste hier folgendes:
"_smarty = ""extDB2"" callExtension ""9:TIME:1"";" \n
wird zu
"_smarty = ""extDB3"" callExtension ""9:LOCAL_TIME"";" \n
Das gleiche nochmal in Zeile 93Wenn dabei die falsche Zeit ausgegeben wird könnt ihr folgendes versuchen:
"_smarty = ""extDB2"" callExtension ""9:TIME:1"";" \n
wird zu
"_smarty = ""extDB3"" callExtension ""9:UTC_TIME:1"";" \n
Das gleiche nochmal in Zeile 939:UTC_TIME:1 bewirkt hierbei, dass nicht die LOCAL_TIME, also die von der DB, sondern die UTC-Zeit.
Da Deutschland eine Stund vor der UTC-Zeit liegt muss :1 hinter 9:UTC_TIME.
Sonst würde die Uhrzeit Ingame eine Stunde nach gehen.
Dachte erst ich hätte die auch drinne aber benutze mittlerweile die real_date.dll
Stimmt, ein gewisser CooliMC hat ja euer Datenbank-Logging System entwickelt
Das macht viele Datenbank-Einträge
Dies ist eine Lüge wir haben im Januar 2016 eine komplett neue Mission angefangen !
Des weitern Loggen wir jede Action des Spielers über den HC.
CoolieMC hat damals bei TexasLife nur Käufe und Verkäufe und geld abheben und einzahlen loggen lassen
Sry, wenn ich jetzt nochmal ganz doof ranfrag... Es ist also definitiv so, das für die 64bit Version exdb3 Pflicht ist oder?
Ohje und ich dachte mir bleibt der ganze Spaß endlich mal erspart...was ich gekotzt habe von extDB1 auf extDB2...und jetzt wieder auf extDB3
Wenn du bereits extDB2 hat ist dies eig kein so großes Problem.
Du musst halt jenachdem noch die ein oder andere Änderung in der Mission vornehmen. Also abgesehen von dem was @crackhead geschrieben hat. Das siehst du aber beim testen relativ schnell. (Je nach Mission unterschiedlich)
Guten Morgen,
Ich wollte mal nachfragen ob ich die ExtDB3 auch bei Der Life Version 4.4 nehmen kann und die dann zu eienr 64bit anwendung machen kann.
extDB3 ist schon für 64bit entwickelt...
Okay danke gibt es die auch schon im github für Windows anwender
schau doch mal in den ersten Post? Lesen hilft...
Und ich habe nachgeschaut die 4.4 kannst du mit dem Tut sofort lauffähig machen
Aber auch nur, wenns die Standart 4.4 ist.
Wir mussten zb. auch noch einiges ändern, und wir verwenden die 4.4
Soll das eigentlich so sein das im Tutorial steht auf Text ändern anstatt Text2
Soll das eigentlich so sein das im Tutorial steht auf Text ändern anstatt Text2
Ja
// DATABASE INIT
if(isNil {uiNamespace getVariable "life_sql_id"}) then {
life_sql_id = round(random(999999));
__CONST__(life_sql_id,life_sql_id);
uiNamespace setVariable ["life_sql_id",life_sql_id];
_version = "extDB2" callExtension "9:VERSION";
if(_version isEqualTo "") exitWith {diag_log text "EXTDB ERROR:: DLL FILE NOT FOUND ! CHECK THE INSTALLATION !"};
if((parseNumber _version) < 64) exitWith {diag_log text format["EXTDB ERROR:: ALTIS-LIFE NEED VERSION 64 OR HIGHER ! CURRENT VERSION: %1",_version]};
"extDB2" callExtension "9:ADD_DATABASE:LIFE";
"extDB2" callExtension format ["9:ADD_DATABASE_PROTOCOL:LIFE:SQL_RAW_v2:%1:ADD_QUOTES",(call life_sql_id)];
"extDB2" callExtension "9:LOCK";
_lockStatus = "extDB2" callExtension "9:LOCK_STATUS";
if(_lockStatus isEqualTo "[1]") then {
diag_log text "EXTDB:: LOCK SUCCESSFULL";
} else {
diag_log text "EXTDB:: LOCK FAILED";
};
} else {
life_sql_id = uiNamespace getVariable "life_sql_id";
__CONST__(life_sql_id,life_sql_id);
};my init.sqf help me please! how to change? version 3.1.4.8
Hat wer auch diesen Fehler mit extDB3?
Error in Expression <, ((_parts select 0) select _i)], _damage select _i];
};
};
if ((_vInfo select 1>
Error Position: <select _i];
};
};
if ((_vInfo select 1>
Error Generic error in Expression
File life_server\Functions\Systems\fn_spawnVehicle.sqf, line 167
#include "\life_server\script_macros.hpp"
/*
File: fn_spawnVehicle.sqf
Author: Bryan "Tonic" Boardwine
Description:
Sends the query request to the database, if an array is returned then it creates
the vehicle if it's not in use or dead.
*/
private ["_vid","_sp","_pid","_query","_sql","_vehicle","_nearVehicles","_name","_side","_tickTime","_dir","_servIndex","_damage","_wasIllegal","_location","_thread"];
_vid = [_this,0,-1,[0]] call BIS_fnc_param;
_pid = [_this,1,"",[""]] call BIS_fnc_param;
_sp = [_this,2,[],[[],""]] call BIS_fnc_param;
_unit = [_this,3,objNull,[objNull]] call BIS_fnc_param;
_price = [_this,4,0,[0]] call BIS_fnc_param;
_dir = [_this,5,0,[0]] call BIS_fnc_param;
_spawntext = _this select 6;
_unit_return = _unit;
_name = name _unit;
_side = side _unit;
_unit = owner _unit;
if (_vid isEqualTo -1 || _pid isEqualTo "") exitWith {};
if (_vid in serv_sv_use) exitWith {};
serv_sv_use pushBack _vid;
_servIndex = serv_sv_use find _vid;
_query = format ["SELECT id, side, classname, type, pid, alive, active, plate, color, inventory, gear, fuel, damage, blacklist FROM vehicles WHERE id='%1' AND pid='%2'",_vid,_pid];
_tickTime = diag_tickTime;
_queryResult = [_query,2] 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 {};
_vInfo = _queryResult;
if (isNil "_vInfo") exitWith {serv_sv_use deleteAt _servIndex;};
if (count _vInfo isEqualTo 0) exitWith {serv_sv_use deleteAt _servIndex;};
if ((_vInfo select 5) isEqualTo 0) exitWith {
serv_sv_use deleteAt _servIndex;
[1,"STR_Garage_SQLError_Destroyed",true,[_vInfo select 2]] remoteExecCall ["life_fnc_broadcast",_unit];
};
if ((_vInfo select 6) isEqualTo 1) exitWith {
serv_sv_use deleteAt _servIndex;
[1,"STR_Garage_SQLError_Active",true,[_vInfo select 2]] remoteExecCall ["life_fnc_broadcast",_unit];
};
if (!(_sp isEqualType "")) then {
_nearVehicles = nearestObjects[_sp,["Car","Air","Ship"],10];
} else {
_nearVehicles = [];
};
if (count _nearVehicles > 0) exitWith {
serv_sv_use deleteAt _servIndex;
[_price,_unit_return] remoteExecCall ["life_fnc_garageRefund",_unit];
[1,"STR_Garage_SpawnPointError",true] remoteExecCall ["life_fnc_broadcast",_unit];
};
_query = format ["UPDATE vehicles SET active='1', damage='""[]""' WHERE pid='%1' AND id='%2'",_pid,_vid];
_trunk = [(_vInfo select 9)] call DB_fnc_mresToArray;
_gear = [(_vInfo select 10)] call DB_fnc_mresToArray;
_damage = [(_vInfo select 12)] call DB_fnc_mresToArray;
_wasIllegal = (_vInfo select 13);
_wasIllegal = if (_wasIllegal isEqualTo 1) then { true } else { false };
[_query,1] call DB_fnc_asyncCall;
if (_sp isEqualType "") then {
_vehicle = createVehicle[(_vInfo select 2),[0,0,999],[],0,"NONE"];
waitUntil {!isNil "_vehicle" && {!isNull _vehicle}};
_vehicle allowDamage false;
_hs = nearestObjects[getMarkerPos _sp,["Land_Hospital_side2_F"],50] select 0;
_vehicle setPosATL (_hs modelToWorld [-0.4,-4,12.65]);
uiSleep 0.6;
} else {
_vehicle = createVehicle [(_vInfo select 2),_sp,[],0,"NONE"];
waitUntil {!isNil "_vehicle" && {!isNull _vehicle}};
_vehicle allowDamage false;
_vehicle setPos _sp;
_vehicle setVectorUp (surfaceNormal _sp);
_vehicle setDir _dir;
};
_vehicle allowDamage true;
//Send keys over the network.
[_vehicle] remoteExecCall ["life_fnc_addVehicle2Chain",_unit];
[_pid,_side,_vehicle,1] call TON_fnc_keyManagement;
_vehicle lock 2;
//Reskin the vehicle
[_vehicle,(_vInfo select 8)] remoteExecCall ["life_fnc_colorVehicle",_unit];
_vehicle setVariable ["vehicle_info_owners",[[_pid,_name]],true];
_vehicle setVariable ["dbInfo",[(_vInfo select 4),(_vInfo select 7)],true];
_vehicle disableTIEquipment true; //No Thermals.. They're cheap but addictive.
[_vehicle] call life_fnc_clearVehicleAmmo;
if (LIFE_SETTINGS(getNumber,"save_vehicle_virtualItems") isEqualTo 1) then {
_vehicle setVariable ["Trunk",_trunk,true];
if (_wasIllegal) then {
private _refPoint = if (_sp isEqualType "") then {getMarkerPos _sp;} else {_sp;};
private _distance = 100000;
private "_location";
{
private _tempLocation = nearestLocation [_refPoint, _x];
private _tempDistance = _refPoint distance _tempLocation;
if (_tempDistance < _distance) then {
_location = _tempLocation;
_distance = _tempDistance;
};
false
} count ["NameCityCapital", "NameCity", "NameVillage"];
_location = text _location;
[1,"STR_NOTF_BlackListedVehicle",true,[_location,_name]] remoteExecCall ["life_fnc_broadcast",west];
_query = format ["UPDATE vehicles SET blacklist='0' WHERE id='%1' AND pid='%2'",_vid,_pid];
_thread = [_query,1] call DB_fnc_asyncCall;
};
} else {
_vehicle setVariable ["Trunk",[[],0],true];
};
if (LIFE_SETTINGS(getNumber,"save_vehicle_fuel") isEqualTo 1) then {
_vehicle setFuel (_vInfo select 11);
}else{
_vehicle setFuel 1;
};
if (count _gear > 0 && (LIFE_SETTINGS(getNumber,"save_vehicle_inventory") isEqualTo 1)) then {
_items = _gear select 0;
_mags = _gear select 1;
_weapons = _gear select 2;
_backpacks = _gear select 3;
for "_i" from 0 to ((count (_items select 0)) - 1) do {
_vehicle addItemCargoGlobal [((_items select 0) select _i), ((_items select 1) select _i)];
};
for "_i" from 0 to ((count (_mags select 0)) - 1) do {
_vehicle addMagazineCargoGlobal [((_mags select 0) select _i), ((_mags select 1) select _i)];
};
for "_i" from 0 to ((count (_weapons select 0)) - 1) do {
_vehicle addWeaponCargoGlobal [((_weapons select 0) select _i), ((_weapons select 1) select _i)];
};
for "_i" from 0 to ((count (_backpacks select 0)) - 1) do {
_vehicle addBackpackCargoGlobal [((_backpacks select 0) select _i), ((_backpacks select 1) select _i)];
};
};
if (count _damage > 0 && (LIFE_SETTINGS(getNumber,"save_vehicle_damage") isEqualTo 1)) then {
_parts = getAllHitPointsDamage _vehicle;
for "_i" from 0 to ((count _damage) - 1) do {
_vehicle setHitPointDamage [format ["%1",((_parts select 0) select _i)],_damage select _i];
};
};
//Sets of animations
if ((_vInfo select 1) isEqualTo "civ" && (_vInfo select 2) isEqualTo "B_Heli_Light_01_F" && !((_vInfo select 8) isEqualTo 13)) then {
[_vehicle,"civ_littlebird",true] remoteExecCall ["life_fnc_vehicleAnimate",_unit];
};
if ((_vInfo select 1) isEqualTo "cop" && ((_vInfo select 2)) in ["C_Offroad_01_F","B_MRAP_01_F","C_SUV_01_F","C_Hatchback_01_sport_F","B_Heli_Light_01_F","B_Heli_Transport_01_F"]) then {
[_vehicle,"cop_offroad",true] remoteExecCall ["life_fnc_vehicleAnimate",_unit];
};
if ((_vInfo select 1) isEqualTo "med" && (_vInfo select 2) isEqualTo "C_Offroad_01_F") then {
[_vehicle,"med_offroad",true] remoteExecCall ["life_fnc_vehicleAnimate",_unit];
};
[1,_spawntext] remoteExecCall ["life_fnc_broadcast",_unit];
serv_sv_use deleteAt _servIndex;
[_vid, _vehicle, 3] spawn mav_tuning_fnc_getTuningFromDB;Sehe da keinen Fehler 
