Beiträge von SlimRF

SlimRF

Code

erver: Object 95:44 not found (message Type_93)
Server: Object info 2:3043 not found.
Can't change owner from 0 to 2
Server: Object 64:21 not found (message Type_121)
Server: Object 2:2180 not found (message Type_93)
Server: Object 2:2179 not found (message Type_93)
Server: Object info 2:3043 not found.
Can't change owner from 0 to 2
Server: Object info 2:3043 not found.
Can't change owner from 0 to 2
Error: Object(122 : 72) not found
Server: Object info 2:3043 not found.
Can't change owner from 0 to 2
Server: Object info 2:2400 not found.
Can't change owner from 0 to 2
Server: Object info 2:2401 not found.
Can't change owner from 0 to 2
Server: Object info 2:2402 not found.
Can't change owner from 0 to 2
Server: Object info 2:2403 not found.
Can't change owner from 0 to 2
Server: Object info 2:2404 not found.
Can't change owner from 0 to 2
Server: Object info 2:2405 not found.
Can't change owner from 0 to 2
Server: Object info 2:2406 not found.
Can't change owner from 0 to 2
Server: Object info 2:2408 not found.
Can't change owner from 0 to 2
Server: Object info 2:2409 not found.
Can't change owner from 0 to 2
Server: Object info 2:2410 not found.
Can't change owner from 0 to 2
Server: Object info 2:2411 not found.
Can't change owner from 0 to 2
Server: Object info 2:2412 not found.
Can't change owner from 0 to 2
Server: Object info 2:2413 not found.
Can't change owner from 0 to 2

Alles anzeigen

many many errors

SlimRF

Code

[Main]
Version = 1

Randomize Config File = false
;; Randomizes Config File after loading.
;;   Recommend to turn on, if you have enabled filepatching on arma.

Allow Reset = false
;; Allows 9:RESET, usefull for development work

Thread = 0;
;; Option to force number of worker threads for extDB3.
;;   Auto = 0, Min = 2, Max = 6

[Log]
Flush = true;
;; Flush logfile after each update.
;;    Option really only usefull if running DEBUG BUILD


[ALTIS]
IP = 127.0.0.1
Port = 3306
Username = login
Password =  Password
Database = arma3life

Alles anzeigen

SlimRF

Zitat von Kuchenplatte

i think its a extdb problem

and what could be the problem? I put the latest version EXTDB

SlimRF

Server or client??

SlimRF

Over 90 players i have a problem! Standing request GUID. 5 -10 minutes auto delay from the garage! Where can I find the problem?

SlimRF

I'm trying to make a script. but I can not figure out how to make a condition. in file @life_server\addons\life_server\Functions\Systems\fn_vehicleStore.sqf
if there is a resource in the trunk then!

SlimRF

Zitat von Lukas B.

Hello,

what do you want to change?

i have extdb2 how to change extdb3

SlimRF

Help me please with altis life 3.1.4.8 and extdb3.
this my files

Spoiler anzeigen

Code

/*
	File: fn_asyncCall.sqf
	Modified: DeadP4xel




	Description:
	Calls an async request to extDB
*/
private["_queryStmt","_result","_key","_mode","_return","_loop"];




// CONVERT DATA
_queryStmt = 		[_this,0,"",[""]] call BIS_fnc_param;
_mode = 			[_this,1,1,[0]] call BIS_fnc_param;
_multiarr = 		[_this,2,false,[false]] call BIS_fnc_param;
_return = 			false;
_result = 			"";




// SEND EXTDB REQUEST AND COLLECT DATA
_key = "extDB2" callExtension format["%1:%2:%3",_mode,(call life_sql_id),_queryStmt];
if(_mode isEqualTo 1) exitWith {true};
_key = call compile format ["%1",_key];
_key = _key select 1;




// DATA COLLECTED NOW SEND MULTI / SOLO DATA
_loop = true;
while{_loop} do {
	_result = "extDB2" callExtension format ["4:%1",_key];
	if(_result isEqualTo "[5]") then {
		_result = "";
		while {true} do {
			_pipe = "extDB2" callExtension format ["5:%1",_key];
			if(_pipe isEqualTo "") exitWith {_loop = false};
			_result = _result + _pipe;
		};
	} else {
		if(_result isEqualTo "[3]") then {
			uiSleep 0.1;
		} else {
			_loop = false;
		};
	};
};




// DATA CONVERTED FROM QUERY REQUEST
_result = call compile _result;
if(count (_result select 1) isEqualTo 0) exitWith {[]};
_return = _result select 1;
if(!_multiarr && (count _return) > 0) then {
	_return = _return select 0;
};




_return;

Alles anzeigen

Code

#define __CONST__(var1,var2) var1 = compileFinal (if(typeName var2 == "STRING") then {var2} else {str(var2)})
DB_Async_Active = false;
DB_Async_ExtraLock = false;
life_server_isReady = false;
publicVariable "life_server_isReady";
[] execVM "\life_server\functions.sqf";
[] execVM "\life_server\eventhandlers.sqf";
//I am aiming to confuse people including myself, ignore the ui checks it's because I test locally.
// 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);
};
//Run procedures for SQL cleanup on mission start.
["CALL resetLifeVehicles",1] spawn DB_fnc_asyncCall;
["CALL deleteDeadVehicles",1] spawn DB_fnc_asyncCall;
["CALL deleteOldHouses",1] spawn DB_fnc_asyncCall;
["CALL deleteOldGangs",1] spawn DB_fnc_asyncCall; //Maybe delete old gangs
["CALL resetLife",1] spawn DB_fnc_asyncCall; //Maybe delete old gangs
["CALL deleteOldMessages",1] call DB_fnc_asyncCall;
life_adminlevel = 0;
life_medicLevel = 0;
life_coplevel = 0;
life_civlevel = 0;
life_adaclevel = 0;
//Null out harmful things for the server.
__CONST__(JxMxE_PublishVehicle,"No");
//[] execVM "\life_server\fn_initHC.sqf";
life_radio_west = radioChannelCreate [[0, 0.95, 1, 0.8], "Side Channel", "%UNIT_NAME", []];
life_radio_civ = radioChannelCreate [[0, 0.95, 1, 0.8], "Side Channel", "%UNIT_NAME", []];
life_radio_indep = radioChannelCreate [[0, 0.95, 1, 0.8], "Side Channel", "%UNIT_NAME", []];
life_radio_east = radioChannelCreate [[0, 0.95, 1, 0.8], "Side Channel", "%UNIT_NAME", []];
serv_sv_use = [];
fed_bank setVariable["safe",(count playableUnits),true];
server_warzones = [];
//General cleanup for clients disconnecting.
addMissionEventHandler ["HandleDisconnect",{_this call TON_fnc_clientDisconnect; false;}]; //Do not second guess this, this can be stacked this way.
[] spawn TON_fnc_cleanup;
life_gang_list = [];
publicVariable "life_gang_list";
life_wanted_list = [];
client_session_list = [];
[] execFSM "\life_server\cleanup.fsm";
[] spawn
{
	private["_logic","_queue"];
	while {true} do
	{
		sleep (30 * 60);
		_logic = missionnamespace getvariable ["bis_functions_mainscope",objnull];
		_queue = _logic getvariable "BIS_fnc_MP_queue";
		_logic setVariable["BIS_fnc_MP_queue",[],TRUE];
	};
};
[] spawn TON_fnc_federalUpdate;
[] spawn
{
	while {true} do
	{
		sleep (30 * 60);
		{
			_x setVariable["sellers",[],true];
		} foreach [Dealer_1,Dealer_2,Dealer_3];
	};
};
//Strip NPC's of weapons
{
	if(!isPlayer _x) then {
		_npc = _x;
		{
			if(_x != "") then {
				_npc removeWeapon _x;
			};
		} foreach [primaryWeapon _npc,secondaryWeapon _npc,handgunWeapon _npc];
	};
} foreach allUnits;
[] spawn TON_fnc_initHouses;
//Lockup the dome
private["_dome","_rsb"];
_dome = nearestObject [[16019.5,16952.9,0],"Land_Dome_Big_F"];
_rsb = nearestObject [[16019.5,16952.9,0],"Land_Research_house_V1_F"];
for "_i" from 1 to 3 do {_dome setVariable[format["bis_disabled_Door_%1",_i],1,true]; _dome animate [format["Door_%1_rot",_i],0];};
_rsb setVariable["bis_disabled_Door_1",1,true];
_rsb allowDamage false;
_dome allowDamage false;
life_server_isReady = true;
publicVariable "life_server_isReady";
[] execVM "\life_server\Functions\DynMarket\fn_config.sqf";
life_attachment_point = "Land_HelipadEmpty_F" createVehicle [0,0,0];
life_attachment_point setPosASL [0,0,0];
life_attachment_point setVectorDirAndUp [[0,1,0], [0,0,1]];
publicVariable "life_attachment_point";
/* Initialize hunting zone(s) */
["hunting_zone",30] spawn TON_fnc_huntingZone;

Alles anzeigen

how to change? help plsease. I do not want to lose my server

SlimRF

Code

// 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);
};

Alles anzeigen

my init.sqf help me please! how to change? version 3.1.4.8

SlimRF

Zitat von Don

Is script is written by OPTiX but I think its not for sale anymore. But you can try to contact him.
Maverick Applications
[email protected]

Thanks hail

SlimRF

Zitat von Don

He doesn't want to remove and place boxes. He's looking for a system which is replacing the boxes and add their storage to the house menu like the Z or T Trunk.
E.g.

Where can I download or purchase this script?

SlimRF

hello everyone!) I have a question! I need a script replace boxes in homes! open inventory on home menu. if not can someone write for pay?

SlimRF

Zitat von Stig
Simple Serverside Ban:
Code
/*
File: fn_simpleban




Description: Ban a player because of Stig




Parameter:
1 - unit to ban




Examples:
Client: _playerToBan remoteExecCall ["STIG_fnc_simpleban",2,false]
Server: _playerToBan call STIG_fnc_simpleban
*/




if((!isPlayer _this) or !isServer)exitWith{};
SERVERCOMMANDPASSWORDinSERVERCFG serverCommand (format ["exec ban %1%2%1","'", getPlayerUID _this]);
Alles anzeigen
Not tested.
DONT put it into your mission, use life_server or a new mod because other people should not see SERVERCOMMANDPASSWORDinSERVERCFG.

Have fun

client: [getPlayerUID player,60," ban / 1 hour"] remoteExecCall ["TON_fnc_simpleban",2,false"];

but i do not understand how create server file

SlimRF

Zitat von Rom

do you call the function serverside? life_server\init.sqf or clientside mission.map\init.sqf?

serverside ( life_server/init.sqf)

SlimRF

Code

/*
 Passed argement is _time1
 You can call this serverside script with:
 [300] remoteExec ["tag_fnc_functionname",2];
 Change your tag_fnc_functionname
*/
private ["_time2","_query","_queryResult"];
params [["_time1",-1,[0]]]; // passed argement, default is -1, expect 0=number
if (_time1 isEqualTo -1) exitWith {diag_log "No argument found";};
_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;
_time1 = _queryResult select 0;
if ((_time1 - 1) < 0) exitWith {}; // cancel script execution, because negative number
_time2 = _time1 - 1;
_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1]; // Replace existing data with current _time1 with the new one (_time2), not all
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

does not work(((

SlimRF

All players are different values. I need to subtract "1 " each player in p_time column. Even if the player is not on the server. Every 15 minutes.

SlimRF

Zitat von Rom

How do you call your function/script?

[arguments] call/spawn/remoteExec/remoteExecCall tag_fnc_functionname

Code

/*
	Passed argement is _time1
	You can call this serverside script with:
		[300] remoteExec ["tag_fnc_functionname",2];
		Change your tag_fnc_functionname
*/
private ["_time2","_query","_queryResult"];
params [["_time1",-1,[0]]]; // passed argement, default is -1, expect 0=number
if (_time1 isEqualTo -1) exitWith {diag_log "No argument found";};
_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;
_time1 = _queryResult select 0;
if ((_time1 - 1) < 0) exitWith {}; // cancel script execution, because negative number
_time2 = _time1 - 1;
_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1]; // Replace existing data with current _time1 with the new one (_time2), not all
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

this is one possibility

call my function in int.sqf

Code

[] spawn{
	while {true} do {
		sleep (1 * 60);
		[] call TON_fnc_updatedtime;
	};
};

SlimRF

Zitat von Rom

You have to use the WHERE Statement in Update:
_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1];

And you have to define _time1 first and select _time2 from your _queryresult

#mobile

Code

private ["_time1","_time2","_query","_queryResult"];




_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;
_time1 = _queryResult;




if(_time1 > 0) then
{
 _time2 = _time1 - 1;
};




_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1];
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

like this?
Sorry please! I'm not good at this yet. Help me to fix everything

SlimRF

this my code.

Code

private ["_time1","_time2","_query"];







_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;







if(_time1 > 0) then
{
 _time2 = _time1 - 1;
};




_query = format["UPDATE players SET p_time='%1'",_time2];
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

I'm trying to make query.

Example : 1. script read p_time column from all players.
2. script subtract "1"
3. script write in p_time new value
(300-1=299)
p_time FOR all players.

But my code write "0" to all players

What i do wrong? Help me please.

altis life 3.1.4.8 extdb2

SlimRF

Zitat von xHaraldx

you use a undefined variable in your query _time1

please help me. How to write this script

PS I need to subtract 1 from all users in the database

Example: read 300 after -1 = 299 write 299 in DB

Beiträge von SlimRF

Over 90 players i have a problem

Over 90 players i have a problem

Over 90 players i have a problem

Over 90 players i have a problem

Over 90 players i have a problem

if resourse in trunk then

Life 3.1.4.8 and extdb3

Life 3.1.4.8 and extdb3

Von ExtDB 2 auf 3 [64bit] RAW SQL

House System

House System

House System

How to create autoban?

Help with query database

Help with query database

Help with query database

Help with query database

Help with query database

Help with query database

Run the script every 15 minutes